Cloud Cost Allocation and Anomaly Analysis

Analyze cloud spend by service, team, product, and environment to find anomalies, allocation gaps, and FinOps savings opportunities.

Prompt Template

Act as a FinOps data analyst. Analyze cloud cost allocation and anomalies for [company/product/team] using the billing data below.

Data available: [paste cloud billing export, cost table, dashboard summary, or fields such as date, service, account, region, tag, project, environment, usage type, cost]
Cloud provider(s): [AWS, GCP, Azure, multi-cloud]
Time period: [month/quarter/date range]
Allocation model: [tags, accounts, namespaces, projects, cost centers, unallocated spend]
Known events: [launches, migrations, incidents, load tests, seasonality]
Business context: [team budgets, revenue drivers, customer usage, committed spend]
Thresholds: [anomaly percentage, dollar amount, budget variance]

Deliver:
1. **Executive summary** — total spend, variance, biggest drivers, and risk areas
2. **Cost allocation breakdown** by team, product, environment, service, and region
3. **Anomaly table** — date, service, account/team, expected cost, actual cost, delta, likely cause
4. **Unallocated spend analysis** — missing tags, shared services, allocation rules, and cleanup plan
5. **Unit economics view** — cost per customer, request, job, GB, or transaction if data allows
6. **Savings opportunities** — rightsizing, commitments, storage lifecycle, idle resources, architecture fixes
7. **Owner action plan** — who investigates what, by when, and expected impact
8. **Dashboard recommendations** — metrics, filters, alerts, and recurring review cadence
9. **Caveats** — data gaps and assumptions that could change the conclusion

Be specific and separate confirmed findings from hypotheses.

Example Output

Cloud Cost Analysis: April 2026

**Total spend:** $82,400, up 18% month over month and 11% over budget. The largest driver was data warehouse compute (+$9,800), followed by untagged Kubernetes storage (+$3,200).

Anomalies

| Date | Service | Owner | Expected | Actual | Delta | Likely cause |

|---|---|---:|---:|---:|---:|---|

| Apr 14 | BigQuery | Analytics | $1,200 | $4,900 | +$3,700 | Backfill query without partition filter |

| Apr 21 | EBS | Untagged | $600 | $2,100 | +$1,500 | Orphaned volumes after migration |

Allocation gaps

14% of spend is unallocated, mostly from shared Kubernetes namespaces and missing `team` tags on storage. Require `team`, `env`, and `product` tags for new resources; backfill top 30 untagged resources this week.

Savings actions

1. Add query cost guardrails for analytics backfills — expected savings $5k/month.

2. Delete orphaned volumes older than 14 days — expected savings $1.8k/month.

3. Review committed-use discounts after workload stabilization.

Tips for Best Results

  • 💡Do not treat every spike as waste; annotate launches and migrations before recommending cuts.
  • 💡Separate unallocated spend from owned spend so teams trust the report.
  • 💡Use both percentage and dollar thresholds; tiny services can have dramatic but irrelevant spikes.
  • 💡Pair savings ideas with owners or they become decorative spreadsheets.