Backlinks & Digital PR

I'm doing link building for rei.com (outdoor retailer).

1. Analyze their current backlink profile (total links, referring domains, DR distribution)
2. Find their top 10 link magnet pages - what content gets the most links?
3. Analyze anchor text distribution - are they over-optimized?
4. Find broken backlinks (link reclamation opportunities)
5. Identify their top linking domains

Then research competitor backlinks:
- Get referring domains for backcountry.com that DON'T link to rei.com

Export to Google Sheets:
- Tab 1: REI backlink overview
- Tab 2: Link magnet analysis (pages + why they attract links)
- Tab 3: Broken link reclamation list
- Tab 4: Competitor link opportunities
- Format with headers, filters enabled, and conditional formatting for DR

I need to plan a digital PR campaign for a sustainable fashion brand in the UK.

1. Research Reddit for discussions about "sustainable fashion", "eco-friendly clothing", 
   and "ethical fashion brands" - find the most engaged communities and top posts
2. Analyze backlinks to goodonyou.eco to understand what stories earn press links
3. Find the top 20 sustainability-focused pages getting backlinks in the fashion niche
4. Research web for recent news about sustainable fashion trends

Create a Google Doc "Digital PR Strategy - Sustainable Fashion" with:
- Audience insights from Reddit (what do people care about?)
- Media angle recommendations based on successful competitor stories
- Target publication list (domains linking to competitors)
- Content ideas that could earn links
- Outreach messaging framework

Audit the backlink profile of moz.com for potential issues:

1. Overall backlink stats (total links, referring domains, dofollow ratio)
2. Anchor text analysis - check for over-optimization
3. Top referring domains by DR - quality assessment
4. Link velocity - are they gaining or losing links?
5. Broken backlinks that need reclamation

Create a health scorecard in Google Sheets:
- Summary tab with key metrics and health score (1-10)
- Anchor text distribution pie chart
- Top referring domains list
- Issues and recommendations tab
- Color-code issues by severity (red/yellow/green)

Give me a backlink overview for semrush.com:
- Total backlinks
- Referring domains
- Domain Rating
- Dofollow vs nofollow ratio

What's the overall quality of their link profile?

Show me the top 30 referring domains for neilpatel.com.
For each domain, include:
- Domain Rating
- Number of backlinks from that domain
- Is it dofollow or nofollow?

Export to Google Sheets sorted by DR.

Analyze the anchor text distribution for ahrefs.com.
- What percentage is branded anchors?
- What percentage is exact match keyword anchors?
- Are there any signs of over-optimization?

Give me the top 20 anchors by frequency.

Find broken backlinks pointing to buffer.com.
Prioritize by the source domain's DR.
Give me a list of the top 20 broken link opportunities.

Export to Google Sheets with:
- Source URL
- Source domain DR
- Original target URL
- Suggested action

I own mailchimp.com. Find domains that link to these competitors but NOT to me:
- constantcontact.com
- sendinblue.com
- convertkit.com

Filter for domains with DR > 40.
Export the top 50 opportunities to Google Sheets.

Analyze the top 10 pages on hubspot.com that have earned the most backlinks.
What type of content are they? (guides, tools, research, templates?)
What topics attract the most links?

Create a Google Doc summarizing:
- Content patterns that work
- Ideas I can replicate for my own link building

Research Reddit for discussions about "remote work tools" and "work from home productivity".
Find:
- The most active subreddits discussing these topics
- Top posts with high engagement
- Common pain points people mention
- Questions people frequently ask

Summarize the insights in a Google Doc for our PR team.