DBeaver

CoolaData integrates with DBeaver SQL client to join data stored there and unify your view with data from additional sources.

Metric Insights

At CoolaData, we believe in the power of open source and open data. Third party built-in integration tools like Metric Insights allow you to enjoy the power of personal alerts according to pre-defined rules, based upon your data stored in CoolaData. Metric Insights provides simple access to actionable, timely, and relevant information to help facilitate smarter decisions. With Metric Insights and CoolaData, you can, for example, send daily emails with your users/session trend chart, and then analyze this data to make better business decisions going forward for those users.

Gmail Integration

Enrich your CoolaData project with your own data received by a gmail account, or upload any report you receive regularly to query alongside your behavioral data. Email Report integration enables you to upload data from reports that are emailed to you from various sources.

Email Report integration enables you to upload data from reports that are emailed to you from various sources.

Execution Frequency: Hourly

Date Format: 

Each report use a different date format, in order to understand the file dates we need the format in which the dates are presented, for example the date: 18/04/1990 16:21 fit the format dd/MM/yyyy HH:mm:ss (the Format is case sensitive ‘MM’ represents Month and ‘mm’ represents seconds).

Google Tag Manager

Combine Google’s Tag Manager website data, like traffic measurement and page views, with CoolaData’s event data to get a complete view of your user’s behavior. CoolaData provides multiple APIs for tracking user/application events. The process involves embedding CoolaData scripts and calls at various relevant places on your site or application. Google Tag Manager (GTM) is a free and easy to use platform that allows you to manage CoolaData’s code snippets and firing of events without having to edit the code of your site or application. All you need to do is create a Google Tag container and define some rules.

We recommend implementing CoolaData’s SDK directly in your site or application, as it will provide you with the most flexibility and the full power of the SDK.

The sample “Documentation” tag is an example of the simplest type of tags and rules you can create. They are not representative of the sort of events and event properties you would be after if you are interested in deep user behavioral analytics.

Using GTM it is possible to go deeper. GTM offers Macros and Data Layer Objects that provide ways of listening to events (as opposed to simple pageviews) and registering their particular properties. However, this would require changes at the code level of your site. It is up to you to decide if it is not simpler, in these cases, to simply implement the CoolaData SDK directly in your site.

This document will walk you through the basic steps of getting this done. As well you can view a short video from Google that shows these basic steps.

Rest API

Use CoolaData’s REST API to send server data or any offline data that you want to join to your event data. Using CoolaData’s REST API enables customers to send data to CoolaData. All API calls are HTTPS based, and require an app-key, provided by CoolaData. REST API data is sent in POST method.

Each call should be sent as an array of JSONs – one JSON per event. We only support flat JSON files – nested JSON is not supported. A single call may include as many as 300 events in a batch. To achieve better throughput, and if you are having many events per second, you should send ONLY in batch (and not one after the other).

For each call CoolaData responds with a “200 ok” status.
Note: As we accept events in JSON format, avoid using escape characters in the data sent to CoolaData. See a list of all escape chars here: http://json.org/. As a best practice we recommend sending events in the event payload url encoded.

Tableau

Cooladata integrates with Tableau to enable a variety of reports and visualizations for data analysis. Choose to connect using our query API or our ODBC driver.