---
title: "How to use the Semrush Analytics display date setting in Supermetrics"
slug: "how-to-use-the-semrush-analytics-display-date-setting-in-supermetrics"
description: "Learn how to use Semrush Analytics in Supermetrics to fetch historical data with the Display date setting, including format and query limitations."
updated: 2026-05-06T11:47:17Z
published: 2026-05-06T13:34:26Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to use the Semrush Analytics display date setting in Supermetrics

You can use the “Display date” setting in Supermetrics Semrush Analytics queries to fetch historical data.

## Before you begin

The setting is not available for all query types. If it isn’t supported by a query type, it won’t appear as an option.

- It only works for months that are in the past, as far back as 2012 for US databases and 2013 for others.
- It can’t be used for the current month.
- It can only query data 1 month at a time. Multiple queries are needed to cover a longer time range.
- The day value must be set to the 15th — no other days are supported.
- The date format must be: YYYYMM15 (year/month/15).

Note that historical data calls for Semrush Analytics cost considerably more API units than current data requests do. Review the cost per line in Semrush’s documentation before querying historical data.

## Instructions

****Google Sheets****

1. Open the Supermetrics sidebar and select a Semrush Analytics query to modify.
2. Go to **Report configuration**.
3. Select a date in the **Display date** field .

****Data Studio****

1. Click on any report element connected to Semrush Analytics in your report to open the Supermetrics pane.
2. Click the **Edit icon** next to the Semrush Analytics query to open its configuration window.
3. Scroll down to the **Display date** field.
4. Enter the display date value with the format YYYYMM15 (year/month/15).

****Excel****

1. Open the Supermetrics sidebar and select a Semrush Analytics query to modify.
2. Go to **Report configuration**.
3. Select a date in the **Display date** field.

****Power BI****

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **Power BI** under **Analyze**.
2. Select a Semrush Analytics query to modify.
3. Go to **Report configuration**.
4. Select a date in the **Display date** field.

****The Supermetrics API****

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **API queries** under **Manage**.
2. Select a Semrush Analytics query to modify.
3. Go to **Report configuration**.
4. Select a date in the **Display date** field.

****Data warehouse****

[When setting up your data transfer](/v1/docs/how-to-create-a-transfer), navigate to **General settings** and select a display date to use.