Data Consolidation Agent

Consolidate sales metrics into live dashboards with timestamped JSON output.

20|9|Updated Mar 10, 2026
One-click install
npx skills add https://github.com/WebWakaHub/manus-agency-skills --skill data-consolidation-agent-webwakahub
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Data Consolidation Agent
Source: https://github.com/WebWakaHub/manus-agency-skills/tree/main/agency-specialized-data-consolidation-agent
Command: npx skills add https://github.com/WebWakaHub/manus-agency-skills --skill data-consolidation-agent-webwakahub

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill removes the manual effort of merging dispersed sales metrics into a single, trustworthy reporting view, making it easier to monitor performance across territories, reps, and pipeline stages.

Core Features & Use Cases

  • Territory Summaries: Consolidate YTD and MTD revenue, attainment, and rep counts by territory.
  • Rep Performance Views: Surface the latest metrics for individual representatives and rank top performers.
  • Pipeline Reporting: Combine lead pipeline data with sales results to show stage counts, values, and weighted values.
  • Trend Analysis: Present trailing six-month trends and recent metric history for deeper operational insight.

Quick Start

Ask the Data Consolidation Agent to generate a live dashboard summary for the latest sales data, including territory performance, rep rankings, pipeline snapshots, and a timestamped output.

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 dispersed sales metrics into a live dashboard?

To consolidate sales metrics into a live dashboard, the agent merges territory, rep, and pipeline data. It applies grouped aggregations and latest-record selection to generate a single, trustworthy reporting view for performance monitoring.

What is the best way to generate territory reporting for executive reviews?

Generating territory reporting for executive reviews requires consolidating YTD and MTD revenue, attainment, and rep counts by territory. The agent surfaces these grouped aggregations to provide a comprehensive snapshot of regional performance.

How do I calculate pipeline stage values and weighted values from lead data?

Calculating pipeline stage values and weighted values involves combining lead pipeline data with sales results. The agent processes this data to display stage counts, total values, and weighted values for pipeline reporting snapshots.

Can I track trailing six-month trends and rep performance rankings automatically?

Tracking trailing six-month trends and rep performance rankings is supported by the agent. It surfaces the latest metrics for individual representatives, ranks top performers, and presents recent metric history for deeper operational insight.

Does the consolidated dashboard output include timestamps for stale-data detection?

Yes, the consolidated dashboard output includes timestamped JSON output specifically for stale-data detection. This ensures you can verify data freshness during performance monitoring and executive reviews.