AI Budget Allocation Optimizer

Problem

Budgets are often split by historical spend, raw event volume, or manual heuristics, but AppsFlyer event counts are not the same as CRM conversions. The same channel can have uneven event quality because of attribution deduplication, channel variants, or event type differences. Scaling budget directly by event volume can keep resources in low-validity channels instead of moving them toward higher-converting channels. campaign-budget-analysis pairs AF events with CRM conversions to assess channel validity and support budget planning.

How it works

The skill is organized around three metrics:
- Validity: CRM conversions / AF events × 100%, used to measure channel conversion quality
- AF CAP: an event-volume cap set by validity tier, preventing low-efficiency channels from consuming excessive budget
- Estimated CRM: projected CRM output derived from the proposed AF CAP

Operationally, it attributes records by source bank or channel, deduplicates by v_appsflyer_id, and merges variants such as bromo_mob_apr into a parent channel. It then generates an Excel report with Channel Validity Data and Summary sheets, using color-coded tiers for high, medium, and low validity to make budget tradeoffs easier to review.

Boundaries

This is best for campaign analysis where AF event tables, CRM conversion tables, and a reliable join key already exist. If channel mapping is incomplete, v_appsflyer_id coverage is low, or the decision requires finance-grade ROI, profit, or LTV evaluation, data definitions should be reconciled before using its output.