Finance

Publication Rate Card Compiler

Aggregate current billing schedules from distribution partners into unified reference documents

Overview Capabilites Agent Workflow Example prompt

Overview

The Publication Rate Card Compiler aggregates current billing schedules and rate information from multiple distribution partners into unified, easy-to-reference documents. Media and publishing companies work with dozens of distribution partners, each with their own rate structures, billing terms, and pricing updates—making it nearly impossible to maintain current rate information. This agent collects rate cards from various sources, standardizes the information, and compiles comprehensive reference documents that keep sales and finance teams aligned on current pricing. It eliminates rate confusion, accelerates deal negotiations, and ensures accurate revenue forecasting.

Capabilities

Aggregate rate cards and billing schedules from multiple partners
Standardize rate information into consistent format
Track rate changes and effective dates across partners
Generate unified rate reference documents by partner or product
Flag discrepancies or missing rate information

Agent Workflow

Input: User provides rate cards, contracts, or partner communications
Data Extraction: Agent extracts rate information from various sources
Standardization: Converts all rates to consistent format and structure
Compilation: Aggregates information into unified reference document
Validation: Flags inconsistencies or missing information
Output: Delivers comprehensive rate card with all partner information

Example prompt

"I'm uploading rate cards and billing schedules from our 12 content distribution partners (mix of PDFs, emails, and spreadsheets). Compile all rate information into a single unified spreadsheet organized by partner, with columns for: partner name, content type, rate structure (CPM, flat fee, revenue share), current rate, effective date, billing terms, and any volume discounts or special terms. Standardize all rates to monthly figures for comparison. Flag any partners where rate information is incomplete or unclear, and highlight any rate increases that took effect in the last 90 days."