How to check whether your attribution is accurate in 30 minutes, with a spreadsheet and no new tools.
The test: pick 20 recent orders and try to trace each one back to where the buyer came from.
Six steps below. (1/9)
@enunomaduro@jetbrains Looking forward to the write-up. Curious how you'll separate what drove it: the format itself, the timing, or who shared it first. That split is what makes takeaways repeatable for other teams.
@agazdecki The useful version of this is being clear about which decisions are reversible. Those can be made fast by one person. The few that are hard to undo are where slowing down and getting input is worth it.
@aviralbhat This is where marketing and finance should share a number. A campaign can hit its CAC target and still strain cash if inventory and media invoices land before customer revenue does. Payback period in weeks travels better between teams than ROAS.
@arthuryuzbashev Failed paid ads on three platforms often says more about the offer or conversion path than the channels. Worth checking whether the same landing page and trial flow sat behind all three before writing the channels off for good.
@alexgroberman That low overlap is the practical point. Checking one assistant and calling it AI visibility is like checking one keyword and calling it SEO. A fixed prompt set run across all four on a schedule gives you a trend you can actually compare.
@alexgroberman Worth pairing whatever Search Console shows with your own analytics: visits from AI tools often arrive without a referrer and get lumped into direct. Annotating content changes helps you tell a real shift from a reporting change.
@AdtechGod Agree that creative carries it. The measurement debate gets louder when the creative is weak, because people go looking for proof the channel works. Judging CTV on reach and lift studies rather than last-click ROAS is a more honest bar.
@Digi_Ingenuity That separation is the useful part. A dated note for each tracking change also makes it easy to look back months later and see why a series stepped up or down. Thanks for sharing how you run it.
@sengineland Measurement gets harder as discovery moves into conversational answers: fewer site clicks, more calls and direction requests. Tracking those Business Profile actions alongside sessions gives a fuller picture than organic traffic alone.
@klaviyo For brands on multiple Shopify Markets, reporting by market matters as much: refunds, currency conversion and local taxes can make per-country revenue in tools differ from what actually settles. Worth reconciling by market, not just in total.
@GoogleAds@adsliaison Before using it, worth checking which channels earn priority on incremental results, not just platform-attributed conversions. A channel that mostly captures existing demand can look efficient in-platform while adding little new revenue.
@neilpatel The measurement side is interesting too. If an agent completes the purchase, there's no click path, no UTM, no pixel session. Brands will need order-level signals beyond platform attribution to see which channel created the demand.
@lorenzo_pravata Post-purchase surveys help here too. The exact words buyers use for why they bought make good hook material, and the answers show which channels people remember, which often differs from what last-click attribution credits.
@neilpatel Word of mouth is also the one that shows up worst in dashboards. It usually lands as direct or branded search. A simple 'how did you hear about us' question at checkout is often the only place it becomes visible.
@ecomchasedimond One more for the list: consistent UTMs on every flow and campaign link from day one. Otherwise a lot of email revenue lands under direct in GA4, and it gets hard to tell which flows drive orders vs. just catch the last click.
@profitierr Worth tracking first-order ROAS and 60/90-day cohort revenue separately. A 0.9 on day one can work with subscriptions, but only if retention holds on the cohorts that spend actually bought, not just the blended subscriber base.
@thedennis The one I'd add: check that same day in Shopify after refunds and chargebacks settle, a week or two later. Platform ROAS counts the order the moment it fires. The bank account counts what's left after returns. Those rarely match on a 'record day'.
@Digi_Ingenuity Agreed, and the annotation habit is underrated. Even a one-line note on why a week's gap widened (a promo, a tracking change, a refund spike) makes the next comparison much easier to trust.
@thedennis Agree the ad is often the first brand touch. Worth judging those ads on more than 7-day ROAS too: branded search volume and direct traffic over the following weeks show whether people remembered the name, not just whether they clicked.
@sengineland Practical side: queries like that lean on review text and listing attributes. Asking happy customers to mention specifics (quiet, good for meetings, parking) in reviews, and keeping Business Profile attributes filled in, gives Maps something to match.