How to get your Analytics, CRM and Media Data into Tableau

crm analytics ad data to tableau

Tableau is widely used for data visualization. To get your GA4, Facebook Ads, Google Ads, Bing Ads, LinkedIn Ads to Tableau is easy. Depending on your set up you work with a set of spreadsheets or database tables. Using a service like what I describe below is a good alternative to get started fast and have the whole process automated.

With the connector below you can easily get all your data from:

 

into Tableau. The actual list of channels is longer (and growing) and can be found here: Tableau Data Connectors 

Let’s get started. The process will take a few steps:

 

  1. Connecting your data
  2. Importing data into Tableau using a Web Data Connector

 

It’s important that before you start that you have access (to authorise apps) on all the platforms you wish to integrate. You should also have Tableau Desktop installed. No programming skills are required.

 

Connecting your data

1. Head to Data Onboarding and connect all the data sources:

Add Data – you want to have available in Tableau.
connect ads crm analytics to tableau 1

1. Once you are done connecting your data head to

2. Select Destination and select Tableau in the I want to have my data in dropdown. Then select I do any transformations in my own tool. Click on the Copy button to save your API URL into your clipboard. We will use it later when we load the data into Tableauconnect ads crm analytics to tableau 2

 

Importing data into Tableau using a Web Data Connector

Now that you have your data sources connected. Let’s get it into Tableau. Let’s get back to the

 

Our Tableau Connector allows you to visualise all your Windsor.ai data directly in Tableau.

To get the data visualised you will need to do the following:

  1. Configure the Windsor.ai Connector in your Tableau Desktop: Open Tableau Desktop, head to Connect > To a Server > More… > Web Data Connector
    In the window you enter the URL https://tableau.windsor.aitableau 1 1
  2. Load your data using the Windsor.ai Connector: Inside the connector enter your Windsor.ai API URL. For this you will need the PAI url you have generated in the first part of this tutorial. Here is a sample URL:https://connectors.windsor.ai/all?api_key=[your API key]&date_from=2020-10-22&fields=source,medium,campaign,clicks,impressions,spend,dateAs you can see in the URL we have a set of fields, your API key and a start date. You can adjust the API url by changing the date (in YYYY-MM-DD format).I strongly recommend to test this first with the standard URL you get in Step 1. Once this works and you have the data set in Tableau you can look at customising your query:To see what other fields are available you can refer to the documentation of connectors. If you want to query specific metrics from connectors, for example Google Analytics custom dimensions or Facebook Ads custom conversions, you can find information on how to get your fields into Tableau here.
  3. Configure your data set
    Select the columns you want to load and specify the name of the table and click Submit

    tableau 3Once this is done your data starts loadingtableau 4
  4. Start visualising your data                                                                                                                                                                                                                                              Now your data is connected and you will be able to create reports, dashboards and join your data with other data sets you might have.tableau 6

 

In case you do not have a marketing dashboard at hand to connect your data to, please have a look at our Marketing Report Template gallery. You can find examples and templates which are ready to be used with our data sets. If you have any questions just drop us a message in the chat and we’ll get back to you immediately.

PS! For other Tableau templates, see this page. 

Watch how-to video