-
What's the direct net churn MRR for direct for the last 6 months?
No answer recorded.
-
What is the definition of Churn vs Contraction in basic_dext_bookings_mrr_movement?
No answer recorded.
-
What is "Prepare Monthly ACV Movement | Breakdown (platform, product churn+ winback)" report and what is "prepare change amount" field? How do they differ from basic_dext_bookings_mrr_movement and total_dext_bookings_mrr_change_amount?
No answer recorded.
-
Which partner has the most client accounts under them?
No answer recorded.
-
Count distinct client accounts grouped by dext_partner_name, sorted descending, top 10 partners
No answer recorded.
-
Show me the top 10 partners by total number of distinct client accounts attached to them
No answer recorded.
-
What are the account names for these account CRNs: 7401176876, 7461178285, 7271754453, 7223085351, 7133303439, 7161926000, 8204041696, 7372852425, 7261619341, 7181905000
No answer recorded.
-
Top 10 partners by total distinct client accounts attached, showing partner account name and CRN
No answer recorded.
-
Show top 10 partners by parent_all_accounts.account_name and account_crn, ranked by total_clients descending
No answer recorded.
-
Give me the partner that has the most client accounts under them and classify them by supplier rules usage
No answer recorded.
-
Which partner has the most client accounts under them, and can you classify those accounts by supplier rules usage?
No answer recorded.
-
For partner accounts (finance_account_type = 'Accountant'), find the parent account relationship linking client accounts (finance_account_type = 'Corporate') to their parent partner account. Rank partner accounts by number of distinct client accounts under them (show account_id and count), for the top partners. Also for each of those top partners' client accounts, compute supplier rules usage = (count of submissions autocategorized by supplier rule + count of submissions autopublished by supplier rule) / count of all submissions.
No answer recorded.
-
For partner accounts with CRN 7401176876, 7461178285, 7271754453, 7223085351, 7133303439, 7161926000, 8204041696, 7372852425, 7261619341, 7181905000, calculate supplier rules usage across their client accounts, defined as (count of submissions autocategorized by supplier rule + count of submissions autopublished by supplier rule) divided by count of all submissions. Show one row per partner account CRN.
No answer recorded.
-
Supplier rules usage rate by partner account CRN for top partners 7401176876, 7461178285, 7271754453, 7223085351, 7133303439: (autocategorized by supplier rule submissions + autopublished by supplier rule submissions) / all submissions
No answer recorded.
-
How is ARR attribution defined for mobile app accounts (Android App, iOS App account_source)? Is it first-touch attribution based on where the user signed up, with activation tied back to the app regardless of whether activation happens on web or in-app?
No answer recorded.
-
Top 10 partner accounts (finance_account_type = 'Accountant') ranked by number of engaged client accounts (finance_account_type = 'Corporate') in the last 90 days. Show partner account CRN and count of engaged clients.
No answer recorded.
-
How many self-paying partner client accounts do we have overall?
No answer recorded.
-
How many self-paying client accounts (finance_account_type = 'Corporate', has paid subscription) do NOT have a Dext parent (has_dext_parent = false)?
No answer recorded.
-
Top 10 self-paying client accounts (finance_account_type = 'Corporate', has paid subscription, has_dext_parent = false) ranked by highest MRR. Show account_id/CRN and MRR.
No answer recorded.
-
Top 10 corporate client accounts with a paid subscription, ranked by highest MRR (prepare_bookings_mrr), across both self-paying clients under a partner (has_dext_parent = true) and standalone clients with no parent (has_dext_parent = false). Show account CRN, has_dext_parent flag, and MRR.
No answer recorded.
-
Top 10 corporate client accounts with paid subscription and has_dext_parent = true, ranked by highest prepare_bookings_mrr. Show account CRN and MRR.
No answer recorded.
-
Top 10 standalone corporate accounts (no dext parent) with paid subscription, by prepare_bookings_mrr
No answer recorded.
-
Top 10 standalone corporate accounts (no dext parent) with paid subscription, ranked by prepare_bookings_mrr in GBP. Show account CRN and MRR in GBP.
No answer recorded.
-
Top 10 corporate client accounts with paid subscription and has_dext_parent = true, ranked by highest prepare_bookings_mrr in GBP. Show account CRN and MRR in GBP.
No answer recorded.
-
Which standalone corporate client account (has_dext_parent = false, paid subscription) has the highest engagement? Show account CRN and the engagement metric used.
No answer recorded.
-
Top standalone client account (no dext parent, paid subscription) by engagement, single top result with CRN
No answer recorded.
-
How is client engagement measured or defined? What is the documented definition of an engaged client?
No answer recorded.
-
Top standalone corporate client account (has_dext_parent = false, paid subscription) ranked by count of qualifying engaged actions in the last 90 days. Show account CRN and count of engaged actions.
No answer recorded.
-
For standalone corporate client accounts (has_dext_parent = false, paid subscription), count the number of distinct days in the last 90 days where the account was engaged (Is Engaged = true). Rank accounts by this day count descending, top 10, show account CRN and number of engaged days out of 90.
No answer recorded.
-
Standalone paid corporate accounts, count distinct engaged days in last 90 days, top 10 by days engaged
No answer recorded.
-
—
No answer recorded.