paygo-ptu-cost-analyzer

Compute percentile TPM capacity and spillover costs from token usage data.

5|2|Updated Apr 28, 2026
One-click install
npx skills add https://github.com/aiappsgbb/awesome-gbb --skill paygo-ptu-cost-analyzer
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: paygo-ptu-cost-analyzer
Source: https://github.com/aiappsgbb/awesome-gbb/tree/main/skills/paygo-ptu-cost-analyzer
Command: npx skills add https://github.com/aiappsgbb/awesome-gbb --skill paygo-ptu-cost-analyzer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, numpy, matplotlib, azure-identity, azure-monitor-query, and includes references (resource) components.

What problem does it solve?

It helps you size Azure OpenAI PTU (Provisioned Throughput) versus PAYGO by turning per-minute token usage into a percentile-based cost and spillover report.

Core Features & Use Cases

  • Headless PAYGO vs PTU analysis that accepts either a customer CSV export or a Log Analytics (AzureMetrics) query.
  • Percentile TPM envelope sizing (e.g., p50–p99) with PTU capacity selection and spillover-to-PAYGO estimates.
  • Output as report.md plus machine-readable report.json and charts for review in PRs or capacity-planning docs.

Quick Start

Ask the agent to run the headless report generator using the bundled synthetic data mode to produce a sample markdown + JSON + chart set in an output directory.

Frequently Asked Questions about paygo-ptu-cost-analyzer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I compare Azure OpenAI PAYGO versus PTU costs using token usage logs?

To compare Azure OpenAI PAYGO versus PTU costs, you process per-minute token usage logs to compute percentile TPM capacity and estimate spillover-to-PAYGO scenarios. This analysis outputs markdown reports, JSON files, and PNG charts for capacity planning.

What is the required CSV token schema for PTU sizing and cost analysis?

The required CSV token schema for PTU sizing includes minute_bin, input_tokens_sum, cached_tokens_sum, and output_tokens_sum columns. You must provide token usage data formatted with these specific fields to generate accurate percentile TPM envelope sizing and spillover estimates.

Can I use Log Analytics KQL queries instead of CSV exports for PAYGO vs PTU analysis?

You can use Log Analytics AzureMetrics KQL queries instead of CSV exports for PAYGO vs PTU analysis. The headless report generator accepts either a customer CSV token export or a direct Log Analytics query to compute percentile-based cost and spillover reports.

Does PTU sizing analysis support custom percentile selection for TPM capacity planning?

PTU sizing analysis supports custom percentile selection for TPM capacity planning. You can specify percentile ranges such as p50 through p99 to model different capacity scenarios, evaluate PTU capacity selection, and estimate spillover-to-PAYGO costs for Azure OpenAI provisioning.

What outputs do I get when generating a PAYGO vs PTU cost report?

Generating a PAYGO vs PTU cost report produces report.md for markdown review, machine-readable report.json, and PNG charts for visual capacity planning. These outputs support review in pull requests or capacity-planning docs for Azure OpenAI provisioning decisions.

Do I need Azure identity credentials to query Log Analytics for token usage analysis?

You need Azure identity credentials to query Log Analytics for token usage analysis when using AzureMetrics KQL queries instead of CSV exports. The analysis relies on azure-identity and azure-monitor-query dependencies to authenticate and retrieve per-minute token usage data for PTU sizing.