etracker
Analytics Editions / Pricing Live-Demo
etracker
Optimiser Editions / Pricing Live-Demo
Pricing For Agencies Support

Calling Report & Metadata

The queries of the etracker report REST API are structured as follows:

https://ws.etracker.com/api/v6/report/#ReportID#/#Service#

The available services are:

ServiceDescription
infoProvides general information and report metadata
metaDataProvides information on types and names of the columns of a specific report query
dataReturns the data of the corresponding report in JSON format
data.csvReturns the data of the corresponding report in CSV format

  • Calling the information and metadata of the report ‘Device’ is done with the following query: https://ws.etracker.com/api/rest/v3/report/CCWRDeviceType/info The return is a JSON array with one element and has the following structure:
    { "report": { "createDate": "2016-01-01 00:00:00", "dimensions": "1", "segments": "0", "visualizationType": "", },"attributes": [ { "id": "device_type", "label": "Ger\u00e4tetyp", "type": "attribute", "sortable": true }, ],"key-figures": [ { "id": "unique_visits", "label": "Visits", "type": "integer", "sortable": true }, ] "views": [ { "view_id": "24", "name": "Test Configuration", "tm": "1477324586", "access": "this_user", "is_default": false },}
    The return object contains four sub-elements:
    1. A report object with general information, like the date, where a report was generated.
    2. An attribute array with metadata on each attribute in the report.
    3. A key figures array with metadata on each key figure in the report.
    4. A views array with metadata on each of the views of the report defined by the users.
    The arrays for the attributes and key figures contain objects with the following data for each attribute and each key figure:
    1. The id for the communication with the REST API.
    2. A name legible for people (label). The language of the names depends on the account ID or sub-user ID used in the header and can be modified using the corresponding settings in the etracker application.
    3. The data type (type) of the values in the column.
    4. A Boolean value (‘true’ or ‘false’), which indicates if the report can be sorted by attribute or by key figure.
    The data types which can be found in etracker reports are described in the following table. The sample data is data as it is returned from the REST API.
    Data typeDescriptionExample
    attributeAttributes contain chains of characters"organic"
    attributeDateA date as character chain"2016-01-15"
    integerWhole number132
    floatFloating-point number2.316757394
    currencyFloating-point number with two decimal points50321.45
    percentPercentage rate: Floating-point number between 0 and 10034.501120345
    relPercentageRelative percentage rate: Floating-point number between 0 and 10.573944096
    staytimeDuration in seconds: The positions after the decimal point are fractions of seconds239.355444
    dateA date2016-01-15
    nullIDs and status information which are neither attributes nor key figures.
    Views can be defined and saved by each user for each report interactively in the etracker application. The views array contains the following data on each view defined by the users.
    1. The view_id for the communication with the REST API.
    2. The unique name provided by the users (name).
    3. Other metadata for the view (e.g. date of creation).
    Calling the data of the ‘Device’ report is done using the following query (a data query without parameters is possible, but not recommended): https://ws.etracker.com/api/rest/v3/report/CCWRDeviceType/data?limit=10 This query returns data in JSON format. For CSV data, ‘data.csv’ instead of ‘data’ at the end of the URI is all that is needed. For the return format, however, CSV and JSON queries are identical. For this reason, we will only describe the JSON case in this section. The return data have approximately the following format:
    [    [        "-,-,-,-,-,-,-,-,-,-",        "=S",        "",        "",        104377,        4.58239668    ],    [        "373563,1417345,1426710,1426574,1426574,1430935,1373563,1373563,0,3",        "=0",        "Desktop",        "no customer",        34201        2.3541867    ],    ...]
    The return is a JSON array of maximum 11 arrays as the parameter limit was set as equal to 10. Each array represents a data record or a line in the return table. The first array is always the ‘Total’ line, in which the key figures were aggregated across all attribute value combinations. The other arrays are attribute value combinations with the corresponding aggregated key figures. Since no sorting information was provided in the parameters, the order of the lines does not matter. Each line begins with a list of IDs of the attribute values which were used for the attribute value combination. Each attribute value has an ID which needs to be used if a specific attribute value is to be referenced via the REST API. The attribute value IDs for the same attribute values can vary from one etracker account to the next. Inside an account however they are always unique. The second element in each line is a designation: ‘=S’ for the line, ‘Total’ and ‘=0’ for all other lines. The attribute values of the attribute combination follow in the same order as in the report information and then the key figure data of the key figures also follows in the same order as in the report information. The above example is simply for introductory purposes and does not represent sensible use of the etracker REST API. To use the REST API in a sensible way, the desired data range and the order needs to be narrowed down using parameters.
    For each data query of a report, the corresponding query-specific metadata can be called. To see the metadata of the above query, ‘data’ just needs to be replaced with ‘metaData’. Here, the parameters should be kept intact. https://ws.etracker.com/api/rest/v3/report/CCWRDeviceType/metaData?limit=10 This query returns a JSON array with one entry per column in the respective data query. The first two entries have the IDs ‘id’ and ‘tree_status’ and the type ‘null’. They correspond to the first two columns described above, which are neither attributes nor key figures.
    [ { "id": "id", "label": zero, "type": zero, "sortable": true }, { "id": "tree_status", "label": zero, "type": zero, "sortable": true }, { "id": "device_type", "label": "Ger\u00e4tetyp", "type": "attribute", "sortable": false }, ...]
    The etracker reports can be understood as dynamic tables or as so-called data cubes. They consist of Attributes and Key Figures. In the literature, the terms Dimensions (for attributes) and Measurements (for key figures) are used. Attributes contain nominal or categorical values which are not numbers and show the characteristics of user interactions. Typical attribute values are names (e.g. ‘Homepage’ or ‘Womenswear’), categories (e.g. ‘customer’, ‘not customer’) or times (e.g. ‘2016-01-25’ or ‘9 AM’). Some attribute values have a natural order (e.g. the times), but most cannot be sorted sensibly or just alphabetically. If one value should be selected from three attributes, then we talk of an attribute value combination or characteristic. If, for example, the attributes ‘Page name’, ‘Country’ and ‘Operating System’ are given, then the values ‘Homepage’, ‘Germany’ and ‘Windows’ would be an attribute value combination and ‘Homepage’, ‘Austria’, ‘Windows’ would be another attribute value combination. Key figures contain numerical values which can be sorted and aggregated. Key figures are always returned from the REST API in aggregated form. The aggregation method depends on the key figure. The key figure ‘Bounce Rate’ is used for averaging. The key figure ‘Visitors’ however, is used for summing. Each query of a report via the REST API returns a table which returns a specific aggregated view. Each key figure is aggregated for each existing attribute value combination. Each line in the table then consists of one attribute value combination followed by the aggregated key figures which belong to it. Two lines of such a table could look like this:
    Attributes  Key data 
    Page nameCountryOperating systemVisitorsBounce-Rate
    HomepageGermanyWindows52330,45%
    HomepageAustriaWindows5735,09%
    The attribute value combination and key figures of the second line can be interpreted as follows: There were 57 visitors to the homepage from Austria using the Windows operating system and 35.09% of them viewed just one page.

Need help?
Our friendly, knowledgeable support engineers are here for you.