Quick links
Getting data into other tools
Advanced features
Advanced transformations
Datasource specific
Sidebar
google_data_studio
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 issues blending my data from windsor.ai connectors with Google data sources
Blending Windsor.ai connectors with Google data sources in Looker Studio
If you join Windsor.ai data sources to connectors which are developed by Google the types need to be cast explicitly to make the join work.
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?
How do I load attributed revenue from charts.windsor.ai into Looker Studio?
google_data_studio.txt · Last modified: 2023/06/07 08:48 by windsor_ai
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
