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 - RU-vid - 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
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!
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.
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?
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).
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 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.
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.
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.
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?
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 ?
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.