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.
