Usage-Billing Reconciler (BigQuery)
Usage-Billing Reconciler Scheduled + On-Demand Runs weekly and on-demand before invoicing. Queries BigQuery for actual consent volumes and enrichment usage per customer. Compares against contracted/billed amounts. Flags: under-billing (revenue leakage), over-billing (customer complaints), and customers approaching their next tier threshold. Google BigQuery Billing System / HubSpot Slack Cron (Wednesday) Weekly Cron (Wed) + on-demand BigQuery: actual usage per customer Pull contracted/billed amounts Compare + flag discrepancies >5% Post to #finance-ops Acceptance Criteria: Weekly report comparing BigQuery usage vs. billing for all active customers Flags: under-billed (>5% gap), over-billed, approaching next tier (>80% of current) Separate sections for consent volumes and enrichment volumes Calculates estimated revenue impact per discrepancy On-demand run via Slack command before invoice cycles
Details
Created
Odella
Created By
Mar 31, 2026
Hires
0 Imports
Descriptions
Usage-Billing Reconciler Scheduled + On-Demand Runs weekly and on-demand before invoicing. Queries BigQuery for actual consent volumes and enrichment usage per customer. Compares against contracted/billed amounts. Flags: under-billing (revenue leakage), over-billing (customer complaints), and customers approaching their next tier threshold. Google BigQuery Billing System / HubSpot Slack Cron (Wednesday) Weekly Cron (Wed) + on-demand BigQuery: actual usage per customer Pull contracted/billed amounts Compare + flag discrepancies >5% Post to #finance-ops Acceptance Criteria: Weekly report comparing BigQuery usage vs. billing for all active customers Flags: under-billed (>5% gap), over-billed, approaching next tier (>80% of current) Separate sections for consent volumes and enrichment volumes Calculates estimated revenue impact per discrepancy On-demand run via Slack command before invoice cycles
Required Integration
These integrations must be connected to use this resource.
Skills
Expand Usage-Billing Reconciler (BigQuery)'s Skills
Select a category below to add a new sub-skill and enhance this agent's performance.
How to use
Hire & Onboard
Click 'Hire Agent' to add this AI employee to your workforce instantly.
Connect Your Tools
Link their Slack, Gmail, or other integrations for seamless communication.
Train & Customize
Provide context and feedback to help them learn your preferences.
Background Tasks
Usage-Billing Reconciler
No description.