Certain campaigns are not returned on Google Ads API

[Nestor Silva]

Hi there.

I'm facing some issues on getting reporting data via the Google Ads API v10. On the UI I'm able to see these campaigns, but I cant get these campaigns via API. Below is the request I'm doing:

POST Request to: https://googleads.googleapis.com/v10/customers/5984560225/googleAds:search

Request Body:

{
   "query":"SELECT customer.currency_code, campaign.name, campaign.id, ad_group.id, ad_grouicros, metrics.impressions, ad_group_criterion.keyword.match_type, ad_group_criterion.keyword.text, segments.device, bidding_strategy.status, meHERE segments.date BETWEEN '2022-07-02' AND '2022-07-02' ",
   "pageSize":1000
}

I exported the same definition of this report via UI, and I'm able to see these missing campaigns. Here are a couple of missing campaigns:

Campaign Ids:
- 17316450938
- 17316451340

Is there a default filter on the API?

Thank you in advance.

[Nestor Silva]

POST  request to: https://googleads.googleapis.com/v10/customers/5984560225/googleAds:search

Request Body:

{

          "query":"SELECT customer.currency_code, campaign.name, campaign.id, ad_group.id, ad_group.name, metrics.clicks, metrics.conversions, metrics.cost_micros, metrics.impressions, ad_group_criterion.keyword.match_type, ad_group_criterion.keyword.text, segments.device, bidding_strategy.status, metrics.conversions_value, segments.date FROM keyword_view WHERE segments.date BETWEEN '2022-07-02' AND '2022-07-02' ",

          "pageSize":1000

[Google Ads API Forum Advisor]

Hi Nestor,

Thank you for reaching out to Google Ads API support with your request log. I replicated no rows for campaign 17316450938 and this is working as intended, for when I took out the segmenting field 'bidding_strategy.status' the rows returned for campaign 17316450938. Campaign 17316450938 has a standard bidding strategy only and not a portfolio bidding strategy.

When adding a segmenting field to the query you are telling the API to only return rows associated with that field and to not return rows that don't use that field. Here's our documentation on how when adding some segments, the metrics in the summary row may decrease. The reason metrics in the summary row decrease is because the rows that don't fit aren't included in the report.

Regards,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2cTEwP:ref

[Nestor Silva]

Hi Aryeh,

Understood, it perfect make sense for me.

I have removed the bidding strategy segment and it match UI vs API.

Thank you!