Example: Building a SEO Audit Deck Draft
I am an SEO consultant preparing for a pre-discovery call with a potential new client, Ashley Furniture (<https://www.ashleyfurniture.com/>). I need to create a brief but insightful deck with some initial findings and quick, actionable recommendations to demonstrate my expertise and the potential growth opportunities for them.
Create a professional "Initial Findings & Recommendations" presentation.
Go to the Spyfu SEO tool (<https://www.spyfu.com/>), and pull Ashley Furniture data:
- Organic traffic trends (last 12 months)
- Top 10 ranking keywords
- Top 5 competitor domains and traffic share
- Backlink profile overview
- Any other insightful data that you think should be included
Then to to Google PageSpeed Insights and run a page speed test for <https://www.ashleyfurniture.com> homepage to include technical performance insights in the presentation.
The presentation should cover these sections, with no more than 6-8 slides:
- Title slide with executive summary
- Traffic Performance (charts + key metrics)
- Technical performance insights
- Top Keywords Analysis
- Competitive Landscape
- Quick Wins Identified
- Recommendations & Next Steps
Apply professional business theme, include relevant images for visual appeal, use charts and data visualizations, professional consulting style.
Example: Managing Notion Content Calendar
Research the latest interior design trends on Pinterest Trends <https://trends.pinterest.com/>, and create the full month of August 2025’s Pinterest content calendar with total 4 posts (every Wednesday) that align with our brand guidelines.
##Pinterest Trend Research
Navigate to Pinterest Trends (trends.pinterest.com) and identify 5-6 related trending home interior design topics (using keyword “home interior design”) in the United States.
For each topic:
* Search that trend term directly on Pinterest.com (stay on Pinterest - do NOT go to Unsplash, Google Images, or other stock photo sites)
* Analyze 5-10 top-performing Pinterest posts for visual patterns: color palettes, composition styles, text overlay placement
* Note engagement patterns and pin descriptions
##Visual Asset Generation (NOT downloading)
GENERATE 4 Pinterest-ready visual assets (vertical aspect ratio) as photorealistic interior room shot. Each visual should:
* Follow our project brand guidelines
* Incorporate trending topic themes
* Realistic lighting and textures
* Styled room photography aesthetic
* Professional interior photography style
* Be completely original content, not downloaded images, do not add text overlays
##Content Creation
For each of the 4 posts, write:
* SEO-optimized title (under 100 characters)
* Compelling description with relevant hashtags
##Notion Upload
Upload all assets and content details to our Notion database "Pinterest Content Calendar" with:
* Visual assets
* Titles and descriptions
Important constraints:
* Only analyze content directly on Pinterest.com
* Generate all visuals - do not download existing images. NOT abstract graphics or illustrations - create realistic room images that look like professional interior design photography.
* Reference attached brand guidelines throughout
Prompt me to login to Notion when ready
Example: User Journey Analysis
I'm on the UX team at Warby Parker. I need to understand how our online shopping experience for prescription glasses compares to our competitor, LensCrafters, to find ways to make our process smoother for customers. Help to a clear, easy-to-read report in a new Google slides presentation that compares the user experience on both websites.
Act like a first-time customer buying prescription glasses online. Go to both www.warbyparker.com and www.lenscrafters.com and complete the following steps:
- Find and select a standard pair of prescription glasses.
- Go through the steps to add lenses and any common options
- Add the glasses to your cart and begin the checkout process
- Document every step, friction points, and standout features
As you go through the process on both sites, Capture for each step:
- Page/Feature tested
- User experience (Ease of Use) highlights
- Friction points encountered
- Standout positive features
- Conversion barriers
Once you have done the analysis, go create the Google slides presentation. Name the presentation as “UX Research Analysis”, structure the deck to cover below sections:- Title: Comparing the Shopping Experience: Warby Parker vs. LensCrafters
- Quick Summary: A short paragraph with the main takeaway: which site is easier to use and why?
- Journey Comparison Table: side-by-side step analysis comparing the key steps for both brands.
- Friction Point Analysis: A simple, bulleted list about top 5 barriers for each site
- Top 3 Recommendations: A list of the top 3 things Warby Parker could do to make its website better for customers.
Important Constraints:
- Use the desktop websites for this task.
- Navigate up to the checkout page to see what's required using Guest Checkout option, but DO NOT enter any personal information (like your name, email, or credit card). Stop before entering personal information but note required fields, form design, and error handling. Do not place any order.
Please prompt me to login to Google Slides when ready.
Example: Customer Sentiment Analysis
Analyze customer sentiment for Monday.com vs. Asana from public forums over the last 12 months (2024-07-01 to 2025-06-30) and compile the findings into a new Google Sheet. Search forums like Reddit, Quora, and relevant LinkedIn professional groups. For each user comment, capture the Product, categorize its Key Theme (e.g., Usability, Pricing), assign a Sentiment (Positive/Negative/Neutral), pull a Key Quote, and include the Source Link. Find at least 25-30 per product and this will help inform our upcoming product marketing strategy and identify key messaging opportunities.
For the Google sheet, name it as “customer research”:
"Raw Data" Tab: Create columns for: Product (Monday.com/Asan), Key Themes, Sentiment, Key Quote, and Source Link.
"Summary Dashboard" Tab: Generate bar charts comparing the top 3 pain points and praises for both products.
Please prompt me to login to Google Sheets when ready.
Analyze customer sentiment for Monday.com vs. Asana from public forums over the last 12 months (2024-07-01 to 2025-06-30) and compile the findings into a new Google Sheet. Search forums like Reddit, Quora, and relevant LinkedIn professional groups. For each user comment, capture the Product, categorize its Key Theme, assign a Sentiment (Positive/Negative/Neutral), pull a Key Quote, and include the Source Link. Find at least 50-60 per product and this will help inform our upcoming product marketing strategy and identify key messaging opportunities.
Predefined Key Themes (use only these 5):
1. Ease of Use - Interface intuitiveness, learning curve
2. Pricing - Cost concerns, value for money, plan limitations
3. Features & Functionality - Available/missing features, capabilities
4. Customization & Flexibility - Workflow customization, adaptability
5. Integration & Automation - Third-party connections, automated workflows
For the Google sheet, name it as “customer research”:
"Raw Data" Tab: Create columns for: Product (Monday.com/Asan), Key Themes, Sentiment, Key Quote, and Source Link.
"Summary Dashboard" Tab, create two separate bar charts:
- Top 3 pain points (negative sentiment themes) by frequency for Monday.com vs Asana
- Top 3 praises (positive sentiment themes) by frequency for Monday.com vs Asana
Please prompt me to login to Google Sheets when ready.
Example: Youtube Content Research
I want to launch a new YouTube channel focused on productivity topics. Research the landscape and create a comprehensive launch strategy for me.
##Phase 1: Channel Discovery & Analysis
Go to YouTube.com and search for productivity, anti-procrastination, and time management content. Identify the top 6-8 channels that have:
- Have uploaded consistently in the last 3 months
- Get strong engagement AND solid view counts (both raw views and views relative to subscriber count matter)
For each channel, analyze their:
- Content approach and format (tutorials, vlogs, reviews, etc.)
- Most popular video topics from the last 6 months in terms of views
- Thumbnail and title strategies that get highest views
- Upload frequency and timing patterns
##Phase 2: Audience Intelligence Analysis
Navigate to the 2-3 highest-performing videos from each top channel. Click on each video and scroll through the comment sections extensively. Identify:
- Recurring audience pain points and frustrations
- Content requests that aren't being fulfilled
- Common questions that keep appearing across multiple videos
- Audience language patterns (how they describe their problems)
##Phase 3: Content Gap Analysis
Cross-reference your findings with Google Trends to:
- Validate which productivity topics are gaining search momentum
- Identify high-demand topics that top channels aren't covering adequately
- Spot emerging trends in the procrastination/productivity space
##Phase 4: Content Opportunities
Based on your YouTube navigation and comment analysis, identify:
- High-demand topics that existing channels aren't covering adequately
- Content gaps where audience requests aren't being fulfilled
- Unique angles based on actual viewer language and pain points
##Final Deliverable:
Output it as a comprehensive Google Doc named "Productivity YouTube Channel Launch Strategy" coverage these sections:
- Executive summary of key opportunities
- Detailed research analysis with actionable insights
- Content strategy with specific topic or video ideas and rationale
- Positioning recommendations and differentiation plan
- 90-day implementation roadmap
Prompt me to login to Google Doc when ready