A Modern catalog square inch analysis (called squinch by some) is a different proposition than it was fifteen years ago.For most of us, we don't have a housefile big enough to truly detect what a catalog drove to the online channel, at an item, department, or division level. So we have to make some assumptions.Here's one way to approach a modern catalog square inch analysis.Step 1: Conduct your standard mail/holdout test. If you're under fifty million in annual sales, you'll probably need at least 7,500 folks in your holdout group to get a halfway decent read of online results.Step 2: At the conclusion of your test (say eight weeks after the in-home date), you'll measure your results as follows: | Catalog Square Inch Analysis Test Results |
|
|
|
|
|
|
| Current | Other | Online |
|
| Catalog | Catalogs | Sales | Totals |
| Mail | $3.00 | $8.00 | $6.00 | $17.00 |
| Holdout | $0.00 | $9.00 | $4.50 | $13.50 |
| Increment | $3.00 | ($1.00) | $1.50 | $3.50 |
Ok, things are going to start getting interesting.Step 3: Tally the total sales for your catalog, based on your telephone results. Let's assume that number is $2,000,000.Step 4: Ok, we have to adjust for cannibalization. This catalog, based on the test results, cannibalized other sales by 33% (the dollar lost in the table above divided by the three dollars of incremental sales per customer. So, the $2,000,000 in sales is multiplied by 0.333, yielding $666,667 that will be taken away in Step 6.Step 5: Now, we have to adjust for the sales we drove online. Based on the test results, we drove an additional $1.50 online, a 50% increase (the $1.50 driven online divided by the $3.00 recorded by the catalog). So, the original $2,000,000 in sales is multiplied by 0.500, yielding $1,000,000 that will be added in Step 6.Step 6: Let's come up with a final demand number. We take the $2,000,000 telephone sales number, we subtract $666,667 for cannibalization across other catalog phone demand, then we add $1,000,000 of incremental online volume. In total, the catalog drove $2,000,000 - $666,667 + $1,000,000 = $2,333,333.Step 7: Take $2,333,333 and divide it by the $2,000,000 your systems recorded, yielding a "lift factor" of 1.167.Now we can calculate a semi-accurate DMPC (demand per thousand pages circulated) for each item. DMPC is a very good measure when doing a square inch analysis.Step 8: Record the phone sales for an item. Say that amount is $10,000.Step 9: Multiply that number by the lift factor in Step 7 of 1.167, yielding $11,670.Step 10: Record the percentage of a page that the item occupied in the catalog. Let's assume an item took up 0.25 of a page.Step 11: Record the total circulation of the page in the catalog. Let's pretend the number is 750,000.Step 12: DMPC (Demand per Thousand Pages Circulated) is calculated as:- ((Lifted Demand) / (Fraction Of Page * Circulation)) * 1,000.
- Or ... ((Step 9) / (Step 10 * Step 11)) * 1,000.
- ($11,670 / (0.25 * 750,000)) * 1,000.
- = $62.24.
And that's it. Just twelve easy steps. You compare the DMPC of this item against other items. You calculate a "break-even", and compare items against the break-even level.Big companies have an advantage, in that they can calculate lift at a merchandise division or department level --- there are enough customers in a holdout group to do this. At Nordstrom, we learned that we didn't have to offer Mens merchandise in a catalog ... the very presence of Womens merchandise drove customers online (and into stores) to buy Mens product.Anyway, that's how we conduct a modern catalog square inch analysis.Your thoughts?Labels: DMPC, Square Inch Analysis, SQUINCH
