|
SuiteBilling Renewal Pipeline & Churn Risk Dashboard
|
|
Using live NetSuite SuiteBilling data only, identify subscriptions renewing in the next 90 days. First inspect the available subscription, subscription line, customer, invoice, payment, and support-case record metadata; then query the required records. Do not generate sample data.
For each renewing subscription, return customer, subscription ID, subscription line, renewal date, ARR, MRR, auto-renewal status, outstanding or overdue invoice balance, and support-case count in the prior 90 days.
Calculate churn risk using this rule: High = payment issue + 3 or more support cases + auto-renewal disabled; Medium = auto-renewal disabled or 1-2 recent support cases; Low = no risk factors. State when a source field is unavailable rather than inferring it.
Provide: (1) total renewals and pipeline ARR, (2) at-risk ARR and high-risk count, (3) a monthly renewal timeline, (4) the 10 highest-risk subscriptions, and (5) a prioritized action list for the next 7 and 30 days. Include the retrieval date, report scope, and all assumptions. Do not update any subscription or customer records.
|