SEMrush
Dashboard and Reporting Software

Due to an API limitation, Databox can pull only daily data for the Semrush ‘Competitors’ metrics.
It is recommended to use these metrics on a Line / Bar Chart to visualize trends. For the Big number (the total value displayed above a chart) or if Competitor metrics are used in a Table, only values for the last day of the selected Date Range will be shown in Databox.

Competitor metrics are:

• Average Position by Competitor
• Authority Score by Competitor
• Backlinks by Competitor
• Common Referring Domains by Competitor
• Total Referring Domains by Competitor
• Competition Level by Competitor
• Estimated Traffic by Competitor
• Absolute Visibility by Competitor
• Relative Visibility by Competitor
• Warnings
• Absolute visibility trend by Competitor %
• Average by position by Competitor %Broken/Healthy Page Rate
• Estimated traffic by Competitor %
• Relative visibility trend by Competitor %

Currently, up to 5 competitors can be referenced for one SemRush Data Source in Databox. The Competitors can be edited at any time without the need to reconnect the SemRush Data Source by navigating to the ‘Details’ link for the given SemRush connection on the Data Manager page and selecting ‘Edit Connection’ from the drop-down menu. This will open a window, where the 5 competitors can be edited.

If tracking is required for more than five competitors, the workaround is to connect the same SemRush account multiple times in Databox, assigning five unique competitors for each connection.

Data for Site Audit metrics will only be available in Databox if the Site Audit tool is enabled in the Semrush account. Once the individual audits are completed, Databox will pull the data from the reports generated. An audit can be scheduled to run periodically (for example every Monday) or can be run manually. You can read more about Site Audit here.

Site Audit metrics available in Databox are:

• Blocked Pages
• Broken Pages
• Pages Crawl Depth
• Pages by Crawl Depth
• Errors
• Errors by Category
• Pages with Issues
• Healthy Pages
• Incoming Internal Links
• Pages by Incoming Internal Links
• Pages Markup
• Pages Markup by Category
• Notices
• Pages Crawled
• Redirects
• Pages in Sitemap
• Site Audit Score
• Warnings

In terms of available historical data, SemRush has two types of metrics.
Some of the SemRush metrics are Current metrics, which means they have no historical data available for dates prior to when they are first used in Databox.
Databox starts syncing the data for Current metrics once they are first used on either your Metrics screen, a Databoard, a Scorecard, a Goal, or an Alert. Once SemRush is connected to Databox and actively syncing data, Databox stores the data that is collected in Databox’s database. This allows to accumulate more data over time as more data syncs are made so that users can report on more historical data in the Databox reports.

The other group of SemRush metrics are General metrics. Due to technical limitations, the Date Range ‘All Time’ will return a maximum of 36 months of historical data for these metrics. The following SemRush metrics will have 36 months of historical data available in Databox:

• Relative Visibility
• Absolute Visibility
• Estimated Traffic
• Average Position
• Average Position by Competitor
• Keywords Tracked
• Top Keywords by Position (incl. Local, Hotel, excl. Business Name)
• Top Keywords by Position (incl. Local, Hotel, Business Name)
• Top Keywords by Position (incl. Local, Hotel, excl. Organic)
• Top Keywords by Position (excl. Local)
• Top Keywords by Position (excl. Hotel)
• Top Keywords by Position (excl. Local, Hotel)
• Top Keywords by CPC
• Top Keywords by Volume
• Keywords in TOP 3
• Keywords in TOP 10
• Keywords in TOP 20
• Keywords in TOP 100

In order to track data for SemRush Competitors metrics in Databox the competitors should be specified. When connecting the SemRush Data Source to Databox, you need to specify the competitors that you want to monitor and compare data against. This can be done during the initial connection process or by editing the existing Data Source connection. If competitors are not specified, there will be no data visible in Databox for Competitors metrics. Competitors metrics will display data only for the specified competitors.
More information on connecting SemRush in Databox is available in Connect Semrush to Databox.

Competitors metrics are:

• Average Position by Competitor
• Estimated Traffic by Competitor
• Absolute Visibility by Competitor
• Relative Visibility by CompetitorAbsolute visibility trend by Competitor %
• Average by position by Competitor %Broken/Healthy Page Rate
• Estimated traffic by Competitor %
• Relative visibility trend by Competitor %
• Authority Score by Competitor
• Backlinks by Competitor
• Common Referring Domains by Competitor
• Total Referring Domains by Competitor
• Competition Level by Competitor

In order to report on multiple Position Tracking Campaigns within one project in Databox, each Campaign must be added as a separate Data Source connection in Databox.

After completing the Authorization (entering SemRush login credentials, authorizing the Databox app, and add up to 5 Competitors URLs (optional)), there are a few additional steps to complete when connecting SemRush to Databox. This additional information is required so Databox can get all the important information for the SemRush connection setup.

Users will be asked for the following information:

• Select a Project and Campaign. If there are no Campaigns associated with the Project, users 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, users will receive an error message stating that the connected campaign does not exist.
• Select tracking / targeting setup.
• Select a database region.

More information about the connection process is available in the designated Help Article: How to connect Semrush to Databox

Due to API limitations, hourly granularity (showing data by hours) is not supported for SemRush metrics. 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 will not 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.

In order to see the correct data for SemRush Competitive Research and Keyword Research metrics in Databox, the right SemRush database region, from which data is to be pulled, needs to be selected. If the selected database region is not the same as in the SemRush account, data discrepancies between Competitive Research and Keyword Research metrics will appear in Databox.

The correct database region should be selected during the connection process of SemRush to Databox. In SemRush the location of the database can be found in the settings on the Position Tracking page under Targeting.
The complete connection process for the SemRush integration is described in the Help Article: How to connect Semrush to Databox

If the SemRush account is already connected to Databox and the location selected is not the same as in SemRush account, the given SEMrush account will need to be reconnected in Data Manager via the Reauthorize option. In case any data discrepancies across SEMrush metrics are still present after the reconnection, the historical data for the whole SemRush connection will need to be purged. WARNING: If historical data for a Data Source is purged, all historical data for this Data Source that has been previously synced with Databox will be lost. Note that for some SemRush metrics this can mean that all data accumulated in Databox will be lost.

Additionally, one SemRush connection should be used to sync data from only one regional database at a time. It is not recommended to reconnect the same connection multiple times in order to ‘switch’ between different regional database reports, as this will lead to data discrepancies across several SemRush metrics in Databox.

The SemRush Domain Metrics available in Databox are: Domain Rank, Domain Organic Keywords, Domain Organic Traffic, Domain Organic Cost, Domain Adwords Keywords, Domain Adwords Traffic and Domain Adwords Cost.

The following API limitations affect all SemRush Domain Metrics:

1. Due to an API limitation, Databox can only get daily and monthly values from the API for Domain Metrics, meaning only daily and monthly granularities are available. The API returns daily data only for the last 30 days and monthly data for the last 12 months.
2. Daily data for Domain Metrics can be obtained up to yesterday since SemRush API has a 2-day delay, meaning it does not return values for the current day and the day before.
3. Monthly data for Domain Metrics can be obtained up to the current moment (i.e. current month).
4. When Domain Metrics are displayed on the Line/Bar Chart, the value of the last day in the selected Date Range will be displayed as the Big Number (the value above the chart) in case there is no value for the whole Date Range (meaning if the month is not finished yet). In case the last day’s value is missing for any reason, the Big Number will not be displayed, and the users will see ”-” instead of the value.

All SemRush metrics available in Databox are non-aggregatable Metrics. This means that due to the nature of these metrics, summing daily/weekly/monthly values will not give correct results for longer time periods.
Additionally, all SemRush metrics available in Databox are no-reset metrics. No-reset metrics are not reset to value 0 with every new day.