How to integrate Google AdWords in Tableau using DataVirtuality

 

While Tableau has some connectors to popular data sources, there are many connectors that are not built by Tableau – such as a connector to the very popular Google Adwords. Therefore, you should choose one of Tableau’s solution/technology partners that provide these data integration services and complement Tableau.

 

Access, centralize and model your data with DataVirtuality and Tableau

Data Virtuality is Tableau’s partner and we have built two solutions to help you integrate AdWords with Tableau. They are DataVirtuality Logical Data Warehouse (LDW) and DataVirtuality Pipes. Our solutions come with over 200 connectors to any data sources you can imagine — and of course Google Adwords is one of them.

Our LDW is the state-of-the-art data warehouse that combines automated ETL (Extract, Transform, Load) and data virtualization. It eliminates many bottlenecks common to traditional ETL, data lakes, and data federation services. With LDW, you can easily build any kind of custom data model by yourself, including integrating AdWords with Tableau. In addition, you can also create a central data model to be used in different reports within Tableau. Below is a peek at the LDW interface. As you can see, all standard Adwords reports are available to query from:

 

DataVirtuality Studio Image Highlight

 

Pipes is our lightweight web-based data integration solution. It’s extremely fast, easy to set up and ready-to-use out of the box. With Pipes, you can use a large number of predefined extraction templates to get data from Adwords into a database of your choice, where you can then analyze it by connecting Tableau.

 

Step 1-1: Go to Setup Storage

Step-by-step guide on how to integrate Adwords in Tableau with DataVirtuality Pipes

Below, there are step-by-step instructions to show you just how easy it is to integrate AdWords with Tableau using DataVirtuality solutions.

The procedure is straightforward: First, load data from AdWords into your database (e.g. PostgreSQL or Amazon Redshift) using Pipes. Second, connect Tableau to this database and open the data. Here are step-by-step instructions:

1. Open DataVirtuality Pipes in your browser, go to Setup Storage to choose the target storage that you use (we’ll use PostgreSQL as an example here as it’s open source), and enter your credentials:

 

Step 1-2: Enter Credentials

 

2. Once your storage is connected to Pipes, go to Add Source and click on the Google AdWords logo, as shown in the screenshot below (highlighted with an orange rectangle), and authenticate it on Google:

 

Step 2-1: Add Source Google AdWords
Step 2-1: Added Source Google AdWords

 

3. Select the data you want to load using the templates, and then use our exclusive Preview feature to tinker with the data and check its structure before loading it. Preview is possible since Pipes’ backend is our cutting-edge LDW, which can virtualize data, and this feature does not exist with other web-based products:

 

Step 3-1: Choose Templates in Pipes
Step 3-2: Preview Data in Pipes

 

4. Happy with the data structure in the preview? Then give it a name and load it instantly, as shown below:

 

Step 4: Load Data Instantly in Pipes

 

5. Now your AdWords data is loaded to your target storage. Open up Tableau and connect Tableau to your storage (PostgreSQL in our example). Et voilà! You now have a beautiful dashboard in Tableau:

 

Step 5: Access Adwords via DataVirtuality in Tableau and build Dashboards

 

That’s how simple it is to connect any data source to Tableau using DataVirtuality Pipes. You can do it in a similar way with DataVirtuality LDW but with more freedom in terms of how you want the data model to be customized.

Now it's your turn! Get your 14 day free trial right here for DataVirtuality Pipes

Having other questions? Just shoot us a message at: info@datavirtuality.com