Forum Discussion
Creating a calculated column from another table based on date criteria
Anonymous attached with this reply.
parry2k Store is important because we send campaigns on behalf of a store, but it's really which campaign triggered the customer to buy.
Then I can show which campaigns are performing well for individual stores.
Thank you so much for your help on this!
Anonymous before i go deep into it, can you check if following campaign id i calculated for each dealdate looks correct based on the logic you provided.
Anonymous this is how sales looks like against each campaign based on the data, does it make sense?
Hi parry2k !
Yes that looks right if all the numbers for Campaign sales are correct, I think I only saw 2 examples that didn't flow through, but the below is absolutely correct for what I'm looking for !!!
If I'm able to add the "Campaign Attributed" Column in the Sales table - I should be able to break out the performance of campaigns for different dealers as well!
Hi parry2k - sorry for late response - everything in your original table looks correct, except for 2 callouts.
- Customer ID BM0001118195, the answer should be M1, not M5
- Customer ID BM000190996 – should be M1 not M5
AnonymousI have solution ready, let me know where you want to send me. atleast this will get you started. Although on larger schema I will improve/make changes to data model.
Thank you so much parry2k - if you're not able to add it here (feel free if you prefer to add for anyone else to see), I have google drive or one-drive, not sure what works best for you to share?