Hmmmmmmmmmmmmmmm. OK Jayshree. Thanks for responding, but in all honesty, you're not helping. Please see the response I got back ( above ). For us, at least for certain accounts ( which have reporting data for the given date range ), we're not getting any data. It's great that you're getting data, but it's not explaining what's happening in our reports.
Can someone from *Google* please respond on this issue? Dan On Friday, 5 October 2012 21:55:29 UTC+10, jayshree bhongle wrote: > > > Have a look at this file,this are the stats i got by running the awql > query i mentioned previously > > On Fri, Oct 5, 2012 at 12:12 PM, dkasak > <[email protected]<javascript:> > > wrote: > >> I spent most of the day rewiring our code to make AWQL requests for this >> report. This doesn't return any records either; just an XML with field >> headers. >> >> Now ... can someone please comment *definitively* on whether this report >> is supposed to work or not? >> >> --- >> >> AWQL: >> >> select >> AccountId >> , AdGroupId >> , AdGroupName >> , AdGroupStatus >> , CampaignId >> , CampaignName >> , CampaignStatus >> , ReachFrequency >> , ReachFrequencyClicks >> , ReachFrequencyConv >> , ReachFrequencyConvRate >> , ReachFrequencyCtr >> , ReachFrequencyDate >> from ADGROUP_REACH_FREQUENCY_REPORT >> during LAST_7_DAYS >> >> Report XML returned: >> >> <?xml version='1.0' encoding='UTF-8' >> standalone='yes'?><report><report-name >> name='ADGROUP_REACH_FREQUENCY_REPORT'/><date-range date='Sep 28, 2012-Oct >> 4, 2012'/><table><columns><column name='accountID' display='Account >> ID'/><column name='adGroupID' display='Ad group ID'/><column name='adGroup' >> display='Ad group'/><column name='adGroupState' display='Ad group >> state'/><column name='campaignID' display='Campaign ID'/><column >> name='campaign' display='Campaign'/><column name='campaignState' >> display='Campaign state'/><column name='frequency' >> display='Frequency'/><column name='clicks' display='Clicks'/><column >> name='conv' display='Conv.'/><column name='convRate' display='Conv. >> rate'/><column name='ctr' display='CTR'/><column name='day' >> display='Day'/></columns></table></report> >> >> Dan >> >> On Thursday, 4 October 2012 21:38:21 UTC+10, jayshree bhongle wrote: >> >>> Hi, >>> This report works.I have used this report and it gives me correct data >>> .I have tested it for the fields which you have specified.But instead of >>> using adhoc reports i use awql queries. >>> The query which gets me this data is as follows:- >>> $reportDefinition = "SELECT AdGroupId,AdGroupName,** >>> AdGroupStatus,CampaignId,**CampaignName,CampaignStatus,**ReachFrequency, >>> **ReachFrequencyClicks,**ReachFrequencyConv,**ReachFrequencyConvRate,** >>> ReachFrequencyCtr,**ReachFrequencyDate,**UniqueUserCountAsLong FROM >>> ADGROUP_REACH_FREQUENCY_**REPORT DURING LAST_7_DAYS"; >>> >>> >>> >>> On Thu, Oct 4, 2012 at 7:26 AM, dkasak <[email protected]**>wrote: >>> >>>> Hi. >>>> >>>> We noticed you have added an ADGROUP_REACH_FREQUENCY_REPORT report >>>> type. We'd like to use this data. When I create a report request: >>>> >>>> <reportDefinition xmlns="https://adwords.google.** >>>> com/api/adwords/cm/v201206<https://adwords.google.com/api/adwords/cm/v201206> >>>> "> >>>> <selector> >>>> <fields>AdGroupId</fields> >>>> <fields>AdGroupName</fields> >>>> <fields>AdGroupStatus</fields> >>>> <fields>CampaignId</fields> >>>> <fields>CampaignName</fields> >>>> <fields>CampaignStatus</**fields> >>>> <fields>ReachFrequency</**fields> >>>> <fields>ReachFrequencyClicks</**fields> >>>> <fields>ReachFrequencyConv</**fields> >>>> <fields>**ReachFrequencyConvRate</**fields> >>>> <fields>ReachFrequencyCtr</**fields> >>>> <fields>ReachFrequencyDate</**fields> >>>> <fields>UniqueUserCountAsLong<**/fields> >>>> </selector> >>>> <reportName>ADGROUP_REACH_**FREQUENCY_REPORT</reportName> >>>> <reportType>ADGROUP_REACH_**FREQUENCY_REPORT</reportType> >>>> <dateRangeType>LAST_7_DAYS</**dateRangeType> >>>> <downloadFormat>GZIPPED_XML</**downloadFormat> >>>> </reportDefinition> >>>> >>>> ... I get a gzipped XML, but it only contains headers; no rows. >>>> >>>> Is this report not working yet? >>>> >>>> Dan >>>> >>>> -- >>>> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~**=~=~=~=~=~=~=~=~=~ >>>> Also find us on our blog and discussion group: >>>> http://adwordsapi.blogspot.com >>>> http://groups.google.com/**group/adwords-api<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 [email protected] >>>> >>>> To unsubscribe from this group, send email to >>>> adwords-api...@**googlegroups.com >>>> >>>> For more options, visit this group at >>>> http://groups.google.com/**group/adwords-api?hl=en<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 [email protected]<javascript:> >> To unsubscribe from this group, send email to >> [email protected] <javascript:> >> 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
