May 2017 Release Notes

Analysis and Data Visualization

Alerts: stay informed of important measures, changes and trends in your user’s activity by email notifications.
Alerts can be triggered by any query! For example, use the behavioral funnel to measure shopping cart drop-off, and send an alert when the user count is greater than the threshold you define.
Click “Check condition” to test the query and see whether the current data would trigger the alert.
Alert emails can contain custom text and reports (like in publications), and can be addressed to any email.
Alerts are available from the project menu, accessible by project admins.
Click “Run now” to compute the condition, and if triggered, send the alert email.

Report Tags: find reports quickly on the reports list by adding tags (especially useful for reports with the same name).
To add or edit the report’s tags:

  1. Edit or create a new report
  2. Click the “Tags” section – below the report date range and filters

Any text can be added as a tag – even emojis! 🙂
Previously used tags are available from the list of tags.
When duplicate a dashboard with reports, a tag will automatically be added to the duplicated reports, to help you distinguish them from the original ones.

Pivot chart drill down: expand multiple levels of breakdowns in a single chart using the pivot visualization.
When you configure a report with multiple breakdowns, for example, using KPI report, the pivot chart allows you to expand each category and isolate it, to see a more detailed view of that data.
Turn “Expand drills down in charts” off in the chart’s settings to disable this and enable to expand multiple categories instead.

Filter external tables: use filters on reports from external tables in the report page and dashboard, as you do for reports from Cooladata.
To filter table properties: in the filter window, either type in any table column name directly in the property field, or select the specific table from the top right dropdown to show only properties from that table in the properties list.
Both Aggregation Tables and Integration tables are available in the tables list, if used in the project.
All operators and functions apply to these properties, just like for Cooladata properties.

Linked Data Source aliases: specify the connection type in the query FROM clause.
When querying Linked Data Sources, either use the standard format – “external.dataBaseName.tableName”, or specific the exact connection type instead – “mysql.dataBaseName.tableName”. Available connection types are:

  • mysql
  • mssql
  • bigquery
  • redshift
  • postgres

Data Management

Edit Aggregation Tables: edit the query of saved Aggregation Tables, without replacing them with new ones.
Note that, to avoid table schema conflicts, this is only allowed when using “Replace” strategy.
To edit an Aggregation Table in “Append” strategy, follow these steps:

  1. Change strategy to “Replace” and save
  2. Edit the query
  3. Run it
  4. Change strategy to “Append” and save

Create segments from funnels: create powerful user segments by isolating specific actions in funnel reports.
To create a segment from a funnel:

  1. Create a funnel report (note – not available when using funnel visualization on CQL reports)
  2. Click the visualization section/s you want to isolate – for example, all the users who dropped off on the second step.
  3. Click “Explore users” at the top right of the chart, and choose “Create Segment”.
  4. Name your segment – use a unique name, without spaces or special characters, and save it.
  5. To further edit the segment you created, either click the link in the save confirmation message at the top of the page, or go to the Segments list from the Project menu and click the name of the segment.

Updated project menu: orientate better in the many project settings Cooladata offers using the updated project menu.
The menu is divided into three sections:

  • Data Sources: all the methods of adding data to your project: tracking, uploading, streaming, integrating and linking to external databases.
  • Build: everything you can create in your project: segments, Aggregation Tables, Alerts and Publications.
  • Manage: control and configure your project: monitor events, edit meta-data, project settings and user permissions.

Updated Schema: easily find out what tables your project contains from the Schema, accessible from the top right of the workspace.
Empty categories will be hidden.
Browse each section or search to find specific items:

  • Cooladata: events and properties
  • Segments
  • Aggregation Tables
  • Integrations
  • Linked Data Sources


Added page_url_params to JavaScript SDK:
Store any params sent it the URL using the default page_url_params property, sent on every page_load event.

Black/white list countries for project: block data from specific countries (by IP), or enable only specific countries.
Contact your Customer Success Manager for additional information.

Print Friendly, PDF & Email

April 2017 Release Notes

Analysis and Data Visualization

  • Updated Pivot chart:
    • Menu items moved to top right (were previously in a standalone row), to free more area for the visualization.
    • Control whether to show function in column titles, e.g. “Sum of Users” or just “Users”. Change from the toggle in the chart settings.
    • Export to CSV/Excel from charts (previously only possible from grid). Click the export button and choose “To Excel” or “To CSV”.
    • Calculated columns shown in flat mode. Switch pivot grid to flat mode from the layout button.
  • Funnel breakdown by time: compare funnel conversion over different time spans – months, weeks, days, etc. Choose breakdown by a time range in funnel report to show the visualization categorized by time. By default, the first 5 sections are selected. Change the selected categories from the breakdown selection in the preview.
  • KPI breakdown by week supports localized week start day: by default, weeks start on Mondays. To change this please contact your CSM or email us at
  • Aggregation Tables: renamed “Material Views” to “Aggregation Tables”. Found in the project menu (accessible on by project admins). Other functions remain unchanged.
  • CQL validation shown in full-screen mode: edit long CQL queries more comfortable by switching to full-screen mode. Click the button at the top right of the CQL section (in CQL reports), or hit F11 while in typing mode to expand/collapse the window. The query validation will be shown at the bottom while in full screen mode.
Print Friendly, PDF & Email

Cooladata has a new look!

We’ve redesigned the platform to be more appealing and easier to use. We’ve kept all the previous design’s functionalities, and introduced some new ones.
Watch the following video to review the new design and see you exactly where everything is, or read the description below.



Responsive Design

Previous, non-responsive design New, responsive design

If you use Cooladata on low-resolution devices, it probably felt like things were a bit… cramped.
The new, responsive design fits any monitor and will help you communicate insights to your colleagues on any screen size.


Main navigation

We’ve moved the main navigation to the top, to give you more screen real estate to what matters most – your data. Dashboards and reports are now bigger and easier to use!

On the left you see the dashboards and reports lists, which will open the corresponding pages. On the right you see the system clock, user panel, project menu, and help menu:

  • Point to the system clock to see the current time in your project’s time zone.
  • Click the user panel to see your user token, for Query API purposes, or to log out.
  • Click the project menu to see all the project options, as before. The list of options depends on your permission – project admins will have more options than standard users.
  • Click the help menu to open the documentation, see what’s new, or restart the getting started tutorials.



We added a quick access “Create” button, to create any report from anywhere in the app. The new “Create” button opens the new report gallery. The new report gallery offers all the same reports as before, and more:

  • In custom reports you’ll find all the report types you’re familiar with. Click a report type to open the default template, same as before.
  • Click any other category to see a list of predefined reports. Click a report from the list to open a new, predefined report of the analysis it describes.
  • Use the search above to find a specific analysis.

Note that reports created from the Create button aren’t added automatically to the dashboard – use the dashboard’s + button for that.



In the dashboard, everything remained in the same place:

  • Rename the dashboard by clicking the title
  • Navigate sheets by clicking the tabs
  • Change the dashboard filters
  • Change the dashboard date range
  • View the dashboard options
  • Share the dashboard (if you are an editor on the dashboard)
  • Add reports to the sheet (if you are an editor on the dashboard)

The filter report design has been updated too, to fit more conditions in a smaller size. Click the button on the top right to apply the new conditions to the sheet.



We’ve overhauled the design of reports to give a lot more screen real estate to your visualization. Update the report, or just view it and switch between visualization types, without giving up screen space!

In the top bar, you’ll notice most things are the same:

  • Report name: On the left you’ll see the report name. Click to edit it.
  • Report type: Below the report name you will see the report type.
  • Filters and date range: On the right you’ll find the report filters and date range, which work the same as before, but look the same as you’re used to in dashboard. Note that the option to ignore dashboard date range and filters have been moved to the Report Settings, under Options.
  • Project: We’ve added the report’s project to the top bar. This will only affect the open report.
  • Tags: We moved tags to the top bar. The new tags design shows you an indication of the number of tags used in the report. Click the button to add or edit tags. Point to the button to see the list of tags.
  • Save and Save as: We’ve added a Save as option to reports. Use it to save changes you’ve made to a new report, without affecting the original. This will not switch you to the new report – click the save confirmation message to open it.

The new report layout is built of two sections: the editor, and the preview area.

  • Editor: In new reports, the editor is open by default. Click on “Hide editor” will collapse it. Click on “Show editor” will expand it.
  • Preview: The preview section allows you select and configure the visualization. Hiding the editor extends the preview area to fit the whole screen.
    • Click a Preview type from the left to select it.
    • Click Description to show, add or edit the report description
    • Click Settings to change the selected visualization settings.


Print Friendly, PDF & Email

March 2017 Release Notes

Analysis and Data Visualization

  • New report – Real Times: see real-time user and event counters, broken down by time, device, region or event type. Reports can be set to update automatically every 1-10 minutes, or manually updated from the preview buttons. The report supports all visualization types and can be used as any other report: in dashboard, embedded and publications. Notes: sheet/dashboard filters do not apply to Real Times reports, nor can they be exported. To active Real Times reports please contact your CSM or email us at
  • Combined Chart: create richer charts by combining multiple types into one and customizing axis, number format and more. We’ve combined Line, Bar, Column and Area charts to a single type of chart – Combined Chart. To customize the chart, click the options icon next to the measure name and change the settings in the menu below. Note: stacked charts only allow to stack measures on top of one another if they are of the same chart type, and on the same axis (the option is hidden when this isn’t the configuration).


Data Management

  • Segment integration: track Cooladata events using the trackers. Please contact your CSM or email us at for additional information.

  • Upload events from data files: upload historical events data or current data tracked by external systems from files. You can upload files from S3 storage, either public or private (by entering your secret key), as well as from any other service which only requires a URI. Note that we don’t store any credentials information – it is only used once to upload the file. Uploaded filed take up to an hour to be added to your project, at which point you will be notified by email of the upload result.

Print Friendly, PDF & Email

February 2017 Release Notes

Onboarding and Tracking

  • Use Cooladata Tagger to get started tracking web events quickly and easily: use CoolaData Tagger when implementing the Cooladata tracker on a website. Find the tutorial video and instruction on the project tracking page and in the documentation.


Analysis and Data Visualization


Filter, group and analyze your user’s behavior using the new Cooladata behavioral segments:

  • Create segments: create segments from cohort report, by intersecting advanced behavioral conditions in the segment builder, or using any CQL query in the segments query editor.
  • Use segments: use segments in any part of the platform –  filters reports and dashboards, group users in reports according to their segment, or in any CQL query.

See the tutorial videos and documentation for more information, or contact us for any further assistance.



Improved funnel report

A new and improved Funnel report and visualization, including multiple new features:

  • Use the funnel visualization in any report: specifically CQL, allowing you to write more complex funnel queries.
  • Use any visualization in funnel report: allowing you to view the data in table, pivot or any other visualization.
  • Show the first steps breakdown height according to their value: previously all steps were normalized to 100%. Now you can change this by toggling “Absolute step height” on.
  • Show global conversion rate under steps: available when you have 3 or more steps, toggle “Step global conversion rate” on to show the under global conversion rate steps 3 and up.
  • Export selected users from multiple categories: choose any sections in the same step and choose any options from “Explore users” to export them all together. Clicking another step would reset the selection. Previously only one category could be exported at a time.
  • First 5 breakdown categories are selected by default: up to 5 categories will be shown by default when breakdown is used. Remove the breakdown (click the trash bin icon next to it) to see the total figures.
  • More intuitive tooltips: hover any part of the visualization to show explanatory tooltips of the data displayed.



Additional features and improvements

  • Use any filter operator: define any condition using filers. Filters now show all supported operators for the each property according to its data type.
  • Use aliases in Ranking report: give the report measures and dimension friendlier names by setting aliases in the report builder.
  • Navigate pages quickly using pagination: quickly scroll through multiple results in table visualization and lists using the paginations, including jump to first/last page buttons.
  • Arrange your dashboard as you wish: size and position dashboard item as you’d like. Item sizes are now completely flexible. To reset the dashboard item’s position and size click the dashboard options icon (ellipses) and choose “Reset reports size”.
  • Project schema shows property data types: see each property data type in your project from the Schema icon (top right).


Data Management

  • Run Aggregation Tables on linked data sources: create aggregation tables or import data from any Linked Data Sources to Cooladata by running Aggregation Tables queries from any data sources, as you would in CQL report.
  • Full AppsFlyer integration: seamlessly stream all your AppsFlyer data into Cooladata. All the events will now be available in Cooladata, as opposed to only app installs previously, allowing you to run deeper analysis on your user’s behavior.
Print Friendly, PDF & Email