Loading tutorials…
Loading tutorials…
ATP Pro's $99/mo isn't worth it without the CSV export workflow that turns raw data into a content plan. Most teams export and then leave the file in a Downloads folder. This walks through the import-to-shipped-article pipeline.
Who this is forContent marketers on ATP Pro ($99/mo) who've exported CSVs but never converted them into a content plan. If your Downloads folder has 6 unused ATP exports, this is the workflow that turns them into shipped articles.
What you'll need
Step 1
AnswerThePublic Pro → Search → Export → CSV. Includes all 5 views (Questions, Prepositions, Comparisons, Alphabeticals, Related) + search volume column.
Pro tier exports CSV per search. Free and Individual tiers don't.
Run your search → click Export → choose CSV format (Excel + image options also available; CSV is the only one for data workflows).
CSV includes columns: Question, Type (Question/Preposition/Comparison/Alphabetical/Related), Search Volume.
Save the CSV with a clear name: 'atp-2026-Q2-email-marketing.csv' beats 'export(7).csv'. Naming convention saves time on quarterly review.
Step 2
Notion database or Airtable base with columns: Question, Source View, ATP Volume, Ahrefs Volume, Ahrefs KD, Intent, Cluster, Status, Priority, Target URL.
Build the template once; reuse for every quarterly import.
Required columns: Question (Title), Source View (Select: Questions/Prepositions/Comparisons/Alphabeticals/Related), ATP Volume (Number), Ahrefs Volume (Number), Ahrefs KD (Number), Intent (Select: info/commercial/transactional), Cluster (Text), Status (Select: idea/researched/briefed/drafted/published/archived), Priority (1-10), Target URL (URL).
Optional columns: Pillar (links to your content pillars), Writer (assigned), Publish Date, Notes.
Notion: use a Database with Table + Board views. Airtable: use a Grid + Kanban view setup. Either works.
Step 3
Notion/Airtable → Import → CSV → map ATP columns to your template columns. Status defaults to "idea."
Notion: New page → Import → CSV → upload → map columns (Question → Title, Type → Source View, Search Volume → ATP Volume).
Airtable: Create base → + Add or import → CSV → map columns.
Don't import all rows. Most CSVs have 200-400 rows; you want 80-150 after a first-pass volume filter.
First filter in spreadsheet BEFORE import: drop rows with under 50 monthly volume (ATP). Cuts noise to manageable.
Set Status = 'idea' for all imported rows. Status column drives your workflow.
Step 4
Filter 1: intent fit (drop irrelevant). Filter 2: pillar match (drop off-pillar). Filter 3: authority match (drop unwinnable). Survivors get Ahrefs validation.
Filter 1 — Intent fit: read each question. Does someone with this query become your customer? If clearly no, mark Status = 'archived.'
Filter 2 — Pillar match: which content pillar does this fit? If none of your defined pillars, mark Status = 'archived.'
Filter 3 — Authority match: skim the live SERP for high-volume candidates. If top 10 are all DR 70+ and your DR is under 40, mark Status = 'archived.'
Surviving rows: usually 30-60 candidates per quarterly import. These move to Status = 'researched' after Ahrefs validation.
Archived rows aren't deleted — they may surface in future quarters as your authority grows.
Step 5
Take 30-60 survivor questions. Paste into Ahrefs Keywords Explorer in batches of 100 (free tier). Add Ahrefs Volume + KD columns.
Open Ahrefs Keywords Explorer → enter up to 100 keywords (free tier limit). Paste from your filtered Notion/Airtable.
Capture Ahrefs Volume + KD for each. Manually update the corresponding rows in your template.
Drop candidates where: Ahrefs Volume is below 100/mo (unless ultra-high intent), KD is 20+ above your DR, or top SERP is unwinnable.
Surviving rows after Ahrefs validation: 15-25 per quarter. Status = 'researched.'
If you have Ahrefs API access (Advanced tier), this step automates. Most teams do manually — it's 30-45 min per quarterly batch.
Step 6
Group researched candidates into clusters (5-12 questions per article). Assign Priority Score. Top 8-12 clusters fill the quarter.
Open the researched candidates. Group by SERP overlap into clusters (one cluster = one article).
Tag each cluster in the Cluster column (e.g., 'email-list-building,' 'cold-email-deliverability').
Assign Priority Score per cluster: Volume (40%) + KD vs DR fit (25%) + Angle clarity (20%) + Conversion potential (15%).
Sort by Priority. Top 8-12 clusters = quarterly editorial calendar. Move each to Status = 'briefed' as briefs get written.
Buffer 1-2 weeks of slack — content commitments slip. Don't load all 12 weeks tight.
Step 7
Quarter end: run new ATP searches, export new CSVs, import into the same template. Old "archived" rows stay; new "idea" rows added.
Quarterly cadence: same template, new CSV imports.
Don't replace the template; append new imports. Archived ideas from old quarters may move to 'idea' if your authority has grown.
Each quarter: run 3-5 ATP searches → export → filter → import → validate → cluster → prioritize. 90 min total.
Reference last quarter's published articles + ranking outcomes. Adjust priority weighting if patterns emerge (e.g., comparison content ranks faster — bump conversion-potential weight).
Common mistakes
Exporting CSVs but never importing them
What goes wrong: You have 5 unopened ATP CSV exports in your Downloads folder. You paid $99/mo × 5 months = $495 for data you never used. The Pro subscription provided $0 of actual content output. Pure waste.
How to avoid: Block 60 min on your calendar within 48 hours of each ATP search. Run the import + filter pipeline immediately. CSV data that sits more than a week rarely gets used.
Importing all 200-400 rows without a first-pass filter
What goes wrong: You paste an entire CSV into Notion. The database becomes unmanageable — 300+ rows where 80% are noise. You can't find the high-value ideas. Decision fatigue kicks in. You stop using the database after week 2. ~$60 of operator time wasted on the setup.
How to avoid: First filter happens in the spreadsheet BEFORE Notion import. Drop volume under 50, drop obvious off-pillar, drop ultra-narrow long-tail. Import 80-150 rows, not 300-400.
Skipping the Ahrefs validation step
What goes wrong: You commit to briefs based on ATP volume alone. ATP volume is 60-90% accurate vs Ahrefs — half your prioritized briefs were on weak keywords. Across a quarter, 4-6 published articles get 30-50% of expected traffic. ~$500-1,000 of misallocated writer time.
How to avoid: Always Ahrefs-validate the top 30-60 survivors before brief commit. 30-45 min of validation prevents 4-6 hours of misallocated writing per quarter.
Treating "Status: idea" as the end state
What goes wrong: You import 100 ideas. None move past 'idea' status. The Notion database becomes a wishlist instead of a pipeline. Six months later, you have 400 ideas and 6 published articles. The ideation phase ate all the time meant for execution.
How to avoid: Status field is the workflow driver. Move ideas through: idea → researched → briefed → drafted → published. Track weekly. Ideas stuck at 'idea' for 60+ days get archived — keep the pipeline flowing.
Building separate templates for each quarterly import
What goes wrong: You import Q1 ATP data into one Notion DB, Q2 into another, Q3 into a third. Searching across quarters is impossible. Archived Q1 ideas you'd revisit in Q3 are lost. You re-mine the same topics quarterly and can't see overlap.
How to avoid: One persistent template; append new quarterly imports as new rows. Archived rows stay accessible. Future-quarter mining can pull from archived bank when authority grows.
Not closing the loop with ranking outcomes
What goes wrong: You import, filter, brief, draft, publish — but never go back to mark which articles ranked top 10. No feedback loop. You keep using the same Priority Score weighting even though it's miscalibrated for your domain. Six months in, the workflow stops compounding.
How to avoid: Add a 'Rank at 90 days' column. Quarterly review: per-pillar rank rate. Adjust Priority Score weighting if pattern emerges. The pipeline learns from outcomes.
Recap
Done — what's next
How to run an AnswerThePublic keyword research session that produces briefs
Read the next tutorial
Hand it off
Running the CSV-to-content-plan pipeline is a 90-min quarterly session. A vetted SEO content specialist on EverestX will own the full pipeline — import, filter, validate, cluster, brief, publish, track — typically $500-1,000/mo at $14-16/hr.
See specialist rates
Yes — Google Sheets or Excel work fine. Notion/Airtable add workflow features (Kanban view, Status automation, linked databases) that solo operators don't need. Sheets is the lowest-friction starting point; upgrade to Notion/Airtable when you have a team.
Add a 'Pillar' column (Select field with options matching your 3-5 defined pillars). Filter views by pillar to see per-pillar pipelines. Don't create separate databases per pillar — search and reporting fragment.
Quarterly batch. Importing on every search creates database churn — each search adds 80-150 rows that need filtering. Quarterly batches let you filter + validate in one focused session.
60 days. If an idea hasn't moved to 'researched' in 60 days, it's not a priority — archive it. Future quarters can resurface it. Pipeline hygiene matters more than idea hoarding.
Yes if you have Ahrefs API access (Advanced tier, $399/mo+). Use Zapier or Make to push Notion rows to Ahrefs API and pull back Volume + KD. Most teams do manually — the 30-45 min per quarterly batch isn't worth $200/mo upgrade.
AnswerThePublic
AnswerThePublic gives you 300+ questions per search. The job is filtering them down to the 8-15 that produce ranking articles. This walks through the production workflow — seed → filter → cluster → brief — that turns question lists into a quarter's content roadmap.
AnswerThePublic
Most content teams ideate blog topics in scattered Slack threads and editorial meetings. ATP turns ideation into a 2-hour quarterly session that produces 30-50 vetted ideas. This walks through the workflow.
AnswerThePublic
AnswerThePublic looks like a one-input toy at the marketing-site level and turns into a real content-research backbone once you understand the Pro features. This walks through the plan choice, region lock, and first-search calibration that most buyers misconfigure before their first batch of content briefs.
Ahrefs
Keywords Explorer is the most-used Ahrefs module and the easiest to use badly. This walks through the operator workflow — intent first, Parent Topic second, raw volume last.
AnswerThePublic
AnswerThePublic's alerts feature surfaces new questions as they enter Google autocomplete — early signal for trending topics. Most Pro subscribers never enable it. This walks through the monitoring workflow that catches trends 60-90 days before they're obvious.