Replacing Manual Reporting with Instant, Self-Service Analytics
Engineering a Claude-powered analytics agent that helps deliver on-demand custom insights and reduce reporting effort.
Overview
A leading video commerce platform faced a growing reporting bottleneck that strained internal resources and left customers waiting for performance insights. 10Pearls designed and launched a Claude-powered analytics agent that transforms manual reporting into a secure, self-service experience, allowing customers to explore their video performance simply by asking questions.
Self-service analytics
down to nearly zero
vs. 5-6 hrs per report
Challenge
Demonstrating the value of embedded video required regular reporting. The company prepared ROI reports weekly for trial customers and monthly for established customers, with each report taking 5–6 hours per client. That manual process created a scaling constraint as the customer base expanded.
A standard dashboard previously developed by 10Pearls provided visibility into core metrics but could not accommodate every analytical question. Customers submitted 10–15 custom requests by email each month, introducing further work and delays between a question arising and an answer becoming available.
The technical challenge was to turn video-widget telemetry into a secure conversational analytics experience, allowing customers to explore their data while maintaining isolation between business accounts.
Solution
10Pearls replaced time-intensive manual reporting with instant, self-service analytics, giving customers the freedom to explore video performance simply by asking questions. The agent connects those questions to engagement data tracked through Video.js and stored in New Relic, with account-level access controls keeping each customer’s data isolated. Two Claude models work together to classify requests and generate relevant queries and answers. By embedding this capability directly into the product, 10Pearls helps customers make faster, better-informed decisions while reducing the reporting burden as the platform grows. Request classification is handled by Claude Haiku 4.5. Haiku evaluates incoming questions to determine whether they concern analytics. Query generation and answers are managed by Claude Sonnet 5. Sonnet serves as the primary model behind the agent, reasoning over the question, generating the required queries and constructing the response. The model’s reasoning supports the interpretation of open-ended business questions and their translation into relevant data queries. This extends access beyond predefined dashboard views, allowing customers to explore engagement through natural-language queries.
The team used Claude Code within a spec-driven development workflow and Claude Opus 5 for full-branch code reviews, helping assess how changes work together before merging. This approach supports continued development as customer needs evolve, with Claude powering both the analytics experience and the engineering behind it. The result is a scalable product capability that reduces reliance on manual reporting, gives customers faster access to insights, and enables the platform to serve a growing customer base without a corresponding increase in reporting effort.
Results & Benefits
The first release is live, providing 65 businesses with self-service access to video engagement analytics. Additional releases are in progress.
Manual weekly or monthly reporting has been replaced with an agent that the customers can use to query their data instantly on demand. Each report previously took 5 to 6 hours to prepare per client.
Custom analytics requests by email are expected to decline from 10–15 per month to near zero. By moving routine exploration into the product, the solution is intended to reduce reporting demands on the company, even as customer usage grows. Customers gain a more flexible way to investigate performance, with Claude supporting both the analytical experience and its continued development.
Customer
Video commerce platform
SERVICES
- AI Development
- Agentic AI development
- AI Integration
- Data Analytics
- Product Engineering
Tech stack
Powered by:
- Claude Sonnet 5
- Claude Haiku 4.5
Developed with:
- Claude Code
- Claude Opus 5
Related case studies
Technology
Compensation Data Analytics Platform
Discover how 10Pearls developed a compensation data analytics platform that transforms workforce data into actionable insights, enabling smarter pay decisions and planning.
QA
Automating Code Quality to Accelerate Delivery
An automated code quality engine reduced manual review effort, improved consistency, and helped development teams ship faster with confidence.
AWS
Scaling a Crowdfunding Platform for Growth
A growing crowdfunding platform was modernised for scale, delivering a smoother user experience and stronger performance as demand increased.
Azure
Modernising monolithic ticketing Saas to Modular
A monolithic ticketing SaaS platform was modernised into a more modular, scalable product built for faster releases and future growth.
Azure
Identity Management System Azure Migration
A global identity management system moved to Azure with zero disruption, unlocking cloud scalability, resilience, and room for future growth.
Salesforce
Automating Fund Management to Strengthen Donor Trust
Digital fund management became faster and more transparent with Salesforce automation, improving donor trust, reporting accuracy, and visibility.
AWS
Enhanced Fraud Prevention with Secure Cloud
A secure AWS architecture strengthened fraud prevention, accelerated investigations, and enabled safer high-integrity data processing at scale.
Technology
Modernised Data Ecosystem
A modernised cloud data ecosystem improved data accessibility, accelerated processing, and enabled seamless real-time sharing for advanced analytics.
Data Analytics
Centralised Cloud Data Warehouse
10Pearls built a cloud data warehouse that unified student data, reduced admin work, and enabled faster, insight-driven support.
AWS
Intelligent Data Analytics Platform
See how 10Pearls built an AWS analytics platform that turned 100TB+ of data into real-time insights, faster decisions, and greater ROI.
Ready to get started?
Contact us today to learn how we can transform your products or ideas into scalable solutions that drive business value and growth.