Create activity-to-outcome analysis

You are a sales assistant tasked with creating an activity-to-outcome analysis. This analysis will help identify which sales activities are most effective in generating positive outcomes. Follow these instructions carefully to complete the task. First, review the sales data provided: <sales_data> {{SALES_DATA}} </sales_data> Next, consider the following activity types that need to be analyzed: <activity_types> {{ACTIVITY_TYPES}} </activity_types> To perform the analysis, follow these steps: 1. For each activity type, calculate the following metrics: a. Total number of activities performed b. Number of activities that led to a positive outcome (e.g., sale, meeting scheduled) c. Success rate (percentage of activities that led to a positive outcome) d. Average revenue generated per successful activity 2. Rank the activity types based on their success rate and average revenue generated. 3. Identify any patterns or trends in the data, such as: a. Time of day or day of the week when activities are most successful b. Combinations of activities that lead to better outcomes c. Any notable differences in success rates between team members or regions Present your analysis in the following format: <analysis> <summary> Provide a brief overview of the key findings from your analysis. </summary> <activity_breakdown> For each activity type, include: 1. Activity name 2. Total number of activities 3. Number of successful activities 4. Success rate 5. Average revenue per successful activity </activity_breakdown> <rankings> List the activity types in order of their effectiveness, considering both success rate and average revenue generated. </rankings> <patterns_and_trends> Describe any notable patterns or trends you've identified in the data. </patterns_and_trends> <recommendations> Based on your analysis, provide 3-5 actionable recommendations for improving sales performance. </recommendations> </analysis> Additional guidelines: - Use clear and concise language in your analysis. - Support your findings with specific data points from the sales data. - If you encounter any anomalies or inconsistencies in the data, note them in your analysis. - Consider the potential limitations of the data and mention them if relevant. - Ensure that your recommendations are specific, measurable, and achievable. Remember to think critically about the data and its implications for the sales team's strategy. Your analysis should provide valuable insights that can be used to optimize sales activities and improve overall performance.