Ciro

Lists the values of a dimension, e.g. the organization's chains (retail_group_name), brands, categories, or the products and stores matching a search. Use it to get the exact spelling before filtering query_data with equals.

list_dimension_values

Lists every measure (metric) and dimension (breakdown) query_data accepts, grouped like Ciro's explorer, with labels, units and definitions, plus the organization's currency and today's date. Call it first when you don't know the exact field for a question.

get_data_catalog

Computes measures over the organization's sell-out (sales), stock and replenishment data, optionally broken down by dimensions and time. Returns a table with the exact date range covered. Examples: sales by chain last month → measures [total_net_sales, total_units_sold], dimensions [retail_group_name], date_range "last month". Monthly trend → time_granularity "month". Top 10 products → dimensions [product_name], order by the measure desc, limit 10. Stockouts → measures [stores_with_stockout, coverage_stockout] by product_name. Purchase suggestion → measures [suggested_units, suggested_money, current_doh] by retail_group_name or store_name. Stock measures always show the latest known stock, whatever the date range. Percentages come in points (12.5 = 12.5%).

query_data

Shows, per chain (Cadena), the last day with sales, the last stock report and the state and last successful sync of each of its integrations. Use it for 'is my data up to date?' questions or to explain gaps before analyzing recent days.

get_data_status

Runs every tile of a saved dashboard and returns each tile's data, the same numbers the person sees in Ciro. Pass date_range to read it over other days than the ones it was saved with.

run_dashboard

Lists the saved dashboards this person can see in Ciro (shared with the organization or personal) and the tiles on each. Use run_dashboard to read one.

list_dashboards