Prerequisites

• To connect your BigQuery account for retrieving marketing specific data, follow the below instructions. If you have any trouble accessing this information, your Prescient CSM is available to assist you.

Expected Table Schema

Our integration expects access to a single table that aggregates your key daily marketing metrics. This table should follow the schema below:

Setup Instructions

To enable data ingestion, please create a Google Cloud Service Account by following these steps:

1. Create a Service Account in Google Cloud Console.

2. Grant the following permissions to the service account you created:

• BigQuery Data Viewer (roles/bigquery.dataViewer)
• BigQuery Job User (roles/bigquery.jobUser)

3. Create and download a JSON key by navigating to the "Keys" tab.
4. Share dataset access