← All posts

Client referral tracking: record the first visit and reward once

A client referral tracking worksheet for studios: connect the referring client, first completed visit and reward record, with a worked example and duplicate checks.

Two paper figures connected by a green ribbon through a checked visit card to one gift parcel

Client referral tracking connects three records: the client who recommended your studio, the new client's qualifying visit, and any reward you promised. Keep a stable reference between them so a rescheduled booking or a change of shift does not produce a second reward.

A client says, “Maya sent me.” Reception notes Maya's name, another colleague books the visit, and a third person later applies a thank-you benefit. A small referral register gives each person enough information to finish that job without relying on a message buried in a private chat.

Write the qualifying rule before inviting referrals

Choose what your business will count as a successful referral. For a small trial, you could require a new client to complete and pay for a first eligible service. Write down which services qualify, how you establish that the person is new, when the offer ends, and what the referring client receives.

Separate the deadline for joining the offer from the deadline for using a reward. A person might register before the offer closes but attend later. Staff need a written answer for that case before promising a benefit. Keep the dated offer terms beside the register, including the person who can resolve an exception.

Provider workflows differ. DaySmart's referral guide describes recording the referring client and identifying referrals that have not received credit. Moadon's Hebrew guide describes a completion threshold based on payments. Check your own provider's rules rather than borrowing a trigger from another product.

In the fictional example, the studio chooses one reward per new client after a completed, paid first visit. The reward is issued to the referring client and can be used later. All names, references and results are invented for the example.

Ask the new client who referred them

Ask at the point where the new client contacts the business: “Did an existing client recommend us? If so, who?” Let them give the answer directly. A referring client's statement that a friend intends to come can remain a lead until the new client confirms the connection.

Use the normal client record to resolve identity. Two people called Maya may visit the same studio. Ask the new client for enough context to identify the intended person, and let an authorized colleague check the match. Avoid reading out other clients' contact details or visit histories.

Keep the introduction separate from the advertising source. Someone may hear about the studio from Maya, then use a general Instagram booking link. Record the confirmed referrer alongside the booking; preserve any measured source separately. The ticket-sales tracking guide covers campaign-link attribution, which cannot establish a personal reward entitlement on its own.

Agree how competing claims will be reviewed. If the client names two people, keep both statements and mark the reward decision as pending. Apply the published offer terms consistently. Do not quietly replace the original name because another person asked later.

Build a register around the client and the offer

Use one row per referred client within the particular offer. Keep the same row when that person changes the booking date or staff member. A booking reference can change; the introduction remains the same.

Field What to record
Referral reference A stable internal reference, such as R-101
Offer version The dated terms used for this introduction
Referred client Existing internal client reference
Referring client Confirmed internal reference, or unresolved
Source check Who confirmed the introduction and when
Qualifying visit Booking reference, visit date and checked outcome
Eligibility Pending, qualified or excluded, with a factual reason
Reward Reference, recipient, issue date and current state
Next action Named owner and the evidence still needed

Store the working copy where authorized reception and management staff can check it. Use client references instead of copying full contact lists into a shared sheet. Keep professional service notes in the protected client record; the client notes template explains that separate record.

Before adding a row, search for the referred client's reference and offer version. If a second record seems to describe the same person, pause the reward decision until the identity check is complete. Do not merge client records or delete the original referral evidence to make the register look tidy.

Check the completed visit before issuing a reward

A booking confirmation establishes that a visit was arranged. At the eligibility review, check the actual visit outcome and the payment evidence required by your offer. If either is unresolved, leave the referral pending and name the person who will check it.

A cancellation followed by a new booking stays under the original referral reference. Replace or append the relevant visit reference with a dated note. An appointment moved from Friday to Monday should not produce two introductions in the reward queue.

Once the conditions are met, record who approved eligibility and the supporting references. Before issuing anything, search the reward record for that referral and recipient. Record the issued reward immediately, including its reference. Until someone issues the benefit, keep it in the next action field.

Assign one person to issue each reward. Mark the row as being handled before they start, and hand over any unfinished action explicitly. Two colleagues reading the same empty reward field can otherwise both act. A shared spreadsheet does not enforce a transaction lock, so agree who may issue benefits during the review and check whether another active tool also grants them.

If the issuing screen times out, check its history before trying again. Record the action as unconfirmed until the responsible person establishes whether it succeeded. Keep a screenshot or transaction reference in the restricted working record where appropriate. A blank confirmation screen does not establish that the benefit was never issued.

Work through six submitted entries

At a fictional studio's review, six entries have arrived from reception notes and booking messages. The offer rule is the completed, paid first visit described above.

Entry New client Check at review Reward action
R-101 C-801 Referrer C-201 confirmed; visit completed and paid W-101 already issued; keep its record
R-102 C-802 Referrer C-202 confirmed; visit next week Pending the visit
R-103 C-803 Referrer C-201 confirmed; visit cancelled No reward issued; check any later eligible visit
R-104 C-801 Same client and offer as R-101 Link duplicate entry to R-101; no additional reward
R-105 C-804 Visit completed and paid; referrer unresolved Check the introduction before approving
R-106 C-805 Referrer C-203 confirmed; visit completed and paid Qualified; issue once after the final duplicate check

The six entries describe five distinct client records. Four have a confirmed referring client. Two currently satisfy the offer rule: R-101 and R-106. One reward has already been issued, and one remains to be issued. The unresolved source on R-105 stays visible rather than being assigned to a convenient name.

Give the unresolved row an owner and a review date. If the evidence cannot establish a referrer, retain that outcome and follow the offer's exception process. Do not count an unresolved claim as a reward owed merely because the visit was paid.

Keep reward issue and redemption separate

Issuing W-101 makes the benefit available to C-201. Redeeming W-101 records its use. Keep both events under the same reward reference, with dates and the redemption transaction or visit reference supported by your process.

If C-201 returns twice, staff should find W-101 and its current state before applying the benefit. A second visit does not create another entitlement from R-101. For a benefit that can be used only once, record its completed redemption so the next shift can see that it has been used.

If a qualifying payment is later reversed or a visit outcome is corrected, refer the case to the offer owner. Preserve the original issue and use records, then document the decision under the applicable terms. Check the provider's supported correction process before changing a balance or promising a replacement.

Rehearse the handover with three records

Skedful's current pricing page lists Marketing at Pro. For a client-referral process, ask the team which attribution, eligibility and reward actions are available for your account. Bring your written rule and a sample register so the enquiry concerns the actual steps your staff need.

Before launching the offer, ask two colleagues to review three fictional records independently: a future visit, a qualifying visit with no issued reward, and a qualifying visit whose reward has already been used. Compare their decisions with the rule. Resolve any disagreement, then put the approved offer version and the reward lookup instructions beside the register before reception accepts the first introduction.

About this article

Skedful is the publisher and corrections contact. Our editorial checklist covers product availability, source dates, worked examples and the limits of each claim.

About this article

Worked examples and sample calculations describe hypothetical scenarios. When an article cites research or customer results, follow the source for its context and limits.

Found an error? Send us the article link and the passage that needs a correction.

Report an error to Skedful

Reminders come with every Skedful plan, on a schedule you set once. PricingSkedful vs Fresha vs Booksy