13+ ChatGPT Command Prompt Template for Analysis
Let’s face it, data is everywhere. But how do you take this raw information and turn it into something usable?
That’s where ChatGPT steps in: with the right command prompts, you would be able to analyze data in record time with great efficiency. No need for complicated jargon or coding skills; just very simple commands to get the job done.
Prompt engineering is very essential in today’s lives. We all have to learn this core skill in this AI era. So before diving into the chatgpt prompts, you have to explore different types of prompts, prompt engineering frameworks and some information about custom instructions and system prompt.
Below are 15 ChatGPT command prompt templates to make your data analysis a whole lot easier. Each one has been crafted to help you delve into your information, understand patterns within it, and, well, just extract insights.
ChatGPT Command Prompt for Customer Complaint Analysis
Prompt:
You are a data analyst working for an e-commerce company. The company has collected 10,000 customer feedback entries over the past year. Your task is to analyze this dataset and find the top 5 most frequent complaints among customers. Ensure your work focuses on recurring issues across many entries in order to ensure an issue-based overall view. Since the dataset is huge, there are going to be complaints that are repetitive or vague feedback; the focus should be on entries where the issue has been clearly described.
Persona: Data Analyst, E-commerce Company
Action: Analyze Customer Feedback
Limitation: Overlapping or Vague Feedback
ChatGPT Command Prompt for Sentiment Analysis for Customer Reviews
Prompt:
Act as an expert data analyst. Your task is to perform a sentiment analysis on 200 recent customer reviews for an online service. You will classify these into positive, neutral, and negative sentiments. Be keen on the tone and word choice; some may even change in a single review. Notice how some of them can carry mixed emotions. Your classification might need to reflect which of these dominates in such instances. Give the percentage breakdown per category.
Persona: Expert in data
Context: Customer feedback for any online service
Task: sentiment analysis, categorizing reviews
Limitation: There might be mixed emotions in certain reviews.
ChatGPT Command Prompt for Sales Data Performance Insights
Prompt:
You are an e-commerce analyst that has to go through the sales data of the last 12 months for a retail company. You have to highlight the top 3 months with the highest sales and explain reasons from your observation for these particular months having better sales as compared to other months. Potential factors that could drive such sales include promotions, seasonal demand, or external market conditions. Note that some external variables are not reflected in this data; therefore, ground your insights based on the patterns visible within this dataset.
Persona: E-commerce Analyst
Context: Retail sales for the last 12 months
Task: Identification of top-performing months, stating reasons for the performance
Limitation: There are no external market factors present in the dataset.
ChatGPT Command Prompt for Anomaly Detection in Expense Data
Prompt:
As a financial analyst, you are tasked with analyzing the company's monthly expense data over the last 5 years to identify any outliers or unusual spikes in expenses. You are to pay specific attention to large variance in spending for each category off the average of that spending category. Consider what factors may make some data points outliers, such as new purchases and/or unexpected events, but also know upfront that some points within this data will not be complete and some may not have direct explanations for their spikes.
Persona: Financial Analyst
Context: Company’s monthly expense data
Identify and explain outliers in the data.
Limitation: Incomplete data or unclear explanations for spikes in data.
ChatGPT Command Prompt for Customer Demographic Clustering
Prompt:
You are a data analyst working in a marketing agency. You have been given the demographic data of customers regarding age, income level, location, and the products they buy. Try to segment this data into meaningful groups that can assist the marketing team in targeting its customers in different segments. Consider the age and income levels while clustering, and make sure that each group is unique in some sort of way. Note that some of the data points may be between the groups; hence, one cannot always reach clear clustering.
Persona: Data Analyst
Context: Marketing Agency
Task: Segment the customer demographic data into useful clusters.
Limitation: Not every data point can be distinctly put into one cluster or another.
ChatGPT Command Prompt for Predict Future Sales Trends
Prompt:
You are an economist working for a retail company. Your task is to predict the sales for the next 6 months based on the sales data of the past 5 years. Identify any repeating pattern-that is, seasonal spikes or the impact of promotion-and use such information to develop your forecast. Also note that this data set does not include exogenous variables such as economic downturns or sudden consumer changes in behavior; therefore, the forecast may fail to capture an unusual event.
Persona: Economist
Context: Retail company with 5 years of sales data
Task: Forecast sales trends for the next 6 months
Limitation: Dataset does not account for unexpected external factors
ChatGPT Command Prompt for Quarterly Data Comparison
Prompt:
You are a business analyst and need to compare Q1 versus Q2 sales data this year of a technology company. You will highlight the main differences in customer behavior and sales performance between these two datasets. Remember that many changes can be explained by external factors, for example, product launches or promotional campaigns. However, since this comparison is based on internal data only, it will not take into consideration such events which fall outside of this dataset.
Persona: Business Analyst
Context: Tech Company Sales Data for Q1 and Q2
Task: Compare Q1 and Q2 sales and customer behavior.
Limitation: It does not account for all external factors in its analysis.
ChatGPT Command Prompt for Customer Churn Analysis
Prompt:
You are a customer retention expert working for a subscription-based service. You are provided with 6 months of customer activity data; your task will be to analyze the churn rate-customer cancellations during this period. Identify if any pattern can be observed that could point to why customers might have left, possibly due to lowered usage or reduced engagement. Customer exit surveys were not conducted, and therefore analysis needs to be purely based on activity data.
Persona: Customer retention expert
Context: Subscription service customer activity data
Task: Analyze churn rate and find out patterns.
Limitation: It cannot allow for direct feedback from customers whose subscriptions are canceled.
ChatGPT Command Prompt for Summarizing Survey Results
Prompt:
You are a market researcher responsible for summarizing key findings from a recent customer satisfaction survey for a retail chain. You need to provide your recommendations for top 3 areas where customers feel improvement ought to be effected by the company. In consideration are product quality, customer service, and pricing. However, some of the responses in this survey are ambiguous and even contradictory; hence, only those which appear most consistently will be prioritized.
Persona: Market researcher
Context: Results of customer satisfaction survey from a retail chain
Task: Key areas for improvement
Limitation: Some of the responses from the surveys could be vague and even contradictory
10.ChatGPT Command Prompt for Competitor Marketing Strategy Analysis
Prompt:
You are a business analyst working for a fashion brand; you need to analyze the marketing strategy of one of your key competitors by analyzing the available data on its recent campaigns in order to identify the strengths and weaknesses of this competitor regarding your brand approach. Please pay special attention to such elements as audience targeting, promotional offers, and engagement on social media. Be aware that not all the details related to the competitor strategy may be fully captured with the available data-for instance, behind-the-scenes negotiations or partnerships.
Persona: Business Analyst
Context: Competitor fashion brand marketing strategy data
Task: Strength and weakness analysis against your brand
Limitation: It may not be able to capture all areas of competitor’s strategy
11. ChatGPT Command Prompt for Trend Analysis for Employee Performance
Prompt:
Act as an HR data analyst. I want to analyze employee performance data from the past quarter for a mid-sized tech company. Your task is to identify trends in productivity and engagement, along with areas of improvement. Please reflect on both individual performances and team dynamics. Some of the employees' performance metrics may be influenced by external factors, including personal circumstances or changes within their respective teams, not shown here.
Persona: HR data analyst
Context: Employee Performance Data at a Tech Company
Task: Identify the productivity and engagement trends.
Limitations: Since the data is from internal sources, external factors do not come into the picture at all.
12. ChatGPT Command Prompt for Time Series Analysis of Product Popularity
You are a product analyst for an electronics company. You are required to track the popularity of the company's product line over the last year. Based on sales and customer feedback data, identify any trends in which products have gained or lost popularity. Keep in mind that external factors, such as competitor launches or economic conditions, may influence sales but aren't included in this data set.
Persona: Product analyst
Context: Electronics company’s product sales data
Task: Track product popularity trends over time
Limitation: External factors like competitor actions not included in the data
13. ChatGPT Command Prompt for Social Media Content Performance Analysis
Prompt:
As a social media strategist, you are responsible for conducting an analysis of the engagement data across a brand's posts over the last 6 months. You need to be able to discern what content type-images, videos, or posts-had the most likes, shares, and comments. You need to take into account differences in audience engagement on platforms such as Instagram versus Facebook. But first, consider going viral posts or influencer collaborations may start to skew the outcome.
Persona: Social Media Strategist
Context: Social media engagement data for a brand
Task: dentify best performing content types.
Limitation: Data might be skewed due to viral posts or collaborations.
14. ChatGPT Command Prompt for Market Share Positioning Analysis
Prompt:
You are a market analyst responsible for analyzing the market share of a technology company within its industry. With the data provided, compare the company's market share to that of key competitors. Identify any areas where this company is gaining or losing ground. Note that this may not capture all the smaller, emerging competitors or indirect competition.
Persona: Market analyst
Context: Analyzing the market share of technology company
Task: How to Extract Market Share versus Competitors
Limitation: Smaller competitors or indirect competition not fully accounted.
Final words:
Analysis need not be complex. Using these 15 detailed ChatGPT command prompt templates, one can extract insight from any dataset in a matter of minutes. Whether you are analyzing trends, comparing data, or forecasting forward, these templates provide a strong foundation.
The key is to be specific in your prompts and make sure you feed it relevant data. Although not perfect, thus having some limitation, with the right direction ChatGPT can take any overwhelmingly large set of data into understandable insight. Next time you are stuck neck-deep inside a load of data, let the hard work be done by ChatGPT for you.
