This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
google_data_studio [2021/04/07 13:06] windsor_ai |
google_data_studio [2023/06/07 08:48] (current) windsor_ai |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Getting your data into Google Data Studio | + | ====== Getting your data into Google Data Studio ===== |
Google Data Studio requires you to install a connector. | Google Data Studio requires you to install a connector. | ||
- | === Blended Data connector / Ad Data + Attribution === | + | ==== Blended Data connector / Ad Data + Attribution ==== |
To get blended data into data studio from all the source we support install the [[https:// | To get blended data into data studio from all the source we support install the [[https:// | ||
+ | |||
+ | |||
+ | ==== 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 " | ||
+ | {{:: | ||
+ | |||
+ | |||
+ | 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, | ||
+ | {{: | ||
+ | |||
+ | New fields with the types and old field with the comma' | ||
+ | {{: | ||
Line 12: | Line 28: | ||
To connect only one specific source you can install connectors separately: | To connect only one specific source you can install connectors separately: | ||
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | | ||
+ | | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | |||
+ | |||
=== List of templates === | === List of templates === | ||
Line 33: | Line 70: | ||
[[https:// | [[https:// | ||
- | ==== Frequently | + | ====== Frequently |
+ | |||
+ | === I have issues blending my data from windsor.ai connectors with Google data sources | ||
+ | |||
+ | [[google_data_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? === | === I have added one data source, how do I blend in more sources? === | ||
Line 44: | Line 89: | ||
[[Google Data Studio: | [[Google Data Studio: | ||
+ | |||
+ | === How do I create a custom metric/ | ||
+ | |||
+ | [[Google Data Studio: | ||
Line 57: | Line 106: | ||
[[Google Data Studio: Separation of accounts in different dashboards]] | [[Google Data Studio: Separation of accounts in different dashboards]] | ||
+ | |||
+ | === How do I load attributed revenue from charts.windsor.ai into Looker Studio? === | ||
+ | |||
+ | [[Looker Studio: Import charts.windsor.ai data]] | ||