Skip to content

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»

SearchSearches per monthWho occupies the top 10Decision
agencia seo bogota1,000AgenciesDiscarded: whoever types it wants an agency, and I'm not one
consultor seo390Consultants' personal sites (average authority 46)Home page pillar
auditoria seo70Free tools (Semrush, Seobility)First deliverable, not the headline
auditoria seo precio10No 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 pillarSearches per monthReal-KDTop 10 average authorityDecision
single page application seo8805559.6First pillar in English: the lowest authority and a site with authority 24 in position 4
llms.txt5,4005581.1Second: two of the four reviewed pages in the top are short
geo seo2,9007080.5Wikipedia, Google and Coursera in the top: not winnable with content
semantic seo8806877.0Downgraded 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

PageClicksImpressionsAverage position
/121.0
/sobre-mi034.3
/blog/core-web-vitals0577.6
/portafolio/seo-app-react-base44015.0
/portafolio/investigacion-de-keywords017.0
/blog/mi-pagina-no-aparece-en-google017.0
/auditoria-seo01100.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.

DateImpressions (30 days)Clicks (30 days)Non-brand queries with impressions
Sep 17, 20261014
Oct 19, 2026pendingpendingpending
Nov 19, 2026pendingpendingpending

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.

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.

DateWhat 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

Is your site aiming at the right searches?

In the free diagnosis I also tell you whether your pages answer what your customer is looking for.

Get a free diagnosis

CayuAbout me