Getting started with aggregate sales measurement

Easily onboard and share aggregated sales measurement data with The Trade Desk with a simple integration workflow. With this solution, you can maintain control over your attribution methodology and share data at an aggregated level.

Here's what you need to know about the benefits and intended uses for Aggregate Sales Measurement:

• You can pass attributed sales to The Trade Desk without sending user IDs.
• Except for a few fields required for The Trade Desk to generate reporting, you can select fields (also referred to as grains) that you want to include in your reports for advertisers.
• You can upload attributed sales data up to 7 days after the sale, and (if needed) rewrite previous sales data.

Onboarding prerequisites

To harness the full potential of The Trade Desk Aggregate Sales Measurement solution, you must satisfy the following criteria:

Have purchase or sales data, which can be online, offline, or both. For example, you might be a merchant or measurement partner.
Have the capability to do attribution of conversions from impression data shared by The Trade Desk.
Have user IDs (email addresses, loyalty card numbers) and the capability to convert them to IDs that can be matched to our TDIDs. Otherwise, you must work with a third-party vendor to map your internal IDs to TDIDs or device IDs with their cross-device capabilities.

If you are new to The Trade Desk platform and meet our requirements or have any questions, contact us at The Trade Desk website. Otherwise, reach out to your assigned Data Partnership Manager to get started.

Workflow overview

The onboarding process for aggregate sales measurement requires close collaboration between you as the measurement partner and The Trade Desk. The following table outlines the steps.

IMPORTANT: You must complete your onboarding before your advertisers' first campaigns go live.

After completing the onboarding process, you can begin your collaboration with advertisers to report sales. Here's a high-level overview of this process:

1. Agree on what is to be measured. For example, this could be SKUs purchased, locations visited, and actions taken.
2. Prior to launching a campaign, the advertiser should make sure that they have allowed sharing of their impression data. If the advertiser has any issues or questions, they should work with their Account Manager at The Trade Desk.
3. You retrieve the impression data and run attribution.
4. You generate a report per agreed format and naming convention and upload to the S3 bucket that The Trade Desk provided during the onboarding.

If you ever need to rewrite past sales data, follow the specified file naming convention to upload your sales data.

Report file naming convention

To prevent any failures of the automated tasks associated with processing your reports, be sure to use the following naming syntax for your files:

{PARTNER_NAME}_sls_{DATETIME}_{TOTAL_FILES}_{FILE_SEQUENCE}_{BACKFILLING_METHOD}.{FILE_EXTENSION}

For example: abcmerchant_sls_20240212T154739_5_5_incremental.csv

The following table explains each placeholder value in curly braces ({}) that you must replace.

NOTE: The file name is not case-sensitive.

Reporting field reference

The following table lists the fields (grains) you can choose for your aggregate sales reports and pass to The Trade Desk. All fields are listed in the order of the columns in the Aggregate sales sample report template file.

NOTE: Only one date field is required, either Impression Date or Event TimeStamp.

* © 2026, The Nielsen Company (US), LLC. The DMA® data is used pursuant to a license from The Nielsen Company (US), LLC. Any use and/or reproduction of these materials without the express written consent of The Nielsen Company (US), LLC, is strictly prohibited. DMA® data is valid for the period 2025 - 2026. DMA® is a registered service mark of The Nielsen Company (US), LLC and is used pursuant to license.

FAQs

The following is a list of frequently asked questions about our Aggregate Sales Measurement solution.

How much time do I have after the date of the sale to submit my sales report?

The reporting timeframe varies based on the agreement you established during your onboarding process. The maximum delay is 7 days.

Can I rewrite past sales data?

Yes. Just be sure to follow the specified naming convention to upload your sales data.

What are my options if I lack the capability to sync my user IDs with TDIDs?

Contact your assigned Data Partnership Manager to discuss your options. For example, you can choose to work with a third-party vendor, such as Circana or LiveRamp, to map your internal IDs to TDIDs or device IDs with their cross-device capabilities.

How is this data used to optimize campaigns?

Aggregate sales data doesn't power our Koa optimizations. Instead, advertisers have the option to manually optimize campaigns by applying bid factors based on the grains provided in this report.

Is there a sample report file that I could use?

Yes, you can use the Aggregate sales sample report template file.