โ How to scrape products (or anything) from any URL in G-sheets for FREE ๐ That’s right – you don’t need to know any coding ๐จโ๐ป ๐ This can be very useful in #ecommerce to scrape competitor product pages for insights, but also to gather a lot of data fast. (For example, retrieving the last 25 posts …
How to Scrape any URL from Google Sheets for Free Read More »
โ Use this method to see howย Googleย categorises your site (and your competitors). ๐ It’s really easy, but I haven’t seen many people taking advantage of it ๐ Simply type the following operator in Google’s search bar: ๐ ๐ฟ๐ฒ๐น๐ฎ๐๐ฒ๐ฑ:[๐ถ๐ป๐๐ฒ๐ฟ๐ ๐จ๐ฅ๐] I tookย Tescoย homepage as an example: apart from the usual suspects (Sainsbury’s), if you scroll down [even …
โ The quickest SEO win from a content perspective ๐ It’s not rocket science, but still very effective ๐ ๐ It’s called “content pruning”: in simple terms, it means removing “dead” or “wasteful” pages from a site (typically anything that doesn’t drive any traffic and brings no value). โ Why is this important? ๐ Because …
Content Pruning 101: How do I trim content for SEO? Read More »
Short answer: yes! Long answer: ๐ A recent quick win for one of my SEO clients (See screenshot above). โ๏ธ +100,000 impressions for images Month on Month.โ๏ธ +30% organic clicks on images during the same period. Although not strictly a top SEO priority, optimising Alt Tags still works โ๏ธ
โ๏ธ How to find your first SEO client: ๐ Open Google and type “service + city” (for example, “bakery in London”).๐ Skip results on page 1 (they are already ranking well).๐ Compile a list of sites ranking on pages 2, 3, 4 etc.๐ Select the top 20 sites you GENUINELY believe you can help.๐ Find …
How to Find your First SEO Client: A Step-by-Step Process Read More »
โ Anotherย #SEOย win for one of the sites we manage. (See screenshot at the bottom). ๐ Two backlinks from the National History Museum’s website in London. Here’s how ๐ โ๏ธ Found out about a photography competition held by the Museum last year.โ๏ธ Realised some of the competing photo subjects (that made it to the final) were …
How to get backlinks without outreach [National History Museum] Read More »
โ How many words do you need to beat your competition? Here’s the answer ๐ I recently tried answering this question for one of myย SEOย clients. I analysed SERPs & publicly available metrics for a bunch of competing sites to discover the following: โ๏ธ More words on a site are generally associated with better performance. โ๏ธ …
How many words do you need to beat your SEO competitors? Read More »
โ How to Plan & Manage deliverables for SEO clients and projects. ๐ Please feel free to steal my template ๐ Over the years I have been working with several agencies: more often than not, they rely on time consuming and complicated timesheet software. It is not fun, but most importantly it doesn’t have to …
โ The most effective ๐ฒ๐บ๐ฎ๐ถ๐น ๐๐ฒ๐บ๐ฝ๐น๐ฎ๐๐ฒ to contact potential SEO clients. ๐ It gets a lot of attention, and I want to share it for FREE! Here’s how it works ๐ โ ๏ธ Don’t worry, you don’t need to write or come up with anything, as the template is already done for you. The steps below …
โ๏ธ How to forecast SEO performance (and price your services accurately) ๐ I use this template in all my proposals and it helps winning clients โ๏ธ The concept is very simple and is based on CTR (Click Through Rate) from a study conducted by Advanced Web Ranking. It’s a very simple concept: โถ๏ธ Ranking in …
How to Forecast SEO Performance with a Simple Google Sheet [Template] Read More »