The SEO, SEM, PPC and Content Marketing Blog - Semrush

10 Don'ts for Google AdWords
5 Advantages to Yandex over Google in Russia
Use Excel To Create a Keyword Strategy

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.
Sergio AicardiJun 19, 2014
Strategic SEO Tips

Ecommerce

8 min read

20 Strategic SEO Tips To Increase Ecommerce Sales

Inadequate customer traffic and lack of sales conversions are the key issues that trouble most ecommerce websites. In spite of increasing global competition, it is very much possible for ecommerce websites to overcome these issues. All you have to do is formulate and deploy the right marketing strategy.
Kinjal AdesharaApr 18, 2014
Lightning Talk

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.
Kathleen GarvinApr 15, 2014
Excel for Data Collection on Ecommerce URLs

General SEO

4 min read

How To Use Excel for Data Collection on Ecommerce URLs

The following Excel trick is best used when you have data located inside of your URLs. This happens a lot when you have an ecommerce website that generates dynamic confirmation URLs after a purchase is made.In one particular case, one of our clients reached out to us hoping to find a PPC management company.
Sergio AicardiApr 10, 2014