Hello fellow experts, I need some advice on a task the marketing department in my company has asked me to do. Basically, we have a user who receives emails from a contact form on our website, in one of the required fields it asks "where did you hear about us" and they select one of about a dozen options. It sends them an email with a basic subject line, and in the body is shows what they selected. They would like to someone extrapolate how many emails/leads come in from a certain magazine/website/referral. Then create excel charts/graphs based on that data. They would like this to be somehow automated, a solution which reads as emails come in and counts where the referral is coming in from.
As of this moment the only idea I can come up with is making a dozen rules, one for each selection and dump the emails as they come in into a certain folder. Then using math and excel to create graphs/charts. But they would like this to be completely automated. Any ideas?
-Marco (Network Admin)