Prerequisites

To enable seamless ingestion of your ecommerce 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 share:

Create and configure shares - This guide will help you set up the share correctly (note: this is different from private listings)
Account identifiers - Reference for understanding account identifiers (ex: <orgname>.<account_name>)

Expected Table Schema

We will directly query the shared tables from this account. The data must be pre-aggregated and updated daily before midnight PST. 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
new_customers	`INTEGER`	Yes	Number of first-time buyers on that date
transactional_orders	`INTEGER`	Yes	Number of completed transactional orders on that date
transactional_revenue	`FLOAT`	Yes	Total transactional revenue generated on that date (excluding repeat subscriptions, but including first-time subscriptions if applicable)
subscription_orders	`INTEGER`	No	Reoccuring subscription based orders that will be excluded from modeling
subscription_revenue	`FLOAT`	No	Repeat revenue that will be excluded from modeling
wholesale_orders	`INTEGER`	No	Wholesale orders that will be excluded from modeling
wholesale_revenue	`FLOAT`	No	Wholesale revenue that will be excluded from modeling

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

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