🔵🔴 Ethan's AI & Organic Venn Generator

Figure out which of your pages are working better for AI, organic, or both. Upload a spreadsheet of URLs with their AI citation counts and organic click counts, and this tool sorts every one of them into AI only, organic only, both, or neither. Adjust your thresholds, and the diagram, the table, and the URL lists all update in real time.

Free Client-Side Only Updated 2026

Upload your data

A spreadsheet with a header row, and columns for a URL, an AI citation count, and an organic click count, in any order. This tool tries to find those columns automatically; if it can't, you'll get a quick chance to point at them yourself. CSV, TSV, and Excel files all work. You can also download this row-header CSV template.

Drop a spreadsheet here, or click to choose a file

CSV, TSV, or Excel · rows beyond 20,000 are trimmed

Some required columns weren't recognized automatically. Assign them below.

URL

AI Citations

Organic Clicks

Overlap

Upload a file to see results here.

Not to scale

AI citation threshold

range 0–1 0% of URLs meet this

Organic click threshold

range 0–10 0% of URLs meet this

A URL counts as visible in a section if it meets or exceeds the thresholds set here.

Show % of all uploaded URLs in the summary table

Bucket	% of URLs	URLs	AI Citations	% of AI Citations	Organic Clicks	% of Organic Clicks

URLs by bucket

Updates automatically with the thresholds above. Full export available below.

🔵🔴 Ethan's AI & Organic Venn Generator

Upload your data

Overlap

URLs by bucket

Interpretation

Export