Carefully review below instructions as there are specific steps that must be followed exactly to avoid errors with the syncing.
Report Name Format
The report name (and file name) must follow this structure: GAM_publishername_exco
- Example: GAM_DisneyWorld_exco
Only allowed for publisher name:
- English letters
- Uppercase/lowercase
- Underscores
Not allowed: spaces, slashes, commas, or any other special characters.
Report Timeframe
Always select Last 7 days
Timezone
Ad Exchange Time zone (America/Los_Angeles)
Dimensions and Metrics
Ensure the dimensions and metrics are defined in this exact order:
- Date
- Ad Unit ID (NOT Ad Unit Name)
- Operating System Category
- Device Category
- Browser Category
- Country Code
- Total CPM and CPC revenue
- Total Impressions
-
Total Average eCPM
Scheduling Configuration
Frequency: Daily
Time:
Set the report to run at 01:00 AM PST (America/Los_Angeles).
Please adjust this time according to your network’s timezone
(e.g., If the your timezone is EST, schedule for 03:00 AM. If your timezone is PST, schedule for 01:00 AM).
You can use this site to verify time zone conversions: https://www.worldtimebuddy.com/
Please check the following:
- Always email on the schedule
- Email with attachment
- Use API column names
- Configure cpm_sync@ex.co as an additional recipient
- In the Attachment settings at the bottom, uncheck Include report properties to exclude the report’s top header from the scheduled report. Only leave Use API column names checked.