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 Yelp

Three channels share one name, and only two of them leave a trace.

Capture Yelp calls and requests as leads, match them against closed sales, and separate what the ads added from what the listing would have brought anyway.

  • No API key
  • Nothing to install in YelpNothing to install
  • No card requiredNo card

Yelp sits on the lead side in CloseRev: a call, message or quote request a business receives through its Yelp page becomes a lead once it carries the customer's own phone number or email and a date, and those leads can be matched against closed sales. A Yelp presence is really three things under one name — a free listing, paid advertising and a body of reviews — and only the first two produce leads anybody can trace. Revenue with no traceable lead is reported as Direct / Unknown.

Page updated October 5, 2026.

The gap

The dashboard shows page views and calls. The ledger shows sales. Nobody has put the two together.

Yelp 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

    Customer phone or email

    The caller's full number from your own phone log or CRM, or the phone number a requester shared. Yelp's call report shows only part of a number, and its message email is a relay address.

  2. Needed

    Contact type

    Call, message or request a quote — put in the campaign column so each ranks separately. Each is a different level of intent.

  3. Needed

    Date

    When the contact happened; it decides which of a customer's leads came first.

  4. Optional

    Paid or unpaid period

    Not read as a field: label it in the campaign value, or compare periods with the report's period comparison. It is how the ads get separated from the listing.

Step by step

Getting the file out of Yelp.

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

  1. Record each Yelp call with the caller's full number

    Yelp's call reporting shows only part of it. Your phone system's log of calls to the Yelp number, or a callback number confirmed on the call, gives the whole one.

  2. Export messages and quote requests

    Keep the phone number where the customer shared one. Yelp's email is a relay address that expires, so it will not match a sale.

  3. Mark when ads were running

    The listing produces leads whether or not you advertise. The ads are only worth what they add on top.

  4. Export closed sales

    From whatever invoices: contact detail, amount, date.

  5. Upload both

    The join runs on the phone and the email, normalized, with calls, messages and requests apart in the campaign drill-down.

What comes back

The page Yelp 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 Home Services page — not from a Yelp account.

Traced to a channel$323,10068% of $475,200
Sales matched100 of 171high confidence only
Average sale$2,820per paid sale
ChannelShareSalesRevenue
Google Ads54$218,600
Meta Ads29$66,500
Email marketing17$38,000
Direct / Unknown71$152,100

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 lead and the ad share a row.

The listing, the ads and the reviews are different channels

A business on Yelp has a free listing that people find by searching, advertising that places it higher or elsewhere, and reviews that shape whether anybody chooses it.

Reported as one thing, the listing's steady flow of inquiries gets credited to the ads, and the ads look far more productive than they are.

The honest question about the advertising is what it adds above what the listing already produced, and that needs periods with and without ads to compare.

Where the business has advertised continuously there is no baseline, and the report will not invent one.

Pausing ads for a few weeks in a quiet season is the cheapest experiment available, and the lead file makes its result readable.

Engagement on the page is interest, not a customer

A listing's reporting typically counts actions taken on the page — a call tapped, a direction requested, a website link followed.

Those are real signals that somebody was interested. They are not customers, and many never become one.

A call or request carrying the customer's own phone number turns one of those actions into a lead with a contact detail, and the ledger turns the lead into money or nothing.

That is the chain the report follows. Anything that cannot be followed to a contact detail stays as an engagement figure and is never presented as revenue.

Reviews move the channel and cannot be credited with a sale

Ratings change how many people pick a business from a list, and that effect is large and slow.

It cannot be attributed to a customer, because nobody in the sales file interacted with a review in a way anything recorded.

The defensible reading is to measure the Yelp channel accurately on revenue, month by month, and look at it beside the business's rating over the same period.

A report that assigns revenue to individual reviews is guessing, and the guess is invisible, which is worse than an honest gap.

Calls can be most of it, and they are the part most often lost

People who find a local business on a phone often call it. Yelp's own call reporting puts a forwarding number on the page and logs each call's date and duration, but only part of the caller's number, which cannot be matched to a sale.

Unless the full number is recorded somewhere, the result is a Yelp channel that looks small in any report and a Direct / Unknown bucket that looks large.

Your phone system's log of calls to the Yelp number, or a callback number confirmed on each call, supplies it. Yelp may not accept a third-party tracking number on the page, so check its guidelines before swapping one in.

Until those numbers are recorded the report is honest about the gap: it ranks what it can trace and shows the size of what it cannot in Direct / Unknown, which can be the most persuasive argument for recording them.

Fair questions

“Yelp already does that.” Not quite.

They say

“Yelp already reports leads.”

We say

It reports actions on the page. Whether they became customers is in your sales records, which it never sees.

They say

“Our ads obviously work — calls go up when they run.”

We say

Then the with-and-without comparison will show it, in revenue rather than in calls.

They say

“Can you tell which reviews brought customers?”

We say

No, and nothing honestly can. The channel is measured on revenue and read beside the rating over time.

Questions

Yelp, specifically.

Something else? Ask us and a person answers.

No. It reads files you exported and your own call records, so your listing and account stay where they are.

Yelp 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 Yelp, no API key, and no need to have been tracking anything until now. Last year works as well as this month.