The totals do not match in the ui and in the API response for the ad reports

[Noémi Molnár]

Hi,

We are trying to reproduce the same report in the Google Ads ui and from the Google Ads API. All the values for the individual ads that we compared match, but the values in the summary row does not match the ui in the case of some metrics. These metrics are: 'cost',  'impressions, 'interactions'.

Do you know what could cause these differences in the values ?

The summary row from the api: 

"summaryRow": {

"metrics": {

"clicks": "10715",

"conversions": 161,

"costMicros": "19364300139",

"currentModelAttributedConversions": 161,

"averageCost": 1803847.241639497,

"impressions": "242027",

"interactions": "10735"

}

The used query: 
```SELECT ad_group_ad.status,ad_group_ad.ad.id,ad_group_ad.ad.final_urls,ad_group_ad.ad.type,ad_group_ad.ad.display_url,ad_group_ad.ad.url_custom_parameters,ad_group_ad.ad.final_mobile_urls,ad_group_ad.ad.call_ad.phone_number,ad_group_ad.ad.call_ad.conversion_action,ad_group_ad.ad.expanded_dynamic_search_ad.description,ad_group_ad.ad.expanded_text_ad.headline_part1,ad_group_ad.ad.expanded_text_ad.headline_part2,ad_group_ad.ad.expanded_text_ad.headline_part3,ad_group_ad.ad.expanded_text_ad.description2,ad_group_ad.ad.expanded_text_ad.path1,ad_group_ad.ad.expanded_text_ad.path2,ad_group_ad.ad.text_ad.headline,ad_group_ad.ad.text_ad.description2,ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.url_collection_id,ad_group_ad.ad.gmail_ad.marketing_image,ad_group_ad.ad.responsive_display_ad.youtube_videos,ad_group_ad.ad.responsive_display_ad.promo_text,ad_group_ad.ad.responsive_display_ad.accent_color,ad_group_ad.ad.responsive_display_ad.format_setting,ad_group_ad.ad.responsive_display_ad.price_prefix,ad_group_ad.ad.responsive_display_ad.business_name,ad_group_ad.ad.responsive_display_ad.square_logo_images,ad_group_ad.ad.responsive_display_ad.logo_images,ad_group_ad.ad.responsive_display_ad.allow_flexible_color,ad_group_ad.ad.responsive_display_ad.headlines,ad_group_ad.ad.responsive_display_ad.main_color,ad_group_ad.ad.legacy_responsive_display_ad.allow_flexible_color,ad_group_ad.ad.legacy_responsive_display_ad.business_name,ad_group_ad.ad.legacy_responsive_display_ad.logo_image,ad_group_ad.ad.legacy_responsive_display_ad.long_headline,ad_group_ad.ad.legacy_responsive_display_ad.format_setting,ad_group_ad.ad.legacy_responsive_display_ad.main_color,ad_group_ad.ad.legacy_responsive_display_ad.promo_text,ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image,ad_group_ad.ad.legacy_responsive_display_ad.call_to_action_text,ad_group_ad.ad.legacy_responsive_display_ad.square_logo_image,ad_group_ad.ad.legacy_responsive_display_ad.short_headline,ad_group_ad.ad.legacy_responsive_display_ad.price_prefix,ad_group_ad.ad.responsive_search_ad.headlines,ad_group_ad.ad.responsive_search_ad.descriptions,ad_group_ad.ad.responsive_search_ad.path1,ad_group_ad.ad.responsive_search_ad.path2,ad_group_ad.ad.image_ad.name,ad_group_ad.ad.image_ad.image_url,ad_group_ad.ad.image_ad.pixel_height,ad_group_ad.ad.image_ad.pixel_width,ad_group_ad.ad.video_ad.media_file,ad_group_ad.ad.video_ad.bumper.companion_banner,ad_group_ad.ad.video_ad.in_stream.companion_banner,ad_group_ad.ad.video_ad.non_skippable.companion_banner,ad_group_ad.ad.name,ad_group_ad.ad.call_ad.headline1,ad_group_ad.ad.call_ad.headline2,ad_group_ad.ad.call_ad.description1,ad_group_ad.ad.call_ad.description2,ad_group_ad.ad.call_ad.phone_number_verification_url,ad_group_ad.ad.call_ad.conversion_reporting_state,ad_group_ad.ad.call_ad.country_code,ad_group_ad.ad.call_ad.business_name,ad_group_ad.ad.call_ad.disable_call_conversion,ad_group_ad.ad.call_ad.call_tracked,ad_group_ad.ad.expanded_text_ad.description,ad_group_ad.ad.text_ad.description1,ad_group_ad.ad.gmail_ad.teaser.headline,ad_group_ad.ad.gmail_ad.marketing_image_headline,ad_group_ad.ad.gmail_ad.marketing_image_description,ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text_color,ad_group_ad.ad.gmail_ad.teaser.business_name,ad_group_ad.ad.gmail_ad.teaser.description,ad_group_ad.ad.gmail_ad.header_image,ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text,ad_group_ad.ad.gmail_ad.product_images,ad_group_ad.ad.gmail_ad.teaser.logo_image,ad_group_ad.ad.gmail_ad.product_videos,ad_group_ad.ad.responsive_display_ad.descriptions,ad_group_ad.ad.responsive_display_ad.call_to_action_text,ad_group_ad.ad.responsive_display_ad.long_headline,ad_group_ad.ad.responsive_display_ad.square_marketing_images,ad_group_ad.ad.responsive_display_ad.marketing_images,ad_group_ad.ad.legacy_responsive_display_ad.description,ad_group_ad.ad.legacy_responsive_display_ad.marketing_image,ad_group_ad.ad.legacy_responsive_display_ad.accent_color,ad_group_ad.ad.app_ad.mandatory_ad_text,ad_group_ad.ad.video_ad.out_stream.headline,ad_group_ad.ad.video_ad.in_stream.action_headline,ad_group_ad.ad.app_ad.headlines,ad_group_ad.ad.video_ad.out_stream.description,ad_group_ad.ad.app_ad.descriptions,ad_group_ad.ad.url_collections,ad_group_ad.ad.app_ad.images,ad_group_ad.ad.image_ad.preview_image_url,ad_group_ad.ad.app_ad.youtube_videos,ad_group_ad.ad.image_ad.preview_pixel_width,ad_group_ad.ad.image_ad.preview_pixel_height,ad_group_ad.ad.app_engagement_ad.descriptions,ad_group_ad.ad.app_engagement_ad.headlines,ad_group_ad.ad.app_engagement_ad.images,ad_group_ad.ad.app_engagement_ad.videos,ad_group_ad.ad.display_upload_ad.media_bundle,ad_group_ad.ad.local_ad.headlines,ad_group_ad.ad.local_ad.descriptions,ad_group_ad.ad.local_ad.call_to_actions,ad_group_ad.ad.local_ad.marketing_images,ad_group_ad.ad.local_ad.logo_images,ad_group_ad.ad.local_ad.videos,ad_group_ad.ad.video_ad.discovery.description1,ad_group_ad.ad.video_ad.discovery.description2,ad_group_ad.ad.video_ad.discovery.headline,ad_group_ad.ad.video_ad.in_stream.action_button_label,ad_group_ad.ad.app_ad.html5_media_bundles,ad_group_ad.ad.shopping_product_ad,ad_group_ad.ad.hotel_ad,ad_group_ad.ad.legacy_app_install_ad,ad_group_ad.ad.shopping_comparison_listing_ad.headline,ad_group_ad.ad.shopping_smart_ad,metrics.cost_micros,metrics.impressions,metrics.interactions,metrics.average_cost,metrics.conversions,metrics.current_model_attributed_conversions,metrics.clicks FROM ad_group_ad WHERE metrics.impressions > 0 AND ad_group_ad.status IN ("ENABLED","PAUSED") AND segments.date >= '2021-09-01' AND segments.date <= '2021-09-30'```

[Google Ads API Forum Advisor]

Hello,

Thanks for reaching out. I would recommend double checking that all filters in the UI are the same as specified in the query (e.g. ensure that 'removed' ads are not included in the UI). If you continue to see the discrepancy, you can reply to us privately with the complete request and response logs, and a screenshot of the UI showing the discrepancy.

Regards,
Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2QEtj2:ref

[Google Ads API Forum Advisor]

Hi Noémi,

Thank you for the logs, you gave me a tough case! I reproduced your discrepancy. The issue is that in the UI, the standard filter filters out all Ad Groups that are removed. When I went into the "Ad Groups" screen and changed the standard filter of Ad Group status of "Enabled, Paused" to "All" then in the "Ads" screen the numbers matched those of your API report.

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2QFvUd:ref