'Experiments data export from big query

I'm trying to create and experiments report by exporting data from big query.

very simple view but get 0 results. does anyone knwo why?

--hits.page.hostname AS hostname,
  DATE_TRUNC(PARSE_DATE('%Y%m%d', date), Day) AS date_range,
  exp.experimentId as test,
  exp.experimentVariant as variant
from
  `experiment.ga_sessions_*`LEFT JOIN
UNNEST(hits) hits LEFT JOIN
UNNEST(hits.experiment) exp
where
  totals.visits = 1
  and hits.type = 'EVENT'
  and exp.experimentId is not null
  and _TABLE_SUFFIX BETWEEN '20210501' AND 'DATE_ADD(CURRENT_TIMESTAMP(), INTERVAL -1 DAY)```

Thanks a lot for any help/advice.
T
sqlgoogle-analyticsgoogle-bigquery


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions