Meta Ad Creatives

Track creative performance and hit rates across multiple Meta Ads accounts.

What This Skill Does

• Calculate hit rates (% of creatives meeting performance benchmarks)
• Track multiple metrics: CPT (cost per trial), CPI (cost per install), IPM (installs per mille), ROAS
• Compare performance across multiple accounts
• Store historical data for trend analysis
• Identify winning creatives vs underperformers
• Support currency conversion for international accounts

Setup

1. Environment Variables

FACEBOOK_ACCESS_TOKEN=your_token_here
FACEBOOK_APP_ID=your_app_id
FACEBOOK_APP_SECRET=your_app_secret

2. Accounts Configuration

Create accounts_config.json:

{
  "accounts": {
    "ClientName": {
      "account_id": "123456789",
      "filter": "CampaignNameFilter",
      "geo_filter": "US",
      "benchmark_value": 100,
      "benchmark_display": "CPT < $100",
      "active": true
    }
  }
}

Configuration fields:

• account_id: Meta Ad Account ID (without act_ prefix)
• filter: Campaign name filter (optional)
• geo_filter: Geographic filter like "US" (optional)
• benchmark_value: CPT threshold for "winning" creatives
• benchmark_display: Human-readable benchmark description

Usage

Get Hit Rates for Current Month

from scripts.meta_ad_creatives import get_all_hit_rates

data = get_all_hit_rates(month_offset=0)
print(f"Overall hit rate: {data['totals']['hit_rate']}%")
for account in data['accounts']:
    print(f"  {account['account_name']}: {account['hit_rate']}%")

Get Hit Rates for Previous Months

# Last month
data = get_all_hit_rates(month_offset=-1)

# Two months ago
data = get_all_hit_rates(month_offset=-2)

Get All-Time Aggregated Data

data = get_all_hit_rates(all_time=True)

Get Individual Ad Performance

from scripts.meta_ad_creatives import get_individual_ads

# All ads for an account
ads = get_individual_ads(account_name="ClientName", month_key="2026-01")

# Only winning ads
winners = get_individual_ads(account_name="ClientName", hit_only=True)

# Sort by CPT
ads = get_individual_ads(sort_by="cpt")

Monthly Comparison

from scripts.meta_ad_creatives import get_monthly_comparison

# Compare last 3 months
months = get_monthly_comparison(num_months=3)
for month in months:
    print(f"{month['month_label']}: {month['totals']['hit_rate']}%")

Key Metrics

Metric	Description
Total Ads	Ads created in the period
Ads with Spend	Ads that received budget
Ads Hitting Benchmark	Ads meeting CPT threshold
Hit Rate	% of ads meeting benchmark
CPT	Cost Per Trial (spend / trials)

Hit Rate Calculation

A creative "hits" the benchmark when:

1. It has spend > $0
2. It has trials > 0
3. CPT < benchmark_value (e.g., $100)

Hit Rate = (Ads Hitting Benchmark / Ads with Spend) × 100

Data Storage

The skill stores historical data for trend analysis:

• Firestore (default for cloud deployments)
• SQLite (local fallback)

Set USE_FIRESTORE=false to use SQLite locally.

Common Questions This Answers

• "What's our creative hit rate this month?"
• "Which creatives are winning for [Client]?"
• "How does this month compare to last month?"
• "Show me all ads that hit the benchmark"
• "What's our all-time hit rate?"