I have been using the v201003 ReportDefinition Service in the .NET
client library for the better part of two months to download and parse
XML Placement Reports.
Currently, I create a predicate for filtering the results of the
report for a single campaignID.
I also use a custom date range for selecting the day from two days
previous (e.g., If today is the 26th of September, the custom date
range would only include the 24th of September).
When I create a report definition to download these are the fields I
request in the report:
AdGroupId,
Url,
Impressions,
Clicks,
Conversions,
Cost
Recently, within the past week, the reports that are being returned by
this exact call (which has not changed in weeks), contain no column
for AdGroupId.
Here is the report definition construction in C#:
service =
(ReportDefinitionService)user.GetService(AdWordsService.v201003.ReportDefinitionService);
service.RequestHeader.clientCustomerId =
clientID_l.ToString();
reportOps = new ReportDefinitionOperation[1];
reportOps[0] = new
ReportDefinitionOperation();
reportops[...@operator = Operator.ADD;
reportOps[0].operatorSpecified = true;
reportOps[0].operand = new ReportDefinition();
reportOps[0].operand.reportName =
"testReport";
reportOps[0].operand.reportType =
ReportDefinitionReportType.URL_PERFORMANCE_REPORT;
reportOps[0].operand.reportTypeSpecified =
true;
reportOps[0].operand.hasAttachment = false;
reportOps[0].operand.hasAttachmentSpecified =
true;
reportOps[0].operand.dateRangeType =
ReportDefinitionDateRangeType.CUSTOM_DATE;
reportOps[0].operand.dateRangeTypeSpecified =
true;
reportOps[0].operand.downloadFormat =
DownloadFormat.XML;
reportOps[0].operand.downloadFormatSpecified =
true;
reportOps[0].operand.selector = new
Selector();
reportOps[0].operand.selector.dateRange = new
DateRange();
reportOps[0].operand.selector.dateRange.min =
startDate_dt.ToString("yyyyMMdd");
reportOps[0].operand.selector.dateRange.max =
endDate_dt.ToString("yyyyMMdd");
reportOps[0].operand.selector.fields = new
string[6] { "AdGroupId", "Url", "Impressions", "Clicks",
"Conversions", "Cost" };
campaignPredicate = new Predicate();
campaignPredicate.field = "CampaignId";
campaignpredica...@operator =
PredicateOperator.EQUALS;
campaignPredicate.operatorSpecified = true;
campaignPredicate.values = new string[1]
{ campaignID_l.ToString() };
reportOps[0].operand.selector.predicates = new
Predicate[1] { campaignPredicate };
As you can clearly see I request very specific fields to be returned
on this line:
reportOps[0].operand.selector.fields = new
string[6] { "AdGroupId", "Url", "Impressions", "Clicks",
"Conversions", "Cost" };
But here is an example of a report that is returned by this call:
<?xml version="1.0" encoding="UTF-8"
standalone="yes" ?>
- <report>
<report-name name="testReport" />
<date-range date="Sep 23, 2010" />
- <table>
- <columns>
<column name="url" display="URL" />
<column name="impressions"
display="Impressions" />
<column name="clicks" display="Clicks" />
<column name="conv1PerClick" display="Conv. (1-
per-click)" />
<column name="cost" display="Cost" />
</columns>
<row url="www.dart-creations.com/article-tree/
loans/military_loan-1.html" impressions="1" clicks="1"
conv1PerClick="0" cost="1.95" />
<row url="greenpayday.com" impressions="1"
clicks="1" conv1PerClick="0" cost="1.64" />
<row url="ezine.article24h.com/1.3c/payday-loans-
phone-one-phone-call-loan-is" impressions="0" clicks="1"
conv1PerClick="1" cost="1.99" />
<row url="verybadcreditmortgageloans.blogspot.com/
2009/08/no-credit-check-loans-for-3000-dollars.html" impressions="2"
clicks="1" conv1PerClick="0" cost="1.67" />
<row url="www.startsearcher.com/search.php"
impressions="1" clicks="1" conv1PerClick="1" cost="1.46" />
<row url="www.dart-creations.com/BI/ccs/
poor_credit_home_improvement_loan.html" impressions="1" clicks="1"
conv1PerClick="0" cost="1.42" />
<row url="www.killerstartups.com/Site-Reviews/
myiadvance-com-short-term-loans" impressions="8" clicks="1"
conv1PerClick="1" cost="1.55" />
<row url="www.fastloanfortheunemployed.com"
impressions="3" clicks="1" conv1PerClick="0" cost="1.33" />
<row url="19nnn.us" impressions="1" clicks="1"
conv1PerClick="0" cost="0.65" />
<row url="www.creditservicer.com" impressions="1"
clicks="1" conv1PerClick="1" cost="1.05" />
<row url="www.e-loan-expert.com/1/1_1_loans-debit-
card.aspx" impressions="2" clicks="1" conv1PerClick="0" cost="1.30" /
>
<row
url="nocreditcheckpaydayloansimmediate.a.article24h.com"
impressions="3" clicks="1" conv1PerClick="0" cost="1.94" />
<row url="web.informer.com/beacon+payday+loan
+website" impressions="2" clicks="1" conv1PerClick="0" cost="1.83" />
<row url="www.needhelppayingbills.com/html/
low_income_no_credit_loans.html" impressions="2" clicks="1"
conv1PerClick="1" cost="1.84" />
<row url="mergemedia.com/offers/finance/
patriots_cash_usa_1500_in_cash_advance_loans.html" impressions="3"
clicks="1" conv1PerClick="0" cost="1.82" />
<row url="wiki.answers.com/Q/
What_payday_loans_will_accept_accountnow_as_a_bank_and_can_you_list_them"
impressions="1" clicks="1" conv1PerClick="1" cost="1.49" />
<row url="www.automotix.net/yellowpages/florida/
leesburg/car_financing_loans/personal_loans" impressions="1"
clicks="1" conv1PerClick="0" cost="1.49" />
<row url="personaloans.com" impressions="1"
clicks="1" conv1PerClick="1" cost="1.38" />
<row url="persinalloan.com" impressions="109"
clicks="0" conv1PerClick="0" cost="0.00" />
<row url="www.bostonapartments.com/loans/
new_business_loan-3.html" impressions="1" clicks="1" conv1PerClick="0"
cost="1.98" />
<row url="www.breadmarket.co.uk/debt-
consolidation/unsecured-loans-bad-credit.php" impressions="1"
clicks="1" conv1PerClick="0" cost="1.29" />
<row url="www.speedybadcreditloans.com/join.html"
impressions="2" clicks="1" conv1PerClick="0" cost="1.71" />
<row url="www.digitalnewsreport.com/2010/09/19-
personal-loans-for-people-with-bad-credit-capital-one-bank/5787"
impressions="1" clicks="1" conv1PerClick="1" cost="1.48" />
<row url="ineedaloanltd.com" impressions="2"
clicks="2" conv1PerClick="0" cost="3.90" />
<row url="badcredit-paydayloan.info/poor-credit-
payday-loan" impressions="1" clicks="1" conv1PerClick="1" cost="1.13" /
>
<row url="loanreferences.com/secured-personal-
loan-for-5500-with-collateral-of-10000-with-bad-credit"
impressions="1" clicks="1" conv1PerClick="0" cost="1.21" />
<row url="wiki.answers.com/Q/
Where_can_you_find_the_best_installment_loan_with_bad_credit"
impressions="2" clicks="1" conv1PerClick="0" cost="1.33" />
<row url="bikingthebalkans.org/loans-for-single-
moms-with-bad-credit" impressions="1" clicks="1" conv1PerClick="0"
cost="1.36" />
<row url="www.singlemomfinancialhelp.com/blog/
2009/07/get-the-best-loans-for-single-mothers-with-bad-credit"
impressions="3" clicks="2" conv1PerClick="1" cost="3.94" />
<row url="paydayhelp.blogspot.com"
impressions="1" clicks="1" conv1PerClick="1" cost="1.38" />
<row url="www.1clickmoney.com/personal_finance/
sc_others_personal_finance.shtml" impressions="1" clicks="1"
conv1PerClick="0" cost="1.80" />
<row url="californialoanfind.com/need-installment-
loans.htm" impressions="1" clicks="1" conv1PerClick="0" cost="1.30" /
>
<row url="www.manta.com/mb_44_A10A3_43/
loan_brokers/tennessee" impressions="1" clicks="1" conv1PerClick="0"
cost="1.54" />
<row url="offers.mycashadvanceexpress.com/match2"
impressions="1" clicks="1" conv1PerClick="1" cost="1.72" />
<row url="www.complaintsboard.com/complaints/ul-
services-online-c249666.html" impressions="1" clicks="1"
conv1PerClick="1" cost="1.74" />
<row url="www.usloanchoice.com" impressions="2"
clicks="1" conv1PerClick="0" cost="0.80" />
<row url="www.fairloanrate.com/2010/05/11/private-
bad-credit-lenders" impressions="2" clicks="1" conv1PerClick="0"
cost="1.67" />
<row url="www.articlesnatch.com/Article/Fast-Cash-
Loans---Easy-And-Rapid-Option-To-Solve-The-Emergency-Problems/1582401"
impressions="2" clicks="1" conv1PerClick="0" cost="1.54" />
<row
url="www.badcreditpersonalinstallmentloan.co.cc" impressions="1"
clicks="1" conv1PerClick="0" cost="1.34" />
<row url="3000loan.net/2010/04/3000-loan"
impressions="1" clicks="1" conv1PerClick="0" cost="1.43" />
<row url="cashloan1.com" impressions="1"
clicks="0" conv1PerClick="1" cost="0.00" />
</table>
</report>
What happened to the aggregation of placement data by AdGroupId?
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
