skills.rest
omeraltn
omeraltnCOMMUNITY
Explore all skills by this author →
GitHub

agency-data-consolidation-agent

Consolidate raw sales and pipeline data into structured JSON dashboard reports.

Updated Apr 11, 2026
Search Tags:#sales#dashboard#pipeline#data-consolidation#territory-reporting#attainment
One-click install
npx skills add https://github.com/omeraltn/ice_cream_website_testing --skill agency-data-consolidation-agent-omeraltn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: agency-data-consolidation-agent
Source: https://github.com/omeraltn/ice_cream_website_testing/tree/main/.antigravity/agency-data-consolidation-agent
Command: npx skills add https://github.com/omeraltn/ice_cream_website_testing --skill agency-data-consolidation-agent-omeraltn

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Fragmented sales and pipeline metrics across territories, reps, and time periods make it hard to produce accurate, timely executive and operational views; this agent consolidates those sources and emits dashboard-ready reports with derived metrics like attainment and weighted pipeline value.

Core Features & Use Cases

  • Territory performance summaries with MTD and YTD revenue, attainment, and rep counts for regional leadership.
  • Individual rep performance listings with latest metrics and recent metric history for coaching and compensation review.
  • Pipeline snapshots by stage including counts, raw value, and weighted value to feed forecasting models.
  • Trend analysis over trailing six months and top performer highlights for executive dashboards.
  • Real-time refresh metadata, generation timestamps for staleness detection, and safeguards like division-by-zero handling and aggregation by territory.

Quick Start

Generate a YTD territory dashboard for Northwest combining the latest sales metrics, pipeline stages, rep rankings, and calculated attainment in JSON.

Frequently Asked Questions about agency-data-consolidation-agent

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

FAQPage Schema
How do I consolidate raw sales data into a unified dashboard report?▼

Consolidating raw sales data into a unified dashboard involves aggregating territory and rep metrics, calculating MTD and YTD attainment with division-by-zero safeguards, and returning structured JSON with generation timestamps for staleness detection.

What is the best way to generate territory performance summaries from fragmented pipeline data?▼

Generating territory performance summaries requires aggregating fragmented pipeline snapshots by stage and rep, calculating weighted pipeline values, and compiling trailing trend analyses to produce dashboard-ready JSON outputs.

Does this data consolidation approach handle division-by-zero errors when calculating sales attainment?▼

Yes, calculating sales attainment includes built-in division-by-zero safeguards to ensure accurate rep performance rankings and territory summaries without breaking the dashboard report generation process.

Can I track trailing sales trends and rep performance rankings over multiple time periods?▼

Tracking trailing sales trends aggregates rep performance rankings and historical metrics over a trailing six-month period, providing MTD and YTD views for executive dashboards and compensation reviews.

How do pipeline snapshots by stage feed into sales forecasting models?▼

Pipeline snapshots by stage feed forecasting models by providing structured counts, raw pipeline values, and weighted pipeline values aggregated from raw sales data into a unified dashboard-ready format.

Why do consolidated sales dashboard reports include generation timestamps?▼

Consolidated sales dashboard reports include generation timestamps for staleness detection, ensuring users can verify they are viewing the latest metric dates and real-time refreshed pipeline data.

Related Skills

Explore More Data & Analytics Skills→
rajyeole6rajyeole6

agency-data-consolidation-agent

Consolidate raw sales metrics and pipeline data into dashboard-ready JSON reports.

Community
Intermediate
WebWakaHubWebWakaHub
20

Data Consolidation Agent

Consolidate sales metrics into live dashboards with timestamped JSON output.

Official
Advanced
elophantoelophanto
116

data-consolidation

Aggregate sales metrics into structured dashboards with territory summaries, rep rankings, and pipeline snapshots.

Community
Intermediate
anavvanzinanavvanzin

agency-data-consolidation-agent

Consolidate sales metrics into live, territory-aware dashboards with JSON outputs.

Community
Intermediate