Prerequisites

To connect your Snowflake 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.

To enable seamless ingestion of your retail performance data into our system, you must make data available through a Snowflake share, with access granted to the following destination:

Snowflake Organization: WBAFXUK.LQA14719
Region: AWS US-East 1 (Northern Virginia)

Follow the official Snowflake documentation to create and configure your key-pair authenticated user:

Create a user with key-pair authentication - This guide will help you set up the share correctly (note: this is different from private listings)
Create new role and apply proper permissions to the prescient user account

Expected Table Schema

We will directly query the shared tables from this account. The data must be pre-aggregated and fully loaded before each daily deadline. The schema of the table should look like the below table:

Column Name	Type	Required	Description
date	`DATE`	Yes	The calendar date of the data
campaign_name	`STRING`	Yes	Human readable name of the campaign.
campaign_id	`STRING`	Yes	Unique Identifier for the campaign
tactic_type	`STRING`	Yes	Advertising Channel Type (i.e., Search, CTV, Online Video, etc)
spend	`FLOAT`	Yes	Spend reported for campaign on that date
revenue	`FLOAT`	No	Channel reported revenue for campaign on that date
conversions	`INTEGER`	No	Conversions reported for campaign on that date
clicks	`INTEGER`	No	Clicks reported for campaign on that date
impressions	`INTEGER`	No	Impressions reported for campaign on that date

Note: The data should be aggregated at the daily level, with one row per date and campaign_id combination.

Setup Instructions

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

Create and configure share
Enter Share Name, Table Name, Schema Name and Account Identifier into connector parameters
Grant access to the Prescient Snowflake destination
Click Save & Test