Hello,
I am a data analyst working to improve transparency for trends in our sales campaigns.
I am looking for an easier way to represent our campaigns' performance based on three criterion at the same time.
If you look at the attached sheet, I have 3 tabs, one for each criterion (credit score, state, and purchase amount).
Using these individual tabs, I can easily see within our 10 sales campaigns which credit scores have the highest performance ratings (ex: campaign 1 best performance is within 750-759 credit scores).
Same goes for state (campaign 1 best performance is in NM), and purchase amount (campaign 1 best performance is within $1000-$2000 purchases).
The issue now is figuring out how to dissect these campaigns even further, which would be looking into all three of these criteria at once.
For example, I know the 750-759 credit score performs the best in campaign 1... which states within this credit tier perform the best? Which purchase amounts within this credit score tier perform the worst?
I know I can accomplish this by subtotaling by all three criteria at once, but the biggest issue with this is that it makes the report so huge that it's incomprehensible especially with so many campaigns.
What I am doing now is trying to think outside the box to find a way to accomplish this. Maybe there is a better way in Excel to solve this problem? Maybe there is a better solution outside of Excel (Microsoft Access? Data modeling, etc)?
In a "perfect world", I would like to have a way to first identify which campaigns have the best performance ratings based off each criteria separately. But then have a way to "click into" the campaign and see the other two criteria within this sample. I gave some thought to a collapsible subtotal, but since the actual report I use has hundreds of rows of formulas broken out into 26 campaigns, I don't know how well this would work.
I REALLY appreciate any help or ideas on how to help me accomplish this! Let me know if anything doesn't make sense.
Thanks ahead of time
Bookmarks