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

How To Use the Semrush API in Google Sheets

General SEO

4 min read

How To Use the Semrush API in Google Sheets

Semrush is my favorite competitive research tool that I use for everything from organic and paid keyword research to understanding market share in a specific region. A few months ago, I was working on a large project where it made sense to look beyond the Semrush interface and pull data directly from their servers via the Semrush API.
Brian JensenMar 12, 2015
Keyword Opportunities

Keyword Opportunities: 4 Tools That Will Open Your Eyes

Finding keyword opportunities is becoming more and more difficult, with the markets we work in becoming even more competitive. I recently wrote a post that went through my five steps to spotting keyword opportunities using a piece of campaign management software, but there are lots of tools that can help you to spot keyword opportunities.
Daniel BianchiniMar 10, 2015
7 Easy Steps To Create a Web Analytics Framework

7 Easy Steps To Create a Web Analytics Framework and Improve Your Marketing

Amel will join Semrush on March 4 for a free webinar, “How to Increase Your Website Revenue Using a Data-Driven SEO Campaign.“ Learn more about the webinar after the jump! “Measurement is the first step that leads to control and eventually to improvement. If you can’t measure something, you can’t understand it. If you can’t understand it, you can’t control it. If you can’t control it, you can’t improve it.” — H.
Amel MehenaouiFeb 26, 2015
The FCB Grid

The FCB Grid: What It Is and How It Works

If you’ve only used keywords to understand how to market your product, you’re not tapping its potential. Lists of keywords tell us what people want. They don’t tell us why. Boredom, fatigue, illness and hunger ... people buy for a reason. Maybe you think of these ideas willy nilly as you type, but how can you engineer them without fail? With the FCB Grid.
Joshua BainsFeb 26, 2015
The 5-Step Competitor Analysis Strategy That Never Fails
Uber Case Study