July 2016 Release Notes

Analysis and Data Visualization

  • New KPI template – you can now combine up to 10 KPIs into one report, and use the calculated fields functionality of the Pivot visualization to calculate measures based on multiple KPIs (e.g. calculate CTR by dividing clicks and impressions). Note – changing the report resets calculated columns in the visualization.
  • Publications (email reports) now support all visualizations – send out any type of visualization as an image in your publication emails. Normal tables (not pivot) are still sent as text and not images.
  • ‘Pretty’ Aliases – you can now use spaces in CQL aliases, by wrapping them in commas. This allows you to create nicer looking reports with column titles such as “Number of Users” instead of “Number_of_users”.
Print Friendly, PDF & Email

June 2016 Release Notes

Analysis and Data Visualization

  • New Sunburst Path Analysis Visualization – see how user paths are distributed using the sunburst visualization.
  • Funnel Analysis of Multiple Events – use multiple events for a single step in the Funnel template.
  • Powerful Pivot Features – the Pivot visualization is now more powerful than ever, including functionality such as calculated fields, conditional formatting and drill down.
  • Reverse Cohort – a new Cohort template that shows the behavior leading up to a certain event (as opposed to the behavior beginning with a certain event, with a standard Cohort).
  • Behavioral Segments – create behavioral segments and filter reports and dashboards using the “is in segment” or “not in segment” operators.
  • Date_Range Date Functions – the date_range clause now supports the date functions: DATE_DIFF, DATE_ADD, DATE, which can be combined with date_range_start and date_range_end. Example: count the events in a time period which is offset from the report’s time frame by two weeks:
    select count(*)
    from cooladata
    where date_range(between date(DATE_ADD(date_range_start, -14, "DAY")) 
    and date(DATE_ADD(date_range_end, -14, "DAY")))
  • White Label Embedding – we have removed the CoolaData logo from the embedded reports so you can now truly white label our reports and embed them in your website.
  • Data Schema Tree – access your data scheme from anywhere within CoolaData by clicking on schema at the top of the page.

Data Management and Administration

  • Security Enhancements – we have added an additional permission level – “Viewer”. Users with “Viewer’ permission can only view the dashboards that have been shared with them. They cannot see or change the dashboards filters for these dashboards. They also cannot view or create reports.
  • Read Only and Hidden Report Attributes – each report can now be classified as “Read Only” to prevent any change or deletion by mistake. Reports can be classified as hidden so they are only accessible to the report’s creator.
Print Friendly, PDF & Email

August 2016 Release Notes

Analysis and Data Visualization

  • Configurable Pivots – You can now control which Pivot functionality the end-users have access to (changing the rows/columns, export, formatting etc.). This also affects the functionality available when embedding the reports in an external web page.

Data Management

  • Removing unnecessary events – you can now deactivate unnecessary events (that are either obsolete or were created by mistake). Once you do they will not appear in the events drop downs in the various templates. Click the top right eye icon to show/hide disabled events in the project’s events list.


  • Trusted IPs – We now support white-list restrictions for Query API – you can define a list or a range of IPs that are allowed to query your project’s dataset. All other IPs will be blocked.


  • Cookie expiration is now configurable – we added a parameter to the JavaScript SDK to control the cookie expiration period.
Print Friendly, PDF & Email