Eles dizem
“Most of our sales have no customer attached.”
Nós dizemos
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.
Sem chave de API Nada para instalar no SquareNada para instalar Sem cartão de créditoSem cartão
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.
Verificado pela última vez na documentação do próprio Square em 24 de setembro de 2026.
A lacuna
You advertise to bring people through the door. They come through the door. Nothing you own connects those two sentences.
O Square vê
O que foi vendido, para quem e por quanto.
nenhuma linha em comum
Sua conta de anúncios vê
O clique, a palavra-chave, a ligação e quanto cada um custou.
O arquivo
O que a exportação precisa ter.
Três coisas sustentam a correspondência: quem, quanto e quando. O resto é opcional e só muda como o relatório pode ser detalhado.
- Obrigatória
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.
- Obrigatória
Transaction or invoice total
What was taken, net of refunds. Tips are a judgement — include them consistently or exclude them consistently.
- Obrigatória
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.
Passo a passo
Como tirar o arquivo do Square.
Escrito para quem está com o Square aberto na aba ao lado. Os nomes dos relatórios variam conforme a edição, então cada passo diz o que procurar.
-
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.
O que você recebe
A página que o Square não consegue mostrar.
Receita por canal, a quantidade de vendas por trás de cada número e uma categoria honesta para as que ninguém conseguiu rastrear. Números de exemplo, do caso prático da página Clínicas de estética e dermatologia — não de uma conta do Square.
Atribuída a um canal$165,60072% de $230,000
Vendas com correspondência201 de 280só alta confiança
Ticket médio$820por venda paga
| Canal | Parcela | Vendas | Receita |
|---|---|---|---|
| Meta Ads | 96 | $78,200 | |
| Google Ads | 61 | $55,200 | |
| E‑mail marketing | 44 | $32,200 | |
| Direto / Desconhecido | 79 | $64,400 |
Vendas sem correspondência ficam em Direto / Desconhecido. Nunca são distribuídas entre os canais pagos para melhorar o total.
O argumento
O que muda quando cada sale e o anúncio ficam na mesma linha.
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.
Perguntas justas
“O Square já faz isso.” Não exatamente.
Eles dizem
“Square already shows customer directory insights.”
Nós dizemos
Those describe who bought. They do not describe which advert produced them, because Square never saw the advert.
Eles dizem
“We do not want to add steps at the counter.”
Nós dizemos
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 setor
Setores que usam o Square.
Como fica o relatório depois que a exportação entra, escrito para cada um.
- Clínicas de estética e dermatologiaQuais anúncios geraram tratamentos que as pessoas pagaram?
- Móveis e decoraçãoO sofá é pesquisado online e comprado na loja.
- JoalheriasNinguém compra o anel de noivado num navegador.
- Oficinas mecânicasQuais canais geraram ordens de serviço pagas?
- Lojas de pneus e rodasQuais canais geraram vendas de pneus pagas?
- Varejo multilojaQuais canais geraram receita na loja física e online?
Outros sistemas
Também vale a leitura.
Usa mais de um sistema ou está comparando? O método é o mesmo; as colunas, não.
Arquivo de vendas fechadas Shopify Merchants selling offline as well as online Arquivo de vendas fechadas O que exportar Arquivo de vendas fechadas QuickBooks Online Businesses whose sales are invoices, not deals Arquivo de vendas fechadas O que exportar Arquivo de vendas fechadas Boulevard Med spas, salons and aesthetic clinics Arquivo de vendas fechadas O que exportar
Todos os 68 sistemas 
Square e os demais nomes de produtos e logotipos desta página pertencem aos seus donos e aparecem para identificar o software de onde vem um arquivo. A CloseRev não é afiliada a eles nem endossada por eles, e não se conecta a nenhum: ela lê um arquivo que você exporta.
Comece hoje
Duas exportações, e você vai saber.
Nada para instalar no Square, sem chave de API e sem precisar ter rastreado nada até agora. O ano passado funciona tão bem quanto este mês.