Hi there,
We are using the .NET client library 14.7.0.0 to calculate the total clicks
on a specific day using the AD_PERFORMANCE_REPORT. When we compare these
results with the totals shown in the Adwords UI (Campaigns -> All online
campaigns -> Ads) there is a difference. The cause of this difference is
missing rows in the AD_PERFORMANCE_REPORT report.
By looking at the adIDs we can figure out which ads are missing in the
report. These ads are not any different from the ones that are present.
We've checked stuff like AdGroup status, impressions, etc.
Below is the code we use to calculate the total of clicks for yesterday
(clicksYesterday).
How can we find out why certain ads are missing or how to solve it?
// Create selector
Selector selector = new Selector();
selector.fields = new string[]
{
"AdNetworkType2",
"AdNetworkType1",
"AdGroupName",
"AdGroupId",
"AdGroupStatus",
"Status",
"AdType",
"CampaignName",
"CampaignId",
"CampaignStatus",
"Clicks",
"Conversions",
"Cost",
"CostPerConversion",
"AverageCpc",
"AverageCpm",
"CreativeDestinationUrl",
"Description1",
"Description2",
"Url",
"DisplayUrl",
"Headline",
"Id",
"ImageCreativeName",
"ImageAdUrl",
"Impressions",
"AveragePosition",
"Date",
};
selector.dateRange = new DateRange();
selector.dateRange.min =
DateTime.Now.Date.AddMonths(-6).ToString("yyyyMMdd");
selector.dateRange.max = DateTime.Now.Date.ToString("yyyyMMdd");
// Add predicates
selector.predicates = new Predicate[] {
new Predicate()
{
field = "Status",
@operator = PredicateOperator.IN,
values = new string[] { "ENABLED", "PAUSED", "DISABLED" }
},
new Predicate()
{
field = "AdGroupStatus",
@operator = PredicateOperator.IN,
values = new string[] { "ENABLED", "PAUSED", "DELETED" }
},
new Predicate()
{
field = "CampaignStatus",
@operator = PredicateOperator.IN,
values = new string[] { "ACTIVE", "PAUSED", "DELETED" }
},
};
// Create report definition
ReportDefinition reportDefinition = new ReportDefinition();
reportDefinition.reportName = "Test - Creative performance report";
reportDefinition.dateRangeType = ReportDefinitionDateRangeType.CUSTOM_DATE;
reportDefinition.reportType =
ReportDefinitionReportType.AD_PERFORMANCE_REPORT;
reportDefinition.downloadFormat = DownloadFormat.XML;
reportDefinition.selector = selector;
reportDefinition.includeZeroImpressions = true;
// Download the report
ReportUtilities reportUtilities = new ReportUtilities(this.User);
reportUtilities.ReportVersion = "v201206";
reportUtilities.DownloadClientReport(reportDefinition,
@"c:\temp\adperformance.xml");
// Extract ids
List<long> adIdsYesteday = new List<long>();
long clicksYesterday = 0;
using (FileStream fileStream = new FileStream(@"c:\temp\adperformance.xml",
FileMode.Open))
{
using (XmlReader xmlReader = XmlReader.Create(fileStream))
{
xmlReader.MoveToContent();
while (xmlReader.Read())
{
// Handle each 'row'
if (xmlReader.Name == "row")
{
// Get values
XElement rowNode = (XElement)XElement.ReadFrom(xmlReader);
long adId = long.Parse(rowNode.Attribute("adID").Value);
DateTime adDate =
DateTime.ParseExact(rowNode.Attribute("day").Value, "yyyy-MM-dd",
CultureInfo.InvariantCulture);
long adClicks =
long.Parse(rowNode.Attribute("clicks").Value);
// Handle data for yesterday
if (adDate == DateTime.Now.Date.AddDays(-1))
{
clicksYesterday += adClicks;
adIdsYesteday.Add(adId);
}
}
}
}
}
// Store adIDs
using (FileStream fs = new FileStream(@"c:\temp\ids.txt", FileMode.Create))
using (StreamWriter sw = new StreamWriter(fs))
foreach (string s in adIdsYesteday.Select(id => id.ToString()))
sw.WriteLine(s);
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
