Sie sagen
„Most of our sales have no customer attached.“
Wir sagen
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.
Für 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.
Kein API-Schlüssel Nichts in Square zu installierenNichts zu installieren Keine Karte nötigOhne Karte
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.
Zuletzt am 24. September 2026 anhand der eigenen Dokumentation von Square geprüft.
Die Lücke
You advertise to bring people through the door. They come through the door. Nothing you own connects those two sentences.
Square sieht
Was verkauft wurde, an wen und für wie viel.
keine gemeinsame Zeile
Ihr Anzeigenkonto sieht
Der Klick, das Keyword, der Anruf und was jedes davon gekostet hat.
Die Datei
Was im Export stehen muss.
Drei Dinge tragen die Zuordnung: wer, wie viel und wann. Alles andere ist optional und ändert nur, wie sich der Bericht aufschlüsseln lässt.
- Erforderlich
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.
- Erforderlich
Transaction or invoice total
What was taken, net of refunds. Tips are a judgement — include them consistently or exclude them consistently.
- Erforderlich
Transaction date
When the payment was taken. For Square Invoices, the paid date rather than the sent date.
- Optional
Location
Which site took the sale. For anybody running more than one, this is the column that turns an average into a decision.
Schritt für Schritt
So holen Sie die Datei aus Square.
Geschrieben für alle, die Square im Nachbar-Tab geöffnet haben. Berichtsnamen unterscheiden sich je nach Edition, deshalb sagt jeder Schritt, wonach Sie suchen.
-
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.
Was zurückkommt
Die Seite, die Square Ihnen nicht zeigen kann.
Umsatz nach Kanal, die Zahl der Verkäufe hinter jedem Wert und eine ehrliche Kategorie für alles, was niemand zuordnen konnte. Beispielzahlen aus dem durchgerechneten Beispiel der Seite Ästhetik & Dermatologie – nicht aus einem Square-Konto.
Einem Kanal zugeordnet$165,60072% von $230,000
Zugeordnete Verkäufe201 von 280nur hohe Konfidenz
Durchschn. Verkauf$820pro bezahltem Verkauf
| Kanal | Anteil | Verkäufe | Umsatz |
|---|---|---|---|
| Meta Ads | 96 | $78,200 | |
| Google Ads | 61 | $55,200 | |
| E‑Mail-Marketing | 44 | $32,200 | |
| Direkt / Unbekannt | 79 | $64,400 |
Nicht zugeordnete Verkäufe bleiben unter Direkt / Unbekannt. Sie werden nie auf die bezahlten Kanäle verteilt, damit die Summe besser aussieht.
Das Argument
Was sich ändert, wenn sale und Anzeige in einer Zeile stehen.
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.
Berechtigte Fragen
„Square kann das doch schon.“ Nicht ganz.
Sie sagen
„Square already shows customer directory insights.“
Wir sagen
Those describe who bought. They do not describe which advert produced them, because Square never saw the advert.
Sie sagen
„We do not want to add steps at the counter.“
Wir sagen
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.
Nach Branche
Branchen, die Square nutzen.
Wie der Bericht aussieht, sobald der Export drin ist – für jede Branche eigens geschrieben.
- Ästhetik & DermatologieWelche Anzeigen haben Behandlungen gebracht, die bezahlt wurden?
- Möbel & WohnenEin Sofa wird online angeschaut und im Möbelhaus gekauft.
- JuweliereDen Ring kauft niemand im Browser.
- Kfz-WerkstättenWelche Kanäle haben bezahlte Werkstattaufträge gebracht?
- Reifen- und FelgenhändlerWelche Kanäle haben bezahlte Reifenaufträge gebracht?
- FilialhandelWelche Kanäle haben Umsatz in der Filiale und online gebracht?
Andere Systeme
Ebenfalls lesenswert.
Mehrere Systeme im Einsatz oder im Vergleich? Die Methode ist dieselbe, die Spalten sind es nicht.
Datei mit Abschlüssen Shopify Merchants selling offline as well as online Datei mit Abschlüssen Was exportieren Datei mit Abschlüssen QuickBooks Online Businesses whose sales are invoices, not deals Datei mit Abschlüssen Was exportieren Datei mit Abschlüssen Boulevard Med spas, salons and aesthetic clinics Datei mit Abschlüssen Was exportieren
Alle 68 Systeme 
Square und die anderen Produktnamen und Logos auf dieser Seite gehören ihren Inhabern und dienen nur dazu, die Software zu kennzeichnen, aus der eine Datei stammt. CloseRev ist mit ihnen nicht verbunden oder von ihnen empfohlen und verbindet sich mit keinem davon: CloseRev liest eine Datei, die Sie exportieren.
Heute starten
Zwei Exporte, und Sie wissen es.
Nichts in Square zu installieren, kein API-Schlüssel, und Sie müssen bisher nichts getrackt haben. Das Vorjahr funktioniert so gut wie dieser Monat.