AI Reporting: New and powerful AI Reporting Tools are Now available.

In Insights (Menu) > AI Tools

We’re excited to introduce AI Reporting, a powerful new way to explore your Redpoint data without needing to write custom SQL queries. With this new tool, you can ask questions in plain language, and the system will generate SQL and run reports for you. More information about this feature and how to use it can be found here on our Knowledge Base.

This tool empowers your team to generate data insights about your members, sales, and operations without relying on custom reports, even if they've never written SQL before.

The AI has been trained on Redpoint’s database schema (tables like Customers & Memberships, Sales & Payments, Inventory, Courses & Programs, Facilities, ect.)

In Insights (Menu) > AI Tools > AI SQL Generator

Example Prompts to Try

• List top 10 retail products sold in 2025. Use revenue account with “retail” in its name.
• List all the members who terminated last month, include the reason and any notes.
• Histogram data by age bracket of current members.
• Top 10 staff members who sold the most “shoes” last month. Use “shoe” in the revenue account.
• Compare average weekend check-ins to weekday check-ins by hour, #withDateFilter.
• List all currently frozen members, their freeze date, and # of months frozen.

Tips for Improving Results

• Be specific: “Sales by month in 2023” is better than “Tell me about sales.”
• Use filters: e.g. “Purchases of product description containing ‘grigri’ in the last 30 days.”
• Request formats: ask for “Top 10,” “grouped by age bracket,” or “sort descending.”
• Start simple, refine later: begin broad and then narrow down with filters and reformatting.
• Use natural dates: “last quarter,” “year to date,” “past 7 days.”
• Check the SQL: AI will show you the SQL it generated.
• Fix errors quickly: If you see an error, click Ask AI to Fix Error (sometimes twice).
• Add Filters: #withDateFilter → add a date range filter, #withFacilityFilter → limit to a specific facility, #withVariantFilter → filter by product variant, #withPlanSetFilter → filter by membership plan set