c/freelance-seo-hub

Looking for a better way to track keyword movement for a bunch of small sites

About three months ago, I took on five local business clients, all in different towns. My old method was just checking their main keywords in a spreadsheet once a month, but that fell apart fast. Last week, I spent over six hours just copying and pasting ranks from a free checker for all of them, and I know I missed stuff. It's a mess trying to see what's actually working for the plumber in Dayton versus the cafe in Springfield. I need a system that doesn't eat a whole day. Has anyone set up a simple dashboard or found a tool, even a cheap one, that can handle tracking for multiple small clients without getting crazy complex?

Okay so I was wrong about those AI content detectors

For months I ignored them, thinking they were just a gimmick. Then a buddy sent me a 2,000-word article he wrote that got flagged by Originality.ai. I ran it through three other tools and they all said the same thing. It turns out his 'writer' had been using a spinner the whole time. Has anyone else been burned by a tool they didn't trust at first?

Pro tip: my main client's site got hit with a manual action last week

I logged into Search Console on Tuesday and saw the notification (my heart just dropped). It was for unnatural links, and the penalty date was retroactive by about 4 months. I had to scramble to pull a full backlink report, identify the toxic ones, and start the disavow process immediately. Has anyone else had to submit a reconsideration request recently and know how long the review is taking now?

I finally tried that AI content tool everyone was talking about

I paid $200 for a year of a tool that promised to write full blog posts, but the stuff it made got flagged as thin content by Google after a month. Has anyone else had this happen and found a better way to use AI for writing?

TIL a lot of new freelancers think a 'backlink' is just any link from another site, but after reviewing 50 client reports, I've seen that a link from a spammy directory can actually hurt more than help.

Has anyone else had to explain to a client why their 'cheap link building' service from two years ago is now causing manual actions?

My neighbor, who runs a small bakery, asked me if SEO is just about keywords now

He said he heard from a podcast that Google's looking more at 'helpful content' and real answers, which made me rethink my whole checklist approach. What's the one thing you've changed in your process because of this shift?

Can we talk about the 'content is king' mantra in SEO?

I heard a speaker at a virtual meetup say 'content is king' is an excuse for bad technical work, and honestly, after fixing a site's crawl budget last week, I think he had a point. Has anyone else seen a site rank better just from fixing basic issues, not just writing more?

A podcast host said local SEO is just about citations and it made me pause

I was listening to a marketing podcast on my drive home yesterday. The host, who runs a big agency, said that for local businesses, SEO is 90% about getting your name, address, and phone number listed on as many sites as possible. He called it 'citation blasting' and said to just use a tool to submit to hundreds of directories. That felt off to me. My own small clients in my town see way better results when I focus on a few key directories, get good reviews, and write helpful content about the area. It's more work, but it actually builds trust. Has anyone else found that a slower, more careful approach beats just blasting out your info everywhere?

Warning: A client meeting in a Chicago coffee shop made me ditch my whole content plan.

They straight up said 'I don't care about your 2,000 word blog posts, I just need the phone to ring.' Now I only write stuff that directly answers local search questions. Anyone else get hit with a reality check like that?

A client in Tempe told me to stop chasing keyword rankings

I was showing him a report full of green arrows, and he just asked 'Did this bring in a new customer?' It happened over coffee at Cartel, and now I only track leads and calls. Anyone else had a client shift their focus like that?

I finally listened to that guy from the Denver meetup about local citations

He told me to stop focusing on national directories for my client's plumbing business and just get listed on 5 local sites like the Chamber and Nextdoor. I thought it was a waste of time for 2 months, but their map pack ranking jumped from the 4th page to the top 3 spots last week. Has anyone else seen results that fast from cleaning up local citations?

This guy at a meetup told me my SEO strategy was 'cute'

Honestly, it was at that local digital marketing meetup in Phoenix about two months ago. I was explaining how I got a small e-commerce site from page 4 to page 1 for a decent keyword in under 90 days. This dude just smirked and said, 'That's cute, but real SEO is about enterprise-level backlink profiles.' He didn't even ask about my process or the tools I used. It just felt so dismissive of the actual freelance grind. Has anyone else had someone talk down to them for working with smaller businesses?

Saw a client's traffic tank after a core update at a meetup in Austin

They'd been ignoring E-E-A-T completely, focusing only on keywords. Has anyone rebuilt a site's authority from scratch after something like that?

Showerthought: I just blew $500 on a 'done-for-you' backlink package that got my site flagged

The provider used spammy PBNs and now my main client's site traffic dropped 40% in two weeks, so has anyone found a legit link building service that actually works?

PSA: That $200 'done for you' backlink package is a total scam

I got suckered into buying one of those 'premium' backlink bundles from a guy on a freelancing platform last quarter. He promised 50 high authority links from real news sites, all white hat. Paid upfront, $200. What I got was a spreadsheet with 50 links, sure, but they were all from the same three garbage PBNs that looked like they were built in 2010. I checked the domains and their DA was like 15, not the 50+ he advertised. Worse, one of the sites got deindexed by Google two weeks later. I had to spend hours disavowing the whole mess. It set my client's site back at least a month. Has anyone actually found a legit and affordable backlink service, or is it all just smoke and mirrors?

Just tried a 'quick' backlink service I found online for a client's site

It was only $50, but it triggered a manual action penalty from Google within two weeks. I learned that cheap shortcuts can cost you months of recovery work. Has anyone else had to clean up a penalty from a bad link source?

PSA: I used to spend hours on keyword lists before even touching a site

Back when I started, my whole process was to build these massive spreadsheets with hundreds of keywords, trying to guess what would rank. I'd spend a full day just on that part for a single local business site. The shift for me happened maybe two years ago, after a project for a bike shop in Portland. I realized their customers were asking questions in reviews and on social media that weren't in any of my keyword tools. Now, I look at the actual search terms bringing people to the site already (via Google Search Console, you know, the free one) and what real people are saying about the business online. I build content around those phrases and questions first. It just works better. Has anyone else moved away from the old keyword-list-first approach?

Update: A client in Austin told me last week their 'SEO guy' was just posting blog comments for backlinks. Three years ago, that might have worked.

Unpopular opinion: that free SEO webinar from Austin last month was a total waste of time

I spent two hours watching this online event, hoping for some fresh link-building tactics. The host spent the first hour just talking about his own agency's growth, and the only 'tip' was to 'create great content.' I already knew that. It was so basic, I closed the tab halfway through the second speaker. Has anyone found a webinar or local meetup that actually gave you one actionable strategy you could use right away?

My old boss in Denver always said to ignore meta descriptions because 'Google rewrites them anyway', but after testing it for a month, my click-through rate dropped by 15% on pages where I left them blank.

Has anyone else actually seen a measurable difference when they write custom ones versus letting Google auto-generate?

Tried two different ways to find keywords for a local bakery client

I spent a week just using a free tool and looking at what came up, then I switched to using Ahrefs and focusing on questions people actually search for. The second way found 30 more good keywords, like 'best birthday cake delivery near me'. Has anyone else found that a better tool makes that much of a difference for local stuff?

Warning: I used to think building backlinks was more important than fixing site speed

For a project last year, I spent about $500 on guest posts for a client's site, but their traffic barely moved. Then I ran a Core Web Vitals check and saw their speed score was 32 out of 100. I spent a week just fixing images and scripts, and their organic traffic went up 40% in two months. Everyone talks about links, but a slow site just kills you. Has anyone else seen a bigger boost from speed work than from link building?

Can we talk about how many people still don't check their crawl budget?

I've been auditing sites for about a year now, and I'd say 7 out of 10 have major crawl budget waste. I saw a site last week with over 2,000 low-value pagination pages being indexed. The owner had no idea Googlebot was spending time there instead of on their new product pages. It's a huge deal because it slows down how fast your good content gets found. How do you guys usually spot and fix this kind of thing first?

I was writing 2000-word blog posts for a client for months before their analytics showed people only read the first 300 words.

A client told me my keyword reports were 'just numbers' and it hit hard

I sent my usual monthly report to a new client in Austin, full of rankings and traffic stats. She emailed back saying, 'This is just numbers. What do they mean for my sales next quarter?' That one line made me stop. I spent the next week redoing my whole report format. Now, every data point has a short note next to it explaining the business impact, like 'This keyword moving up could bring 10 more leads a month.' Has anyone else had to totally change how they show their work?