# 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](/files/jJ4YnM9XUCEEzkCDMdwJ)

## Sandbox to use

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

## Exercises

[12.1 Create your Google Cloud Platform Account](/comprehensive-technical-tutorial-archive/module12/ex1.md)

Create your Google Cloud Platform account.

[12.2 Create your first query in BigQuery](/comprehensive-technical-tutorial-archive/module12/ex2.md)

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

[12.3 Connect GCP & BigQuery to Adobe Experience Platform](/comprehensive-technical-tutorial-archive/module12/ex3.md)

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

[12.4 Load data from BigQuery into Adobe Experience Platform](/comprehensive-technical-tutorial-archive/module12/ex4.md)

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](/comprehensive-technical-tutorial-archive/module12/ex5.md)

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

[Summary and benefits](/comprehensive-technical-tutorial-archive/module12/summary.md)

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 %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.adobesandbox.com/comprehensive-technical-tutorial-archive/module12.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
