Re: Need all rows and not aggregated data.

2021-11-23 Thread 'Google Ads API Forum Advisor' via AdWords API and Google Ads API Forum
Hi Aakash, I am also a member of Google Ads API Support. Let me assist you with this. Upon checking the attached campaign_report_to_csv_results.csv file, I found python code instead of log results. For us to impersonate the resource campaign (campaign report), could you provide us the customer

Re: Need all rows and not aggregated data.

2021-11-23 Thread Akash Prajapati
Can you please provide any update on the same. thanks On Tuesday, November 23, 2021 at 11:00:37 AM UTC+5:30 Akash Prajapati wrote: > Hello Team, > > 1. The modified query still we get aggregated results. - > query = """ > SELECT > campaign.id, > campaign.status, > campaign.name, > segments.date

Re: Need all rows and not aggregated data.

2021-11-22 Thread Akash Prajapati
Hello Team, 1. The modified query still we get aggregated results. - query = """ SELECT campaign.id, campaign.status, campaign.name, segments.date, segments.ad_network_type, metrics.impressions FROM campaign WHERE segments.date = '2021-11-13' and metrics.impressions >= 0 and campaign.status IN (

Re: Need all rows and not aggregated data.

2021-11-22 Thread 'Google Ads API Forum Advisor' via AdWords API and Google Ads API Forum
Hi Akash, I work with Peter and will assist you. For the discrepancy in Ads API and AdWords API regarding rows of campaign returned, let me tell you a general rule that most probably applies apply to your situation, that in the Ads API zero impressions are always excluded when segmenting a repo

Re: Need all rows and not aggregated data.

2021-11-22 Thread Akash Prajapati
Hello Team, Thanks for the quick response! 1. The issue is when we are querying the Campaign_Performance _Report to fetch the data we are not getting all the total distinct rows, instead, we are getting aggregated data for each campaign_id. Suppose the total rows for a particular date 2021-11-

RE: Need all rows and not aggregated data.

2021-11-21 Thread 'Google Ads API Forum Advisor' via AdWords API and Google Ads API Forum
Hi Jayant, Thank you for reaching out to our API support team. For more information on the reporting feature of the Google Ads API, I would recommend that you refer to this guide. You may note as well that API reports specialize and provide statistics on different entities (see here the list of