Empty response stream from an account, JAVA GoogleAdsServiceClient

[lawrence kalinowski]

Using JAVA, I programmatially download campaign performance data (cost,click,impressions,etc).

I do this for multiple accounts, for the most part successfully. But only 1 doesn't have any content in the resultant stream. Note, the account does have active campaigns.

I can't figure out why this account would provide no data when the API is queried.

If it helps, this Account is linked to Google Analytics. the data IS visible in Universal Analytics BUT it is not visible in Google Analytics 4.

Let me know what steps I can take to troubleshoot the issue.

thanks

[Google Ads API Forum Advisor]

Hi there,

Thanks for reaching out to the Google Ads API Forum.

Since you mentioned that the only one account does not return the campaign performance data on your end, could you please confirm if you could see the campaign performance data  on Google Ads UI's report? Please note that Google Ads API mirrors Google Ads UI, and not Google Analytics.

That said, for us to investigate further, could you provide the following details?

• Complete logs in the format of the request and response logs along with the request-id, as seen in their respective links for the API request where you didn’t get performance data
• Compete Ads UI screenshot without cropping.

​​Kindly send the above details via reply privately to author option. 

This message is in relation to case "ref:_00D1U1174p._5004Q2mUlYT:ref"

Thanks,
 

Google Ads API Team

[lawrence kalinowski]

sent the requested information yesterday. lmk if you need additional information.  appreciate the help.

[Google Ads API Forum Advisor]

Hi,

Thanks for getting back to us.

Upon checking your UI screenshot, I can see that you are in the Campaigns UI screen. You may refer to the Query Cookbook guide in replicating Google Ads UI screens. For the Campaigns screen in your screenshot, you may refer to the Campaigns screen query cookbook. You can use these queries as is or as starting points for constructing your own customized queries.

I tried to query the same data via API using the Campaign report and I was able to pull the same data and metrics with that of the UI.

Sample query.

SELECT 
  campaign.name, 
  campaign_budget.amount_micros, 
  campaign.status, 
  campaign.optimization_score, 
  campaign.advertising_channel_type, 
  metrics.clicks, 
  metrics.impressions, 
  metrics.ctr, 
  metrics.average_cpc, 
  metrics.cost_micros, 
  campaign.bidding_strategy_type 
FROM campaign 
WHERE 
  campaign.status != 'REMOVED' 
  AND campaign.id = {ID of the Campaign} 
  AND segments.date BETWEEN '2023-06-01' AND '2023-06-20' 

Let us know how it goes on your end.

Reference links included in this email:

• Query Cookbook: https://developers.google.com/google-ads/api/docs/query/cookbook
• Campaigns screen query cookbook: https://developers.google.com/google-ads/api/docs/query/cookbook#campaigns
• Campaign report: https://developers.google.com/google-ads/api/fields/v13/campaign
• Campaign report query builder - https://developers.google.com/google-ads/api/fields/v13/campaign_query_builder

[Jim]

additional information sent. my UI was incorrect. Keyword UI supplied

[Jim]

search term query is also unproductive.

SELECT search_term_view.search_term,
  segments.keyword.info.match_type,
  search_term_view.status,
  campaign.name,
  ad_group.name,

  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros,

  campaign.advertising_channel_type
FROM search_term_view

WHERE segments.date DURING LAST_7_DAYS