Re: How to get correct number of video quratile views

Hi Zweitze, I noticed strange behavior when I use the Adgroup performance report. When I use your solution: if AdGroupType=='In-stream' then Video Views Quartile XX= Impressions * VideoQuartile100Rate else Video Views Quartile XX=0 And back-calculation Total VideoQuartile100Rate = Total

Re: How to get correct number of video quratile views

Thank you very much! Got it. On Friday, December 6, 2019 at 12:20:16 AM UTC+7, Zweitze wrote: > > Hi, > > I struggled with this some time ago. Later someone asked the same > question, and the answer there best describes my findings: >

Re: How to get correct number of video quratile views

Thanks for the replay. But I am still don't understand how I can calculate correct totals by API data. My problem is that I can't store the total values of VideoQuartile50Rate from API response. And I need a method to calculate it my own. Can you please confirm the next formula is correct or

How to get correct number of video quratile views

Hi all, please help to figure out the next issue I try to calculate the number when the video was viewed at 50%. Adwords API gives the rate VideoQuartile50Rate Description: Percentage of impressions where the viewer watched 50% of your video. So, I make a backward calculation of

Re: Data mismatch between criteria and gender report types

Hi, thanks for the quick reply. Sorry but I am a little bit confused As you have observed, the report appears to have not selected the Gender > criteria as the type to return in the results. > But in my criteria report request, I've put a clause CriteriaType=GENDER and actually in response I

Data mismatch between criteria and gender report types

Hello! Can anybody explain to me why I see different metric count between criteria performance report and gender performance report My query for criteria report https://adwords.google.com/api/adwords/reportdownload/v201809?__fmt=CSV&__rdquery=SELECT CriteriaType,Criteria, Clicks FROM

Re: Empty Label values in API response for ad performance report

Thanks for the quick reply! Yes, I am confirming that we don't have labels for the ads and expected to see the same labels as for campaigns. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/

Empty Label values in API response for ad performance report

Hi there! Looking for somebody who able to exlain why Label and Labelids not have being returned in AD_PERFORMANCE_REPORT *My request:* POST https://adwords.google.com/api/adwords/reportdownload/v201809?__fmt=XML&__rdquery=SELECT CampaignId,CampaignName,Labels,LabelIds,Impressions FROM