Query to get same data as Adwords dashboard

[Carlos H. Vieira]

I have a query that get's the data from the API but the data coming is different from the dashboard. The dashboard have nothing different, basically I put yesterday and show all campaigns.

The difference is easy spotted when I see the cost. It normally have a small difference of around £30, but today I saw more than £1k for yesterday report.

My query is the following:

SELECT
 CampaignId,
 CampaignName,
 AdGroupId,
 AdGroupName,
 Id,
 Criteria,
 CriteriaType,
 QualityScore,
 AveragePosition,
 AverageCpc,
 Impressions,
 Clicks,
 Cost
FROM
 CRITERIA_PERFORMANCE_REPORT
WHERE
 Status IN [ENABLED]
DURING {$dateString}, {$dateString}

Adwords dashboard have Time zone (GMT+00:00) GMT (no daylight saving)

Thank you for the help.

[Vincent Racaza (AdWords API Team)]

Hi Carlos,

The Criteria Performance Report is a single attribution report, meaning, only one of the triggering criteria (e.g. keyword, placement, etc.) is being recorded for a given impression. This said, there is no specific mapping for this report type in the AdWords UI as the data on this report may come from different criteria, thus in the UI, this would be from different UI views/tabs. So if you are using this report type to get statistics of a specific criteria such as a keyword, then you will need to check that specific data from "Keywords view" in the UI.

However, so I can further check if you are mapping the UI and API reports correctly, can you provide to me your clientCustomerId as well as the specific date range of your API report? Also, kindly provide the UI report screenshot (with highlighted specific criteria) that shows the discrepancies. Provide these details via Reply privately to author option.

Thanks,

Vincent

AdWords API Team