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 Jotform

The lead file you were told you needed is already sitting in your form tool.

Export your submissions, match them against closed sales, and find out which forms and which sources produced revenue.

No API key Nothing to install in JotformNothing to install No card requiredNo card

Jotform sits on the lead side in CloseRev: every submission carries the contact details somebody typed, a timestamp and whatever hidden fields the form was built with. Exported and matched against closed sales, it becomes the lead file most businesses assume they do not have. Revenue with no traceable submission is reported as Direct / Unknown.

Last checked against Jotform's own documentation on September 24, 2026.

The gap

Submissions arrive by email, get actioned, and are never counted against anything.

Jotform 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 submission, as typed by the enquirer. Whichever fields your form asks for become the join keys.

  2. Needed

    Submission date

    When the form was sent, which anchors the window.

  3. Needed

    Form name

    Which form produced it. A quote request and a newsletter sign-up are not the same lead and must not be pooled.

  4. Optional

    Hidden source field

    Where a hidden field captures the campaign or referrer, this is what turns a form file into a source file.

Step by step

Getting the file out of Jotform.

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

  1. Export submissions

    One row per submission with a contact detail, the form name and the date.

  2. Keep forms separate

    Quote requests, contact enquiries, event sign-ups and support requests have entirely different values and should never be averaged.

  3. Add a hidden source field if you have not

    One hidden field carrying the campaign turns every future submission into an attributable lead at no ongoing cost.

  4. Export closed sales

    Contact detail, amount, date, from whichever system invoices.

  5. Upload both

    The join runs on the phone and the email, normalised, with unmatched submissions kept visible.

What comes back

The page Jotform 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 Jotform 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 submission and the ad share a row.

The most common reason attribution is impossible is that nobody kept the leads

Businesses are routinely told they cannot measure marketing because they have no lead data, when in fact every enquiry for three years is sitting in a form tool.

Submissions are stored, timestamped and exportable, and they carry the contact details the enquirer typed themselves.

That is all a match needs, and it means the historical report can be run today rather than starting from now.

It is worth checking before buying anything: a great many businesses already have both halves of the file and have never put them in the same place.

Where the forms have been running for years, the first report covers years rather than months, which is a much better basis for a decision.

A hidden source field costs nothing and changes everything

A form that records only what the enquirer typed can tell you that somebody enquired, not where they came from.

A hidden field populated from the page's query string carries the campaign or referrer through to the submission at no ongoing cost.

From that point every submission is an attributable lead, and the report can rank campaigns rather than merely forms.

It is the single cheapest improvement available on this page and it takes one change to a form, applied once to the template every other form is copied from.

Until it exists the report is honest about the limit: it will rank forms on revenue and will not invent a campaign breakdown.

Different forms are different leads and averaging them is the usual mistake

A quote request from somebody with a broken boiler and a newsletter sign-up from somebody browsing are both submissions, and pooling them destroys the signal.

Because form tools report submission counts as a single number, that pooling is the default and it makes every channel look the same.

Splitting by form is immediate, requires nothing extra, and usually reveals that one form produces nearly all the revenue.

That finding changes where the buttons go on the website, which is a cheaper intervention than changing the media plan.

It also tends to reveal a form nobody has looked at in two years quietly producing enquiries that go to an inbox nobody reads. That is not a marketing problem and it is usually the most expensive thing the report finds.

Spam and duplicates are real and the report should show them

Public forms attract automated submissions and duplicate entries from people who pressed the button twice.

Counted as leads, they inflate the volume of whichever channel exposed the form most, which is usually the best-performing one.

Normalisation collapses obvious duplicates on the contact detail, and anything that cannot be matched is reported rather than quietly dropped.

The report does not silently discard rows it does not like, because a lead file that has been cleaned by an invisible rule cannot be checked by anybody.

That matters more than it sounds. Every attribution number rests on which rows were kept, and a tool that decides that quietly is asking to be trusted on the one judgement that determines the answer.

Fair questions

“Jotform already does that.” Not quite.

They say

“We do not have a lead file.”

We say

You almost certainly do. Every submission your forms have taken is stored, timestamped and exportable.

They say

“Our forms do not record the source.”

We say

One hidden field fixes that for every future submission. Until then the report ranks forms and declines to invent campaigns.

They say

“Most submissions are rubbish.”

We say

Some are, and the report shows what it could not match rather than cleaning the file behind your back.

Questions

Jotform, specifically.

Something else? Ask us and a person answers.

No. It reads an exported file, so your forms, submissions and integrations stay where they are.

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