Sample Queries For Data, Marketing, Writing, and Coding
I’ll walk you through over 30 use cases showing how ChatGPT can simplify your writing, data analysis, marketing, and sales tasks.
Imagine having a virtual co-founder, a freelance data analyst, a pair programmer, and more.
You need 6 minutes to read this, but instead jump to the relevant section.
Related:
Entrepreneurship
Created a co-founder CustomGPT with a knowledge base of my blogs or case studies. I ask it questions to help me make decisions as a solo entrepreneur.
Product management tasks
Convert between formats in PRD - use cases, JTBDs, or acceptance criteria.
Analyze the issue in this list of commands and outputs. Create a Jira ticket with the correct summary and description, then supporting commands to run to recreate it.
Write a Jira ticket by reading my draft title and raw notes from customer chat about XYZ.
Combine two roadmap documents into one. More details below.
Customer interview synthesis, for example, helping create 12 Essential Questions Every Parent Should Consider For Schools In Ireland and Here Is The Advice I Got From Consultants With 236+ Years Of Experience Collectively.
Combine two roadmaps
Connect the table from person A about our roadmap to my roadmap table.
This will allow me to add new rows to my table and consider dates. My table is in csv attached.
Use the team names and feature names from my table. Note that my table does not have all the features of the other road map table from person A, which has more swimming lanes and more features.
First, connect each swim lane from person A to my team. Second, connect each feature from person A with my features.
Remember that a feature's classification may differ in the two tables. organize these raw notes from a conversation into the below headings
Customer Interview synthesis
I asked 24 parents about their experience and decisions in applying and choosing schools for their kid(s). I want you to review the responses to one question from all parents and synthesize it. i will give you one question and all answers to it. write most of this in past tense. combine the quotes, common themes, and variant views. here is the format you should use for the output:
step 1 identify Common Themes: Identify and describe up to 5 themes that emerge from the responses.
step 2 Variations/Divergent Views: Highlight any unique responses or differing opinions that provide an alternative perspective or highlight less common concerns. per theme that you identified in step 1. do step 1 before doing step 2.
step 3 Representative Quotes: Include 2-3 quotes per theme from different parents to backup or show a divergence per common theme you've identified.
quantify how many rows were showing up in each theme instead of writing "many" or "significant number of".
although i will paste a bigger part of my table, i want you to focus on: "Q: What other schools did you consider before choosing this school?" but to help you answer this question, i'm pasting context from other questions.
Technical engineering solutions
I want to create a GoogleScript to find files in my Google Drive open to public access or beyond the shortlist of email IDs I give you. How do I start? More details: Pair Programming Google App Scripts with ChatGPT - Google Drive Permissions Audit.
Programming resume parser. More details: How I Ditched No-Code And Used Chatgpt To Launch A Product In 2 Hours
Programming home assistant node-red functions
What are the following git commands I need to write based on my current status to help me submit PR?
Help me understand what NAME means in this engineering conversation.
I am new to this domain. Help me understand what the engineers are saying in this Slack thread.
Help me understand docker and Kubernetes from the basics. For example, what if I only have a laptop and know how it works but nothing beyond it?
Data analysis
Find anomalies in a CSV dataset.
Write SQL or Excel formulae.
How do I write the formula in notion to use the input as a quarter (Q3 2024) and write the start and end date of the quarter?
CustomGPT using data from food nutrition to rank food items. Read more: How To Use Data And Metrics To Make Better Protein Choices
Understanding Blogs and guides
Heymarvin uses a style of questions in discussion guides that starts with / slash. The format or wording of those questions is interesting. I want you to understand the best practices from this blog and tell me.
How does the below information describe train.py, and what is the name for that script, e.g., entry point script or model training script, etc?
Marketing tasks
Help in competitor research by formatting web scraping - case studies, list of customers. More: Using ChatGPT for competitive analysis as a Product Manager - Mix of success and failure and Use ChatGPT to Extract Valuable Insights for Competitive Analysis from Social Media or LinkedIn
Think of each word in my LinkedIn headline, and see if it should be or not be there. Let’s Think Step by Step. Elaborate on your thinking.
Help me think of how to edit this to make it less about the tech and more about what it enables customers to do.
Writing improvements
Edit to remove adverbs, passive voice, and typos. Read more: Implementing Eva Parish’s Editing Tips Using ChatGPT
Edit transcription to my style. Read more: Make ChatGPT Write In Your Style, Your Tone: Step-By-Step Guide
Suggest a video description that I can add to the YouTube video. Use the context below.
Add emojis to social media posts or messages.
Review my post and point out the missing parts. Read more: Reduce Writing Time by 58% And Improve Quality With AI And Your Voice
Review my post and suggest multiple title subtitle ideas with reasoning.
Review the section headings in this post and suggest improvements with reasoning. Consider ease of summarizing the section, SEO, simple words, and brevity. Give me the output as a before-after with explanations. Read the article to get the context of each section.
If there are major improvements to be made by rewriting sentences or headings or creating a bulleted list, point it out to me.
Give me intro ideas for my article. The intro should draw the right reader in by showing them what value they gain from this article. Right in a similar writing tone and style as the rest of the article.
Review my post and point out grammar mistakes, changes for ease of reading, and typos.
Create a storybook based on my wife and my personalities, likes, and dislikes. Read more: Illustrated Storybook: My 5 Steps With ChatGPT And Midjourney
Business writing improvements
Draft my email based on the context in this Slack thread
People say I write very formally. Convert my draft message below to a more casual conversational tone for a direct message on LinkedIn/Slack.
How do I keep a short objective like NAME but also clarify why it is reliable? So that developers can iterate fast to meet customer needs. Think of 10 ways to rewrite the objective while explaining your reasoning for word choice, length, etc.
Sales and Managing Relationships
Review CRM notes to suggest reconnection messages. Read more: 12 Learnings And Tips From Reconnecting With Social And Work Connections
Review past convo to suggest the next follow-up or reconnection message.
Analyze a conversation thread to extract notes to add to CRM.
Practice pitch, get feedback, and prepare FAQs.
Create a private custom GPT with Peter K's Founding sales book. Ask it sales questions as a founder.
Everyone keeps asking me, 'How is your work going at the new place?' because I joined NAME as ROLE recently. Tell me the elements of a good answer I can reuse when speaking to people or typing in instant messages virtually.
Job Hunt
I know a product manager at a healthcare tech company. I want to identify all words in his resume related to the healthcare domain and find ways to abstract them. I will give you his resume. I need you to reproduce his bullet points as-is but put all such words in bold italics. First, list 50 healthcare-related terms commonly found in resumes within the healthcare tech sector.
Related: