Category: seo
-
Google drops new site-reputation-abuse bomb on voucher code companies
Google has snuck in an update on 4th June to its March blog post on site reputation abuse moving from publishers having to oversee the sections to insisting they source voucher codes directly. Under the heading “My site has a coupon area that we produce in part by working with a third party. Is this…
-
Bill Gates, Man United and 20 other sites that ban linking to them
10+ years ago I created an annual list of websites that FORBADE you from linking to them, DEMANDED you write to ask for permission or LIMITED links to only their home page. Royal Mail even promised to post me a paper licence. Now a decade has passed, let’s see who’s still doing it … And…
-
Create your own rank tracker – Brighton SEO formulae
The formulae from my talk on creating your own rank tracker using Google Search Console, Looker Studio and Google Sheets. Get the data from GSC, into looker studio and then export to sheets. Sort out the date =arrayformula(month(B2:B)) =arrayformula(DAY(B2:B)) Then combine month and date with EG =date(2023,D2,E2) (this is all to cope with September coming…
-
Keyword clustering using google sheets: Brighton SEO formulae
To combine similar columns multiple tabs into one sheet, there are many ways to do this in google sheets. But here’s the one I used to combine electric scooters, escooters and e-scooters: =sort(QUERY({‘Electric scooter’!A2:B;Escooter!A2:B;’E scooter’!A2:B},”select * where Col2 >40″),2,false) To categorise your search terms, where they are listed in column A, your category names are…
Malcolm Coles 