Reach Report for Ads

[oks...@tapclicks.com]

Hi guys! I'm a newbie in DoubleClick Campaign Manager and really hope to get some help here.

I'm puling Standard report for Ads and it works fine, request parameters are:
{"criteria":{"dateRange":{"startDate":"2017-04-21","endDate":"2017-04-25"},"dimensions":[{"name":"dfa:campaignId"},{"name":"dfa:date"},{"name":"dfa:adId"},{"name":"dfa:ad"},{"name":"dfa:adStatus"},{"name":"dfa:adType"},{"name":"dfa:creativeSize"}],"metricNames":["dfa:clicks","dfa:impressions", "dfa:totalConversions", "dfa:totalConversionsRevenue", "dfa:activityClickThroughConversions", "dfa:activityViewThroughConversions", "dfa:mediaCost", "dfa:activityViewThroughRevenue", "dfa:activityClickThroughRevenue"],"dimensionFilters": [   {"dimensionName": "dfa:advertiser","id": "4853420","matchType": "EXACT"}]},"fileName":"api_report_files","name":"ads_report","type":"STANDARD"}
Call URL is $call_url = 'https://www.googleapis.com/dfareporting/v2.7/userprofiles/'.$dfa_profile_id.'/reports';

When I try to pull a very simple Reach report for the same advertiser I get an error:

 "code": 400,
 "message": "The combination of dimensions, metrics, and filters in your report is invalid."
Request parameters are:
{"reachCriteria":{"dateRange":{"startDate":"2017-04-21","endDate":"2017-04-25"},"dimensions":[{"name":"dfa:campaignId"},{"name":"dfa:date"},{"name":"dfa:adId"},{"name":"dfa:ad"}],
"metricNames":["dfa:clicks","dfa:impressions", "dfa:totalConversions", "dfa:totalConversionsRevenue", "dfa:activityClickThroughConversions", "dfa:activityViewThroughConversions", "dfa:mediaCost", "dfa:activityViewThroughRevenue", "dfa:activityClickThroughRevenue"],
"dimensionFilters": [   {"dimensionName": "dfa:advertiser", "id": "4853420","matchType": "EXACT"}]},"fileName":"api_report_files","name":"ads_report","type":"REACH"}
Same error for reduced call:
{"reachCriteria":{"dateRange":{"startDate":"2017-04-21","endDate":"2017-04-25"},"dimensions":[{"name":"dfa:ad"}],"metricNames":["dfa:clicks","dfa:impressions"]},"fileName":"api_report_files","name":"TAPCLICKS-API-PLACEMENT-REPORT","type":"REACH"}

What do I miss? I thought it is possible to get Reach report for Ads as dfa:ad is mentioned here https://developers.google.com/doubleclick-advertisers/v2.7/dimensions#reach-dimensions?DoubleClick Campaign Manager ?

Thanks in advance! 

[Lakshmi(DCM API Team)]

Hi,

I recommend to create the report in the UI first and retrieve that report in the API. This way you will get a better idea on the possible combinations of dimensions, metrics and filters for a given DCM account. If you are able to run the report in UI but not in the API, please send the DCM account Id in a private message.

Thanks,

Lakshmi, DCM API Team

[oks...@tapclicks.com]

Thanks Lakshmi. Unfortunately I don't have access to DCM UI, have only OAuth token for API.
Is combination of dimensions, metrics and filters account specific? I search for universal solution for various accounts.
I'll send you specific IDs in private email. Thanks!

[oks...@tapclicks.com]

Thanks Lakshmi for answering in private mode.
The answer was in enableAllDimensionCombinations: true which I needed to use.

My last question on this Ads report. "dfa:creativeSize" can't be included in Reach report dimensions according to spec.
But isn't there 1 to 1 relation between DFA Ad and Creative? I see Ad name always including creative size, like "UK - The Economist 300x600", "728x90 Default Web Ad". How wrong it will be to pull Reach report and then add creativeSize from Standard report in my product?

Thanks so much!

[Lakshmi(DCM API Team)]

Hi,

I recommend to go through the available dimensions and metrics list to have an idea on available dimension and metrics for a given report type. Your questions can be best addressed by general support as it is more of a product related question. Please contact them here.

[oks...@tapclicks.com]

Thanks Lakshmi!