Add3 – Digital Marketing Agency with offices in Seattle & Portland

Welcome to the latest Amplify Interactive Hot 11! Thanks for dropping by. We’ve got some great articles rounded up for you from the world of SEO, SEM, PPC, SMM, and possibly other abbreviations! Feel free to read it if you want to, no pressure.Amplify Interactive's Hot 11

1) Search Marketing Agency Seeks SEM Account Coordinator

from Amplify Interactive

We (Amplify Interactive) are hiring an account coordinator! If you or anyone you know is looking for a great entry-level position at a growing agency, click this link!

2) AdWords Quality Score: Hype, Changes, and Tracking Tools

by Michelle Morehouse at Clix

There’s been a good number of opinion pieces on QS as well as an update in Google’s reporting. QS has been around for a while, so what’s all the hoopla about?

3) When It Comes To Google, Microsoft’s Ballmer Is Still Fighting Old Battles With Old Tactics

by Danny Sullivan at Search Engine Land

How is Microsoft going to beat Google? Comments from departing CEO Steve Ballmer suggest there are no new tactics in the playbook.

4) 3 Methods Fueled by Data and Tools to Earn More (and Better) Links – Whiteboard Friday

by Rand Fishkin at Moz

In the latest Whiteboard Friday, Rand Fishkin clears up the confusion and offers a few clear attributes of better links, walking us through three great ways to find them. By the way, if you’re in Portland make sure to catch Rand speaking live this Tuesday for semPDX! All proceeds go to the Cottam library fund, a very worthwhile cause.

5) “The Mighty Nudge – the Future of Digital Marketing” (Rand Fishkin Live Event in Portland)

As I was writing that blurb for #4 I thought to myself “you know what self? That event needs its own spot on this list! If you’re in Portland you should definitely check out this event! All proceeds go to a very worthy cause.

6) IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,” “,””))+1)

Whoah, the Hot 11 is getting all out of the normal format! This is not an article, it’s just an Excel formula that my co-worker Ashley shared. Oh well, #YOLO! This is a useful Excel formula that Ashley sent out this past week. According to her “This is a pretty sweet formula! It counts the number of words in a cell – which can come in handy when you are trying to identify longer tailed keywords in search query reports.” There you go, file that one away in the ole noggin somewhere. Again, that’s IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,” “,””))+1)

7) Quickly Remove the Space From the End of Keywords from Ubersuggest

Let’s keep this off format stuff going! This is not an article, it’s a simple tool that saved me some frickin time this past week. If you use Ubersuggest, you may have noticed that it annoyingly adds a space to the end of terms when you export. I used to use a bothersome function in Excel (TRIM, I think?). Anyways, I found this site that makes this way easier.

8) Pinterest Experiments with Promoted Pins

by Jessica Lee at Search Engine Watch

Advertising is on the way to Pinterest, in the form of promoted pins in its search results. While Pinterest said it’s just a test for now, it assured users that the promoted pins will be tasteful, transparent, and offer a good user experience.

9) 5 Simple PowerPoint Tricks You Should Have Up Your Sleeve

by Ginny Soskey

Powerpoints don’t bore people, people bore people. Here are some Powerpoint tricks to put up your sleeve to help captivate your audience.

10) Google Analytics Visitor Segmentation: Users, Sequences, Cohorts!

by Avinash Kaushik at Occam’s Razor

As user behavior becomes increasingly complex, it is mandatory that your data analysis include the ability to do visitor segmentation. Learn how to with Avinash.

11) Peregrine Falcon Killing a Duck in Mid-Air


Oh my gosh, this is pretty awesome. Did you know a Peregrine Falcon can reach speeds of up to 250 miles per hour? WHAT? That’s just crazy talk. Go to about 2:45 to skip to the exciting part.

Amplify Interactive is a Search Engine Marketing agency that provides search engine & social media marketing services for B2B clients. Check out our Search Marketing and Social Media Marketing services and our Clients or download one of our SEM Whitepapers. Go ahead and follow Amplify Interactive on LinkedIn or follow us on Slideshare or both!


About Add3 Team

Comments & Replies