Re: Customer/Campaign Report Metrics
林灿
Hello,I need to get Customer/Campaign report data through google ads api, and I encounter two problems.refer documentation
- The "install", "download", "In-app actions" indicators correspond to what fields in the api ？
- Does it support group by syntax? I need to get data within a certain period of time and return it by day
Google Ads API Forum Advisor
Hello,
Thank you for reaching out to Google Ads API Forum.
I understand that you need to get Customer/Campaign report data through google ads api, but you encounter two problems when referring to this document(https://developers.google.com/google-ads/api/fields/v13/campaign). Please see responses below.
The "install", "download", "In-app actions" indicators correspond to what fields in the api ？
- You may need to use metrics.biddable_app_post_install_conversions(https://developers.google.com/google-ads/api/fields/v13/metrics#metrics.biddable_app_post_install_conversions) field if you are looking to get the number of in-app actions and the field metrics.biddable_app_install_conversions (https://developers.google.com/google-ads/api/fields/v13/metrics#metrics.biddable_app_install_conversions) to pull the number of installs. These are not valid fields in the SELECT clause when campaign is the resource in the FROM clause. With regards to the download field, as shown in the UI it is for a mobile app, currently it is not available in the metrics for API. That said, could you provide your business use case for pulling this report so we could raise this to the rest of the team as a feature request?
Does it support group by syntax? I need to get data within a certain period of time and return it by day
- As per gaql query grammar documentation, there is no group by syntax. You may check this Google Ads Query Language grammar reference (https://developers.google.com/google-ads/api/docs/query/grammar)
Additionally, you may try referring to this guide (https://developers.google.com/google-ads/api/docs/query/cookbook#campaigns) as it provides a set of Google Ads Query Language queries that demonstrate how to return the same data as screens in the Google Ads UI, as well as how to look up geo constants. You can use these queries as is or as starting points for constructing your own customized queries.
Regards,
 |
Google Ads API Team |
ref:_00D1U1174p._5004Q2kU6eK:ref
Google Ads API Forum Advisor
Hi,
Thank you for reaching out to Google Ads API Forum.
I can see that you've already raised this same inquiry in another thread “Customer/Campaign Report Metrics”. We have already replied to the other thread and for better tracking of the issue, kindly continue discussion only in that thread instead.
Regards,
|
Google Ads API Team |
Google Ads API Forum Advisor
Hi,
Thanks for getting back with us.
With regards to your concern, can you try using the ad_group_ad_asset_view report? You may build and validate your query using our ad_group_ad_asset_view query builder. You may see sample query below:
SELECT
metrics.biddable_app_install_conversions,
campaign.id,
campaign.labels,
campaign.name,
ad_group.campaign
FROM ad_group_ad_asset_view
If this doesn't work, then can you provide the complete request and response logs with request ID generated as shown in the respective links? We do this to check if there’s an error thrown on your side and we can further investigate.
You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.
Links included in this email:
- Request - https://developers.google.com/google-ads/api/docs/concepts/field-service#request
- Response - https://developers.google.com/google-ads/api/docs/concepts/field-service#response
- Request ID - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id
- ad_group_ad_asset_view query - https://developers.google.com/google-ads/api/fields/v13/ad_group_ad_asset_view_query_builder
- ad_group_ad_asset_view report - https://developers.google.com/google-ads/api/fields/v13/ad_group_ad_asset_view