number of rows returned is different in v9 compared with v7 for the same query

[David Boissier]

Hello,

We are migrating from the v7 to v9 of google-ads API. We have some non-regression testing and we found a strange behavior of the v9.

It returns more than the v7 version and the metrics are not the same.

Here below the v7 version query :

SELECT AccountCurrencyCode, AccountDescriptiveName, AdNetworkType2, Ctr, Criteria, CampaignId, CampaignName, CampaignStatus, Device, Impressions, Interactions, InteractionTypes, Clicks, Conversions, VideoViews, Cost, Date

FROM GENDER_PERFORMANCE_REPORT

WHERE CampaignStatus IN ['ENABLED', 'PAUSED', 'REMOVED']
AND Impressions > 0
DURING <start_date>, <end_date>

And the v9 version query :

SELECT
customer.currency_code,
customer.descriptive_name,
campaign.id,
segments.ad_network_type,
campaign.name,
campaign.status,
metrics.clicks,
metrics.conversions,
metrics.video_views,
metrics.cost_micros,
metrics.ctr,
segments.date,
segments.device,
metrics.impressions,
metrics.interactions,
metrics.interaction_event_types,
ad_group_criterion.gender.type
FROM gender_view
WHERE campaign.status in ('ENABLED', 'PAUSED', 'REMOVED')
AND metrics.impressions > 0
AND segments.date BETWEEN '<start_date>' AND '<end_date>'

What we found is whenever we aggregate the results by a certain number of columns, we retreive the same number of rows returned from the v7 query and with correct metrics.

This seems to be specific to gender_view and age_range_view. The others such as geo_view; keyword_view do not have the above problem.

Could you help us on that ?

Thanks.

[Google Ads API Forum Advisor]

Hello David,

Thank you for reaching out to us.

So our team can better check on this, can you share to us the following details below?

• complete report definition in XML or AWQL form (including the actual values of the start and end date)
• complete API logs (request and response with request-id)
• Screenshots showing the strange behavior mentioned

Please send the requested details via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Regards,

Mark Kevin Google Ads API Team

ref:_00D1U1174p._5004Q2XjvKl:ref