Search Console Country & Continent reporting
How to group Countries in Search Console into Continents or other custom country groups? Use Calculated Field & Regex in Data Studio, or use a lookup table.
Customer Latency - What it is and how to use it to avoid Customer Churn
What is Latency, and how it can help you to avoid Customer churn.
“Inferred CTR” method for reducing cannibalisation of SEO
Find out about 3 simple principles you should apply to your PPC campaigns in order to understand and minimise cannibalisation of your SEO traffic. “Inferred CTR method” explained.
Google Trends reports and automation
Learn about the different ways extracting Google Trends data and building automated reports.
YouTube Competitor tracker in Google Sheets
Use Google Sheets to track and monitor changes in the number of Subscribers and Views of your YouTube competitors
Monitor PPC competitors using Google Sheets tracker
Use Google Sheets template to track your Paid Search competition. Easily setup keyword list and automatically collect the data.
SEO Brand - what it is and how to measure it
Measure and monitor your SEO Brand traffic using these simple steps. See how to calculate the split between brand and non-brand SEO traffic, using both Google Search Console and Google Analytics data. M easure Sales of your SEO Brand traffic using a simple Landing Pages method.
Introduction to using Google Trends for Marketing
Google Trends is a must in a toolkit of every Marketer, whether Digital or traditional. Understand the main advantages of using this free tool to understand changes in the search demand, measure brand awareness or spot new business opportunities.
3 simple ways to increase Incrementality of PPC campaigns
If your SEO rankings are strong (ie you are often ranking on page one of Google), it is highly likely that some of your Google Ads are cannibalising your SEO traffic. Follow these three simple principles to avoid cannibalisation of SEO, hence increasing incrementality of your PPC campaigns.
Ultimate Google Search Console report in Google Sheets
Build an ultimate SEO report using just Google Sheets. Automatically extract the data from Google Search Console, backup and transform the data into very powerful SEO report. Categorise your Pages and Keywords into meaningful Categories.
Ultimate Google Search Console report in Google Data Studio
Build an ultimate SEO report using just Google Data Studio. Automatically extract the data from Google Search Console (no coding required). See how you can “on the fly” group your Pages and Keywords into meaningful Categories and build powerful and beautiful reports.
Ultimate Google Search Console report in Excel
Minimize your tax bill with some smart planning that will leave more money in your pocket come April 15.