#announcements
Title
n
nice-shampoo-1738
09/04/2023, 6:19 AMI 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*.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 AMPlease 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 AMDang - 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