The Omni dashboard shows 11,046 paying partners, but you returned 11,172 (a difference of 126). What could explain the difference? Which snapshot date did you use, and how does your paying partner definition and filters compare to the governed Paying Partners metric in Omni?
Basis: Paying partners under Omni’s Prepare-paid definition versus partners paid on any Dext product, with, snapshot of the latest available date. Governed filters applied. Every row's «Unclassified Product Difference» came back as 0. That is usually a wrong segment filter rather than a real zero.
Per-step detail — each LLM call, each Omni request, each rejected draft —
is traced to stdout only and is not stored, so it cannot be shown here.
Query attempts counts run_query executions, not model turns.
WITH partner_booking_rows AS (
SELECT
omni_dbt__eds_calendar_day."DATE_DAY" AS "Snapshot Date",
omni_dbt__eds_all_accounts."DERIVED_ACCOUNT_ID" AS "Partner Account ID",
omni_dbt__eds_bookings."PRIMARY_KEY" AS "Booking Primary Key",
MAX(omni_dbt__eds_bookings."HAS_PAID_SUBSCRIPTION") AS "Has Any Paid Subscription",
MAX(omni_dbt__eds_bookings."HAS_PREPARE_PAID_SUBSCRIPTION") AS "Has Prepare Paid Subscription",
MAX(omni_dbt__eds_bookings."HAS_PRECISION_PAID_SUBSCRIPTION") AS "Has Precision Paid Subscription",
MAX(omni_dbt__eds_bookings."HAS_COMMERCE_PAID_SUBSCRIPTION") AS "Has Commerce Paid Subscription"
FROM PROD."EDS_ALL_ACCOUNTS" AS omni_dbt__eds_all_accounts
INNER JOIN PROD."EDS_CALENDAR_DAY" AS omni_dbt__eds_calendar_day
ON omni_dbt__eds_calendar_day."DATE_DAY" >= omni_dbt__eds_all_accounts."VALID_FROM" AND omni_dbt__eds_calendar_day."DATE_DAY" <= omni_dbt__eds_all_accounts."VALID_TO"
LEFT JOIN PROD."EDS_BOOKINGS" AS omni_dbt__eds_bookings
ON omni_dbt__eds_all_accounts."DERIVED_ACCOUNT_ID" = omni_dbt__eds_bookings."DERIVED_ACCOUNT_ID" AND omni_dbt__eds_calendar_day."DATE_DAY" >= omni_dbt__eds_bookings."VALID_FROM" AND omni_dbt__eds_calendar_day."DATE_DAY" <= omni_dbt__eds_bookings."VALID_TO"
WHERE omni_dbt__eds_calendar_day."IS_LATEST_AVAILABLE_DATE" = TRUE
AND omni_dbt__eds_all_accounts."FINANCE_ACCOUNT_TYPE" = 'Accountant'
AND COALESCE(omni_dbt__eds_all_accounts."IS_DEXT_DEMO", FALSE) = FALSE
AND omni_dbt__eds_all_accounts."FRANCHISE_NAME" IS NULL
AND (omni_dbt__eds_all_accounts."SALESFORCE_ACCOUNT_TYPE" != 'Reseller' OR omni_dbt__eds_all_accounts."SALESFORCE_ACCOUNT_TYPE" IS NULL)
GROUP BY
omni_dbt__eds_calendar_day."DATE_DAY",
omni_dbt__eds_all_accounts."DERIVED_ACCOUNT_ID",
omni_dbt__eds_bookings."PRIMARY_KEY"
),
partner_snapshot AS (
SELECT
"Snapshot Date" AS "Snapshot Date",
"Partner Account ID" AS "Partner Account ID",
MAX(CASE WHEN "Has Any Paid Subscription" = TRUE THEN 1 ELSE 0 END) AS "Has Any Paid Subscription",
MAX(CASE WHEN "Has Prepare Paid Subscription" = TRUE THEN 1 ELSE 0 END) AS "Has Prepare Paid Subscription",
MAX(CASE WHEN "Has Precision Paid Subscription" = TRUE THEN 1 ELSE 0 END) AS "Has Precision Paid Subscription",
MAX(CASE WHEN "Has Commerce Paid Subscription" = TRUE THEN 1 ELSE 0 END) AS "Has Commerce Paid Subscription"
FROM partner_booking_rows
GROUP BY "Snapshot Date", "Partner Account ID"
)
SELECT
MAX("Snapshot Date") AS "Snapshot Date",
COUNT(DISTINCT CASE WHEN "Has Prepare Paid Subscription" = 1 THEN "Partner Account ID" END) AS "Omni Paying Partners",
COUNT(DISTINCT CASE WHEN "Has Any Paid Subscription" = 1 THEN "Partner Account ID" END) AS "All Product Paying Partners",
COUNT(DISTINCT CASE WHEN "Has Any Paid Subscription" = 1 AND "Has Prepare Paid Subscription" = 0 THEN "Partner Account ID" END) AS "Difference Excluding Prepare",
COUNT(DISTINCT CASE WHEN "Has Any Paid Subscription" = 1 AND "Has Prepare Paid Subscription" = 0 AND "Has Precision Paid Subscription" = 1 AND "Has Commerce Paid Subscription" = 0 THEN "Partner Account ID" END) AS "Precision Only Difference",
COUNT(DISTINCT CASE WHEN "Has Any Paid Subscription" = 1 AND "Has Prepare Paid Subscription" = 0 AND "Has Precision Paid Subscription" = 0 AND "Has Commerce Paid Subscription" = 1 THEN "Partner Account ID" END) AS "Commerce Only Difference",
COUNT(DISTINCT CASE WHEN "Has Any Paid Subscription" = 1 AND "Has Prepare Paid Subscription" = 0 AND "Has Precision Paid Subscription" = 1 AND "Has Commerce Paid Subscription" = 1 THEN "Partner Account ID" END) AS "Precision and Commerce Difference",
COUNT(DISTINCT CASE WHEN "Has Any Paid Subscription" = 1 AND "Has Prepare Paid Subscription" = 0 AND "Has Precision Paid Subscription" = 0 AND "Has Commerce Paid Subscription" = 0 THEN "Partner Account ID" END) AS "Unclassified Product Difference"
FROM partner_snapshot
LIMIT 1
No feedback linked to this request.
Cost is the LLM completion spend LiteLLM priced for each call, summed per
request.
Chandler is running on the Codex CLI, which draws ChatGPT plan quota
rather than per-token API billing, so this figure is not money paid —
it is what the same traffic would have cost on the API, priced from the
token counts Codex reports. Read it as the size of the bill avoided.
Two known limits: embedding spend is not recorded, so
retrieval and matching cost is missing, and because the figure is one sum
per request it cannot be split by model within a request — a
request's classifier and agent calls can use different models while
llm_model holds only one name.
Only authenticated calls are logged, USAGE_LOG_ENABLED can
switch logging off, and log writes are fail-soft — this is not a complete
record of traffic. Questions are grouped into sessions: a session is
exact when the caller echoed its id back to us and otherwise inferred from
a 30-minute gap in that user’s activity, so a grouping is only as
good as the source shown on the session itself. A call with no
attributable user gets no session at all; those questions are listed
separately rather than dropped.