Analyze resource costs by SKU

Understanding the highest costing SKUs can help multiple personas in an organization achieve goals, such as: Contract negotiation: Procurement teams can use this information to negotiate the best possible discounts with cloud providers. SKU-based forecasting: Product and Finance teams can use this information to forecast future demand for SKUs and plan accordingly. High unit-cost cleanup: FinOps teams can use this information to identify and prioritize SKUs with high unit costs, which can be optimized or eliminated to reduce overall cloud spend.

← Reporting & Analytics

Source: FOCUS MCP snapshot
FOCUS editions: v1.3, v1.4
Queries: 1
Mode: Read-only
Library snapshot (UTC): 2026-10-08

Personas: FinOps Practitioner

Analyze resource costs by SKU v1.3

Adapted to v1.0

Source: FOCUS 1.0 sample
Result rows: 100
Status: Adapted to v1.0
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Lists the highest-cost SKU prices with quantity, list cost and effective cost. ServiceProviderName (v1.3+) is derived from provider_name, or publisher_name for marketplace sellers. Instead of one row per hourly charge period (which made the source's first 100 rows a single hour), rows are aggregated over the selected window and ordered by effective cost; AWS and Oracle effective_cost values in this sample are whole-dollar rounded, so many AWS rows show 0 effective cost.

Column adaptations (1)

Top SKUs by effective cost

Chart controls and notes

Showing the first 20 categories. Open full screen to explore all 99 categories.

Query results
Service provider name	First charge period start	Last charge period end	Sku id	Sku price id	Pricing unit	List unit price	Total pricing quantity	Total list cost	Total effective cost
AWS	2026-03-05 20:00	2026-03-31	4GQWNPC9K2PZAY97	4GQWNPC9K2PZAY97.JRTCKXETXF.6YS6EN2CT7	Hours	$1.62	204.06	$331.39	$388.00
AWS	2026-03-05 19:00	2026-03-31	SEPZUZKD53RX92J8	SEPZUZKD53RX92J8.JRTCKXETXF.6YS6EN2CT7	Hours	$2.04	170.2	$347.20	$341.00
Microsoft	2026-03-04	2026-03-19	1075863	1075863	Hours	$0.38	385.25	$144.47	$144.47
AWS	2026-03-12 06:00	2026-03-30 22:00	J4T9ZF4AJ2DXE7SA	J4T9ZF4AJ2DXE7SA.JRTCKXETXF.6YS6EN2CT7	Hours	$2.00	34.91	$69.83	$70.00
AWS	2026-03-06 21:00	2026-03-30 08:00	3TJZCQ6SUHGWH4FS	3TJZCQ6SUHGWH4FS.JRTCKXETXF.6YS6EN2CT7	Hours	$1.50	37.38	$56.22	$68.00
AWS	2026-03-12	2026-03-29 14:00	JKB56VZGZSM354HN	JKB56VZGZSM354HN.JRTCKXETXF.6YS6EN2CT7	Hours	$2.86	23.02	$65.73	$67.00
AWS	2026-03-04 21:00	2026-03-30 20:00	SQ37ZQ2CZ2H95VDC	SQ37ZQ2CZ2H95VDC.JRTCKXETXF.6YS6EN2CT7	Hours	$1.14	64.33	$73.34	$65.00
AWS	2026-03-14 09:00	2026-03-30 20:00	UH59G55UJ94HZTJJ	UH59G55UJ94HZTJJ.JRTCKXETXF.6YS6EN2CT7	Hours	$5.67	10.86	$61.58	$64.00
AWS	2026-03-09 15:00	2026-03-30 04:00	RSMWKBGGTAAEV4RH	RSMWKBGGTAAEV4RH.JRTCKXETXF.6YS6EN2CT7	Hours	$2.28	26.36	$60.09	$55.00
AWS	2026-03-03 05:00	2026-03-31	QW4FHUGEZYB74TW8	QW4FHUGEZYB74TW8.JRTCKXETXF.6YS6EN2CT7	Hours	$0.68	59.89	$40.72	$49.00
Microsoft	2026-03-01	2026-03-19	1077078	1077078	Hours	$0.15	288	$43.78	$43.78
Datadog Inc.	2026-03-01 08:00	2026-03-30 20:00	YS6FWZFVEY3UJH8D	YS6FWZFVEY3UJH8D.4799GE89SK.6YS6EN2CT7	Units	$0.01	4,098.24	$40.98	$40.32
AWS	2026-03-14 10:00	2026-03-30 14:00	HWZ4252E5KSE3VEQ	HWZ4252E5KSE3VEQ.JRTCKXETXF.6YS6EN2CT7	Hours	$4.28	9.83	$42.10	$40.00
Microsoft	2026-03-09	2026-03-10	1012333	1012333	Hours	$1.50	24	$36.00	$36.00
AWS	2026-03-04 22:00	2026-03-28 16:00	6YZ8PP5Q4B442EER	6YZ8PP5Q4B442EER.JRTCKXETXF.6YS6EN2CT7	Hours	$4.70	6	$28.22	$30.00
AWS	2026-03-02 03:00	2026-03-30 06:00	MYC92D68328BCK4R	MYC92D68328BCK4R.JRTCKXETXF.6YS6EN2CT7	Hours	$4.66	6	$27.94	$30.00
Microsoft	2026-03-16	2026-03-17	1077097	1077097	Hours	$0.30	96	$29.18	$29.18
Microsoft	2026-03-02	2026-03-15	1011266	1011266	Hours	$0.40	72	$28.80	$28.80
Microsoft	2026-03-02	2026-03-20	1073082	1073082	Units/Month	$122.88	0.22	$27.31	$27.31
AWS	2026-03-14 18:00	2026-03-30 21:00	S78KHHH96AJF23KZ	S78KHHH96AJF23KZ.JRTCKXETXF.6YS6EN2CT7	Hours	$2.36	13	$30.68	$26.00
Microsoft	2026-03-02	2026-03-20	616261530	616261530	Hours	$0.22	118.05	$25.85	$25.85
Microsoft	2026-03-02	2026-03-11	1077122	1077122	Hours	$0.10	238	$23.78	$23.78
AWS	2026-03-01	2026-03-30 21:00	S8QGXX5R2BKKMDSJ	S8QGXX5R2BKKMDSJ.JRTCKXETXF.6YS6EN2CT7	GB	$0.50	41.52	$20.76	$21.00
Microsoft	2026-03-03	2026-03-13	616604905	616604905	Hours	$0.20	96	$19.20	$19.20
Microsoft	2026-03-03	2026-03-16	1007368	1007368	Hours	$0.30	48	$14.40	$14.40
Microsoft	2026-03-12	2026-03-15	1007831	1007831	Hours	$0.60	24	$14.40	$14.40
Microsoft	2026-03-13	2026-03-16	1016532	1016532	Hours	$0.30	48	$14.35	$14.35
Microsoft	2026-03-08	2026-03-16	1072956	1072956	Units/Month	$135.17	0.1	$13.52	$13.52
AWS	2026-03-09 20:00	2026-03-27	D3YXS6CU28JAFC5C	D3YXS6CU28JAFC5C.JRTCKXETXF.6YS6EN2CT7	Hours	$4.08	3.29	$13.41	$13.00
Microsoft	2026-03-03	2026-03-19	1013017	1013017	Hours	$0.00	41.25	$0.00	$12.95
Oracle	2026-03-01 22:00	2026-03-31	B93298	–	Gigabyte Per Hour	$0.00	8,000.49	$0.00	$12.00
Microsoft	2026-03-05	2026-03-20	1077393	1077393	Hours	$0.15	76	$11.55	$11.55
Microsoft	2026-03-01	2026-03-20	1007663	1007663	Hours	$0.15	78	$11.39	$11.39
Microsoft	2026-03-04	2026-03-05	611243743	611243743	GB/Month	$0.04	263.48	$11.15	$11.15
Microsoft	2026-03-03	2026-03-20	1071470	1071470	Units/Hour	$0.02	535	$10.70	$10.70
Microsoft	2026-03-04	2026-03-05	1017113	1017113	Hours	$0.44	24	$10.66	$10.66
Microsoft	2026-03-10	2026-03-11	616451661	616451661	Units	$10.00	1	$10.00	$10.00
Microsoft	2026-03-02	2026-03-18	1010660	1010660	Hours	$0.19	48	$9.12	$9.12
AWS	2026-03-01 11:00	2026-03-30 13:00	DW64VZC89TS9M2P2	DW64VZC89TS9M2P2.JRTCKXETXF.6YS6EN2CT7	Hours	$0.77	8	$6.14	$8.00
Microsoft	2026-03-01	2026-03-20	1073873	1073873	Units/Month	$19.71	0.38	$7.47	$7.47
AWS	2026-03-11 06:00	2026-03-25 18:00	Z88B5DU3VRCXZWV8	Z88B5DU3VRCXZWV8.JRTCKXETXF.6YS6EN2CT7	Hours	$1.35	5.15	$6.94	$7.00
AWS	2026-03-02 11:00	2026-03-30 20:00	R3GQ2N4B24GTY3EP	R3GQ2N4B24GTY3EP.JRTCKXETXF.6YS6EN2CT7	Hours	$0.68	9.03	$6.14	$7.00
Microsoft	2026-03-02	2026-03-20	611243015	611243015	Hours	$0.10	63.65	$6.37	$6.37
AWS	2026-03-01 03:00	2026-03-31	9AXD6XJT8GZWPQED	9AXD6XJT8GZWPQED.JRTCKXETXF.6YS6EN2CT7	GB	$0.05	236.91	$10.66	$6.00
AWS	2026-03-01	2026-03-18	5M4327XEUKBBTWAT	5M4327XEUKBBTWAT.JRTCKXETXF.Q3Z75P77EN	GB	$0.09	93.24	$8.39	$6.00
AWS	2026-03-10 17:00	2026-03-17 07:00	X634X9DKWKQ3HC94	X634X9DKWKQ3HC94.JRTCKXETXF.6YS6EN2CT7	Hours	$4.08	2	$8.16	$6.00
AWS	2026-03-01 21:00	2026-03-29 12:00	A36KJNEX3EM3YH8E	A36KJNEX3EM3YH8E.JRTCKXETXF.6YS6EN2CT7	Hours	$4.08	1.7	$6.93	$6.00
AWS	2026-03-01 11:00	2026-03-09 17:00	PAWFKD4ZUQNBD8GW	PAWFKD4ZUQNBD8GW.JRTCKXETXF.6YS6EN2CT7	Hours	$2.74	2	$5.47	$6.00
AWS	2026-03-18 19:00	2026-03-30 08:00	KR9EVAFX4677NQ9A	KR9EVAFX4677NQ9A.JRTCKXETXF.6YS6EN2CT7	Hours	$0.65	6	$3.92	$6.00
Oracle	2026-03-02 22:00	2026-03-30 22:00	B93297	–	OCPU Per Hour	$0.00	474.21	$0.00	$6.00
Microsoft	2026-03-07	2026-03-08	1060871	1060871	Units/Month	$157.67	0.03	$5.26	$5.26
Microsoft	2026-03-05	2026-03-20	611183229	611183229	Hours	$0.04	124	$5.02	$5.02
AWS	2026-03-23 07:00	2026-03-24 07:00	J29KD2787RGQNXMX	J29KD2787RGQNXMX.JRTCKXETXF.6YS6EN2CT7	ConfigurationItemRecorded	$0.003	1,584	$4.75	$5.00
AWS	2026-03-02 14:00	2026-03-29 12:00	H78UZ2P9MH2QFUTH	H78UZ2P9MH2QFUTH.JRTCKXETXF.6YS6EN2CT7	GB	$0.07	51.65	$3.62	$5.00
Microsoft	2026-03-10	2026-03-11	1018280	1018280	GB	$2.30	2.04	$4.70	$4.70
Microsoft	2026-03-13	2026-03-14	1047627	1047627	Hours	$0.00	24	$0.00	$4.40
Microsoft	2026-03-04	2026-03-05	1010438	1010438	Units/Month	$129.89	0.03	$4.19	$4.19
Microsoft	2026-03-02	2026-03-19	1051526	1051526	Hours	$0.08	50.03	$4.16	$4.16
Microsoft	2026-03-14	2026-03-15	611230191	611230191	Hours	$0.17	24	$4.15	$4.15
AWS	2026-03-11 03:00	2026-03-31	HQEH3ZWJVT46JHRG	HQEH3ZWJVT46JHRG.JRTCKXETXF.VF6T3GAUKQ	GB	$0.09	126.95	$10.79	$4.00
AWS	2026-03-05 05:00	2026-03-26 23:00	B4WWWN5ZR39ADG67	B4WWWN5ZR39ADG67.JRTCKXETXF.6YS6EN2CT7	Hours	$1.37	4	$5.47	$4.00
AWS	2026-03-24 13:00	2026-03-30	A86N9S7CGUKZHH8P	A86N9S7CGUKZHH8P.JRTCKXETXF.Q3Z75P77EN	GB	$0.12	36.84	$4.42	$4.00
AWS	2026-03-05	2026-03-23 06:00	BA478CC6K2HYAUP4	BA478CC6K2HYAUP4.JRTCKXETXF.6YS6EN2CT7	GB	$0.07	55.03	$3.85	$4.00
AWS	2026-03-13 16:00	2026-03-25 14:00	4EJ6YKYP3U22GDYZ	4EJ6YKYP3U22GDYZ.JRTCKXETXF.6YS6EN2CT7	Hours	$1.53	2.42	$3.70	$4.00
AWS	2026-03-22	2026-03-23 10:00	WF68Q2FH2F5QR8Q3	WF68Q2FH2F5QR8Q3.JRTCKXETXF.6YS6EN2CT7	Hours	$0.90	4	$3.62	$4.00
Microsoft	2026-03-07	2026-03-10	616281223	616281223	Hours	$0.08	48	$3.69	$3.69
Microsoft	2026-03-05	2026-03-17	1076488	1076488	GB/Month	$0.12	31.45	$3.62	$3.62
Microsoft	2026-03-12	2026-03-15	616679558	616679558	Hours	$0.14	25.2	$3.58	$3.58
Microsoft	2026-03-01	2026-03-20	616452105	616452105	Units/Hour	$0.01	231	$3.10	$3.10
Microsoft	2026-03-01	2026-03-20	1071790	1071790	Hours	$0.005	611	$3.06	$3.06
AWS	2026-03-02	2026-03-30 20:00	3JXC85ZZR3FKV6TZ	3JXC85ZZR3FKV6TZ.JRTCKXETXF.6YS6EN2CT7	Metrics	$0.00001	509,634	$5.10	$3.00
Oracle	2026-03-05 23:00	2026-03-25 23:00	B93113	–	OCPU Hours	$0.03	133	$3.33	$3.00
AWS	2026-03-09 22:00	2026-03-09 23:00	6U3DWZDASYDWNGJ8	6U3DWZDASYDWNGJ8.JRTCKXETXF.6YS6EN2CT7	Hours	$2.85	1	$2.85	$3.00
AWS	2026-03-03 10:00	2026-03-28 17:00	4KVKKTM5HW4NVWCE	4KVKKTM5HW4NVWCE.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.03	82.58	$2.06	$3.00
AWS	2026-03-13 06:00	2026-03-22	J5KKP5G9TBUNP68G	J5KKP5G9TBUNP68G.JRTCKXETXF.6YS6EN2CT7	Hours	$0.68	3	$2.05	$3.00
AWS	2026-03-23 14:00	2026-03-29 05:00	A5AEYK32AA4QTAG9	A5AEYK32AA4QTAG9.JRTCKXETXF.6YS6EN2CT7	Hours	$0.51	3.84	$1.95	$3.00
AWS	2026-03-02 05:00	2026-03-24 17:00	9M7EVK4FWUFZMBS3	9M7EVK4FWUFZMBS3.JRTCKXETXF.6YS6EN2CT7	Hours	$0.50	3	$1.50	$3.00
Microsoft	2026-03-01	2026-03-20	1009967	1009967	Hours	$0.15	20	$2.98	$2.98
Microsoft	2026-03-02	2026-03-19	1036049	1036049	Hours	$0.00	43.98	$0.00	$2.71
Microsoft	2026-03-01	2026-03-18	1073849	1073849	Units/Month	$19.71	0.13	$2.63	$2.63
Microsoft	2026-03-04	2026-03-18	1053311	1053311	GB/Month	$0.10	26.25	$2.62	$2.62
Microsoft	2026-03-03	2026-03-19	1091029	1091029	Units/Hour	$0.02	120	$2.40	$2.40
Microsoft	2026-03-09	2026-03-18	1073520	1073520	Units/Month	$23.84	0.1	$2.38	$2.38
Microsoft	2026-03-17	2026-03-18	1020457	1020457	Hours	$0.10	24	$2.38	$2.38
Microsoft	2026-03-01	2026-03-10	611230660	611230660	GiB Hours	$0.01	168	$2.07	$2.07
AWS	2026-03-01	2026-03-25 12:00	GV2WFGX37Q9PDSHF	GV2WFGX37Q9PDSHF.JRTCKXETXF.Q3Z75P77EN	GB	$0.09	50.16	$4.26	$2.00
AWS	2026-03-17	2026-03-31	5M4327XEUKBBTWAT	5M4327XEUKBBTWAT.JRTCKXETXF.VF6T3GAUKQ	GB	$0.09	37.81	$3.21	$2.00
AWS	2026-03-01	2026-03-29 01:00	Z3FQZG73HYSPVABR	Z3FQZG73HYSPVABR.JRTCKXETXF.PGHJ3S3EYE	GB-Months	$0.02	104.8	$2.41	$2.00
Oracle	2026-03-13 21:00	2026-03-21 22:00	B99060	–	Service Fees (OCPU Hours)	$0.10	18	$1.76	$2.00
Microsoft	2026-03-02	2026-03-20	616383192	616383192	Units/Hour	$0.00941	212	$1.99	$1.99
Microsoft	2026-03-01	2026-03-20	611235125	611235125	Hours	$0.01	183	$1.83	$1.83
Microsoft	2026-03-01	2026-03-06	1053938	1053938	GB	$2.30	0.62	$1.43	$1.43
Microsoft	2026-03-05	2026-03-19	1014127	1014127	Units/Month	$19.71	0.07	$1.31	$1.31
Microsoft	2026-03-02	2026-03-19	1073359	1073359	Units/Month	$19.71	0.07	$1.31	$1.31
AWS	2026-03-01 23:00	2026-03-30	CNYETXBBP73CTYPG	CNYETXBBP73CTYPG.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.05	166.74	$8.34	$1.00
AWS	2026-03-01 04:00	2026-03-30 12:00	VU3485RNDU6HBQF6	VU3485RNDU6HBQF6.JRTCKXETXF.Q3Z75P77EN	GB	$0.09	35.97	$3.06	$1.00
AWS	2026-03-01 01:00	2026-03-31	GQN8D8ZABJSBVTUG	GQN8D8ZABJSBVTUG.JRTCKXETXF.6YS6EN2CT7	GB-Months	$0.30	5.49	$1.65	$1.00
AWS	2026-03-13 21:00	2026-03-30 17:00	DS3YD2GXXXZZ7BDJ	DS3YD2GXXXZZ7BDJ.JRTCKXETXF.6YS6EN2CT7	Hours	$0.61	2.09	$1.28	$1.00
AWS	2026-03-05 10:00	2026-03-13 21:00	Y84QSZWEPC2WJ4WW	Y84QSZWEPC2WJ4WW.JRTCKXETXF.6YS6EN2CT7	GB	$0.04	28.8	$1.15	$1.00
AWS	2026-03-03 12:00	2026-03-30 05:00	FP5XU5WFCUVXQXF5	FP5XU5WFCUVXQXF5.JRTCKXETXF.6YS6EN2CT7	IOs	$0.0000002	5,238,854	$1.05	$1.00

100 rows. Scroll inside the table to see more.

Default parameters use the precomputed result, generated as the read-only focus_reader role.

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end as service_provider_name,
       min(charge_period_start) as first_charge_period_start,
       max(charge_period_end) as last_charge_period_end,
       sku_id as sku_id,
       sku_price_id as sku_price_id,
       pricing_unit as pricing_unit,
       list_unit_price as list_unit_price,
       sum(pricing_quantity) as total_pricing_quantity,
       sum(list_cost) as total_list_cost,
       sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
  and charge_period_end < $2::timestamptz
group by 1, sku_id, sku_price_id, pricing_unit, list_unit_price
order by total_effective_cost desc nulls last, total_list_cost desc nulls last, sku_id
limit 100

Parameters: $1 = period_start, $2 = period_end

Original FOCUS SQL

SELECT
  ServiceProviderName,
  ChargePeriodStart,
  ChargePeriodEnd,
  SkuId,
  SkuPriceId,
  PricingUnit,
  ListUnitPrice,
  SUM(PricingQuantity) AS TotalPricingQuantity,
  SUM(ListCost) AS TotalListCost,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
  ServiceProviderName,
  ChargePeriodStart,
  ChargePeriodEnd,
  SkuId,
  SkuPriceId,
  PricingUnit,
  ListUnitPrice
ORDER BY
  ChargePeriodStart ASC
LIMIT 100

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗