SearchNorwich 10
St Georges Works, 51 Colegate, Norwich NR3 1DD
3 January 2020 at 18:00:00
Event summary
.jpg)
For SearchNorwich 10 we’ve got award winner Hannah Rampton with us to talk about getting started with Query in Google Sheets. Hannah has over a decade of experience and has worked for respected agencies such as StrategiQ and SEOgadget (now Builtvisible).
We also have international SEO consultant Aleyda Solis coming along to talk to you about Marketplace SEO. Aleyda has spoken at over 100 conferences in 20 different countries to offer actionable SEO tips.
The schedule
The venue
The speakers
Key takeaways
Video
Slides
The Query function in Google Sheets is a powerhouse!
Query combines filtering with arithmetic functions and aggregation such as AVG. SUM, MAX, COUNT, allowing you to both cleanse and calculate in a single query.
You are able to use dynamic settings using nested vlookups.
Hannah Rampton
Getting started with Query in Google Sheets
Key takeaways
Video
Slides
The goal of an SEO audit is to be source and driver of the process.
SEO audits are challenging, Aleyda uses a set of principles she calls SP2: Strategic, prioritised, solution-focused, proactive/preventative.
No SEO audit can be standardised - it will change based on goals, website size, the type of business and SEO majority.