Use case Finance + AdOps
Month-end close
Billing reconciliation and export
Generate a billing reconciliation report, exclude non-billable line item types by default, and export the evidence table.
User prompt
"Prepare the May billing report. Include STANDARD and SPONSORSHIP line items only, show contracted vs delivered impressions, revenue and eCPM, then export the result as CSV for finance."
Expected outcome
A finance-ready reconciliation summary plus CSV evidence for invoice review.
Agent workflow
- 01
Run generate_billing_report for the billing period and billable line item types.
- 02
Review excluded types before sharing numbers externally.
- 03
Export CSV when finance needs the row-level proof.
MCP functions
Parent MCP call shown with the reporting action.
| Function | Cost | Purpose |
|---|---|---|
reporting(action="generate_billing_report") | 0.5 cr | Builds contracted vs delivered billing rows. |
reporting(action="export_report_csv") | 0.5 cr | Exports evidence rows as CSV. |
reporting(action="get_report_result") | 0 cr | Reads cached details for review. |
JSON payload
{
"tool": "reporting",
"arguments": {
"action": "generate_billing_report",
"params": {
"startDate": "2026-05-01",
"endDate": "2026-05-31",
"lineItemTypes": [
"STANDARD",
"SPONSORSHIP"
],
"format": "json"
}
}
}Representative output
- Billing period 2026-05-01 to 2026-05-31: 18 orders, 42 line items, EUR 38,420 revenue.
- STANDARD delivered 93.2% of contracted impressions; 3 line items need make-good review.
- CSV export ready: billing_2026_05_standard_sponsorship.csv.
Dimensions and metrics
Dimensions
| Name | Source | Description |
|---|---|---|
| ORDER_NAME | GAM | Advertiser order |
| LINE_ITEM_NAME | GAM | Billable line |
| LINE_ITEM_TYPE_NAME | GAM | Billing treatment |
| ADVERTISER_NAME | GAM | Customer account |
Metrics
| Name | Source | Description |
|---|---|---|
| LINE_ITEM_CONTRACTED_QUANTITY | GAM | Contracted impressions |
| AD_SERVER_IMPRESSIONS | GAM | Delivered impressions |
| AD_SERVER_REVENUE | GAM | Delivered revenue |
eCPM | Derived | Revenue per 1,000 impressions |
Limits
- Manual make-goods, compensations and offline invoice adjustments are not included.
- HOUSE, NETWORK, AD_EXCHANGE and other non-guaranteed types are excluded unless explicitly requested.
- Always verify finance totals before invoicing customers.
- Validate every field against the dimensions and metrics reference before automating the prompt.
Billing reports are operational aids, not final accounting records.
Field references