RE: Age report missing data

[Google Ads API Forum Advisor]

Hi,

Thank you for your questions.

The campaign report aggregates all the metrics (ex. impressions) accumulated at 
the campaign level. Meaning, this report should contain as well the metrics 
from all other criteria (if other types are also being targeted) that triggered 
the ads under the said campaign.

On the other hand, the age_range_view will only return statistics aggregated at 
the age range criterion.  I hope this helps.

Best regards,

Peter Laurence Napa Oliquino
Google Ads API Team
ref:_00D1U1174p._5004Q2IxL3U:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/dhHGY0QV57T800gCan_DL3Q4681rxIwDHgMA%40sfdc.net.

Age report missing data

[lezhne...@gmail.com]

Hello! 

I am comparing the two reports:
- one the total campaign report
- and the other one that segments data by age groups

Age report contains a small fraction of data compared to campaign report. 
In my case around ~800 impressions in campaign report compared to ~20 in 
age report.
Can you tell why it happens? 

I am providing the GQL that I am using to make reports:

*Campaign report:*
SELECT 

metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.conversions,

segments.date,
customer.currency_code

FROM campaign

WHERE campaign.status IN ('ENABLED','PAUSED','REMOVED')
AND segments.date BETWEEN %s AND %s 
AND campaign.resource_name = '%s'

*Age report:*
SELECT 

metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.conversions,

segments.date,
customer.currency_code,
ad_group_criterion.age_range.type

FROM age_range_view
WHERE 
segments.date BETWEEN %s AND %s AND 
campaign.resource_name IN ('%s')

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/dd3175d2-fd09-4d51-b83f-3a5c11b86d71n%40googlegroups.com.