Schema & Semantic Layer

Product Penetration Analytics

product-penetration v3.0

Analyze product adoption, cross-sell opportunities, wallet share, and segment-level product penetration across the membership base

Metric Definitions

total_members
Total Members
overview neutral

Total membership count

COUNT(DISTINCT member_id)
total_products
Total Products
overview neutral

Total product accounts held

COUNT(product_id)
avg_products_per_member
Avg Products/Member
penetration ↑ higher

Average number of products per member

total_products / total_members
stretch: 5.0 target: 4.0 warn low: 3.0
product_penetration_rate
Product Penetration Rate
penetration ↑ higher

Percentage of members holding a specific product

members_with_product / total_members * 100
cross_sell_opportunity
Cross-Sell Opportunity
opportunity neutral

Members eligible for product who don't have it

eligible_members - members_with_product
wallet_share
Wallet Share Index
engagement ↑ higher

Estimated share of member's financial wallet

products_held / potential_products * 100
segment_penetration
Segment Penetration
segment neutral

Product penetration within a specific segment

segment_members_with_product / segment_total * 100
revenue_opportunity
Revenue Opportunity
opportunity neutral

Estimated annual revenue from cross-sell conversion

opportunity_size * avg_revenue_per_product
deposit_penetration
Deposit Penetration
category penetration neutral

Percentage of members with deposit products

members_with_deposits / total_members * 100
lending_penetration
Lending Penetration
category penetration neutral

Percentage of members with lending products

members_with_loans / total_members * 100

Products & Cross-Sell Targets

Product Categories

Deposit Products
Savings and transactional accounts
Checking Account (checking) Savings Account (savings) Money Market Account (money_market) Certificate of Deposit (cd)
Lending Products
Consumer and real estate loans
Auto Loan (auto_loan) Personal Loan (personal_loan) Mortgage (mortgage) HELOC (heloc) Credit Card (credit_card)
Investment Products
Retirement and investment accounts
IRA/Retirement Account (ira)
Business Products
Commercial banking products
Business Checking (business_checking) Business Loan (business_loan)

Cross-Sell Targets

ID Source → Target Priority Est. Revenue/Acct Conversion Target
checking_to_credit_card checking → credit_card #1 $550 15%
checking_to_auto_loan checking → auto_loan #2 $1200 8%
checking_to_ira checking → ira #3 $300 10%
savings_to_cd savings → cd #4 $200 12%
checking_to_mortgage checking → mortgage #5 $3500 3%

Insight Templates

IDTriggerHeadlineSeverity
high_penetration penetration_rate >= 80 Strong Penetration positive
low_penetration_opportunity penetration_rate < 30 Growth Opportunity info
segment_leader segment_avg_products >= 5 High Engagement Segment positive
cross_sell_ready opportunity_size > 1000 Large Cross-Sell Pool info

Segment Definitions

Lifecycle

IDNameDescriptionFilter
young_professional Young Professional Early career members building financial foundation age BETWEEN 22 AND 34
established_family Established Family Peak earning years with family financial needs age BETWEEN 35 AND 49
pre_retiree Pre-Retiree Planning for retirement transition age BETWEEN 50 AND 64
empty_nester Empty Nester Reduced family obligations, wealth accumulation age BETWEEN 55 AND 70
retiree Retiree Fixed income, wealth preservation focus age >= 65
mid_career Mid-Career Professional Career growth phase with expanding needs age BETWEEN 30 AND 45

Engagement

IDNameDescriptionFilter
single_product Single Product Members with only one product products_held = 1
multi_product Multi-Product Members with moderate product adoption products_held BETWEEN 2 AND 4
full_relationship Full Relationship Deeply engaged members with high wallet share products_held >= 5

Decision Type Definitions

cross_sell_campaign
Cross-Sell Campaign
marketing monthly high

Launch targeted campaign to increase product adoption

Triggers
cross_sell_opportunity > 1000 members
penetration_rate < 30%
segment_gap detected
Actions
• Email Campaign (marketing_manager) • Branch Referral Program (retail_manager) • Digital Offer (digital_manager) • Direct Mail Campaign (marketing_manager)
Outcome Metrics
product_penetration_rateconversion_ratecampaign_roi
segment_engagement
Segment Engagement Strategy
member experience quarterly

Tailored engagement approach for specific member segment

Triggers
segment_wallet_share < average
segment_attrition elevated
segment_growth opportunity
Actions
• Segment-Specific Campaign (marketing_manager) • Product Bundle Offer (product_manager) • Lifecycle Program (member_experience_manager) • Financial Advisor Outreach (wealth_manager)
Outcome Metrics
segment_penetrationsegment_wallet_sharesegment_retention
product_optimization
Product Optimization
product quarterly

Actions to improve product competitiveness and adoption

Triggers
product_penetration declining
competitive_gap detected
member_feedback negative_trend
Actions
• Pricing Review (product_manager) • Feature Enhancement (product_manager) • Product Simplification (product_manager) • Digital Experience Upgrade (digital_manager)
Outcome Metrics
product_penetration_ratemember_satisfactionnew_account_volume
wallet_share_growth
Wallet Share Growth
strategy annual

Strategic initiative to deepen member relationships

Triggers
avg_products_per_member < 4.0
single_product_members > 30%
wallet_share < industry_benchmark
Actions
• Relationship Pricing (cfo) • Loyalty Program (marketing_manager) • Onboarding Optimization (member_experience_manager) • Data-Driven Offers (analytics_manager)
Outcome Metrics
avg_products_per_memberwallet_sharemember_lifetime_value
single_product_conversion
Single-Product Conversion
retention monthly high

Convert single-product members to multi-product relationships

Triggers
single_product_count > 1500
tenure_threshold > 6 months
engagement_score low
Actions
• Second Product Campaign (marketing_manager) • Enhanced Welcome Series (member_experience_manager) • Checking + Savings Bundle (product_manager) • Digital Engagement Push (digital_manager)
Outcome Metrics
single_product_conversion_rateavg_products_per_membermember_retention

Decision States & Flow

Workflow
Surfaced
Acknowledged
Analyzing
Campaign Planned
In Market
Terminal States:
Completed(terminal)
Deferred(terminal) req. rationale
Dismissed(terminal) req. rationale

State Definitions

StateDescriptionTerminal
surfaced
Opportunity identified, awaiting review active
acknowledged
Responsible party has reviewed active
analyzing
ROI and feasibility analysis in progress active
campaign_planned
Campaign strategy defined active
in_market
Campaign launched and running active
completed
Campaign complete, results measured terminal
deferred
Postponed with rationale terminal
dismissed
Not actionable with rationale terminal

Service Level Agreements

Decision TypeResponse WindowEscalation Path
cross_sell_campaign 14 days Marketing Analyst (3 days)Marketing Manager (7 days)Cmo (14 days)
segment_engagement 30 days Segment Analyst (7 days)Marketing Manager (14 days)Cmo (30 days)
product_optimization 30 days Product Analyst (7 days)Product Manager (14 days)Cpo (30 days)
wallet_share_growth 90 days Analytics Manager (14 days)Marketing Manager (30 days)Executive Team (90 days)
single_product_conversion 14 days Marketing Analyst (3 days)Retention Manager (7 days)Marketing Manager (14 days)

Authority Levels

LevelRoleCan Approve
L1 analyst
Marketing/Product Analyst
— read only —
L2 marketing_manager
Marketing Manager
email_campaigndigital_offerdirect_mailsegment_campaignsecond_product_campaign
L2 product_manager
Product Manager
product_bundlepricing_reviewfeature_enhancementsimplificationsavings_bundle
L2 digital_manager
Digital Manager
digital_experiencedigital_engagement
L2 retail_manager
Retail Manager
branch_referral
L3 member_experience_manager
Member Experience Manager
lifecycle_programonboarding_optimizationwelcome_series
L3 analytics_manager
Analytics Manager
data_driven_offers
L4 cmo
Chief Marketing Officer
loyalty_program
L5 cfo
Chief Financial Officer
relationship_pricing
L6 executive
Executive Team
strategic_initiatives