Windsor_ai
Windsor_ai
  • 141
  • 102 460
Google My Business data to BigQuery
Sync Google My Business Data to BigQuery
Hi, this is Matthias from Windsor.ai. In this video, I'll show you how to sync your Google My Business data into BigQuery efficiently. Follow along as we go through the steps of accessing your accounts, selecting the desired metrics and dimensions, creating tasks, and ensuring your data is uploaded correctly. Learn how to set up schedules and even backfill historical data. Watch now to effortlessly integrate your business data with BigQuery using Windsor.ai.
00:00 Introduction to Syncing Google My Business Data
00:10 Setting Up Access and Initial Steps
00:27 Granting Google My Business Access
00:50 Selecting Metrics and Dimensions
01:14 Configuring BigQuery Destination
01:46 Finalizing and Scheduling the Upload
02:20 Verifying Data in BigQuery
02:45 Running a Backfill for Historical Data
03:10 Conclusion and Final Tips
Переглядів: 33

Відео

Google My Business data to Looker Studio in less than 2 minutes
Переглядів 67Місяць тому
In this video I'll show you how to get your Google My Business data into Looker Studio in less than 2 minutes. Topics covered: 00:00 Introduction to Google My Business Data Integration 00:20 Setting Up Looker Studio 00:30 Connecting Google My Business to Looker Studio 00:38 Authorizing and Selecting Locations 00:58 Finalizing the Connection 01:21 Customizing Your Report 01:41 Conclusion and Nex...
Google My Business data to Google Sheets
Переглядів 31Місяць тому
In this video I'll show you how to sync Google My Business data into Google Sheets in 4 minutes. Topics covered: 00:00 Intro 00:15 Checking Google My Business Access 00:33 Connecting Google My Business to Windsor.ai 00:47 Granting Access and Logging In 01:10 Previewing and Selecting Data 01:19 Setting Up Google Sheets Add-On 01:31 Configuring Data Sync in Google Sheets 02:03 Customizing Data Fi...
Google My Business data to Power BI
Переглядів 58Місяць тому
In this video I'll show you how to get Google My Business data to Power BI in less than 4 minutes. Topics covered: 00:00 Syncing Google My Business Data with Power BI 00:10 Preparing for the Sync: Access Requirements 00:34 Initial Setup: Onboarding with Windsor.ai 00:50 Granting Access to Google My Business 01:20 Selecting and Previewing Data 01:50 Syncing Data into Power BI 02:10 Building Your...
Sync Facebook Page data to Snowflake
Переглядів 9Місяць тому
In this video I'll show you how to sync Facebook Page data to Snowflake in less than 4 minutes. Topics covered: 00:00 Introduction to Syncing Facebook Page Data 00:20 Setting Up Facebook Page Access 00:57 Selecting Data Fields for Snowflake 01:26 Configuring Snowflake Destination 02:10 Verifying Data Transfer 02:42 Final Steps and Recommendations Installation: onboard.windsor.ai/ Support: suppo...
Sync Shopify data to Snowflake
Переглядів 18Місяць тому
In this video I'll show you how to set up a data sync from Shopify to Snowflake. Topics covered: 00:00 Introduction to Syncing Shopify Data with Snowflake 00:08 Setting Up Your Accounts 00:26 Connecting Shopify to Windsor.ai 00:59 Selecting and Customizing Data Fields 01:52 Scheduling Data Syncs 02:15 Verifying Data in Snowflake 02:35 Handling Multiple Objects and Backfills Installation: onboar...
Instagram data to Snowflake
Переглядів 26Місяць тому
In this video I'll show you how to connect Instagram to Snowflake in less than 3 minutes. Topics covered: 00:00 Introduction to Streaming Instagram Data 00:15 Setting Up Instagram Access 00:52 Selecting and Querying Fields 01:17 Configuring Snowflake Destination 01:46 Scheduling and Syncing Data 02:02 Verifying Data in Snowflake 02:32 Backfilling and Multiple Destinations 02:54 Conclusion and N...
Connect Google Search Console to Snowflake
Переглядів 12Місяць тому
In this video I'll show you how to set up a data sync between Search Console and Snowflake in 3 minutes. Topics covered: 00:00 Introduction to Syncing Google Search Console with Snowflake 00:16 Setting Up Google Search Console Access 00:59 Configuring Data Fields and Metrics 01:50 Scheduling and Saving the Data Transfer 02:19 Verifying Data in Snowflake 02:42 Advanced Features: Multiple Destina...
Sync Google Ads to Snowflake in less than 3 minutes
Переглядів 26Місяць тому
In this video I'll show you how to sync your Google Ads data into Snowflake in less than 3 minutes. Topics covered: 00:00 Introduction to Syncing Google Ads with Snowflake 00:09 Setting Up Your Environment 00:22 Navigating Windsor.ai Onboarding 00:40 Selecting and Previewing Google Ads Data 01:25 Configuring Snowflake Destination 01:51 Scheduling and Saving the Sync 02:06 Verifying Data in Snow...
Sync HubSpot data to Snowflake
Переглядів 35Місяць тому
In this video I'll show you how to sync HubSpot data to Snowflake in 3 minutes. Topics covered: 00:00 Introduction to Syncing HubSpot Data with Snowflake 00:08 Setting Up Your HubSpot and Snowflake Accounts 00:33 Granting HubSpot Access 01:01 Selecting and Syncing HubSpot Objects 01:36 Configuring Snowflake Destination 01:50 Scheduling and Running the Sync 02:12 Verifying Data in Snowflake 02:3...
Sync Salesforce data to Snowflake
Переглядів 54Місяць тому
In this video I'll show you how to set up a Salesforce to Snowflake sync in 3 minutes. Topics covered: 00:00 Introduction to Streaming Salesforce Data into Snowflake 00:19 Setting Up Salesforce Access 00:56 Selecting and Customizing Salesforce Fields 01:22 Configuring Snowflake as the Destination 01:49 Scheduling and Verifying Data Transfer 02:33 Backfilling and Managing Data in Snowflake 02:56...
Connect LinkedIn Pages to BigQuery
Переглядів 9Місяць тому
In this video I'll show you how to sync LinkedIn page data into Google BigQuery in less than 4 minutes. Topics covered: 00:00 Introduction and Prerequisites 00:20 Setting Up LinkedIn Connector 00:54 Previewing and Selecting Data 01:30 Configuring BigQuery Destination 02:25 Finalizing and Verifying Data Upload 02:56 Additional Options and Conclusion Installation: onboard.windsor.ai/ Support: sup...
Connect LinkedIn Ads to BigQuery in under 4 minutes
Переглядів 14Місяць тому
In this video I'll demo how to get data your LinkedIn Ads data into BigQuery in less than 4 minutes ⏳. We'll cover 00:00 Introduction to Syncing LinkedIn Ads Data 00:21 Initial Setup and Login 01:02 Previewing and Customizing Data 01:27 Configuring BigQuery Destination 02:05 Scheduling and Running the Upload 02:26 Verifying Data in BigQuery 02:55 Backfilling Historical Data 03:15 Conclusion and...
Connect Salesforce to Google Sheets (incl. custom fields/objects)
Переглядів 33Місяць тому
In this video I'll show you how to set up automated data exports from Salesforce into Google Sheets. We'll set up an hourly refresh. Custom objects and custom fields are supported. Topics covered: 00:00 Introduction and Overview 00:13 Setting Up Salesforce Access 01:04 Previewing Salesforce Data 01:22 Exporting Data to Google Sheets 01:42 Configuring Google Sheets Add-On 02:10 Building and Runn...
Cómo combinar tus datos con el conector blending de Windsor.ai
Переглядів 14Місяць тому
Acceso a Onboard onboard.windsor.ai/ Acceso a la documentación de los conectores windsor.ai/data-field/facebook/
Connect Salesforce to Looker Studio (incl. custom objects/fields) in less than 3 minute
Переглядів 103Місяць тому
Connect Salesforce to Looker Studio (incl. custom objects/fields) in less than 3 minute
Cómo configurar un reporte de Google Ads en Looker Studio con Windsor.ai
Переглядів 47Місяць тому
Cómo configurar un reporte de Google Ads en Looker Studio con Windsor.ai
Salesforce Data Integration to Power BI (including custom fields and objects) in 2 minutes.
Переглядів 112Місяць тому
Salesforce Data Integration to Power BI (including custom fields and objects) in 2 minutes.
Windsor.ai for Power BI Native connector
Переглядів 253Місяць тому
Windsor.ai for Power BI Native connector
TikTok Ads data to Power BI in less than 3 minutes
Переглядів 50Місяць тому
TikTok Ads data to Power BI in less than 3 minutes
Connecting LinkedIn Page data to Power BI in less than 4 minutes
Переглядів 79Місяць тому
Connecting LinkedIn Page data to Power BI in less than 4 minutes
LinkedIn Ads data to Power BI in less than 3 minutes
Переглядів 62Місяць тому
LinkedIn Ads data to Power BI in less than 3 minutes
Connect LinkedIn Pages to Google Sheets in less than 4 minutes
Переглядів 19Місяць тому
Connect LinkedIn Pages to Google Sheets in less than 4 minutes
TikTok Ads data to Google Sheets in less than 4 minutes
Переглядів 48Місяць тому
TikTok Ads data to Google Sheets in less than 4 minutes
TikTok Ads To Looker Studio in less than 3 minutes
Переглядів 46Місяць тому
TikTok Ads To Looker Studio in less than 3 minutes
Facebook Page Insights to Looker Studio in less than 3 minutes.
Переглядів 53Місяць тому
Facebook Page Insights to Looker Studio in less than 3 minutes.
Connect LinkedIn Pages to Looker Studio in less than 2 minutes
Переглядів 73Місяць тому
Connect LinkedIn Pages to Looker Studio in less than 2 minutes
LinkedIn Ads to Google Sheets in less than 4 minutes
Переглядів 25Місяць тому
LinkedIn Ads to Google Sheets in less than 4 minutes
Connect LinkedIn Ads to Looker Studio in less than 2 minutes
Переглядів 36Місяць тому
Connect LinkedIn Ads to Looker Studio in less than 2 minutes
Windsor.ai integración con BigQuery
Переглядів 452 місяці тому
Windsor.ai integración con BigQuery

КОМЕНТАРІ

  • @nyaa_ufall964
    @nyaa_ufall964 День тому

    sir, my ad image can't appear

  • @nicolasdelbois
    @nicolasdelbois 29 днів тому

    Amazing video, I have fund Windsor at the right moment !

  • @pedroandrade4183
    @pedroandrade4183 Місяць тому

    Does the api automatically update the data?

  • @carlossanchez0612
    @carlossanchez0612 Місяць тому

    Hola Pamela, tengo una duda, estoy haciendo una tarea para extraer datos de hubspot y llevarlos a bigquery, mi consulta es sobre las "columns to match" comentaste que puedes dejar "date" pero esa fecha es que la de creación del registro o fecha de la ultima actualización que tenga el registro?, si necestio agregar los registros nuevos pero también actualizar los que tuvieron cambio puedo incluir mas de una columna? y en el caso de los filtros del panel de la derecha como es que funcionan?

    • @windsorai
      @windsorai Місяць тому

      Hola Carlos, la columna date en Hubspot es por defecto para la ultima actualización. Si puedes agregar más de una columna. Todas las columnas disponibles están listadas acá windsor.ai/data-field/hubspot/. Respecto a los filtros. Te refieres a los filtros para configurar la query? Si es eso, se utilizan para filtrar un determinado campo. Por ejemplo si tienes campaign como columna y solo quieres campaigns que contengan "PMax"puedes usar los filtros para limitar los datos. Saludos!

  • @MattressXperts-Admin
    @MattressXperts-Admin 2 місяці тому

    Great Video! Thank You!

    • @windsorai
      @windsorai 2 місяці тому

      Glad you liked it!

  • @Raksha-ui6ky
    @Raksha-ui6ky 2 місяці тому

    This video was great. Thank you. Is there a way to get my inventory from google sheets to shopify?

    • @windsorai
      @windsorai 2 місяці тому

      Here is the field reference for inventory data windsor.ai/data-field/shopify/#order_inventory_item_cost. If what you're looking for is currently not there please create a feature request here feature-requests.windsor.ai/ and let us know what fields you need and we can add them for you.

  • @talesfernando7159
    @talesfernando7159 2 місяці тому

    the quality is bad!

    • @windsorai
      @windsorai 2 місяці тому

      Sorry to hear that. What exactly is the issue?

    • @talesfernando7159
      @talesfernando7159 2 місяці тому

      The qualitys vídeo....360p Can not see anything

  • @LautiFerrario
    @LautiFerrario 3 місяці тому

    hi, how can i add reels views?

    • @windsorai
      @windsorai 2 місяці тому

      Here's the only reels related field we currently have windsor.ai/data-field/instagram/#media_plays. Would you mind writing down what reels field you'd need here feature-requests.windsor.ai/ so that we can add them for you?

  • @dzulihsan5613
    @dzulihsan5613 3 місяці тому

    Will these data be updated real time when we log on to power BI and hit the refresh button?

    • @windsorai
      @windsorai 2 місяці тому

      In case you refer to Power BI web you can set up an automated refresh here learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh. For Power BI desktop you just click refresh and the data should be refreshed in case you use a relative date range in your query (e.g. date_preset=last7d).

  • @hameddadgour
    @hameddadgour 3 місяці тому

    Great summary. Thank you for sharing!

  • @user-vv7so9zo9s
    @user-vv7so9zo9s 4 місяці тому

    Hi, I see you choose "Select Date Range" is "Last 7 days". I want to get data range 1 year or more. But, the service spends only user paid. I try to find information about the expenses of this service but I don't see it. Can you help me with this issue How much pay for to get the data range 1 year? Thank you

    • @windsorai
      @windsorai 2 місяці тому

      Our pricing is here windsor.ai/pricing. All paid plans contain unlimited date ranges.

    • @CNW21
      @CNW21 8 днів тому

      the date range is dynamic in looker studio and irrelevant to pricing. I believe the 7 days you saw is just a data preview.

  • @JanithPathirage
    @JanithPathirage 4 місяці тому

    I can't see the Connect button. Is this allowed in the free version of Looker Studio?

    • @windsorai
      @windsorai 4 місяці тому

      It should be there yes. Can you contact us via chat on onboarding.windsor.ai so that we can help you?

  • @jamesmcmillan2178
    @jamesmcmillan2178 4 місяці тому

    This is amazing thank you saves me so much time from doing all the research myself!

    • @windsorai
      @windsorai 4 місяці тому

      Great to hear James!

  • @user-oi6hs4py3o
    @user-oi6hs4py3o 4 місяці тому

    after the connect the data, i dont have the option to 'create a report' automatically, do you know why?

    • @windsorai
      @windsorai 4 місяці тому

      could you contact us via chat on our website so the we can help?

  • @mitch5020
    @mitch5020 4 місяці тому

    that was easy

  • @vidyuthnair
    @vidyuthnair 5 місяців тому

    How do I add leads from my lead form in FB Ads Campaign to populate into excel?

    • @windsorai
      @windsorai 5 місяців тому

      you would need to use our Facebook leads connector to do this.

    • @vidyuthnair
      @vidyuthnair 5 місяців тому

      @@windsorai Thanks for that. Where can I find the connector option to set up? Its not under the facebook ads or facebook leads option in the "Add Data" step.

    • @windsorai
      @windsorai 4 місяці тому

      @@vidyuthnair onboard.windsor.ai/app/facebook_leads it would be here

  • @ayeshabintehabib5448
    @ayeshabintehabib5448 5 місяців тому

    But by using this I will get the data of the days already passed, what if I want the data to be updated in real time? Can it be done using windsor?

    • @windsorai
      @windsorai 5 місяців тому

      Yes, historical data can be loaded. With other connectors real time data is possible but search console has a 3 day delay for reporting so for SC the answer is no because Google does not allow it.

  • @K-K9-MN
    @K-K9-MN 5 місяців тому

    This is a nice high-level discussion. Would love to see a deeper dive into the Python code and interpretation of both MMM and Markov MTA.

    • @windsorai
      @windsorai 5 місяців тому

      Will definitely keep that in mind and reply once we have it live here on YT.

  • @rafermocil959
    @rafermocil959 6 місяців тому

    how to create a report for multiple clients in just one report?

    • @windsorai
      @windsorai 5 місяців тому

      You just select multiple accounts while installing the connector in Looker Studio and then all of the acccounts will be in your report.

  • @ibrahimcalskan6458
    @ibrahimcalskan6458 7 місяців тому

    0:21 Avanco Social é o melhor para comprar seguidores para tiktok e facebook

  • @sumitmathur6800
    @sumitmathur6800 7 місяців тому

    Could you help me to connect with Amazon seller central with power bi

    • @windsorai
      @windsorai 7 місяців тому

      sure. you can book a meeting here calendly.com/windsorai/guided-onboarding

  • @mcdoo58
    @mcdoo58 7 місяців тому

    What's the solution for this?

    • @windsorai
      @windsorai Місяць тому

      The solution is to get 1 source of truth. You can set up a report with a third-party tool where you join your raw data and run an attribution model. windsor.ai/attribution-modelling-software/

  • @user-jk7fk9yn3n
    @user-jk7fk9yn3n 7 місяців тому

    hi this works but is there way to optimize the speed of how reporting data is generated? I noticed a very long delay whenever i modify the metrics and dimensons

    • @windsorai
      @windsorai 7 місяців тому

      The Shopify API is throttling requests. This makes the dashboard slow when you query a new combination of fields for the first time. On subsequent runs its faster as its then cached.

  • @freedom-online-2023
    @freedom-online-2023 8 місяців тому

    Could you please show this on the new GA4 Property... Because the Analytics (UA) Old version is not available now.

    • @windsorai
      @windsorai 8 місяців тому

      this should be covered here windsor.ai/preparing-your-google-analytics-4-account-for-multitouch-attribution/

    • @freedom-online-2023
      @freedom-online-2023 8 місяців тому

      thanks a lot 🙂@@windsorai

  • @freedom-online-2023
    @freedom-online-2023 8 місяців тому

    Thank you, Thank you, Thank you so much..........

  • @princebritwum9781
    @princebritwum9781 Рік тому

    is there a way to refresh the data automatically or you will need to do this each time you want to see new results?

    • @simonmartin7114
      @simonmartin7114 4 місяці тому

      Have the same question! Did you find your answer?

  • @about-robots8920
    @about-robots8920 Рік тому

    is the data will updated automatically or should i repet the same process for new data

  • @povyang7935
    @povyang7935 Рік тому

    111111111111p

  • @vaschmir
    @vaschmir Рік тому

    Hi Sir Matias, just wanted to ask, if a parameter is configure in such way (6:22) what will happen to the previous data? Thanks :)

    • @windsorai
      @windsorai Рік тому

      It will be replaced with the newly selected date range.

  • @crch6141
    @crch6141 Рік тому

    COOL!!! THANK YOU

  • @LorenaGarcia-ml3vz
    @LorenaGarcia-ml3vz Рік тому

    How do you remove access to certain accounts you no longer want to connect to?

    • @windsorai
      @windsorai Рік тому

      You would need to remove access in the data source. LinkedIn > Privacy would be where to remove access.

  • @AllenChen-ro5mw
    @AllenChen-ro5mw Рік тому

    Can I pull API names instead of the field names appear in Salesforce?

    • @windsorai
      @windsorai Рік тому

      Yes, more information here wiki.windsor.ai/salesforce

  • @kbeltran100
    @kbeltran100 Рік тому

    excellent ! thanks for share !

  • @chapterme
    @chapterme Рік тому

    Chapters (Powered by ChapterMe) - 00:00 - Introduction 01:50 - Agenda 02:23 - Project goal 03:40 - Challenges to be addressed 07:08 - Vendor selection process 10:10 - Implementation process 12:05 - Transformations 15:00 - Final output of the product 19:13 - Recommendations / Lessons learned 22:54 - Q&A 23:21 - What resources would you recommend reading when building these Power BI dashboards?

  • @AniAnu835
    @AniAnu835 2 роки тому

    can u explan through api

  • @agungsukariman
    @agungsukariman 2 роки тому

    Thank you!!

  • @JarosawTabor
    @JarosawTabor 2 роки тому

    This was a blast. Than you and looking for more Python tricks not only about the SEM.

    • @windsorai
      @windsorai 2 роки тому

      Thanks. Glad that you liked it!

  • @ALOAKBJAWALI
    @ALOAKBJAWALI 2 роки тому

    👍

  • @shunmax
    @shunmax 2 роки тому

    Just wow

  • @truelightl
    @truelightl 2 роки тому

    anyvideo showing how to tracking CIR for all channels to know which channel we should spend money on?

  • @sufiyanshaikh1272
    @sufiyanshaikh1272 2 роки тому

    It was a amazing session

  • @debrajpaul1349
    @debrajpaul1349 2 роки тому

    Hi would like to contact you

  • @mattiasarfati8134
    @mattiasarfati8134 3 роки тому

    Hello, thanks for the video, I do have a question :) I've connected Google Ads, Facebook Ads, Criteo, GA, Tiktok and Pinterest with my Ad Data connector, but I'm not able to find the right metrics for the right channel. Is there any way to easily find that ?

    • @windsorai
      @windsorai 3 роки тому

      Thanks for the question. Yes, there is a way: Check out this link here www.windsor.ai/connector/attribution-connector/. It contains a list with more details about the different fields.

  • @jyotimatripathi6066
    @jyotimatripathi6066 3 роки тому

    if i am hitting the export data url on browser then it is showing {"error": "This endpoint requires the datasource test_attributions_and_costs, database or `all_datasource_access` permission", "stacktrace": null} And if run by curl script it is showing Internal Server Error. Please suggest any solution

    • @windsorai
      @windsorai 3 роки тому

      This means that you are trying to load the demo data set instead of your own data set. Can you try and create a fresh URL when you are logged in with your data set?

    • @jyotimatripathi6066
      @jyotimatripathi6066 3 роки тому

      @@windsorai : If I am logged in then export URL is working fine otherwise it is showing error. I think that's why you mentioned this step done manually. for automated process we have to use API URL with attribution name.. AM I right??

    • @windsorai
      @windsorai 3 роки тому

      You can actually also use the link from charts.windsor.ai but you would probably need to check if there are any redirect info which should be removed before loading the data. You can do so with curl -v [your url].