CE Cosmos Signal

Query Consumer Edge Orion data using natural language. Answers questions about Consumer Edge Orion 2022 Panel. Returns a task_id — poll get_cosmos_result(task_id='<returned task_id>') every ~10s until ready. Question formatting rules: - Preserve exact time ranges, date constraints, and metrics from the user. Do NOT broaden scope (e.g. 'last 4 weeks' stays 'last 4 weeks'). - Preserve stock tickers verbatim (e.g. keep 'LULU', don't expand to 'Lululemon'). Cosmos resolves tickers itself. - Orion merchants are a two-level hierarchy: a **parent merchant** is the owning company (e.g. 'Gap Inc.', 'Yum! Brands'); a **child merchant** is a banner under it (e.g. 'Old Navy', 'Taco Bell'). The same name can exist at either level and the two give different numbers, so you MUST disambiguate. Explicitly say 'parent merchant X' or 'child merchant X' in the question; if the user is ambiguous, ask before calling this tool. - One child merchant can roll up to more than one parent (e.g. 'Kroger' appears under both 'Kroger' and 'Kroger ex-Fuel'). If a child-merchant query returns multiple parent rows, don't sum them — pick the parent matching the user's intent or surface both distinctly, and explain the split. - Do NOT add analytical details the user didn't specify (comparison windows, aggregations, bucketing). Cosmos picks the right approach. Sessions: pass a session_id (from a previous get_cosmos_result) to continue a conversation. Only one query per session at a time — wait for it to finish before reusing the id. Omit session_id to start fresh.

ask_cosmos_orion

Poll for the result of a previously submitted Cosmos query. Call this after submitting a question with an ask_cosmos_<dataset> tool. Automatically waits up to 40 seconds for completion before responding, so you only need to poll every ~10 seconds. Returns the query result on success, a status update if still running, or an error message on failure.

get_cosmos_result

Report your organization's Cosmos usage against its limits. Returns each limited resource as a percentage of its limit and (when relevant) a suggested action if you are close to or over it.

get_cosmos_usage

Run a DuckDB SQL query against tabular data from a completed Cosmos query. Available after get_cosmos_result returns data tables. The result includes an "Available Data" section listing table names like data_0, data_1, etc. that this tool queries with standard SQL. Strongly preferred for any calculation, aggregation, or comparison on Cosmos results — averages, totals, growth rates, ranking. It computes exact values over the full returned rows, which is more reliable than estimating from the table preview.

query_cosmos_data