Re:Ask HN: Lessons learned from implementing user-facing ana...
by kevan on Thursday September 28, 2023 @11:52AM
(#37691385)
And make sure your project plan includes milestones for explicitly aligning all stakeholders on definitions otherwise you'll have a big hot potato game the first time the outputs show something unfavorable.
Re:Ask HN: Lessons learned from implementing user-facing ana...
by datadrivenangel on Saturday September 30, 2023 @01:11PM
(#37717474)
Or hire a data analyst to spend 3 months standardizing on just 3 definitions of retention!
For instance, if a marketing head wants to plot CAC (cost of acquiring customers) over time, saying CAC is number of customers divided by marketing spend is manager-speak. Spends are budgeted higher early in the month and adjusted with actuals. Customers ask for refunds and cancel accounts. Some campaigns have volume incentives which are known later... and so on. The solution is to write well commented SQL which laymen can audit and improve.