Seems it's bcoz the ReachFrequency field causes segmentation. But even if I SELECT only CampaignId, UniqueUserCountAsLong I still get same or different rows in the result like below: Can anyone help shed some light on this?
Thanks! =========sample result=== Campaign IDUnique Users 3185181231 3185181231 3185158434 3185158434 31851548310 3185154834 3185154836 On Friday, February 27, 2015 at 5:16:32 PM UTC+8, Eitan Shay wrote: > > 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/9068558b-03ea-444c-b698-03ffad3a9b20%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
