gorgeous-midnight-57657
08/03/2023, 5:23 AMexperiment_viewed
event on the GA4 and and also with direct queries to BigQuery. However the experiment on Growthbook still returns “No data yet. Make sure your experiment is tracking properly.”
I copied out the metric query to run directly on Bigquery and it only produces results when I remove one of the Where
clauses _TABLE_SUFFIX BETWEEN '20230727' AND '20230802'
Could this be because my experiment data is all in the .events_intraday_20230802
table ?fresh-football-47124
gorgeous-midnight-57657
08/04/2023, 8:17 AMdevice.category
(i.e mobile, desktop, other) . It’s from my device field which is struct.
{
"device": {
"category": "desktop",
"mobile_brand_name": "Apple",
"mobile_model_name": "Safari",
"mobile_marketing_name": null,
"mobile_os_hardware_model": null,
"operating_system": "Macintosh",
"operating_system_version": "Macintosh Intel###",
"vendor_id": null,
"advertising_id": null,
"language": "en-us",
"is_limited_ad_tracking": "No",
"time_zone_offset_seconds": null,
"browser": null,
"browser_version": null,
"web_info": {
"browser": "Chrome",
"browser_version": "115.0#####",
"hostname": ####
}
}
}
When I set the dimension, I get only one grouping, Mobile .
I’ve queried the experiment viewed directly and i can see that there are mobile AND desktop users who viewed the experiment. So I’m not sure why the experiment result is only returning Mobilefresh-football-47124
gorgeous-midnight-57657
08/04/2023, 8:32 AMwe give the full SQL we use to get that data shownYes I also see just one grouping when I query BQ directly. Okay. I will try with a larger sample size and if it doesn’t work I’ll resort to creating metrics for each device type. 🤞
fresh-football-47124