About Google Data Studio
Data Studio, part of Google marketing Platform and closely integrated with Google Cloud, allows you to easily access data from Google Analytics, Google Ads, Display & Video 360, Search Ads 360, YouTube Analytics, Google Sheets, Google BigQuery and over 500 more data sources, both Google and non-Google, to visualize and interactively explore data.
It allows you to easily share your insights with anyone in your organization. And beyond just sharing, Data Studio offers seamless real-time collaboration with others—whether you’re sitting across the room, or across the world.
Learn more at https://datastudio.google.com/.
The main areas in which they work
- Data centralization
- Multiple connectors
- Reporting and dashboards
- Complete customization of visualizations
- Access rights
- Automated sharing
AT Connect Google Data Studio
This AT Connect allows you to easily import data from Piano Analytics into Google Data Studio. Explore, transform and combine Piano Analytics data with hundreds of sources available in Google Data Studio.
Thanks to this integration you can create meaningful and easy-to-follow reports in just a few clicks. Collaborate with your team to create dashboards that inspire smarter business decisions!
- Native connector: Access Google Data Studio and simply enable the Piano Analytics data source. A Piano Analytics template is also available to save you time.
- Unite sources: Cross, compare and combine your Piano Analytics data with the hundreds of sources available in Google Data Studio. Import all this data in just a few clicks, without using a line of code.
- Custom dashboards: Easily create complete dashboards and reports with simple drag and drop. Curves, histograms, tables... Use the most relevant visualization and facilitate the decision making.
- Collaboration and sharing: Invite your collaborators to participate in the creation of impactful reports. Spread the knowledge of key KPIs within your organization by automating the sharing of your different dashboards.
How the bridge works
The AT Connect Google Data Studio allows you to export Piano Analytics data to create custom dashboards. You can also cross Piano Analytics data with other data sources available in this Google platform. The activation of the connector needs two steps:
- The first step is to generate an API key from your Piano Analytics user profile. You’ll have to paste this key into Google Data Studio interface.
- The second step takes place in Google Data Studio. You must choose the Piano Analytics data source, allow the Piano Analytics application through Google authentication, and activate the connector by pasting your Key API.
API Key creation from the user profile
You must create an API Key that will allow you to activate the connector. You must therefore access your user profile in order to create this key (the Key API is composed of an Access Key and a Secret Key). For information, you must have a level of access rights "Analyst" at least to be able to generate this API.
You access your profile by clicking on "See profile" at the top right of your Piano Analytics interface.
You will then be able to create a new API Key from the "API Keys" menu (last item in the horizontal menu) by clicking on the "Create a new API Key" button.
You must then give a name to this API Key and provide a description.
Your API Key will be automatically generated. Be careful to keep it in a secure location, it will be displayed entirely once. You'll have to paste it into the Google Data Studio interface. The API Key is composed of an Access Key and a Secret Key.
Connector activation in Data Studio
Selecting the Piano Analytics Data Source
In order to enable the connector, you must select the Piano Analytics data source in Google Data Studio. You must go to the Google platform via this address - https://datastudio.google.com/.
Data sources are available through the left menu "Create" and then "Data Source".
You can then choose the Piano Analytics data source to enable the connector and proceed to the next step. A search engine helps you to quickly reach the desired data source.
- 'AT Internet' Source: connector based on Data Query 2 source (APIv2).
- 'AT Internet - DELTA' Source: connector based on Data Query 3 (APIv3).
Authorize the Piano Analytics application
In order to work properly, Data Studio requests permission to use the Piano Analytics Connector. You must then allow the Piano Analytics application through Google Authentication.
Paste your API Key and choose your Piano Analytics site
In this last step you have to paste the API Key generated from the Piano Analytics interface (part 3 of this document). Google Data Studio will then be able to recover your Piano Analytics data.
Be careful to associate the Access Key and the Secret Key with an underscore "_" before pasting the information into Google Data Studio.
Example: Accesskey_Secretkey (xxxxx_xxxxxxxxxxx).
You must then choose the site concerned by this new Dashboard. Piano Analytics also offers a default template, avoiding you to start from scratch.
You must press the "Connect" button located at the top right of the interface to activate the connector.
Dashboard creation in Google Data Studio
Once the connector is enabled, you can edit the imported properties and metrics. Different options are available: renaming, deletion, choice of the type of data, aggregation, modification of the description, addition of a field ...
You can also configure the general options of the dashboard such as the freshness of the data, the activation of the visualizations created by the community or the possibility of editing a field directly in the dashboard.
Once set up, you must click on "Create report" at the top right to start creating a dashboard.
Now all you have to do is to create dashboards from Piano Analytics data with other data sources. You can also collaborate with others on these dashboards, share them whenever you like via a link, by .PDF or by email.
TipsFor information in Google Data Studio you can add charts from different sources in the same Dashboard (multiple Piano Analytics sites and other sources). You must go to the right side of the screen to edit / add a data source.
TipsIt's possible to combine data from several level 1 sites into one graph and make calculations with these data (addtions, etc.) thanks to these two GDS features:
To correct this problem, the account owner of the source must update its information in the "Account and privacy" interface of Google Data Studio (cogwheel at the top right of your interface). Like this :
TipsIn Data Query 3 you have the possibility to save your custom metrics. Here is an example with a custom metric "m_events_per_visitors".
After saving this metric is available in Data Query 3:
In Google Data Studio you must refresh the Piano Analytics data source to integrate the custom metric you just created. To do this you must click on the source editing pencil (right panel), then you click on the data refresh button (bottom left) and finally you must apply the changes.