6 Steps To Do Google Marketing 360 Analysis Like A Boss With Tableau And Amazon Redshift
Google Marketing 360 is a leader in display and search advertising. It is one of the most widely used platforms by agencies and advertisers. Tableau is a leading data reporting and visualization tool. Amazon Redshift is a leading cloud data warehouse solution. Combining Google Marketing 360, Tableau and Redshift makes a powerful analytic combo!
In this article, we will guide you through the process of connecting Tableau to your Google Marketing 360 data in Redshift.
How to connect Tableau to Amazon Redshift
Step 1: Select the connect option
Open Tableau and select “Amazon Redshift” from the Connect options in the left-hand toolbar:
Step 2: Enter the credentials
Enter the server address, database, username and password provided by Openbridge into the Amazon Redshift Connection pop-up.
Once you enter and click “OK”, assuming your credentials are correct, you will be connected. Time to create your first visual!
Step 3: Select a schema
Since we are using Openbridge data our first step is to select the ‘openbridge’ schema. This will list a collection of tables in Redshift under that schema. You simply drag the desired table(s) to the right. In this case, we are using Google Marketing 360 display media performance data:
Step 4: Create a new worksheet
Click on a new worksheet. You will see the tables fields listed as either Dimensions or Metrics
Step 5: Configure rows
- Drag ‘Date’ field from the Dimensions section onto the row shelf
2. Click the drop-down on the right of the Date field, select ‘More’ and then ‘Custom’
3. Choose ‘Month/Day/Year’ format
4. Drag the ‘Clicks’ field from Metrics onto the Text mark
Step 6: Create a chart
Select the Line Chart from the ‘Show Me’ drop down
Voila! Your first Google Marketing 360 visualization in Tableau with the data from Redshift is ready!
Want to see how to use Tableau and Redshift with social data? Check out how we did we paired Tableau and Redshift with Instagram data: Instagram How To: Powerful Data Analytics Tips.
DWant to discuss a solution like this for your organization? Need a platform and team of experts to kickstart your data and analytic efforts? We can help! Getting traction adopting new technologies, especially if it means your team is working in different and unfamiliar ways, can be a roadblock for success. This is especially true in a self-service only world. If you want to discuss a proof-of-concept, pilot, project or any other effort, the Openbridge platform and team of data experts are ready to help.
Reach out to us at hello@openbridge.com. Prefer to talk to someone? Set up a call with our team of data experts.
Visit us at www.openbridge.com to learn how we are helping other companies with their data efforts.
