12 - Ingest & Analyze Google Analytics data in Adobe Experience Platform with the BigQuery Source Co
Ingest & Analyze Google Analytics data in Adobe Experience Platform with the BigQuery Source Connector
Authors: Victor de la Iglesia, Wouter Van Geluwe
In this module, you'll set up your own instance of Google Cloud Platform, load sample data in Google Cloud Platform and you'll then use the BigQuery Source Connector to ingest that data from Google Cloud Platform into Adobe Experience Platform. Finally, you'll use Customer Journey Analytics to visualize that data.
Source connectors in Adobe Experience Platform make the process of getting data into Adobe Experience Platform easy. Google BigQuery is one of the already available connectors. Thanks to Adobe Experience Platform and the BigQuery Source Connector we can now bring Google Analytics data into Analysis Workspace in Customer Journey Analytics.
In addition, we can enrich that Google Analytics data by joining it with other data sources such as CRM, Call Center or Loyalty data within Customer Journey Analytics.
Learning Objectives
Become familiar with the Google Cloud Platform and BigQuery User Interface
Ingest Google Analytics data into Adobe Experience Platform
Use Customer Journey Analytics to perform analysis of Google Analytics data
Enrich Google Analytics data with offline data
Prerequisites
Some familiarity with Customer Journey Analytics is preferred, but not required
Access to Adobe Experience Platform: https://experience.adobe.com/platform
Access to Customer Journey Analytics
Access to Google Cloud Platform and Google BigQuery
Download these assets:
This tutorial was created to facilitate a particular workshop format. It uses specific systems and accounts to which you might not have access. Even without access, we think you can still learn a lot by reading through this very detailed content. If you're a participant in one of the workshops and need your access credentials, please contact spphelp@adobe.com, who will provide you with the required information.
Architecture Overview
Have a look at the below architecture, which highlights the components that will be discussed and used in this module.
Sandbox to use
Kindly refer to Exercise 0.0 for instructions on how to find your Sandbox ID and other identifying values.
Exercises
12.1 Create your Google Cloud Platform Account
Create your Google Cloud Platform account.
12.2 Create your first query in BigQuery
Learn how to use BigQuery to prepare the data for loading into Platform.
12.3 Connect GCP & BigQuery to Adobe Experience Platform
Learn how to setup the source connector in Adobe Experience Platform.
12.4 Load data from BigQuery into Adobe Experience Platform
Learn how to configure the BigQuery source connector in Adobe Experience Platform to ingest your Google Analytics Data.
12.5 Analyze Google Analytics Data using Customer Journey Analytics
Learn how to analyze Google Analytics data in Customer Journey Analytics and combine it with Loyalty data.
Summary of this module and overview of the benefits.
Thank you for investing your time in learning all there is to know about Adobe Experience Platform. If you have questions, want to share general feedback of have suggestions on future content, please contact the Solution Partner Portal, by sending an email to spphelp@adobe.com.
Last updated
