First of all, have to confess that my math skills are not the best and i would appreciate if you could please keep your response as simple as possible (preferably in layman's term).
I'm trying to create a scoring system for some performance reporting that I'm currently working on. There's a lot of data to go through, so I thought that a way I can help with when navigating the data would be to create a system that scores our campaigns (some type of efficiency indicator) based on a couple of variables/indicators (listed below). This would allow us to promptly identify and prioritize low performing campaigns. I would appreciate if you could please help me create an algorithm that could solve for this issue.
List Variables/Indicators:
Opportunities (This is an amount): This represents the amount of times a campaign has the chance to serve an impression to a user.
Ad% (This is a percentage): This percentage represents the amount of time an impression is waiting to be loaded after an "Opportunity" occurs. The highest this number the better it is.
Fill% (This is a percentage): This percentage represents the amount of time an impression was actually displayed. The highest this number the better it is.
Margin (This is an amount): This represents the campaign's profitability.The highest this number the better it is.
Error% (This is a percentage): This percentage represents the amount of time an error was generated, which prevented an impression from being displayed. The lowest this number the better it is.
Thanks in advance for the help and please let me know if there's any additional information I can provide to help.