Agents help retailers stay responsive to shoppers as demand changes in stores and online.
Update website datasets with new and changed rows.
Get new and changed rows from the public pages on your request forms every Monday, plus a workbook report of failed pages.
Import valid spreadsheet rows for analysis and flag entry errors.
Your reporting table gets valid new spreadsheet rows every 15 minutes, with import counts and row-specific fixes waiting in the sheet.
Match report questions to schema fields and draft pivot SQL.
Get a pivot SQL query back in the chat thread, with totals explained and columns matched to your database schema.
Turn chat requests for ranked lists into schema-checked SQL.
Get a ranking SQL query in your chat thread, ready for review. See how the measure and ties determine each position.
Turn team count questions into SQL with clear counting units.
Get a SQL count query in the chat thread, with a clear note on what it counts and which conditions it uses.
Draft SQL from the schema for the requested period.
Get a SQL query for a date or date range in your report chat, with the time field and boundaries explained in the same thread.
Draft schema-based SQL for coworkers' data questions.
Get a SQL query and a clear explanation in the same chat thread as your question, with results when you allow them.
Turn metric definitions into SQL CASE groups for review.
You get a SQL CASE query that groups your metric by the rules you provide, plus clear explanations in the same request thread.
Draft multi-table queries from the keys in a teammate's question.
Get a SQL query with the joins and filters your question needs, plus a short explanation in the same help thread.
Start analysis from usable CSV rows and review source line errors.
Your analysts get CSVs from new text exports in a shared folder. A companion report points to source lines that need fixing.
Combine weekly extracts and count exact duplicates removed.
Get a downloadable CSV from your teams' weekly extracts when the files are usable. See what needs attention in a summary beside it.
Deliver checked data extracts to colleagues each month.
Get a dated CSV and row count in your shared folder every month, or an error note explaining why the export stopped.