it could tell you which day the bread sells and which weeks were busiest, if you had an evening for a pivot table.
a retune bot can hold that file and answer questions about it in plain words. retune is free if you run your own copy: it runs on your own computer, with an agent that builds what you ask for.
the bakery in the video is sunrise bakery. i made it up, sales and all, to show the feature.
the owner drops last year's sales on her bot. the video says it's about ten thousand rows.
then she asks what she should bake more of on fridays. the bot compares fridays with the other days and draws bars. challah sells more than twice as much on a friday, and cinnamon rolls and cold brew are up too.
she also asks for weekly revenue and gets a line for the whole year. her busiest weeks were in november and december.
anything you'd otherwise answer with a filter and a sum. like these:
the first row of the file needs the column names, like date, product and amount.
the bot writes a query, runs it on your file, and answers with the number. when a chart helps, it draws one. a ranking gets bars, and weeks or months get a line. a single number comes on its own.
if you want to try it on a different kind of file, like a price list, this letter is about that.
the worry with ai and numbers is that it makes one up. this bot doesn't read the file as text and guess a total. it runs a query on your table, and every answer has a show query button. it opens the exact query and the rows that came back.
it's still an ai model writing that query, so it can get one wrong, like the wrong months for a quarter. if a number is going into a decision, open show query and look. if a query fails, the bot says so and shows you the query instead of guessing.
it fits if your till or shop system can export a csv or an excel file. a year of sales at a small bakery fits, like in the video. a file can be up to 5 mb, 50,000 rows and 60 columns, and the bot reads its first sheet.
it reads the file you uploaded, not your till. new sales show up when you upload a new export.
it gives you numbers, not reasons. it won't tell you why challah sells on fridays. you'll know that better than it does.
the rows are stored with your bot, in your retune account. the ai model sees the column names, a few sample values and the rows a query returns. anyone who can open that bot's chat can ask about the file. so keep your sales on a bot that's just for you and your staff.
if your bakery's bot also talks to customers, the bakery letter is about that side. and once a bot is on your site, its own chats are worth the same kind of look: what customers ask your chatbot.
if you're not sure your file would work, the first card below is my inbox. say what's in it.
if you'd rather go straight to the steps, they're in ask questions about a csv file.
and if it can't answer something you need, tell me. i can build that part.
olive