Usage

Input Fields

Field	Value	Required?	Comments
`utc_datetime`	Date in UTC. Preference is YYYY-MM-DD 01:10:15 but can support other formats.		For monthly updates, use the first day of the month
`activity_type`	The billable activity - see Data Dictionary		This should match the contract setup in Scope3 - ask your CSM if unclear
`impressions`	The number of billable impressions	For volume-based contracts
`currency`	The billing currency (eg `USD` or `EUR`)	For revshare contracts	Must match what is in the contract
`net_revenue_to_scope3`	The revenue payable to Scope3	For revshare contracts
`client`	See Sharing Data with Clients		A unique identifier that can be used to reference customer's client - could be a billing ID or an account name
`po_number`	The PO number to include on the invoice		If a PO number is required on the invoice, it can be added here
`deal_id`	string	Required if deal_name provided	transaction
`deal_name`	string		transaction
`campaign_id`	string	Required if campaign_name provided	transaction
`campaign_name`	string		transaction
`advertiser_id`	string	Required if advertiser_name provided	transaction
`advertiser_name`	string		transaction
`campaign_group_id`	string	Required if campaign_group_name provided	transaction
campaign_group_name	string		transaction
line_item_id	string	Required if line_item_name provided	transaction
line_item_name	string		transaction
insertion_order_id	string	Required if insertion_order_name provided	transaction
insertion_order_name	string		transaction

Example

For a client that has both volume-based and revshare terms (for instance, $0.02 for measurement and a 70/30 revshare for optimization). Note that impressions are optional for revshare rows but are fine to pass if helpful.

date,activity_type,impressions,currency,net_revenue_to_scope3,client
2023-09-01,MEASUREMENT,123322,,,bayer
2023-09-01,MEASUREMENT,8372810,,,unilever
2023-09-01,OPTIMIZATION,,USD,87.82,ford