Data Consolidation Agent

Consolidate sales metrics into dashboard-ready JSON structures.

Updated Apr 16, 2026
One-click install
npx skills add https://github.com/jc180105/.opencode --skill data-consolidation-agent-jc180105
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Data Consolidation Agent
Source: https://github.com/jc180105/.opencode/tree/main/.opencode/skills/data-consolidation-agent
Command: npx skills add https://github.com/jc180105/.opencode --skill data-consolidation-agent-jc180105

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill solves the challenge of fragmented sales data by automatically aggregating metrics from multiple territories and reps into centralized, real-time dashboards.

Core Features & Use Cases

  • Territory performance summaries (YTD/MTD revenue, attainment, rep count)
  • Rep performance rankings and leaderboard-style insights
  • Pipeline snapshot by stage (count, value, weighted value)
  • Trend analysis over trailing periods
  • Top performers highlights and automated reporting

Quick Start

Generate a live territory and rep performance dashboard using the latest data.

Frequently Asked Questions about Data Consolidation Agent

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I consolidate scattered sales metrics into a live dashboard?

To consolidate sales metrics into a live dashboard, this Skill aggregates territory and rep performance data across MTD, YTD, and custom periods, merging pipeline snapshots with sales metrics to output dashboard-friendly JSON structures. It ensures the latest data is used for real-time visibility.

What is the best way to generate territory performance summaries and rep rankings?

Generating territory performance summaries and rep rankings is done by aggregating YTD/MTD revenue, attainment, and rep count data. This Skill processes pipeline snapshots by stage and automates leaderboard-style insights to highlight top performers across multiple timeframes.

Can I analyze pipeline visibility and rep performance across custom time periods?

Yes, you can analyze pipeline visibility and rep performance across custom time periods. The Skill consolidates sales metrics from territories and representatives, applying trend analysis over trailing periods to provide real-time pipeline snapshots by stage, count, value, and weighted value.

Does this data consolidation process output dashboard-friendly JSON structures?

Yes, the data consolidation process outputs dashboard-friendly JSON structures. It uses efficient queries to merge pipeline data with sales metrics, ensuring territory-level reporting, rep performance analysis, and real-time pipeline visibility are formatted directly for live dashboard integration.

How do I merge pipeline data with sales metrics for real-time reporting?

Merging pipeline data with sales metrics for real-time reporting is achieved by applying efficient queries to the latest consolidated data. The Skill automatically aggregates fragmented inputs across territories and timeframes to produce live, dashboard-ready JSON outputs.

When do I need to use automated sales data consolidation for territory analysis?

You need automated sales data consolidation for territory analysis when fragmented sales data prevents real-time visibility. This Skill solves that challenge by aggregating metrics from multiple territories and reps, ensuring pipeline snapshots and trend analysis are always up-to-date for live reporting.