Forum Discussion
Creating a calculated column from another table based on date criteria
Anonymous attached with this reply.
Super UserAnonymous quick question, I think you want to get the campaign id based on store / customer, not only just dealdate
Hi parry2k - Yes, you are right, sorry for the confusion!
Basically the last Campaign the customer received before they actually bought a boat, based on those date criterias.
- parry2k
Anonymous how about store? Does that matter? I noticed campaigns are by store
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!
- parry2k
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.
We can send the same type of campaign to multiple stores