Order sheet columns
Date · product · channel · campaign or code · city · confirmed · courier · status · delivered or refused · return reason · courier cost both ways · margin.
Analytics and tracking
We set up tracking that follows an order to the doorstep: which ad, post or channel brought it, whether it was confirmed, delivered or refused, and what it cost in courier fees both ways. The result is one sheet or dashboard showing profit by product, channel and city — not just likes and order counts.
On the Business bundle package, from PKR 25,000 per month. Ad spend, if you run ads, is separate.
Why it fits
Online sellers often know how many orders came in but not how many turned into money. When a share of COD parcels comes back, a product or city that looks busy may quietly lose money. Without tracking, every decision is a guess: which ad to scale, which city to stop shipping to, which product to restock. Tying each order to its source and its final status turns those guesses into figures you can act on.
The work
Examples
Illustrative starting points, not results. The audit decides the real first move.
Order sheet columns
Date · product · channel · campaign or code · city · confirmed · courier · status · delivered or refused · return reason · courier cost both ways · margin.
A question the data answers
'Ads for the black bag bring plenty of orders from one city, but many refuse — is it worth shipping there?' The sheet shows cost per delivered parcel for that city, so the answer is a figure rather than a feeling.
Record every order with its source, city and courier status, and mark it delivered or refused when the courier updates. Add the courier cost both ways for refusals. Sellers in Islamabad and Rawalpindi who do this weekly can see which products, channels and cities actually make money.
Only if you have a website. If you sell through DMs and WhatsApp from a room in G-13 or Bahria, a well-kept order sheet with source codes tells you more. Once a store is live, analytics and ad pixels add detail, but the order-to-delivery sheet stays at the centre.
Pitfalls
Where
Price
The Business bundle includes tracking on the website we build and run for you; auditing a large existing site with several platforms is quoted separately.
Business bundle
from PKR 25,000per month
A local shop, clinic or service that needs to be findable, not just posted.
These are the questions we get on WhatsApp every week, answered the way we would answer them there.
WhatsApp usAnalytics and tracking sit with the Business bundle, including the order sheet and pixel checks. Complex dashboards joining several stores, Daraz and courier data are scoped and quoted separately.
Sometimes. It depends on whether your courier offers an export or an API. Where it does not, we set up a simple weekly import from the courier portal instead.
Related
Next step
Tell us your business and where you trade. We reply on WhatsApp with the first thing we would change, usually under 2 hours in working hours.
WhatsApp us