Building the Referral Attribution Backbone Powering Driver Acquisition and Vendor Payouts

A fleet management company running a driver-referral program — where existing drivers, in-house field sales staff, and third-party sourcing vendors all earn credit for successfully referring new driver-partners — needs a precise, time-bound way to decide whether a given vehicle allocation counts as a successful referral.

Without clear rules, referral attribution is prone to disputes: a referral logged weeks before a driver actually joins, a driver who takes on a second vehicle, or a referral credited to the wrong referrer type can all distort who gets paid and how much.

TopN Analytics built a referral-attribution pipeline anchored on a precise time window — a referral only counts if the referred driver's first vehicle allocation falls between the referral's logged activation date and its expiry date.

The pipeline normalizes referrer identity across several source types into one consistent category set, and separately tracks 'add-on' credit for when a referred driver takes on an additional vehicle within 30 days of their first allocation, so multi-vehicle referral value isn't lost. The resulting fact table applies the same new-join/rejoin/resurrection classification used elsewhere in the business.