GOOGLE ADS API] Missing campaign data using location_view

[silientsee]

Hi Team!

I'm trying to get the data from location_view breakdown by campaign. but missing one of campaign which could found in campaign view?

SELECT
location_view.resource_name,
campaign_criterion.location.geo_target_constant,
metrics.conversions_value,
metrics.clicks,
metrics.ctr,
metrics.impressions,
metrics.average_cpm,
metrics.cost_micros,
campaign.id, campaign.name, segments.date FROM location_view
where metrics.impressions > 0 AND segments.date DURING YESTERDAY

I'm sure impression > 0 is true

Can you please tell me how to fix it?

Thank you very much for your help

[Google Ads API Forum Advisor Prod]

Hello,

Thanks for reaching out! In order for me to take a closer look, can you please provide your customerClientId along with the campaign ID of the missing campaign? 

Please provide these details via the Reply privately to author ​​​​​​​option.

Regards,

Danica Google Ads API Team

ref:_00D1U1174p._5004Q25WX8Q:ref

[silientsee]

I solved the problem by changing location_view to geographic_view

Thank you anyway

[Google Ads API Forum Advisor Prod]

Hello,

Glad to hear you were able to resolve your issue. If you have any additional questions, please do not hesitate to reach out to us again.