How to get full report of running Placements

[Peter Truong]

Hi team, I am trying to get the full report regarding the placements that the campaign run on. In the campaign, there is 

- Total: Placements 1,8k impressions

- Total: Other 82k impressions

I query the data in the table "managed_placement_view" and it just returns me data of the"Total: Placements", not including "Total: Other". I search Google and it show that I need to use the "placement performance report" (deprecated) and not found in the builder query 

Can you please help me to get the data on all placements (both targeting and outside)?

Bests,

[Google Ads Scripts Forum]

Reposting the last inquiry (https://groups.google.com/g/adwords-scripts/c/LDqICTkXkn8) from the forum as it wasn't routed to our support queue.

Regards,
Google Ads Scripts Team

[Google Ads Scripts Forum]

Hi Peter,

Thank you for reaching out to the Google Ads Scripts Team.

Kindly note that the previously named Placement Performance Report which conforms to the AdWords Query Language when mapped is the stated managed_placement_view report which conforms to the Google Ads Query Language. That said, in order for metrics to be viewed from the `Total: Placements`, `Total: Other`, you would need to segment your report. You can check the documentation on the managed_placement_view <https://developers.google.com/google-ads/api/fields/v13/managed_placement_view> and check the fields you may use to segment the report. Kindly also check the query builder for the said report type <https://developers.google.com/google-ads/api/fields/v13/managed_placement_view_query_builder>.

If you would need further assistance, kindly provide your Google Ads account ID and a complete and uncropped screenshot of the placements you would specifically like to retrieve from a campaign but doesn't get returned by the managed_placement_view so that we can investigate your concern further. You may send these privately via the Reply to author option. Note that you may need to join the Google Group for you to use this option. If this option is not available on your end still, you may send it through our email (googleadsscr...@google.com) instead.

Best regards,
Google Ads Scripts Team

[Peter Truong]

Hi, I read the document you sent me and try with some potential segment "segments.ad_network_type", "segments.device" . However, it seems not to display full data placement of the campaign. 

The query only returns the "Total: Placements" (1837 imps).

Here is my first query

SELECT campaign.name, ad_group_criterion.youtube_channel.channel_id, metrics.impressions

FROM managed_placement_view

Bests,

[Google Ads Scripts Forum Advisor]

Hello Peter,

Upon reviewing the screenshot you have provided, we suspect you have items with zero metrics and will not be included in the report as Google ads API does not support zero metrics. You will have to add other metrics, such as conversions, for products that have 0 metrics to be returned. You can read more in this article: https://developers.google.com/google-ads/api/docs/reporting/zero-metrics. However, if the disregarding zero click item result is inconsistent, kindly provide us the following:

• Google Ads account ID or CID
• Additional Screenshots of Issue
• Script Name

Kindly send the requested items via `Reply privately to author` option. If the said option is not available on your end, you may send those through this email alias <googleadsscr...@google.com> instead.

Regards,

 

Google Ads Scripts Team

ref:_00D1U1174p._5004Q2lJ9Om:ref