topic Re: Archival access and analysis using Python/R etc in Industry Trends

Archival access and analysis using Python/R etc

MikeOD — Thu, 07 Dec 2023 16:45:27 GMT

Hi all, by chance has anyone extracted archival Raw data to do Data Analysis with external tools such as Python/R etc.

Im looking to our data on an individual cheque level and look at menu item performance for Market basket Analysis and menu engineering purposes.

Id be grateful for any thoughts or advice

Re: Archival access and analysis using Python/R etc

Rob — Thu, 07 Dec 2023 19:06:41 GMT

Hey @MikeOD, Thanks for reaching out! Could you please clarify what kind of data you need? Our Toast support team can assist you with large data pulls, but I want to make sure I understand what you're looking for first.

Re: Archival access and analysis using Python/R etc

rcmck — Thu, 07 Dec 2023 19:23:58 GMT

I think data exports is what you want, https://central.toasttab.com/s/article/Automated-Nightly-Data-Export-1492723819691 Personally I have never used them, so all I know about them is that they exist. But I think that is were you would begin with something like data analysis.

Re: Archival access and analysis using Python/R etc

MikeOD — Sun, 21 Jan 2024 20:25:01 GMT

Hi Rob, Many thanks for responding. I am looking to extract data by Cheque reference. Ideally Id like to do some data analysis at the cheque level including the server id, timestamp and then all the items purchased. I see theres is the data export function but its not ot the extent we need. Any advice would be greatly appreciated. I love platform its got lots if info and potential insight sbut we want to dig deeper

Re: Archival access and analysis using Python/R etc

Rob — Mon, 22 Jan 2024 17:26:11 GMT

Unfortunately, not right now. You would have to build a web scraper function out in Excel or google sheets to mass pull this info, or use some other means. There is no mass export option for the check info at this time.

Re: Archival access and analysis using Python/R etc

MikeOD — Tue, 23 Jan 2024 09:41:05 GMT

Thanks Rob, Thats absolutely fine, Im happy to code up a bot in Python with Selenium - Excel or Google sheets does not do well with Dynamic JavaScript platforms. Does Toast have any blockers if I do that? Also Where on the platform can I search at the cheque level? Many thanks appreciate your resopnses

Re: Archival access and analysis using Python/R etc

Rob — Tue, 23 Jan 2024 15:54:17 GMT

Oh, gotcha. I don't have much experience with Python;😅 I always wanted to learn, though! As far as I can see, there are no blockers, you should be fine if we don't have to provide anything other than the info provided on Toastweb.com.
The closest to that info would be the "Order Details" combined with "Orders" reports. Make sure to click the "Show/hide" and select All. Also, I really like Data Analysis, so if you ever want to share your bots or have questions about reports, send me a DM!