The art of merch data analysis: how to move from pieces delivered to real return

Why most merch reports are not useful for decisions

Corp-Merch.MX has reviewed merch reports from clients that closed the year with numbers of pieces produced, pieces delivered and pieces in storage, but not a single line that connected the spend to a business outcome. The reason is almost always the same: the report comes from procurement or marketing operations, not from business intelligence, because merch is treated as an admin expense and not as a programme with measurable return.

Corp-Merch.MX proposes a four layer data scheme. The first layer is pieces: SKU, supplier, price, MOQ, production date, delivery date, batch, quality control. The second layer is deliveries: recipient, date, location, programme assigned, requesting business unit. The third layer is interaction: QR scanned, landing visited, action taken (download, register, purchase, refer). The fourth layer is business: pipeline generated, sales attributed, talent retention, internal NPS satisfaction.

Corp-Merch.MX has seen clients that adopt this four layer scheme answer three questions they could not answer before: what is the real cost per lead captured (including production, logistics and promotion), what is the return per programme (not per order), and which catalogue piece converts best and which one only looks pretty. Those three answers are what defend next year budget and trim what does not work.

The investment in merch data analysis usually pays back in the first year, because it identifies between 15% and 30% of pieces that get purchased and nobody uses, and between 20% and 40% of pieces that are underestimated in the logistics budget. Corp-Merch.MX has seen clients reduce total programme spend while keeping the same delivery level, simply because the analysis allowed reallocating volumes to pieces and programmes with the best return.

Corp-Merch.MX has also learned that merch data analysis is not just a reporting exercise: it is an input for next year planning. The programme that converts best in Q1 is not necessarily the one that converts best in Q4, because sales cycles, business unit budgets and external client calendars shift. Corp-Merch.MX recommends reviewing the four data layers every month, not just at year close, to adjust the mix of pieces and programmes in real time.

How Corp-Merch.MX rolls out data analysis with a new client

Corp-Merch.MX starts with a two week diagnostic where we review the available data sources (orders, deliveries, CRM, event platform, social media), identify the gaps, and propose a minimum viable capture scheme. Corp-Merch.MX delivers a data architecture document with the four layers, the minimum fields per layer, the source of every field, and the owner of every source. The document translates into a dashboard in Looker Studio, Power BI or Tableau, depending on the platform the client already runs.

Technical implementation includes source connection, historical data cleanup (when applicable), KPI definition in the dashboard, and training the client team to use the dashboard. Corp-Merch.MX also defines the monthly review ritual, where the four metrics get looked at, the goals get adjusted, and the decision happens on which pieces or programmes get kept, adjusted or retired. The ritual is documented in minutes that get archived in the programme repository.

Data analysis is invoiced as a one-off project (diagnostic, dashboard, training) or as a monthly service inside the merch management contract. Corp-Merch.MX recommends the second option for clients with more than 8,000 pieces per year, because continuous analysis needs dashboard maintenance, source connection refreshes, and attribution model retraining when the client changes CRM or event platform.