URL Performance Report Fields

[ADM]

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[0].@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";
campaignPredicate.@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?

[AdWords API Advisor]

Hi ADM,

Could you run http://code.google.com/p/google-api-adwords-dotnet/source/browse/trunk/Examples/v201003/GetReportFields.cs
and let me know the list of fields returned by the server?

Cheers,
Anash P. Oommen,
AdWords API Advisor.

[ADM]

Anash,

Here is the list of fields returned by that sample code in the link
you posted:

AdNetworkType1,
AdNetworkType2,
AverageCpc,
AverageCpm,
Clicks,
ConversionCategoryName,
ConversionRate,
ConversionRateManyPerClick,
Conversions,
ConversionsManyPerClick,
ConversionTypeName,
Cost,
CostPerConversion,
CostPerConversionManyPerClick,
Ctr,
Date,
DayOfWeek,
Impressions,
Month,
Quarter,
Url,
Week,
Year

No where in this list are there options for selecting/requesting
adGroupID, adGroup name, campaignID, campaign name, etc. Those missing
fields are very important for data aggregation and it is very
surprising that they would suddenly disappear.

On Sep 27, 5:40 am, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:
> Hi ADM,
>
> Could you runhttp://code.google.com/p/google-api-adwords-dotnet/source/browse/trun...

> ...
>
> read more »

[AdWords API Advisor]

Hi ADM,

These fields should be there, and I'm working with the core
engineering team to restore them. See this thread for more
information:

http://groups.google.com/group/adwords-api/browse_thread/thread/d20b1be0a7a6a7b8/

Best,
- Eric Koleda, AdWords API Team

> ...
>
> read more »

[ADM]

Erik,

Thank you very much for your cooperation. I'm glad this got caught
early and is being resolved.

Best,

ADM

On Sep 28, 3:35 pm, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:
> Hi ADM,
>

> These fields should be there, and I'm working with the core
> engineering team to restore them.  See this thread for more
> information:
>

>  http://groups.google.com/group/adwords-api/browse_thread/thread/d20b1...

> ...
>
> read more »