Cookie preferences

Choose what we may use. Strictly necessary cookies keep you signed in and can't be turned off; everything else is your call and changes nothing about how the site works. You can change your mind any time from the footer.

For Redtail CRM

The paperwork was signed in May. The assets arrived in June. The first fee was billed in October.

Export prospects from Redtail, match them against new households and fees, and rank sources on the assets and revenue they actually produced.

  • No API key
  • Nothing to install in Redtail CRMNothing to install
  • No card requiredNo card

Redtail sits on the lead side in CloseRev for an advisory firm: it records the prospect, how they arrived and the household they belong to, while the revenue is a fee on assets that is billed elsewhere, often a quarter in arrears. CloseRev joins Redtail's contacts to the firm's billing or new-asset records on the contact detail and reports new households and fee revenue by source. Revenue with no traceable source is reported as Direct / Unknown.

Page updated September 25, 2026.

The gap

The CRM knows who became a client. The billing system knows what they pay. Nobody has put the source on the fee.

Redtail CRM sees

What was sold, to whom, and for how much.

no shared row
Your ad account sees

The click, the keyword, the call, and what each one cost.

The file

What the export needs in it.

Three things carry the match: who, how much, and when. Anything else is optional and only changes how the report can be sliced.

  1. Needed

    Contact phone or email

    On the contact in Redtail, and on the client record in billing. The contact detail joins them.

  2. Needed

    Source (by household)

    How the prospect arrived. The household is the client, not the individual: give every household member's row the same source, so either contact detail joins.

  3. Needed

    Assets transferred and date

    From the custodian or the billing system: what actually arrived, and when.

  4. Optional

    Fees billed

    What the household has paid. One amount is read per row, so run fees as their own import if you also upload assets. It lags the assets, and it is the revenue.

Step by step

Getting the file out of Redtail CRM.

Written for somebody with Redtail CRM open in the next tab. Report names vary by edition, so each step says what to look for.

  1. Export prospects and clients with their source

    One row per contact with a contact detail, source and the date they first appeared — one row for each household member.

  2. Export new assets or fees by household

    From billing or the custodian: contact detail, amount, date.

  3. Match on the household, not the person

    A spouse may have been the inquiry and the other partner the account holder. List both in the lead file with the same source, so either contact detail joins.

  4. Export a long period

    Assets arrive weeks after signing, and fees follow a quarter or more after that.

  5. Upload both

    The join runs on the phone and the email, normalized, with the first-seen date in the matched-records export for grouping by when the prospect arrived.

What comes back

The page Redtail CRM cannot show you.

Revenue by channel, the count of sales behind each figure, and an honest bucket for the ones nobody could trace. Sample figures, from the worked example on the Wealth Management page — not from a Redtail CRM account.

Traced to a channel$376,00047% of $800,000
Sales matched53 of 114high confidence only
Average sale$7,000per paid sale
ChannelShareSalesRevenue
Google Ads24$168,000
Email marketing18$112,000
Events11$96,000
Direct / Unknown61$424,000

Unmatched sales stay in Direct / Unknown. They are never spread across the paid channels to make the total look better.

The argument

What changes when the household and the ad share a row.

The revenue is not in the CRM

An advisory firm's CRM holds relationships: prospects, households, notes, meetings. The fee — a percentage of assets, billed quarterly — is calculated somewhere else.

That separation is sensible, and it means no report inside the CRM can say which source produced revenue, because the revenue is not there.

Joining the CRM's contacts to the billing records on the contact detail brings the two together without either system knowing about the other.

The result is fee revenue by source, which is the number a firm's marketing should be judged on.

Where only new-asset figures are available, rank on those and say so, since assets are what fees are charged on and they arrive a quarter sooner.

Signed is not transferred, and transferred is not billed

Between a signed agreement and money under management sit the account transfers, which take weeks and sometimes arrive only in part.

Then the first fee is billed, often at the end of the following quarter and in arrears.

A report built on signed agreements counts clients whose assets never fully arrived; a report built on billing alone looks a quarter behind every campaign.

The matched-records export carries the prospect's first-seen date, so revenue can be grouped by when the household arrived, whatever the transfer and billing timetable.

Set beside the signed amounts in the CRM, it also shows how much of what was signed actually arrived, per source, which is a useful number of its own.

The household is the client

Advisers serve households: a couple, sometimes a family, often with several accounts under different names.

The person who inquired is frequently not the account holder, and a match that looks only for the inquirer's details misses the household entirely.

With every household member in the lead file under the same source, any contact detail joins, and the household's assets all credit one channel, which keeps the client whole.

Both partners still count as two leads, so read lead counts with that in mind — in a firm growing through couples' referrals it happens often — but the revenue lands on one channel.

Rollovers are a life event with their own sources

A large share of new assets can arrive as retirement plan rollovers, when somebody changes jobs or retires.

Those clients often arrive through different routes from ordinary referrals — an employer relationship, a workshop, a search at a specific moment in life — and they bring larger balances.

Where the firm marks rollover households, mapped as Product / service, the report cuts revenue by it, and the matched-records export shows whether the sources feeding rollovers are a short and specific list.

Knowing that list lets a firm put its effort where the largest single decisions are made.

It also stops a single large rollover from deciding a source's ranking. Balances vary enormously between households, so the report shows the count and the average beside the total, and the matched-records export lists every household, so a source carried by one exceptional household is visible as exactly that.

Fair questions

“Redtail CRM already does that.” Not quite.

They say

“Redtail already tracks our prospects and clients.”

We say

It does. The fees are in billing, and nothing puts the source on the fee.

They say

“Our growth is all referrals.”

We say

Then recording the referrer lets the report rank them on the assets and fees they produced.

They say

“The fee lags too much to measure.”

We say

Which is why grouping by when the household first appeared — from the matched-records export — beats grouping by billing date.

Questions

Redtail CRM, specifically.

Something else? Ask us and a person answers.

No. It reads exported files, so your contacts, notes and activities stay where they are.

Redtail CRM and the other product names and logos on this page belong to their owners and are shown to identify the software a file comes from. CloseRev is not affiliated with or endorsed by them, and connects to none of them: it reads a file you export.

Start today

Two exports, and you will know.

Nothing to install in Redtail CRM, no API key, and no need to have been tracking anything until now. Last year works as well as this month.