Case: how I decided what to sell with data, not intuition
By Carlos Alberto Cardona B. · published · updated
Before writing a single page of this site I had to decide what to sell. Intuition said «SEO auditor». The data said something else, and this case tells how.
It's a small and recent case, so the results section is honest: four days of indexing and a fixed date to measure again.
What needed solving
I was going to advertise as an SEO auditor. It made sense: an audit ends in recommendations, and every recommendation is a service. But I hadn't measured anything.
The risk was the usual one: picking the biggest search without looking at who types it or who already wins it, and finding out six months later with a whole site aimed at the wrong place.
What was done
I measured Google Ads volumes in Colombia, Spain and Mexico, checked who occupied the top 10 for each candidate and calculated difficulty from that real top 10. Then I grouped by intent, not by how similar the words looked.
Google Ads via DataForSEO · Colombia · September 2026 · a single source, except for «auditoria seo»
| Search | Searches per month | Who occupies the top 10 | Decision |
|---|---|---|---|
| agencia seo bogota | 1,000 | Agencies | Discarded: whoever types it wants an agency, and I'm not one |
| consultor seo | 390 | Consultants' personal sites (average authority 46) | Home page pillar |
| auditoria seo | 70 | Free tools (Semrush, Seobility) | First deliverable, not the headline |
| auditoria seo precio | 10 | — | No volume to lose: the price isn't published at launch |
I try to cross-check every volume with a second tool and declare the difference. In this research I could only do it for «auditoria seo»: 70 searches per month in Google Ads and 60 in Mangools. The second source got blocked by its usage limit, and I wrote that down instead of presenting the other figures as cross-checked.
On September 17 I repeated the exercise in English for the future version of the site. There, calculated difficulty changed a decision already made: «semantic seo» looked like the ideal cluster by volume and fell apart when I measured who occupies its top 10.
United States · Google Ads volume (DataForSEO) · Cayu Real-KD on the live top 10 · Sep 17, 2026
| Candidate pillar | Searches per month | Real-KD | Top 10 average authority | Decision |
|---|---|---|---|---|
| single page application seo | 880 | 55 | 59.6 | First pillar in English: the lowest authority and a site with authority 24 in position 4 |
| llms.txt | 5,400 | 55 | 81.1 | Second: two of the four reviewed pages in the top are short |
| geo seo | 2,900 | 70 | 80.5 | Wikipedia, Google and Coursera in the top: not winnable with content |
| semantic seo | 880 | 68 | 77.0 | Downgraded to a copy angle: the top 10 is the industry's big publishers |
How it turned out later
This site's home page positions as a technical SEO consultant, the audit lives on its own page as a deliverable, and the AI assistants topic has its own service. That was the decision. What follows is what Google says four days after indexing the site.
Google Search Console (API), propiedad de dominio · Aug 20 to Sep 17, 2026 · totals: 10 impressions, 1 click
| Page | Clicks | Impressions | Average position |
|---|---|---|---|
| / | 1 | 2 | 1.0 |
| /sobre-mi | 0 | 3 | 4.3 |
| /blog/core-web-vitals | 0 | 5 | 77.6 |
| /portafolio/seo-app-react-base44 | 0 | 1 | 5.0 |
| /portafolio/investigacion-de-keywords | 0 | 1 | 7.0 |
| /blog/mi-pagina-no-aparece-en-google | 0 | 1 | 7.0 |
| /auditoria-seo | 0 | 1 | 100.0 |
Ten impressions are not a trend and I won't dress them up as one. The home page shows in position 1 only for searches of my name; the blog pages are starting to surface in positions 77 to 95 for «core web vitals», which is exactly what you'd expect from a four-day-old site.
Scheduled measurements. The table gets filled in on each date, with the instrument and the window.
| Date | Impressions (30 days) | Clicks (30 days) | Non-brand queries with impressions |
|---|---|---|---|
| Sep 17, 2026 | 10 | 1 | 4 |
| Oct 19, 2026 | pending | pending | pending |
| Nov 19, 2026 | pending | pending | pending |
What I learned, mistakes included
Until September 15 this page said «I cross-check every volume with a second tool». It was an exaggeration: I had only done it for one keyword. I corrected it and left the correction in writing.
Commercial tools gave me difficulty 0 for «consultor seo» and 0 for «single page application seo». Both had a top 10 with real authority. Since then difficulty gets calculated, not looked up.
And I learned that volume doesn't decide alone. «semantic seo» had 880 searches and my LinkedIn headline pointed there; the top 10 said no, and the top 10 rules.
If you want to check it yourself
Search «consultor seo» on Google from Colombia and look at who occupies the first ten results: personal sites, not agencies. Then search «agencia seo bogota». The difference in intent is what decided this site.
The tool I used to calculate difficulty is Cayu.
The first pillar in English, SPA SEO, rests on the React app case.
How this site was put into production after deciding: the domain and Worker case.
What I can't claim
Google Ads volumes come in rounded bands: «10» means «between 0 and about 15». And except for «auditoria seo», every figure comes from a single instrument.
I don't claim positions for any commercial keyword: with ten impressions, any average position is noise.
Next measurement
The dates are written before the data exists. If I haven't updated this page by then, call me on it.
| Date | What gets measured |
|---|---|
| 30-day impressions and clicks; non-brand queries with impressions; first reading of «consultor seo» | |
| Second reading and decision on the first article in English |