Malcolm Coles

I’m an SEO and content strategy consultant – a data-led digital publishing expert with experience leading global editorial, SEO, social and product teams. I’ve scaled audience and revenue at major news companies, affiliate sites and ecommerce startups.

I can help you

1.

Data

Find insights to drive growth in your analytics and search data.

2.

Strategy

What do your goals mean you can do – and what should you do?

3.

Technical

Tell the tech team your requirements in a way they understand.

4.

Implement

Manage SEO change, content delivery and reporting

Clients

Group SJR

Agency

Electroheads

Ecommerce

News UK

Publisher

City AM

Publisher

With Malcolm’s help we attracted 50k users to our brand new ecommerce site in just 4 months, and rank 1st on Google for some of the most competitive search terms in our industry. We now have a blueprint for ongoing success, and the peace of mind of working with somebody who knows how to turn the latest SEO knowledge into success.

— Richard Beech, co-founder, electroheads.com

  • 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…

    Malcolm Coles

  • 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…

    Malcolm Coles

  • 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