⚙️ What This Prompt Does:
- Converts user input into a structured financial analysis task.
- Focuses on calculating Customer Acquisition Cost (CAC) by channel.
- Outputs data in a markdown table format with specified columns.
❓Tips:
- Systematically track and categorize all expenses related to each acquisition channel to ensure accurate calculation of total acquisition costs, which is crucial for determining the CAC.
- Regularly update the number of new customers acquired through each channel during the specified time period to maintain up-to-date data for precise CAC analysis.
- Use the calculated CAC to evaluate the efficiency of different acquisition channels and optimize marketing spend to focus on the most cost-effective channels.
❓ CAC Analyst Consultant ChatGPT Prompt
Adopt the role of a financial analyst specializing in customer acquisition metrics. Your primary objective is to calculate the Customer Acquisition Cost (CAC) for a specific business over a given time period. To achieve this, you will create a detailed breakdown of acquisition costs and new customers by channel. Take a deep breath and work on this problem step-by-step. Begin by listing all relevant acquisition channels, then compile the total acquisition cost and number of new customers for each channel. Finally, calculate the overall CAC by dividing the total acquisition cost by the total number of new customers.
#INFORMATION ABOUT ME:
My business: [INSERT BUSINESS NAME]
My time period: [INSERT TIME PERIOD]
My primary acquisition channels: [LIST PRIMARY ACQUISITION CHANNELS]
My total marketing budget: [INSERT TOTAL MARKETING BUDGET]
My total new customers: [INSERT TOTAL NEW CUSTOMERS]
MOST IMPORTANT!: Present your output in a markdown table format with 3 columns: Acquisition Channel, Total Acquisition Cost, and Number of New Customers. Include a row for totals and the final CAC calculation.
❓How To Use The Prompt:
- Fill in the placeholders [INSERT BUSINESS NAME], [INSERT TIME PERIOD], [LIST PRIMARY ACQUISITION CHANNELS], [INSERT TOTAL MARKETING BUDGET], and [INSERT TOTAL NEW CUSTOMERS] with specific details about your business. For example, if you run a digital marketing agency, specify its name, the time period you are analyzing (e.g., Q1 2023), list your primary channels like Google Ads, Facebook, and LinkedIn, state your total marketing budget for the period, and note the total number of new customers acquired.
- Example: "My business: Digital Marketing Solutions Inc., My time period: Q1 2023, My primary acquisition channels: Google Ads, Facebook, LinkedIn, My total marketing budget: $50,000, My total new customers: 150"
❓ Example Input:
#INFORMATION ABOUT ME:
- My business: God of Prompt, the biggest collection of easy-to-follow AI resources, AI Prompts & How-to Guides for busy Small Business Owners.
- My time period: January 2023 - December 2023
- My primary acquisition channels: Social Media, Email Marketing, SEO, Paid Ads
- My total marketing budget: $50,000
- My total new customers: 500
❓ Example Output:
❓Additional Tips:
- Ensure to document all the data sources and methodologies used in calculating the CAC for transparency and future reference.
- Periodically review and adjust your acquisition channels based on the CAC analysis to adapt to changing market dynamics and consumer behavior.
- Consider conducting A/B testing on different acquisition channels to identify the most effective strategies for customer acquisition and improve overall CAC efficiency.
- Collaborate with the marketing team to align on goals and strategies, ensuring a unified approach towards optimizing CAC and maximizing ROI.