'Firebase A/B test user variant information not available in Google Analytics clickstream tables

I'm looking to report on the outcome of a Firebase A/B test using Google Analytics / BigQuery tables.

To do this I need to identify the test group each user was in.

The Firebase documentation (https://firebase.google.com/docs/ab-testing/ab-concepts) suggests experiment and variant memberships are stored as user properties on every GA event in the normal GA event tables.

However, I can't find this information associated with GA events in the GA interface or BQ clickstream tables - I can only see it in the Firebase tables.

Where should I be looking? I've checked the Event Action, Event Category, Event Label etc. dimensions.



Solution 1:[1]

Use in your query to identify it userProperty.value.string_value where userProperty.key = 'firebase_exp_000'

Sources

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

Source: Stack Overflow

Solution Source
Solution 1 Pash