Segment in report

2014-01-09 Thread Sergey Levitskiy
Hello! I read about requirement of using Segment in report (Ad Network, Device, ClickType). I tried to get Device data using AWQL (example for campaign report): SELECT CampaignId,Clicks,Impressions,Ctr,AverageCpc,Cost,AveragePosition,Device FROM CAMPAIGN_PERFORMANCE_REPORT DURING

Re: How can I change report language

2013-12-26 Thread Sergey Levitskiy
. On Monday, December 23, 2013 2:42:14 PM UTC+4, Sergey Levitskiy wrote: Hi! How can I set report language? *Now CSV:* AD_PERFORMANCE_REPORT (Dec 1, 2013-Dec 20, 2013) Ad ID,Ad,Campaign ID,Campaign,Ad group ID,Ad group 43893796927,Header,148153447,Campaign #1,9523291327,Ad Group #1

Get Percent Served

2013-12-26 Thread Sergey Levitskiy
Hello! I didn't find any information about this in documentation. How can I get Percent Served (Percent Served shows how often one ad was shown instead others in the ad group) using v201309? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group:

Get info about all Clients without foreah

2013-12-25 Thread Sergey Levitskiy
Hello! I have a task - to get all campaigns from MCC where 7 days after the start were spend less than 25 USD. How can I write query to not use Client_id of each of them (without foreach)? Thanks in advance. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and

Re: AD_PERFORMANCE_REPORT returns duplicated rows

2013-12-25 Thread Sergey Levitskiy
Hagikura (AdWords API Team) wrote: Hi Sergey, AdIds look unique to me, I don't think there are duplicate rows. Can you please check it on your side again? Best, - Takeshi, On Saturday, December 21, 2013 1:03:00 AM UTC+9, Sergey Levitskiy wrote: Hi there! I faced with such a problem, when i

AD_PERFORMANCE_REPORT returns duplicated rows

2013-12-23 Thread Sergey Levitskiy
Hi there! I faced with such a problem, when i try to get report with AD_PERFORMANCE_REPORT google returns duplicate rows. My query: SELECT Id,Headline,CampaignId,CampaignName,AdGroupId,AdGroupName FROM AD_PERFORMANCE_REPORT DURING 20131201,20131220 The answer is: AD_PERFORMANCE_REPORT (Dec 1,

How can I change report language

2013-12-23 Thread Sergey Levitskiy
Hi! How can I set report language? *Now CSV:* AD_PERFORMANCE_REPORT (Dec 1, 2013-Dec 20, 2013) Ad ID,Ad,Campaign ID,Campaign,Ad group ID,Ad group 43893796927,Header,148153447,Campaign #1,9523291327,Ad Group #1 43969612087,Header 2,148153447,Campaign #1,9531291367,Ad Group #2 Total, --, --, --,