Reporting & Data Export

Create a monthly SEO report for amazon.com (top-level metrics only):

1. Current organic traffic estimate
2. Total organic keywords (top 3, top 10, top 50 breakdown)
3. Domain Rating
4. Top 10 keywords by traffic
5. Top 5 pages by traffic
6. Traffic by country (US, UK, DE, FR, JP)

Generate a professional Google Doc report titled "Amazon SEO Performance - December 2024":
- Executive summary with key KPIs
- Organic visibility overview with traffic and keyword charts (use tables)
- Top performing content section
- Geographic distribution analysis
- Recommendations for next month
- Add header with company name and date
- Format with professional styling

New SEO client: patagonia.com
Perform complete onboarding audit:

1. Domain metrics snapshot (DR, traffic, keywords, backlinks)
2. Top 20 organic keywords with positions
3. Top competitors by keyword overlap
4. Backlink profile overview
5. Top referring domains (first 20)
6. Pages best by traffic (top 10)

Create both outputs:

Google Sheets "Patagonia SEO Audit Data":
- Tab per analysis area
- Raw data for analysis
- Filters enabled
- Formatted headers

Google Doc "Patagonia SEO Audit - Executive Summary":
- Professional client-ready format
- Key findings and opportunities
- Priority recommendations
- Next steps proposal

I need to track 30 keywords for the client nike.com in the US market:
running shoes, basketball shoes, air jordan, nike air max, 
athletic wear, sports bra, running shorts, training shoes,
cross training shoes, nike free run, nike pegasus, nike zoom,
workout clothes, gym clothes, nike pro, nike dri-fit,
soccer cleats, football cleats, nike mercurial, nike tiempo,
nike slides, nike sandals, nike socks, nike backpack,
nike hoodie, nike sweatpants, nike jacket, nike shorts men,
nike shoes women, nike sneakers

For each: get current volume, difficulty, and SERP position for nike.com.

Create Google Sheet "Nike Keyword Tracking Dashboard":
- Main tracking sheet with all data
- Conditional formatting: green for top 3, yellow for 4-10, red for 11+
- Summary section at top with averages
- Chart showing position distribution
- Freeze header row, enable filters

Get these metrics for zapier.com and export to Google Sheets:
- Domain Rating
- Organic traffic
- Total keywords
- Referring domains
- Top 10 keywords by traffic

Name the spreadsheet "Zapier SEO Snapshot"

Create a competitor comparison report for my client stripe.com vs:
- square.com
- paypal.com
- adyen.com

Compare:
- Domain Rating
- Organic traffic
- Total keywords
- Backlinks
- Top 3 traffic-driving keywords for each

Create a Google Doc "Stripe vs Competitors - SEO Analysis":
- Executive summary
- Side-by-side comparison table
- Strengths and weaknesses analysis
- Strategic recommendations
- Professional formatting

Create a backlink report for shopify.com.

Include:
- Total backlinks and referring domains
- Top 50 referring domains with DR
- Anchor text distribution (top 20 anchors)
- New vs lost backlinks trend

Export to Google Sheets "Shopify Backlink Report":
- Summary tab with key metrics
- Referring domains tab
- Anchor text tab
- Format with headers and filters

Create a content performance report for the blog.hubspot.com:

1. Top 30 articles by organic traffic
2. Keywords each article ranks for
3. Traffic estimates per article

Export to Google Sheets:
- All data with sortable columns
- Traffic column with conditional formatting (darker green = more traffic)
- Summary showing total blog traffic

Also create a Google Doc summary with:
- Top 5 performing content themes
- Recommendations for future content

Create a geographic traffic report for airbnb.com:

1. Traffic by country (top 20 countries)
2. Top keywords in each of the top 5 countries
3. Regional DR comparison

Export to Google Sheets:
- Country traffic breakdown
- Pie chart showing traffic distribution
- Highlight top 5 countries

Research keywords for "email marketing" in the US and export everything.

Get:
- Main keyword data (volume, difficulty, CPC)
- Top 50 related keywords
- Top 30 search suggestions
- SERP overview for main keyword

Export to Google Sheets "Email Marketing Keyword Research":
- Tab 1: Core keywords with all metrics
- Tab 2: Related keywords
- Tab 3: Search suggestions
- Tab 4: SERP analysis
- All tabs with headers, filters, and proper formatting

Check current rankings for these keywords for hubspot.com:
- crm software
- marketing automation
- sales software
- email marketing
- customer service software

Update my Google Sheet "HubSpot Rank Tracking" with:
- Current position for each keyword
- Add today's date as a new column
- Keep the historical data