Integrating Reveal with Google Analytics and Google Data Studio

This article documents the steps needed to combine first and third party data (Clearbit) together in Google Analytics.

If you're looking for the Reveal GA integration guide, please go here.

This article covers setting up Data Studio at a high level via PostgreSQL.

Steps

1. Either visit: https://datastudio.google.com or from inside Google Reporting Suite, select the drop down from the top left corner and select the option for Data Studio (three staggered/stacked horizontal bars), then select the "Get Started".

Screenshot_2018-10-15_14.24.54.png

2. Select Data Sources from the left hand menu, then choose the integration your team will be connecting:

Screenshot_2018-10-15_14.34.20.png

3. Clearbit's team uses Amazon Redshift. You can select PostgreSQL for this:

Screenshot_2018-10-15_14.35.49.png

 

4. Authenticate your Database (your operations team should be able to assist here):

Screenshot_2018-10-15_14.41.02.png

 

5. Depending on how your database is configured, you may need to write a custom query. Afterwards make sure the fields you want to pass are selected. You will need to check with your operations team for exact querying.

Screenshot_2018-10-15_16.51.43.png

 

6. Select the table option and draw a box on the page (grid looking icon):

Screenshot_2018-10-15_16.58.25.png

7. Select the table you just created. On the right hand menu that pulls open, select "BLEND DATA"

Screenshot_2018-10-17_16.26.42.png

 

8. Choose your data sources, what dimensions you will be using from each, and make sure to join by a matching key. Once done, select save in the bottom right hand of the menu.

Screenshot_2018-10-17_16.27.54.png

 

9. From the right side menu, pull the dimensions and metrics you blended and will be in your report:

Screenshot_2018-10-17_16.32.36.png

 

10. You will most likely want to add some filters (including email and specific high value pages) to your report so that each rep gets their own custom dashboard to review daily. 

Screenshot_2018-10-17_16.28.35.png

ie: for email, you'll want to add the following, and change this for each copied dashboard that you may wish to create.

Screenshot_2018-10-17_16.28.28.png

11. Add "Date Range" to your report to allow users to filter activity by date:

Screenshot_2018-10-17_16.35.58.png

 

12. Edit field names as desired, and share with respective team members. 

Screenshot_2018-10-17_16.28.53.png