I have amplitude data in redshift (via S3).
I also have Google ads in redshift (via stitch).
I’m trying to join my amplitude data to my google data by using the amplitude event time and utm_content and connecting it google ads using the date and ad_id respectively.
a lot of the records are connecting but many others aren’t.
Is there something I’m missing?
Hello
Thanks for your question! I will need more information from you to better investigate your query.I will ask a Community Moderator to help transfer this post into a Support ticket and continue investigations from there.
Thank you!
Reply
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comWelcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.