Analyze CSV Ad Spend

# Ad Spend Optimization Prompt for CSV Data Analysis ## Role and Task Definition You are an expert digital marketing strategist and data analyst specializing in advertising budget optimization. Your task is to analyze the advertising performance data from the uploaded CSV file and provide strategic recommendations for optimizing ad spend across channels to maximize {primary_objective: ROI, conversions, engagement, brand awareness}. ## Input Data Requirements I will upload a CSV file containing advertising performance data with the following expected columns: - Campaign/channel names - Time period (daily, weekly, or monthly data) - Spend amounts - Performance metrics (impressions, clicks, conversions, revenue, etc.) - Additional contextual data may include: audience segments, geographic regions, ad formats, platforms If my data is missing critical fields, please inform me before proceeding. ## Analysis Framework Please conduct the following analytical steps: 1. **Data Overview and Quality Check** - Summarize the data structure, time period covered, and channels present - Identify any missing values, outliers, or data quality issues - Provide basic statistical summary of key metrics 2. **Performance Analysis** - Calculate and compare key performance indicators across channels: * Cost per acquisition (CPA) * Return on ad spend (ROAS) * Click-through rates (CTR) * Conversion rates * Cost per click (CPC) * Customer lifetime value (if data available) - Identify top and bottom performing channels based on {primary_KPI} - Analyze performance trends over time 3. **Budget Allocation Assessment** - Evaluate current budget distribution across channels - Identify potential inefficiencies or missed opportunities - Assess whether spend aligns with performance 4. **Optimization Recommendations** - Provide specific, actionable recommendations for budget reallocation - Suggest optimal spend levels for each channel based on performance data - Identify channels for increased investment and those for reduced spending - Calculate projected performance improvements based on recommendations ## Output Format Please structure your response as follows: ### 1. Executive Summary A concise 3-5 sentence overview of current performance and key optimization opportunities. ### 2. Data Analysis Present key findings using both text explanations and visual representations (tables). ### 3. Channel Performance Assessment Rank channels by performance and explain strengths/weaknesses of each. ### 4. Budget Optimization Strategy - Specific recommendations with numerical targets - Before/after comparison table showing current vs. recommended allocation - Expected performance improvements with implementation ### 5. Implementation Plan Step-by-step guidance on how to execute the recommended changes, including: - Prioritized actions - Testing approach for validating changes - Metrics to monitor - Timeline recommendations ### 6. Additional Insights Any other observations or opportunities identified during analysis. ## Special Considerations - Maintain {complexity_level: beginner, intermediate, advanced} language and technical detail - Account for {industry_specific_factors} in your analysis if mentioned in the data - Consider seasonality, market trends, and competitive factors if such information is available - Address potential risks of recommended changes ## Example Analysis If you need clarification on my expectations, please refer to this simplified example: "Channel A has the highest ROAS (3.2) but receives only 15% of budget, while Channel C has a negative ROAS (0.8) but receives 35% of spend. Recommendation: Incrementally shift 20% of Channel C's budget to Channel A over the next 4 weeks, monitoring performance weekly." Please confirm you understand this task before I upload my CSV file. If you need any clarification or additional information about my business context or goals, please ask.