The method
Use this prompt in ChatGPT to analyze provided BI data and generate concise reports. Input data should be structured (e.g., CSV, JSON). Specify desired report format (Executive Summary, Detailed Analysis) for tailored output. Optimal for identifying key trends.
The prompts
Prompt 1
I am providing business intelligence data in CSV format. Please analyze the data for key trends in customer acquisition cost (CAC), customer lifetime value (CLTV), and churn rate over the past year. Generate an executive summary highlighting the three most significant findings and their potential impact on marketing strategy. The data includes the following columns: Month, CAC, CLTV, ChurnRate. The overall report should be short, no more than 300 words.
Prompt 2
Analyze the following JSON data representing sales performance across different regions. Identify regions with the highest and lowest growth rates. Also find correlation between marketing spend and revenue and produce a detailed report. The JSON includes fields: Region, SalesRevenue, MarketingSpend, PreviousYearSales. Present your findings in a detailed report with charts and graphs generated using markdown. The report should also include specific recommendations for optimizing resource allocation based on your analysis. Limit the report to 500 words.