Prerequisites

To connect eCommerce Revenue data via Google Sheets, please ensure you have access to the official Prescient eCommerce Revenue template and the ability to share the sheet with an external service account.

If you have any trouble completing these steps, your Prescient CSM is available to assist you.

Expected Table Schema

Our integration expects access to a single table that aggregates your key daily eCommerce performance metrics.

This table should follow the schema below:

Column Name	Type	Required	Description
date	`DATE`	Yes	The calendar date of the data in YYYY/MM/DD format. Data must be aggregated at the daily level with one row per date.
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	Recurring subscription-based orders that will be excluded from modeling.
subscription_revenue	`FLOAT`	No	Repeat subscription 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:
Data must be aggregated at the daily level, with one row per date.

Setup Instructions

To enable eCommerce Revenue data ingestion, please follow the steps below:

1. Download the eCommerce Revenue Template

Download and use the official Prescient eCommerce Revenue Google Sheet template.

📥 eCommerce Revenue Template

2. Prepare Your Google Sheet

Fill in your eCommerce Revenue data using the provided template.

Ensure all required columns are populated.
Data must be aggregated at the daily level.
Create a named range that includes all data rows (e.g., eCommRevenueData).
The template includes a pre-configured named range by default.

If needed, see: Create & use named ranges in Google Sheets

3. Share the Sheet

Share the Google Sheet with Prescient’s service account:

Permission level: Viewer
Email address:
google-sheet-integration@prescient-ai-production.iam.gserviceaccount.com

The connector will not work unless the sheet is properly shared.

4. Enter Sheet URL in Prescient

Copy the full URL of your Google Sheet and paste it into the Sheet URL field in the Prescient setup form.

5. Validate and Select Named Range

In Prescient:

Click Find Sheet to validate access.
Select the appropriate named range from the dropdown menu.

6. Save & Test

Click Save & Test to complete setup and confirm successful ingestion.

Troubleshooting Tips

If validation fails, double-check that:

The sheet is shared with the correct service account email.
The full Google Sheet URL (not a shortened link) was used.
The named range fully covers all data rows and columns.
Numeric columns contain plain numeric values only.
All required columns are present in the sheet.
Header names match the template exactly (including spelling and formatting).

Once successfully connected, your eCommerce Revenue data will begin syncing automatically.