Data requirements

This page lists the columns that Data Center requires for each type of channel. The requirements apply to a channel whose data comes from Google Sheets, BigQuery, Snowflake, SFTP, or Azure Blob Storage. The columns depend on the type of the channel, which the Type column of the Channels tab shows.

A channel that a hosted connect card or a provider sign-in carries has no column requirement.

Advertising

Column	Required	Notes
date	Required	The day of the row. The expected name is created_date in Google Sheets.
campaign_name	Required	The name of the campaign.
campaign_id	Required	The ID of the campaign. Prescient reads the ID as text.
spend	Required	The spend of the campaign on that day.
tactic_type	Optional	Text.
clicks	Optional	A number.
impressions	Optional	A number.
conversions	Optional	A number.
revenue	Optional	A number.

Web analytics

Column	Required	Notes
date	Required	The day of the row. The expected name is created_date in Google Sheets.
channel_grouping	Required	The channel group of the sessions.
total_sessions	Required	The sessions of that group on that day.
engaged_sessions	Optional	A number.
new_users	Optional	A number.
active_users	Optional	A number.
total_users	Optional	A number.
bounce_rate	Optional	A number.

Conversion

Column	Required	Notes
date	Required	The day of the row. The expected name is created_date in Google Sheets.
value	Required	A number. Do not supply a conversion channel from Snowflake. See the rules for each source.

E-commerce

Column	Required	Notes
date	Required	The day of the row. The expected name is created_date in Google Sheets and in Snowflake.
new_customers	Required	Optional when the data comes from Snowflake.
transactional_orders	Required	A number.
transactional_revenue	Required	A number.
subscription_orders	Optional	A number.
subscription_revenue	Optional	A number.
wholesale_orders	Optional	A number.
wholesale_revenue	Optional	A number.

Retail

Column	Required	Notes
date	Required	A date. The expected name is created_date in Google Sheets.
date_aggregation	Required	Text.
revenue_amount	Required	A number.
revenue_ccy	Required	The currency of the revenue. Text.
total_units_sold	Required for SFTP, Azure Blob Storage, and Snowflake	Optional for Google Sheets and BigQuery.
num_of_stores	Required for SFTP, Azure Blob Storage, and Snowflake	Optional for Google Sheets and BigQuery.

Other

Column	Required	Notes
asin	Required	One row for each ASIN. An ASIN has 10 characters, each an uppercase letter or a digit.
brand_name	Optional	Text.

Unique rows

Data Center refuses data with two rows that have the same values in these columns.

Channel type	Columns	Result
Advertising	The date and campaign_id	One row for each campaign on each day.
Web analytics	The date and channel_grouping	One row for each channel group on each day.
Conversion	The date	One row for each day.
E-commerce	The date	One row for each day.
Retail	The date	One row for each date.
Other	asin	One row for each ASIN.

Rules for each source

Subject	Rule
Name of the date column	The expected name is created_date in Google Sheets, and in Snowflake for an e-commerce channel. The expected name is date in each other source. Data Center accepts date and created_date for the two names.
How Data Center reads column names	Data Center ignores capital letters, spaces, and punctuation in a column name, so Created Date and created_date are the same name. Data Center also accepts some other names for a column: campaign for campaign_name, tactic for tactic_type, cost for spend, sessions for total_sessions, and currency for revenue_ccy.
Other channels	A channel of the type Other can take data only from Google Sheets.
Date format	In Google Sheets, SFTP, and Azure Blob Storage, a date has the form YYYY-MM-DD or YYYY/MM/DD. In Google Sheets, a cell that has a date format is also a date. The fix message of a Google Sheets connection asks for the form YYYY-MM-DD.
Dates after today	In Google Sheets, SFTP, and Azure Blob Storage, a row with a date more than 1 day after today does not pass the check. Do not add rows for days that have not occurred.
Data patch sheet	A data patch sheet always uses the Google Sheets column names, so its date column is created_date.
Conversion data from Snowflake	Do not supply a conversion channel from Snowflake. The checks can pass, but Prescient does not read conversion data from a Snowflake service account. Use Google Sheets, BigQuery, SFTP, or Azure Blob Storage.
Values of the wrong type	A date column must hold dates, and a number column must hold numbers. An ASIN must have 10 characters, each an uppercase letter or a digit.
Blank values	A required column cannot have a blank value.
Numbers	A number must be a plain number, with no currency symbol and no currency format.
Duplicate rows	Two rows cannot have the same values in the columns that make a row unique.
Empty source	The source must have one row or more.
Column names that differ	When Data Center cannot match a required column to one of your columns, the setup dialog shows a form. In the form, select the column of your data for each required column.

Pages of the earlier help center

Some pages of the earlier help center list different required columns, or one date format only. The tables and the rules on this page agree with the checks that Data Center runs. For the columns of data that a workspace supplies, this page is the reference.

A data patch needs fewer columns

In a data patch, the main metric columns are optional. See Data patches.

Related

• Data Center: the guides and the concepts of the product area.
• Connect a channel: the steps to connect a sheet, a table, or a file location.
• Add a data patch: the steps for a patch sheet.
• Data patches: what a patch is and which columns it needs.