Eles dizem
“Our Shopify analytics already shows marketing attribution.”
Nós dizemos
For orders placed online, and it does it well. This is about the orders placed in a shop or over the phone, which those reports cannot see at all.
Para Shopify
Shopify attributes the checkout. It cannot attribute the till.
Export your orders, upload your calls and leads beside them, and see which marketing produced the sales that never had a click on them.
Sem chave de API Nada para instalar no ShopifyNada para instalar Sem cartão de créditoSem cartão
CloseRev reads a Shopify export of orders — the customer's email or phone, the order total and the date — and matches the ones with no click behind them against your call and lead records. Online checkout is already attributed and needs nothing from us; the point of this page is Shopify POS, phone orders and draft orders, where somebody researched online and bought where no pixel could follow. Orders that match no lead are reported as Direct / Unknown rather than credited to the last campaign that ran.
Verificado pela última vez na documentação do próprio Shopify em 24 de setembro de 2026.
A lacuna
Your online orders are measured to the penny. The customer who compared three sofas on your website and then rang to order is invisible to every report you have.
O Shopify 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 order's customer. Online orders always carry an email; point-of-sale and phone orders carry whichever your staff captured, which is why both columns belong in the file.
- Obrigatória
Order total
What the order took, after discounts and including shipping if you want it counted. Consistency matters more than which you choose.
- Obrigatória
Order date
When the order was placed. For draft orders sent as a quote, the date it was paid is closer to the decision.
- Opcional
Sales channel or location
Online store, point of sale, draft order, and which shop. This is the column that separates what already has attribution from what does not, and it is the most important optional field on this page.
Passo a passo
Como tirar o arquivo do Shopify.
Escrito para quem está com o Shopify aberto na aba ao lado. Os nomes dos relatórios variam conforme a edição, então cada passo diz o que procurar.
-
Export orders with the sales channel
One row per order with a customer contact detail, the total, the date and — if at all possible — the channel or location it came through. Without the channel you cannot tell the already-attributed orders from the ones this exists for.
-
Separate online checkout from everything else
Online orders with a click behind them are already measured properly by your ad platforms. The value here is in point-of-sale, phone and draft orders, so isolate those first and read them on their own.
-
Export your calls and leads
Call tracking, the contact form, showroom enquiry logs, quote requests. Contact detail plus the source, campaign or keyword.
-
Cover a wider window on the order side
Considered purchases are researched for weeks before somebody walks in or rings. A window as short as the ad platform's will miss exactly the orders this is for.
-
Upload both
The join is the email and the phone, normalised on both sides, with weak links flagged rather than counted.
O que você recebe
A página que o Shopify 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 E-commerce e varejo — não de uma conta do Shopify.
Atribuída a um canal$196,00070% de $280,000
Vendas com correspondência192 de 264só alta confiança
Ticket médio$1,060por venda paga
| Canal | Parcela | Vendas | Receita |
|---|---|---|---|
| Google Ads | 84 | $98,000 | |
| Meta Ads | 61 | $53,200 | |
| E‑mail marketing | 47 | $44,800 | |
| Direto / Desconhecido | 72 | $84,000 |
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 order e o anúncio ficam na mesma linha.
This page is about the orders with no click, and only those
A straightforward online purchase is one of the best-measured events in commerce. The click, the session and the checkout are all in one place, the ad platform sees the conversion, and nothing here improves on that.
What is not measured is everything else Shopify now runs: a point-of-sale order in a shop, a phone order taken by a person, a draft order sent as a quote and paid days later. The customer researched online — that is where they found you — and then bought somewhere the pixel does not reach.
For merchants with a physical presence or a considered product, that is not a rounding error. It is frequently the larger half of the revenue and the half that decides whether the advertising pays.
The higher the price, the less likely the click and the purchase are the same event
Under fifty, people buy on the spot. Over a few thousand — furniture, equipment, jewellery, bikes, appliances — they research online, then come in to see it, then buy.
The result is a systematic bias in every report the merchant reads: the cheap impulse categories look efficient because their whole journey is online and measurable, and the expensive considered categories look like they do not work.
Budget follows the measurement rather than the money, and it does so quietly for years. Matching offline orders back to the enquiries and calls that preceded them is the correction, and it usually moves spend toward the categories that were carrying the business all along.
Point of sale captures a contact detail unevenly, and that shapes the answer
An online order cannot exist without an email. A shop order can, and often does — the transaction completes with a card and nothing else unless somebody asks.
That gradient decides your matched share. Merchants who capture an email at the till for the receipt match well; merchants who do not will see a large Direct / Unknown and should read it as a property of their till process rather than as a finding about their marketing.
It is also the cheapest thing on this page to fix. Asking for an email at the counter changes what can be measured more than any change to the advertising would.
Returning customers are the point of retail and the trap of attribution
Retail lives on repeat purchase, and a customer produced by a campaign two years ago may have bought fifteen times since. Crediting all of it to that campaign makes it look extraordinary; crediting none of it understates a channel producing genuinely loyal customers.
Neither answer is right for every merchant, so the report does not choose. First orders and subsequent orders are reported separately, and the decision about which to spend against stays visible and yours.
Perguntas justas
“O Shopify já faz isso.” Não exatamente.
Eles dizem
“We are online only.”
Nós dizemos
Then you probably do not need this. If you take any phone orders or send draft orders as quotes, those are the ones worth reading.
Eles dizem
“Our till orders have no email.”
Nós dizemos
Then the matched share will be low and the report will say so. Capturing an email at the counter is usually the highest-return change a shop can make here.
No. There is no app to install and no scope to grant. It reads a file you exported, which is also why it cannot touch your storefront.
Orders with a customer contact detail, the total, the date and the sales channel or location where possible.
You can, but they are already attributed properly by your ad platforms. The value here is point-of-sale, phone and draft orders.
On the sales channel or location column, which is why it is the most important optional field on this page.
Yes, and it is the main reason to do this. A POS order with a customer email or phone matches like any other row.
They match too, and the paid date is usually closer to the decision than the created date.
Include them and they reduce a channel's revenue, which is the honest figure.
They are reported separately from first orders, so you decide whether two years of repeat purchase should credit the advert that started it.
Direct / Unknown. They are never matched on a name, because names are not unique.
Yes, where the export carries one. A multi-site retailer's blended figure is usually true of none of its shops.
A contact detail, an amount and a date, plus a channel if you include one. No line items, no addresses, no payment details, no browsing history. Encrypted in transit and at rest and deleted with the import.
Revenue by channel for the orders that had no click of their own, the share matched, and everything unmatched kept visible.
Por setor
Setores que usam o Shopify.
Como fica o relatório depois que a exportação entra, escrito para cada um.
- E-commerce e varejoOs pedidos que não fecham no carrinho.
- Móveis e decoraçãoO sofá é pesquisado online e comprado na loja.
- JoalheriasNinguém compra o anel de noivado num navegador.
- Varejo de eletrodomésticos e eletrônicosQuanto maior o eletrodoméstico, maior a chance de alguém ligar.
- Colchões e artigos para dormirVocê investe mais que todo mundo. E não enxerga o que funcionou.
- Noivas e trajes de festaO agendamento é a venda.
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 Square Businesses that take payment in person 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 Qualquer um dos arquivos HubSpot Equipes de vendas e marketing no HubSpot CRM Qualquer um dos arquivos O que exportar
Todos os 68 sistemas 
Shopify 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 Shopify, sem chave de API e sem precisar ter rastreado nada até agora. O ano passado funciona tão bem quanto este mês.