BrightonSEO

Malcolm will explain how to combine google sheets functions to make your life much easier - such as categorising keywords in under 5 minutes.

Find out how to use arrayformula(), how to order keywords in a cell in alphabetical order to eliminate duplicates, and how to convert tabular data into column data so you can make pivot tables.

This talk will deep dive into the untapped power of keyword research. A lot of keyword research is done ‘for the sake of it’ and it’s shared with clients at the start of campaigns by the SEO team and never looked at again, or even shared with other channels.

This talk will explore how keyword research should be a starting point for any campaign and should sit within the strategy team, then feed into SEO, PR, Social etc. And how it should be referred to and updated throughout a campaign. Keyword research is a secret weapon for crafting a killer organic marketing strategy.