Competitive Analysis

Perform a comprehensive SEO analysis of hubspot.com:

1. Domain metrics: DR, organic traffic, total keywords, traffic value
2. Top 20 organic keywords by traffic
3. Top 10 pages by traffic
4. Backlink profile: total backlinks, referring domains, DR distribution
5. Top 5 organic competitors by keyword overlap
6. Historical traffic trend (last 6 months)

Create a professional Google Doc titled "HubSpot SEO Analysis Report" with:
- Executive summary with key findings
- Sections for each analysis area with tables
- SWOT analysis based on the data
- Strategic recommendations
- Professional formatting with headers, bullet points, and proper spacing

Compare these 5 CRM software companies:
- salesforce.com
- hubspot.com
- zoho.com
- pipedrive.com
- monday.com

For each, get:
- Domain Rating
- Organic traffic estimate
- Total organic keywords
- Top 5 ranking keywords
- Number of referring domains

Export to Google Sheets with:
- Comparison matrix on first tab
- Bar chart comparing DR and traffic
- Ranking by each metric
- Highlight the leader in each category with green background

I'm analyzing the German fintech space. Evaluate authority and content strategy for:
- n26.com
- trade-republic.com
- scalable.capital
- finanzfluss.de

For each site:
1. Get DR and DR history (is authority growing?)
2. Find their top 5 link magnet pages (best by external links)
3. Identify their organic traffic growth trend
4. Find their top commercial-intent keywords

Create a Google Doc "German Fintech SEO Landscape" with competitive intelligence report.

Compare the SEO metrics of these three sites:
- shopify.com
- bigcommerce.com
- wix.com

Show me: Domain Rating, organic traffic, and total backlinks for each.
Which one has the strongest SEO presence?

Find the top 10 organic competitors for ahrefs.com.
Show me the keyword overlap percentage for each competitor.
Which competitors should I analyze more closely?

Analyze the organic traffic history for nerdwallet.com over the last 12 months.
- Has traffic been growing or declining?
- What's the estimated monthly organic traffic?
- What are their top 5 pages driving traffic?

Create a summary in Google Docs with insights and trends.

Show me the top 20 pages by organic traffic for backlinko.com.
For each page, include:
- URL
- Estimated traffic
- Main keyword it ranks for
- Number of keywords the page ranks for

Export to Google Sheets with the data sorted by traffic.

Analyze the geographic distribution of organic traffic for booking.com.
Which countries drive the most traffic?
Show me the top 10 countries with their traffic estimates.