-
What does the metric NECE mean?
The metric **NECE** is not defined in the provided documentation. Please contact the Analytics team for its approved definition.
- **Definition available:** No
- **AI warning:** This answer was generated by AI and should be double-checked.
-
What is NECE and how has it changed over the last 6 complete months (monthly)?
NECE is not defined in the provided documentation, and no corresponding field or view is available. Therefore, I cannot explain the metric or calculate its monthly change without inventing a definition. Please contact the Analytics team for the authoritative definition and data source.
- **Metric definition:** Not documented
- **Monthly results:** No data available
- **Intended period:** March–August 2026, the last six complete months
- **Required information:** NECE definition and its source field/view
**Warning:** This answer was generated by AI and should be double-checked.
-
—
No answer recorded.
-
How has NECE changed over the last 6 complete months (monthly)?
Data answer — see full detail.
-
Give me the exact definition, description, and any filters/criteria for the NECE field as defined in Product Usage - Accounts.topic.yaml
The provided documentation does not include the **NECE** field or the contents of `Product Usage - Accounts.topic.yaml`, so its exact definition, description, and filters/criteria cannot be determined.
- **Missing:** NECE field-level description and AI context
- **Required source:** `Product Usage - Accounts.topic.yaml`
- **Next step:** Provide the relevant topic/field excerpt or contact the Analytics team.
**Warning:** This answer was generated by AI and should be double-checked.
-
—
No answer recorded.
-
—
No answer recorded.
-
—
No answer recorded.
-
How many engaged clients of type 'Solo' do we have?
Data answer — see full detail.
-
How many Solo-type clients have had usage in the last 90 days (active/engaged filter: number of days since last usage <= 90), using the same base filters as before (Corporate finance account type, has Dext parent, not demo, not suspended, not reseller)?
This cannot be calculated accurately from the provided documentation. The topic includes fields to identify Solo accounts and Corporate finance account type, but it does not document the required usage-recency measure or all requested base-filter fields. I will not approximate or substitute fields.
- **Result:** No count available
- **Available:** `intercom_user_accounts.hmrc_individual_id` identifies accounts that exist on Solo
- **Available:** `intercom_user_accounts.finance_account_type = 'Corporate'`
- **Missing:** Number of days since last usage, Dext-parent status, demo status, suspension status, and a documented reseller-exclusion field
- **Logic required:** Count Solo client accounts where days since last usage ≤ 90, after applying all listed base filters and the topic’s default filters
- **Next step:** Ask the Analytics team to provide the relevant usage field, account identifier, filter fields, joins, and topic default filters
Possible follow-ups:
- Which topic contains the documented “days since last usage” field?
- Can the Analytics team confirm the standard fields for demo, suspended, and reseller exclusions?
**Warning:** This answer was generated by AI and should be double-checked.
-
Using the eds_all_accounts topic (same as the Solo client count query), is there a field for days since last usage or last activity date? I want to filter Solo, Corporate finance-type accounts to only those active/used in the last 90 days.
The provided documentation does not list a “days since last usage,” “last activity date,” or exact 90-day engagement field in the `eds_all_accounts` view. Therefore, I cannot accurately define this filter using the available fields.
- **Solo count field:** `omni_dbt__eds_all_accounts.total_distinct_dext_solo_accounts`
- **Solo identifier counted:** `omni_dbt__eds_all_accounts.hmrc_individual_id`
- **Corporate filter:** `eds_all_accounts.finance_account_type = 'Corporate'`
- **Required activity window:** last **90 days**
- **Missing:** a documented activity-date field or exact “Is Engaged” field name in this topic
The model defines engagement as at least one qualifying action within 90 days, but the applicable field is not documented here. Please contact the Analytics team to confirm whether that field is available in **Product Usage - Users** and how it should be filtered.
**Warning:** This answer was generated by AI and should be double-checked.