-
Which fields in our Omni model represent each of these account signals? For each, give me the exact field path (model.view.field) and what value(s) indicate "true":
1. Whether an account is on a plan that includes Core Agents / AI Assist by default (i.e. Core Agents license present)
2. Whether an account has ever started an AI Assist trial (trial start date, trial active/expired flag)
3. Whether an account is currently a paid AI Assist customer (has a paid AI Assist add-on)
4. Whether an account has ever used LIX free credits (LIX free credits consumed > 0 at any point)
5. Whether an account currently purchases LIX bundles (active LIX bundle purchase)
Don't return data rows — I only need the field paths and the truthiness rule for each.
No answer recorded.
-
Cohort: accounts that currently have a paid AI Assist / Agents add-on (paid AI Assist customers), excluding Dext demos and Reseller accounts. Return one row per account with: account CRN, account name, Salesforce country. No aggregation.
No answer recorded.
-
How many active accounts today have an AI Assist / Agents add-on (i.e. ai_assist_client_limit > 0)? Exclude Dext demos and Reseller accounts. I need the count. Please execute the query.
No answer recorded.
-
How many accounts have ever started an AI Assist trial (i.e. have an AI Assist trial start date, or an ai_assist_trial_started flag = true)? Please execute the query. Exclude Dext demos and Reseller accounts.
No answer recorded.
-
Do we track AI Assist / Agents trials as a distinct concept from paid AI Assist? For example: is there an ai_assist_trial_active flag, an ai_assist_trial_start_date, a subscription tier that means "on trial", or a license type value like "trial"? I need to know the field name and how to identify accounts currently on an AI Assist trial vs accounts that have ever started one. Please describe the concept — I don't need data rows, just the field(s) and their values.
No answer recorded.
-
Two related questions on our booking / subscription model:
1) Is there any way at all to identify accounts currently on an AI Assist trial vs paid, even indirectly? For example: a subscription_tier value, a license_type value, an is_trial flag on the AI Assist booking, or ai_assist_contract_client_limit > 0 combined with something like has_paid_subscription = false. Just tell me the field/logic — no data rows needed.
2) Is there a "Core Agents license" concept? I.e. plans that include Agents / AI Assist by default (not as a paid add-on) — some product feature bundle flag on the plan or account.
No answer recorded.
-
Which fields in our model track LIX usage at the account level? Specifically: LIX credits consumed (lifetime, or in a period), whether an account has ever used free LIX credits, whether an account currently has an active LIX bundle purchase. I need field paths only. If there's a topic dedicated to LIX / credit consumption, name it.
No answer recorded.
-
Please execute a query: how many accounts consumed at least one LIX credit (Line Item Extraction) in the last 90 days? Just give me the count. If LIX is not in the model, say so plainly.
No answer recorded.
-
Please execute this query. Return one row per account: accounts that currently have a paid AI Assist / Agents add-on (ai_assist_contract_client_limit > 0) AND currently purchase a LIX bundle (i.e. have an active LIX bundle subscription today). Columns per row: account_crn, account_name, salesforce_country. Exclude Dext demos, exclude Reseller accounts, exclude suspended accounts. Use the latest available snapshot date.
No answer recorded.
-
Give me the list of accounts today where BOTH conditions hold: eds_bookings.ai_assist_contract_client_limit > 0 AND the account has a currently-active LIX bundle purchase (any positive LIX bundle MRR or LIX bundle contract value on the latest snapshot). Return account_crn, account_name, salesforce_country. Exclude dext demos, resellers, suspended accounts. Use is_latest_available_date = true.
No answer recorded.
-
Count of accounts today where ai_assist_contract_client_limit > 0 AND there is at least one active LIX bundle. Exclude demos, resellers, suspended. Just the count.
No answer recorded.
-
How many paid AI Assist customers are also currently buying LIX bundles?
No answer recorded.
-
How many paid AI Assist customers have never used any LIX (Line Item Extraction) lines — i.e. lifetime LIX line volume is zero?
No answer recorded.
-
Among current paid AI Assist customers, how many have zero total LIX line volume?
No answer recorded.
-
How many paid AI Assist customers have ever extracted any LIX lines (total_lix_line_volume > 0)? Then also give me: of paid AI Assist customers, how many have total_lix_line_volume = 0? Two counts.
No answer recorded.
-
2026-08-06 10:15
generate
internal_error
$0.7379
162.2 s
full detail →
Generate a query that returns account_crn, account_name, salesforce_country for accounts where eds_bookings.ai_assist_contract_client_limit > 0 AND account_lix_metrics_dynamic.total_lix_line_volume = 0 AND eds_bookings.lix_contract_bundle_applied = false. Use is_latest_available_date = true. Exclude is_dext_demo = true, exclude salesforce_account_type = Reseller, exclude is_suspended_dext = true.
Error calling tool 'generate': Failed to produce a valid Omni query after 16 iterations. Active topic: Analytics/Product Usage - Accounts. Last error: blocked: field(s) omni_dbt__eds_all_accounts.account_name contain personal information (name/email/phone/address) and cannot be queried
-
Return distinct account_crn and salesforce_country for accounts where ai_assist_contract_client_limit > 0 AND lix_contract_bundle_applied = true, using is_latest_available_date = true, excluding is_dext_demo, salesforce_account_type = Reseller, and is_suspended_dext. One row per account. Sort by salesforce_country then account_crn.
No answer recorded.
-
Return distinct account_crn and salesforce_country for accounts where ai_assist_contract_client_limit > 0 AND lix_contract_bundle_applied = false AND account_lix_metrics_dynamic.total_lix_line_volume = 0. Use is_latest_available_date = true. Exclude is_dext_demo, salesforce_account_type = Reseller, is_suspended_dext. One row per account. Sort by country then CRN.
No answer recorded.