Search Query Performance Report do not get/count all clicks when using "Query" field

[saidul alam]

1. this show " clicks: 22  " at LAST_7_DAYS

$query = (new ReportQueryBuilder())
->select([
'Month',
'AdGroupName',
'AdGroupId',
'CampaignId',
'CampaignName',
'Cost',
'AverageCpc',
'Clicks',
'Impressions',
'Ctr',
'Conversions',
'NumOfflineInteractions',
'CostPerConversion',
'SearchImpressionShare'
])
->from(ReportDefinitionReportType::ADGROUP_PERFORMANCE_REPORT)

->build();

2. this show " clicks: 10  " at LAST_7_DAYS

$query = (new ReportQueryBuilder())
->select([
'CampaignId',
'AdGroupId',
'Query',
'Impressions',
'Clicks',
'Conversions',
'Cost'
])
->from(ReportDefinitionReportType::SEARCH_QUERY_PERFORMANCE_REPORT)

->build();

when I remove 'Query' from select it works fine. But I must need this field.

[Google Ads API Forum Advisor Prod]

Hi Saidul,

Thank you for reaching out to our API support team.

Our team does not usually recommend comparing reports of different types since metrics are calculated and attributed to different entities which the reports specializes in. For your scenario, since you included the Query field, then records that were not triggered by or associated to the said query may have been excluded.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2FafRA:ref