AgeRangeView, GenderView, etc. Campaign Level Reports - Google Ads API v6

[Jake Nieto]

Hi,

I am currently trying to generate reports that segment the metrics data on variables like age, gender, income, etc., but on the campaign level (i.e. reports that are akin to the GENDER_PERFORMANCE_REPORT, AGE_RANGE_PERFORMANCE_REPORT, etc in the Adwords API).

As of right now, I am able to generate reports that segment the data on the ad_group level by selecting the ad_group_criterion.<variable>.type. I tried selecting the campaign_criterion.<variable>.type field but this gave me this error:

 error_code {

    query_error: PROHIBITED_RESOURCE_TYPE_IN_SELECT_CLAUSE

  }

  message: "Cannot select fields from the following resource: \'CAMPAIGN_CRITERION\', since the resource is incompatible with the resource in FROM clause."

After reading the docs more closely I see that it says, "These fields [campaign_criterion] will not segment metrics in your SELECT clause."

Will I have to aggregate the data on the ad_group level to get the reports for the campaign level, or is there a way to leverage the Google Ads API differently to get the data on the campaign level?

Thanks,

Jake