data key and respond with a data envelope.
Indicator categories
Sales Metrics
Track revenue totals, payment method distribution, ticket sell-through rates, and platform-wide statistics. Includes per-client sales breakdowns.
Office Metrics
Analyze ticket sales and revenue by office (taquilla), compare active vs inactive offices per event, and report on USB/offline device sales.
All indicator functions
| Function | Data source | What it measures |
|---|---|---|
total_sales | orders_transactions (PostgreSQL) | Total revenue grouped by date, with optional event and date filters |
total_sales_client | orders_transactions (PostgreSQL) | Total revenue per client, grouped by date |
money_distribution | orders_payout (PostgreSQL) | Revenue split across payment methods (custody accounts) for an event |
number_tickets_vs_sold | Firestore + orders (PostgreSQL) | Allocated seat count vs sold ticket count with percentage |
number_tickets_sold | orders (PostgreSQL) | Raw count of sold tickets with optional event and date filters |
general_platform_data | Firestore | Total counts of events, offices, collaborators, and clients across the platform |
types_of_collaborators | Firestore | Count of collaborators broken down by account type |
sold_by_office | orders (PostgreSQL) | Tickets sold and revenue per office/taquilla |
offices_vs_offices_active | Firestore | Total offices vs active offices assigned to a specific event |
sold_by_usbs | orders_transactions (PostgreSQL) | Revenue from USB/offline devices, broken down by office and currency |
Common filter parameters
Most indicator functions accept the same set of optional filters applied as SQLWHERE conditions against the PostgreSQL tables.
| Parameter | Type | Description |
|---|---|---|
event_id | string | Restrict results to a single event |
from | string (YYYY-MM-DD) | Include records from this date onward (date_created >= from) |
to | string (YYYY-MM-DD) | Include records up to and including this date (date_created <= to) |
client_id | string | Used by total_sales_client to filter by client |
All date comparisons cast the
date_created timestamp column to DATE before comparing. Pass dates as YYYY-MM-DD strings.