Hi Asad, Thanks for reaching out to the Google Ads API Forum.
Since you mentioned attempting to add the ad_group_ad.ad.type dimension in the SELECT clause, an increase in the number of rows for your provided GAQL. I’ve checked your GAQL, and it’s not valid as seen below: Upon checking, kindly note that the field ad_group_ad.ad.type is a segments field as report ad_group_ad is segmented to video report. You may check the following scenario if it is happening on your end: Zero metrics are always excluded when segmenting a report, provided all selected metrics are zero Any segment fields from your select clause in the GAQL query filters that segment is telling the query to only get the rows of data said segments fields. Note that zero metrics campaigns records shown on Ads UI, however, Google Ads API excludes and does not pull when segmenting a report, provided all selected metrics are zero. You may check here for more information. Also, when any segments fields are added to a query with FROM ad_group_ad, that segment is telling the query to only get the rows of data that have said segments field, and remove any row that is not associated. These both scenarios may also affect in combination with each other. That being said, you may double check on your end if for the given dates in a date range, if there are zero metrics for a given date range, then the API doesn't pull the row if the row is segmented and has no metrics for that date range. If the above scenario is not happening, then you may provide the following details via reply privately to author option: Complete request and response logs with request ID generated for said report Complete Ads UI screenshot without cropping showing date filters Regards, Yasar Google Ads API Team ref:_00D1U1174p._5004Q2iMO3N:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/rVarV000000000000000000000000000000000000000000000ROXAQ400AGlyhmt6TlmzX3YJOrvZlQ%40sfdc.net.
