How to integrate Google AdWords in Tableau using DataVirtuality

AdWords Tableau Blog Post Feature Image

 

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

 

Access, move and model your data with DataVirtuality and Tableau

Data Virtuality is Tableau’s partner and my team has 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 150 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 automized ETL (Extract, Transform, Load) and data virtualization. It eliminates many bottlenecks common to traditional ETL (Extract, Transform, Load), data lakes, and data federation services. With LDW, you can build any kind of custom data model by yourself easily, including integrating AdWords with Tableau. In addition to this, you can also create a central data model to be used in different reports within Tableau. Below is a peek into the LDW interface. As you can see, all standard Adwords reports are avaiable to query from:

Pipes is our lightweight web-based data integration solution. It’s extremely fast and 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 them 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, we will give you a step-by-step instruction in Pipes to show you just how easy it is to integrate AdWords with Tableau using DataVirtuality products.

The procedure is straightforward: First you load data from AdWords into your database via Pipes, like PostgreSQL or Amazon Redshift. Second, you connect Tableau to this database and open the data. Here’s is the step-by-step instruction:

1. Open DataVirtuality Pipes in your browser, go to Setup Storage to choose the analytical 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 logo of Google AdWords like in the screenshot below (highlighted with orange), and authenticate it with 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 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 preview? Then give it a name and load it instantly like below:

Step 4: Load Data Instantly in Pipes

 

5. Now your AdWords data is loaded to your analytical storage. Open up Tableau and connect Tableau to your storage (PostgreSQL in our example). Voilà! Here’s 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 sources to Tableau using DataVirtuality Pipes. You can do it similarly with DataVirtuality LDW but with more freedom to how you want the data model to be customized.

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

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