Forum Discussion
Creating a calculated column from another table based on date criteria
Example file with Sales and Mailers Tables Example End Product Conversion Chart by Campaign Background: We help boat dealers sell boats, we do marketing for them. I have 2 tables: Mailer table ...
Anonymous attached with this reply.
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.
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!