Different campaign report results when using location

[Scott Vaillancourt]

I'm trying to produce a report using the Google Ads API that includes totals for impressions, clicks and cost at the campaign/metro area level. I understand that if geographic information isn't available then data won't be returned from the geographic_view. In order to get all data for a campaign, I'm retrieving campaign-level data and comparing that to totals at the metro area level. I would expect that the campaign level data would always be greater than or equal to the geographic data since geographic data may sometimes be missing. However, what I've found is a case where totals for geographic-level data are greater than what the campaign is showing.

I'm trying to understand why the two results would differ in this manner and which one is accurate. Thanks.

Scott

[Scott Vaillancourt]

Looks like the data I pasted didn't come through in the original post.

Additionally, here's the GAQL I'm using to create the data.

query = '''

    SELECT

        segments.date,

        campaign.name,

        metrics.impressions,

        metrics.clicks,

        metrics.cost_micros

    FROM campaign

    WHERE

        segments.date BETWEEN "{:s}" AND "{:s}"

        AND metrics.impressions > 0

    ORDER BY segments.date ASC, campaign.name ASC

    LIMIT 100000'''.format(start, end)

query = '''

    SELECT

        campaign.name,

        metrics.impressions,

        metrics.clicks,

        metrics.cost_micros,

        segments.geo_target_metro,

        segments.date

    FROM geographic_view

    WHERE

        segments.date BETWEEN "{:s}" AND "{:s}"

        AND metrics.impressions > 0

    ORDER BY segments.date ASC, campaign.name ASC

    LIMIT 100000'''.format(start, end)

[Google Ads API Forum Advisor Prod]

Hi Scott,

Thank you for reaching out.

Could you also share your customer ID, and the complete request and response logs with the request ID, when you generated the reports?

You may send the requested details using the Reply privately to author option.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q278Ghw:ref

[Scott Vaillancourt]

Hi Peter,

I don't have permission to 'Reply privately to author' and would need some other mechanism to send you the information you're requesting. Also, I'm not sure where I'd capture the response log or request ID. Thanks.

Scott

[Google Ads API Forum Advisor Prod]

Hi Scott,

Please provide the requested details to the email address below instead.

• googleadsa...@google.com

Also, please refer to the helpful links below for enabling the logging of specific client libraries that you are using:

• Java - https://developers.google.com/google-ads/api/docs/client-libs/java/logging
• .NET - https://developers.google.com/google-ads/api/docs/client-libs/dotnet/logging
• PHP - https://developers.google.com/google-ads/api/docs/client-libs/php/logging
• Python - https://developers.google.com/google-ads/api/docs/client-libs/python/logging
• Ruby - https://developers.google.com/google-ads/api/docs/client-libs/ruby/logging
• Perl - https://developers.google.com/google-ads/api/docs/client-libs/perl/logging

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q278Ghw:ref