>From another thread, I know I cannot use JOIN. But I got several different statistics data for the same campaign ID. Can anyone help explain why this happens?
Here's my awql query: SELECT CampaignId, CampaignName, UniqueUserCountAsLong, ReachFrequency, ReachFrequencyClicks, ReachFrequencyCtr " FROM CAMPAIGN_REACH_FREQUENCY_REPORT WHERE CampaignStatus IN [ENABLED, PAUSED] DURING LAST_WEEK Thanks a lot! Campaign ID Unique UsersFrequencyClicksCTR 318515843 2100.00% 318515843 1200.00% 318515843 1300.00% 318515843 2100.00% 318515843 1200.00% 318515843 1300.00% On Friday, February 27, 2015 at 1:42:41 PM UTC+8, Eitan Shay wrote: > > Thanks Michael. > I've got the reach data with API version v201406. > > But I still got "HTTP Response Code: 400, Type: QueryError.PARSING_FAILED" > error with the following awql using JOIN. > According to the example awql in > https://developers.google.com/adwords/api/docs/guides/structure-reports, > we can use the JOIN clause. > Can you please help me find any error from the following awql. > > Thanks very much! > > ===================awql with JOIN================ > SELECT Id, Name, Impressions, Clicks, Ctr, AverageCpm, AverageCpc, > *UniqueUserCountAsLong, > ReachFrequency* > FROM *CAMPAIGN_PERFORMANCE_REPORT * > JOIN* CAMPAIGN_REACH_FREQUENCY_REPORT* ON CAMPAIGN_PERFORMANCE_REPORT. > Id=CAMPAIGN_REACH_FREQUENCY_REPORT.CampaignId > WHERE CampaignStatus IN [ENABLED, PAUSED] DURING LAST_WEEK > > > On Friday, February 27, 2015 at 3:10:31 AM UTC+8, Michael Cloonan (AdWords > API Team) wrote: >> >> Hello, >> >> For now, I believe you can still use these reports with API version >> v201406. >> >> Unfortunately, I cannot comment on release dates or timelines for future >> features. >> >> Regards, >> Mike, AdWords API Team >> >> On Thursday, February 26, 2015 at 9:30:16 AM UTC-5, Eitan Shay wrote: >>> >>> Thanks Michael. >>> So for now we cannot get the reach data from AdWords API, is there any >>> other way to get it? >>> If not, Could you please tell us the approximate time that this feature >>> will be released? >>> >>> Best regards, >>> Eitan >>> >>> >>> On Thursday, February 26, 2015 at 10:00:58 PM UTC+8, Michael Cloonan >>> (AdWords API Team) wrote: >>>> >>>> Hello, >>>> >>>> We are aware of this gap and are working on adding a method for you to >>>> reach this data via reporting. Please watch our blog >>>> <http://googleadsdeveloper.blogspot.com/> for new feature >>>> announcements to keep up do date. >>>> >>>> Regards, >>>> Mike, AdWords API Team >>>> >>>> On Thursday, February 26, 2015 at 2:08:12 AM UTC-5, Eitan Shay wrote: >>>>> >>>>> >>>>> Hi, >>>>> >>>>> I am trying to get reach data(unique impressions) for each campaign. >>>>> From >>>>> https://developers.google.com/adwords/api/docs/guides/structure-reports, >>>>> I can see that I can use JOIN in awql on* CAMPAIGN_PERFORMANCE_REPORT* >>>>> and *CAMPAIGN_REACH_FREQUENCY_REPORT* >>>>> >>>>> But I got "HTTP Response Code: 400, Type: QueryError.PARSING_FAILED" >>>>> error with the following awql: >>>>> >>>>> SELECT Id, Name, Impressions, Clicks, Ctr, AverageCpm, AverageCpc, >>>>> *UniqueUserCountAsLong, >>>>> ReachFrequency* >>>>> FROM *CAMPAIGN_PERFORMANCE_REPORT * >>>>> JOIN* CAMPAIGN_REACH_FREQUENCY_REPORT* ON >>>>> CAMPAIGN_PERFORMANCE_REPORT.Id=CAMPAIGN_REACH_FREQUENCY_REPORT.CampaignId >>>>> WHERE CampaignStatus IN [ENABLED, PAUSED] DURING LAST_WEEK >>>>> >>>>> Then I found CAMPAIGN_REACH_FREQUENCY_REPORT is not supported in the >>>>> latest version >>>>> since I got error >>>>> “HTTP Response Code: 500, FieldPath: selector, Trigger: Enum >>>>> ReportDefinitionReportType does not have a constant corresponding to >>>>> CAMPAIGN_REACH_FREQUENCY_REPORT, Type: ReportInfoError.REPORT_INFO_ERROR >>>>> ” >>>>> when querying on only CAMPAIGN_REACH_FREQUENCY_REPORT in the following: >>>>> >>>>> SELECT UniqueUserCountAsLong, ReachFrequency >>>>> FROM *CAMPAIGN_REACH_FREQUENCY_REPORT* >>>>> WHERE CampaignStatus IN [ENABLED, PAUSED] DURING LAST_WEEK >>>>> >>>>> Can anyone please help me solve this? >>>>> >>>>> Thanks very much! >>>>> Eitan >>>>> >>>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. Visit this group at http://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/47235bce-9f30-4767-bb1a-528cfefa1bf9%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
