How to pull a media spend report from CM
video walk through here!
Step-by-Step Directions:
Navigate to the reporting area of the adserver by hitting the four little squares > Reporting and Attribution
Report Builder > Offline Reporting
Optional: Reporting can be filtered > Created By: Me, Anyone, Shared with me (helpful if you want to repurpose an already created report)
Create a brand new report by selecting New > Standard
Title report something that will identify what the report is to you
When you're doing a media cost or media spend report, your date range should be the entire duration of the campaign
Select filters based off your needs
Metrics need to include the 4 from the example below
Save time and clicks by changing the delivery format to Excel > Save and Run
Related Articles
Turning on Big Query for an Advertiser in CM360
In CM, if you enable BigQuery, it applies to the whole seat. T The data sent to the BigQuery dataset will include all advertisers, so 1 advertiser in the XM ad server seat would be receiving data from all those other accounts, which is simply not ...How to Create Default Ad Reporting in CM360
To create a default ad report, go to "Report Builder" in CM and select a "Standard" Offline report. Rename your report to something that makes sense. DO NOT leave it unnamed. Setup the report exactly like the screenshot below. Do not apply any ...Ad Auto deactivation in CM
I hate this and there is no way to turn it off. But it happens and here's why: The automatic deactivation occurs in two cases: A week passes after the end date for an ad with a hard cut-off The ad stops serving right at the end date, but won't ...CM Video Specs
As a best practice, here are CM's video specs. The below can and should be provided to account teams for the creative houses: The maximum size allowed is 1 GB. Always upload a source file with the highest possible specifications you have ...IAS + MOAT Viewability Calculation for reporting
This explains how metrics are calculated, not what the viewable guaranteed number should be on media team/mkpl ios. IAS viewability is calculated in the following manner, for reference: IAS removes any IVT from calculations, as well as blocked ...