Geoe Target Performance with matrics in campaign level

[Traktor Quick]

Hallo Google ads API team

 I was try to retrive geo target data and matrics  in campaing level with this query

query1 = """SELECT
  geo_target_constant.canonical_name,
  geo_target_constant.country_code
  FROM geo_target_constant """

query2 ="""
        SELECT
        campaign.id,
        campaign.name,
        campaign.status,
        campaign_criterion.location.geo_target_constant
        FROM campaign_criterion
        WHERE campaign.status = 'ENABLED'
        """

query1 to get all name geo target and query2 to get geo target in camapign level, and than how to get geo traget with matrics like impression, cpc and others ? i was try use geographic_view but i don't know to join with query1 or query2, can you give me best practics for this case ?

[Google Ads API Forum Advisor]

Hi,

The geographic_view aggregates at the country level, one row per country, via the geographic_view.country_criterion_id. If the geo_target_constant.id is a country type, you can use it as filter for the mentioned geographic_view country ID field.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2UjXuw:ref

[Traktor Quick]

So, if my target location campaign is a province or district, then  geographic_view  won't be aggregated by province or district?

[Google Ads API Forum Advisor]

Hello Traktor,

Thanks for getting back to us. With respect to your query, if your target on location campaign is a province or district then you may aggregate it at the location_view, it summarizes the performance of campaigns by Location criteria.
Hope this helps. Let us know if you have any further questions.

Best regards,

Jakeia Sabrina Google Ads API Team

 

ref:_00D1U1174p._5004Q2UjXuw:ref

[Traktor Quick]

ok thanks, now i have got the data as i expected

[Google Ads API Forum Advisor]

Hello Traktor,

Glad to know that the issue has been resolved. Please let us know if we can help with anything else.

Regards,