====== 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 [[https://datastudio.google.com/datasources/create?connectorId=AKfycbwMs3jUvu_RtMs6XtlspAdiMR8X19N1DAi8mYOCfUxy6I3NHhXRR9qkqxg83fG2js71| 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 {{::edit_connection.png?1200|}} 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) {{:add_new_field.png?1200|}} New fields with the types and old field with the comma's also visible. {{:2021-08-26_15-17.png?800|}} === List of connectors === To connect only one specific source you can install connectors separately: * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbxzt5KiJwAA3WPPP_oyK6-p36j6-iZYdFXlfQl4kXWMLyrt7medUu1z0gLIljhtVqOL|AdRoll]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbzaoSoOuUY1_4Muvqluzerdf5w788OVa2BPVF7s7v4krnD2Y2b-IVrSk6qcUQBuGZE| Amazon MWS]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbyYujpIAoA9nPv4e17jabwf4nayozNmx7sk8VyNcaEwcn07_Nd3D8QygIPecaxi2YdN| AppNexus]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbzf1fpiXL0T2uM0kDJiYilPQQXNq8nzbi7qdysTNDRRqI3YENvtW3Zb7BzAVBlXyy8x| Apple Search Ads MWS]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbyiuyICYRyLShFwikLtRD83GfCu2V8M0xA_mqdZFwINTC3bUsdaKkVNSfMvsHnirnpW| Appsflyer Attribution]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbzPPI4vwEYgMrxCor6_hxJOwSjZco-34tX5TZiiPMmWVhflzBCudzg2KDf-ieAFIRfv|Awin - Affiliate Window]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbzIHEIom1VF_w9Pr_AhGNm9wKsnhIzsuGmT1NZB1UKlf_lcwtVkIgN0DrNJm1aBQo11BQ|Bing Ads / Microsoft Ads]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycby7Ip8yHqbzZgItbbdu5wQiFTOFbPKeGW3LwQ9rbGgMQgkwC8eu7FxdXKhYUb0RVgvWag| Criteo]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbxvhYo5-Z5faPpxqZd5EXHZg1nxWcjG0tU9985gUVCdaGg-qxEnBkaxfVZ8aLMUNhrL| Facebook Ads]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbyo4RzBIhFGCf1n6cswv3W18dCnFewTbNizF5OSlAFyEN6sleM8waiC6yKIFvlK9HNcoA| Facebook Page Insights]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbz3TlRGjbu8bu0SMDzoxtd2NslyWy39u-ZemGewuFcg08aQPGCSSluR9_yfJ1zFDCCO| Google Ads]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbz6KQzKhydN8GhY3oPym-NlvPtoWc5af8KE3LvA9O-na8A8dtQOmN-UzDPNSNZ7heTy| Google Analytics 4]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbzTE-lZ-I9HcsbWGkfpISVnGnQrN6AyKNyofi1qBlO2h5418ytQkPLXVLoCHNYd-ih9| Google Campaign Manager 360]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbzccQ6djqevrtiYAn4GkuOw2llZgu_qS6eTT10jpv18hnn20oHsXh2wGMopcDJx4vdAjg| Google Display & Video 360]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbxNrZvWuaGw5HAunlQafDZZheBzMy0Ouz-NLLjaUGgpHOlfSY301eKGy0-hZrmqQSxb| Google Search Console]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbxz-KPB_W_KGA2bEGHOwExacux49Ar71atiuz4m2odLffX3AOkOMlKOM49AxP-bNdMWUA| HubSpot]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbw-_ugAXVB1d8nQCdo6be1QTBT62d6g4a4UVSGDlqlukikzt_JG5hYsWrtRNOhz1XGT| Idealo]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbwTnMGX4tQiUoGAoktjnAnfTMguuCyUclX0jsyLN7fCrBLWsRW40zv01S_HoHSh80SW| Instagram Insights]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbwx4Ixzwm6Gi99VbTwJUM1vTZTux6q7TffLGhP7rYOsqI6EIS01xEYYUPi4kS2cPoKw_Q|JSON Connector]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbzHuaYQDFFWciKxR4MRjtTBNgd_ZytOW-WW8en0DeZ-wecqi2qLpizt2_5EF8gz32o_OQ| LinkedIn Ads]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbwTu9CcmSE0YO3ZiNGxwbjGsPOwLZUnxKCvyLldsuY-r1h4ibp9_JA5shjOKqlkEQlz| LinkedIn Pages]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbzHP_rzmYuCACkdqQBUcMNNKnB3WO4OEfQNsdrQ846n4KjaldzQxID0n_gdBW3V8ZPTdg| Mailchimp]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbwuKSHJUsFjXB_zlo0Q8XU6twkITls2wD59j7jCDZzQiAEOXk6WH5sRAxMx1gfmfHXU| Outbrain]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbyY8jAGwhRPFv9DKWsZjgAlQzeH2dalUBJexsh4oIgt5fsz-_WiuijN-_EGhC43qmUs| Pinterest Ads]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbx_-xrmC1fPIeCRdi2vDM-PcUwQ2SUCM3ZoKqWgzRuWCOwrXe26rwCaGsUZsgThf7l2CA| Quora Ads]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbxF58bxBgJcKMV5doAgNfjCL1sWkMthUGQcyvQk-QUSlSdRuQ58r6Gjfnt6bvLAV6oLWQ| RTB House]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbxCvV3wfPTmyAPgNIm8LR0HZQmDVNCyrq12dD3159P34R38GmnTNdGg-LLh0gOxTWB3| Reddit Ads]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbwh9uoXR0CRma7AoKZv38nuy23CPFKHhUjlctT1jiHoLLOP91K4fdz9hawgxpyu14Lc| Salesforce]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycby6ubudr0EmEvzD3gdqh_iOBtU-H4SHd1aG3EVCcGyASNn16NVQgqIMQwrq_cDNviqI-Q|Shopify]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbzJ_Kil7ZdF48d71G2bIxylUW_TDoB_wJWRQgr8Fsxpij-UxjfIeJiVCF-8bnOPxICT| Snapchat Ads]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbxaL5q2pgjLC6oVlBT1OuU4TKl0mkcBL8l2mAm_kGkzbAlJiNKolFr9eBYG1R2G2zbqLw| Stripe]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbyQRSmzs5TDbxC5lK_k5dEn_-mdGyxr5UiLYa7U2wypaeLh7FH5EViiDbqawYXOaVN1Ew| TikTok Ads]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbzp5qflFaVgcnUKqe2TqrbZwA7b2vvgXlJYlmXXvID2Hin_vhxZFg9Idkufg7AYuOty0g|Twitter Ads]] * [[https://datastudio.google.com/datasources/create?connectorId=AKfycbwRExOMxocJKeAmZdFdB3XLbuL04TeU89qxQO8Y_ue33lw7mDxNbHjfHHcR6Zyl9lYeQA| Zoho CRM]] === List of templates === [[https://www.windsor.ai/data-studio-template-gallery/| Windsor.ai Data Studio Template Gallery]] ====== Frequently Asked Questions ====== === I have issues blending my data from windsor.ai connectors with Google data sources === [[google_data_studio:blending_with_google_datasources|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. {{:google_data_studio:blending_error_looker_studio.png?600 |}} === I have added one data source, how do I blend in more sources? === [[Google Data Studio:Adding additional sources in Data Studio]] === How are currency conversions handled? === [[Google Data Studio:Currency conversions in Data Studio]] === How do I create a custom metric/dimension? === [[Google Data Studio:Creating a custom metric or dimension]] === Which metric should I use for media costs, media spend? === [[Google Data Studio:Metrics to use for costs and media spend in Data Studio]] === How do I compare the CPA or ROAS on Google Analytics vs. what the platform reports? === [[Google Data Studio: CPA or ROAS on Google Analytics vs. platform]] === How do I connect separate accounts to different Data Studio 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]]