-
What is our ARR (Annual Recurring Revenue) for the last 12 months, broken down month over month?
I cannot calculate monthly ARR for the last 12 months from the supplied documentation. ARR is defined as **MRR × 12**, but no total MRR or ARR field is available; the documented MRR measures only cover previous add-on bookings before a customer-support-related change, so using them would understate and misrepresent company ARR.
- **Result:** No data available
- **Missing:** A total customer MRR or ARR measure in a topic joined to `omni_dbt__eds_calendar_day.date_day`
- **Required logic:** Filter the last 12 months using `date_day`, select month-end records with `is_last_day_of_month = true`, then report ARR by month
- **Possible follow-ups:**
- Which topic contains Dext’s total MRR or ARR measure?
- Can ARR be split between Partners and Direct accounts?
**Warning:** This answer was generated by AI and should be double-checked with the Analytics team.
-
What is our total MRR (Monthly Recurring Revenue) month over month for the last 12 months?
I cannot calculate total MRR month over month from the provided documentation. The only MRR measure available is **Previous Landlord MRR**, which represents Landlord Bookings MRR before a change—not total company MRR. The documented month fields relate to signed documents and cannot accurately time-series MRR.
- **Timeframe requested:** Last 12 months, monthly
- **Missing:** A total MRR measure and an applicable calendar month/date field in the same topic
- **Not substituted:** `total_last_period_landlord_bookings_mrr`, to avoid an inaccurate result or double counting
- **Next step:** Contact the Analytics team to identify the appropriate total MRR field and topic
Warning: This answer was generated by AI and should be double-checked.
How did I do with this report?
-
What is our ARR (Annual Recurring Revenue) year over year for the last 3 years?
I cannot calculate ARR year over year for the last three years from the provided documentation. ARR is defined as **MRR × 12**, but no current MRR or ARR field is documented. The only revenue measure provided is **Previous Landlord MRR**, which is limited to landlord add-on changes and cannot accurately represent total ARR.
- **Result:** No data available
- **Required:** A documented total MRR or ARR measure, plus the calendar date field needed to compare three annual periods
- **Time logic:** Dext’s financial year runs **May–April**; a period-based comparison should use explicit date ranges
- **Next step:** Contact the Analytics team to identify the appropriate ARR field and topic
Possible follow-ups:
- Which documented topic contains total customer MRR or ARR?
- Should the comparison use Dext financial years or calendar years?
**Warning:** This answer was generated by AI and should be double-checked.
-
Total MRR by month for the last 12 months
Data answer — see full detail.
-
What is our NPS (Net Promoter Score) by month for the last 12 months?
Data answer — see full detail.
-
What is our NPS (Net Promoter Score) by month, for each month between September 2025 and August 2026?
Data answer — see full detail.
-
What is our Direct MRR by month for the last 12 months?
The documented fields are insufficient to calculate total Direct MRR by month accurately. The available Direct dashboard query measures **MRR change from channel transfers**, not total MRR, and the documentation does not confirm a monthly calendar join or the required Direct-account filters in the same topic.
- **Result:** No data can be produced from the supplied documentation
- **Direct definition:** Corporate accounts with a paid subscription
- **Required filters:** `eds_all_accounts.finance_account_type = 'Corporate'` and `eds_bookings.has_paid_subscription = true`
- **Required metric:** MRR, with `prepare_bookings_mrr` documented only for Prepare
- **Required monthly logic:** Filter `omni_dbt__eds_calendar_day.date_day` to the last 12 months and use month-end records via `is_last_day_of_month = true`
- **Missing:** A documented topic containing the MRR metric, Direct-account fields, calendar spine, valid joins, and default filters
Please contact the Analytics team to identify the appropriate monthly Direct MRR topic. **Warning: This answer was generated by AI and should be double-checked.**
Chandler is still young and makes mistakes in his calculations sometimes — reach out to the Data & Analytics team in #analytics-questions-and-alerts if you have questions.
-
Total Prepare Bookings MRR by month for the last 12 months, filtered to Direct accounts (Corporate finance account type with a paid subscription, excluding demo and reseller accounts)
Data answer — see full detail.
-
What is our ACV (Average/Annual Contract Value) by month for the last 12 months?
Data answer — see full detail.
-
What is Prepare Monthly ACV by month, for each month between September 2025 and August 2026?
Data answer — see full detail.
-
What is our total company revenue by month for the last 12 months?
Data answer — see full detail.
-
List distinct account_crn values where parent_account_crn = 7333782788 (filter only on parent_account_crn field, not account_crn) and snapshot date = 2026-04-23, sorted by account_crn descending
Data answer — see full detail.
-
Same query as before (account_crn where parent_account_crn = 7333782788, snapshot date 2026-04-23, sorted by account_crn descending) but return ALL rows, not truncated, and use exact equals match on parent_account_crn rather than starts_with
Data answer — see full detail.
-
Total Prepare Bookings MRR for Corporate accounts (excluding demo and reseller) for September 2025 and October 2025
I can’t calculate this accurately from the provided documentation because no field for **Prepare Bookings MRR** is documented, and the exact field/value needed to identify **reseller** accounts is not defined.
- **Periods requested:** September 2025 and October 2025
- **Known filters:** `finance_account_type = 'Corporate'`; exclude accounts using `is_dext_demo`
- **Missing:** Prepare Bookings MRR measure and documented reseller exclusion
- **Time logic:** A period-based query should filter `omni_dbt__eds_calendar_day.date_day` and should not use `is_latest_available_date`
Please contact the Analytics team to confirm the missing measure and reseller definition. **Warning: This answer was generated by AI and should be double-checked.**
-
Total Prepare Bookings MRR by month for each month between September 2025 and October 2025
Data answer — see full detail.
-
Return the field account_crn (not parent_account_crn) from omni_dbt__eds_all_accounts, filtered where parent_account_crn equals exactly 7333782788, and snapshot date is 2026-04-23. Sort by account_crn descending. Return up to 100 rows, not truncated to 10.
Data answer — see full detail.
-
Show account_crn for all child accounts whose parent_account_crn is 7333782788, as of snapshot date 2026-04-23. Order results by account_crn, descending. I need the account_crn column in the output, not parent_account_crn.
I can confirm the required fields and filters, but the documentation contains no account-level records or query results, so I cannot list the actual `account_crn` values.
- **Snapshot date:** `omni_dbt__eds_calendar_day.date_day = 2026-04-23`
- **Parent filter:** `omni_dbt__eds_all_accounts.parent_account_crn = 7333782788`
- **Output:** `omni_dbt__eds_all_accounts.account_crn`
- **Sort:** `account_crn` descending
- **Logic:** Select child accounts linked to the specified parent on the snapshot date, applying the topic’s default filters and preserving account-level grain to avoid duplicates.
Possible follow-ups:
- How many child accounts did this parent have on 2026-04-23?
- Which child accounts had a paid Prepare subscription on that date?
**Warning:** This answer was generated by AI and should be double-checked.
Chandler is still young and makes mistakes in his calculations sometimes — reach out to the Data & Analytics team in #analytics-questions-and-alerts if you have questions.
-
Total Prepare Bookings MRR for October 2025 only
I cannot calculate Total Prepare Bookings MRR for October 2025 from the provided documentation. The required Prepare Bookings MRR measure and a related bookings date field are not available; the documented measure is only **Previous Landlord MRR**, which cannot be substituted.
- **Requested period:** 1–31 October 2025
- **Missing:** Prepare Bookings MRR measure
- **Missing:** Applicable bookings date field
- **Result:** No data can be calculated accurately
Please contact the Analytics team for the required fields.
**Warning:** This answer was generated by AI and should be double-checked.
Chandler is still young and makes mistakes in his calculations sometimes — reach out to the Data & Analytics team in #analytics-questions-and-alerts if you have questions.
-
Total Prepare Bookings MRR by month for each month between October 2025 and November 2025
Data answer — see full detail.
-
List distinct account_crn values where parent_account_crn = 7333782788 (filter only on parent_account_crn field, not account_crn) and snapshot date = 2026-04-23, sorted by account_crn descending. Please return all 31 rows, not just the first 10.
Data answer — see full detail.
-
List all distinct account_crn values where parent_account_crn = 7333782788, snapshot date 2026-04-23, sorted by account_crn descending. Output field must be account_crn. There are 31 total rows - please output the full list of 31 account_crn values in your text answer, not just the first 10.
The documentation confirms that `account_crn`, `parent_account_crn`, and snapshot `date_day` are available, but it contains no underlying row values. Therefore, I cannot provide the requested 31 `account_crn` values.
- Required filters: `parent_account_crn = 7333782788`; `date_day = 2026-04-23`
- Output: distinct `account_crn`
- Sort: `account_crn` descending
- Missing: actual query results/data rows
Warning: This answer was generated by AI and should be double-checked.
-
List distinct account_crn values where parent_account_crn = 7333782788 (filter only on parent_account_crn field, not account_crn) and snapshot date = 2026-04-23, sorted by account_crn descending
Data answer — see full detail.