Hanapin Marketing

The brains behind @ppchero and @heroconf have recently joined @brainlabs on a mission to build the best marketing agency in the world - follow us there!

[Hanapin Marketing @Hanapin]

Amazing news! We're delighted to announce that our team is joining forces with @brainlabs, the award-winning agency! Read more about the integration:

[Diana-Alina Aldea @DianaAlinaAldea]

#ppcchat 😂 everyone else feeling it?

[Brainlabs @Brainlabs]

Super talented brainlabber @Robinlord8 has put together a text based RegEx learning game that’s slasher themed and wicked fun! Check it out 👇👇👇 https://t.co/bzoN86CETh

[Brainlabs @Brainlabs]

In partnership with @Optmyzr, @acquisio, @taboola, and @TubeBuddy, we're tracking COVID-19's impact on the paid media industry with the Paid Media Pulse dashboard, a report which shares survey data from marketers across the globe every month. Access the dashboard now 👇#ppcchat

[Brainlabs @Brainlabs]

Day 13 of 30 #GoogleSheets for #SEO - SUBSTITUTE

Building page subtitles for loads of different products?

1. =SUBSTITUTE
2. Select the cell to be searched (A2)
3. Add the text to replace (“Jeans”)
4. Add the text to replace this with (“Shorts”)

👖🔁👗🔁🧥🔁🥼

[Hanapin Marketing @Hanapin]

Day 8 features our first nested formula!

[Brainlabs @Brainlabs]

Day 8 of 30 #GoogleSheets for #SEO - LEFT, RIGHT, MID

Our first nested formula! Extract all the character either side of a specific character.

1. =LEFT
2. Select the cell
3. Nest a FIND formula for the first empty space
4. Select the cell to look in
5. -1 to remove the space

[Hanapin Marketing @Hanapin]

anddddd Day 3 is out!

[Brainlabs @Brainlabs]

Day 3 of 30 #GoogleSheets for #SEO - UNIQUE

Need to tidy a list of repeating domains so they are all UNIQUE?

1. Type =UNIQUE
2. Select the cells you'd like to tidy (A2:A18 in the video)

Super quick and super easy.

[Brainlabs @Brainlabs]

Day 3 of 30 #GoogleSheets for #SEO - UNIQUE

Need to tidy a list of repeating domains so they are all UNIQUE?

1. Type =UNIQUE
2. Select the cells you'd like to tidy (A2:A18 in the video)

Super quick and super easy.

[Hanapin Marketing @Hanapin]

Stuck at home? Use our tutorial on how to make instagram filters to help pass the time and learn a new skill!

[Brainlabs @Brainlabs]

Eager to jump onto the Instagram augmented reality train, but not sure how to start? Here’s an easy-breezy tutorial for how to create your very own randomizer filter

https://t.co/iapMr2dgsp

[Hanapin Marketing @Hanapin]

Check out our 30 days of #googlesheets for #seo happening over on our @Brainlabs account!

[Brainlabs @Brainlabs]

Day 2 of 30 #GoogleSheets for #SEO - Text to columns

Need to split a URL into domain, subfolder and slug? This is quick and simple with just a few clicks.

1. Select all cells in column A
2. Click data > Split text to columns
3. Change separator to Custom and set as /

[Brainlabs @Brainlabs]

If you’re currently experiencing reduced website traffic due to COVID-19, now could be a good time to experiment with CRO to test friction points and improve the likelihood of conversions! https://t.co/xbegamCeVp

[Brainlabs @Brainlabs]

Tomorrow at 3 pm BST (10 am ET) we're hosting a transatlantic webinar: 🧠 Ask The Experts 🧠

You'll get to hear from Operating Partner Jeff Baum and Account Director Maris Rutkis answering all your burning questions on the current state of digital marketing!

Save your seat 👇

[Frederick Vallaeys @siliconvallaeys]

Join PPC Town Hall Wednesday. https://t.co/VbKbP7VB9q

We'll share the impact of #coronavirus on #ppc and ask everyone to share their tips.

Let's stay healthy and keep business running the best we can.

@JeffAllenUT @andrew_goodman @BenuAggarwal @Optmyzr

[PPC Hero @ppchero]

Let’s celebrate those people that have influenced our work most over the last year and continue to help guide us through these uncertain times.

Take 2 minutes to vote for them in PPC Hero’s annual Top 25 Most Influential PPC Experts survey.

https://t.co/lmkeZzVcfC

[Hanapin Marketing @Hanapin]

Our team loves Ad Gallery! It features a collection of paid media specs and examples for #digitalmarketing and #PPC heroes. https://t.co/Pov6DXzUmH

[Hanapin Marketing @Hanapin]

We're #hiring! This is your chance to join a GLOBAL #digitalmarketing agency! Passionate about all things #digital? Learn more: https://t.co/UZmLYvrxla

[Hanapin Marketing @Hanapin]

Grab our short report that covers Paid Advertising Trends for #SaaS Marketers for 2020! https://t.co/ufPcK6m1yY

[Hanapin Marketing @Hanapin]

Is #PPC a huge driver for YOUR business? If so, grab this report: https://t.co/zOjeEBG5Bf

[Hanapin Marketing @Hanapin]

The @heroconf schedule is LIVE! There is content for every level of #PPC marketer. See the sessions: #digitalmarketing #professionaldevelopment #conferences https://t.co/9Mdb9kJlWP

[Hanapin Marketing @Hanapin]

Are you a beginner at @FacebookAds ? Our updated guide will help you set up and start running effective ads in the platform. #PPC https://t.co/cSLEYp5mdC

[Hanapin Marketing @Hanapin]

Looking to make 2020 your best year yet? Consider adding a #HeroConf Workshop to up your skills in CRO, Analytics, #Excel or #PaidSocial. Learn more: https://t.co/W9MrseK8Xn