Schema Examples

Last updated: August 12, 2026

Sample business target metric schema for B2C orders

Example schema for a B2C business target metric of orders by order date.

Column Name	Type	Description
Date	Date	Date of new order
Customer Type	String	New or Returning customer
Country	String	Location of order
State	String	Location of order
City	String	Location of order
Number of Orders	Numeric	Unique number of orders at this level of detail.
Total Order Revenue	Numeric	Sum of the order revenue for this aggregation.

Sample business target metric for B2B leads

Example schema for a B2B business target metric of new leads.

Column Name	Type	Description
Date	Date	Date of new lead
Leads	Numeric	Volume of leads
Opps	Numeric	Volume of opportunities that originated on that date
Closed Won	Numeric	Volume of closed won deals that originated on that date
Segment	String	Customer segment
Country	String	Location of lead
State	String	Location of lead
City	String	Location of lead

Sample marketing channel schema for many channels

Example schema for a combined table across multiple channels and ad platforms.

Column Name	Type	Description
Date	Date	Date of impressions and spend
Channel	String	Name of ad platform
Campaign Name	String	Campaign Name
Campaign Group	String	Sub-channel or campaign grouping such as brand search vs non-brand search.
Country	String	Country targeted
State	String	Target State, if available
City	String	Target city, if available — especially useful for channels like OOH where spend may be shared by city.
Impressions	Numeric	Impressions (or proxy of impressions such as registrations or email sends) for date
Spend	Numeric	Spend in USD for the channel on the date.

Sample opportunity pipeline schema for B2B revenue teams

Example schema for an opportunity pipeline table used for pipeline ARR analysis and opportunity-volume reporting.

Column Name	Type	Description
Date	Date	Reporting date for the pipeline snapshot or daily aggregate.
Opportunity Count	Numeric	Count of distinct `opportunity_id` records included in the pipeline ARR metric so volume reporting stays comparable to ARR reporting.
Pipeline ARR	Numeric	ARR metric for the included opportunity set.
Sales Department	String	Segment field such as Commercial, Mid-Market, or Enterprise for slicing analysis.
Opportunity Type	String	Classification such as New Business, Renewal, or Terms Modification.

Note: negative opportunity values can legitimately appear for renewals or terms modifications when there is a downgrade or mid-term reduction. For downstream reporting, teams often ensure the daily aggregate does not go below zero while still preserving opportunity volume.

Want to learn more about sharing your data? Check out other Paramark data sharing articles here