skills.rest
augustoheiss
augustoheissCOMMUNITY
Explore all skills by this author →
GitHub

agency-data-consolidation-agent

Consolidate sales metrics into unified dashboard-ready JSON reports.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Consolidates and reconciles distributed sales metrics into consistent, real-time dashboard-ready reports to eliminate stale or inconsistent summaries and speed decision-making.

Core Features & Use Cases

  • Territory summaries: YTD/MTD revenue, attainment, and rep counts aggregated by territory for regional visibility.
  • Rep performance & rankings: Latest metrics per representative with top-performer highlights.
  • Pipeline integration: Merge lead pipeline data with closed metrics to produce stage counts, values, and weighted pipeline snapshots.
  • Trend analysis & freshness: Trailing 6-month trends, recent metric history, and generation timestamps for staleness detection.
  • Use Case: A revenue operations analyst requesting a consolidated executive dashboard and territory deep-dive that updates every minute.

Quick Start

Generate a full YTD dashboard JSON for territory "North" including latest metrics, pipeline snapshot, top 5 performers, and a generation timestamp.

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 multi-territory sales metrics into a live dashboard?▼

Sales metric consolidation merges distributed territory data into unified, dashboard-ready JSON reports. It selects the latest metric_date per type, aggregates territory-level revenue, and applies division-by-zero handling for accurate attainment calculations.

What is the best way to calculate sales attainment and rank rep performance across territories?▼

Sales attainment calculation requires accurate division-by-zero handling to avoid errors when targets are zero. The process aggregates latest metrics per representative, ranks top performers, and outputs structured territory summaries for regional visibility.

Can I merge lead pipeline data with closed sales metrics for stage snapshot analysis?▼

Pipeline integration merges lead pipeline data with closed metrics to produce stage counts, values, and weighted pipeline snapshots. This combined view enables comprehensive trend analysis alongside trailing 6-month historical metric data.

How do I detect stale reporting data in consolidated sales dashboards?▼

Stale data detection uses a generation timestamp included in the consolidated JSON output to identify outdated metric summaries. This freshness indicator updates every minute to ensure real-time accuracy in executive dashboard reporting.

Does sales data consolidation support MTD and YTD revenue trend analysis?▼

Sales data consolidation supports MTD and YTD revenue views by selecting the latest metric_date per type and aggregating territory-level data. It generates trailing 6-month trends and recent metric history for comprehensive trend analysis.

What format does consolidated sales data output for dashboard integration?▼

Consolidated sales data outputs as structured JSON containing territory summaries, rep rankings, pipeline snapshots, and generation timestamps. This dashboard-ready format supports direct integration with live reporting views for executive analysis.

Related Skills

Explore More Marketing & Sales Skills→
OneWave-AIOneWave-AI
245

territory-planning-optimizer

Optimize sales territory design for coverage, balance, and revenue potential.

Official
Basic
omeraltnomeraltn

agency-data-consolidation-agent

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

Community
Advanced
elophantoelophanto
116

data-consolidation

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

Community
Intermediate
WebWakaHubWebWakaHub
20

Data Consolidation Agent

Consolidate sales metrics into live dashboards with timestamped JSON output.

Official
Advanced