Lurkit Dashboard

📰 News Feed

Last 30 days · Internal highlights & wins

Loading your news feed...

🏥 Customer Health Scores

Include Churned

Total Customers

Healthy

At Risk

Critical

Showing: - clients MRR: -

Company	Lurkit ID	Status	Younium	MRR	Sub End	Term	Renewal	Owner	CS Mgr	Last Contact	Total	Published	30d	60d	90d	Accepted	Accept %	Claim %
Click "Load Data" to get started

🎯 Opportunity Finder

Surfaces actionable opportunities: new quest activity, active customers not contacted, increasing engagement, and more.

Total Opportunities

🆕 New Quests

📵 Active, Not Contacted

📈 Increasing Activity

💎 High MRR, Low Usage

🔄 Renewal Soon

🎨 Creator Growth

⚡ Low Acceptance

📭 No Submissions

🔑 Low Key Claims

Showing: - opportunities MRR: -

Company	Opportunity	Priority	MRR	Owner	Signal	Last Contact	Suggested Action
Click "Load Opportunities" to get started

🚀 Onboarding Tracker

Only shows companies whose subscription start date is within the selected period. Use the filter to adjust the window (e.g. "Last 180 days" = subscriptions that started less than 180 days ago).

Total

✅ On Track

All indicators green — healthy onboarding

⚠️ Needs Attention

1 critical or 2+ warnings

🟠 At Risk

2-3 critical issues detected

🔴 Critical

4+ critical issues — immediate action needed

📊 Indicator Overview

Showing: - clients MRR: -

🚦 Traffic Light Guide

Green — Milestone achieved / healthy

Yellow — Partial progress / warning

Red — Not started / critical gap

Gray — No data available

Health	Company	Lurkit ID	Days	Owner	MRR	Keys Claimed	Any Login	User Count	Login Recency	Younium MRR	Has Campaign	Has Published	Creator Eng.	Consistency
Click "Load Onboarding Data" to get started

📈 Company Activity

Total Companies

Avg Score

Total MRR

Active Subscriptions

Company ↕	Total ↕	Published ↕	Camp 30d ↕	Camp 60d ↕	Camp 90d ↕	Camp 365d ↕	Camp All ↕	Acc 30d ↕	Acc 60d ↕	Acc 90d ↕	Acc 365d ↕	Acc All ↕	Accept % ↕	Claim % ↕	Comp % ↕	Score ↕	MRR ↕	Sub Status ↕
Click "Load Data" to get started

⚠️ Churn Risk Analysis

🔴 High Risk

🟠 Medium Risk

🟢 Low Risk

Total Active

Risk	Company	MRR	Last Login	Days Inactive	Campaigns 30d	Campaigns 90d	Trend	Risk Factors
Click "Load Cached" to get started

📛 Churned Customers

Total Churned

Churned

Expired

Canceled

Company ↕	Lurkit ID	Status ↕	Churn Reason ↕	MRR ↕	Tier	Sub Start ↕	Sub End ↕	Lifetime ↕	Owner ↕
Click "Load Data" to get started

📉 Younium Churn 2025

Customer start from

Churned Subscriptions (orders)

Unique Accounts (with churn)

Total MRR Lost (SEK)

Definition note: this dashboard counts churn at subscription/order level. Product tables count product-lines within churned subscriptions.

⏳ Customer Lifetime Bins

Count = churned subscriptions (orders), grouped by subscription lifetime in months. Click a bin row for drill-down.

Lifetime Bin	Churned subscriptions	MRR Lost (SEK)	Avg MRR / churn (SEK)
Click "Load Data" to get started

📦 Product Churn (Top by MRR)

Count = number of churned subscriptions where the product appears.

Product	Subscriptions with product	MRR Lost (SEK)
No data loaded

🧩 Lifetime Bin × Product (Full Breakdown)

Här repeteras lifetime bins per produkt (t.ex. 3-6 months + Creator Ops, 6-12 months + Creator Ops). Klicka en rad för detaljlista.

Count mode Count = churned subscriptions where the product appears in the bin.

Lifetime Bin	Product	Churned subscriptions	MRR Lost (SEK)	Avg MRR / churn (SEK)	Intensity
No data loaded

♻️ Inactive → Reactivated (2024)

Inactive Accounts (2024)

Resurrected Accounts

Resurrection Rate

Total Reactivations

Account	Account #	Churn events (2024)	Reactivations	Latest churn (2024)	First return	Fluctuation index	Currently active	Younium Account
No data loaded

📆 Monthly Fluctuation (2024)

Month	Inactive accounts	Churn events	Resurrected accounts	Reactivations	Resurrection rate	Net reactivations	Fluctuation index
No data loaded

🧠 Churn Company Outcome Scorecards (Perplexity)

Definition: one row = one account. "Churned subs" = number of churned subscriptions/orders for that account in 2025.

Company status Layoff signal Game performance

Showing 0 / 0 companies

Select	Account	Account #	Churned subs (orders)	Subscription start	MRR lost (SEK)	Company status	Layoff signal	Game performance (Steam + CCU)	Funding signal	Outcome score	Confidence	Parsed JSON	Highlights	Risks	Reasoning	Sources	Analyze
Click "Load Companies" to select a batch.

Account	Account #	Churned subs	MRR lost (SEK)	Company status	Layoff signal	Game performance (Steam + CCU)	Outcome score	Confidence	Insights	Updated	Sources	Younium Account
Load companies, then analyze selected to populate scorecards.

Smart bins: Outcome score

Here, "Companies" = account rows in scorecard output (not subscriptions).

Bin	Companies	Avg score	Total MRR lost (SEK)	Avg MRR lost/company (SEK)
Load scorecards to see bins

Smart bins: Signal patterns

Pattern	Companies	Avg score	Total MRR lost (SEK)
Load scorecards to see groupings

Perplexity Results - Extended View

Account	Account #	Parsed JSON	Full Perplexity Response	Sources	Updated
Load scorecards to see full Perplexity responses

🏢 Churned Customers (2025)

Account	Account #	Subscription	Churn Date	Lifetime (months)	MRR Lost (SEK)	Younium Order	Younium Account
No data loaded

💰 Quest Spending & Commercial KPIs

📊 Commercial KPI Overview

Budget Utilization

Avg Spend / Quest

Quest Completion Rate

Avg Bid Value

Active Quest Companies

Zero-Spend Quests

Revenue Concentration (Top 5)

Revenue Concentration (Top 10)

🔄 Quest Pipeline

📝 Draft

⏳ Awaiting Verification

🟢 Published

✅ Closed

💸 Quest Spending by Period

30 Days

60 Days

90 Days

All Time

📈 Spending Velocity (Last 12 Months)

Month	Spending	Budget	Utilization %	Quests	Companies	Accepted Bids	Trend
Click "Load Data" to get started

🏆 Top Spenders

#	Company	Total Quests	Budget	30d Spending	90d Spending	Total Spending	Utilization %
Click "Load Data" to get started

🚨 Biggest Under-Spenders (Sorted by Unspent Budget)

Companies with the most unspent budget — commercial upselling opportunity. Sorted by largest unspent budget first.

#	Company	Quests	Total Budget	Total Spending	Unspent Budget	Utilization %	Zero-Spend Quests	Bids	Runs / Completed	Last Quest
Click "Load Data" to get started

💳 Quest Payouts

30 Days

60 Days

90 Days

All Time

Top Payers

#	Company	Payout Count	30d Payouts	90d Payouts	Total Payouts	Avg Payout
Click "Load Data" to get started

📅 MRR Expiration Analysis

Total Active MRR

Auto-Renewed MRR

Non Auto-Renewed

3-Month Risk

MRR by Expiration Bucket

Cumulative MRR at Risk

Contracts

#	Company ↕	MRR (USD) ↕	Bucket ↕	End Date ↕	Time Left ↕	Auto-Renew ↕
Click "Load Data" to get started

📋 Scorecard

Total Companies

Total Campaigns

Verified Companies

Verification Rate

Active Subscriptions

Company Types

Subscription Status

Campaign Status

Campaign Types

🔑 Key Statistics

Total Keys

Claimed Keys

Available Keys

Claim Rate

⏱️ Campaign Duration

Avg Duration

Min Duration

Max Duration

Content Submissions

Participation

📊 Engagement Metrics

Total Accepted

Total Declined

Total Waitlist

Total Submissions

Total Invited

Avg Invited / Campaign

Campaigns w/ Invitations

✅ Acceptance Rate

Overall Rate

Total Accepted

Total Invited

Total Declined

Acceptance Rate by Type

Acceptance Rate by Period

⏳ Pending / Unanswered

Total Pending

Pending %

Campaigns w/ Pending

Pending by Campaign Type

Pending by Time Period

Creator Types by Followers

Creator Types by Platform

Campaigns by Month

Companies by Month

📅 Time Period Breakdown

Generated: -

🔍 Data Validation

✅ Linked

⚠️ Partial Link

❌ Missing in Younium

❌ Missing in HubSpot

💰 MRR Mismatches

Link Status	HubSpot (CRM)					Younium (Billing)						Issues
Link Status	Name	HubSpot ID	Lurkit ID	MRR	Status	Name	Younium ID	Lurkit ID	MRR	Status	View	Issues
Loading account link data...

Lurkit ID	HubSpot Name	Younium Name	HubSpot MRR	Younium MRR	Difference	Issues
Click "Load Comparison" to start

Order #	Account	MRR	Tier	Lurkit ID	Start Date	End Date	View
Click "Load Missing Metadata" to start

Order #	Account	MRR	End Date	Days Overdue	Status	View
Click "Load Expired" to start

Order #	Account	Product	Start Date	End Date	Status	View
Click "Load Zero MRR" to start

💼 Customer Portfolio

📋 Executive Summary

🥇 Top 1 Customer

🏆 Top 5 Customers

📊 Top 10 Customers

📈 Top 20 Customers

Revenue by Customer Tier

How much of total MRR each tier accounts for

Revenue by MRR Bucket

Revenue distribution across spending segments

Revenue Concentration Curve (Lorenz)

Shows how evenly revenue is distributed. The further the curve bows from the diagonal, the more concentrated revenue is among fewer customers. Gini coefficient: -

💡

Loading insights...

Total Customers ℹ️

Total MRR ℹ️

ARPA ℹ️

Avg Contract ℹ️

months

📏 Contract Length Statistics

Based on the Younium "term" field (in months) from active subscriptions. If no term is set, falls back to the duration calculated from effectiveStartDate → effectiveEndDate. Only customers with term data are included (see "No Term Data" below).

Avg Term ℹ️

months

Median Term ℹ️

months

P10 Term ℹ️

months

P90 Term ℹ️

months

🎯 Portfolio Health KPIs

Customer Concentration (Top 10%) ℹ️

Short-Term Contract Risk ℹ️

ARPA ℹ️

No Term Data ℹ️

💰 MRR Distribution

Click any row to see the customers in that MRR bucket with links to Younium.

Bucket	Customers	Total MRR	% of MRR	ARPA ℹ️	Avg Term ℹ️	Renewal Term ℹ️	Contract Length ℹ️	Auto-Renew % ℹ️
Load portfolio data to see distribution

🏷️ Tier Distribution

Tier	Customers	Total MRR	% of Customers	Avg MRR
Load portfolio data to see tiers

📅 Contract Duration Analysis

Duration	Customers	% of Total	Total MRR
Load portfolio data to see durations

Drill Down

🏆 Top 20 Customers

#	Company	MRR	Tier	Contract	End Date	Auto Renew
Load portfolio data to see top customers

📊 CpHW Benchmark

Loading date range...

Cost per Hour Watched (CpHW) benchmarks from Quest activations. Shows P25 / Median / P75 across CCV, follower, and bid amount buckets. Toggle between Accepted Bids (paid, with CpHW) and Open Bids (remaining quest budget).

Total Records

Median CpHW

P25 (Low)

P75 (High)

Total Bid $

Avg Bid

CpHW by CCV Bucket

Bucket	Records	P25	Median	P75	Avg	Min	Max
Loading benchmark data...

📈 Weekly CpHW Trend (Median)

Quest Status	Count	Total Budget	Accepted	Open	% Open
Loading...

💳 Campaign Ledger

Campaign accounts with balances from HubSpot deals. Track deposits, spend, and remaining budget per customer.

Total Accounts

Total Deposited

Total Spent

Total Balance

📋 Campaign Accounts

Account #	Company	Status	Deposited	Spent	Balance	Credit Limit	Created
Loading campaign accounts...

⚡ System Highlights

Daily digest from Firebolt & MongoDB — trending games, biggest movers, platform breakdown, top streamers, and creator program activity.

Active Streamers

Games Streamed

Watch Hours

Peak Viewers

Loading system highlights...

🩺 Creator Program Health

Track creator program growth, content submissions, activation activity, and compare CCP member streaming vs non-members week-over-week.

Total Programs

Total Creators

New Joins (7d)

Submissions (30d)

Company	Owner	CSM	MRR	Games	Total	7d	14d	30d	60d	90d	Subs 7d	Subs 30d	Runs 30d	New Acts 90d	Latest	Stream	Case	Analys
Click "Refresh" to load data

📈 CCP Impact Dashboard

Batch-baserad effektanalys för Creator Program: före/efter streaming, andel creators som ökar och bolagsnivå-insikter från Postgres.

Batch ID

Items (total)

Avg hours (before -> after)

Creators with higher hours

Items with data

Both windows

Avg days (before -> after)

Avg frequency (before -> after)

Per Company

Company	Programs	Total items	With data	Both windows	Avg before h	Avg after h	Avg delta h	Increased h %
Click "Refresh" to load data

Top Programs by Hour Delta

Program ID	Company ID	Total items	With data	Both windows	Avg before h	Avg after h	Avg delta h	Increased h %
No data yet

🔑 Key Claims Health

Analyze key claim performance per campaign and game, with streaming activity over 7, 14, 30, 60, and 90-day windows.

Campaign Rows

Total Streamers

Total Streams

Hours Watched

Hours Streamed

Overall CCV

Campaign	Game	Streamers	Memberships	Streams 90d	Watched h (90d)	Streamed h (90d)	CCV (90d)	7d	14d	30d	60d	90d
Click "Refresh" to load data

🔬 Creator Program Deep Dive

Prove creator program value: compare content production, streaming activity, and retention between program members and non-members. Data sampled across 3 monthly windows from Firebolt + MongoDB.

Select a Creator Program to Analyze

Loading creator programs...

L U R K I T C O M M A N D C E N T E R

Welcome back, Hunter

Choose your operator:

Press Enter to begin the hunt

🎯 Revenue Hunt

📡 Streamed Hide Seen

0 / 0

Click Refresh IGDB to load recently released games, or games will load automatically from cache.

🎮 Game Wrapped

Spotify Wrapped-style overview for games. Search or browse games and view streaming stats, creator programs, benchmarks, and studio rollups.

✨ Create a Wrap

Build wraps as a clear journey: choose source, define scope, name report, queue job.

1. Source

2. Scope

3. Naming

4. Queue + Links

Step 1 · Choose source

Source type

Step 2 · Define scope

Public games to include

No games selected yet.

Step 3 · Name report

Report name

Scope alias

Requested by

Wrap type

CCP Full Year includes CCP modules and is only available for CCP source.

Step 4 · Queue and deliver

Processing can take up to 15–20 minutes. Jobs run in the background; use Refresh to check status.

Public share link (no login required)

No job queued yet.

Generated Wraps

No generated wraps yet.

Browse Existing Programs & Preloads

Use these tools for manual exploration. Create flow above is for production wrap generation.

Creator Programs

Loading programs...

Preloaded Views

Loading preloaded views...

💸 Usage Pricing Simulator

Initierar...

Kunddefinition laddas...

Datakälla

Population

Seed

Reach multiplier

Quest multiplier

CCP multiplier

Users multiplier

Insights period

seats_max

active_activations_max

support_level

analytics_depth_level

paid_throughput_cap period

paid_throughput_cap amount

Take rate base (SEK/activation)

invites_per_period organic %

invites_per_period quests %

invites_per_period CCP %

invites_per_period mission %

Top kunder i tabell

Take rate: Indie 25%, Growth 20%, Enterprise = contact sales. Insights begränsas till 30/60/90 dagar.

Komponent	Inkluderat	Överage / mån
Basavgift	–
Reach outs
Quests
CCP-kreatörer
Seats / användare

Kunder i urvalet

MRR (SEK)

ARPA (SEK/kund)

Tier 4 andel

Antal exporter

Scenario	MRR	ARPA	Bas	Reach	Quests	CCP	Seats	Support	Take rate
Laddar...

Rå usage-tabell

Kort översikt per metric. P50 visar en typisk kundnivå, och P95 visar nivån för topp 5% mest aktiva kunder.

Metric	Total	Snitt / kund	P50	P95
Laddar...

Smart binning (percentiler)

P25: 25% av användarna ligger här eller lägre · P50: median (typisk användare) · P70: var majoriteten ligger · P95: topp 5%-nivå (power users)

Metric	P50 (typisk)	P70 (majoritet)	P95 (topp 5%)	Tolkning
Laddar...

Per kund: parametrar + beräknad MRR

Visar kunder sorterat på högst beräknad MRR. Kolumnerna inkluderar dina requested parametrar per kund.

Company	Company tier (Mongo)	Company role (Mongo)	Role flags (pub/dev)	Segment	MRR	seats_max	active_activations_max	support_level	invites_per_period	analytics_depth_level	paid_throughput_cap
Laddar...

Company tier buckets (MongoDB)

Buckets baseras på `lurkit-company-mdb.company.Type` och visas med labels (indie, small_studio, studio, publisher, enterprise).

Tier bucket	Antal kunder	Andel kunder	Exporter totalt	Exporter / kund
Laddar...

Company role buckets (publisher / developer variants)

Buckets från `lurkit-game-mdb.game.ProviderData[].InvolvedCompanies[]` via `Publisher`/`Developer`: `publisher_only`, `developer_only`, `publisher_and_developer`, `neither_flagged`, `unknown`.

Role bucket	Antal kunder	Andel kunder	Exporter totalt	Exporter / kund
Laddar...

Company type buckets (full)

Full utskrift per companyType med antal kunder, andel, exporter och snitt-usage per kund.

Company type	Antal kunder	Andel kunder	Exporter totalt	Exporter / kund	Reach / kund	Quests / kund	CCP / kund	Seats / kund
Laddar...

Full bin-fördelning per metric

En rad per bin och metric med count och andel.

Company type	Metric	Bin	Min	Max	Count	Andel
Laddar...

Exporter per pricing segment

Segment bygger på simulatorns prismodell (indie / growth / enterprise).

Segment	Antal kunder	Exporter totalt	Exporter / kund	Andel exporter
Laddar...

Rå data snapshot (JSON)

Samlad dump för aktuell körning (parametrar + aggregeringar + rows preview).

Laddar...

📊 Lurkit Analys

Company performance med creator signups samt quest funnel för kreatörer: invited → accepted → completed.

Company performance

Creator signups (all time)

Creator signups (30d)

Creator signups (90d)

Månad	Creator signups
Ladda data för att visa trend

Quest creator funnel

1) Invited creators

2) Accepted creators

3) Completed creators

Funnel metric	Värde
Invite → Accept rate	-
Accept → Complete rate	-
Invite → Complete rate	-
Total invites	-
Accepted invites	-
Completed runs	-

Quest KPI månad för månad

Månad	Antal creators	Antal quests	Antal bids	Acceptance grad	Bekräftade quests	Dollar summa (bekräftade)	Growth vs föregående
Ladda data för quest KPI

Nuvarande månad: funnel

Creators

Quests

Bids

Bekräftade quests

Dollar summa

Funnel step	Värde	Andel av bids
Ladda data för funnel

Organiska key claims (månad för månad)

Claims denna månad

Claims förra månaden

Unika creators denna månad

Growth claims

Månad	Organiska claims	Unika creators	Growth claims vs föregående	Growth creators vs föregående
Ladda data för organiska claims

CCP aktivitet (månad för månad)

Månad	CCP signups	Nya missions	Completed missions	Unika creators (signups)	Growth vs föregående
Ladda data för CCP aktivitet

Dataverifiering	Status	Detalj
Verifierar datan...

Top earners per månad (Top 10)

Månad	Top 10 creators	Utbetalat till Top 10 (USD)	Antal payouts	Growth vs föregående
Ladda data för top earners

Younium MRR + churn + SaaS pipeline

Total MRR

Top 5 koncentration

Top 10 koncentration

Churn risk (nästa 3 månader)	MRR i risk	Andel av total MRR	Antal konton/orders
Laddar MRR churn-risk...

SaaS stage	Deals	Recurring Revenue Amount	Saknar värde
Laddar SaaS pipeline...

Firebolt: mest spelade spel denna månad

Lurkit creators (agg)

Lurkit watched hours (agg)

Övriga watched hours (agg)

Game	Total creators	Lurkit creators	Lurkit watched hours	Övriga watched hours	Lurkit WH share
Laddar Firebolt game split...

🧩 March Release Cohorts (Firebolt)

Månader: Top spel/månad:

Topp-spel per månad för spel med mars-release (månad=3), inklusive Lurkit vs icke-Lurkit watch hours och jämförelse mot föregående månad.

Senaste månad

Total WH (top cohort)

Lurkit WH (top cohort)

Icke-Lurkit WH (top cohort)

Lurkit share (WH)

Månad	#	Game	Total WH	Lurkit WH	Icke-Lurkit WH	Lurkit WH share	Delta Total WH vs prev	Delta Lurkit WH vs prev	Delta Lurkit share (pp)
Ladda data för release cohorts

📰 News Feed

🏥 Customer Health Scores

Company Campaigns

🎯 Opportunity Finder

🚀 Onboarding Tracker

📊 Indicator Overview

🚦 Traffic Light Guide

📈 Company Activity

⚠️ Churn Risk Analysis

📊 Churn Insights

📛 Churned Customers

📊 Churn Reason Breakdown

📉 Younium Churn 2025

⏳ Customer Lifetime Bins

📦 Product Churn (Top by MRR)

🧩 Lifetime Bin × Product (Full Breakdown)

♻️ Inactive → Reactivated (2024)

📆 Monthly Fluctuation (2024)

🧠 Churn Company Outcome Scorecards (Perplexity)

Smart bins: Outcome score

Smart bins: Signal patterns

Perplexity Results - Extended View

🏢 Churned Customers (2025)

💰 Quest Spending & Commercial KPIs

📊 Commercial KPI Overview

🔄 Quest Pipeline

💸 Quest Spending by Period

📈 Spending Velocity (Last 12 Months)

🏆 Top Spenders

🚨 Biggest Under-Spenders (Sorted by Unspent Budget)

💳 Quest Payouts

Top Payers

📅 MRR Expiration Analysis

MRR by Expiration Bucket

Cumulative MRR at Risk

Contracts

📋 Scorecard

Company Types

Subscription Status

Campaign Status

Campaign Types

🔑 Key Statistics

⏱️ Campaign Duration

Content Submissions

Participation

📊 Engagement Metrics

✅ Acceptance Rate

Acceptance Rate by Type

Acceptance Rate by Period

⏳ Pending / Unanswered

Pending by Campaign Type

Pending by Time Period

Creator Types by Followers

Creator Types by Platform

Campaigns by Month

Companies by Month

📅 Time Period Breakdown

🔍 Data Validation

💼 Customer Portfolio

📋 Executive Summary

Revenue by Customer Tier

Revenue by MRR Bucket

Revenue Concentration Curve (Lorenz)

📏 Contract Length Statistics

🎯 Portfolio Health KPIs

💰 MRR Distribution

🏷️ Tier Distribution

📅 Contract Duration Analysis

Drill Down

🏆 Top 20 Customers

📊 CpHW Benchmark

CpHW by CCV Bucket

📈 Weekly CpHW Trend (Median)

Quest Status Breakdown

📈 Monthly Open Budget Trend

💳 Campaign Ledger

📋 Campaign Accounts

Account Details

⚡ System Highlights

🩺 Creator Program Health