| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||||||
2 | INSTRUCTIONS | |||||||||||||||||||||||||
3 | (1) Copy this spreadsheet in Google Sheets via File → Make a copy | |||||||||||||||||||||||||
4 | (2) Enter your total 90-day catalog revenues in columns A and B | |||||||||||||||||||||||||
5 | (3) Sort products by Column B (Revenue) highest to lowest | |||||||||||||||||||||||||
6 | (4) Flag any low conversion rate products using your Sessions by landing page report | |||||||||||||||||||||||||
7 | (5) Enter your COGS to evaluate your margin and break even points, and price increase headroom | |||||||||||||||||||||||||
8 | (6) Evaluate the roles of each product. | |||||||||||||||||||||||||
9 | (7) Prioritize your tests into waves or separate tracks based on revenue contribution, margin headroom, and product role. | |||||||||||||||||||||||||
10 | (8) Develop your hypotheses for each test. |