Ellos dicen
«We already set a lead source on every job.»
Nosotros decimos
Then you have something to check this against, which is better than most. Where the two disagree, the click and the invoice are the harder evidence.
Para Workiz
Every job is in Workiz. Which advert produced it is not.
Export your jobs, upload the calls and leads beside them, and rank channels on what was charged rather than on what was booked.
Sin clave de API Nada que instalar en WorkizNada que instalar Sin tarjeta de créditoSin tarjeta
CloseRev reads a Workiz export of completed jobs — the client's phone or email, the amount charged and the date — and matches it against the calls and leads that produced them. It is built for the trades Workiz serves, where jobs are booked on the phone in minutes and the same customer never appears twice, so a channel's booking count says very little about its worth. Jobs with no matching lead are reported as Direct / Unknown.
Comprobado por última vez con la documentación del propio Workiz el 24 de septiembre de 2026.
La brecha
You spend on three or four channels and the phone rings from all of them. Which one pays for itself is a matter of opinion in your business, and it should not be.
Workiz ve
Qué se vendió, a quién y por cuánto.
ninguna fila en común
Su cuenta publicitaria ve
El clic, la palabra clave, la llamada y cuánto costó cada uno.
El archivo
Qué debe contener la exportación.
Tres cosas sostienen la coincidencia: quién, cuánto y cuándo. Todo lo demás es opcional y solo cambia cómo se puede desglosar el informe.
- Necesaria
Client phone or email
On the client the job is attached to. The phone is the realistic key here: these jobs are booked by phone and a large share of clients never give an email at all.
- Necesaria
Job total charged
What the job actually took, after whatever was added on site. In these trades the difference between the quote and the total is routine and is often most of the margin.
- Necesaria
Job or payment date
When the work happened or was paid for. These jobs close fast, so the two are usually days apart.
- Opcional
Job type or source field
If your team already sets a source on the job, include it — the report will compare it against what the match found, which is an education.
Paso a paso
Cómo sacar el archivo de Workiz.
Escrito para quien tiene Workiz abierto en la pestaña de al lado. Los nombres de los informes varían según la edición, así que cada paso indica qué buscar.
-
Export jobs with what they charged
One row per job with a client contact detail, the amount and a date. The export listing jobs with totals is the one; its name differs by account.
-
Include the whole period, not the campaign window
These jobs close quickly, so a tight window works better here than in most trades — but emergency work still arrives days after somebody first searched.
-
Export your calls and leads
Call tracking is the main one. Marketplace leads, website forms and anything else that produced a phone call belong in the same file.
-
Upload both
The join runs on the phone number, normalised on both sides. Exact matches count automatically and weaker ones are put in front of a person.
-
Compare against what your team recorded
If the office has been setting a source on jobs, put the two side by side. The gap between what people remember and what the numbers say is usually large and always instructive.
Lo que recibe
La página que Workiz no puede mostrarle.
Ingresos por canal, el número de ventas detrás de cada cifra y un grupo honesto para las que nadie pudo rastrear. Cifras de ejemplo, del caso práctico de la página Puertas de garaje, no de una cuenta de Workiz.
Atribuidos a un canal$274,50061% de $450,000
Ventas coincidentes309 de 505solo alta confianza
Ticket medio$890por venta pagada
| Canal | Proporción | Ventas | Ingresos |
|---|---|---|---|
| Google Ads | 171 | $153,000 | |
| Anuncios de servicios locales | 109 | $94,500 | |
| Meta Ads | 29 | $27,000 | |
| Directo / Desconocido | 196 | $175,500 |
Las ventas sin coincidencia quedan en Directo / Desconocido. Nunca se reparten entre los canales pagados para que el total se vea mejor.
El argumento
Qué cambia cuando cada job y el anuncio comparten una fila.
One-time customers make volume metrics misleading
A locksmith, a junk removal outfit or a garage door repairer mostly sees a customer once. There is no maintenance agreement, no second visit, no lifetime value to spread over — the job is the whole relationship.
That makes the revenue of the individual job the only thing that matters, and it makes booking counts actively misleading. A channel producing thirty small lockouts and a channel producing eight door replacements look very different on a dashboard and very similar on the bank statement, or the other way round.
Ranking on what was charged, per channel, is the only comparison that means anything in these trades, and it is the one nobody has because the money and the leads are in different systems.
Emergency work is bid on by everybody and converted by whoever answers
Urgent work has the shortest consideration window in this catalogue. Somebody locked out of their car is not researching, they are calling the first three numbers and going with whoever picks up and can come now.
Two things follow. The cost per click is high because everyone is bidding on the same intent, and the conversion depends on operations as much as on marketing — a missed call is a lost job, whatever the campaign did.
Matching invoiced jobs back to channels exposes both. A channel that produces calls you do not answer shows up as expensive, and it should, because for your business it is.
The ticket differs more than the volume does
Across these trades, the spread between the smallest and largest job is very wide and the distribution has a long tail. A handful of jobs carry a disproportionate share of the month.
Any metric that treats jobs as interchangeable — cost per lead, cost per booking, conversion rate — is blind to exactly the jobs that paid for the month. Ranking channels on money is not a refinement here, it is the difference between a useful answer and a wrong one.
What the office writes down and what the numbers say
Most teams already ask callers how they heard about the business, and most already have a source field somebody fills in. It is worth keeping and it is not worth trusting on its own.
The known failure is not carelessness. Callers genuinely do not remember, they say the internet when they mean a search advert, and staff under pressure pick whichever option is first in the list. The error is systematic rather than random, so it does not average out.
Putting the recorded source beside the matched source shows the size and direction of that error, which is usually the first thing a business learns from doing this at all.
Preguntas justas
«Workiz ya hace eso». No exactamente.
Ellos dicen
«Our jobs close the same day — is the match still useful?»
Nosotros decimos
More useful, not less. A short window means fewer confounders, and the money still sits in a different system from the lead.
Ellos dicen
«We are too small for this.»
Nosotros decimos
The smaller the business, the more one wrong channel costs as a share of the budget. Two exports is the whole exercise.
No. It reads a file you exported; no credential to your account is held and nothing is written back.
Jobs with a client contact detail, the amount charged and a date.
Calls and leads with a source — call tracking, marketplace leads, web forms.
Yes. The phone number is the better key in these trades and it is what the match leans on.
Because it disagrees with the evidence in a predictable direction, and the size of the disagreement is worth knowing.
On the phone number, normalised with a proper phone library on both sides rather than compared as text.
Yes, where the export carries a job type — and in these trades that is usually the most useful split there is.
They are reported as Direct / Unknown rather than assigned to a channel.
Indirectly and usefully: a channel producing calls that never became jobs ranks badly, which for your business is the true reading.
A little further than the lead file. These jobs close fast, but not always the same day.
A contact detail, an amount and a date. No job notes, no photos, no dispatch records, no card details. Encrypted in transit and at rest, isolated to your workspace, deleted with the import.
Revenue by channel from charged jobs, what share could be matched, and everything that could not.
Por sector
Sectores que usan Workiz.
Cómo se ve el informe una vez cargada la exportación, escrito para cada uno.
- Puertas de garaje¿Qué canales generaron trabajos de puertas agendados?
- Plomería y fontanería¿Qué anuncios produjeron trabajos que valen la pena?
- Electricistas¿Qué canales generaron trabajos eléctricos agendados?
- Servicios de residuos y reciclaje¿Qué canales generaron cuentas con facturación?
- Empresas de climatización (HVAC)¿Qué anuncios vendieron equipos, y no visitas de servicio?
Otros sistemas
También vale la pena leer.
¿Usa más de un sistema o está comparando? El método es el mismo; las columnas, no.
Archivo de ventas cerradas FieldEdge HVAC, plumbing and electrical contractors Archivo de ventas cerradas Qué exportar Archivo de ventas cerradas Housecall Pro Oficios de servicios residenciales Archivo de ventas cerradas Qué exportar Archivo de ventas cerradas Shopmonkey Auto repair shops Archivo de ventas cerradas Qué exportar
Los 68 sistemas 
Workiz y los demás nombres de productos y logotipos de esta página pertenecen a sus propietarios y se muestran para identificar el software del que procede un archivo. CloseRev no está afiliada a ellos ni cuenta con su respaldo, y no se conecta a ninguno: lee un archivo que usted exporta.
Empiece hoy
Dos exportaciones y lo sabrá.
Nada que instalar en Workiz, sin clave de API y sin necesidad de haber rastreado nada hasta ahora. El año pasado funciona igual de bien que este mes.