Ask
197
@sql_window_fn ·

analytics says 1,900 visitors, my users table says 61, stripe says 4 - which of these is lying

Last 30 days. The analytics number and my server logs disagree by a wide margin, and the analytics referrer breakdown says 40% direct which I do not believe either.

I am trying to work out where to spend the next month and I cannot get three systems to agree on what happened in the last one. Where do these numbers normally diverge?

8 answers Share
Report

Answering anonymously — a moderator will review it first.

  • @seedstart_sim · last wk. · 4 replies

    None of them are lying, they are measuring three different things and one of them is being actively blocked.

    Client-side analytics get blocked at rates that will surprise you, and it scales with how technical your audience is - general consumer traffic loses a modest slice, a developer audience can lose something close to half. Browsers with tracking protection on by default account for a chunk of it before anyone installs an extension.

    The only number you can trust is the one your own server writes down. At signup, insert the referrer, the utm parameters, the landing path and the timestamp onto the user row. Then reconcile against payments by customer id. Three systems become one system with two decorations.

    168
    Share
    Reply

    Answering anonymously — a moderator will review it first.

    Report
    • @nightbus_nina · last wk.

      The reconcile key matters more than the instrumentation. I joined users to payments on email address for months and quietly lost every customer who signed up with a personal address and paid with a work one. Put the payment provider's customer id on the user row the moment it exists and never join on email again.

      57
      Share
      Reply

      Answering anonymously — a moderator will review it first.

      Report
    • @margot_teller · 5mo ago

      One-time, for as long as I own the place, does change how I read the number.

      29
      Share
      Reply

      Answering anonymously — a moderator will review it first.

      Report
    • @emergency_fund_ed · 5mo ago

      It also generally covers the cost of defending your title, which in a real dispute is the part that actually hurts financially.

      19
      Share
      Reply

      Answering anonymously — a moderator will review it first.

      Report
  • @braise_or_bust · 5d ago

    Take the numbers at face value for a second: 1,900 to 61 is 3.2% visitor-to-signup, and 61 to 4 is 6.5% signup-to-paid. Neither of those is broken for cold traffic. Depending on the source they are unremarkable.

    The bigger question is how many of the 1,900 were bots. Crawlers, uptime checkers, link previewers and scrapers are a genuinely large fraction of raw traffic on small sites, and most edge dashboards count them by default. Strip known bots before you draw any conclusion about your conversion rate, or you will 'improve' a denominator that was never human.

    112
    Share
    Reply

    Answering anonymously — a moderator will review it first.

    Report
  • @inbox_zero_ivo · last wk. · 2 replies

    At four customers, funnel analysis is astrology. You have four rows. Open them, find out who those people are, email all four, and ask what they were doing the day they signed up. You will learn more in one afternoon than a year of reconciling dashboards, and the sample size is the same either way.

    66
    Share
    Reply

    Answering anonymously — a moderator will review it first.

    Report
    • @truing_stand_tia · last wk.

      Agree on where to spend today, disagree on what to skip. Instrumenting now is an hour; instrumenting retroactively is impossible because the data simply does not exist. Log the raw events cheaply, go talk to the four people, and be glad in six months that past-you wrote the rows.

      24
      Share
      Reply

      Answering anonymously — a moderator will review it first.

      Report
  • @starschema_sy · 5mo ago · 2 replies

    The upsell criticism isn't baseless — claim rates on title policies are low relative to premium volume, and that's a fair thing to notice out loud. I bought mine anyway, but I shopped the rate rather than accepting the closing agent's default. Ask whether simultaneous-issue pricing applies when both policies are written together.

    54
    Share
    Reply

    Answering anonymously — a moderator will review it first.

    Report
    • @coptic_cleo · 5mo ago

      Simultaneous issue is the actual tip in this thread. It can cut the owner's premium substantially and nobody offers it unprompted.

      26
      Share
      Reply

      Answering anonymously — a moderator will review it first.

      Report
  • @rebalance_rita · 5mo ago

    A 1940s house that has turned over twice recently is exactly the profile where I'd buy it. Older chains have more places to go wrong, and quick resales sometimes have paperwork done in a hurry by people who won't be around later. I've never claimed on mine and I'd buy it again on the next house.

    76
    Share
    Reply

    Answering anonymously — a moderator will review it first.

    Report
  • @onebag_ozzy · 7d ago

    Two practical fixes for the direct-traffic mystery. First, serving your analytics from your own domain rather than a third party host recovers some of the blocked portion - not all of it, list maintainers do notice, but some. Second, check your redirects: any hop that drops the query string silently destroys your utm parameters, and a bare domain to www redirect is the classic culprit. Traffic that arrives tagged and lands untagged shows up as 'direct' and you will never work out why.

    51
    Share
    Reply

    Answering anonymously — a moderator will review it first.

    Report
  • @maren_dowd · 5mo ago

    Ask what amount the policy is written for. Some owner's policies are written at purchase price with no inflation provision and others have an escalation feature. Twenty years from now that difference is effectively the whole policy.

    37
    Share
    Reply

    Answering anonymously — a moderator will review it first.

    Report
  • @dawless_dev · 5d ago

    Found a fun one in mine while chasing exactly this: the signup conversion event fired on form submit rather than on successful account creation, so every failed signup - taken email, weak password, validation error - counted as a conversion. My analytics conversion count was about 20% higher than my users table for a completely mundane reason. Worth checking where your event actually fires before you go looking for anything clever.

    20
    Share
    Reply

    Answering anonymously — a moderator will review it first.

    Report
  • @bootstrap_nadia · 5mo ago

    Pricing and the rules around it vary a great deal by state and country. Check with a real estate attorney where you're actually buying rather than taking a forum's word for what's negotiable.

    14
    Share
    Reply

    Answering anonymously — a moderator will review it first.

    Report