Hi David,
I've chimed in on that thread, please follow up with me there.
Best,
- Eric
Original Message Follows:
------------------------
From: "David Lin" <da...@apexpacific.com>
Subject: FW: Error: !!!2|||-1|||Improperly formatted report request??? for
AdHoc Reports Service
Date: Tue, 18 Oct 2011 11:48:53 +1100
> Hi Eric,
>
>
>
> You have helped me with some API issues previously, and I need help from
> your team again.
>
>
>
> We tried to upgrade our software to the new Adwords API 201109, but we
> received following error for the AdHoc reporting service. We have posted
> this to the forum, and received some feedbacks from other member Peter
> Petrov, he said it works fine for him, but it did not work for us.
>
>
>
> Anyway, here is the problem:
>
>
>
> We received following error message when using the AdHoc reporting
service:
>
>
>
> !!!2|||-1|||Improperly formatted report request???
>
>
>
>
>
> I used the '__rdxml=" parameter name to post following XML request to
> "https://adwords.google.com/api/adwords/reportdownload/v201109";
>
>
>
>
__rdxml=<reportDefinition><selector><fields>Date</fields><fields>CampaignId<
>
/fields><fields>Id</fields><fields>Impressions</fields><fields>Clicks</field
>
s><fields>Cost</fields><predicates><field>Status</field><operator>IN</operat
>
or><values>ACTIVE</values></predicates><dateRange><min>20111001</min><max>20
>
111014</max></dateRange></selector><reportName>Report1</reportName><reportTy
>
pe>KEYWORDS_PERFORMANCE_REPORT</reportType><dateRangeType>CUSTOM_DATE</dateR
> angeType><downloadFormat>CSV</downloadFormat></reportDefinition>
>
>
>
> We also tried the exact example code from your web site, same problem.
We
> have tried many different things, it always returned the same error.
>
>
>
> Could you please let me know what I am doing wrong?
>
>
>
> Regards,
>
> David
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> From: Peter Petrov [mailto:p.a.pet...@gmail.com]
> Sent: Tuesday, 18 October 2011 7:06 AM
> To: 'David Lin'
> Cc: p.a.pet...@gmail.com
> Subject: RE: Error: !!!2|||-1|||Improperly formatted report request???
for
> AdHoc Reports Service
>
>
>
> David,
>
>
>
> With this report definition which you pasted in your last email:
>
>
>
>
__rdxml=<reportDefinition><selector><fields>Date</fields><fields>CampaignId<
>
/fields><fields>Id</fields><fields>Impressions</fields><fields>Clicks</field
>
s><fields>Cost</fields><predicates><field>Status</field><operator>IN</operat
>
or><values>ACTIVE</values></predicates><dateRange><min>20111001</min><max>20
>
111014</max></dateRange></selector><reportName>Report1</reportName><reportTy
>
pe>KEYWORDS_PERFORMANCE_REPORT</reportType><dateRangeType>CUSTOM_DATE</dateR
> angeType><downloadFormat>CSV</downloadFormat></reportDefinition>
>
>
>
> my client code (I use java) is pulling real reporting data i.e. I have
no
> issues when posting this definition to their URL.
>
>
>
> I suggest you talk to somebody from Google/AdWords as I doubt I can be
of
> much further help.
>
>
>
> Regards,
>
> Peter
>
>
>
> _____
>
> From: David Lin [mailto:da...@apexpacific.com]
> Sent: Monday, October 17, 2011 8:29 AM
> To: 'Peter Petrov'
> Subject: RE: Error: !!!2|||-1|||Improperly formatted report request???
for
> AdHoc Reports Service
>
>
>
> Hi Peter,
>
>
>
> Really appreciated your continue help.
>
>
>
> I have changed to what you said, but still same problem.
>
>
>
> Here is exactly what I post:
>
>
>
>
__rdxml=<reportDefinition><selector><fields>Date</fields><fields>CampaignId<
>
/fields><fields>Id</fields><fields>Impressions</fields><fields>Clicks</field
>
s><fields>Cost</fields><predicates><field>Status</field><operator>IN</operat
>
or><values>ACTIVE</values></predicates><dateRange><min>20111001</min><max>20
>
111014</max></dateRange></selector><reportName>Report1</reportName><reportTy
>
pe>KEYWORDS_PERFORMANCE_REPORT</reportType><dateRangeType>CUSTOM_DATE</dateR
> angeType><downloadFormat>CSV</downloadFormat></reportDefinition>
>
>
>
> I also tried the exact sample code from Google, same problem.
>
>
>
> Do I need to encode the post string?
>
>
>
> Please let me know what else I need to do.
>
>
>
> Many thanks.
>
>
>
> Regards,
>
> David
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> From: Peter Petrov [mailto:p.a.pet...@gmail.com]
> Sent: Friday, 14 October 2011 10:49 PM
> To: David Lin
> Subject: Re: Error: !!!2|||-1|||Improperly formatted report request???
for
> AdHoc Reports Service
>
>
>
> Dave,
>
> Now you're trying to pull Keyword Performance Report.
>
> You have 2 mistakes in your request.
>
> 1) HourOfDay is invalid - remove it
> 2) Status (in the predicate) should be named ACTIVE and not ENABLED -
change
> it
>
> Then your request should work, at least it works for me after these 2
> changes.
>
> Regards,
> Peter
>
> On Thu, Oct 13, 2011 at 7:14 PM, David Lin <da...@apexpacific.com>
wrote:
>
> Hi Peter,
>
>
>
> Many thanks and I really appreciated your help.
>
>
>
> However, I changed to what you said below and still same problem.
>
>
>
> Here is what I did:
>
>
>
> I used HTTP POST to post following Query String to :
> https://adwords.google.com/api/adwords/reportdownload/v201109
>
>
>
>
__rdxml=<reportDefinition><selector><fields>Date</fields><fields>CampaignId<
>
/fields><fields>Id</fields><fields>HourOfDay</fields><fields>Impressions</fi
>
elds><fields>Clicks</fields><fields>Cost</fields><predicates><field>Status</
>
field><operator>IN</operator><values>ENABLED</values></predicates><dateRange
>
><min>20111001</min><max>20111012</max></dateRange></selector><reportName>Re
>
port4</reportName><reportType>KEYWORDS_PERFORMANCE_REPORT</reportType><dateR
>
angeType>CUSTOM_DATE</dateRangeType><downloadFormat>CSV</downloadFormat></re
> portDefinition>
>
>
>
> Is that right?
>
>
>
> Many thanks for your help again.
>
>
>
> Regards,
>
> David
>
>
>
>
>
>
>
>
>
>
>
>
>
> From: Peter Petrov [mailto:p.a.pet...@gmail.com]
> Sent: Thursday, 13 October 2011 10:54 PM
> To: googlecen...@apexpacific.com; 'AdWords API Forum'
> Subject: RE: Error: !!!2|||-1|||Improperly formatted report request???
for
> AdHoc Reports Service
>
>
>
>
>
> I am not from the Google AdWords team so don't take my reply as 100%
> certain.
>
>
>
> But I think your problem is that the BiddingStrategy predicate cannot be
> used here.
>
>
>
>
>
> I think it's a property of Campagns so you can use it in Campaign
> Performance Reports.
>
>
>
>
>
> I changed only the predicate part of your report definition as follows:
>
>
>
>
>
> <reportDefinition>
>
> <selector>
>
> <fields>Date</fields>
>
> <fields>CampaignId</fields>
>
> <fields>Id</fields>
>
> <fields>HourOfDay</fields>
>
> <fields>Impressions</fields>
>
> <fields>Clicks</fields>
>
> <fields>Cost</fields>
>
> <predicates>
>
> <field>Status</field>
>
> <operator>IN</operator>
>
> <values>ENABLED</values>
>
> <values>PAUSED</values>
>
> </predicates>
>
> <dateRange>
>
> <min>20111001</min>
>
> <max>20111010</max>
>
> </dateRange>
>
> </selector>
>
> <reportName>TestReport</reportName>
>
> <reportType>ADGROUP_PERFORMANCE_REPORT</reportType>
>
> <dateRangeType>CUSTOM_DATE</dateRangeType>
>
> <downloadFormat>CSV</downloadFormat>
>
> </reportDefinition>
>
>
>
> and this works.
>
>
>
>
>
> See also this:
>
>
>
>
>
> Available fields for CAMPAIGN_PERFORMANCE_REPORT
>
> ConversionRateManyPerClickSignificance(SignificanceData) := []
>
> ConversionRateSignificance(SignificanceData) := []
>
> Period(BudgetPeriod) := [DAILY, MONTHLY, ]
>
> ViewThroughConversionsSignificance(SignificanceData) := []
>
> AccountCurrencyCode(String) := []
>
> AccountDescriptiveName(String) := []
>
> AccountTimeZoneId(Integer) := []
>
> AdNetworkType1(AdNetworkType1) := [SEARCH, CONTENT, ]
>
> AdNetworkType2(AdNetworkType2) := [SEARCH, SEARCH_PARTNERS,
CONTENT,
> ]
>
>
> AdvertiserExperimentSegmentationBin(AdvertiserExperimentSegmentationBin)
:=
> [OUTSIDE_OF_EXPERIMENT, CONTROL, EXPERIMENT, ]
>
> Amount(Money) := []
>
> AverageCpc(Money) := []
>
> AverageCpm(Money) := []
>
> AveragePosition(Double) := []
>
> BiddingStrategy(Type) := [MANUAL_CPC, MANUAL_CPM,
BUDGET_OPTIMIZER,
> CONVERSION_OPTIMIZER, PERCENT_CPA, ]
>
> BudgetLostImpressionShare(Double) := []
>
> CampaignId(Long) := []
>
> CampaignName(String) := []
>
> Clicks(Long) := []
>
> ClickSignificance(SignificanceData) := []
>
> ClickType(ClickType) := [URL_CLICKS, CALLS, OTHER,
> PRODUCT_EXTENSION_CLICKS, SITELINKS, PRODUCT_LISTING_AD_CLICKS,
> GET_DIRECTIONS, OFFER_PRINTS, ]
>
> ConversionCategoryName(String) := []
>
> ConversionManyPerClickSignificance(SignificanceData) := []
>
> ConversionOptimizerBidType(ConversionOptimizerBidType) :=
> [TARGET_CPA, MAX_CPA, ]
>
> ConversionRate(Double) := []
>
> ConversionRateManyPerClick(Double) := []
>
> Conversions(Long) := []
>
> ConversionSignificance(SignificanceData) := []
>
> ConversionsManyPerClick(Long) := []
>
> ConversionTypeName(String) := []
>
> ConversionValue(Long) := []
>
> Cost(Money) := []
>
> CostPerConversion(Money) := []
>
> CostPerConversionManyPerClick(Money) := []
>
> CostPerConversionManyPerClickSignificance(SignificanceData) := []
>
> CostPerConversionSignificance(SignificanceData) := []
>
> CostSignificance(SignificanceData) := []
>
> CpcSignificance(SignificanceData) := []
>
> CpmSignificance(SignificanceData) := []
>
> Ctr(Double) := []
>
> CtrSignificance(SignificanceData) := []
>
> CustomerDescriptiveName(String) := []
>
> Date(Date) := []
>
> DayOfWeek(DayOfWeek) := [MONDAY, TUESDAY, WEDNESDAY, THURSDAY,
> FRIDAY, SATURDAY, SUNDAY, ]
>
> DeduplicationMode(ConversionDeduplicationMode) := [ONE_PER_CLICK,
> MANY_PER_CLICK, ]
>
> DerivedDailyBudget(Long) := []
>
> Device(DeviceType) := [DESKTOP, HIGH_END_MOBILE, TABLET, ]
>
> EnhancedCpcEnabled(Boolean) := []
>
> ExactMatchImpressionShare(Double) := []
>
> ExternalCustomerId(Long) := []
>
> HourOfDay(Integer) := []
>
> Id(Long) := []
>
> Impressions(Long) := []
>
> ImpressionShare(Double) := []
>
> ImpressionSignificance(SignificanceData) := []
>
> InvalidClickRate(Double) := []
>
> InvalidClicks(Long) := []
>
> Month(String) := []
>
> MonthOfYear(MonthOfYearType) := [JANUARY, FEBRUARY, MARCH, APRIL,
> MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER, ]
>
> Name(String) := []
>
> PositionSignificance(SignificanceData) := []
>
> PrimaryCompanyName(String) := []
>
> PrimaryUserLogin(String) := []
>
> QualityLostImpressionShare(Double) := []
>
> Quarter(String) := []
>
> Slot(Slot) := [SearchRhs, SearchTop, SearchOther, Content,
AfsTop,
> AfsOther, Unknown, ]
>
> Status(CampaignStatus) := [ACTIVE, DELETED, PAUSED, ]
>
> TotalConvValue(Long) := []
>
> ValuePerConv(Double) := []
>
> ValuePerConversion(Double) := []
>
> ValuePerConversionManyPerClick(Double) := []
>
> ValuePerConvManyPerClick(Double) := []
>
> ViewThroughConversions(Long) := []
>
> Week(String) := []
>
> Year(Integer) := []
>
>
>
>
>
>
>
>
>
>
>
> Available fields for ADGROUP_PERFORMANCE_REPORT
>
> ConversionRateManyPerClickSignificance(SignificanceData) := []
>
> ConversionRateSignificance(SignificanceData) := []
>
> ViewThroughConversionsSignificance(SignificanceData) := []
>
> AccountCurrencyCode(String) := []
>
> AccountDescriptiveName(String) := []
>
> AccountTimeZoneId(Integer) := []
>
> AdGroupId(Long) := []
>
> AdGroupName(String) := []
>
> AdNetworkType1(AdNetworkType1) := [SEARCH, CONTENT, ]
>
> AdNetworkType2(AdNetworkType2) := [SEARCH, SEARCH_PARTNERS,
CONTENT,
> ]
>
>
> AdvertiserExperimentSegmentationBin(AdvertiserExperimentSegmentationBin)
:=
> [OUTSIDE_OF_EXPERIMENT, CONTROL, EXPERIMENT, ]
>
> AverageCpc(Money) := []
>
> AverageCpm(Money) := []
>
> AveragePosition(Double) := []
>
> BudgetLostImpressionShare(Double) := []
>
> CampaignId(Long) := []
>
> CampaignName(String) := []
>
> CampaignStatus(CampaignStatus) := [ACTIVE, DELETED, PAUSED, ]
>
> Clicks(Long) := []
>
> ClickSignificance(SignificanceData) := []
>
> ClickType(ClickType) := [URL_CLICKS, CALLS, OTHER,
> PRODUCT_EXTENSION_CLICKS, SITELINKS, PRODUCT_LISTING_AD_CLICKS,
> GET_DIRECTIONS, OFFER_PRINTS, ]
>
> ConversionCategoryName(String) := []
>
> ConversionManyPerClickSignificance(SignificanceData) := []
>
> ConversionOptimizerBidType(ConversionOptimizerBidType) :=
> [TARGET_CPA, MAX_CPA, ]
>
> ConversionRate(Double) := []
>
> ConversionRateManyPerClick(Double) := []
>
> Conversions(Long) := []
>
> ConversionSignificance(SignificanceData) := []
>
> ConversionsManyPerClick(Long) := []
>
> ConversionTypeName(String) := []
>
> ConversionValue(Long) := []
>
> Cost(Money) := []
>
> CostPerConversion(Money) := []
>
> CostPerConversionManyPerClick(Money) := []
>
> CostPerConversionManyPerClickSignificance(SignificanceData) := []
>
> CostPerConversionSignificance(SignificanceData) := []
>
> CostSignificance(SignificanceData) := []
>
> CpcSignificance(SignificanceData) := []
>
> CpmSignificance(SignificanceData) := []
>
> Ctr(Double) := []
>
> CtrSignificance(SignificanceData) := []
>
> CustomerDescriptiveName(String) := []
>
> Date(Date) := []
>
> DayOfWeek(DayOfWeek) := [MONDAY, TUESDAY, WEDNESDAY, THURSDAY,
> FRIDAY, SATURDAY, SUNDAY, ]
>
> DeduplicationMode(ConversionDeduplicationMode) := [ONE_PER_CLICK,
> MANY_PER_CLICK, ]
>
> Device(DeviceType) := [DESKTOP, HIGH_END_MOBILE, TABLET, ]
>
> EnhancedCpcEnabled(Boolean) := []
>
> ExactMatchImpressionShare(Double) := []
>
> ExternalCustomerId(Long) := []
>
> HourOfDay(Integer) := []
>
> Id(Long) := []
>
> Impressions(Long) := []
>
> ImpressionShare(Double) := []
>
> ImpressionSignificance(SignificanceData) := []
>
> KeywordContentMaxCpc(Bid) := []
>
> KeywordMaxCpc(Bid) := []
>
> MaxCpm(Bid) := []
>
> Month(String) := []
>
> MonthOfYear(MonthOfYearType) := [JANUARY, FEBRUARY, MARCH, APRIL,
> MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER, ]
>
> Name(String) := []
>
> PercentCpa(int) := []
>
> PositionSignificance(SignificanceData) := []
>
> PrimaryCompanyName(String) := []
>
> PrimaryUserLogin(String) := []
>
> ProxyKeywordMaxCpc(Bid) := []
>
> ProxySiteMaxCpc(Bid) := []
>
> QualityLostImpressionShare(Double) := []
>
> Quarter(String) := []
>
> SiteMaxCpc(Bid) := []
>
> Slot(Slot) := [SearchRhs, SearchTop, SearchOther, Content,
AfsTop,
> AfsOther, Unknown, ]
>
> Status(Status) := [ENABLED, PAUSED, DELETED, ]
>
> TargetCpa(Bid) := []
>
> TotalConvValue(Long) := []
>
> ValuePerConv(Double) := []
>
> ValuePerConversion(Double) := []
>
> ValuePerConversionManyPerClick(Double) := []
>
> ValuePerConvManyPerClick(Double) := []
>
> ViewThroughConversions(Long) := []
>
> Week(String) := []
>
> Year(Integer) := []
>
>
>
>
>
>
>
>
>
> Hope this helps.
>
>
>
>
>
> Regards,
>
> Peter
>
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: adwords-api@googlegroups.com [mailto:adwords-api@googlegroups.com]
On
> Behalf Of Dave L
> Sent: Thursday, October 13, 2011 9:41 AM
> To: AdWords API Forum
> Subject: Error: !!!2|||-1|||Improperly formatted report request??? for
AdHoc
> Reports Service
>
>
>
> Hi,
>
>
>
> I received following error when using the AdHoc Reports service:
>
>
>
> !!!2|||-1|||Improperly formatted report request???
>
>
>
> According to the documentation at
> http://code.google.com/apis/adwords/docs/reportingtopics.html#adhoc.
>
>
>
> I used the '__rdxml=" parameter name to post following XML request to
>
> "https://adwords.google.com/api/adwords/reportdownload/v201109";
>
>
>
> <reportDefinition>
>
> <selector>
>
> <fields>Date</fields>
>
> <fields>CampaignId</fields>
>
> <fields>Id</fields>
>
> <fields>HourOfDay</fields>
>
> <fields>Impressions</fields>
>
> <fields>Clicks</fields>
>
> <fields>Cost</fields>
>
> <predicates>
>
> <field>BiddingStrategy</field>
>
> <operator>IN</operator>
>
> <values>BidToPosition</values>
>
> <values>CpaPercent</values>
>
> </predicates>
>
> <dateRange>
>
> <min>20111001</min>
>
> <max>20111010</max>
>
> </dateRange>
>
> </selector>
>
> <reportName>TestReport</reportName>
>
> <reportType>ADGROUP_PERFORMANCE_REPORT</reportType>
>
> <dateRangeType>CUSTOM_DATE</dateRangeType>
>
> <downloadFormat>CSV</downloadFormat>
>
> </reportDefinition>
>
>
>
> then I received the following error:
>
>
>
> !!!2|||-1|||Improperly formatted report request???'
>
>
>
> I have used the correct HTTP header according to the specification.
>
>
>
> Could you please let me know what I am doing wrong?
>
>
>
>
>
>
>
> --
>
> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
>
> 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
> <mailto:adwords-api%2bunsubscr...@googlegroups.com>
>
> For more options, visit this group at
>
> http://groups.google.com/group/adwords-api?hl=en
>
>
>
>
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
