ga4 says 912 users, plausible says 1,430 visitors, my database says 274 signups - which number do i plan with
Same month, same site. The two analytics tools are 36% apart and I can't reconcile them. My own database is the only thing I'd swear to, but it only knows about people who signed up, so it can't give me a conversion rate.
If I use the higher number my conversion rate looks terrible. If I use the lower one it looks fine. I've been quietly picking whichever supports the decision I already wanted to make, which I've noticed about myself and am not proud of.
How do you actually run a funnel when the top of it is a guess?
@yaml_yuri · 6mo ago · 2 replies
Instrument your own funnel and stop caring about the top number. Write a row when someone hits the landing page from a cheap server-side event, a row when they start signup, a row when they finish, a row on first meaningful action. Now every step is measured by the same instrument, so the ratios between steps are trustworthy even when the absolute numbers are wrong.
Analytics tools are for 'where did they come from'. Your database is for 'what happened next'. Making one do both is where the frustration comes from.
Reply
Report
@parquet_pile · 6mo ago
A single events table with timestamp, anonymous id, name and a properties blob gets you most of a product analytics tool and joins straight to your users. Took an afternoon.
Reply
Report