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.
Aleyda Solis
How to develop actionable and impactful SEO audits
Our sponsors
365d
24h
60m
60s
Newsletter signup
Please do! Sometimes it can be intimidating to go to a room with a bunch of strangers.
All you'll need to do is to share the event link with friends and colleagues, so they can sign up for the event.
We will always provide vegan and vegetarian and gluten-free options for food and drink where possible. In the case of specifically ordered food, we’ll put a label nearby so you know what is suitable for you. If you have any other dietary requirements please let us know.
Apart from meeting lovely people like yourself, you'll experience some of the most technical conversations going – “Why did Google say they weren’t parsing second-wave javascript inserted canonical tags when it’s proven they do?" – you know, the usual conversation starters!
You’ll also meet people not like you, which is probably more important. Chat with in-house digital marketers or freelancers to hear what they’re saying about working with agencies and what they really need help with.
There’s so much marketing talent in Norwich, including agencies working with huge global brands. Let’s learn together and help each other so we can all get better at our jobs and keep Norwich on the map!
Working in-house gives you the chance to get closer to the brand than anyone, but it’s a double-edged sword. It can be refreshing to meet agency people who work over a varied cross-section of verticals and have had the luxury of trying (and failing) with a wide range of strategies.
Getting to know other digital marketers can lead to great conversations about how to handle the specific challenges of working in-house and how to get the best from agencies.
It's all about collaboration and cooperation, when we learn together, it benefits everyone.
Great digital talent is hard to find and even harder to attract and you’re going to be in a room full of people who are involved in it – we’ve partnered with the University of East Anglia and Norwich City College, so you’ll be able to meet the next rising star in the digital marketing world.
The talks will give you a strategic insight into what to consider for your business. You’ll also be in a room full of people that will want to talk to you about it. They’ll also be great networking opportunities with other local businesses.
In a nutshell, you may find your next employer or apprenticeship in search marketing at SearchNorwich.
You’ll also get invaluable insight into the day-to-day of companies who do search marketing and learn how agencies plan or execute campaigns.
There’s also free food and drink if that student loan is looking tight.