Looker Studio is a free data visualization tool used to consolidate data from different sources and share aggregated results. This connector gives you the opportunity to connect Contentsquare aggregated site, page, and zone metrics and tailor results by segment, device, or goal in Looker.
Before you can begin setting up your connector you will need to:
- Be a Contentsquare admin
- Download the CS Looker Studio Helper Chrome extension
- Ask your CSM for access to Contentsquare's Metrics API
Set up your Connector
2. Add Contentsquare as a Looker Studio data source
Go to Looker Studio and add Contentsquare as a data source to a new or existing report
Click 'Add data' Search for "Contentsquare" and select it.
- Input the API key you have generated
- The configuration screen should appear, all the checkboxes to allow parameters to be modified in the report should be checked.
- Click 'Connect' and then 'Allow' on the configuration pop-up.
Use the Chrome Extension
- Open your CS Looker Studio Helper extension and enter the API key you just generated.
- You will also need to create a password that the extension will use to securely retrieve your encrypted API key. (Tip: Keep it simple, you will need it regularly while building your dashboard).
2. Choose a project
- Select which CS project’s data you wish to work on
- Select a timezone. If you want your data to match what you see in Contentsquare, specify the same timezone as the one set in your user account.
3. Define parameters and page zones
Use the extension just like you would your CS Analysis context
- Define your parameters: select your segment, device, and goals.
- Choose your mapping, then corresponding pages and zones, then apply filter.
Although the Google Data Studio Connector relies on the Metrics API, some of the metrics available through the Metrics API are not available in Looker Studio.
Here is a list of metrics available on Looker Studio:
|Zone metrics (web)||Zone metrics (app)|
Can I aggregate the data on a periodicity other than daily?
The connector does not support this directly yet. You can do it through some Looker Studio computation, but you should only do so for metrics in absolute values that can be safely summed. E.g. If you do it for ratios such as the click rate, then averaging the daily data won’t give the right computation (a click rate for a month is not the average of 30 daily click rates, but rather the ratio between all the clicks and all the sessions for a month, which is different!)
Can I use Looker Studio controls?
Our connector supports the date range and the drop-down controls. You can use drop-down controls to select among segments, devices, goals, pages, or zones, for example. For your visualization to be dynamic based on a drop-down control selection, you must ensure that no specific occurrence of the target dimension (e.g. no specific segment) has been specified through the Chrome extension for this visualization. In “View” mode, the value selected in the dropdown will be dynamically sent to the connector if the corresponding parameter has been properly left empty.
Will my teammates need to generate their own API keys or can they use mine?
No. By default, you share your dashboard with the option 'Owner’s credentials' attached to your Contentsquare data source, meaning that anybody you shared the dashboard with will benefit from your API key access. This is useful, but it also means you should remain vigilant and share the dashboard only with people who can access the Contentsquare data.
What if the data I see in Looker Studio is not up to date with what I see in Contentsquare?
If you see that the dropdowns (segments, mappings, goals, etc.) in the extension are not up to date with your Contentsquare platform, it’s because the Chrome extension uses some cache and may not display the last changes occurring on your platform. You can force a refresh of the dropdowns by clicking on the “Refresh dropdowns” button in the footer of the extension.
How do I change my API key?
1. Generate a new key using the Contentsquare console.
2 Go to Add data > Connect to data > “…” button of the Contentsquare connector > Revoke access to delete your previous key.
2. Add the new key just like you would add a new credential for the first time.
3. Open the Chrome Extension and click 'New API key' at the bottom-right.
Watch the Demo
Here are some examples of dashboards you can create using the GDS Connector.