- Видео 172
- Просмотров 134 145
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
Custom fields in Windsor.ai
How to Use Custom Fields in Windsor.ai
Introduction our custom fields feature, allowing users to create their own metrics and dimensions.
We cover 2 scenarios: creating a custom channel or campaign grouping, and combining link clicks from Facebook ads with clicks from Google ads.
Learn how to use these custom fields in data destinations like Looker Studio, Google Sheets, BigQuery, and more. Share your feedback and enjoy the new feature!
Example 1:
The formula for the campaign grouping field is
```
if(
'Japan' in campaign or 'APAC' in campaign, 'APAC',
if('UK' in campaign or 'FR' in campaign, 'EUROPE', 'other')
)
```
Example 2:
The formula for the clicks2 field is:
```
float(link_clicks)
```
Facebook Ads...
Introduction our custom fields feature, allowing users to create their own metrics and dimensions.
We cover 2 scenarios: creating a custom channel or campaign grouping, and combining link clicks from Facebook ads with clicks from Google ads.
Learn how to use these custom fields in data destinations like Looker Studio, Google Sheets, BigQuery, and more. Share your feedback and enjoy the new feature!
Example 1:
The formula for the campaign grouping field is
```
if(
'Japan' in campaign or 'APAC' in campaign, 'APAC',
if('UK' in campaign or 'FR' in campaign, 'EUROPE', 'other')
)
```
Example 2:
The formula for the clicks2 field is:
```
float(link_clicks)
```
Facebook Ads...
Просмотров: 120
Видео
How to set up marketing data pipelines for agencies
Просмотров 1012 месяца назад
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...
Google Ads to Power BI (Native Connector)
Просмотров 1873 месяца назад
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)
Просмотров 2913 месяца назад
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
Просмотров 7333 месяца назад
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
Просмотров 3394 месяца назад
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
Просмотров 234 месяца назад
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
Просмотров 394 месяца назад
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
Просмотров 474 месяца назад
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
Просмотров 264 месяца назад
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
Просмотров 934 месяца назад
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
Просмотров 864 месяца назад
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
Просмотров 434 месяца назад
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
Просмотров 594 месяца назад
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
Просмотров 1304 месяца назад
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
Просмотров 4494 месяца назад
Facebook Ads to Looker Studio in less than 3 minutes
Search Console to Looker Studio in 2 minutes
Просмотров 1214 месяца назад
Search Console to Looker Studio in 2 minutes
Google Ads to Looker Studio in 2 minutes
Просмотров 1454 месяца назад
Google Ads to Looker Studio in 2 minutes
Google Analytics 4 to Looker Studio in 2 minutes
Просмотров 814 месяца назад
Google Analytics 4 to Looker Studio in 2 minutes
Google Analytics 4 (GA4) to BigQuery in less than 3 minutes
Просмотров 824 месяца назад
Google Analytics 4 (GA4) to BigQuery in less than 3 minutes
Connect Salesforce to BigQuery in less than 3 minutes
Просмотров 1954 месяца назад
Connect Salesforce to BigQuery in less than 3 minutes
Connect Google Ads to Google Sheets in less than 3 minutes
Просмотров 1574 месяца назад
Connect Google Ads to Google Sheets in less than 3 minutes
Connect Microsoft Bing Ads to Google Sheets in less than 3 minutes
Просмотров 534 месяца назад
Connect Microsoft Bing Ads to Google Sheets in less than 3 minutes
Connect Microsoft Ads to Looker Studio in 2 minutes
Просмотров 2784 месяца назад
Connect Microsoft Ads to Looker Studio in 2 minutes
Syncing Google Ads to BigQuery in less than 4 minutes
Просмотров 4294 месяца назад
Syncing Google Ads to BigQuery in less than 4 minutes
Connect Google Analytics 4 (GA4) to Google Sheets in 3 minutes
Просмотров 645 месяцев назад
Connect Google Analytics 4 (GA4) to Google Sheets in 3 minutes
Sync YouTube Analytics to Snowflake in less than 3 minutes
Просмотров 935 месяцев назад
Sync RUclips Analytics to Snowflake in less than 3 minutes
Connect YouTube Analytics to Looker Studio in less than 2 minutes
Просмотров 2675 месяцев назад
Connect RUclips Analytics to Looker Studio in less than 2 minutes
YouTube Analytics to Google Sheets in 3 minutes
Просмотров 1845 месяцев назад
RUclips Analytics to Google Sheets in 3 minutes
YouTube Analytics to BigQuery in 3 minutes
Просмотров 1375 месяцев назад
RUclips Analytics to BigQuery in 3 minutes
I don't see any of my conversions API fields when importing the list. How do I get those to load in?
Currently conversion API fields are only supported if you load them via custom conversions.
@@windsorai Good to know, thanks for the reply!
Some alternative free? I wanna import all the fields.
There is a free forever plan.
This Instruction is good for paid subscriptions. If the free period is limited to 9 fields. That is, you can't try if it's true until you buy a subscription.
The free forever plan supports only 9 fields in the data preview. If you use the native Windsor connector in Power BI you can add additional fields within Power BI desktop so you are not constrained to the 9 field limit. Hope this helps!
How to do it in we version if Im using mac
There is no Power BI desktop on Mac. You’ll need to run it via Paralkels or UTM mac.getutm.app
Obrigado
De nada
is it free?
Yes there is a free version
Thank you for the video! Could you please explain if we can use windsor for connecting UberEats or Doordash merchant platforms to Power BI?
We don’t have connectors for UberEats and Doordash at the moment I’m afraid.
@@windsorai Thanks for the response.
@@azharkudaibergenova116 you're welcome.You could request the features here feature-requests.windsor.ai/ and we'll do our best to get them onto our roadmap.
Excelente mil gracias
De nada
Cost?
Starts at $19/month
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?
@@simonmartin7114 automatic updates can be scheduled on the tableau server
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