4 ms·

Tell HN: A data-driven look at a failed HN account

• pwg 1y ago
  You've discovered why this sentence is in the HN guidelines: Please don't use HN primarily for promotion. It's ok to post your own stuff part of the time, but the primary use of the site should be for curiosity.
• attogram 1y ago
  And more data: METRIC OLD ACCOUNT NEW ACCOUNT --- --- --- Submission Velocity 4/3 = 1.333/day 1/6 = 0.167/day Comment Velocity 3/2942 = 0.00102/day 19/6 = 3.167/day Karma Efficiency 3/11 = 27.27% 30/20 = 150.00% Submission Mortality 7/8 = 87.50% 0/1 = 0.00% Comment Mortality 0/3 = 0.00% 0/19 = 0.00% Active Lifespan 13 days 6 days Total Lifespan 2942 days 6 days Karma/Submission 3/8 = 0.375 30/1 = 30.000 Karma/Comment 3/3 = 1.000 30/19 = 1.579 Engagement Intensity 11/13 = 0.846/day 30/6 = 5.000/day Karma Gain Rate 3/2942 = 0.00102/day 29/6 = 4.833/day Comment/Submission Ratio 3/8 = 0.375 19/1 = 19.000 Active Days Ratio 13/2942 = 0.00442 6/6 = 1.00000 Karma Sustainability 3/11 = 27.27% 30/19 = 157.89% Content Survival Rate 4/19 = 21.05% 20/20 = 100.00% Upvoted Comments Ratio 3/3 = 100.00% 19/19 = 100.00% Karma Distribution (low) (medium) Reply-to-Comment Ratio 0/3 = 0.00% 2/19 = 10.53% Peak Engagement N/A 14:00-16:00 UTC Flag-to-Karma Correlation -0.92 (strong negative) 0.00 (no correlation) Topic Consistency 0.33 (low) 0.82 (high) User Retention 0.44% 100.00% Cross-Thread Engagement 1.00 (low) 3.40 (high) FORMULAS: Submission Velocity = total_submissions / account_age_days Comment Velocity = total_comments / account_age_days Karma Efficiency = (final_karma / sum_raw_points) x 100 Submission Mortality = (dead_submissions / total_submissions) x 100 Comment Mortality = (dead_comments / total_comments) x 100 Active Lifespan = last_activity_day - first_activity_day Total Lifespan = last_check_day - creation_day Karma/Submission = final_karma / total_submissions Karma/Comment = final_karma / total_comments Engagement Intensity = total_karma_gained / active_days Karma Gain Rate = (final_karma - start_karma) / total_days Comment/Submission Ratio = total_comments / total_submissions Active Days Ratio = active_days / total_days Karma Sustainability = final_karma / total_raw_points x 100 Content Survival Rate = living_content / total_content x 100 Upvoted Comments Ratio = upvoted_comments / total_comments x 100 Karma Distribution = variance(karma_per_comment) Reply-to-Comment Ratio = replied_comments / total_comments x 100 Peak Engagement = hours_with_most_activity Flag-to-Karma Correlation = correlation(flags -karma_change) Topic Consistency = topic_similarity_score across comments User Retention = active_days / total_days x 100 Cross-Thread Engagement = avg_comments_per_thread Fun with data!