Hi Dhanya, I am using CampaignPerformance report only. I am giving an example of my case. Lets say I am fetching CampaignPerformance Report from API for last 7 days with impressions, VideoQuartile25Rate, VideoQuartile50Rate. So I will get 7 records with those metrics and I am calculating total value for that day also like below
day, impressions, video_played_to_25%, video_played_to_50%, total_impressions, total_video_played_to_25%, total_video_played_to_50% day1, 50, 30, 40, 50, 30, 40 day2, 40, 20, 35, 90, 50, 75 day3, 20, 10, 30, 110, 60, 105 day4, 20, 10, 30, 130, 70, 135 day5, 20, 10, 30, 150, 80, 165 day6, 20, 10, 30, 170, 90, 195 day7, 20, 10, 30, 190, 100, 225 The last 3 columns I have added to calculate total values of that day by adding previous records with current records. For impressions its correct because we can sum yesterdays impressions with todays to get total, but not other metrics. For VideViewRate I have calculated using formula of views/impressions to get totals. So I am searching for a way to calculate the same with VideoQuartile25Rate, VideoQuartile50Rate. Thanks, N Kishore. On Friday, November 30, 2018 at 10:02:34 PM UTC+5:30, Dhanya Sundararaju (AdWords API Team) wrote: > > Hi Kishore, > > You can use the fields: VideoQuartile25Rate and VideoQuartile50Rate in > Campaign Performance Report to get the percentage of impressions where the > viewer watched 25% and 50% of your video respectively. If that does not > answer your question, could you please elaborate with specific examples > from the UI so that I can check further? > > Regards, > Dhanya, AdWords API Team > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/e79187f8-026e-47ae-8c3b-57386500d827%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
