Measurement
Part of How to measure promotional merchandise campaigns and report the results
Build a promotional merchandise reporting dashboard or borrow one?
Compare building a promotional merchandise reporting dashboard with borrowing tools such as Looker Studio, Power BI, Tableau, Geckoboard and Databox.
What to take away
A Sheffield distributor tracked a 4,000-unit order through a spreadsheet, a courier portal and an inbox. When the client asked which channel drove the repeat order, nobody could answer without three hours of digging.
- Fix source data before you choose a tool.
- Agree attribution rules in writing before the first chart.
- Keep three to five headline metrics, not twenty.
- Name one owner and one glossary.
- Review monthly and rebuild quarterly.
Build or borrow: name the real options
The title asks a simple question. Build if you have one data source, one owner and fewer than three viewers. Borrow if several people need live access or you need connectors.
Build vs borrow dashboard tools
Build path
- Tools
- Sheets, Excel, Looker Studio
- Cost
- Free with Google account
- Best for
- Small teams, one source
- Limit
- Refresh depends on source
Borrow path
- Tools
- Power BI, Tableau, Geckoboard
- Cost
- Per-user or per-dashboard
- Best for
- Live access, connectors
- Limit
- Licences, cost, admin
Build path: Google Sheets or Microsoft Excel as the source, then Google Looker Studio for charts. Looker Studio is free with a Google account and connects to Sheets and BigQuery. Suits small teams. Limit: refresh depends on the source.
Borrow path: Microsoft Power BI, Tableau, Geckoboard, Databox and Klipfolio.
Build or borrow
- Microsoft Power BIper-user subscription; strong Excel links. Suits finance teams. Limit: viewers often need a licence.
- Tableauper-user subscription; deep visual analysis. Suits larger firms with analyst support. Limit: cost and admin.
- Geckoboardsubscription per dashboard; prebuilt connectors. Suits operations teams that display live numbers. Limit: lighter modelling.
- Databoxsubscription with a limited free tier; marketing connectors. Suits agencies and marketing teams. Limit: connector depth varies.
- Klipfoliosubscription; custom client-facing dashboards. Suits teams reporting to clients. Limit: setup needs technical input.
Start with the source data
List every place a number is born: order system, warehouse, courier, event sign-up sheet, social platform. Each one needs an owner and a refresh frequency.
Source data inventory checklist
- Order system
- Warehouse
- Courier
- Event sign-up sheet
- Social platform
- Owner and refresh date per source
Write that list as a table with a date beside each owner. A broken feed then has somewhere to be recorded.
If your firm buys advertising to support a campaign, the reporting interface behind small business advertising resources will export impressions and clicks you can join to order data. Without that join, paid reach stays a separate story.
Agree attribution rules first
Attribution is the argument that sinks most builds. Decide whether a redemption code, a QR scan or a sales conversation counts as the trigger. Write the rule down and date it. Version the document.
When the rule changes, older numbers stay readable only if you know which version produced them. The wider question of which method suits which campaign sits in our guide to promotional merchandise attribution methods. Read it before you hard-code a model into a tool.
Pick three to five headline metrics
More metrics do not mean more insight. Choose a small set and hold them stable for at least two quarters.
| Metric | What it answers |
|---|---|
| Cost per redeemed item | Did the unit economics work? |
| Repeat order rate | Did the merchandise earn a second purchase? |
| Enquiry-to-order conversion | Did the campaign move pipeline? |
| Stock write-off value | Did we over-order? |
Everything else belongs in a drill-down view, not the front page.
Size the market you report into
Context helps a client judge whether a result is good. ONS publishes changes to business data covering business births, deaths and survival. That gives a defensible backdrop for sector claims.
For a static comparison, the business population estimates for 2022 show how many firms existed then. You can frame growth without inventing a figure.
Build the glossary
A short glossary ends most disputes. Keep it visible in the dashboard itself.
- Redemption
- a code or QR scan logged against a specific order.
- Reach
- unique people who saw the branded item or its campaign.
- Cost per unit
- total campaign spend divided by units distributed.
- Attribution window
- the period in which a touchpoint can claim credit.
- Write-off
- stock that cannot be sold or reissued.
Set the review rhythm
Book a monthly check and a quarterly rebuild. Monthly checks catch broken feeds. Quarterly reviews catch metrics that no longer matter. Put the metric definitions in the same document as the review dates.
The full set of measurement questions, from briefing to board pack, sits in our pillar on promotional merchandise measurement and reporting. Read it alongside this build guide so the dashboard serves the reporting cycle rather than replacing it.
Common questions
Should we build or borrow first?
Build a simple version if you have one owner and fewer than three viewers. Borrow when live access or connectors matter more than control.
How long does a first build take?
For a small supplier, two to four weeks of part-time work is realistic once source access is agreed. Most of that time goes on definitions, not wiring.
Do we need a paid analytics tool?
No. A spreadsheet with a scheduled refresh and one owner can carry a small catalogue. Move to a paid tool when more than three people need live access.
Who should own the dashboard?
One named person, usually in marketing operations or finance. Shared ownership is how definitions drift.
