Tracking AI-answers AND SERPs
19 min.
Multiple titles extract in Sheets
1 min.
From structured data to structured language
36 min.
Mastering Ahrefs' SERP-component exports
9 min.
Minimal (but powerful) keyword preprocessing in BigQuery
2 min.
How to partition 4000+ domain names in BigQuery
6 min.
Google Sheets redirect chain checker
16 min.
url_decode 4 google sheets
1 min.
URL path segments and Google Sheets: simple Apps Script
2 min.
Google Sheets scraper
7 min.
Filter links from HTML
1 min.
Remove double trailing slashes with .htaccess
1 min.
Aspect ratio calculator
1 min.
Fetch the Nth segment of a URL in MySQL
2 min.
MySQL word count function
1 min.
Extract the domain name from a URL with MySQL
1 min.
MySQL split string
1 min.
Automatic split .CSV file in macOS terminal
1 min.
Batch rename file extensions in Mac OS X Terminal
1 min.
Merge .csv files in macOS Terminal
1 min.
Bio-rewriter
Free for personal use: a tuned LLM that helps you with your conference or podcast or guestpost bio text. Based on my utility-writing research.
Where AI looks for evidence
An expanding body of research that investigates the types of pages AI looks at when trying to find evidence to back up its claims about you.
trueroot.ai
Source grader
A big-ass checklist of sources to create and improve, with why they help you gain better visibility in AI systems
trueroot.ai
19 min.
Multiple titles extract in Sheets
1 min.
From structured data to structured language
36 min.
Mastering Ahrefs' SERP-component exports
9 min.
Minimal (but powerful) keyword preprocessing in BigQuery
2 min.
How to partition 4000+ domain names in BigQuery
6 min.
Google Sheets redirect chain checker
16 min.
url_decode 4 google sheets
1 min.
URL path segments and Google Sheets: simple Apps Script
2 min.
Google Sheets scraper
7 min.
Filter links from HTML
1 min.
Remove double trailing slashes with .htaccess
1 min.
Aspect ratio calculator
1 min.
Fetch the Nth segment of a URL in MySQL
2 min.
MySQL word count function
1 min.
Extract the domain name from a URL with MySQL
1 min.
MySQL split string
1 min.
Automatic split .CSV file in macOS terminal
1 min.
Batch rename file extensions in Mac OS X Terminal
1 min.
Merge .csv files in macOS Terminal
1 min.
Bio-rewriter
Free for personal use: a tuned LLM that helps you with your conference or podcast or guestpost bio text. Based on my utility-writing research.
Where AI looks for evidence
An expanding body of research that investigates the types of pages AI looks at when trying to find evidence to back up its claims about you.
trueroot.ai
Source grader
A big-ass checklist of sources to create and improve, with why they help you gain better visibility in AI systems
trueroot.ai