Female Founder Collective Data Alignment

May 2026 · Prepared June 12, 2026 · Verified against BQ + HubSpot + Chargebee + Meta + HubSpot Email

Overview: May 1 – May 31

?Monthly recurring revenue from Chargebee active subscriptions. Includes all active plans (FOM, Cabinette, 10th House, etc.).sum(plan_mrr) where subscription_status = 'active'
MRR
$65,804
1,056 active subscriptions
?Deals moved to Won stage in HubSpot during the period. April was an anomaly due to a large 10th House cohort push (139 deals / $86,937).count(deals) where stage = 'Won' and close_date in period
Deals Won
8 / $4,455
-94% vs April (139 / $86,937)
April was anomaly (large 10H cohort push)
?New contacts created in HubSpot during the period. Includes all sources (form submissions, imports, integrations).count(contacts) where created_date in period
New Contacts
706
-75% vs April (2,818)
?Total Meta Ads spend for the period. Pulled from Meta Ads reporting API via BigQuery.sum(spend) from meta_ads where date in period
Meta Ad Spend
$577
-88% vs April ($4,908)
?Total invoice revenue collected via Chargebee during the period. Includes one-time charges, renewals, and upgrades.sum(invoice_amount) where status = 'paid' and date in period
Paid Invoice Revenue
$68,449
-50% vs April ($135,747)
?New subscriptions created in Chargebee during the period. Includes all plan types.count(subscriptions) where created_date in period
New Subscriptions
35
-73% vs April (129)
?Subscriptions flagged as non-renewing or scheduled for cancellation. Represents at-risk MRR that will churn unless retained.count(subs) where status = 'non_renewing'
Non-Renewing (At Risk)
170 subs
$17,829 MRR at risk
?HubSpot marketing email open rate for the period. Calculated as unique opens / delivered emails.open_rate = unique_opens / delivered
Email Open Rate
34.6%
+6.5pp vs April (28.1%)

Meta Ads

Platform-reported
Metric Value
Spend$577
Platform Revenue$0
Impressions11,598
Clicks272
CTR2.35%
CPC$2.12
Conversions (Meta-reported)20
Why this won't match. May shows 20 conversions but $0 revenue — likely pixel lag or lookback window mismatch. April had $5,982 from similar conversion volume. At ~$19/day spend, this is maintenance-level budget. Revenue attribution may appear in June reporting once the lookback window closes.
Meta Ads — Daily Spend (May 2026)
Maintenance-level budget ~$19/day
What we're filtering by.
  • Attribution window: 7-day click / 1-day view (Meta default)
  • Conversion event: Purchase / Lead
  • Revenue: $0 reported despite 20 conversions — pixel/lookback issue
  • Spend down 88% MoM ($4,908 → $577)
  • April reference: ~$5,982 revenue at similar conversion volume

HubSpot Email

Connected
Metric Value
Recipients142,468
Opens49,320
Clicks1,525
Open Rate34.6%
Click Rate1.07%
Email-Attributed Conversions0
Why this won't match. Zero email-attributed conversions despite 1,525 clicks. No purchase or conversion event is mapped in HubSpot email attribution. Engagement metrics (34.6% open rate, 1.07% click rate) are healthy — the gap is in conversion tracking, not performance. To close the loop: map Chargebee subscription events as HubSpot conversion goals.
HubSpot Email — Daily Opens vs Clicks (May 2026)
34.6% open rate, 1.07% click rate
What we're filtering by.
  • Source: HubSpot Marketing Email (not external ESP)
  • Recipients: 142,468 across all campaigns and workflows
  • Conversion tracking: Not configured — no purchase/subscription event mapped
  • Open rate includes Apple MPP influence (may overcount)
  • Click-to-open rate: 3.1% (1,525 clicks / 49,320 opens)

Chargebee Subscriptions

Connected
Metric Value
Active Subscriptions1,056
MRR$65,804
New Subscriptions (May)35
Cancellations (May)43
Net Change-8
Top Plans New Subs
FOM Yearly16
Cabinette Annual5
10th House Yearly5
Other Plans9
Total New35
Chargebee — New Subs vs Cancellations (May 2026)
Net -8 subscriptions
What we're filtering by.
  • Source: Chargebee subscription API
  • MRR: Active subscriptions only (excludes paused, non-renewing)
  • Non-renewing subs (170) represent $17,829 at-risk MRR
  • Net negative: 43 cancellations vs 35 new — churn exceeds acquisition
  • FOM Yearly is the top new-sub plan (46% of May signups)

Combined: Source Alignment

Source Metric Value Status
Chargebee MRR $65,804 Connected
HubSpot Deals Won 8 / $4,455 Connected
Meta Ads Spend $577 $0 revenue reported
HubSpot Email Recipients 142,468 Connected
LinkedIn Ads Status Paused $0 spend
FFC is a membership/subscription business — revenue sits in Chargebee, not in ad platform attribution. MRR ($65,804) is the core health metric. HubSpot Deals ($4,455) represents new sales pipeline, not recurring revenue. Meta shows 20 conversions but $0 revenue (pixel/lookback lag). Email drives engagement (142K recipients, 34.6% open rate) but has no conversion tracking mapped. LinkedIn is paused. To close the loop: map Chargebee subscription events to HubSpot conversion goals and reconnect LinkedIn when budget resumes.