We are constantly adding more ways to connect your data with Cooladata, to provide you with a single point of management for your data. We aim to make new connections available to any user, with just a few clicks, so you can configure them yourself and not need R&D to get insights quickly.
Data Sources Page (Admins only)
The new Data Sources Page provides you with an overview of the multitude of ways you can connect with Cooladata, both for sending data and querying it. To access the page, from the project menu, select Data Sources. Here, browse through the different categories: Event sources, Integrations, Linked data sources and BI Tools, and click an item to learn more about it.
Integrations (Admins only)
Salesforce develops CRM solutions that help customers increase sales, improve customer service, collaborate with their team, and develop customized applications on the Salesforce platform.
Integrating Salesforce into your Cooladata account will and allow you to enrich the behavioral data tracked by Cooladata with your CRM data.
Setting up the Salesforce integration will fetch the following Salesforce objects: Leads, Opportunities, Accounts, Contacts, Price books, Products, Campaigns, Events.
All the above objects’ fields, standard and custom, are fetched. See each object’s standard fields list here.
Data is updated daily. To configure a specific update hour please contact us at email@example.com.
Intercom is a powerful set of tools for better managing your company’s customer support system. It includes a help center with a feedback system, which you can use to focus future articles on the growing needs of your customers, and it also provides a robust conversation system that allows you to assign support teams to customers based on specific criteria (about the customer or discussion topic), rather than just based on availability. Intercom is designed to create a more effective customer support network by specifically tracking and targeting your customers’ needs.
Cooladata’s integration with Intercom empowers marketers and customer management teams to understand the entire user journey, and the impact of Intercom on their users’ lifetime and value.
The integration runs daily, updating the previous day’s end of day data in each table: intercom_conversations, intercom_users.
To integrate Intercom to your Cooladata project please contact your customer success manager or email us at firstname.lastname@example.org.
Google Search Console
Google Search console (GSC) is a collection of Google SEO tools and reporting. It offers data and configuration control for your website as well as a variety of visitor metrics.
As an online marketer, the GSC “search analytics” section is probably the most useful report for you. GSC “search analytics” delivers insights into how your website is performing in regards to the overall organic search traffic from Google. You can see the most popular queries, pages, countries and devices. Additionally, for better understanding of your website’s performance in Google’s search results, you can use different filters to segment traffic even further. See what keyword searches on Google led to the site being listed in the SERPs, and the click through rates of such listings.
The Google Sheets integration enables you to use your Google Spreadsheets as tables in your Cooladata project, and query them directly from your Cooladata project.
Connected spreadsheets are always updated and reflect the exact data your sheet contains.
The new table will be added to your project Schema, under Integration Tables, in the Table Name you selected. Query it by using the following syntax:
FROM < table name >
Firebase is Google’s mobile platform that helps you quickly develop high-quality apps and grow your business.
You can now integrate Firebase with Cooladata so that all the events generated by Analytics for Firebase will be sent as any other event to your Cooladata project.
To do so, you will need to link your Firebase app to BigQuery. Linking your Firebase app to BigQuery allows you to access your raw, unsampled event data along with all of your parameters and user properties.
Once you’ve linked your Firebase app to a BigQuery project, we will connect it to your Cooladata project. This will stream all your event data directly into your Cooladata project, where you can query, export or join your data with data from other platforms and data sources in your project, to perform custom analysis.
To set up a new Firebase integration, contact your Customer Success Manager or email us at email@example.com.
Aggregation Tables – Run Multiple Tasks Per Table (Admins only)
You can now create multiple tasks per table. Each item in the Aggregation Tables page is now a task, which runs on a table. This enabled you to run several ETL processes for the same table, for example: extracting data from you Linked Database, adding column to include specific data, and running aggregations on that data. When creating a task you can select to run on an existing tables, or create a new table. Task name can be anything you want.
URL Parameter Virtual Properties (Admins only)
This new virtual property lets you create a separate property from any parameter sent in your webpage URL. Use this to extract any lead information passed from marketing campaigns, forms, etc. To create a new virtual property, from the project menu select Properties, click the + icon, and choose URL Parameter. All virtual properties are calculated on the fly, and can be modified at any time.
Expressions in Virtual Properties (Admins only)
Previously you could use two types of calculations in virtual properties: Virtual Dimension and Virtual Measure. To simplify the process, we have combined both capabilities to one, easy to use type. In this new virtual property type, you can enter any CQL expression you want to calculate, be it a function, CASE, or calculation based on other properties. Existing Virtual Dimensions have been automatically converted to the equivalent CASE expression. Unlike Virtual Dimension, where you could only use strings as the results of the CASE expression, with Expression you can select any value, includes calculations on the data.
R and Python Reports
In the modern world of analytics, SQL queries can only go so far. Powerful insights rely on advanced machine learning and AI algorithms. Now, you can incorporate any such scripts in Cooladata.
As a first step, we enable you to run R and Python scripts in your reports. Run any script and plot any visualization to be shown in a report, embedded reports, dashboards or publications.
To create a new R or Python Report, from the New Report gallery go to Scripts and choose the report type. Enter the CQL query in the top section to draw the data, and run the script below. To use a library, see list of pre-installed libraries in the script, or add new ones in “Additional Libraries”.
Note that this feature is still in beta – your feedback will be much appreciated!
Alerts Builder (Admins only)
Getting notified on business events is critical to managing your business. To help you with this, Cooladata enables email alerts to be sent on a scheduled basis, whenever a condition applies in your data. Now you can set advanced behavioral triggers yourself, without writing the CQL query. Get alerted on changes in users activity, events and property values, compared to preceding period or parallel historical periods. To create a new alert, from the project menu select Alerts, click the + icon and select Builder. Set your trigger condition and schedule, and add any pertinent info and reports to the email body.
PIVOT CQL Function
Data is constantly changing, and requires us to change with it. When dissecting data across various dimensions, we often need to update our analysis as the dimensions changes. To help you automate this process, we have added support to the useful PIVOT function in our CQL (Cooladata SQL) language. Like in the pivot visualization, the PIVOT function lets use convert row values of a specific dimension to multiple columns, allowing you to treat each as a measure and compare them side by side in a single chart. See the PIVOT documentation for the exact syntax and options in the function.
In the following example we converted country values to columns, showing them together in a bar chart.
You can now view reports and dashboards on your mobile device. Specifically designed to let you access reports sent to your email, the mobile support also fits complete dashboards in the palm of your hand, to let you access them anywhere, anytime. Open Cooladata on a mobile Chrome browser to access it.
White Label Publications
Share reports with your clients via email directly from Cooladata. You can now request to set all your publications to be sent with your branding. If you use Cooladata as a whitelabel site, all links can be updated to direct to that site. If not, they can be removed. Contact your CSM or email us at firstname.lastname@example.org to set up.