Prerequisites

To connect Retail Revenue data via Google Sheets, please ensure you have access to the Retail Revenue template (link HERE) 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 offline metrics. This table should follow the schema below:

Column Name	Type	Required	Description
date	`DATE`	Yes	Reported date in YYYY/MM/DD format. Dates need to either be daily or a consistent day of the week when aggregating to weekly values.
revenue_amount	`FLOAT`	Yes	Total revenue that will be modeled against.
revenue_ccy	`STRING`	Yes	Currency the revenue is in.
date_aggregation	`STRING`	Yes	The data aggregation level D(aily) or W(eekly). The weekly aggregation is assumed to end on the date you give it in the column.
total_units_sold	`INTEGER`	No	The total number of units sold in the time period.
num_of_stores	`INTEGER`	No	The total number of actively selling stores in the time period. Count of all stores with sales greater than 0 in the specific time period.

Note: The recommendation is for the data to be aggregated at the daily level or weekly level, with one row per date. If that is not possible then a weekly rollup to the start of week can be supported.

Setup Instructions

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

Download the Retail Revenue Template

Download and use the official Prescient Retail Revenue Google Sheet template:

📥 Retail Revenue Template https://docs.google.com/spreadsheets/d/17xT_HuKM3_v81M13Lc4NDdPZ5ANfikk_AvW4y6k0WLY/edit?gid=0#gid=0

Prepare Your Google Sheet

Fill in your Retail Revenue data using the provided template.

Ensure all required columns are populated
Data should be aggregated at a daily or weekly level (Data should be pulled from a Monday - Sunday start if at the weekly level)
Create a named range that includes all data rows (e.g., RetailRevenueData)
Note: The template includes a pre-configured named range by default

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

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

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.

Validate and Select Named Range

In Prescient:

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

Save & Test

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

Tips:

If validation fails, double-check that:
The sheet is shared with the correct email
The full Google Sheet URL was used
The named range fully covers your data
Use US-based numeric format