General Marketing

Whether you‘re new to marketing or a seasoned pro, our General Marketing category offers tips, tools, and expert advice to boost your marketing efforts. Learn from top experts and enhance your marketing skills.

article illustration

How To Use Excel To Create a Keyword Strategy

Everyone knows keywords are a big part of SEO, but I feel most people don’t really appreciate the work that goes behind setting up a strategy that is based on keyword performance. Maybe it’s because most people don’t understand what measures are taken to create large SEM campaigns with thousands of keywords that need to be strategically selected. When dealing with large pay per click campaigns in AdWords, using the right keywords means everything. Since there are great tools out there like Semrush and Google Analytics, we can get great keyword data from our competitors or our websites that we manage easily. But managing that data can be tricky at times (especially with ecommerce data). As a member of a PPC management company, it’s important that I am efficient and strategic when selecting keywords for our clients. I wanted to share some of the ways I use Excel to create a keyword strategy very quickly using simple concatenation in a not-so-simple way.

article illustration

16 Ways To Prepare for a Lightning Talk

Last week I delivered a speech at a large, local technology event. I was one of five speakers to address the crowd during the lightning talk session. What is a lightning talk? Generally speaking, it‘s a micro presentation or pitch of some sort to your audience. Organizers can choose different metrics, from time length to topic. The event I participated in was part of a week-long gathering for those in the tech and new media community. On Tuesday, I spoke under the umbrella topic, “The Future of Digital Marketing.” Speakers could use visual aids, demonstrate a case study or pitch their company. Oh, and we only had three minutes to present.