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 (watch a complete demo here). It eliminates many bottlenecks common to traditional ETL, data lakes, and data federation services. With the 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.
This is what the LDW interface looks like. As you can see, all standard Adwords reports are available to query from.
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, from where you can then analyze it by connecting Tableau.
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 Data Virtuality 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 Data Virtuality 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 Google AdWords logo, as shown in the screenshot below (highlighted with an orange rectangle), and authenticate it on 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 this feature does not exist with other web-based products:
4. Happy with the data structure in the preview? Then give it a name and load it instantly, as shown 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). Et voilà! You now have a beautiful dashboard in Tableau:
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 for Data Virtuality Pipes.