Skip to content

cloudthinker-ai/CloudSkills / skills/connections/managing-apptio

managing-apptio

Verified

Use when working with Apptio — apptio and Cloudability IT financial management and cloud cost optimization. Covers IT cost allocation, cloud cost analysis, benchmarking, budget forecasting, showback/chargeback reports, and technology business management. Use when managing IT financial planning, benchmarking cloud spend, or creating chargeback models.

Apptio / Cloudability Management Skill

Manage IT financial planning and cloud cost optimization with Apptio and Cloudability.

MANDATORY: Discovery-First Pattern

Always list connected accounts and cost models before querying financial data.

Phase 1: Discovery

#!/bin/bash

apptio_api() {
    local method="${1:-GET}"
    local endpoint="$2"
    local data="${3:-}"
    if [ -n "$data" ]; then
        curl -s -X "$method" -H "Authorization: Bearer $APPTIO_API_TOKEN" \
            -H "Content-Type: application/json" \
            "https://api.apptio.com/v1/${endpoint}" -d "$data"
    else
        curl -s -X "$method" -H "Authorization: Bearer $APPTIO_API_TOKEN" \
            "https://api.apptio.com/v1/${endpoint}"
    fi
}

cloudability_api() {
    local endpoint="$1"
    curl -s -H "Authorization: Bearer $CLOUDABILITY_API_TOKEN" \
        "https://api.cloudability.com/v3/${endpoint}"
}

echo "=== Connected Cloud Accounts ==="
cloudability_api "vendors/accounts" | jq -r '
    .result[] | "\(.vendorAccountId)\t\(.vendorAccountName)\t\(.vendor)\t\(.status)"
' | column -t | head -20

echo ""
echo "=== Cost Models ==="
apptio_api GET "cost-models" | jq -r '
    .items[] | "\(.id)\t\(.name)\t\(.status)\tPeriod: \(.period)"
' | column -t

echo ""
echo "=== Business Units ==="
apptio_api GET "business-units" | jq -r '
    .items[] | "\(.id)\t\(.name)\tOwner: \(.owner // "unassigned")"
' | column -t | head -15

Core Helper Functions

#!/bin/bash

apptio_api() {
    local method="${1:-GET}"
    local endpoint="$2"
    local data="${3:-}"
    if [ -n "$data" ]; then
        curl -s -X "$method" -H "Authorization: Bearer $APPTIO_API_TOKEN" \
            -H "Content-Type: application/json" \
            "https://api.apptio.com/v1/${endpoint}" -d "$data"
    else
        curl -s -X "$method" -H "Authorization: Bearer $APPTIO_API_TOKEN" \
            "https://api.apptio.com/v1/${endpoint}"
    fi
}

cloudability_api() {
    local endpoint="$1"
    curl -s -H "Authorization: Bearer $CLOUDABILITY_API_TOKEN" \
        "https://api.cloudability.com/v3/${endpoint}"
}

Output Rules

  • TOKEN EFFICIENCY: Target ≤50 lines per output
  • Use jq to extract financial summaries and cost allocation data
  • Round costs to 2 decimal places

Common Operations

IT Cost Allocation

#!/bin/bash
PERIOD="${1:-current}"

echo "=== IT Cost Allocation by Business Unit ==="
apptio_api GET "cost-allocation?period=${PERIOD}&groupBy=businessUnit" | jq -r '
    .items[] | "\(.businessUnit)\t$\(.totalCost | . * 100 | round / 100)\tDirect: $\(.directCost | . * 100 | round / 100)\tShared: $\(.sharedCost | . * 100 | round / 100)"
' | sort -t'$' -k2 -rn | column -t | head -15

echo ""
echo "=== Cost by IT Tower ==="
apptio_api GET "cost-allocation?period=${PERIOD}&groupBy=itTower" | jq -r '
    .items[] | "\(.itTower)\t$\(.totalCost | . * 100 | round / 100)\t\(.percentOfTotal | . * 100 | round / 100)%"
' | sort -t'$' -k2 -rn | column -t | head -15

Cloud Cost Analysis (Cloudability)

#!/bin/bash
echo "=== Cloud Cost Summary (last 30 days) ==="
cloudability_api "reporting/cost/run?start_date=$(date -u -d '30 days ago' +%Y-%m-%d)&end_date=$(date -u +%Y-%m-%d)&dimensions[]=vendor&metrics[]=unblended_cost" | jq -r '
    .result[] | "\(.vendor)\t$\(.unblended_cost | . * 100 | round / 100)"
' | sort -t'$' -k2 -rn | column -t

echo ""
echo "=== Cost by Service (Top 15) ==="
cloudability_api "reporting/cost/run?start_date=$(date -u -d '30 days ago' +%Y-%m-%d)&end_date=$(date -u +%Y-%m-%d)&dimensions[]=service_name&metrics[]=unblended_cost&sort[]=unblended_cost&order=desc&limit=15" | jq -r '
    .result[] | "\(.service_name)\t$\(.unblended_cost | . * 100 | round / 100)"
' | column -t

Benchmarking

#!/bin/bash
echo "=== Cost Benchmarking ==="
apptio_api GET "benchmarking/summary" | jq '{
    itSpendPerRevenue: .itSpendPerRevenue,
    cloudSpendPerEmployee: .cloudSpendPerEmployee,
    industryMedian: .industryMedian,
    percentile: .percentile,
    peerComparison: .peerComparison
}'

echo ""
echo "=== Benchmark by IT Tower ==="
apptio_api GET "benchmarking/by-tower" | jq -r '
    .items[] | "\(.tower)\tYour Cost: $\(.yourCost | . * 100 | round / 100)\tMedian: $\(.industryMedian | . * 100 | round / 100)\tPercentile: \(.percentile)th"
' | column -t | head -10

Budget Forecasting

#!/bin/bash
echo "=== Budget vs Actual ==="
apptio_api GET "budgets/current" | jq -r '
    .items[] | "\(.category)\tBudget: $\(.budgetAmount | . * 100 | round / 100)\tActual: $\(.actualAmount | . * 100 | round / 100)\tVariance: \(.variancePercent | . * 100 | round / 100)%"
' | column -t | head -15

echo ""
echo "=== Forecast (next quarter) ==="
apptio_api GET "forecasts/next-quarter" | jq '{
    forecastTotal: .forecastTotal,
    budgetTotal: .budgetTotal,
    variance: .variance,
    trend: .trend,
    confidenceLevel: .confidenceLevel
}'

Showback / Chargeback Reports

#!/bin/bash
BU="${1:-}"

echo "=== Chargeback Report ==="
ENDPOINT="chargeback/report?period=current"
[ -n "$BU" ] && ENDPOINT="${ENDPOINT}&businessUnit=${BU}"
apptio_api GET "$ENDPOINT" | jq -r '
    .items[] | "\(.businessUnit)\t\(.service)\t$\(.chargedAmount | . * 100 | round / 100)\tModel: \(.allocationModel)"
' | sort -t'$' -k3 -rn | column -t | head -20

echo ""
echo "=== Allocation Models ==="
apptio_api GET "allocation-models" | jq -r '
    .items[] | "\(.name)\tType: \(.type)\tBasis: \(.allocationBasis)"
' | column -t | head -10

Safety Rules

  • Financial data sensitivity: Cost allocation data may be confidential -- restrict access appropriately
  • Read-only queries: API operations are observational -- cost model changes require UI
  • Budget approvals: Never modify budgets or forecasts without finance team approval
  • Chargeback accuracy: Validate allocation models before publishing chargeback reports

Output Format

Present results as a structured report:

Managing Apptio Report
══════════════════════
Resources discovered: [count]

Resource       Status    Key Metric    Issues
──────────────────────────────────────────────
[name]         [ok/warn] [value]       [findings]

Summary: [total] resources | [ok] healthy | [warn] warnings | [crit] critical
Action Items: [list of prioritized findings]

Target ≤50 lines of output. Use tables for multi-resource comparisons.

Anti-Hallucination Rules

  1. NEVER assume resource names — always discover via CLI/API in Phase 1 before referencing in Phase 2.
  2. NEVER fabricate metric names or dimensions — verify against the service documentation or --help output.
  3. NEVER mix CLI commands between service versions — confirm which version/API you are targeting.
  4. ALWAYS use the discovery → verify → analyze chain — every resource referenced must have been discovered first.
  5. ALWAYS handle empty results gracefully — an empty response is valid data, not an error to retry.

Counter-Rationalizations

ShortcutCounterWhy
"I'll skip discovery and check known resources"Always run Phase 1 discovery firstResource names change, new resources appear — assumed names cause errors
"The user only asked for a quick check"Follow the full discovery → analysis flowQuick checks miss critical issues; structured analysis catches silent failures
"Default configuration is probably fine"Audit configuration explicitlyDefaults often leave logging, security, and optimization features disabled
"Metrics aren't needed for this"Always check relevant metrics when availableAPI/CLI responses show current state; metrics reveal trends and intermittent issues
"I don't have access to that"Try the command and report the actual errorAssumed permission failures prevent useful investigation; actual errors are informative

Common Pitfalls

  • Data lag: Cloud billing data can lag 24-72 hours from actual usage
  • Allocation models: Incorrect shared cost allocation models skew business unit charges
  • Amortization: RI/SP amortization settings affect how upfront payments appear in reports
  • Multi-currency: Global organizations need proper exchange rate configuration
  • Tag coverage: Low tag coverage makes cost allocation inaccurate -- target 90%+ tagging
  • API versioning: Apptio and Cloudability have separate APIs -- use correct endpoints for each
planning-and-task-breakdownaddyosmani/agent-skillsBreaks work into ordered tasks. Use when you have a spec or clear requirements and need to break work into implementable tasks. Use when a task feels too large to start, when you need to estimate scope, or when parallel work is possible.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
screenpipethedotmack/claude-memSearch screen and audio history recorded by Screenpipe and optionally save selected context into claude-mem. Use when the user asks to recall desktop activity, a meeting, or something seen in another app through Screenpipe.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
contact-widgetnexu-io/open-designSelf-contained floating chat widget with welcome screen, social links, meeting button, and message input. Single HTML file, zero dependencies.Stars: 108kUpdated Claude CodeCodexVerifiedInstall
meeting-notesnexu-io/open-designMeeting notes page — title bar with attendees, agenda checklist, decisions block, action items table with owners + dates, and a "next meeting" footer. Use when the brief mentions "meeting notes", "minutes", "1:1 notes", "all-hands recap", or "会议纪要".Stars: 108kUpdated Claude CodeCodexVerifiedInstall