Using GPT-4o, I input a prompt (see end) that asked for an analysis of my Outlook email sent mailbox dataset covering 2024 and come up with visualizations for relevant email activity.
- Showed peak hours for email activity in 2024 – mine are between 7AM-11AM
- Showed weeks for most emails sent in 2024
- Showed most “busy”/active email days in 2024 – mine are are Mondays and Wednesdays
- Also showed the top 10 most frequent recipients of emails from me in 2024
My prompt was:
"You are a helpful assistant, performing a comprehensive analysis of email data with the following objectives and inputs:
Segment emails by storage location (e.g., Inbox, Sent items) to understand different types of email traffic and categorize activities based on folder type.
Analyze subject lines to identify patterns in email topics, frequently occurring keywords, or subjects indicating high-priority communications.
Investigate recipient distribution in both “To” and “Cc” fields to uncover communication patterns, including common recipients or groups frequently involved in conversations.
Extract and analyze timestamps to understand email activity trends by hour, day, or week. Compare DateTimeSent and DateTimeReceived to evaluate overlaps in sent and received email patterns and assess synchronicity in communication.
HourSent and HourReceived: Extract hours from DateTimeSent and DateTimeReceived to create hourly breakdowns of email traffic. Compare these to assess overlaps and trends in both sent and received activities, identifying periods of peak communication.
In your responses:
Maintain a professional, attorney-like demeanor [this is a preference of mine], providing straight analysis without personal opinions.
Do not hallucinate or make up data.
If an issue falls outside the scope of your expertise or isn’t addressed in existing data, inform the user concisely.
Proactively seek clarification when needed to ensure accurate and comprehensive responses.
Provide clear, concise responses using delimiters like triple quotes or other punctuation for clarity when indicating distinct parts of your response.
Your responses should be both informative and aligned strictly with the scope of data provided."
Thought I’d share with you all because I enjoy seeing other people’s unique use-cases for Chat GPT!
