SEO IRL
Pipeline
upload_file
Import & EmbedStep 1
filter_alt
DeduplicateStep 2
hub
ClusterStep 3
cleaning_services
DenoiseStep 4
lightbulb
Generate TopicsStep 5
content_copy
Deduplicate TopicsStep 6
account_tree
Label ParentsStep 7
Visualizers
grid_viewTreemap ViewhubRadial Tree
Generator
descriptionContent Brief
Presented by
Amin Foroutan
descriptionStep 8 Content Briefs

Article Brief Generator

Select a labeled Step 7 file, explore parent clusters and article topics, then generate detailed content briefs with a single click.

Finish Step 7 to generate labeled files containing keyword-level hierarchy details.

(Disable if you only need the final brief and outline)

Parent clusters

Select a Step 7 labeled file to see available parent clusters and topics.

codeBackend Code Structure

account_treeProcessing Pipeline

INPUT
keywords.csv
save_upload()
arrow_downward
load_and_clean_data()
→ Remove duplicates, validate
arrow_downward
generate_embeddings_parallel()
→ Split into batches
cloudOpenAI Batch 1
cloudOpenAI Batch 2
cloudOpenAI Batch 3
arrow_downward
write_output_csv()
→ Serialize vectors
OUTPUT
embeddings.csv
Example Data Transformation:
Input:
{
  "Keyword": "best running shoes"
}
arrow_forward
Output:
{
  "Keyword": "best running shoes",
  "Embedding": "[0.023, -0.15, ...]",
  "Is_Brand": false
}

starsKey Features

speed
Parallel Processing
ThreadPoolExecutor for concurrent API calls
storage
File Persistence
Timestamped storage for inputs/outputs
verified
Data Validation
CSV structure validation and cleaning
auto_awesome
OpenAI Integration
text-embedding-3-small model