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.
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!