Hi,
I tried your query for the period from March 1, 2024, to March 2, 2024. But
the query doesn't return anything. Attached, you will find a copy of the
report made with Google Ads.
- SELECT campaign.status, segments.date, campaign.name,
metrics.cost_micros,
I've found that any query doesn't return data for paused campaigns. It's as
if they don't exist. If I use CUSTOMER, I get the correct total cost across
campaigns. However, if I use CAMPAIGN or another table, the paused
campaigns are not present in the results, whereas the active campaigns are.
How do I retrieve campaigns that are paused from the User Location View? I
used this query, but it only returns campaigns with an ACTIVE status.
QUERY:
SELECT segments.date,campaign.name, metrics.cost_micros,
user_location_view.country_criterion_id,metrics.conversions,
metrics.impressions,
