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, centralize 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(LDW) and . Our solutions come with over 150 connectors to any data sources you can imagine — and of course Google Adwords is one of them.
Ouris 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:
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-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 solutions.
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 target storage that you use (we’ll use PostgreSQL as an example here as it’s open source), and enter your 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:
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:
4. Happy with the data structure in preview? Then give it a name and load it instantly like below:
5. Now your AdWords data is loaded to your target storage. Open up Tableau and connect Tableau to your storage (PostgreSQL in our example). Voilà! Here’s a beautiful dashboard in Tableau:
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: firstname.lastname@example.org