Customer Acquisition Cost Tracker

Calculate and analyze customer acquisition cost (CAC) across all channels for my Shopify store with optimization recommendations.

Store and Marketing Data:

  Store URL: [YOUR_STORE_URL]
  Analysis period: [TIME_PERIOD, e.g., last quarter]
  Total new customers acquired: [NEW_CUSTOMERS, e.g., 400]
  Average order value: [AOV, e.g., $65]
  Estimated customer lifetime value: [CLV, e.g., $180]


Marketing spend breakdown for [TIME_PERIOD]:

  Google Ads: [GOOGLE_ADS_SPEND, e.g., $3000]
  Facebook/Instagram Ads: [META_SPEND, e.g., $2500]
  TikTok Ads: [TIKTOK_SPEND, e.g., $500]
  Email marketing platform: [EMAIL_SPEND, e.g., $200/month]
  Influencer partnerships: [INFLUENCER_SPEND, e.g., $1000]
  Content creation: [CONTENT_SPEND, e.g., $800]
  SEO tools and services: [SEO_SPEND, e.g., $300]
  Other channels: [OTHER_SPEND, e.g., affiliate program $400]


CAC Analysis Required:


  Blended CAC Calculation:
    
      Total marketing spend divided by total new customers
      Include fully loaded costs (tools, agency fees, staff time for marketing)
      Blended CAC trend over last 4 quarters
      Blended CAC as percentage of first-order revenue
      CLV:CAC ratio assessment and health grade
    
  
  Channel-Specific CAC:
For each marketing channel, calculate:
    
      Channel spend in [TIME_PERIOD]
      New customers attributed to channel (first-touch and last-touch models)
      Channel CAC (spend / new customers)
      Channel CAC as percentage of first-order AOV
      Channel ROAS for new customer orders only
      Channel efficiency ranking from lowest CAC to highest
    
  
  CAC by Customer Segment:
    
      CAC for different customer demographics if available
      CAC by product category of first purchase
      CAC for customers acquired via discount vs full price
      CAC comparison: customers who become repeat vs one-time buyers
      Identify which acquisition channels bring the highest-value customers
    
  
  CAC Payback Period:
    
      How many days until the average customer’s revenue exceeds their CAC
      Payback period by acquisition channel
      Cash flow implications of CAC payback at current growth rate
      Comparison to industry benchmark payback periods for [YOUR_NICHE]
    
  
  CAC Optimization Opportunities:
    
      Channels with CAC above CLV threshold (unprofitable acquisition)
      Channels with lowest CAC and room to scale (increase budget recommendation)
      Organic channel development to reduce reliance on paid acquisition
      Referral program potential: calculate CAC reduction if [REFERRAL_RATE, e.g., 10%] of customers refer
      Retention improvement impact: how improving repeat rate by [RETENTION_IMPROVEMENT, e.g., 5%] changes effective CAC
    
  
  CAC Budget Planner:
    
      Recommended monthly marketing budget to acquire [TARGET_NEW_CUSTOMERS, e.g., 500] new customers
      Optimal channel mix allocation based on CAC efficiency
      Projected CAC if budget increases by 25%, 50%, or 100% (diminishing returns estimate)
      Quarterly CAC targets and tracking milestones