{"id":7,"date":"2026-08-12T12:55:51","date_gmt":"2026-08-12T12:55:51","guid":{"rendered":"http:\/\/corpolearn.wp\/productdelivery\/\/product-analytics-mastering-funnel-analysis-cohort-retention-north-star-metrics\/"},"modified":"2026-08-12T12:55:51","modified_gmt":"2026-08-12T12:55:51","slug":"product-analytics-mastering-funnel-analysis-cohort-retention-north-star-metrics","status":"publish","type":"post","link":"https:\/\/corpolearn.com\/productdelivery\/product-analytics-mastering-funnel-analysis-cohort-retention-north-star-metrics\/","title":{"rendered":"Product Analytics: Mastering Funnel Analysis, Cohort Retention &amp; North Star Metrics"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Data-informed decision making relies on tracking user funnels from acquisition to activation, retention, revenue, and referral (AARRR Pirate Metrics).<\/p>\n<h2 class=\"wp-block-heading\">SQL Cohort Retention Query<\/h2>\n<pre>SELECT \n    DATE_TRUNC('month', signup_date) AS cohort_month,\n    COUNT(DISTINCT user_id) AS initial_users,\n    COUNT(DISTINCT CASE WHEN active_days &gt; 30 THEN user_id END) AS retained_30d\nFROM user_activity_log\nGROUP BY 1 ORDER BY 1 DESC;<\/pre>","protected":false},"excerpt":{"rendered":"<p>Data-informed decision making relies on tracking user funnels from acquisition to activation, retention, revenue, and referral (AARRR Pirate Metrics). SQL Cohort Retention Query SELECT DATE_TRUNC(&#8216;month&#8217;, signup_date) AS cohort_month, COUNT(DISTINCT user_id) AS initial_users, COUNT(DISTINCT CASE WHEN active_days &gt; 30 THEN user_id END) AS retained_30d FROM user_activity_log GROUP BY 1 ORDER BY 1 DESC;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_cl_workflow_state":"","_cl_content_brief":"","_cl_target_topic":"","footnotes":""},"categories":[13],"tags":[],"class_list":["post-7","post","type-post","status-publish","format-standard","hentry","category-product-analytics"],"_links":{"self":[{"href":"https:\/\/corpolearn.com\/productdelivery\/wp-json\/wp\/v2\/posts\/7","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/corpolearn.com\/productdelivery\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/corpolearn.com\/productdelivery\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/corpolearn.com\/productdelivery\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/corpolearn.com\/productdelivery\/wp-json\/wp\/v2\/comments?post=7"}],"version-history":[{"count":0,"href":"https:\/\/corpolearn.com\/productdelivery\/wp-json\/wp\/v2\/posts\/7\/revisions"}],"wp:attachment":[{"href":"https:\/\/corpolearn.com\/productdelivery\/wp-json\/wp\/v2\/media?parent=7"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/corpolearn.com\/productdelivery\/wp-json\/wp\/v2\/categories?post=7"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/corpolearn.com\/productdelivery\/wp-json\/wp\/v2\/tags?post=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}