Accessing any fields from your marketing platforms for your data pipelines

Accessing any fields from your marketing platforms for your data pipelines

Automate your data pipelines with Windsor.ai

Extract your marketing data and stream it into Looker Studio, Power BI, Tableau, Google BigQuery, Snowflake, Amazon S3, MySQL, PostgreSQL, Google Sheets, Python, Azure MS SQL, Azure Blob Storage, or Excel.

  1. With just a few clicks you can connect to any of the 75+ supported data sets and sources.
  2. Select the output dimensions of your choice (custom output formats accessible for Power BI, Tableau, and Qlik, JSON, CSV) and elect the metrics and aspects you want to abstract from data source.
  3. Once the query has been created, your marketing data is ready to be adjusted into your BI tool, database, or spreadsheet tool.

 

Are you interested in very specific metrics and dimensions from your marketing platforms?

This article will help you: it guides you how to get your data stream in the format you want. Currently, we support more than 3000 dimensions and metrics.

Our most used connector Facebook Ads for example offers more than 300 metrics and dimensions to choose from. For Google Ads, it looks similar.If you are in luck and have a CRM system which is easy to integrate with a cloud data pipeline software like ours, you can start blending the data between marketing, advertising and your CRM.

In case you would like to know what other customers are building using our platform I suggest having a look at our Marketing Template gallery. This should give you some inspiration of the possibilities on data visualization.

 

You might also be interested in…

 

Connecting your data

As first step you need to connect your data. Click on the button below and configure your data sources. A complete documentation on what fields are available from what platforms can be found below.

Create Windsor.ai user account / Connect data to existing account

After connecting your data you now can get started with creating API queries to get the data you want into your destination.

 

Getting started

A quick overview of how it works: Sample API URL

https://connectors.windsor.ai/all?api_key=[your API key]&date_preset=last_7d&fields=source,medium,campaign,clicks,impressions,spend,date&_renderer=csv

 

The query here contains:

  • A connector /all: Here the connector is called all. This connector blends data from all sources (see Attribution connector below)
  • A date preset date_preset=last_7d: The last 7 days. Can be 3, 7, 14, 28,30 and 90 days.
  • A list of fields: source, medium, campaign, clicks, impressions, spend and date
  • A renderer: In this case we would like the output to be a CSV.

 

Additional query parameters

  • date_to, in combination with date_from it will allows you to query a specific date range
  • Removing _renderer=csvwill return a JSON file instead (useful when working with nested data
  • Adding &force_refresh=true will bypass caching and fetch fresh data every time the endpoint is called

 

Example URL with fixed dates:

https://connectors.windsor.ai/all?api_key=[your API key]&date_from=2021-01-29&date_to=2021-01-30&fields=source,medium,campaign,clicks,impressions,spend,date&_renderer=csv

 

Connector Directory

Attribution Connector

favicon 310

 

 

Sample API query
This connector as previously mentioned blends all data from the platforms you have connected. If you run a query, it returns a pre-blended data stream. This makes it very easy to get started.
https://connectors.windsor.ai/all?api_key=[your API key]&date_from=2020-10-19&fields=source,medium,campaign,clicks,impressions,spend,date&_renderer=csv
The available fields for the super connector are:

  • date
  • source
  • medium
  • campaign
  • impressions
  • clicks
  • spend

 

In case you have a Google Analytics data set connected the super connector also allows you to query these additional fields:

  • transactions
  • transactionrevenue

 

Fields

IDNameConnector NameConnectors Description
IIII