Re: How to get correct number of video quratile views

['Damir Murzagulov' via AdWords API and Google Ads API Forum]

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 Imps / Total Views 
Quartile XX, I get less value than API. 

But when I calculate Views Quartile XX by just summing all ad group types I 
get the correct value. 

[image: Screenshot (71).png]


But it is not working with the campaign performance report.   
 

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: 
> 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, InStream ads and 
> VideoDiscovery ads. VideoDiscovery is search in YouTube, InStream is an ad 
> played immediatly before a different video. Both ad types have impressions, 
> but they have completely different meaning.
> 2. For your type of calculations, you need to filter on InStream ads, as 
> you only want their impressions.
> 3. In Google Ads Web UI, you can do this by segmenting on "View Type" - 
> then you can do calculations by hand, and validate your calculation method. 
> Unfortunately, Google AdWords API does NOT support this segment. Maybe 
> Google Ads API beta does support this.
> 4. Alternatively, if that's an option, your calculation will be correct 
> when you stop all VideoDiscovery ads - or, have less than 1 impression on 
> these ads combined.
> 5. Another alternative is requesting the same results on ADGROUP level, 
> and filter on AdGroupType. Only groups with AdGroupType of YOUTUBE_WATCH 
> should be included.
>
> So basically, we're waiting on Google to add segment "View Type" to 
> CAMPAIGN_PERFORMANCE_REPORT. I'm waiting 2.5 years now. But the AdGroup 
> workaround works pretty nice.
>
>
> Hope this helps!
>
>
>
> On Monday, December 2, 2019 at 9:31:25 AM UTC+1, Damir Murzagulov wrote:
>>
>> 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 
>> VideoQuartile50 Views=VideoQuartile50Rate*Impressions 
>>
>> But the problem when I compare total values from API and my calculation 
>> numbers does not match. 
>>
>> I prepared some example here 
>> https://docs.google.com/spreadsheets/d/1L0I1Knj07KX1_0K1HKAvxme8N0eeVRcqbmGE0gqWI7o/edit#gid=0
>>
>> There, according to my calculation, I get total 
>> VideoQuartile50 Views=60094327.39
>>
>> But if I would use for calculation total numbers from API, I get 
>> VideoQuartile50 Views=48.67%*328498405=159880173.7
>>
>> Why it is happening? I am puzzled. 
>>
>>
>>  
>>
>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/ab62b501-a2d6-4c5f-9b66-5a22b15dba53%40googlegroups.com.

Re: How to get correct number of video quratile views

['Damir Murzagulov' via AdWords API and Google Ads API Forum]

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: 
> 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, InStream ads and 
> VideoDiscovery ads. VideoDiscovery is search in YouTube, InStream is an ad 
> played immediatly before a different video. Both ad types have impressions, 
> but they have completely different meaning.
> 2. For your type of calculations, you need to filter on InStream ads, as 
> you only want their impressions.
> 3. In Google Ads Web UI, you can do this by segmenting on "View Type" - 
> then you can do calculations by hand, and validate your calculation method. 
> Unfortunately, Google AdWords API does NOT support this segment. Maybe 
> Google Ads API beta does support this.
> 4. Alternatively, if that's an option, your calculation will be correct 
> when you stop all VideoDiscovery ads - or, have less than 1 impression on 
> these ads combined.
> 5. Another alternative is requesting the same results on ADGROUP level, 
> and filter on AdGroupType. Only groups with AdGroupType of YOUTUBE_WATCH 
> should be included.
>
> So basically, we're waiting on Google to add segment "View Type" to 
> CAMPAIGN_PERFORMANCE_REPORT. I'm waiting 2.5 years now. But the AdGroup 
> workaround works pretty nice.
>
>
> Hope this helps!
>
>
>
> On Monday, December 2, 2019 at 9:31:25 AM UTC+1, Damir Murzagulov wrote:
>>
>> 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 
>> VideoQuartile50 Views=VideoQuartile50Rate*Impressions 
>>
>> But the problem when I compare total values from API and my calculation 
>> numbers does not match. 
>>
>> I prepared some example here 
>> https://docs.google.com/spreadsheets/d/1L0I1Knj07KX1_0K1HKAvxme8N0eeVRcqbmGE0gqWI7o/edit#gid=0
>>
>> There, according to my calculation, I get total 
>> VideoQuartile50 Views=60094327.39
>>
>> But if I would use for calculation total numbers from API, I get 
>> VideoQuartile50 Views=48.67%*328498405=159880173.7
>>
>> Why it is happening? I am puzzled. 
>>
>>
>>  
>>
>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/f4be02df-a0a8-4e3b-a8f3-eb4eb3d5589a%40googlegroups.com.

Re: How to get correct number of video quratile views

['Damir Murzagulov' via AdWords API and Google Ads API Forum]

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 not?
VideoQuartile50 Views=VideoQuartile50Rate*Impressions 
I want to get absolute values of shows when the video was played at 50%. 
Then use the formula for totals Total VideoQuartile50Rate= SUM(VideoQuartile50 
Views)/SUM(Iipressions)


On Wednesday, December 4, 2019 at 3:37:46 AM UTC+7, adsapiforumadvisor 
wrote:
>
> 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 help 
> options on the bottom of the link I sent you.
>
> Regards,
> Anthony
> Google Ads API Team
>
> ref:_00D1U1174p._5001UODb2E:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/9917d02e-5f2d-4926-a409-42efb2a269d1%40googlegroups.com.

How to get correct number of video quratile views

['Damir Murzagulov' via AdWords API and Google Ads API Forum]

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 
VideoQuartile50 Views=VideoQuartile50Rate*Impressions 

But the problem when I compare total values from API and my calculation 
numbers does not match. 

I prepared some example 
here 
https://docs.google.com/spreadsheets/d/1L0I1Knj07KX1_0K1HKAvxme8N0eeVRcqbmGE0gqWI7o/edit#gid=0

There, according to my calculation, I get total 
VideoQuartile50 Views=60094327.39

But if I would use for calculation total numbers from API, I get 
VideoQuartile50 Views=48.67%*328498405=159880173.7

Why it is happening? I am puzzled. 


 

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/7f933e7f-5bc8-4a43-bcd0-54152fdeee0b%40googlegroups.com.

Re: Data mismatch between criteria and gender report types

['Damir Murzagulov' via AdWords API and Google Ads API Forum]

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 see data breakdown by gender but the metric is 
zero.   

Piece of response 
Gender,Undetermined,0
Gender,Female,0
Gender,Male,0
Gender,Male,0
Gender,Female,0
Gender,Female,0
Gender,Female,0
Gender,Male,0
Gender,Female,0
Gender,Undetermined,0
Gender,Female,0
Gender,Male,0
Total, --,0

Can you confirm that such data is correct? Seems that I misunderstood 
single attribution properties.
Also what would be if I include in clause all types of criteria? is the 
total value of clicks for an account in such case will match with the total 
value from another report type?   
  



On Thursday, August 15, 2019 at 12:45:53 PM UTC+7, adsapiforumadvisor wrote:
>
> Hi Damir,
>
> The Criteria Performance Report is a single attribution 
> 
>  
> type of report and that said, it would return only the criteria type it 
> deems most relevant. As you have observed, the report appears to have not 
> selected the Gender criteria as the type to return in the results.
>
> Additionally, we do not recommend comparing different report types as this 
> would produce discrepancies since each report is aggregated at different 
> levels. I hope this helps.
>
> Thanks and regards,
> Peter
> Google Ads API Team
>
> ref:_00D1U1174p._5001UEJ9Fv:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/4b4c1655-265e-466f-bb43-31c9cae97c47%40googlegroups.com.

Data mismatch between criteria and gender report types

['Damir Murzagulov' via AdWords API and Google Ads API Forum]

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 CRITERIA_PERFORMANCE_REPORT
WHERE CriteriaType=GENDER
DURING LAST_7_DAYS

I receive all zeros

Request for gender report type for the same account and same date range  

https://adwords.google.com/api/adwords/reportdownload/v201809?__fmt=CSV&__rdquery=SELECT
 
Criteria, Clicks
FROM GENDER_PERFORMANCE_REPORT
DURING LAST_7_DAYS

I get total clicks values = 21794 

My expectation here was that I would see the same metrics count. Is it 
correct behavior? What I am missing? 
Please advise, thanks. 


 

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/da9257bc-33e0-416e-8820-36bfbe3c0bd7%40googlegroups.com.

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

['Damir Murzagulov' via AdWords API and Google Ads API Forum]

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/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/9fef9561-98ed-4e82-b09d-5ae2646f74ae%40googlegroups.com.

Empty Label values in API response for ad performance report

['Damir Murzagulov' via AdWords API and Google Ads API Forum]

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 AD_PERFORMANCE_REPORT WHERE CampaignId IN [1370474364]
DURING LAST_7_DAYS

*API Response*






















Meanwhile then I request Labels from CAMPAIGN_PERFORMNCE_REPORT for same 
campaignID I get Labels 
*My request:*
POST 
https://adwords.google.com/api/adwords/reportdownload/v201809?__fmt=XML&__rdquery=SELECT
 
CampaignId,CampaignName,Labels,LabelIds,Impressions
FROM CAMPAIGN_PERFORMANCE_REPORT WHERE CampaignId IN [1370474364]
DURING LAST_7_DAYS

*API reponse* 
















 
What I am miising? Can sombody explain what problem here? 


-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/575e96d0-fdc4-4aef-a8cc-ad0ef3f89507%40googlegroups.com.