Search Query Performance Report do not show exact count of clicks

[saidul alam]

Search Query Performance Report do not show exact count of clicks when select attribute named  Query.

CODE:

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

[Google Ads API Forum Advisor Prod]

Hi Saidul,

So our team can further investigate, could you share your customer ID and the complete report definition in XML or AWQL form? You may also include any dates that you have used.

You may then send the requested details using the Reply privately to author option.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2Fagzm:ref

[saidul alam]

SELECT CampaignId, AdGroupId, Impressions, Query, Clicks, Conversions, CostFROM SEARCH_QUERY_PERFORMANCE_REPORT
WHERE CampaignId = Cid, AdGroupId = Gid
DURING LAST_7_DAYS

Get Total click : 6

And without Query Field

SELECT CampaignId, AdGroupId, Impressions, Clicks, Conversions, CostFROM SEARCH_QUERY_PERFORMANCE_REPORT
WHERE CampaignId = Cid, AdGroupId = Gid
DURING LAST_7_DAYS

Get Total click : 17

[Google Ads API Forum Advisor Prod]

Hi Saidul,

Thank you for providing the requested details.

I tried to replicate the issue on my end using the report definition and the customer ID that you've provided. However, I generated an empty report because of the 2 filters below:

CampaignId = 121969996681, AdGroupId = 121969996521

The reason is, the campaign with ID 121969996681 is not existing when I checked on my end. With this, could you provide the report definition with the exact filters so that I can further investigate? I would recommend to send your reply via Reply privately to author option.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2Fagzm:ref