Use SEMrush as a data source

Resources

Data Source Type: Guide to REST/URL data sources
Authentication: Basic HTTP Authentication
API Documentation: SEMrush API documentation
Important! You will be charged SEMrush API units each time you create a new SEMrush data source in Klipfolio or refresh your SEMrush data. As a result, we recommend that when you create a SEMrush data source, to set the refresh rate to once a day. If you ever exceed your SEMrush subscription’s API limit, you can buy an additional API package from SEMrush.

Step-by-Step

To create a data source using SEMrush, you need to accomplish three tasks:

  • Find your SEMrush API Key
  • Start the data source creation process in Klipfolio.
  • Craft a query and save your data.

Prerequisite: Find your SEMRush API Key

To get data from SEMrush, you need an API Key from SEMrush.

To find your API Key,

  1. Open a new tab and login to your SEMrush account.
  2. Click on your Profile, and select API from the drop-down menu.
  1. Select Account.
  1. Keep your API Key handy - you'll need it for your query in Klipfolio.

Start the data source creation process in Klipfolio

To create a data source using SEMrush, go to the New Data Source page in Klipfolio and select SEMrush.

Craft the query and enter it in Klipfolio

To get started crafting a query, refer to the to the SEMrush API documentation. And remember! You will be charged SEMrush API units each time you create a new SEMrush data source in Klipfolio.

Here is a sample query to get you started:

Top 5 Keywords

http://api.semrush.com/?type=domain_organic&key=Your-API-Key&export_columns=Ph,Po,Pp,Pd,Nq,Cp,Ur,Tr,Tc,Co,Nr,Td&domain=yourdomain.com&display_sort=tr_desc&database=yourRegionalDatabase&display_limit=5

Learn more about SEMrush Analytics API columns (for example, Ph,Po,Pp,Pd,Nq, etc.)

Authenticate and complete the data source creation process

After creating your SEMrush query,

  1. In the Authentication (OAuth, 2-Step, X-WSSE, or Basic) menu, under Type, select Basic HTTP Authentication.
  2. At Username, enter your API Key
  3. At Password, leave the password blank.
  4. Select Get Resource.
  5. If you are satisfied with the data returned, click Continue.

Learn more