Mobile Support

Cooladata now supports viewing the app on mobile devices. On your mobile device you can:

  • View a report
  • View a dashboard
  • Browser the Reports and Dashboards lists

Cooladata’s mobile supports comes to help you access you data quicker and at any time, and is specifically designed to work with report links from a Publications and Alerts.

Note that most features are not accessible from a mobile device, as it is intended for viewing only.
As with the desktop version, Cooladata works best on a Chrome browser.

Contact us at support@cooladata.com for questions or requests regarding mobile support.

Examples – ReportDashboard, and Dashboards list:

 

Print Friendly, PDF & Email

Drillthrough Reports

Drillthrough Reports enable you to drill through (zoom in) to a section of a report by clicking it, and opening another preconfigured report, filtered to that category’s data.

For example, define a report broken down by days, and another report broken down by hours. By linking the first to the latter, you can click any date in the first report chart to zoom in to that day’s hourly breakdown. The same would work for any breakdown, not just by time, considering the linked report supports filtering by the selected property (see more below).

Notes:

  • Can link from the following visualizations: Table, Line, Area, Bar, Column, Combo, Pie, Geo.
  • Cannot use linked report in Embedded Reports

 

Define Drillthrough Reports

  1. In the report editing page, from Report Options  choose Drillthrough Reports:
  2. In the opened window, choose up to 5 reports (from the same project) that will be linked to from this report. An indication will be added to the report page that Drillthrough Reports are in use – “Drillthrough” label next to report options.
  3. Make sure the linked reports you choose support filtering by the X axis dimension, i.e. include this property in the data.
    For example, if you link a report running over Cooladata to a report running on an Aggregation Table, the Aggregation Table must include the property used as the first report’s X axis.

 

Drillthrough from Chart

Once a drillthrough has been defined, click any point in the chart to select the x axis value the linked report will be filtered by.

  1. Hover over a point in the chart. You will see an indication in the tooltip: “Click to drill through“.
  2. Click the point to choose from a list of linked reports.
  3. Once a report has been selected it will be displayed instead of the current report (i.e. in the same preview area).
    The new report will be filtered by the data point you clicked.
    For example, if you chose to drill through on a specific date, say January 1st, 2017, the new report will only show data for January 1st, 2017.
  4. The report header will show a Back icon to return to the last report shown.

 

Print Friendly, PDF & Email

Filters

Filters enable you to filter (slice) the data displayed in reports without changing the original report or query.

Filters can be used in many sections of the platform:

  • Report: each report has a built in filter function, that runs on the entire report query. Some reports also include internal filters on specific sections, such as KPI measures and Funnel steps. Additionally, each report can be set to Ignore External Filters, i.e. Sheet or Dashboard filters.
  • Sheet: enables you to select a specific group of reports in a specific dashboard sheet to be filtered. This option displays a filter in the dashboard that lets users easily change the value of each condition. It can also enable dashboard viewers to change filter values.
  • Dashboard: allows you to filter all the reports, in all the sheets in the dashboard. Viewer users (guests) do not see dashboard filter indicators. This allows you to filter the dashboard to only show customer specific data, without displaying these conditions to customers viewing the dashboard. Cooladata Users/Admins can set their own filters for the dashboard. They will get the same filters as yours when you first share the dashboard with them, but if you later change your dashboard filters, theirs will remain the same.

 

Report

  1. Click the Filter 3-12 button at the top of the report. The following opens:
    3-13
  2. Fill in the conditions of this filter:
    1. Property: Select an event property from the Where dropdown field on the left.
    2. Operator: Select an operator to act upon the selected property.
    3. Value: Type in or select one or more values.
    4. Case sensitivity: “Contains” and “Doesn’t contain” conditions can also be set as case sensitive/insensitive. Click the Aa icon next to the condition to switch between the two modes.
      3-14
  3. To add an additional filter, click the + button on the right. Specify whether there is an AND relationship (all filters define a match) or an OR relationship (any filter defines a match).
  4. Click the Apply button. The counter on the filter icon indicates how many filters are applied. A filter icon also appears in the report preview, specifying the conditions that apply to it.

To set a report to ignore external filters:

  1. In the report page, click the Options button at the top right and choose Report Settings.
  2. Turn the options to Ignore External Filters on or off. When On, only filters defined in the report itself will be used. This applies to any use of the report, both in a dashboard and Embedded report.

 

Sheet

  1. Click the Add Reports 3-16 button in the top right of the dashboard, and choose Filter. The following opens:
    3-18
  2. In the Affected reports field, select one or more reports in this dashboard sheet to which to apply this filter.
  3. Fill in the conditions of this filter:
    1. Property: Select an event property from the Where dropdown field on the left.
    2. Operator: Select an operator to act upon the selected property.
    3. Value: Type in or select one or more values.
    4. Case sensitivity: “Contains” and “Doesn’t contain” conditions can also be set as case sensitive/insensitive. Click the Aa icon next to the condition to switch between the two modes.
      3-14
  4. To add an additional filter, click the + button on the right. Specify whether there is an AND relationship (all filters define a match) or an OR relationship (any filter defines a match).
  5. To allow dashboard viewers (and project Viewer users) to select the filter values from the sheet itself, set the “Can be updated by dashboard viewers” toggle to On. Note that only dashboard editors will be able to change the selected properties and operators.
  6. Click the Apply button. A filter icon also appears in each report that is affected, specifying the conditions that apply to it.
  7. By default, the filter is added to the top left corner of the sheet. However, you can drag it anywhere in the sheet, as well as resize it.
    3-20
  8. To change the filter condition values click the filter fields and select a value. Click the Update button to apply the change and reload the effected reports. Note that changes to these values will be saved for 30 minutes, and then reset to what you defined the in the filter settings.
  9. Changes to this filter’s settings in your dashboard will effect all users sharing it, and will update the next time they open the dashboard.

 

Dashboard

  1. Click the Filter 3-12 button at the top of the dashboard. The following opens:
    3-13
  2. Fill in the conditions of this filter:
    1. Property: Select an event property from the Where dropdown field on the left.
    2. Operator: Select an operator to act upon the selected property.
    3. Value: Type in or select one or more values.
    4. Case sensitivity: “Contains” and “Doesn’t contain” conditions can also be set as case sensitive/insensitive. Click the Aa icon next to the condition to switch between the two modes.
      3-14
  3. To add an additional filter, click the + button on the right. Specify whether there is an AND relationship (all filters define a match) or an OR relationship (any filter defines a match).
  4. Click the Apply button. The counter on the filter icon indicates how many filters are applied. A filter icon also appears in each report that is affected, specifying the conditions that apply to it.

 

Example: Building a Parametric Dashboard

A parametric dashboard is comprised of multiple sheets, each containing the same reports. The data in each sheet is sliced according to the value of a specific event property.
For example, a parametric dashboard could show multiple sheets, each containing the same reports, where each sheet shows the data of a specific country.
The same thing could apply to a dashboard that has a sheet for each branch, department, game provider or customer.
You can add the same report(s) to a sheet multiple times, each with a different filter. Placing them side-by-side enables easy comparison.

To define a multi-sheet parametric dashboard:

  1. Create a new dashboard.
  2. Add all the reports that you would like to appear in the dashboard to the sheet.
  3. Add a filter to the sheet, with the condition your wish to show on this specific sheet. Note that reports for which the Ignore Dashboard Filters option is On are not affected by dashboard filters.
  4. Duplicate the sheet, and rename it to describe the data it will display.
  5. Edit the filter (edit-1 button in the top right of the window) to change each sheet’s conditions, and select the values to be displayed in this sheet. For example, to show different countries in each sheet, you can select ip_country is in list United States for one sheet (so that it only shows data from the United States) and ip_country is in list Canada for another sheet (so that it only shows data from Canada).
  6. Click Apply.
Print Friendly, PDF & Email

Embedded Reports

CoolaData enables you to embed your CoolaData reports in any web page framework, while enjoying the full benefit of CoolaData’s visualization options.

The embedded report will look like this:

Get Your CoolaData User API Token

To get your CoolaData API token click the Profile icon at the top right of the window and copy your API Token.

Get the Report ID

  1. Create/Open a Report in CoolaData. See Creating Reports.
  2. In the Report Editing window, copy the report ID which is the last part of its URL.
    5-6

 

Prepare the CoolaData Report Request

The following are the mandatory parts of a request for embedding a CoolaData report script in your site.

Use the retrieved User API Token as described in Step 2 in, and the retrieved Report ID, as described in Step 3.

Method: Post

Request URI: https://app.cooladata.com/1/embeddedReports

Content Type: application/json

Payload:

{ 
  "apiToken": "<apiToken>", 
  "reportId": "<reportId>"
}

The response to the request above is a single report token according to the parameters of the request. A token expires immediately after being used or within five minutes, if it is not used.

{
  "token": "<tokenId>"
}

 

More Options for the CoolaData payload request

Here are a few more options that you can include in your CoolaData report request in order to get back the visualization and data that you want.

Dashboard ID

Including a dashboard ID in the request returns the same view as is currently displayed in this dashboard of this user (the user is determined by the API token). This means that the report script represents the same date range and filters as in the dashboard.

To get the dashboard ID, open the dashboard and then copy the dashboard ID from the right of its URL:

https://app.cooladata.com/#/dashboards/56a63385e4b0e8504dbe8770

Note: If the report has an active date range or filter override, then the report’s date range and filters are used. Otherwise, the dashboard’s date range and filters are used, as set by the user of this API token.

Date Range

If the request does not include a specific date range, then the report’s date range is returned.

Adding a date range to the request takes precedence over the date range defined in the CoolaData console for this report and dashboard.

To specify a date range, use one of the following options:

  • Date Range Expression:
    "dateRange": {
      "mode": "TODAY | YESTERDAY | LAST_7_DAYS | LAST_30_DAYS | LAST_90_DAYS | CURRENT_WEEK | CURRENT_MONTH"
      }

– OR –

  • Custom Range: Epoch milliseconds – you can send any millisecond during the date. CoolaData converts it to the first second of the Start date and the last second of the End date.
    Start date (actualFrom): is converted to “YYYY-MM_DD 00:00:00”.
    End date (actualTo): is converted to “YYYY-MM-DD 23:59:59”.

    "dateRange": {
     "mode": "CUSTOM",
     "actualFrom": 1439275953685,
     "actualTo": 1439275953685
     }

 

Filters

If the request does not include a specific filter (as described below), then the report’s filters determine the data that is returned.

Adding filters to the request takes precedence over the filter defined in the CoolaData console for this report and dashboard. Multiple conditions can be entered in the slicer section of the request. All conditions can either be specified with an AND or an OR Boolean operator.

Specify the name of an event property, an operator and a value.

"slicer": {
  "bitwiseOperator": "AND",
  "conditions": [{
    "property": "property_name",
    "operator": "INTEGER_EQUALS | INTEGER_NOT_EQUALS | STRING_EQUALS | STRING_NOT_EQUALS | INTEGER_IN_LIST | INTEGER_NOT_IN_LIST | STRING_IN_LIST | STRING_NOT_IN_LIST | CONTAINS | NOT_CONTAINS | EXISTS | NOT_EXISTS | REGEX | AT_LEAST | NO_MORE_THAN | BETWEEN | TIME_BETWEEN | LATER_THAN | EARLIER_THAN",
    "values": ["value1", "value2"]
    }]
  }

To use segmentation in filters, add the following condition:

{
    "property": "COOLADATA_SEGMENT",
    "operator": "IS_IN_SEGMENT_TABLE | NOT_IN_SEGMENT_TABLE"
    "values": ["segment_name"]
}

You can use multiple segment conditions in the same query.

 

Fetch the CoolaData Report

Use the report token that you received (as described above) in the following API to fetch the report visualization (Method – GET). Then, embed it in any webpage framework.

https://app.cooladata.com/reports/<reportToken>

 

Example

Using all the above options.

Request the Report Token:

{
    "apiToken": "aRG1DbdzN0FC1z8Ii7VUjFwlQvaogiBm6LE6oxFs",
    "reportId": "55cca707e4b03f8a48f9299f",
    "documentId": "55bf81c2e4b0d15ad906453e",
    "dateRange": {
        "mode": "LAST_7_DAYS"
        },
    "slicer": {
        bitwiseOperator: "AND",
        "conditions": [{
            "property": "browser_name",
            "operator": "STRING_IN_LIST",
            "values": ["Chrome", "Android Browser"]
            }]
}

Response:

{
    "token": "55d2f2cee4b067eb33fe778"
}

Fetch the report:

https://app.cooladata.com/reports/55d2f2cee4b067eb33fe778

 

Print Friendly, PDF & Email