What your Macy's dashboard cannot tell you

Log into Macy's and you get Macy's. Log into Nordstrom and you get Nordstrom. Both are accurate, both are useful, and neither can answer the question you sat down to ask.

That question is almost always about a product, not a channel. Is this coat working? Where is it working? And why does it come back twice as often in one store as another?

The same SKU behaves differently in different places. A jacket that returns at eleven per cent on your own site can return at twenty-six on a department store. Same garment, same size run, often the same photography. What changes is the customer, the returns policy, the delivery promise and how the product was merchandised on the page.

Portals cannot see each other. Every marketplace reports on its own orders, in its own definitions, over its own return window. Put four of those side by side in a spreadsheet and you are not comparing like with like, you are comparing four different measurement systems.

Reasons are where the money is, and they are the first thing lost. Marketplace returns arrive with a reason code from that marketplace's own list. Those codes rarely match each other and almost never match your own. Normalise them and a pattern that was invisible in any single channel becomes obvious across all of them.

Channel share is not channel health. A store taking thirty per cent of your units can be taking sixty per cent of your returns. On volume it looks like your best account. On contribution it is your worst.

The view worth having is one SKU, every channel, one set of definitions. Revenue, units, return rate, top reason and worst size, per store, over the same window. That is what changes the next buy, and it is not a view any single portal can give you.

‍

What this looks like in practice

Reportly pulls Shopify, the marketplaces and wholesale into one product view. Open a SKU and you see every channel it sells on side by side, on one definition of a return rate and one window.

Reason codes from each marketplace are mapped to a single set of reasons on the way in, so a sizing problem at Macy's and a sizing problem at Nordstrom count as the same thing.

‍