
- Видео 171
- Просмотров 119 636
Windsor_ai
Швейцария
Добавлен 24 апр 2020
Simplify your data pipelines with Windsor.ai.
Our platform helps to stream data to your preferred analytics, reporting, and data warehouse platforms, with support for over 300 data sources.
More than 300k marketers and data analysts use us.
Data sources include:
- Google Analytics
- Google Ads
- Meta Ads/Facebook Ads
- Facebook Page Insights
- Instagram Insights
- HubSpot
- Shopify
- Salesforce CRM, Pardot, Salesforce Marketing Cloud
- TikTok ads
- Google Search Consoles
- LinkedIn Ads
- LinkedIn Pages
- RUclips
- Google My Business
Our destinations include:
- Microsoft Power BI
- Google Looker Studio
- Tableau
- Google BigQuery
- Amazon S3
- Snowflake
- Azure SQL
- Amazon Redshift
- PostgreSQL
- MySQL
- Google Sheets
- Microsoft Excel
- Python
- R
Our platform helps to stream data to your preferred analytics, reporting, and data warehouse platforms, with support for over 300 data sources.
More than 300k marketers and data analysts use us.
Data sources include:
- Google Analytics
- Google Ads
- Meta Ads/Facebook Ads
- Facebook Page Insights
- Instagram Insights
- HubSpot
- Shopify
- Salesforce CRM, Pardot, Salesforce Marketing Cloud
- TikTok ads
- Google Search Consoles
- LinkedIn Ads
- LinkedIn Pages
- RUclips
- Google My Business
Our destinations include:
- Microsoft Power BI
- Google Looker Studio
- Tableau
- Google BigQuery
- Amazon S3
- Snowflake
- Azure SQL
- Amazon Redshift
- PostgreSQL
- MySQL
- Google Sheets
- Microsoft Excel
- Python
- R
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/
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
Good solution, thanks
Cost?
Starts at $19/month
I synced for 5 minutes, thanks
Great to hear!
Thanks for price table, all i need for alternative it is price comparison
Glad to hear that it is useful!
Thanks, it works
Great to hear!
BigQuery better than Azur MSL, thanks i will use
nice
Thanks
Thanks, it helped
very interesting
Glad you think so!
Update: You can now also use Windsor.ai's native connector in Power BI: learn.microsoft.com/en-us/power-query/connectors/windsor
Update: You can now also use Windsor.ai's native connector in Power BI: learn.microsoft.com/en-us/power-query/connectors/windsor
Is this free or paid?
Its free if you use one connector with one account. There are also paid plans.
sir, my ad image can't appear
Could you ping us via support chat so we can help you check?
Amazing video, I have fund Windsor at the right moment !
Great to hear!
Does the api automatically update the data?
Yes, it does
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?
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!
Great Video! Thank You!
Glad you liked it!
This video was great. Thank you. Is there a way to get my inventory from google sheets to shopify?
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.
the quality is bad!
Sorry to hear that. What exactly is the issue?
The qualitys vídeo....360p Can not see anything
hi, how can i add reels views?
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?
Will these data be updated real time when we log on to power BI and hit the refresh button?
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).
Great summary. Thank you for sharing!
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
Our pricing is here windsor.ai/pricing. All paid plans contain unlimited date ranges.
the date range is dynamic in looker studio and irrelevant to pricing. I believe the 7 days you saw is just a data preview.
I can't see the Connect button. Is this allowed in the free version of Looker Studio?
It should be there yes. Can you contact us via chat on onboarding.windsor.ai so that we can help you?
This is amazing thank you saves me so much time from doing all the research myself!
Great to hear James!
after the connect the data, i dont have the option to 'create a report' automatically, do you know why?
could you contact us via chat on our website so the we can help?
that was easy
great to hear!
How do I add leads from my lead form in FB Ads Campaign to populate into excel?
you would need to use our Facebook leads connector to do this.
@@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.
@@vidyuthnair onboard.windsor.ai/app/facebook_leads it would be here
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?
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.
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.
Will definitely keep that in mind and reply once we have it live here on YT.
how to create a report for multiple clients in just one report?
You just select multiple accounts while installing the connector in Looker Studio and then all of the acccounts will be in your report.
Could you help me to connect with Amazon seller central with power bi
sure. you can book a meeting here calendly.com/windsorai/guided-onboarding
What's the solution for this?
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/
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
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.
Could you please show this on the new GA4 Property... Because the Analytics (UA) Old version is not available now.
this should be covered here windsor.ai/preparing-your-google-analytics-4-account-for-multitouch-attribution/
thanks a lot 🙂@@windsorai
Thank you, Thank you, Thank you so much..........
is there a way to refresh the data automatically or you will need to do this each time you want to see new results?
Have the same question! Did you find your answer?
is the data will updated automatically or should i repet the same process for new data
111111111111p
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 :)
It will be replaced with the newly selected date range.
COOL!!! THANK YOU
How do you remove access to certain accounts you no longer want to connect to?
You would need to remove access in the data source. LinkedIn > Privacy would be where to remove access.
Can I pull API names instead of the field names appear in Salesforce?
Yes, more information here wiki.windsor.ai/salesforce
excellent ! thanks for share !
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?
can u explan through api
Thank you!!
You're welcome!
This was a blast. Than you and looking for more Python tricks not only about the SEM.
Thanks. Glad that you liked it!
👍
Just wow