CPM Sync - Google Ads Manager Report Creation

1. Click on the Reporting
2. Click on Reports
3. Click on New report.

Setup in the Report builder

General settings

1. Select Historical Report type.
2. Enter the report name according to this template: <COMPANY NAME>_Adx_CPM_Sync.
   1. Replace <COMPANY NAME> with your company’s name, as stated in app.ex.co.
   2. Do not use any special characters and spaces (e.g EX.CO becomes ExCo).
3. Select the time zone closest to GMT, if possible (e.g GMT+3:00 is better than GMT-7:00).
4. Select Dynamic Date range.
5. Set Date range to Last 7 days.
6. Set Report currency to USD (US Dollar).
7. (optional) Apply any filter logics in order to report only relevant Ad Units

Dimensions

1. Select Time unit - Date.
2. Select Inventory - Ad unit (all levels).
   1. Do not check any checkbox in the Ad unit (all levels) dimension.
3. Select Geography - Country.
4. Select Platform - Device category.
5. Select Platform - Browser category.
6. Select Platform - Operating system category.
7. Maintain the specified order of dimensions. 

Metrics

1. In the  Total section
2. Check Total impressions.
3. Check Total CPM and CPC revenue.
4. Check Total average eCPM.

Editors and scheduling

1. Select Daily Schedule.
2. Set End date 1 year from Start date (e.g Oct. 14, 2023 - Oct. 13, 2024).
3. Select CSV FIle format (NOT Excel CSV).
4. Check Include header.
5. Check Include IDs.
6. Set cpm_sync@ex.co as a report recipient.
7. Click Save and run.

Example outputs

Report builder:

CSV File: