Quick links
Getting data into other tools
Advanced features
Advanced transformations
Datasource specific
Sidebar
google_data_studio
This is an old revision of the document!
Table of Contents
Getting your data into Google Data Studio
Google Data Studio requires you to install a connector.
Blended Data connector / Ad Data + Attribution
To get blended data into data studio from all the source we support install the Ad Data + Attribution Connector.
How to change field types to number or date etc.
Sometimes fields have to be formatted or changed from text to number.
It can be done in the following way.
1. Click edit connection after selecting “Resource” → Manage datasources
2. Edit the field type. In our example this did not work because the data contained comma , as decimal symbols and datastudio was expecting dots . So in addition to the cast we have to create a regex to replace the comma values. We use the formula which both replaces the comma with dot and casts it to number: CAST(REGEXP_REPLACE(spend, “[\\,]”,“.”) AS NUMBER)
New fields with the types and old field with the comma's also visible.
List of connectors
To connect only one specific source you can install connectors separately:
List of templates
Frequently Asked Questions
I have added one data source, how do I blend in more sources?
How are currency conversions handled?
How do I create a custom metric/dimension?
Which metric should I use for media costs, media spend?
How do I compare the CPA or ROAS on Google Analytics vs. what the platform reports?
How do I connect separate accounts to different Data Studio dashboards?
google_data_studio.1651760568.txt.gz · Last modified: 2022/05/05 15:22 by windsor_ai
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
