# 12 - Ingest & Analyze Google Analytics data in Adobe Experience Platform with the BigQuery Source Co

**Authors:** [**Victor de la Iglesia**](https://www.linkedin.com/in/victordelaiglesia/)**,** [**Wouter Van Geluwe**](https://www.linkedin.com/in/woutervangeluwe/)

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**:
  * [JSON - Sample Data: Loyalty Data](https://github.com/AdobePartnerTechnicalServices/aep-quickstart-guide/blob/main/assets/json/bqLoyalty.json)

{% hint style="warning" %}
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**](mailto:spphelp@adobe.com), who will provide you with the required information.
{% endhint %}

## Architecture Overview

Have a look at the below architecture, which highlights the components that will be discussed and used in this module.

![Architecture Overview](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-f29eeb7b8dc6d815b9c442e305b7a623e56b277b%2Farchitecturem16.png?alt=media)

## Sandbox to use

{% hint style="info" %}
Kindly refer to [Exercise 0.0](https://docs.adobesandbox.com/comprehensive-technical-tutorial-archive/getting-started/ex0) for instructions on how to find your Sandbox ID and other identifying values.
{% endhint %}

## Exercises

[12.1 Create your Google Cloud Platform Account](https://docs.adobesandbox.com/comprehensive-technical-tutorial-archive/module12/ex1)

Create your Google Cloud Platform account.

[12.2 Create your first query in BigQuery](https://docs.adobesandbox.com/comprehensive-technical-tutorial-archive/module12/ex2)

Learn how to use BigQuery to prepare the data for loading into Platform.

[12.3 Connect GCP & BigQuery to Adobe Experience Platform](https://docs.adobesandbox.com/comprehensive-technical-tutorial-archive/module12/ex3)

Learn how to setup the source connector in Adobe Experience Platform.

[12.4 Load data from BigQuery into Adobe Experience Platform](https://docs.adobesandbox.com/comprehensive-technical-tutorial-archive/module12/ex4)

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](https://docs.adobesandbox.com/comprehensive-technical-tutorial-archive/module12/ex5)

Learn how to analyze Google Analytics data in Customer Journey Analytics and combine it with Loyalty data.

[Summary and benefits](https://docs.adobesandbox.com/comprehensive-technical-tutorial-archive/module12/summary)

Summary of this module and overview of the benefits.

{% hint style="info" %}
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>**.
{% endhint %}