Windsor_ai
Windsor_ai
  • Видео 171
  • Просмотров 119 636
How to set up marketing data pipelines for agencies
Matthias from Windsor explains how marketing agencies can structure data pipelines efficiently. Learn to consolidate data from multiple accounts using tools like BigQuery and Snowflake, create unified tables, and join data for analysis. Additionally, discover tips for working with CRM data and integrating with BI tools like Looker Studio or Power BI.
00:00 Introduction and Purpose
00:32 Setting Up Data Dumps
01:01 Creating Unified Tables
01:45 Joining Data for Analysis
02:36 Filtering and Visualizing Data
03:16 Working with CRM Data
04:20 Conclusion and Contact Information
Set up your data pipelines here: onboard.windsor.ai/
Просмотров: 6

Видео

Google Ads to Power BI (Native Connector)
Просмотров 92Месяц назад
Connect Google Ads to Power BI in 2 Minutes with Windsor.ai In this video, Matthias from Windsor.ai shows you how to effortlessly connect Google Ads to Power BI using Windsor.ai's native Power BI connector. Follow the steps to sign in, select your Google Ads accounts, preview and save your query, and load the data into Power BI. Enhance your dashboard with pre-built templates to streamline your...
Connect Facebook Ads to Power BI (Native Connector)
Просмотров 136Месяц назад
Connect Facebook Ads to Power BI in 2 Minutes | Windsor.ai Tutorial Hi, this is Matthias from Windsor. And today I show you how to get Facebook ads data into Power BI. Let's get started. As a first step, you head to onboard.windsor.ai and click on Facebook ads. Then click on grant Facebook ads access. Once you're done granting Facebook ads access, select the accounts you want to connect. Then c...
Windsor.ai for Power BI Native Connector
Просмотров 316Месяц назад
Connecting Facebook Ads Data to Power BI Using Windsor.ai In this tutorial, Matthias from Windsor demonstrates how to use the Windsor.ai native connector to import Facebook Ads data into Power BI. He guides you through the steps to select data sources, create and save queries, and load the data into Power BI. Matthias also highlights the convenience of using Windsor.ai's template gallery for a ...
Facebook Ads a Power BI en menos de 4 minutos
Просмотров 145Месяц назад
Conectar Facebook Ads a Power BI en Menos de 4 Minutos En este video, Pamela de windsor.ai te muestra cómo utilizar el conector nativo de Windsor para integrar datos de anuncios de Facebook con Power BI. A través de una demostración paso a paso, Pamela explica cómo autorizar y seleccionar cuentas, validar datos y configurar métricas y dimensiones. También cubre cómo exportar y manipular estos d...
Google Search Console to Azure SQL in 2 minutes
Просмотров 18Месяц назад
This is a video about Google Search Console to Azure SQL in 2 minutes 00:00 Introduction and Prerequisites 00:16 Connecting Google Search Console to Windsor 00:39 Configuring Data Fields and Azure SQL 01:18 Setting Up Data Upload Schedule 01:51 Final Steps and Verification 02:13 Exploring Additional Connectors
Facebook Ads to Azure SQL in 2 minutes
Просмотров 23Месяц назад
This is a video about Facebook Ads to Azure SQL in 2 minutes 00:00 Introduction and Setup Requirements 00:15 Connecting Facebook Ads to Windsor.ai 00:38 Selecting and Customizing Data Fields 01:01 Configuring AzureSQL Destination 01:23 Scheduling and Finalizing Data Sync 01:58 Verifying Data in AzureSQL 02:21 Conclusion and Additional Tips
Bing Ads to Azure SQL in 2 minutes
Просмотров 29Месяц назад
This is a video about Bing Ads to Azure SQL in 2 minutes 00:00 Introduction and Prerequisites 00:17 Onboarding to Windsor.ai 00:29 Granting Access to Microsoft Ads 00:45 Configuring Data Stream to Azure SQL 01:21 Setting Up Data Refresh Schedule 01:35 Table Creation and Data Backfill 01:54 Verifying Data in Azure SQL 02:19 Additional Tips and Conclusion
Instagram to Azure SQL in 2 minutes
Просмотров 19Месяц назад
This is a video about Instagram to Azure SQL in 2 minutes 00:00 Introduction and Prerequisites 00:20 Onboarding to Windsor.ai 00:28 Granting Instagram Access 00:40 Previewing and Selecting Data 01:04 Setting Up Azure SQL Destination 01:31 Scheduling and Backfilling Data 02:12 Verifying Data in Azure SQL 02:32 Final Recommendations and Conclusion
Google Ads to Azure SQL in 3 minutes
Просмотров 49Месяц назад
This is a video about Google Ads to Azure SQL in 3 minutes 00:00 Introduction and Prerequisites 00:16 Setting Up Google Ads Account 00:47 Selecting Metrics and Dimensions 01:17 Configuring AzureSQL Destination 01:56 Scheduling and Backfilling Data 02:29 Verifying Data in AzureSQL 02:53 Conclusion and Next Steps
TikTok Organic to Looker Studio in 2 minutes
Просмотров 42Месяц назад
This is a video about TikTok Organic to Looker Studio 00:00 Introduction and Prerequisites 00:13 Setting Up Looker Studio 00:33 Authorizing TikTok Access 01:00 Connecting TikTok Accounts 01:32 Customizing Your Report 01:42 Metrics and Final Tips
Tiktok Organic to BigQuery in less than 3 minutes
Просмотров 23Месяц назад
This is a video about Tiktok Organic to BigQuery in less than 3 minutes 00:00 Introduction and Prerequisites 00:12 Setting Up Windsor.ai for TikTok Organic Data 00:20 Granting Access to TikTok Organic 00:35 Previewing the data 01:05 Configuring Data Transfer to BigQuery 01:40 Scheduling and Final Steps 02:15 Verifying Data in BigQuery 02:37 Conclusion and Next Steps
Tiktok Organic to Power BI in less than 3 minutes
Просмотров 35Месяц назад
This is a video about Tiktok Organic to Power BI 00:00 Introduction and Setup Requirements 00:14 Accessing TikTok Organic Data 00:32 Configuring Data Sync 00:57 Exporting Data to Power BI 01:43 Loading and Visualizing Data in Power BI 02:17 Conclusion
Tiktok Organic to Google Sheets in less than 3 minutes
Просмотров 462 месяца назад
How to Import TikTok Organic Data into Google Sheets Matthias from Windsor demonstrates a step-by-step process on how to import TikTok organic data into Google Sheets. This tutorial covers accessing TikTok organic account, logging into onboard.windsor.ai, selecting the TikTok organic data source, and configuring the Google Sheets add-on by inputting an API key. Matthias also shows how to set up...
Facebook Ads to Looker Studio in less than 3 minutes
Просмотров 2312 месяца назад
Quick Tutorial: Connect Facebook Ads to Looker Studio Learn how to connect Facebook ads data to Looker Studio efficiently. In this tutorial by Matthias from Windsor, follow step-by-step instructions to authorize accounts, select data sources, and customize reports. Check out our template gallery for a quick start. 00:00 Introduction to Connecting Facebook Ads to Looker Studio 00:20 Setting Up L...
Search Console to Looker Studio in 2 minutes
Просмотров 402 месяца назад
Search Console to Looker Studio in 2 minutes
Google Ads to Looker Studio in 2 minutes
Просмотров 572 месяца назад
Google Ads to Looker Studio in 2 minutes
Google Analytics 4 to Looker Studio in 2 minutes
Просмотров 332 месяца назад
Google Analytics 4 to Looker Studio in 2 minutes
Google Analytics 4 (GA4) to BigQuery in less than 3 minutes
Просмотров 512 месяца назад
Google Analytics 4 (GA4) to BigQuery in less than 3 minutes
Connect Salesforce to BigQuery in less than 3 minutes
Просмотров 1092 месяца назад
Connect Salesforce to BigQuery in less than 3 minutes
Connect Google Ads to Google Sheets in less than 3 minutes
Просмотров 732 месяца назад
Connect Google Ads to Google Sheets in less than 3 minutes
Connect Microsoft Bing Ads to Google Sheets in less than 3 minutes
Просмотров 282 месяца назад
Connect Microsoft Bing Ads to Google Sheets in less than 3 minutes
Connect Microsoft Ads to Looker Studio in 2 minutes
Просмотров 1302 месяца назад
Connect Microsoft Ads to Looker Studio in 2 minutes
Syncing Google Ads to BigQuery in less than 4 minutes
Просмотров 2092 месяца назад
Syncing Google Ads to BigQuery in less than 4 minutes
Connect Google Analytics 4 (GA4) to Google Sheets in 3 minutes
Просмотров 312 месяца назад
Connect Google Analytics 4 (GA4) to Google Sheets in 3 minutes
Sync YouTube Analytics to Snowflake in less than 3 minutes
Просмотров 822 месяца назад
Sync RUclips Analytics to Snowflake in less than 3 minutes
Connect YouTube Analytics to Looker Studio in less than 2 minutes
Просмотров 1572 месяца назад
Connect RUclips Analytics to Looker Studio in less than 2 minutes
YouTube Analytics to Google Sheets in 3 minutes
Просмотров 1032 месяца назад
RUclips Analytics to Google Sheets in 3 minutes
YouTube Analytics to BigQuery in 3 minutes
Просмотров 882 месяца назад
RUclips Analytics to BigQuery in 3 minutes
YouTube Analytics to Power BI in 3 minutes
Просмотров 1392 месяца назад
RUclips Analytics to Power BI in 3 minutes

Комментарии

  • @Sergiikosan
    @Sergiikosan 3 часа назад

    Good solution, thanks

  • @Bruhfinally
    @Bruhfinally 11 дней назад

    Cost?

    • @windsorai
      @windsorai 10 дней назад

      Starts at $19/month

  • @Sergiikosan
    @Sergiikosan 28 дней назад

    I synced for 5 minutes, thanks

  • @Sergiikosan
    @Sergiikosan 28 дней назад

    Thanks for price table, all i need for alternative it is price comparison

    • @windsorai
      @windsorai 25 дней назад

      Glad to hear that it is useful!

  • @Sergiikosan
    @Sergiikosan Месяц назад

    Thanks, it works

  • @Sergiikosan
    @Sergiikosan 2 месяца назад

    BigQuery better than Azur MSL, thanks i will use

  • @Sergiikosan
    @Sergiikosan 2 месяца назад

    nice

  • @Sergiikosan
    @Sergiikosan 2 месяца назад

    Thanks, it helped

  • @Sergiikosan
    @Sergiikosan 2 месяца назад

    very interesting

    • @windsorai
      @windsorai 2 месяца назад

      Glad you think so!

  • @windsorai
    @windsorai 2 месяца назад

    Update: You can now also use Windsor.ai's native connector in Power BI: learn.microsoft.com/en-us/power-query/connectors/windsor

  • @windsorai
    @windsorai 2 месяца назад

    Update: You can now also use Windsor.ai's native connector in Power BI: learn.microsoft.com/en-us/power-query/connectors/windsor

  • @sagar-z1i
    @sagar-z1i 2 месяца назад

    Is this free or paid?

    • @windsorai
      @windsorai 2 месяца назад

      Its free if you use one connector with one account. There are also paid plans.

  • @nyaa_ufall964
    @nyaa_ufall964 3 месяца назад

    sir, my ad image can't appear

    • @windsorai
      @windsorai 2 месяца назад

      Could you ping us via support chat so we can help you check?

  • @nicolasdelbois
    @nicolasdelbois 3 месяца назад

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

    • @windsorai
      @windsorai 3 месяца назад

      Great to hear!

  • @pedroandrade4183
    @pedroandrade4183 4 месяца назад

    Does the api automatically update the data?

  • @carlossanchez0612
    @carlossanchez0612 4 месяца назад

    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 4 месяца назад

      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 5 месяцев назад

    Great Video! Thank You!

    • @windsorai
      @windsorai 5 месяцев назад

      Glad you liked it!

  • @Raksha-ui6ky
    @Raksha-ui6ky 5 месяцев назад

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

    • @windsorai
      @windsorai 5 месяцев назад

      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 5 месяцев назад

    the quality is bad!

    • @windsorai
      @windsorai 5 месяцев назад

      Sorry to hear that. What exactly is the issue?

    • @talesfernando7159
      @talesfernando7159 5 месяцев назад

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

  • @LautiFerrario
    @LautiFerrario 5 месяцев назад

    hi, how can i add reels views?

    • @windsorai
      @windsorai 5 месяцев назад

      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 6 месяцев назад

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

    • @windsorai
      @windsorai 5 месяцев назад

      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 6 месяцев назад

    Great summary. Thank you for sharing!

  • @VyĐặngThịTường-i3m
    @VyĐặngThịTường-i3m 6 месяцев назад

    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 5 месяцев назад

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

    • @CNW21
      @CNW21 3 месяца назад

      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 7 месяцев назад

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

    • @windsorai
      @windsorai 7 месяцев назад

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

  • @jamesmcmillan2178
    @jamesmcmillan2178 7 месяцев назад

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

    • @windsorai
      @windsorai 7 месяцев назад

      Great to hear James!

  • @ManolisVryonakis
    @ManolisVryonakis 7 месяцев назад

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

    • @windsorai
      @windsorai 7 месяцев назад

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

  • @mitch5020
    @mitch5020 7 месяцев назад

    that was easy

    • @windsorai
      @windsorai 7 месяцев назад

      great to hear!

  • @vidyuthnair
    @vidyuthnair 8 месяцев назад

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

    • @windsorai
      @windsorai 8 месяцев назад

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

    • @vidyuthnair
      @vidyuthnair 7 месяцев назад

      @@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 7 месяцев назад

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

  • @ayeshabintehabib5448
    @ayeshabintehabib5448 8 месяцев назад

    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 8 месяцев назад

      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.

  • @MN-Unicorn
    @MN-Unicorn 8 месяцев назад

    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 8 месяцев назад

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

  • @rafermocil959
    @rafermocil959 9 месяцев назад

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

    • @windsorai
      @windsorai 8 месяцев назад

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

  • @sumitmathur6800
    @sumitmathur6800 10 месяцев назад

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

    • @windsorai
      @windsorai 10 месяцев назад

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

  • @mcdoo58
    @mcdoo58 10 месяцев назад

    What's the solution for this?

    • @windsorai
      @windsorai 4 месяца назад

      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/

  • @eugenegalang-q8f
    @eugenegalang-q8f 10 месяцев назад

    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 10 месяцев назад

      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 10 месяцев назад

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

    • @windsorai
      @windsorai 10 месяцев назад

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

    • @freedom-online-2023
      @freedom-online-2023 10 месяцев назад

      thanks a lot 🙂@@windsorai

  • @freedom-online-2023
    @freedom-online-2023 10 месяцев назад

    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 7 месяцев назад

      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 2 года назад

    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