Hi.
Every midnight I retrieve data from adwords for passed day and store in
database. Today I've found out that summarizing stored daily stats don't
match with data received for time span from AdWords.
That is sum($this->getStats($adwords_id, '20150622',
'20150623'), $this->getStats($adwords_id, '20150622', '20150623'), ...) !=
$this->getStats($adwords_id, '20150622', '20150624');
How so? Is there something I've missed in documentation?
This is my report retrieval function:
const ADWORDS_VERSION = 'v201506';
public function getStats($adwords_id, $dateStart, $dateEnd)
{
$user = new AdWordsUser(Yii::$app->params['google_config']);
$user->SetClientCustomerId($adwords_id);
$user->LoadService('ReportDefinitionService',
self::ADWORDS_VERSION);
// Create selector.
$selector = new \Selector();
$selector->fields = ['CampaignId', 'CampaignName', 'Impressions',
'Clicks', 'Cost', 'AverageCpc'];
$selector->dateRange = new \DateRange($dateStart, $dateEnd);
$reportDefinition = new \ReportDefinition();
$reportDefinition->selector = $selector;
$reportDefinition->reportName = 'Campaign performance report';
$reportDefinition->dateRangeType = 'CUSTOM_DATE';
$reportDefinition->reportType = 'CRITERIA_PERFORMANCE_REPORT';
$reportDefinition->downloadFormat = 'XML';
// Exclude criteria that haven't recieved any impressions over the
date range.
$reportDefinition->includeZeroImpressions = TRUE;
// Set additional options.
$options = ['version' => self::ADWORDS_VERSION];
// Download report.
$report = \ReportUtils::DownloadReport($reportDefinition, null,
$user, $options);
// Parse data
$report = new \SimpleXMLElement($report);
$stats = [
'impressions' => 0,
'clicks' => 0,
'cost' => 0
];
foreach($report->table->row as $row){
foreach($row->attributes() as $attr => $value){
if (isset($stats[$attr])) {
$stats[$attr] += $value;
}
}
}
$stats['cost'] = $stats['cost'] ? ($stats['cost'] / 1000000) : null;
$stats['avgCPC'] = $stats['cost'] && $stats['clicks'] ?
round($stats['cost'] / $stats['clicks'], 2) : null;
return $stats;
}
Example results are:
Retrieving for 2015-06-22 - 2015-06-24
Retrieved time span:
Array
(
[impressions] => 259
[clicks] => 22
[cost] => 299.2
[avgCPC] => 13.6
)
Summarized results:
Array
(
[impressions] => 329
[clicks] => 30
[cost] => 408.16
[avgCPC] => 13.605
)
Per line:
Array
(
[0] => Array
(
[impressions] => 140
[clicks] => 15
[cost] => 195.72
[avgCPC] => 13.05
)
[1] => Array
(
[impressions] => 189
[clicks] => 15
[cost] => 212.44
[avgCPC] => 14.16
)
)
(not sure if that helps w/o actual data, but just in case).
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
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
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/adwords-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/ca545b3c-6d53-4265-af0a-77fcbfa40768%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
