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.
Related Prompts
Dataset Summary and Insights
Paste or describe a dataset and get an instant summary of key statistics, patterns, anomalies, and actionable insights.
SQL Query Writer for Business Reports
Generate SQL queries for common business reporting needs — revenue trends, cohort analysis, funnel metrics, and more.
Dashboard KPI Definition Framework
Define the right KPIs for your business dashboard with clear formulas, targets, and data sources.