How to access your data?

This article is going to guide you through how to access your collected data.

Note

Clicking on links will guide you to external documentations or to a specific resource, the topic is about.

Experience Platform's data

Experience Platform uses Google's powerful service, called GCP to collect, store and share the data processed by it. GCP can be opened on this site. The account manager, after login, under the "DATA ACCESS" menu, can manage who can access the collected data. There are two types of access:

  • Raw data: only service accounts can be authorized to access the data. This is the recommended way for programmatic access.
  • Dashboard: only non-service accounts can be authorized to access the dashboard related data. Please note, that the underlying datastructure of the dashboard can be changed, so it is not recommended to use it for programmatic access.

Please visit this link to manage your data access.

Due to GCP's security restrictions only Google Accounts can be authorized.

Important

By default, no account has access to your data! Data manager's account (the one which you used to register on Experience Platform Console), should be authorized as well!


Important

Authorization can take 10-15 minutes, depending on GCP.

What is a Google Account?

Google Accounts are user profiles authenticated through Google's identity service. GCP allows only Google Accounts to log in to it. Anyone can create a new Google Account in few minutes.

How to create a new Google Account?

  1. To create a new Google Account please visit this page and fill out the form.
Note

You can use any type of email address, it doesn't need to end with '@gmail.com', by clicking on "Use my current email address instead".

  1. You will receive a verification code on your email, which you need to use to verify your address
  2. Entering the verification code you will need to fill out a new form
  3. If you finished with the form, you need to go through the privacy policy and confirming its content
  4. You are done! The new address can be authorized to access you Experience Platform data through GCP

Main identifiers in GCP

GCP project name: experience-platform-export
GCP project ID: experience-platform-export
Product: BigQuery
BigQuery Dataset name for programatic access: experience-platform-export.live

Data Dashboard

If your account is already authorized, you can navigate to your XP Dashboard and Panel Quality Report in Looker Studio.

Deauthorization

Any authorized accounts can be easily deauthorized on Experience Platform's Console.

Important

Deauthorization takes 5-10 minutes, depending on GCP.

Service account

Service accounts are non user accounts, designer for server-to-server communication. Through Experience Platform's Console you are able to create a Service Account and download the necessary key file. Using the key file, you can create automatized queries against BigQuery.
Here you can see an example returning 20 rows.

using Google.Apis.Auth.OAuth2;
using Google.Cloud.BigQuery.V2;

var gcpCred = GoogleCredential.FromFile("GCP_Credential.json");
var bqClient = BigQueryClient.Create("experience-platform-export", gcpCred);

var query = $"SELECT type, absolute_utc_time FROM `experience-platform-export.live.events` as t LIMIT 20";

var bqResults = await bqClient.ExecuteQueryAsync(
              query,
              null);

Console.ReadLine();

Note

GCP_Credential.json is the name of the key file, downloaded from Experience Platform's Console.