May and June were so busy, we forgot to tell you what we shipped! Andrew joined the team full-time and got right to work shipping these awesome features:
- New Data Sources: Ordway, Kit, Attio, Instantly, NPM, and MongoDB
- Rollups: aggregate across apps with natural language
- Universal Data Library: automatic data cleaning and modeling
- Percy: smarter AI features
- Charts show growth rates to help you monitor performance
- Grapple got WAY faster, most pages load in under 1 second now!
New Data Sources
We added support for SaaS billing platform, Ordway, so you can build ARR Waterfall reports and understand financial performance. Then Kit, Attio, and Instantly, bring more of your GTM data into Grapple. And for you nerds, we added support for tracking NPM downloads and bringing in data from MongoDB clusters.
Rollups
Rollups are a foundational feature for Grapple: they allow you to aggregate across multiple apps from a single field. For example, count the number of Zendesk tickets per customer, or calculate how many days old the oldest still open Zendesk ticket is. Or, pull in the latest payment status for a customer from Stripe.
Rollups are particularly useful dashboards like Customer Health Tracking where you want to combine data from several apps into a single view. For example, bring in data from Zendesk, Stripe, your app's product database, and Asana for a full picture of your customers across every touchpoint.
In the demo below, Jack builds a customer health tracker with data from Hubspot, Zendesk, Stripe, and Supabase:
Universal Data Library
One of the slowest parts of visualizing business data is modeling it. With Univeral Data Library, data modeling is fully automated. This means your data is queryable right away—no matter the data source.
In technical terms, data like dates and numbers are automatically normalized so you can ask questions like "what was my sales pipeline last quarter?" or "how much did my team close this week?".
Universal Data Library also automatically joins your data. For example, if you want to work with Hubspot deals, UDL will automatically join owners, companies, contacts, and line items. This means you can pull data from these other objects directly into your report right away without writing SQL joins or vlookups.
Meet, Percy
Percy is your AI data engineering working in the background to understand and act on your natural language requests. Percy translates natural language like "who is my top sales rep" into a beautiful bar chart.
We've improved Percy's performance dramatically the last few months. Percy can now generate:
- Filters, including those using dates
- Spreadsheet formulas so you never have to hit =... again
- Rollups, yes the new powerful aggregation feature you saw above
- Any type chart or data visualization
In fact, Universal Data Library and Percy work together to deliver highly accurate, transparent dashboards. Percy talks to UDL and can see the shape of your data but not the data itself. So you never have to worry about your sensitive business data being used to train models or shared with 3rd parties.