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.