Trying to link amplitude utm to google ads data in redshift

aaianmars

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?

Jacenda Davis

Hello aaianmars,

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!