get_azadea_report
ChatGPTPrimary report router for Azadea One. Preserve the user's full question and explicit dates. Commercial sales, actual-vs-budget, original/FQ2 reforecast and ecommerce-versus-stores questions route to the governed business_performance service, not advertising campaign revenue or legacy mono-only Trading parity. It serves net actuals, separate gross diagnostics, Original/FQ1/FQ2 net budgets, mono/marketplace scope, web sessions and physical-store visits by brand/division/market/month with source and partial-coverage evidence. FQ2 is a planning version, not a calendar-quarter filter. Use reportKind=measurement_readiness to evaluate the 33-question product registry against scoped current evidence; it does not certify missing joins or causal studies. Use domain=ecommerce for specialist ecommerce reports, domain=offline_retail for specialist physical-store reports, and domain=marketing_budget only for explicit Marketing Budget Operations/spend tracker questions. CRM, Customer Analytics and executive strategy retain dedicated governed sources and permissions. Never substitute ad-attributed revenue for commercial sales or answer from the catalog alone.
get_budget_overview
ChatGPTReturns read-only aggregate Marketing Budget Operations/spend tracker metrics, including totals and breakdowns by market, brand, channel, and sub-channel. Use this only when the user explicitly asks about Marketing Budget Operations, spend-form, spend tracker, or budget control-plane data. For ecommerce, offline, or digital-marketing actual-vs-budget questions use get_performance_budget_actuals. This tool never creates, updates, deletes, or submits budget rows.
get_business_performance_report
ChatGPTGoverned overall-business net sales versus Original and FQ2 reforecast budgets across ecommerce and physical stores, with optional marketing spend/plan. Groups by division, brand, market and month. Existing finance/commercial sources take precedence; workbook history fills only exact uncovered metrics and full historical months. Sessions are web/app traffic; storeVisits are physical-store footfall. ecommerceScope=total includes mapped mono and marketplace components without adding parent totals twice. Gross ecommerce diagnostics are separate from net Finance plans. Requires Performance Marketing and Budget access, and binds division-limited accounts before querying. Unknown filters fail closed. This tool is read-only, has no campaign execution, and never uses advertising-attributed revenue as sales. Dates must be explicit; FQ2 is a planning version rather than a calendar-quarter range.
get_crm_detailed_analysis
ChatGPTReturns aggregate CRM dashboard slices across requested dimensions such as channel, brand, market, campaign, delivery type, creator, day, hour, and month. Use dayOfWeek/hourOfDay with openRate, adjustedOpenRate, readRate, impressionRate, or primaryRate for send-time analysis.
get_crm_detailed_analysis
ChatGPTReturns aggregate CRM dashboard slices across channel, workspace, brand, division, market, campaign, campaign status, flow/journey, delivery type, creator, sent day/hour, and month. Use campaignStatus or flow for journey inventory and historical campaign-calendar analysis. Sent-date dimensions describe observed activity only; they do not prove future scheduling.
get_crm_overview
ChatGPTReturns aggregate CRM campaign metrics for Email, SMS, App Push, and WhatsApp without exposing customer-level rows.
get_crm_overview
ChatGPTReturns aggregate CRM campaign metrics for Email, SMS, App Push, and WhatsApp without exposing customer-level rows. Campaign status and flow ID/name filters are supported when present in the governed source. Calendar semantics are historical sent activity, not unconfirmed future plans.
get_customer_analytics_analysis
ChatGPTQueries the same active certified release and page models used by the live Customer Analytics dashboards. Use business_overview for business KPIs; customer_insights for one classification section; reachability for database coverage; customer_classification for active/inactive and lifecycle classification; value_groups for value segments; customer_affinity for cross-brand affinity; product_direction for category/subcategory performance and affinity; e_receipts for receipt penetration plus aggregate fraud evidence; omnichannel for channel scope; and crm_channel only for the separate historical QBR cache. The tool never exposes raw customers, profiles, events, transaction IDs, fraud-customer detail, or free-form SQL.
get_customer_analytics_detailed
ChatGPTReturns masked aggregate Customer Analytics slices across requested dimensions such as brand, market, segment, lifecycle stage, channel, source, event, and cohort month.
get_customer_analytics_detailed
ChatGPTReturns exact-period aggregate Customer Analytics slices by day, workspace, brand, market, division, value segment, channel, source, or cohort month. Customer counts are exact within each group but non-additive across groups. Unsupported lifecycle/event metrics are returned as unavailable rather than guessed.
get_customer_analytics_overview
ChatGPTReturns masked aggregate Customer Analytics metrics from approved BigQuery serving views. No customer identifiers or raw profile/event rows are returned.
get_customer_analytics_overview
ChatGPTReturns exact-period aggregate Customer Analytics revenue, transactions/orders, units, distinct active customers, repeat customers, AOV, UPT, and revenue per customer from the certified partitioned Customer Insights fact. Overlapping source transactions are deterministically deduplicated, period ratios are recomputed from totals, and no identifiers or raw rows are returned.
get_ecommerce_business_analysis
ChatGPTUse this specialist tool for ecommerce finance/net sales, cancelled-order counts and cancelled units, returns, fulfillment operations, out-of-stock, current inventory, SKU/product funnel, category performance, coupons, retention, and Decathlon e-receipts. For a cancellation question, always select subject=cancellations instead of filtering get_ecommerce_overview or get_ecommerce_detailed by order status. Cancellation counts come from the published per-storefront feeds; cancellation reason is unavailable in those sources and is never guessed. Product-funnel country is visitor geography, category reporting defaults to one L1 hierarchy, and category order/customer occurrences are non-additive across categories. Fulfillment currently uses a manually materialized historical snapshot; inspect sourceStatus and coverage.requestedWindowStatus, and never interpret an uncovered current-period zero as confirmed activity. Results are aggregate-only. Raw tables, customer/order/email identifiers, and free-form SQL are never exposed.
get_ecommerce_cancellations
ChatGPTUse this dedicated tool for every ecommerce cancellation question, including how many orders or units were cancelled and cancellation breakdowns by brand, market, storefront/source, platform, language, city, price group, SKU, or day. It always queries the governed published per-storefront cancellation feeds and cannot be redirected to finance or the commercial order-status dataset. Cancellation reasons are unavailable in the source and are never guessed. Results are aggregate-only; order references are used only internally for COUNT DISTINCT and are never returned.
get_ecommerce_detailed
ChatGPTReturns aggregate ecommerce commercial slices across requested dimensions such as division, brand, market, channel, platform, source, category, day, store, order status, and fulfillment status. Use this for sales, orders, revenue, sessions, customers, payment/category/channel performance, and dashboard KPI breakdowns. Do not use this for warehouse pick, SLA, terminal rejection, or fulfillment lead-time questions.
get_ecommerce_detailed
ChatGPTCommercial gross-sales breakdown tool only. Do not use this tool to answer finance/net-sales, cancelled-order counts or cancelled units, returns, fulfillment, OOS, inventory, product funnel, category, coupon, retention, or e-receipt questions; call get_ecommerce_business_analysis with the matching required subject instead. orderStatus here only segments the commercial gross-sales dataset and is not the published per-storefront cancellation feed. Returns aggregate ecommerce commercial slices across day, division, brand, market, source, platform, paymentMethod, and orderStatus using brand dashboard gross-sales actuals plus the governed FY26 daily USD ecommerce budget snapshot shared with Performance Hub. salesBudget, variance, and attainment are comparable only for day, brand, market, and division breakdowns without source/platform/payment/order-status filters; unsupported grains return null budget rather than allocating or guessing. A zero budget returns null attainment and missing or partial coverage is null. Keep ecommerce gross revenue and offline converted-USD revenue separate.
get_ecommerce_overview
ChatGPTReturns aggregate ecommerce commercial metrics such as revenue, orders, sessions, customers, units, AOV, conversion rate, category, channel, platform, market, and brand from approved BigQuery serving views. Use this for sales, orders, sessions, customers, payment/category/channel performance, and dashboard KPI questions. Do not use this for warehouse pick, SLA, terminal rejection, or fulfillment lead-time questions.
get_ecommerce_overview
ChatGPTCommercial gross-sales dashboard tool only. Do not use this tool for finance/net sales, cancelled-order counts or cancelled units, returns, fulfillment, OOS, inventory, product funnel, category, coupons, retention, or e-receipts; call get_ecommerce_business_analysis with the matching subject instead. Returns aggregate ecommerce commercial metrics from brand dashboard gross-sales actuals plus the governed FY26 Azadea.com and Dot.com daily gross-sales budget snapshot shared with Performance Hub. Commercial actuals remove exact overlapping order lines across standalone and consolidated sources. Sales budget metrics include salesBudget, salesBudgetVariance, and salesBudgetAttainment alongside revenue, orders, customers, units, AOV, unitsPerOrder, and revenuePerCustomer. A zero salesBudget returns null attainment as N/M, and missing or partial budget coverage is null. Budget is comparable at total/day/brand/market/division grain, but not when source, platform, payment-method, or order-status filters are applied. Never label ecommerce gross revenue plus offline converted-USD revenue as certified combined, consolidated, or net sales; any addition is only an arithmetic channel sum with differing KPI and market coverage. Use this for ecommerce gross sales, sales budget, total orders, customers, units, payment/platform/market/brand dashboard KPI questions.
get_executive_strategy_report
ChatGPTBuilds a governed cross-domain evidence pack for strategy questions using current and annual ecommerce/offline commercial evidence, all seven governed Customer Analytics subjects, CRM status/flows, Performance Marketing, and budget data according to the actor's page permissions. It returns an email-requirement evidence map plus explicit unavailable requirements for live websites, future expansion, future calendars/events, and unsupported initiative spend instead of inventing them.
get_gateway_readiness
ChatGPTReturns the pilot readiness checklist, enabled auth modes, and current governed source status.
get_gateway_readiness
ChatGPTReturns the pilot readiness checklist, enabled auth modes, current governed source status, and compact five-value filter samples.
get_marketing_detailed_analysis
ChatGPTReturns aggregate Performance Marketing dashboard slices across requested dimensions such as brand, market, source, platform, campaign, day, month, and quarter.
get_marketing_detailed_analysis
ChatGPTReturns aggregate Performance Marketing dashboard slices across requested dimensions such as brand, market, source, platform, campaign, day, month, and quarter.
get_marketing_overview
ChatGPTReturns aggregate Performance Marketing metrics for a governed date window and optional filters.
get_marketing_overview
ChatGPTReturns Assembly advertising/marketing KPI actuals for a governed date window and optional filters. Its attributed revenue is NOT store sales or ecommerce Finance net sales. For commercial sales/budget questions use get_business_performance_report or default get_performance_budget_actuals.
get_offline_retail_detailed
ChatGPTReturns governed aggregate physical-store breakdowns by day, brand, market, country, division, or store. canonical returns converted-USD revenue plus FY26 monthly-paced salesBudget, salesBudgetVariance, and salesBudgetAttainment at day, brand, market/country, and division grain. Budget is null for store breakdowns, store-filtered requests, and boggi_operational because the governed budget has no such grain. Every row includes distinct storeCount; orders, units, visits, conversion, AOV, and UPT remain available.
get_offline_retail_overview
ChatGPTReturns governed aggregate physical-store metrics, including converted-USD revenue, FY26 monthly-paced salesBudget, salesBudgetVariance, salesBudgetAttainment, and distinct storeCount. Offline budget is comparable only for source=canonical without store filters. source=boggi_operational returns complete Boggi daily coverage across AE, BH, EG, IQ, JO, KW, LB, and QA with sourceRevenue/sourceAov explicitly source-native and budget metrics null. No customer-level or transaction-level rows are exposed.
get_operations_fulfillment_detailed
ChatGPTReturns governed aggregate Business Central / ecommerce fulfillment operations analysis only for pick requests, pick request statuses, terminal rejection, rejection reasons, cross-docking/order type, store versus warehouse processing, SLA, and lead-time questions. Do not use this for normal ecommerce sales, revenue, orders, sessions, customers, payment, category, or channel KPI questions. No raw order, customer, or warehouse rows are exposed.
get_performance_budget_actuals
ChatGPTReturns the exact dashboard-parity live Performance Marketing Actual vs Budget payload by default: ecommerce Finance net actuals and the matching Trading Sales Budget, all-store offline actuals and eligible FQ2 budget, plus Assembly digital-marketing actual and eligible FQ2 marketing budget. It also keeps Trading gross/net sales, Trading web sessions/CVR and Assembly sessions/attributed CVR in separately labelled metric families. The default comparison is the identical calendar dates last year; previous-period and custom comparison are explicit options. It supports the dashboard's brand, market, source, division, platform, campaign, language, trading-month, year, scope and date filters. Use reportingBasis=business only when the separately governed overall-business report is explicitly required; that mode is independently release-gated and does not accept campaign/platform/source filters. Both modes require Performance Marketing plus Budget access. Read-only; no budget writes.
list_governed_datasets
ChatGPTLists approved Azadea data domains, their access status, PII posture, and serving source.
list_governed_datasets
ChatGPTLists approved Azadea data domains, access status, freshness, supported metrics, and bounded filter-value samples. Use domain report tools for actual KPI answers.
