You are a marketing analyst trying to measure the success of your campaigns.
Data engineering has already compiled all of the relevant information into tables from Snowflake and it’s up to you to perform the ROI analysis.
A great alternative to writing SQL directly into Snowflake or downloading massive CSV files is to start analyzing in the no-code solution, Datameer.
Read the full details of this use case here: https://www.datameer.com/blog/blending-data-to-solve-for-ad-spend-roi-an-e-commerce-analytics-use-case-with-datameer/