will said
“Hey if anyone want to check a number of your r&r sites for keywords… here is a handy little Google sheet for the purpose”
 
What are r&r sites??

Rank and rent

Something I would recommend is Ubot for automation (there is also zennoposter). These are not free but you can trial them, I found ubot more intuitive and very powerful. 

There is a learning curve but lots of great youtube tutorials

Yeah, this is something that need to be resolved. One of my sites just got smashed with the double agent. I don’t know if I was doing something wrong or if there’s been an update with double agent. But one of my pages that had an affiliate setup on it just got hammered, completely deindexed. It was on the position 5 before. 

IS DA no longer safe?

That’s cool Sam. I’ve had a couple more 1 or 2 cent days and another add click for $1.80. Trying to figure it all out.

Big

Stick webmaster tools on it quickly, see what messages you have from G

Nick said
I have NO idea what xamp, wamp or gizzzamps are, but my VA makes these on his old laptop.  😛

Windows,  apache,  mysql, php … or a variation

RD, thanks for getting back. Let me ask a different way.

If the mirrored site HAD been indexed or you had used your client’s site directly, do you think there would have been any damage to those? I know your SLL-type site was deindexed but curious about your thoughts on the site input into Double Agent? Do you think they are at risk?

Was there any damage to the mirrored site? If so, that would have been the “client” site for those of us who have not been doing mirrors.

Thanks Brian,

I agree that nobody would be searching for a term like that. Would love to find one like that though. Probably better to chase after something more service based than product based. The big  dogs previously mentioned don’t often show up for service based stuff.

I just want to know how Google decides if it is a local s…[Read more]

Nick, example: you have a 300,000 page national site but only a 1,500 KW ProRankTracker (or Accuranker, Serpfox, etc.) plan

I just put in the KWs+city for a representative sample of cities and figure those results will extrapolate over the entire group. Or I focus on a State or Metropolitan area I am interested in.

The only issue with this…[Read more]

Nick, good points.

RD, was it just your SLL-type site that got deindexed? Did anything happen to your client’s site? If no damage to your client, build another SLL site and try again.

BH, I just did a similar test.

Magic Tap: Top 10 results are the Big Dogs you mentioned
Magic Tap reviews: 5 Big Dogs, 2 non-big dogs (YT vids), and 3 smaller review sites
Magic Tap los angeles: 0 Big Dogs

How does Google differentiate between when I want to search local and search Global? Is it based on the term (Pizza vs World…[Read more]

RD, agree with much mentioned above. Try again, build new site with same content and KWs, overlay onto a “Test” or “Throwaway” site for safety, and see what happens. Use some of the suggestions above to try to mitigate risk. If you get deindexed again, you have confirmation. If you don’t, you have a template. Good luck!

Mario said
Great info, can this also work using Serp Shaker? 
What I am wondering for new local sites should I use fakenamegenerator.com to get info like name and phone, dont want to use zip or address since I am targeting entire county and am not sure if you use the address and zip if it will reduce the postings in the rest of the county, an…

[Read more]

Yeah all works as it should, I have modified and added some notes to the cells..

All you have to do is paste your keywords in (once you have made a copy), wait for it to check them …

Dont worry about the script part unless you really want to (its not necessary for this to work) … just use it for on the fly keyword checking. 

Paul said
How do i get this to work?
“SET TRIGGER TIME >Tools >Script Gallery (you first need to authorise the script)”
That option isn’t there anymore, i pasted my keywords but nothing happens

I will check the sheet once on my computer, all you should need to do is copy the sheet change the keywords,  local etc.

The script part is t…[Read more]

Nick, does this screenshot help?