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
[image: image.png]
And without Query Field
SELECT CampaignId, AdGroupId, Impressions, Clicks, Conversions
Total click : 6
And without Query FieldSELECT CampaignId, AdGroupId, Impressions, Clicks,
Conversions, CostFROM SEARCH_QUERY_PERFORMANCE_REPORT
WHERE CampaignId = CId, AdGroupId = GId
DURING LAST_7_DAYS
Total click : 17
[image: image (1).png]
SELECT CampaignId, AdGroupId, Impressions, Query, Cli
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
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'
]
