
Data mining project - input wanted
I'm about to embark on a huge data mining project that will take about 3,000 orders from the past few months and input the following data:
- order #
- traffic source (drilled down to specific PPC campaigns, etc)
- trigger email that caused the purchase (if applicable)
- days elapsed from opt-in to sale
- # of follow-up emails from opt-in to sale
- if someone bought without opting in (there are more of these than I thought)
In addition I want to add in details from specific autoresponder and broadcast emails including:
- open rate
- # sent
- whether text or html email
etc etc.....
...with an ultimate goal of looking at which individual traffic sources and AdWords campaigns respond best to which combination of tactics. In other words, based on what I find out, I can start sending each traffic source to its own email follow-up series.
I know that I can input either set of data separately into a spreadsheet app like Excel and generate charts but the issue I'm having is how to I cross-reference both sets of data to generate the end result I'm looking for.
Is there a way to do this in Excel without hurting my brain or am I needing a more robust database app like FileMaker?
Thanks!
Frank
Steve Rosenbaum - The Back End Specialist
Legally Extract Facebook User Data into Your Database