Ad_group_asset query no rows returned

[tonero]

Hello,
I am trying to get the assets insights through the Google Ads API, however, 
every time I run this query I am not getting any row back.

SELECT 
ad_group_asset.ad_group, 
ad_group_asset.asset, 
ad_group_asset.resource_name, 
ad_group_asset.status, 
ad_group_asset.asset, 
ad_group_asset.field_type, 
metrics.impressions, 
metrics.clicks, 
metrics.cost_micros, 
metrics.conversions, 
metrics.conversions_value, 
metrics.all_conversions, 
metrics.all_conversions_value, 
segments.ad_network_type, 
segments.date 
FROM ad_group_asset
WHERE segments.date BETWEEN '2022-11-01' AND '2022-11-30' 
ORDER BY segments.date ASC

The values we get from ad_group_ad_asset_view do not match what we see on 
the Ads manager hence the need to try another approach.

Could you tell me what could be the cause of this behavior?

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"Google Ads API and AdWords 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/8d0e6e04-67e3-4110-98d7-56e61c2d6da9n%40googlegroups.com.

Re: app installs data in report

[tonero]

Hello, last week, I was informed that a feature request will be raised for 
the installations and in-app-actions fields to be added at the ad group 
level. Is there any progress in this regard? 
Thank you

On Tuesday, August 30, 2022 at 10:59:26 AM UTC+2 adsapi wrote:

> Hi Tonero,
>
>
> Thank you for getting back to us. I work with Carmela and allow me to 
> assist you here. I hope you are doing well today.
>  
>
> Moving forward, regarding this, *"Is there a way to get app installs 
> values from the API at Ad_Group level?" *I'm afraid that this 
> biddable_app_install_conversions and biddable_app_post_install_conversions 
> field is not supported in the ad_group report. To see the metrics and 
> segments that can be put in the same SELECT clause as the fields of 
> customers, you may refer to this documentation 
> <https://developers.google.com/google-ads/api/fields/v11/ad_group?hl=en> by 
> clicking “Yes, it is” in the dropdown box.
>
>
> However, in order for us to create a feature request for this, could you 
> please provide a complete screenshot of the Google Ads UI showing that 
> biddable app install conversions and biddable app post install conversions 
> are available at the Ad Group level?
>
>
> You can provide it via Reply privately to the author option. If this 
> option is not available, then send it instead on this email address 
> googleadsa...@google.com.
>
>  
>
> Regards,
> [image: Google Logo] 
> Darwin 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2dokav: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 
"Google Ads API and AdWords 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/9dc141ec-0a38-4a52-84d3-d32747933cefn%40googlegroups.com.

Re: app installs data in report

[tonero]

Thank you for the feedback. As suggested, I used ad_group_ad_asset_view 

 but 
unfortunately the summed up values do not match the ones on Ad_Group level 
which I got from the Google Ads interface. Is there a way to get app 
installs values from the API at Ad_Group level?

On Tuesday, August 30, 2022 at 7:13:39 AM UTC+2 adsapi wrote:

> Hello,
>
> Thank you for raising this concern to the Google Ads API team.
>
> When looking at our reporting documentation, kindly note to select the 'Yes 
> it is 
> '
>  
> option to see what are the SELECTABLE fields for a specific report.
>
> Moving forward, since you want to retrieve 
> the biddable_app_install_conversions 
> and biddable_app_post_install_conversions, you may try using 
> ad_group_ad_asset_view 
> 
>  report 
> on your end.
>
> Regards,
> [image: Google Logo] 
> Carmela 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2dokav: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 
"Google Ads API and AdWords 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/7f15219d-ee87-4df7-a88b-3603a1a389f7n%40googlegroups.com.

app installs data in report

[tonero]

Hello, I have been trying to retrieve the installs metric of a Google Ads 
campaign.
So far I got this error:




*error_code {query_error: PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE  
}  message: "Cannot select or filter on the following metrics: 
\'biddable_app_install_conversions\'(could not support requested resources: 
\'AD_GROUP\'), \'biddable_app_post_install_conversions\'(could not support 
requested resources: \'AD_GROUP\'), since metric is incompatible with the 
resource in the FROM clause or other selected segmenting resources."}*

It seems I can't get it from the ad_group resource.
>From which resource can I retrieve the app installs data?

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"Google Ads API and AdWords 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/fa9fd3e0-90f3-406c-9cea-cc372a8ad2c8n%40googlegroups.com.