This message was deleted.
# announcementsw
worried-planet-2191
09/04/2023, 6:19 AMThis message was deleted.
n
nice-shampoo-1738
09/04/2023, 8:36 AMI 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*.nice-shampoo-1738
09/04/2023, 8:37 AMBut 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
fresh-football-47124
09/04/2023, 10:08 AM
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 🙂
nice-shampoo-1738
09/05/2023, 5:27 AM@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
fresh-football-47124
09/06/2023, 10:30 PM
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
n
nice-shampoo-1738
11/08/2023, 12:39 PMThat would be awesome. At what time would it fit in? We are just about to start it up on a customer and I simply cant wrap my head about constructing the sql to get "Add an Experiment Assignment" filled when I have the experimentid and its value as shown in the bigquery screenshot
161 Views