Retrieving details information about GoogleAds campaigns

[Łukasz Kowalski]

Hi everyone, I am working on Google Ads API. My goal is to find detailed information on the cost, clicks, etc. for each "Performance Max" campaign. When I use the following query:
 
```
SELECT
  campaign.id,
  campaign.name,
  segments.ad_network_type,
  segments.advertising_channel_type
FROM
  campaign
WHERE
  segments.date DURING LAST_30_DAYS
  AND segments.advertising_channel_type = 'Performance Max'
```

I see that the ad_network_type field has a value of 'mixed'. I want to find detailed information on what constitutes this 'mixed' value (e.g., how many clicks, impressions, cost) for the components such as:

    CONTENT
    GOOGLE_TV
    SEARCH
    SEARCH_PARTNERS
    UNKNOWN
    UNSPECIFIED
    YOUTUBE

I found information in the documentation that such data can be retrieved from the detail_placement_view table:
https://developers.google.com/google-ads/api/fields/v15/detail_placement_view
https://developers.google.com/google-ads/api/fields/v15/detail_placement_view_query_builder
However, when I try to retrieve any data from this table, even with the simplest query, I always get an empty array as a result, for example:

I have tried this query:
```
SELECT detail_placement_view.placement_type
FROM detail_placement_view
WHERE segments.date BETWEEN '2024-01-01' AND '2024-05-26'
```
and it always returns me an emtpy array. I have tried manipulating this query, extracting different fields, increasing the date range, etc., but I always get an empty array. Why is this happening? Is this table still provided by Google, or is it deprecated? Does anyone have any information on this?

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

Please be informed that the ad network type MIXED refers to campaigns that include both Google Search and Display Network ads. This allows advertisers to target their ads to people who are searching for products or services on Google, as well as people who are browsing websites and apps on the Display Network.

In order to assist you further, could you provide us the complete API logs (request and response with request-id and request header) generated at your end along with the uncropped UI screenshot from your Google Ads account highlighting the field that you are trying to retrieve using Google Ads API.

If you are using a client library and haven't enabled the logging yet, I would request you to enable logging for the specific client library that you are using. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag.

You can send the details via Reply privately to the author option, or direct private reply to this email.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tJ1Rq:ref" (ADR-00235566)

Thanks,
 

Google Ads API Team