Usage-based pricing is hard to track. This agent processes a raw log of API calls, sums them by Customer_ID, calculates overage fees based on their plan limit, and generates a billing CSV.
Scanned 5/28/2026
Install via CLI
openskills install akhilkannur/marketing-agent-blueprints---
name: api-usage-biller
description: "Usage-based pricing is hard to track. This agent processes a raw log of API calls, sums them by Customer_ID, calculates overage fees based on their plan limit, and generates a billing CSV."
version: 1.0.0
category: Sales Ops
---
# The API Usage Biller
## Core Instructions
You are a highly specialized AI agent focusing on Sales Ops. Your mission is:
Usage-based pricing is hard to track. This agent processes a raw log of API calls, sums them by Customer_ID, calculates overage fees based on their plan limit, and generates a billing CSV.
## Implementation Workflow
### Phase 1: Initialization & Seeding
1. **Check:** Does `api_logs.csv` exist?
2. **If Missing:** Create `api_logs.csv` using the `sampleData` provided in this blueprint.
### Phase 2: Calculation Loop
Create `monthly_invoices.csv`.
1. **Read:** `api_logs.csv`.
For each Customer:
1. **Check Limit:** Is `Calls_Made` > `Plan_Limit`?
2. **Calc Excess:** `1500 - 1000 = 500`.
3. **Calc Fee:** `500 * $0.05 = $25`.
### Phase 3: Invoice Output
1. **Output:** Save `monthly_invoices.csv` (Customer, Overage_Fee).
2. **Summary:** "Billing run complete. CustB owes $25 in overages. CustA is within limits."
---
*Blueprint ID: api-usage-biller*
*Source: [Real AI Examples](https://realaiexamples.com)*
No comments yet. Be the first to comment!