Hi,
We are building a custom report to collect and analyse our ads costs.
To achieve this, we are listing all Accounts and then listing all ads in each one of them. The issue is that ad_groups of 'display' type are not being listed. We could only list the ad_groups of 'search' type.
Display type ads cannot be listed in this resource? Is there any other that we could use to list them?
Here are the AWQL scripts that we built:
To list all accounts:
SELECT customer_client.client_customer FROM customer_client
To list all ads in each one of them:
SELECT ad_group_ad.ad.final_urls,
ad_group_ad.ad.name,
ad_group_ad.ad_group,
ad_group_ad.ad.id,
metrics.cost_micros,
segments.date
FROM ad_group_ad
WHERE segments.date BETWEEN $startDateParameter AND $endDateParameter
AND metrics.cost_micros > 0
Note that we have active display ads, so cost and date filters should not eliminate them.
Thanks and Regards,
B4B IT Team.