Ahrefs Data Pull – Full Competitor SEO Breakdown (Keywords, Backlinks, Content Gap)
UpworkUSNot specifiedexpertScore: 34
AhrefsOff-Page SEOSEO Keyword ResearchSEO AuditSEO BacklinkingSearch Engine Optimization
I am looking for an experienced SEO professional with active Ahrefs access to perform a structured data pull on a competitor website - www.rittenhousepa.com
This is a data extraction and organization project only. No strategy write-up is required. I want clean exports and clearly organized outputs.
Scope
You will analyze one competitor domain (Rittenhouse Psychiatric Associates).
You must include:
* Every service page
* Every condition page
* The ADHD shortage guide page
Responsibilities
1. Compile Full Page List
Create a complete list of URLs for:
* All service pages
* All condition pages
* ADHD shortage guide
Use their sitemap and/or directories to ensure completeness.
2. Organic Keywords Export
Using Ahrefs (Site Explorer → Domain → Organic Keywords):
* Export all keywords ranking positions 1–100 for each URL
* The export must include ranking URL and position
3. Dofollow Backlinks Export
Using Ahrefs (For entire Domain and specific URLS):
* Filter to dofollow only
* Export full backlink dataset
* The export must include target URL so backlinks can be mapped to specific pages
If the export is too large, split into:
* Service page targets
* Condition page targets
* ADHD shortage guide target
4. Relevant Content Gap Analysis
Conduct separate content gap analyses for `~10 pages that you think are most optimal or for the entire set of conditions or services
Deliverables
* Organic keyword export
* Dofollow backlink export(s)
* Content gap export(s)
Requirements
* Active Ahrefs subscription with all of the required feautres
* Strong familiarity with Ahrefs Site Explorer and Content Gap
* Ability to keep analysis tightly relevant (no generic or bloated exports)
This is a focused, execution-based task. If done well, this may lead to additional SEO work.
When applying, briefly confirm:
* Your Ahrefs plan level
* Experience performing competitive keyword and backlink exports
* Estimated turnaround time
Unlock AI Intelligence, score breakdowns, and real-time alerts
Upgrade to Pro — $29.99/moClient
Spent: $912.24Rating: 5.0Verified