Ellos dicen
«Most of our sales have no customer attached.»
Nosotros decimos
Then the report shows a large Direct / Unknown and tells you the truth about what is measurable. Emailed receipts are usually the cheapest way to change that.
Para Square
A card-present sale is the hardest thing in marketing to attribute. It is also most of your revenue.
Export your Square transactions, upload the enquiries beside them, and find out which marketing produced the people who walked in.
Sin clave de API Nada que instalar en SquareNada que instalar Sin tarjeta de créditoSin tarjeta
CloseRev reads a Square export of transactions — the customer's email or phone where it was captured, the amount and the date — and matches it against the calls, forms and ad clicks that brought that person in. A card-present sale is the least attributable event in marketing: there is no click, no session and no referrer, only somebody standing at a counter. Sales with no matching lead are reported as Direct / Unknown rather than assigned to whatever was running.
Comprobado por última vez con la documentación del propio Square el 24 de septiembre de 2026.
La brecha
You advertise to bring people through the door. They come through the door. Nothing you own connects those two sentences.
Square 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
Customer email or phone
On the customer record attached to the transaction. This is the constraint that decides everything on this page: a sale with no customer attached cannot be matched at all.
- Necesaria
Transaction or invoice total
What was taken, net of refunds. Tips are a judgement — include them consistently or exclude them consistently.
- Necesaria
Transaction date
When the payment was taken. For Square Invoices, the paid date rather than the sent date.
- Opcional
Location
Which site took the sale. For anybody running more than one, this is the column that turns an average into a decision.
Paso a paso
Cómo sacar el archivo de Square.
Escrito para quien tiene Square 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 transactions with the customer attached
One row per sale with a contact detail, the amount and the date. A transactions export without a customer column is the common case and it cannot be matched — check this before anything else.
-
Look at how many sales have a customer at all
This is the single number that decides whether the exercise works. If a quarter of sales carry an email or phone, that is your ceiling, and the report will say so rather than pretend otherwise.
-
Export your enquiries
Call tracking, the booking widget, the contact form, local search leads. Contact detail plus where it came from.
-
Cover a wide enough window
Somebody who searched on Tuesday may come in on Saturday, or the Saturday after. Give the sales file more room than the enquiry file.
-
Upload both
The join runs on the email and the phone, normalised, and reports first sales separately from repeat ones.
Lo que recibe
La página que Square 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 Medicina estética y dermatología, no de una cuenta de Square.
Atribuidos a un canal$165,60072% de $230,000
Ventas coincidentes201 de 280solo alta confianza
Ticket medio$820por venta pagada
| Canal | Proporción | Ventas | Ingresos |
|---|---|---|---|
| Meta Ads | 96 | $78,200 | |
| Google Ads | 61 | $55,200 | |
| Email marketing | 44 | $32,200 | |
| Directo / Desconocido | 79 | $64,400 |
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 sale y el anuncio comparten una fila.
No click, no session, no referrer — and it is where the money is
Everything digital advertising measures depends on the purchase happening in a browser. A card-present sale has none of it: no click to attribute, no session to attach, no referrer, no landing page.
So businesses that sell in person get told, in effect, that their advertising produces nothing — or they get a proxy like store visits, which is modelled, cannot be reconciled with anything, and never appears on a bank statement.
Matching a payment export against an enquiry file is the only reading built on two things that actually happened: somebody enquired, and somebody paid. It is coarse and it is real, which is the right trade for a question that currently has no answer at all.
The customer record is the whole ceiling, and most businesses have not thought about it
Square will take a payment without knowing anything about who paid. Many businesses run for years that way, and their transaction export is a list of amounts with no people attached.
Where a customer is attached — because they were emailed a receipt, booked an appointment, joined a loyalty scheme or were invoiced — the sale can be matched. Where they are not, it cannot, and no amount of cleverness changes that.
So the honest first step is counting. If the attachment rate is low, the report will show a large Direct / Unknown, and the useful conclusion is about the till process rather than about the marketing. Emailed receipts alone typically move this more than any campaign change would.
Appointments and invoices match far better than walk-ins
Square's booking and invoicing products capture a contact detail as a matter of course. A salon appointment, a trades invoice or a quote sent by email arrives with an email address attached and matches cleanly.
An anonymous counter sale does not. That means the matched share is not evenly distributed across a business's revenue, and reading it without knowing that will mislead — the bookable side of the business will look like it is where all the marketing works.
Where the export distinguishes the two, read them apart. It is the difference between a report about your marketing and a report about your data capture.
Several locations, one budget, one average that helps nobody
Multi-site operators buy marketing centrally and read it centrally, and the blended cost per customer is the number that reaches the owner.
The same campaign performs very differently across sites — catchment, competition, footfall and the staff at the counter all differ — and the average describes none of them. It is entirely normal for a channel to be the cheapest customer at one site and the most expensive at another.
Where the transaction export carries a location, the report splits on it, and that split is usually the reason a multi-site business does this at all.
Preguntas justas
«Square ya hace eso». No exactamente.
Ellos dicen
«Square already shows customer directory insights.»
Nosotros decimos
Those describe who bought. They do not describe which advert produced them, because Square never saw the advert.
Ellos dicen
«We do not want to add steps at the counter.»
Nosotros decimos
Then read the bookable and invoiced side of the business, which already captures contact details, and take the walk-in revenue as unmeasured rather than misattributed.
No. Nothing is installed at the till and no credential to your account exists; the report is built from a file you downloaded.
Transactions with a customer contact detail, the amount and the date.
They cannot be matched and are reported as Direct / Unknown. The share of sales carrying a customer is the ceiling on the whole exercise.
Yes, and better than counter sales — a booking captures a contact detail as a matter of course.
Yes, and it matches cleanly. Use the paid date rather than the sent date.
Either, consistently. Mixing them across a file makes one location or one period look better for no real reason.
Include them. A channel's revenue should fall when its customers are refunded.
Yes, where the export carries one — and for a multi-site business that is usually the point of doing this.
They are reported separately from first sales, so the decision stays yours.
Further than the enquiry file. People search days or weeks before they come in.
A contact detail, an amount and a date, plus a location if you include one. No card data, no line items, no loyalty history — and card details could not be included even if you wanted them, because they never leave Square. Encrypted in transit and at rest and deleted with the import.
Revenue by channel for sales that had no click, the share matched, and everything unmatched reported as unmatched.
Por sector
Sectores que usan Square.
Cómo se ve el informe una vez cargada la exportación, escrito para cada uno.
- Medicina estética y dermatología¿Qué anuncios produjeron tratamientos que la gente pagó?
- Muebles y decoración del hogarEl sofá se mira en internet y se compra en la tienda.
- JoyeríasNadie compra el anillo en un navegador.
- Talleres mecánicos¿Qué canales generaron órdenes de reparación pagadas?
- Tiendas de neumáticos y rines¿Qué canales generaron tickets de neumáticos pagados?
- Retail multisede¿Qué canales generaron ingresos en tienda y en línea?
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 Shopify Merchants selling offline as well as online Archivo de ventas cerradas Qué exportar Archivo de ventas cerradas QuickBooks Online Businesses whose sales are invoices, not deals Archivo de ventas cerradas Qué exportar Archivo de ventas cerradas Boulevard Med spas, salons and aesthetic clinics Archivo de ventas cerradas Qué exportar
Los 68 sistemas 
Square 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 Square, sin clave de API y sin necesidad de haber rastreado nada hasta ahora. El año pasado funciona igual de bien que este mes.