File: 05-kpi-results.md
Lumenwire Audio: KPI results
The results the calculation script writes. The Calculation Pack reads every number from here.
{
"dq_gl_unmapped_rows": 0,
"dq_gl_dup_rows": 0,
"fy_rev": {
"2020": {
"total": 57740271.1,
"hw": 53140271.1,
"sw": 4000000.0,
"oth": 600000.0,
"cos": 18476886.75
},
"2021": {
"total": 66153367.589999996,
"hw": 59053367.59,
"sw": 6500000.0,
"oth": 599999.9999999999,
"cos": 20507543.95
},
"2022": {
"total": 80499806.82,
"hw": 70099806.82000001,
"sw": 9800000.0,
"oth": 600000.0,
"cos": 25437938.96
},
"2023": {
"total": 93755733.66,
"hw": 80155733.65999998,
"sw": 12999999.999999998,
"oth": 600000.0,
"cos": 30376857.71
},
"2024": {
"total": 122086358.34999998,
"hw": 105086358.35,
"sw": 16400000.000000002,
"oth": 600000.0,
"cos": 37480512.01
},
"2025": {
"total": 118400000.0,
"hw": 99199999.99999999,
"sw": 18600000.0,
"oth": 600000.0,
"cos": 34336000.0
},
"2026": {
"total": 80600000.0,
"hw": 54299999.99999999,
"sw": 25700000.0,
"oth": 600000.0,
"cos": 18538000.0
}
},
"recon_FY25_total": 118400000.0,
"recon_FY26_total": 80600000.0,
"recon_FY26_sw": 25700000.0,
"recon_FY26_sw_growth": 0.381720430107527,
"recon_gm_FY25": 0.71,
"recon_gm_FY26": 0.77,
"k1_series": [
{
"month": "2026-06",
"r12": 80600000.0,
"hw": 54300000.0,
"sw": 25700000.0,
"path": 80600000.0,
"gap": 0.0,
"gap_pct": 0.0
},
{
"month": "2026-07",
"r12": 79957905.42,
"hw": 54814492.190000005,
"sw": 24525379.91,
"path": 82033333.33333333,
"gap": -2075427.9133333266,
"gap_pct": -0.025299812027630986
},
{
"month": "2026-08",
"r12": 81007987.42999999,
"hw": 54994195.879999995,
"sw": 25403341.54,
"path": 83466666.66666667,
"gap": -2458679.2366666794,
"gap_pct": -0.029457019608626345
},
{
"month": "2026-09",
"r12": 80537990.16,
"hw": 54798103.120000005,
"sw": 25136026.01,
"path": 84900000.0,
"gap": -4362009.840000004,
"gap_pct": -0.0513782077738516
}
],
"k1": {
"current": 80537990.16,
"hw": 54798103.120000005,
"sw": 25136026.01,
"path": 84900000.0,
"gap": -4362009.840000004,
"gap_pct": -0.0513782077738516,
"months_remaining": 21,
"pace_needed_per_month": 1641048.0876190478,
"run_rate_3m": -20669.94666666786,
"path_pace_per_month": 1433333.3333333333,
"peak_r12": 122086358.35,
"peak_r12_month": "2024-06"
},
"quarterly_rev": {
"FY25-Q1": {
"hw": 23793892.28,
"sw": 4008164.61,
"oth": 147055.52000000002
},
"FY25-Q2": {
"hw": 25573960.86,
"sw": 4700587.31,
"oth": 145608.0
},
"FY25-Q3": {
"hw": 24084293.96,
"sw": 5981548.74,
"oth": 147791.13
},
"FY25-Q4": {
"hw": 25747852.9,
"sw": 3909699.34,
"oth": 159545.35
},
"FY26-Q1": {
"hw": 12901896.88,
"sw": 6413973.989999999,
"oth": 146138.96999999997
},
"FY26-Q2": {
"hw": 14473638.579999998,
"sw": 4177279.38,
"oth": 147220.81
},
"FY26-Q3": {
"hw": 12572801.02,
"sw": 10505003.99,
"oth": 148649.96
},
"FY26-Q4": {
"hw": 14351663.52,
"sw": 4603742.64,
"oth": 157990.26
},
"FY27-Q1": {
"hw": 13400000.0,
"sw": 5850000.0,
"oth": 150000.0
}
},
"plan_fy27_total": 92689999.99,
"path_at_jun27": 97800000.0,
"fy27_q1_actual": 19400000.0,
"fy27_q1_plan": 22381311.31,
"plan_vs_prior_year_ratio_min_max": [
1.1499999572904003,
1.150000077863064
],
"plan_sw_mar27": 9886566.78,
"dq_lic_vs_gl_diff_FY26": 12854.730000004172,
"dq_lic_vs_gl_diff_R12M": 33969.58999999985,
"big_licence": {
"id": "LIC03074",
"customer": "Corvane",
"oem": "OEM0079",
"value": 7400000.0,
"start": "2026-03-27",
"type": "perpetual",
"seats": 0
},
"k3": {
"cur": 25136026.01,
"prior": 21005809.38,
"growth": 0.19662258926963583,
"cur_ex": 17736026.01,
"growth_ex": -0.15566090841104252,
"fy26": 25700000.0,
"fy25": 18600000.0,
"fy24": 16400000.000000002,
"fy26_growth": 0.381720430107527,
"fy26_growth_ex": -0.016129032258064502,
"fy25_growth": 0.13414634146341453,
"big_share_of_fy26": 0.28793774319066145,
"big_share_of_r12": 0.294398167675989,
"months_remaining": 9,
"growth_series": {
"2026-06": 0.381720430107527,
"2026-07": 0.14882111276797327,
"2026-08": 0.17695551237287988,
"2026-09": 0.19662258926963583
},
"run_rate_pts_per_month": -6.169928027929705,
"pace_needed_pts_per_month": 0.037526785892935365,
"perp_cur": 21072509.909999996,
"perp_prior": 17194859.89,
"sub_cur": 4063516.1000000006,
"sub_prior": 3810949.4899999998,
"perp_cur_ex": 13672509.909999996,
"lic_count_cur": 617,
"lic_count_prior": 598,
"new_cust_median_value_cur": 7193.915,
"new_cust_median_value_prior": 7729.72,
"bridge": {
"prior": 21005809.38,
"big_licence": 7400000.0,
"perpetual_other": -3522349.8599999975,
"sub_annual": 229670.99000000022,
"sub_monthly": 48779.90000000002,
"current": 25136026.01
},
"bridge_sum_check": 25884.400000002235,
"renewal_due_n": 491,
"renewal_status_missing": 88,
"renewal_rate_value": 0.6935971310251886,
"renewal_rate_count": 0.7220843672456576,
"renewal_rate_count_prior": 0.8816425120772947,
"pending_in_due": 75,
"renewal_decided_n": 328,
"renewal_rate_decided": 0.8871951219512195,
"renewal_rate_decided_prior": 0.8816425120772947,
"renewal_decided_prior_n": 414,
"lic_vs_gl_r12m_diff": 33969.58999999985
},
"dq_lic_enddate_missing_subs": 0,
"dq_lic_oem_missing": 1750,
"dq_lic_total": 3096,
"k3_1": {
"total": 25169995.600000005,
"largest": 7400000.0,
"largest_share": 0.29400084599140724,
"top5": 10185951.25,
"top5_share": 0.40468625469286923,
"largest_share_ex": 0.04861392931352218,
"n": 617,
"top5_share_ex": 0.18388929933105894,
"largest_customer_is_oem": true,
"prior_largest_share": 0.039275525403000056,
"prior_top5_share": 0.1455953940288566,
"by_fy_largest_share": {
"2020": 0.049773932381785894,
"2021": 0.03545343407021289,
"2022": 0.03976703134198894,
"2023": 0.03408294885345897,
"2024": 0.06649509133897837,
"2025": 0.04494108559275412,
"2026": 0.28779379332650235
},
"second_largest": 863869.31
},
"dq_lic_zero_seats": 1,
"k3_2": {
"cur": 0.7650262808594528,
"prior": 0.7230250583705315,
"fy25": 0.71,
"fy26": 0.77,
"cur_rev": 80537990.16,
"cur_cos": 18924311.08,
"cur_ex_big": 0.7412519671568727,
"fy26_ex_big": 0.7467486338797814,
"hw_gm_cur": 0.6788346735898171,
"hw_gm_prior": 0.6682170387426157,
"sw_gm_cur": 0.9549999996200672,
"sw_share_cur": 0.3121014810533981,
"sw_share_prior": 0.19111323485378887,
"var5010_cur": -260095.68000000005,
"var5010_prior": 227562.96999999997,
"target_fy27_board": 76.0,
"r12_series": {
"2026-06": 0.77,
"2026-07": 0.7656008997290213,
"2026-08": 0.7663878179129824,
"2026-09": 0.7650262808594528
},
"run_rate_pts_per_month": -0.16579063801824095,
"pace_needed_pts_per_month_v11": -0.055847565105030895
},
"dq_inv_oem_missing": 3161,
"dq_inv_rows": 392709,
"dq_inv_order_missing": 2200,
"dq_inv_order_missing_hw": 1331,
"dq_inv_oem_missing_families": {
"software_subscription": 3161
},
"dq_inv_fx_missing_nonaud": 34737,
"dq_inv_fx_missing_nonaud_last24m": 0,
"recon_invoice_vs_gl": {
"2020": {
"hw_diff": 0.0,
"sw_diff": 0.0,
"oth_diff": 0.0
},
"2021": {
"hw_diff": -7.450580596923828e-09,
"sw_diff": 0.0,
"oth_diff": 1.1641532182693481e-10
},
"2022": {
"hw_diff": -1.4901161193847656e-08,
"sw_diff": 0.0,
"oth_diff": 0.0
},
"2023": {
"hw_diff": 1.4901161193847656e-08,
"sw_diff": 1.862645149230957e-09,
"oth_diff": 0.0
},
"2024": {
"hw_diff": 0.0,
"sw_diff": -1.862645149230957e-09,
"oth_diff": 0.0
},
"2025": {
"hw_diff": 0.0,
"sw_diff": 0.0,
"oth_diff": 0.0
},
"2026": {
"hw_diff": 7.450580596923828e-09,
"sw_diff": 0.0,
"oth_diff": 0.0
}
},
"recon_max_abs_diff": 1.4901161193847656e-08,
"bridge_fy25_fy26": {
"fy25": 118400000.0,
"hw_volume": -49788168.25161144,
"hw_price_mix": 388168.21161143546,
"rebates": 4500000.04,
"sw_big_licence": 7400000.0,
"sw_other": -300000.0,
"other": 0.0,
"fy26": 80600000.0,
"check_unexplained": 0.0,
"hw_units_fy25": 4883606,
"hw_units_fy26": 2590114,
"hw_units_change_pct": -0.4696308424553496,
"hw_avg_price_change_pct": 0.00925460812897283
},
"sku_price_change_pct": {
"LW-C100": 0.00381001064623665,
"LW-C200": 0.0071703893703118915,
"LW-K128": 0.014081581993650616,
"LW-K64": 0.005258433131902329,
"LW-M310": 0.0069652399076316485,
"LW-M320": 0.005205537063714516,
"LW-M410": 0.007013960454937962
},
"fx_effect_fy26_hw": 606682.5837348849,
"fx_rates": {
"EUR_2025": 1.6800000000000004,
"EUR_2026": 1.7399999999999995,
"USD_2025": 1.5300000000000002,
"USD_2026": 1.54
},
"oem_breadth": {
"oems_buying_fy25": 409,
"oems_buying_fy26": 408,
"lost_oems": 1,
"oems_down": 409,
"oems_total": 409,
"median_oem_change_pct": -0.5198101271228002,
"top10_share_fy25": 0.24598905042483946,
"top10_share_fy26": 0.25696072636203865,
"top1_oem": "OEM0079",
"top1_fy25": 5422466.05,
"top1_fy26": 2524728.88
},
"by_tier": {
"A": -0.46046072473976196,
"B": -0.4556208420070257,
"C": -0.4934908347668122
},
"by_region": {
"AMER": -0.5285724066566841,
"APAC": -0.4824335395463847,
"EMEA": -0.5163412739000919,
"GCHINA": -0.3479793980322986
},
"by_sku_units": {
"LW-C100": -0.47101352211710346,
"LW-C200": -0.4760671547039018,
"LW-K128": -0.47655074337427283,
"LW-K64": -0.47511166591897636,
"LW-M310": -0.48469941677226025,
"LW-M320": -0.4361668272719702,
"LW-M410": -0.4698514068280063
},
"quarter_end": {
"qe25": 49252733.68,
"ot25": 57047266.35999999,
"qe26": 21260855.41,
"ot26": 35639144.59,
"qe_share25": 0.4633370993552824,
"qe_share26": 0.3736529949033392,
"qe_avg_month25": 12313183.42,
"ot_avg_month25": 7130908.294999999,
"qe_avg_month26": 5315213.8525,
"ot_avg_month26": 4454893.07375,
"rebate_rate25": 0.0667920981874724,
"rebate_rate26": 0.04569420035149385,
"rebate_only_in_quarter_end_months": true
},
"dq_orders_leadtime_missing": 11542,
"dq_orders_rows": 391848,
"dq_act_rows": 1198459,
"dq_act_dup_serials": 5040,
"dq_act_dup_serials_last24m": 1611,
"dq_act_oem_missing": 107210,
"dq_act_oem_missing_after_backfill": 85186,
"dq_act_beta_rows": 2197,
"dq_act_beta_in_last24m": 0,
"dq_act_model_string_free_text": true,
"k2": {
"cur": 2492460.0,
"prior": 2528350.0,
"growth": -0.01419502837819131,
"prior2": 2455380.0,
"prior_growth": 0.029718414257670966,
"raw_cur": 2505330.0,
"raw_growth": -0.014099859906499423,
"months_remaining": 9,
"growth_series": {
"2026-06": -0.033032549778435394,
"2026-07": -0.024774473114043682,
"2026-08": -0.019610861764740695,
"2026-09": -0.01419502837819131
},
"run_rate_pts_per_month": 0.6279173800081361,
"pace_needed_pts_per_month": 0.7132780930910145,
"fy_activations": {
"2022": 1520470.0,
"2023": 2304410.0,
"2024": 2426060.0,
"2025": 2547790.0,
"2026": 2463630.0
},
"dup_rate_cur": 0.005137047814060436,
"by_group_growth": {
"card": -0.013041545225510043,
"chip": -0.01577194744793442,
"module": -0.012537088494324888
},
"country_growth_range": [
-0.03529633824084555,
0.013368055555555536
],
"countries_growing": 3,
"countries_total": 21,
"top_country_growth": {
"United States": -0.014642649622312653,
"Italy": -0.026059592880322557,
"Japan": -0.020485626569913484,
"Brazil": -0.0036032619002465127,
"China": -0.007943988151339676,
"Germany": -0.019595788826558103,
"Canada": -0.015394233023364845,
"Sweden": -0.007039774727208736
},
"oems_growing": 130,
"oems_total": 319,
"oem_growth_median": -0.012658227848101222,
"quarterly": {
"FY25-Q2": 662050.0,
"FY25-Q3": 616520.0,
"FY25-Q4": 658610.0,
"FY26-Q1": 591170.0,
"FY26-Q2": 640290.0,
"FY26-Q3": 591280.0,
"FY26-Q4": 640890.0,
"FY27-Q1": 620000.0
},
"dup_serial_share_all": 0.004205400435058688
},
"sellin_vs_installs": {
"2023": {
"invoiced": 3985844.0,
"activated": 2304410.0,
"ratio": 1.7296592186286295
},
"2024": {
"invoiced": 5279584.0,
"activated": 2426060.0,
"ratio": 2.17619679645186
},
"2025": {
"invoiced": 4883606.0,
"activated": 2547790.0,
"ratio": 1.9168008352336732
},
"2026": {
"invoiced": 2590114.0,
"activated": 2463630.0,
"ratio": 1.051340501617532
},
"R12M": {
"invoiced": 2598870.0,
"activated": 2492460.0,
"ratio": 1.0426927613682868
},
"R12M_prior": {
"invoiced": 4310658.0,
"activated": 2528350.0,
"ratio": 1.704929301718512
},
"ratio_jan25_jun25_avg": 1.9135225427995577,
"ratio_jul25_sep26_avg": 1.040281745864452,
"cum_excess_jul22_jun25": 6870774.0,
"ratio_fy22": 2.2615513624076766
},
"timeline": {
"2022-06": {
"ord_qty": 447031.0,
"lead_wk": 47.59616677874916,
"inv_qty": 316375.0,
"act": 178720.0
},
"2023-03": {
"ord_qty": 352647.0,
"lead_wk": 47.65900649953575,
"inv_qty": 391624.0,
"act": 183900.0
},
"2023-09": {
"ord_qty": 219561.0,
"lead_wk": 43.742088032011644,
"inv_qty": 533249.0,
"act": 194400.0
},
"2023-12": {
"ord_qty": 10742.0,
"lead_wk": 18.764705882352942,
"inv_qty": 590605.0,
"act": 213480.0
},
"2024-03": {
"ord_qty": 9382.0,
"lead_wk": 10.674528301886792,
"inv_qty": 554228.0,
"act": 193800.0
},
"2024-09": {
"ord_qty": 336703.0,
"lead_wk": 7.878391472868217,
"inv_qty": 552417.0,
"act": 201680.0
},
"2025-06": {
"ord_qty": 194068.0,
"lead_wk": 7.752707581227437,
"inv_qty": 577771.0,
"act": 221930.0
},
"2025-09": {
"ord_qty": 211188.0,
"lead_wk": 7.745762711864407,
"inv_qty": 224569.0,
"act": 196740.0
},
"2026-09": {
"ord_qty": 131424.0,
"lead_wk": 7.836626506024096,
"inv_qty": 208143.0,
"act": 205590.0
}
},
"orders_drought": {
"ord_qty_oct23_jun24": 245944.0,
"ord_qty_prev9m": 3362811.0,
"lead_before": 47.65900649953575,
"lead_after": 8.506602641056423,
"backlog_invoiced_jul24_jun25_vs_orders": 4883606.0
},
"dq_inv_reports_rows": 1087,
"dq_inv_reports_unmatched": 0,
"dq_inv_reports_raw_names": 235,
"dq_inv_reports_clean_names": 35,
"dq_inv_reports_kinds": {
"reel": 88,
"finished": 229
},
"dq_inv_reports_dups": 0,
"inv_by_quarter": {
"2021-Q3": {
"units": 301889.0,
"oems": 22,
"parts": 275066.0
},
"2021-Q4": {
"units": 350229.0,
"oems": 22,
"parts": 258466.0
},
"2022-Q1": {
"units": 308782.0,
"oems": 23,
"parts": 213574.0
},
"2022-Q2": {
"units": 311629.0,
"oems": 23,
"parts": 218735.0
},
"2022-Q3": {
"units": 402067.0,
"oems": 27,
"parts": 276900.0
},
"2022-Q4": {
"units": 408856.0,
"oems": 23,
"parts": 290707.0
},
"2023-Q1": {
"units": 518776.0,
"oems": 27,
"parts": 367161.0
},
"2023-Q2": {
"units": 448505.0,
"oems": 28,
"parts": 327635.0
},
"2023-Q3": {
"units": 657439.0,
"oems": 31,
"parts": 458663.0
},
"2023-Q4": {
"units": 711208.0,
"oems": 23,
"parts": 513115.0
},
"2024-Q1": {
"units": 868256.0,
"oems": 27,
"parts": 643444.0
},
"2024-Q2": {
"units": 785292.0,
"oems": 26,
"parts": 712944.0
},
"2024-Q3": {
"units": 1072762.0,
"oems": 25,
"parts": 883964.0
},
"2024-Q4": {
"units": 975940.0,
"oems": 24,
"parts": 832390.0
},
"2025-Q1": {
"units": 1376758.0,
"oems": 28,
"parts": 969385.0
},
"2025-Q2": {
"units": 1590583.0,
"oems": 31,
"parts": 1152555.0
},
"2025-Q3": {
"units": 1284416.0,
"oems": 26,
"parts": 903991.0
},
"2025-Q4": {
"units": 980357.0,
"oems": 28,
"parts": 736506.0
},
"2026-Q1": {
"units": 1066952.0,
"oems": 26,
"parts": 787237.0
},
"2026-Q2": {
"units": 777310.0,
"oems": 22,
"parts": 620820.0
},
"2026-Q3": {
"units": 841883.0,
"oems": 28,
"parts": 580074.0
}
},
"inv_lfl": {
"2021-Q4": {
"prev": "2021-Q3",
"both": 13,
"prev_units": 210294.0,
"units": 220117.0,
"change": 0.04671079536268263
},
"2022-Q1": {
"prev": "2021-Q4",
"both": 18,
"prev_units": 251668.0,
"units": 260967.0,
"change": 0.03694947311537433
},
"2022-Q2": {
"prev": "2022-Q1",
"both": 16,
"prev_units": 208713.0,
"units": 214984.0,
"change": 0.030046044089251822
},
"2022-Q3": {
"prev": "2022-Q2",
"both": 17,
"prev_units": 245734.0,
"units": 262422.0,
"change": 0.06791083041011836
},
"2022-Q4": {
"prev": "2022-Q3",
"both": 16,
"prev_units": 250765.0,
"units": 266946.0,
"change": 0.064526548760792
},
"2023-Q1": {
"prev": "2022-Q4",
"both": 18,
"prev_units": 345928.0,
"units": 370112.0,
"change": 0.06991050160727097
},
"2023-Q2": {
"prev": "2023-Q1",
"both": 23,
"prev_units": 359256.0,
"units": 380839.0,
"change": 0.060076936780457446
},
"2023-Q3": {
"prev": "2023-Q2",
"both": 26,
"prev_units": 422108.0,
"units": 523976.0,
"change": 0.24133160233873796
},
"2023-Q4": {
"prev": "2023-Q3",
"both": 20,
"prev_units": 445185.0,
"units": 535844.0,
"change": 0.2036434291362017
},
"2024-Q1": {
"prev": "2023-Q4",
"both": 17,
"prev_units": 532583.0,
"units": 625767.0,
"change": 0.17496615551003325
},
"2024-Q2": {
"prev": "2024-Q1",
"both": 20,
"prev_units": 514766.0,
"units": 589438.0,
"change": 0.14506008555343586
},
"2024-Q3": {
"prev": "2024-Q2",
"both": 18,
"prev_units": 586642.0,
"units": 639868.0,
"change": 0.09072995114567317
},
"2024-Q4": {
"prev": "2024-Q3",
"both": 17,
"prev_units": 712405.0,
"units": 758840.0,
"change": 0.06518062057397134
},
"2025-Q1": {
"prev": "2024-Q4",
"both": 19,
"prev_units": 801405.0,
"units": 838853.0,
"change": 0.046727934065796894
},
"2025-Q2": {
"prev": "2025-Q1",
"both": 24,
"prev_units": 1240064.0,
"units": 1326652.0,
"change": 0.06982542836498751
},
"2025-Q3": {
"prev": "2025-Q2",
"both": 24,
"prev_units": 1299038.0,
"units": 1196671.0,
"change": -0.07880215975206273
},
"2025-Q4": {
"prev": "2025-Q3",
"both": 19,
"prev_units": 778449.0,
"units": 717172.0,
"change": -0.07871678170310448
},
"2026-Q1": {
"prev": "2025-Q4",
"both": 19,
"prev_units": 704585.0,
"units": 646589.0,
"change": -0.08231228311701211
},
"2026-Q2": {
"prev": "2026-Q1",
"both": 18,
"prev_units": 735779.0,
"units": 651301.0,
"change": -0.11481436681394819
},
"2026-Q3": {
"prev": "2026-Q2",
"both": 18,
"prev_units": 665812.0,
"units": 552255.0,
"change": -0.17055415042083955
}
},
"inv_peak": {
"quarter": "2025-Q2",
"units": 1590583.0,
"oems": 31
},
"inv_lfl_peak_to_latest": {
"oems": 25,
"peak": 1387997.0,
"latest": 758319.0,
"change": -0.4536594819729437
},
"inv_share_of_oems": {
"reporting_latest": 28,
"total_active": 418
},
"inv_coverage_fy26_hw_share": 0.461172899824253,
"inv_months_cover_latest": 9.272792357511051,
"inv_months_cover_peak": 7.8731988615270385,
"inv_notes_counts": {
"none": 482,
"includes goods in transit": 163,
"excludes Mexico plant": 162,
"estimate": 157,
"as at month end": 123
},
"dq_crm_rows": 8990,
"dq_crm_no_dates_at_all": 2932,
"dq_crm_undated_last_modified_max": "2023-01-25",
"dq_crm_undated_by_stage": {
"lost": 1018,
"design_win": 915,
"shipping": 530,
"pre_production": 469
},
"dq_crm_undated_past_dw_stage": 1914,
"dq_crm_dated_dw": 3840,
"dq_crm_ship_without_dw_date": 349,
"dq_crm_dw_without_design_in": 245,
"dq_crm_dw_without_design_in_after_2023q2": 0,
"dq_crm_stage_dates_start": "2023-01-01",
"dq_crm_missing_share_k4": 0.33263816475495306,
"k4_cutoff": "2025-03-30",
"k4": {
"n": 2131,
"shipped": 672,
"rate": 0.3153449084936649,
"lost": 151,
"lost_rate": 0.07085875175973722,
"still_open": 1308,
"cohort_from": "2023-01-01",
"cohort_to": "2025-03-30",
"shipped_within_18m": 470,
"rate_within_18m": 0.22055373064289066,
"rate_within_24m_cohort": 0.29778051787916154,
"n24": 1622,
"sens_include_undated_stage_based": 0.2971569839307787,
"months_remaining": 9
},
"k4_cohorts": [
{
"q": "2023Q3",
"n": 211,
"shipped": 69,
"lost": 13,
"age_months": 43.56110381077529,
"s12": 0.07582938388625593,
"s18": 0.22274881516587677,
"pp12": 0.44075829383886256,
"lost12": 0.02843601895734597,
"rev_median": 62500.0,
"last_week_share": 0.037914691943127965,
"no_design_in": 0.9052132701421801
},
{
"q": "2023Q4",
"n": 219,
"shipped": 69,
"lost": 10,
"age_months": 40.57161629434954,
"s12": 0.0639269406392694,
"s18": 0.1963470319634703,
"pp12": 0.3972602739726027,
"lost12": 0.0228310502283105,
"rev_median": 62500.0,
"last_week_share": 0.0593607305936073,
"no_design_in": 0.2465753424657534
},
{
"q": "2024Q1",
"n": 248,
"shipped": 96,
"lost": 16,
"age_months": 37.450722733245726,
"s12": 0.0967741935483871,
"s18": 0.23387096774193547,
"pp12": 0.4153225806451613,
"lost12": 0.028225806451612902,
"rev_median": 62500.0,
"last_week_share": 0.06451612903225806,
"no_design_in": 0.0
},
{
"q": "2024Q2",
"n": 242,
"shipped": 85,
"lost": 14,
"age_months": 34.526938239159,
"s12": 0.06198347107438017,
"s18": 0.2190082644628099,
"pp12": 0.4090909090909091,
"lost12": 0.03305785123966942,
"rev_median": 62500.0,
"last_week_share": 0.045454545454545456,
"no_design_in": 0.0
},
{
"q": "2024Q3",
"n": 224,
"shipped": 79,
"lost": 15,
"age_months": 31.471747700394218,
"s12": 0.09821428571428571,
"s18": 0.25892857142857145,
"pp12": 0.46875,
"lost12": 0.022321428571428572,
"rev_median": 50000.0,
"last_week_share": 0.05803571428571429,
"no_design_in": 0.0
},
{
"q": "2024Q4",
"n": 236,
"shipped": 61,
"lost": 12,
"age_months": 28.48226018396846,
"s12": 0.08050847457627118,
"s18": 0.1652542372881356,
"pp12": 0.4110169491525424,
"lost12": 0.01694915254237288,
"rev_median": 37500.0,
"last_week_share": 0.0847457627118644,
"no_design_in": 0.0
},
{
"q": "2025Q1",
"n": 242,
"shipped": 81,
"lost": 15,
"age_months": 25.427069645203677,
"s12": 0.09090909090909091,
"s18": 0.24380165289256198,
"pp12": 0.4214876033057851,
"lost12": 0.004132231404958678,
"rev_median": 37500.0,
"last_week_share": 0.09504132231404959,
"no_design_in": 0.0
},
{
"q": "2025Q2",
"n": 245,
"shipped": 72,
"lost": 26,
"age_months": 22.437582128777922,
"s12": 0.09387755102040816,
"s18": 0.23673469387755103,
"pp12": 0.37551020408163266,
"lost12": 0.0653061224489796,
"rev_median": 37500.0,
"last_week_share": 0.053061224489795916,
"no_design_in": 0.0
},
{
"q": "2025Q3",
"n": 267,
"shipped": 60,
"lost": 30,
"age_months": 19.513797634691194,
"s12": 0.07865168539325842,
"s18": 0.20599250936329588,
"pp12": 0.40823970037453183,
"lost12": 0.056179775280898875,
"rev_median": 25000.0,
"last_week_share": 0.06741573033707865,
"no_design_in": 0.0
},
{
"q": "2025Q4",
"n": 266,
"shipped": 49,
"lost": 49,
"age_months": 16.491458607095925,
"s12": 0.07142857142857142,
"s18": null,
"pp12": 0.37969924812030076,
"lost12": 0.08270676691729323,
"rev_median": 22500.0,
"last_week_share": 0.06766917293233082,
"no_design_in": 0.0
},
{
"q": "2026Q1",
"n": 278,
"shipped": 32,
"lost": 68,
"age_months": 13.567674113009199,
"s12": 0.08273381294964029,
"s18": null,
"pp12": 0.3597122302158273,
"lost12": 0.11151079136690648,
"rev_median": 25000.0,
"last_week_share": 0.039568345323741004,
"no_design_in": 0.0
},
{
"q": "2026Q2",
"n": 300,
"shipped": 12,
"lost": 98,
"age_months": 10.545335085413928,
"s12": null,
"s18": null,
"pp12": null,
"lost12": null,
"rev_median": 37500.0,
"last_week_share": 0.06333333333333334,
"no_design_in": 0.0
},
{
"q": "2026Q3",
"n": 311,
"shipped": 6,
"lost": 0,
"age_months": 7.457293035479632,
"s12": null,
"s18": null,
"pp12": null,
"lost12": null,
"rev_median": 50000.0,
"last_week_share": 0.08681672025723473,
"no_design_in": 0.0
},
{
"q": "2026Q4",
"n": 291,
"shipped": 0,
"lost": 0,
"age_months": 4.533508541392904,
"s12": null,
"s18": null,
"pp12": null,
"lost12": null,
"rev_median": 62500.0,
"last_week_share": 0.06529209621993128,
"no_design_in": 0.0
},
{
"q": "2027Q1",
"n": 260,
"shipped": 0,
"lost": 0,
"age_months": 1.3469119579500657,
"s12": null,
"s18": null,
"pp12": null,
"lost12": null,
"rev_median": 50000.0,
"last_week_share": 0.08461538461538462,
"no_design_in": 0.0
}
],
"k4_fy_dw": {
"2023": 430,
"2024": 950,
"2025": 1020,
"2026": 1180,
"FY27_Q1": 260
},
"k4_bonus_test": {
"ship12": {
"pre_n": 1380,
"post_n": 1298,
"pre": 0.07971014492753623,
"post": 0.08320493066255778
},
"ship18": {
"pre_n": 1380,
"post_n": 754,
"pre": 0.21594202898550724,
"post": 0.22811671087533156
},
"preprod12": {
"pre": 0.42318840579710143,
"post": 0.3882896764252696
},
"lost12": {
"pre": 0.025362318840579712,
"post": 0.06548536209553159
},
"dw_per_quarter_pre": 230.0,
"dw_per_quarter_post": 273.3333333333333,
"est_rev_median_pre": 50000.0,
"est_rev_median_post": 37500.0,
"last_week_share_pre": 0.058695652173913045,
"last_week_share_post": 0.06910569105691057,
"last_week_expected": 0.07692307692307693
},
"k4_bonus_payout_estimate_fy26": 472000.0,
"k4_bonus_payout_lost_after_dw_fy26_cohort": 66400,
"k4_bonus_dw_fy26_not_shipped": 1130,
"k4_spread": {
"owner_min": 0.2422360248447205,
"owner_max": 0.4140127388535032,
"owners": 14,
"region": {
"Americas": 0.3132867132867133,
"Asia Pacific": 0.35094339622641507,
"Europe": 0.3232169954476479,
"Greater China": 0.2886178861788618
},
"tier": {
"A": 0.33583489681050654,
"B": 0.3107569721115538,
"C": 0.30650887573964497
},
"owner_n_min": 83
},
"k4_invoice_crosscheck": {
"shipped_opps": 672,
"oem_invoiced_after_ship": 664
},
"k4_1": {
"median": 15.013140604467806,
"p25": 11.925098554533507,
"p75": 18.89783180026281,
"n": 672,
"all_shipped_median": 14.257555847568987,
"all_n": 771,
"by_cohort": [
{
"q": "2023Q3",
"n_ship": 69,
"median": 15.078843626806833
},
{
"q": "2023Q4",
"n_ship": 69,
"median": 15.571616294349539
},
{
"q": "2024Q1",
"n_ship": 96,
"median": 15.555190538764784
},
{
"q": "2024Q2",
"n_ship": 85,
"median": 16.16294349540079
},
{
"q": "2024Q3",
"n_ship": 79,
"median": 14.520367936925098
},
{
"q": "2024Q4",
"n_ship": 61,
"median": 15.111695137976346
},
{
"q": "2025Q1",
"n_ship": 81,
"median": 15.473061760840999
},
{
"q": "2025Q2",
"n_ship": 72,
"median": 14.224704336399475
},
{
"q": "2025Q3",
"n_ship": 60,
"median": 13.304862023653087
}
],
"run_rate_months_per_cohort": -0.6022777047744198
},
"k4_2": {
"2023Q3": 211,
"2023Q4": 219,
"2024Q1": 248,
"2024Q2": 242,
"2024Q3": 224,
"2024Q4": 236,
"2025Q1": 242,
"2025Q2": 245,
"2025Q3": 267,
"2025Q4": 266,
"2026Q1": 278,
"2026Q2": 300,
"2026Q3": 311,
"2026Q4": 291,
"2027Q1": 260
},
"k4_2_fy26": 1180,
"k4_2_fy25": 1020,
"k4_2_run_rate_per_quarter": 4.333333333333333,
"dq_fc_rows": 84,
"dq_fc_thousands_rows": 12,
"dq_fc_thousands_quarters": [
"FY24-Q1",
"FY24-Q2",
"FY24-Q3",
"FY24-Q4"
],
"k5_quarters": {
"finance_run_rate": {
"FY24-Q1": {
"forecast": 26479800.0,
"actual": 30567522.37,
"err": -0.13372763158625606
},
"FY24-Q2": {
"forecast": 29551500.0,
"actual": 28956308.99,
"err": 0.020554795509522626
},
"FY24-Q3": {
"forecast": 27893900.0,
"actual": 31545948.52,
"err": -0.11576917770231623
},
"FY24-Q4": {
"forecast": 30936500.0,
"actual": 31016578.47,
"err": -0.0025817957347375594
},
"FY25-Q1": {
"forecast": 39782781.0,
"actual": 27949112.41,
"err": 0.42340051506487175
},
"FY25-Q2": {
"forecast": 34415706.0,
"actual": 30420156.169999998,
"err": 0.13134547395717733
},
"FY25-Q3": {
"forecast": 36223439.0,
"actual": 30213633.830000002,
"err": 0.19891037284077648
},
"FY25-Q4": {
"forecast": 32093863.0,
"actual": 29817097.59,
"err": 0.07635771399707185
},
"FY26-Q1": {
"forecast": 27153991.0,
"actual": 19462009.84,
"err": 0.39523056576565785
},
"FY26-Q2": {
"forecast": 28386775.0,
"actual": 18798138.77,
"err": 0.5100843411850183
},
"FY26-Q3": {
"forecast": 25096753.0,
"actual": 23226454.97,
"err": 0.08052447230607235
},
"FY26-Q4": {
"forecast": 22298088.0,
"actual": 19113396.419999998,
"err": 0.16662091394010872
},
"FY27-Q1": {
"forecast": 16070686.0,
"actual": 19400000.0,
"err": -0.17161412371134022
}
},
"sales_crm": {
"FY24-Q1": {
"forecast": 33015801.0,
"actual": 30567522.37,
"err": 0.08009411428133352
},
"FY24-Q2": {
"forecast": 33789118.0,
"actual": 28956308.99,
"err": 0.16690003590129537
},
"FY24-Q3": {
"forecast": 34333343.0,
"actual": 31545948.52,
"err": 0.08835982466124942
},
"FY24-Q4": {
"forecast": 36452329.0,
"actual": 31016578.47,
"err": 0.1752530678152522
},
"FY25-Q1": {
"forecast": 34022513.0,
"actual": 27949112.41,
"err": 0.21730209177687443
},
"FY25-Q2": {
"forecast": 35783928.0,
"actual": 30420156.169999998,
"err": 0.17632295508363272
},
"FY25-Q4": {
"forecast": 33666036.0,
"actual": 29817097.59,
"err": 0.12908494525271466
},
"FY26-Q1": {
"forecast": 25812261.0,
"actual": 19462009.84,
"err": 0.3262895873656593
},
"FY26-Q2": {
"forecast": 26151613.0,
"actual": 18798138.77,
"err": 0.39118097381722866
},
"FY26-Q3": {
"forecast": 31264955.0,
"actual": 23226454.97,
"err": 0.34609242092186576
},
"FY26-Q4": {
"forecast": 26326926.0,
"actual": 19113396.419999998,
"err": 0.377406998813244
},
"FY27-Q1": {
"forecast": 24376083.0,
"actual": 19400000.0,
"err": 0.2564991237113402
}
}
},
"k5_order": [
"FY24-Q1",
"FY24-Q2",
"FY24-Q3",
"FY24-Q4",
"FY25-Q1",
"FY25-Q2",
"FY25-Q3",
"FY25-Q4",
"FY26-Q1",
"FY26-Q2",
"FY26-Q3",
"FY26-Q4",
"FY27-Q1"
],
"k5_missing_source_quarters": [
"sales_crm FY25-Q3"
],
"dq_fc_late_snapshots": [
{
"source": "sales_crm",
"q": "FY26-Q2"
}
],
"dq_fc_snapshot_days_before_start": [
2,
5
],
"k5_last4": [
"FY26-Q2",
"FY26-Q3",
"FY26-Q4",
"FY27-Q1"
],
"k5": {
"finance_run_rate": {
"latest_q": "FY27-Q1",
"latest_err": -0.17161412371134022,
"latest_abs": 0.17161412371134022,
"mape_last4": 0.2322109627856349,
"mape_all": 0.18667091486930212,
"n_all": 13,
"within5": 2,
"within10": 4,
"bias_all": 0.12148741814089441,
"bias_last4": 0.1464039009299648,
"worst_q": "FY26-Q2",
"worst_err": 0.5100843411850183,
"mape_before_break": 0.13783093454909123,
"mape_after_break": 0.2648148833816395,
"bias_before_break": 0.07481128329326378,
"bias_after_break": 0.19616923389710342,
"n_over": 9,
"n_quarters": 13,
"abs_err_latest": 0.17161412371134022,
"run_rate_pts_per_quarter": -11.282340582455937,
"pace_needed_pts_per_quarter": -4.05380412371134,
"abs_err_series_last4": {
"FY26-Q2": 0.5100843411850183,
"FY26-Q3": 0.08052447230607235,
"FY26-Q4": 0.16662091394010872,
"FY27-Q1": 0.17161412371134022
},
"pace_needed_pts_per_quarter_v11": -2.3871374570446737
},
"sales_crm": {
"latest_q": "FY27-Q1",
"latest_err": 0.2564991237113402,
"latest_abs": 0.2564991237113402,
"mape_last4": 0.3427948793159197,
"mape_all": 0.2275655116168075,
"n_all": 12,
"within5": 0,
"within10": 2,
"bias_all": 0.2275655116168075,
"bias_last4": 0.3427948793159197,
"worst_q": "FY26-Q2",
"worst_err": 0.39118097381722866,
"mape_before_break": 0.1476167192531932,
"mape_after_break": 0.3394938209258676,
"bias_before_break": 0.1476167192531932,
"bias_after_break": 0.3394938209258676,
"n_over": 12,
"n_quarters": 12,
"abs_err_latest": 0.2564991237113402,
"run_rate_pts_per_quarter": -4.489395003529615,
"pace_needed_pts_per_quarter": -6.883304123711341,
"abs_err_series_last4": {
"FY26-Q2": 0.39118097381722866,
"FY26-Q3": 0.34609242092186576,
"FY26-Q4": 0.377406998813244,
"FY27-Q1": 0.2564991237113402
},
"pace_needed_pts_per_quarter_v11": -5.216637457044674
}
},
"k5_unit_trap": {
"fy24q1_raw": 26479.800000000003,
"fy24q1_fixed": 26479800.0
},
"k5_family": {
"finance_run_rate": {
"hardware": {
"mape": 0.274978217947371,
"bias": 0.1533137681710926
},
"other": {
"mape": 0.05739869519249771,
"bias": 0.0010761977901988678
},
"software": {
"mape": 0.42625106043922045,
"bias": 0.16511495193170297
}
},
"sales_crm": {
"hardware": {
"mape": 0.26652408225375007,
"bias": 0.26652408225375007
},
"other": {
"mape": 0.013831903623421031,
"bias": -0.004838369051362156
},
"software": {
"mape": 0.14286909205352213,
"bias": 0.14286909205352213
}
}
},
"k5_family_last4": {
"finance_run_rate": {
"hardware": {
"mape": 0.39969606807070523,
"bias": 0.163212038219959
},
"other": {
"mape": 0.025458319854064052,
"bias": 0.0005084719032206978
},
"software": {
"mape": 0.39181781900737056,
"bias": 0.21309466033106428
}
},
"sales_crm": {
"hardware": {
"mape": 0.43810692228205467,
"bias": 0.43810692228205467
},
"other": {
"mape": 0.011582567905349233,
"bias": -0.008382646644217732
},
"software": {
"mape": 0.1351361626610999,
"bias": 0.1351361626610999
}
}
},
"k5_finance_vs_naive": {
"FY24-Q1": {
"f_vs_prev": 0.09296566693314756,
"naive_err": -0.20741117985481017,
"err": -0.1337276315862561
},
"FY24-Q2": {
"f_vs_prev": -0.03323862358557261,
"naive_err": 0.0556429129332896,
"err": 0.02055479550952266
},
"FY24-Q3": {
"f_vs_prev": -0.036690069523947266,
"naive_err": -0.08209103392019357,
"err": -0.1157691777023162
},
"FY24-Q4": {
"f_vs_prev": -0.01931939119261583,
"naive_err": 0.017067325801652267,
"err": -0.002581795734737602
},
"FY25-Q1": {
"f_vs_prev": 0.28262957948372325,
"naive_err": 0.10975182377893611,
"err": 0.42340051506487186
},
"FY25-Q2": {
"f_vs_prev": 0.23137026661663485,
"naive_err": -0.08123047581316867,
"err": 0.13134547395717733
},
"FY25-Q3": {
"f_vs_prev": 0.1907709742701167,
"naive_err": 0.006835402228080767,
"err": 0.1989103728407764
},
"FY25-Q4": {
"f_vs_prev": 0.06223114970477539,
"naive_err": 0.01329895503085421,
"err": 0.07635771399707192
},
"FY26-Q1": {
"f_vs_prev": -0.08931474909526904,
"naive_err": 0.5320667205047513,
"err": 0.39523056576565785
},
"FY26-Q2": {
"f_vs_prev": 0.45857366394179144,
"naive_err": 0.03531578727674223,
"err": 0.5100843411850182
},
"FY26-Q3": {
"f_vs_prev": 0.33506584386173244,
"naive_err": -0.1906582905449733,
"err": 0.08052447230607229
},
"FY26-Q4": {
"f_vs_prev": -0.03997023959097956,
"naive_err": 0.21519244720400144,
"err": 0.1666209139401087
},
"FY27-Q1": {
"f_vs_prev": -0.15919255547989086,
"naive_err": -0.014773380412371195,
"err": -0.17161412371134022
}
},
"k5_naive": {
"finance_mape_all": 0.18667091486930204,
"naive_mape_all": 0.120102748869525,
"median_abs_gap_to_prev": 0.09296566693314756,
"corr": 0.7117748471901201,
"finance_mape_ex_break": 0.16907974580217539,
"naive_mape_ex_break": 0.09222687585333658
},
"k5_software_miss_q": {
"finance_run_rate FY24-Q2": 1.4773835729188105,
"finance_run_rate FY25-Q1": 0.5809006407049735,
"finance_run_rate FY25-Q2": -0.5741995908166633,
"finance_run_rate FY26-Q2": 0.5363545064108209,
"finance_run_rate FY27-Q1": 0.5149263247863248
},
"k5_fy26q3_software_actual": 10505003.99,
"k5_fy26q3_software_actual_ex": 3105003.99,
"k5_fy26q3_software": {
"finance_run_rate": {
"forecast": 6750029.0,
"err": -0.35744631735261245,
"err_ex": 1.173919589713635
},
"sales_crm": {
"forecast": 12319688.0,
"err": 0.17274472353627346,
"err_ex": 2.967688299170269
}
},
"k5_break": {
"finance_run_rate": {
"forecast": 22461090.0,
"actual": 12901896.88
},
"sales_crm": {
"forecast": 18236559.0,
"actual": 12901896.88
}
},
"k5_fy27q1_hw": {
"finance_run_rate": {
"forecast": 7062228.0,
"actual": 13400000.0
},
"sales_crm": {
"forecast": 17806060.0,
"actual": 13400000.0
}
},
"k5_fin_fy27q1_hw_vs_actual_prev_q": 14351663.52,
"k5_disagreement": {
"FY24-Q1": 0.2138217458675896,
"FY24-Q2": 0.14634524039177274,
"FY24-Q3": 0.20412900236356565,
"FY24-Q4": 0.17783486354998976,
"FY25-Q1": -0.20609842328799735,
"FY25-Q2": 0.044977481126455374,
"FY25-Q4": 0.05272723125564281,
"FY26-Q1": -0.06894097839999859,
"FY26-Q2": -0.11890336736778968,
"FY26-Q3": 0.26556794861579347,
"FY26-Q4": 0.2107860848731353,
"FY27-Q1": 0.4281132474226804
},
"k5_disagreement_median_abs": 0.1909819329567777,
"k5_target_checks": {
"latest_q": "FY27-Q1",
"months_remaining": 9
},
"k5_blend_mape": 0.17805408096185496,
"k5_blend_quarters": 12,
"k5_sales_mape_same_quarters": 0.2275655116168075,
"k5_finance_mape_same_quarters": 0.1856509600383459,
"incentive": {
"plan_fy": "FY25",
"role": "Account manager",
"component": "Design wins",
"weight_pct": 25,
"payout_rule": "A$400 per opportunity moved to design_win in the CRM, paid quarterly, no clawback if later lost"
},
"board_targets": [
{
"target_id": "BT-01",
"metric": "Total revenue",
"period": "FY28",
"target_value": 115000000.0,
"unit": "AUD",
"set_by": "Board",
"set_date": "2026-08-26",
"basis": "Board strategy day: back to FY25 revenue within two years"
},
{
"target_id": "BT-02",
"metric": "Total revenue",
"period": "FY27",
"target_value": 92689999.99,
"unit": "AUD",
"set_by": "Finance",
"set_date": "2026-06-15",
"basis": "FY26 actual plus 15% (board_plan_fy27)"
},
{
"target_id": "BT-03",
"metric": "Gross margin",
"period": "FY27",
"target_value": 76.0,
"unit": "percent",
"set_by": "Finance",
"set_date": "2026-06-15",
"basis": "FY27 budget assumption"
},
{
"target_id": "BT-04",
"metric": "Underlying EBITDA",
"period": "FY27",
"target_value": 8889540.0,
"unit": "AUD",
"set_by": "Finance",
"set_date": "2026-06-15",
"basis": "FY27 budget (board_budget_fy27)"
}
],
"dq_heartbeat_rows": 1236586,
"dq_heartbeat_devices": 58917,
"dq_heartbeat_first_month": "2022-07-01",
"k1_flat_jun27": {
"value": 73137990.16,
"with_big": 80537990.16,
"path": 97800000.0,
"gap_to_path": -24662009.840000004
},
"plan_corvane_repeat": 8510000.0,
"plan_ex_corvane_repeat": 84179999.99,
"k1_hw_q_vs_prior_year": {
"FY27-Q1": 0.03860696800112695,
"FY26-Q4": -0.4426073670787516
},
"k1_hw_q_vs_prev_q": {
"FY26-Q1": -0.4989136791285613,
"FY27-Q1": -0.06631032832352801
},
"hw_q_series": {
"FY25-Q1": 23793892.28,
"FY25-Q2": 25573960.86,
"FY25-Q3": 24084293.96,
"FY25-Q4": 25747852.9,
"FY26-Q1": 12901896.88,
"FY26-Q2": 14473638.579999998,
"FY26-Q3": 12572801.02,
"FY26-Q4": 14351663.52,
"FY27-Q1": 13400000.0
},
"hw_volume_split": {
"units_change": -2293492.0,
"installs_change": -84160.0,
"gap_change": -2209332.0,
"avg_price_fy25": 21.766702727451804,
"installs_effect": -1831885.701542344,
"gap_effect": -48089872.87024655,
"total_effect_at_avg_price": -49921758.57178889,
"sku_level_volume_effect": -49788168.25161144,
"installs_share_of_units_fall": 0.03669513562724439
},
"k2_quarter_yoy": {
"FY25-Q1": 0.050439539644583586,
"FY25-Q2": 0.04309122420040956,
"FY25-Q3": 0.058421603804357236,
"FY25-Q4": 0.04944389559896756,
"FY26-Q1": -0.03183701544357287,
"FY26-Q2": -0.032867608186692876,
"FY26-Q3": -0.040939466683968084,
"FY26-Q4": -0.02690514872230909,
"FY27-Q1": 0.04876769795490299
},
"k2_month_yoy_2025_07_to_2026_06_mean": -0.033073593182029175,
"k2_month_yoy_2024_07_to_2025_06_mean": 0.0503732104535348,
"k2_latest_q_units": 620000.0,
"k2_latest_q_prior_units": 591170.0,
"k2_latest_q_yoy_exact": 0.04876769795490299,
"k2_dip_breadth": {
"countries_down": 20,
"countries": 21,
"min": -0.06323454266734796,
"max": 0.008042066192391006,
"groups": {
"card": -0.03823716848865144,
"chip": -0.03420842029281157,
"module": -0.030638011334941928
}
},
"k2_latest_q_breadth": {
"countries_up": 19,
"countries": 21
},
"k2_firmware_first_month": {
"4.0.0": "2021-06",
"4.0.0-beta": "2021-01",
"4.0.2": "2022-01",
"4.1.0": "2022-08",
"4.1.3": "2023-03",
"4.2.1": "2023-10",
"4.3.0": "2024-05",
"4.4.2": "2024-12",
"4.5.0": "2025-07",
"4.6.1": "2026-02"
},
"k2_dup_share_by_period": {
"dip": 0.005289232173066871,
"before": 0.0046956610060903126
},
"k2_quarter_share_of_year": {
"2023": [
0.2404,
0.2603,
0.2398,
0.2595
],
"2024": [
0.2396,
0.2616,
0.2401,
0.2587
],
"2025": [
0.2397,
0.2599,
0.242,
0.2585
]
},
"k2_heartbeat_devices_seen": {
"2025-06-01": 31183,
"2025-07-01": 31608,
"2026-06-01": 37374,
"2026-07-01": 37852,
"2026-09-01": 38726
},
"k3_perp": {
"cur_n": 81,
"prior_n": 105,
"cur_value": 13672509.979999999,
"prior_value": 17194859.839999996,
"cur_median": 106019.01,
"prior_median": 120430.01,
"cur_over_500k": 4,
"prior_over_500k": 5,
"cur_over_500k_value": 2785951.25,
"prior_over_500k_value": 3059526.26,
"small_cur": 10886558.729999999,
"small_prior": 14135333.58
},
"big_oem_hw": {
"fy25": 5422466.05,
"fy26": 2524728.88,
"change": -0.5343947095805238,
"rank_fy25": 1
},
"k4_old36": {
"n": 678,
"shipped": 0.34513274336283184,
"lost": 0.05752212389380531,
"open": 0.5973451327433629
},
"k4_ship_curve_2023h1": {
"6": 0.002325581395348837,
"12": 0.06976744186046512,
"18": 0.20930232558139536,
"24": 0.2744186046511628,
"30": 0.313953488372093,
"36": 0.3186046511627907,
"42": 0.3209302325581395
},
"k4_ship_curve_2023h1_n": 430,
"k5_finance_vs_yearago": {
"FY24-Q1": {
"f_vs_yago": 0.16789239376675602,
"yago_err": -0.258260116225442
},
"FY24-Q2": {
"f_vs_yago": 0.22660530961785774,
"yago_err": -0.16798436505425618
},
"FY24-Q3": {
"f_vs_yago": 0.22540500075902314,
"yago_err": -0.2784174850355712
},
"FY24-Q4": {
"f_vs_yago": 0.27691796596187723,
"yago_err": -0.21888623165081178
},
"FY25-Q1": {
"f_vs_yago": 0.301472213496903,
"yago_err": 0.09368490568105314
},
"FY25-Q2": {
"f_vs_yago": 0.18853911981272864,
"yago_err": -0.048120962029893466
},
"FY25-Q3": {
"f_vs_yago": 0.14827547433022947,
"yago_err": 0.04409647305241071
},
"FY25-Q4": {
"f_vs_yago": 0.03473253927869502,
"yago_err": 0.040227955668035165
},
"FY26-Q1": {
"f_vs_yago": -0.02844889663528316,
"yago_err": 0.4360856170443699
},
"FY26-Q2": {
"f_vs_yago": -0.06684321929962,
"yago_err": 0.6182536229888678
},
"FY26-Q3": {
"f_vs_yago": -0.16935668376702506,
"yago_err": 0.3008284677547588
},
"FY26-Q4": {
"f_vs_yago": -0.25217107625263,
"yago_err": 0.5600104206911021
},
"FY27-Q1": {
"f_vs_yago": -0.1742535261198902,
"yago_err": 0.0031963835051547207
}
},
"k5_yearago": {
"corr": 0.5603201742939866,
"yago_mape": 0.23600407741397897,
"finance_mape": 0.18667091486930204,
"median_gap_to_yago": 0.1742535261198902
},
"k5_aud_error_last4": {
"finance_run_rate": {
"hardware": 9085904.880000003,
"other": 663.9700000000012,
"software": 2227742.99
},
"sales_crm": {
"hardware": 24013658.880000003,
"other": -5120.029999999999,
"software": 3573047.99
}
},
"k5_aud_actual_last4": 80537990.16,
"k4_asof": {
"2025-12-31": {
"rate": 0.3079710144927536,
"n": 1380
},
"2026-03-31": {
"rate": 0.31381011097410605,
"n": 1622
},
"2026-06-30": {
"rate": 0.3165236051502146,
"n": 1864
},
"2026-09-30": {
"rate": 0.3153449084936649,
"n": 2131
}
},
"k4_run_rate_pts_per_month": 0.08193215556568131,
"k4_pace_needed_pts_per_month": 5.385056572292612,
"k3_fy27_need": {
"need_fy27": 30840000.0,
"q1_actual": 5850000.0,
"rest_per_month": 2776666.6666666665,
"fy26_ex_big_per_month": 1525000.0,
"ex_big_trailing_per_month": 1478002.1675000002
},
"k3_flat_jun27": {
"value": 17736026.01,
"growth": -0.30988225642023337
},
"k2_pace_note": {
"target_units_jun27": 2654767.5
},
"k5_plan_vs_forecast_q1": {
"plan_hw": 14837181.41,
"finance_forecast_hw": 7062228.0,
"sales_forecast_hw": 17806060.0,
"actual_hw": 13400000.0,
"plan_set": "2026-06-15",
"forecast_dated": "2026-06-26"
},
"k5_plan_q1_all": 22381311.31,
"k5_plan_q1_err": 0.15367584072164941,
"gary_hw_codes_check": {
"plan_other_codes_match": true,
"other_fy26": 600000.0,
"dev_kits_fy26": 349596.5800000001,
"freight_fy26": 250403.42
},
"fy27_plan_vs_path_gap": -5110000.010000005,
"fy27_plan_vs_path_gap_pct": -0.05224948885480574,
"board_target_fy27_gm": 76.0,
"orders_vs_installs": {
"shortage_2022_07_to_2023_09": {
"orders": 400189.8,
"installs": 192380.0,
"invoiced": 351249.8
},
"drought_2023_10_to_2024_06": {
"orders": 27327.11111111111,
"installs": 204974.44444444444,
"invoiced": 444075.6666666667
},
"rebuy_2024_07_to_2025_04": {
"orders": 412051.5,
"installs": 210839.0,
"invoiced": 396712.6
},
"reset_2025_05_to_2026_09": {
"orders": 214392.4705882353,
"installs": 207237.0588235294,
"invoiced": 242607.29411764705
}
},
"lic_vs_gl_monthly": {
"max_abs_diff": 26979.080000000016,
"months_over_1pct": 28,
"months": 87
},
"k2_1": {
"latest_q": "2026-Q3",
"latest_units": 841883.0,
"latest_oems": 28,
"latest_parts": 580074.0,
"peak_q": "2025-Q2",
"peak_units": 1590583.0,
"peak_oems": 31,
"lfl_latest": {
"prev": "2026-Q2",
"both": 18,
"prev_units": 665812.0,
"units": 552255.0,
"change": -0.17055415042083955
},
"lfl_prev": {
"prev": "2026-Q1",
"both": 18,
"prev_units": 735779.0,
"units": 651301.0,
"change": -0.11481436681394819
},
"lfl_prev2": {
"prev": "2025-Q4",
"both": 19,
"prev_units": 704585.0,
"units": 646589.0,
"change": -0.08231228311701211
},
"raw_sum_no_reel_fix_latest": 755556.0,
"run_rate_lfl_per_quarter": -0.12256026678393328
},
"counter": {
"k1_gm": 0.7650262808594528,
"k1_rebate_rate_fy26": 0.04569420035149385,
"k2_dup": 0.005137047814060436,
"k3_renewal": 0.8871951219512195,
"k4_lost": 0.07085875175973722,
"k5_bias_fin": 0.1464039009299648,
"k5_bias_sales": 0.3427948793159197
},
"k3_v11": {
"growth_ex": -0.15566090841104252,
"excluded_cur": 7400000.0,
"excluded_prior": 0.0,
"cur": 17736026.01,
"prior": 21005809.38,
"limit": 1000000,
"n_over_limit_cur": 1,
"n_over_limit_prior": 0,
"series": {
"2026-06": -0.016129032258064502,
"2026-07": -0.1978106729853918,
"2026-08": -0.1658919345996145,
"2026-09": -0.15566090841104252
},
"months_remaining": 9,
"run_rate_pts_per_month": -4.651062538432601,
"pace_needed_pts_per_month": 1.7295656490115836,
"fy26_ex": -0.016129032258064502
},
"k2_1_cover": {
"2021-Q3": {
"stock": 301889.0,
"oems": 22,
"invoiced_per_month": 85068.0,
"activated_per_month": 18423.333333333332,
"months_invoiced": 3.5487962571119573,
"months_activated": 16.386231228514568
},
"2021-Q4": {
"stock": 350229.0,
"oems": 22,
"invoiced_per_month": 100883.33333333333,
"activated_per_month": 38570.0,
"months_invoiced": 3.471623988105072,
"months_activated": 9.080347420274824
},
"2022-Q1": {
"stock": 308782.0,
"oems": 23,
"invoiced_per_month": 79452.33333333333,
"activated_per_month": 40273.333333333336,
"months_invoiced": 3.886380513263718,
"months_activated": 7.667157755338519
},
"2022-Q2": {
"stock": 311629.0,
"oems": 23,
"invoiced_per_month": 83819.66666666667,
"activated_per_month": 42346.666666666664,
"months_invoiced": 3.717850623759738,
"months_activated": 7.358997166246851
},
"2022-Q3": {
"stock": 402067.0,
"oems": 27,
"invoiced_per_month": 109877.33333333333,
"activated_per_month": 66160.0,
"months_invoiced": 3.6592351470730997,
"months_activated": 6.0771916565900845
},
"2022-Q4": {
"stock": 408856.0,
"oems": 23,
"invoiced_per_month": 116362.0,
"activated_per_month": 65063.333333333336,
"months_invoiced": 3.51365566078273,
"months_activated": 6.2839694656488545
},
"2023-Q1": {
"stock": 518776.0,
"oems": 27,
"invoiced_per_month": 128382.0,
"activated_per_month": 77956.66666666667,
"months_invoiced": 4.04087800470471,
"months_activated": 6.65467139864027
},
"2023-Q2": {
"stock": 448505.0,
"oems": 28,
"invoiced_per_month": 112608.66666666667,
"activated_per_month": 66633.33333333333,
"months_invoiced": 3.9828639595531428,
"months_activated": 6.730940470235118
},
"2023-Q3": {
"stock": 657439.0,
"oems": 31,
"invoiced_per_month": 161129.66666666666,
"activated_per_month": 69516.66666666667,
"months_invoiced": 4.080185937205853,
"months_activated": 9.457286022536561
},
"2023-Q4": {
"stock": 711208.0,
"oems": 23,
"invoiced_per_month": 157530.33333333334,
"activated_per_month": 76400.0,
"months_invoiced": 4.514736844332625,
"months_activated": 9.309005235602093
},
"2024-Q1": {
"stock": 868256.0,
"oems": 27,
"invoiced_per_month": 150034.0,
"activated_per_month": 67010.0,
"months_invoiced": 5.787061599370809,
"months_activated": 12.957110878973287
},
"2024-Q2": {
"stock": 785292.0,
"oems": 26,
"invoiced_per_month": 123872.0,
"activated_per_month": 51983.333333333336,
"months_invoiced": 6.339544045466288,
"months_activated": 15.106611093299133
},
"2024-Q3": {
"stock": 1072762.0,
"oems": 25,
"invoiced_per_month": 142181.0,
"activated_per_month": 67996.66666666667,
"months_invoiced": 7.545044696548765,
"months_activated": 15.776685131624099
},
"2024-Q4": {
"stock": 975940.0,
"oems": 24,
"invoiced_per_month": 124317.0,
"activated_per_month": 70606.66666666667,
"months_invoiced": 7.8504146657335685,
"months_activated": 13.822207534699272
},
"2025-Q1": {
"stock": 1376758.0,
"oems": 28,
"invoiced_per_month": 160789.66666666666,
"activated_per_month": 81810.0,
"months_invoiced": 8.562478102863162,
"months_activated": 16.828725094731695
},
"2025-Q2": {
"stock": 1590583.0,
"oems": 31,
"invoiced_per_month": 188761.33333333334,
"activated_per_month": 96796.66666666667,
"months_invoiced": 8.426423843866328,
"months_activated": 16.432208409380486
},
"2025-Q3": {
"stock": 1284416.0,
"oems": 26,
"invoiced_per_month": 83561.66666666667,
"activated_per_month": 71746.66666666667,
"months_invoiced": 15.370875800307157,
"months_activated": 17.902099981416093
},
"2025-Q4": {
"stock": 980357.0,
"oems": 28,
"invoiced_per_month": 76050.0,
"activated_per_month": 64873.333333333336,
"months_invoiced": 12.890953320184089,
"months_activated": 15.111864145514335
},
"2026-Q1": {
"stock": 1066952.0,
"oems": 26,
"invoiced_per_month": 80904.33333333333,
"activated_per_month": 72673.33333333333,
"months_invoiced": 13.187822654740373,
"months_activated": 14.681478763416202
},
"2026-Q2": {
"stock": 777310.0,
"oems": 22,
"invoiced_per_month": 73738.33333333333,
"activated_per_month": 63610.0,
"months_invoiced": 10.541464186424973,
"months_activated": 12.21993397264581
},
"2026-Q3": {
"stock": 841883.0,
"oems": 28,
"invoiced_per_month": 77004.66666666667,
"activated_per_month": 85343.33333333333,
"months_invoiced": 10.93288285558451,
"months_activated": 9.864660391360388
}
},
"k2_1_cover_summary": {
"latest": {
"stock": 841883.0,
"oems": 28,
"invoiced_per_month": 77004.66666666667,
"activated_per_month": 85343.33333333333,
"months_invoiced": 10.93288285558451,
"months_activated": 9.864660391360388
},
"peak_q": "2025-Q3",
"run_rate_per_quarter": -0.6526901548665265,
"pace_needed_per_quarter": -1.6442942851948363,
"quarters_remaining": 3,
"activation_share_oem_known": 0.9289203885990259,
"activated_vs_invoiced_ratio_latest": 0.9022927000742103,
"peak": {
"stock": 1284416.0,
"oems": 26,
"invoiced_per_month": 83561.66666666667,
"activated_per_month": 71746.66666666667,
"months_invoiced": 15.370875800307157,
"months_activated": 17.902099981416093
}
},
"k4_pace_needed_pts_per_month_v11": 0.3850565722926117
}