Hi again everyone. Can anyone help with seting up a metric that measure Earning Per Click? SELECT user_id, user_pseudo_id as anonymous_id, TIMESTAMP_MICROS(event_timestamp) as timestamp, event_value_in_usd as value FROM

events_intraday_*

WHERE event_name = 'purchase' AND event_value_in_usd IS NOT NULL AND event_value_in_usd != 0 AND _TABLE_SUFFIX BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}' With "Visits" as Denominator does not seem to work. What am I missing? ( understanding probably 🙂 )

Hey, @curved-football-3891 - Is the query returning an error or is the data returned just not what you expect? This looks like it might be for a GA4 / BigQuery data source - if so, the

FROM

clause might be an initial place to start. I think you'll need the projectId and default dataset prefixed. E.G. FROM ``projectId.defaultDataset.events_*``

Thank you @billions-xylophone-11752 I do not get data I expect. I get the same results as for Average order Value 😞