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!
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
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
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”)
👖🔁👗🔁🧥🔁🥼
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
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.
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.
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
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 /
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
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 👇
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
We're #hiring! This is your chance to join a GLOBAL #digitalmarketing agency! Passionate about all things #digital? Learn more: https://t.co/UZmLYvrxla
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
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