While fetching the Google data from campaign , API is showing lesser number of records than what is already there in Google Adwords

55 views
Skip to first unread message

Pankaj Kumar Chibhrani

unread,
Sep 25, 2020, 1:16:24 PM9/25/20
to AdWords API and Google Ads API Forum
While fetching the Google data for campaign , API is showing lesser number of records than what is already there in Google Ads.

There are 963 records in Google for different campaigns belonging to 8 different accounts while Google API is showing only 315 . Why?

Thanks and Regards,
Pankaj Chibhrani

Google Ads API Forum Advisor Prod

unread,
Sep 25, 2020, 3:48:43 PM9/25/20
to pankaj.c...@successive.tech, adwor...@googlegroups.com
Hi Pankaj,

Can you please share with me the report definition, API results and a screenshot of your UI through reply privately to author so I can take a closer look?

Thanks,
Anthony
Google Ads API Team

Google Logo
Anthony
Google Ads API Team
 


ref:_00D1U1174p._5004Q25Wwsd:ref

Pankaj Kumar Chibhrani

unread,
Oct 8, 2020, 2:26:29 AM10/8/20
to AdWords API and Google Ads API Forum
Hi Team,

Here is the query :

SELECT campaign.name,campaign.optimization_score,metrics.impressions,metrics.cost_micros,
metrics.conversions_value,
metrics.interaction_rate,metrics.interactions,metrics.average_cost,metrics.cost_per_conversion,
metrics.conversions,
metrics.conversions_from_interactions_rate,segments.date,
campaign.status,campaign.id,campaign_budget.amount_micros,
campaign.name,campaign.status, campaign.start_date,campaign.end_date,
campaign_budget.has_recommended_budget,metrics.clicks,metrics.average_cpc,metrics.ctr,
campaign_budget.recommended_budget_amount_micros from campaign
where segments.date DURING TODAY AND campaign.status = 'ENABLED'
AND campaign.advertising_channel_type='SEARCH'

We were getting only 315 campaigns but Google was showing 963.

Thanks and Regards,
Pankaj Chibhrani

Google Ads API Forum Advisor Prod

unread,
Oct 8, 2020, 12:48:52 PM10/8/20
to pankaj.c...@successive.tech, adwor...@googlegroups.com
Hello Pankaj,

Thanks for the query. I still need the API results and UI screenshots. Please send those via reply privately to author.

Regards,
Reply all
Reply to author
Forward
0 new messages