Which channels produced paid flooring jobs?

Customers browse online, then come in and decide with a sample in hand. Every dashboard records the visit as direct traffic, and the campaign that produced it disappears.

If the showroom captures a name and a contact detail, that list belongs in the lead file, tagged as showroom. Matched against completed jobs, the campaigns that fill the showroom finally show up in the revenue.

Retail-only sales and full supply-and-fit jobs differ by several thousand dollars, and channels feed them unevenly.

A job-type column mapped as Product / service shows full installations and material-only sales as separate lines, with how much of each traces to a channel, so the two are not averaged into one figure.

Most flooring is sold in a showroom. Somebody searches, browses, and then drives to look at samples, because nobody commits to a floor from a photograph. The advertisement's job is to produce a visit, and the visit's job is to produce a sale, and almost no flooring retailer can connect the two.

So the website is measured on form submissions and phone calls, which are a small and unrepresentative slice of the demand it actually generates. The channels that drive footfall look weak and the channels that drive form fills look strong, and the ranking that results is close to backwards.

Matching invoiced sales back to the customer, using whatever contact detail is captured at the point of quotation or order, recovers the footfall that the website produced. It will not recover all of it — some walk-ins genuinely cannot be traced — and the report says so rather than pretending otherwise.

A supply-only sale and a supplied-and-fitted job carry very different margins, and they are frequently produced by different searches at different costs. A price-led keyword tends to bring supply-only buyers; a design-led or room-led keyword tends to bring fitted work.

Ranking channels on total revenue hides that, because a large supply-only order and a smaller fitted job can invoice the same amount while earning very different money.

Exporting margin rather than revenue as the amount lets the report rank on what the business actually keeps; do it consistently, because the report adds up every row in the workspace. It is a one-column change and it can reverse which campaign looks like the best in the account.

Flooring paperwork names whoever paid, and that is frequently not the person the campaign reached. A retail order can be raised against a husband's card when the wife spent three weeks researching and chose the product. A fitted job can sit under a builder's trade account when the homeowner found you directly. A landlord's details can appear on work an agent arranged. In each case the inquiry file holds one person and the sales file holds another, and a match that reads contact details will not connect them, because strictly they are two different people.

The remedy is not cleverer matching, it is the right contact. Most order and point-of-sale systems carry a site or delivery contact alongside the bill-to account; put that person's phone or email in the row's contact fields instead of the account's, and the engine has a person to test rather than an account name. Where a trade account genuinely covers many households, the honest treatment is to export each job's own contact instead of the account, and to accept that builder-supplied work belongs to the builder relationship rather than to a consumer campaign that never touched it.

What should not happen is guessing. A shared surname and a nearby address are not a match, and the engine does not link such a pair at all. Anything unmatched stays in Direct and Unknown rather than being allocated to whichever campaign looks most plausible. For a showroom business that means the attributed figure starts lower than you might like and can be relied on. Raising it is a change to how orders are recorded, not a setting.