Motley × ImpactPilot: Scaling impact with narratives

How we partnered with ImpactPilot to turn customer success data into data driven reports

When we founded Motley, our north star was clear: transform raw business data into structured narratives that drive action. Stories that answer what happened, what it means, and what you should do next.

‍

So when we started working with ImpactPilot, it felt like an ideal match. ImpactPilot helps CS teams convert scattered data inside HubSpot into meaningful signals.

‍

Here’s how we worked together to create an automated end-of-cycle reporting engine that generates structured, insight-rich reports for their customers every quarter.

‍

The challenge

ImpactPilot is a native solution inside HubSpot that transforms scattered customer-success data into clear, actionable insights. It automates risk- and opportunity-detection using AI agents, tracks your defined “impact drivers” across accounts, and embeds directly in your CRM so your CSMs never leave their workflow.

‍

ImpactPilot realises tangible NRR improvements for customers and wants to communicate this at scale through an end-of-quarter report they could share with their customers with minimal manual overhead.

‍

They had tried other approaches: “Our challenge is that none of the existing AI tools seems to do the data crunch, visualisation and consistent report building at the same time. ChatGPT is awfully inconsistent, Gamma can’t crunch the data and Julius doesn’t have a repeatable process.”

‍

Our approach

Here’s how we tackled it together:

‍

1. Data & structuring

Motley used anonymised data of the key activities of each ImpactPilot customer via secured data transfer, about 45,000 lines of data in total.

‍

2. Creation of a Master presentation

Working with the ImpactPilot team, we built an “End-of-Cycle Quarter” that structures the flow:

‍

• Executive summary: “What moved, what stands out.”
• CSM performance snapshot: number of engagements, impact-driver progress, wins.
• Account portfolio summary: high-risk accounts, high-opportunity accounts.
• Insights from interaction-data: surfaced via LLMs (e.g., “stakeholder engagement dropped in Region X”, “renewal risk flagged because of Y”, “expansion opportunity in segment Z”).
• Recommended next steps

‍

3. Automation & delivery

Once configured, Motley automates generation of each customer’s end-of-quarter report in Google Slides. The result: hours saved per report, consistent quality, scalable at growth speed.

The results

• ImpactPilot was able to generate a complex data report for each of their customers
• Customers now receive a structured end-of-cycle summary: “Here’s what happened this quarter”, “Here’s how your CSM and team performed”, “Here are the themes you should know”, “Here’s what we should do next.”
• ImpactPilot’s value-promise of being outcome-driven gets bolstered: the narratives tie directly to “impact drivers” and business outcomes.
• Scale becomes real: as their customer base grows, the report engine has the ability to scale too — same quality, same narrative, minimal additional effort.

‍

Final word

Working with partners such as ImpactPilot is critical in our process of developing Motley’s platform. But even more so when we work with partners who share common belief in the future of customer success, deeply integrating with the tools companies already use, leveraging AI for insight generation, automation and practical applications for CSMs

Here’s to telling better stories, driving more impact, and building stronger customer relationships.