Hello everyone,
I would like to list the most specific locations of presence from the clicks of a campaign.
According to the documentation, this query:
SELECT click_view.location_of_presence.most_specific, metrics.clicks FROM click_view
WHERE
campaign.id = XXX AND segments.date DURING TODAY
returns both valid and invalid clicks.
Is there any way to determine if and how many of the metrics.clicks are valid? or to return only the valid ones? Unfortunately metrics.invalid_clicks is not available for click_view...
Any help would be appreciated.
Regards