https://www.growthbook.io/ logo
n

nice-shampoo-1738

09/04/2023, 6:19 AM
I am trying to get the experiment and variation data from mParticle in Google BigQuery. We have sent it as event attributes which means it shows up in BigQuery as sub elements on rows (see image) How do I get the data in to the SQL formular in GrowthBook?: SELECT mparticleuserid as user_id, eventtimestamp as timestamp, experimentId as experiment_id, variationId as variation_id
I am now so far as getting the data shown in the image from this query: SELECT mparticleuserid as user_id, eventtimestamp as timestamp, attributename, attributevalue FROM
dataset.mparticle.raw_event_other_experimentviewed*.
AS t, UNNEST(t.eventattributes) AS eventattributes WHERE attributename = "experimentId" OR attributename = "variationId"
But I need a separate column for experiemntId and variationId for me to figure out how to state it in Growthbook. Can anybody help?
f

fresh-football-47124

09/04/2023, 10:08 AM
Hi Kasper. You should be able to do that with a simple self-join
if you don’t figure it out, I can help you in a few hours
n

nice-shampoo-1738

09/04/2023, 10:33 AM
Please do @fresh-football-47124 🙂
@fresh-football-47124 Did you have any tips for the Arrayed mParticle structure in BigQuery to Growthbook SQL? 🙂
f

fresh-football-47124

09/05/2023, 11:35 PM
Hi Kasper: do you have some time to meet this week?
n

nice-shampoo-1738

09/06/2023, 10:58 AM
@fresh-football-47124 friday?
f

fresh-football-47124

09/06/2023, 10:29 PM
yes
n

nice-shampoo-1738

09/07/2023, 6:03 AM
Dang - its very edge hours for my euro timezone. ill need to coordinate some more then. Thank you for the link. I´ll put in a request when I get the time sorted :)
f

fresh-football-47124

09/08/2023, 5:03 PM
I can work late my time, earlier your time