Hi Damir,
I can take a closer look for you if you'd like. You can reply privately to
author your CID, report query and results to do so.
Regards,
Anthony
Google Ads API Team
ref:_00D1U1174p._5001UODb2E:ref
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
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
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:
>
Hi,
I struggled with this some time ago. Later someone asked the same question,
and the answer there best describes my findings:
https://groups.google.com/d/msg/adwords-api/KLLiGbhnHAA/EnUhS7_LBgAJ
To summarize (but do read previous discussion):
1. Video campaigns consist of two types of ads,
Hi Will,
The VideoQuartile50Rate should return as a double. The value represents the
percentage of viewers that watched at least 50% of the video. I can have a look
at your report definition, results and UI so I can see where the discrepancy is
through reply privately to author.
Regards,
Hi Anthony,
You wrote that "The *VideoQuartile50Rate* field in the API should match the
value of *Video played to: 50% *in the Google Ads UI."
This doesn't seem to be the case, however. In the example that Damir
mentioned, the Google Ads UI is displaying a rate:
[image: Screen Shot
Hi Damir,
Since the API and UI metrics correspond to each other, you should reach out to
the product team to see how the fields are calculated as I mentioned. Once you
have the formula, you can use its corresponding API fields if you are unable to
use the actual VideoQuartile50Rate field.
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
Hi Damir,
The VideoQuartile50Rate field in the API should match the value of Video played
to: 50% in the Google Ads UI. Here are more details on video fields in Google
Ads. If you are still curious about how these numbers are calculated, you can
reach out to the product team by clicking on the
