Guide: Using Semrush with Databox

HOW TO

How to connect Semrush to Databox

IN THIS SECTION

How to connect Semrush to Databox

To connect a Semrush Account in Databox, go to  Data Manager > + New Data Source. Type Semrush in the search bar and click on the green Connect button. 

This will open the   Authorization window, which is where you will be prompted to enter your Semrush login credentials, authorize the Databox app, and up to 5 Competitors URLs (optional).

Pro Tip: In order to report on competitors data in Databox, you must manually enter Competitors URLs (without 'http://").
If you choose not to enter any Competitor URLs, Position Tracking metrics will only return data for your URL domain.

There are a few additional prompts that you must fill out when connecting your data source. These are required so we can get all the important information for your setup.

  • You will be asked to select a project. After you have selected a Project, you will be be asked to select a Campaign. If you have no Campaigns associated with the Project, you will still be able to connect, but some metrics that are specific to Campaigns will not work. When such a metric is placed on a Databoard, you will receive an error message stating that the connected campaign does not exist.
  • The prompts after will be for the tracking / targeting setup. You will be offered 4 options:

Screenshot 2024-04-23 at 7.40.31 PM

  • These 4 options correspond to the following options on SEMrush’s UI:

Screenshot 2024-04-23 at 7.42.53 PM

  • The next prompt will then be about the your database setup:

c5620f06-92a3-44e8-93e8-22a08f28f548

  • This can be accessed on the same location as the information about the tracking setup:

Screenshot 2024-04-23 at 7.47.06 PM

Most of the Competitive Research and Keyword Research reports/metrics fall under this category. If these are not properly set, then discrepancies are likely to occur.

Which Semrush plans can be connected with Databox? 

Due to our partnership with Semrush and the way they've made data available to us, all Semrush accounts and plans can be connected with Databox. 

You do not have to purchase API units to sync your data with Databox. We will use your Semrush login credentials to pull Semrush data to Databox.

How to report on Project data

Pro Tip: Position Tracking must be configured so you can report on project data for the Semrush integration. Without this, the connection can fail once a metric is added on a Databoard. Follow the steps below to set this up:

In Your Semrush Account, navigate to My Projects > Position Tracking column > Set up.

Learn more about Configuring Position Tracking here

When you set up a Project in Semrush, make sure that you enter your Domain without www. The Domain should be entered in the form "urlname.com" and not as "www.urlname.com".

Note that the Project Domain cannot be changed for existing projects. Instead, a new Project with the Project Domain in the correct form has to be created. Historical data can be pulled into the new Project.

If the Project Domain is not set correctly, this can cause missing keywords for the "Top Keywords by Position" Metric. 

How to report on multiple Position Tracking Campaigns within 1 project

Pro Tip: In order to support multiple Position Tracking Campaigns within one project, each Campaign must be added as a separate Data Source in Databox.

If you are using multiple Position Tracking Campaigns, you will need to copy the exact Business Name from your Semrush Account and link it with your Semrush Data Source in Databox. In order to display the correct data in Databox, the Business Name must be identical to what is shown in your Semrush Account. 
To find your  Business Name in Semrush, follow the steps below:
  1. Navigate to Management > Projects 
     
  2. Select the project whose Business Name you would like to access

     

  3. Select  Positioning Tracking
     
  4. In the upper righthand corner, click the Settings icon and select Tracking + Project Name
     
  5. Copy the Business Name from the Business Name for Local Map Pack textbox
    If you are adding a new Semrush Data Source in Databox, paste the Business Name in the Business Name field in the Activate Semrush window during the connection process. 

  If you have already connected the Semrush account in Databox, you will need to edit the Data Source and enter the Business Name to retrieve the relevant data. 

Pro Tip: To add or edit Business Name for an existing Data Source, please contact help@databox.com.
In your email, specify Databox Account(s) and Semrush Data Source(s) that you'd like to edit.

How to report on Competitors data from Semrush   

When you connect your Semrush Data Source to Databox, you can specify the competitors you want to monitor and compare your data against. This can be done during the initial connection process or by editing the Data Source. 

Pro Tip: To add or edit Competitors for an existing Data Source, please contact help@databox.com.
In your email, specify which Databox Account(s) and Semrush Data Source(s) you'd like to edit.

The given Metrics will display data only for the given competitors. These metrics are:

  • Visibility trend by Competitor
  • Estimated traffic by Competitor
  • Average position by Competitor

What's the maximum amount of historical data initially available when you use a new Semrush Metric in Databox?

Data is synced for the Metrics that are being used in your Account, so when you first use a new Semrush Metric, the maximum amount of historical data available is 36 months. Historical data is available for the following metrics:

  • Relative Visibility
  • Absolute Visibility
  • Estimated Traffic
  • Average Position
  • Average Position by Competitor
  • Keywords Tracked
  • Top Keywords by Position
  • Top Keywords by CPC
  • Top Keywords by Volume
  • Keywords in TOP 3
  • Keywords in TOP 10
  • Keywords in TOP 20
  • Keywords in TOP 100

Other Metrics don't have any historical data available. Data will start to sync once you first use a new Semrush Metric in your Account.

Pro Tip:  In order to start syncing data for a Metric, you can add it to your Metrics screen, use it in a Scorecard, set a Goal around it, create an Alert for it, or add it to a Databoard. Learn more  here

The amount of historical data you're able to access in Databox is dependent on your Databox plan. Learn more here.

What time zone does Semrush data sync in? 

Semrush data is synced in UTC.

How often does Semrush data sync?

All Semrush Data Sources will sync once a day with Databox. Learn more here.

How to access pre-built Semrush Templates

 
  1. Navigate to Databoards > Public Templates
  2. In the Data Source drop-down list, select Semrush
  3. To view a preview of the Template populated with dummy data, click Preview
  4. To pull the Template into your Account and re-populate it with your own Semrush data, click Use Template
  5. Select the appropriate Semrush Data Source from the drop-down list to complete the process. The Databoard will be re-populated with data from the selected Semrush Account and can be found on the  Databoards page

Pro Tip: Once the Databoard is available on the Databoards page, it is completely disconnected from the public Template. Therefore, you can further customize this Databoard to meet your specific needs using the Designer.

Popular Semrush Templates

Semrush: Position Tracking Semrush (Keywords & Audits)
This dashboard displays the change in your online presence based on your keyword rankings over time.
Semrush (Keywords and Audits) dashboard gives you a full view of your SEO visibility as well as any errors that occurred.

How to build a Databoard using Semrush data

 
  1. Navigate to Databoards > + New Databoard > Start Blank
  2. Click on the  Metric Library icon on the lefthand side of the Designer
  3. Select the appropriate Semrush Account from the Data Source drop-down list in the Metric Library
  4. View the list of pre-built Semrush Datablocks in the Metric Library. Drag and drop your selected Datablock onto your Databoard.
  5. If a pre-built Datablock isn't available for your use case, click on the  Visualization Types icon under the Metric Library icon.
  6. View the list of Visualizations available in Databox. Drag and drop your selected Visualization onto your Databoard.
  7. Click on the Datablock on the Databoard to open the corresponding Datablock Settings on the righthand side of the Designer.
  8. Select the appropriate Semrush Data Source and Metric in the righthand Datablock Settings. This will update the Datablock and it will populate the Datablock with the corresponding data.
  9. Complete steps 4-8 until your Databoard is complete.

Popular Semrush Metrics

Visibility Trend Keywords in Top 3 Top Keywords by Position

     

View a full list of Semrush Metrics available in Databox here.

Additional Information

IN THIS SECTION

Metric Considerations

  • Due to technical limitations, the Date Range ''All Time'' will return a maximum 36 months of historical data.

Granularity Restrictions

  • Due to API limitations, hourly granularity is not supported. This may affect visualization options for Charts in Databox.

    For example, if a Semrush Metric is used on a Line or Bar Chart with ''Yesterday'' Date Range selected, hourly data won't be displayed on the Chart.
    However, the big number above the Chart will accurately reflect the Metric value for the selected Date Range.

    Learn more about Granularity here