Daily reports via email from GAM

OpenPath publishers can configure a report in Google Ad Manager (GAM) to email to The Trade Desk for data parsing and ingestion. This is particularly useful for publishers who cannot upload reports to The Trade Desk by other means.

Setup

In GAM, you can schedule reports and have them automatically emailed to The Trade Desk on a daily basis. To ensure that The Trade Desk can correctly process your reports, follow these steps in GAM:

1. Create a new report.

2. Fill out the following information:

   Field/Section	Value Description
   Report Type	Select Historical.
   Name	Enter a report name following this format exactly: DailyReport|PUBLISHER={PUBLISHERNAME}|CURRENCY={YOURCURRENCY}|TIMEZONE={YOURTIMEZONE} For example: DailyReport|PUBLISHER=ebay|CURRENCY=USD|TIMEZONE=America/Los_Angeles IMPORTANT: To prevent errors in parsing your report data, be sure to correctly format the report name. For details, see Report name requirements.
   Time zone	Select the time zone that you report in.
   Date range	Set the value to Custom and specify a range for the last 31 days by setting the Start Date to 32 days before today and the End Date to 0 days before yesterday.
   Report currency	Set the currency you report in.
   Table structure	Flat
   Dimensions	Date
   Metrics	Select Total Impressions and Total CPM and CPC Revenue.

3. Filter line items to show only The Trade Desk line items that have served based on your current setup:

   • For instances where The Trade Desk has its own order, filtering only by order will work.
   • For instances where Prebid line items are shared, include the Prebid order and key values that represent the highest bidder. For example, hb_bidder = ttd.

4. In the Editors and Scheduling section, do the following:

   Field	Value Description
   Schedule	Daily
   File format	CSV
   Include header	Make sure that this checkbox is selected.
   Add recipients	Enter the following email addresses: openpath@reports.thetradedesk.com seller.reports@thetradedesk.com

5. Click Save & Run.

After GAM starts sending reports to The Trade Desk, we'll make sure that we receive and process them correctly. For details, see Verification process.

Report name requirements

The report name format must match the following format:

DailyReport|PUBLISHER={PUBLISHERNAME}|CURRENCY={YOURCURRENCY}|TIMEZONE={YOURTIMEZONE}

Here's what you need to know about the report name components:

• {PUBLISHERNAME}: Your publisher name, provided by The Trade Desk.
• {YOURCURRENCY}: The currency code for the currency you report in, for example, USD for US dollars.
• {YOURTIMEZONE}: The time zone that you report in.

IMPORTANT: If your reporting is not in UTC, be sure to use the Olson time zone format, for example America/Los_Angeles. This format accounts for differences in daylight savings and standard time.
For a list of acceptable time zone values, see the windowsZones.xml file. The specific time zone names that you can use in your report name are the type attribute values.

Verification process

Here's what to expect after you start sending GAM reports to The Trade Desk via email:

1. We monitor the process to confirm that we receive your reports and properly ingest the data.
2. After we've confirmed that we're processing your reports correctly, we start sending daily summary reports to you.
3. After you've started receiving summary reports, contact your Technical Account Manager to confirm receipt.

NOTE: If The Trade Desk encounters errors in processing your reports, your Technical Account Manager will contact you to help resolve the problem.