graph TD
A[Read keywords_with_metrics.csv] --> B[Parse CSV Data]
B --> C[Initialize LLM Classifier]
C --> D{Process Each Keyword}
D --> E[Extract Keyword Text]
E --> F[Apply LLM Classification]
F --> G{Determine Intent}
G -->|Buyer Signals| H[Label as Buyer]
G -->|Info Signals| I[Label as Informational]
H --> J[Add Intent Column]
I --> J
J --> K[Compile Updated CSV]
K --> L[Save keywords_with_intent.csv]
L --> M[Return Final CSV]
subgraph Silo1[LLM Classification]
C
D
E
F
G
H
I
end
subgraph Silo2[CSV Processing]
A
B
J
K
L
M
end