Open navigation

Supermetrics data source historical range limits, known API delays, and refresh window recommendations

We've listed below the different limits for historical ranges, API delays, and recommended refresh windows of data available from different data sources.


A standard Supermetrics license supports as much history as each data source allows (data warehouse, cloud storage, and data lake licenses are an exception with an upgradable limit of 2 years).


The refresh window determines how many days of data will be updated every time the data is refreshed. Learn more about refresh windows.


Please note that this list isn't exhaustive. If a data source doesn't have a recommended refresh window, 3 days is a good starting point. 

Date range in data blends

If you're using data blending to pull data from multiple data sources, update the query date range to fit the most restrictive date range. You can also use the Return partial data for different maximum historical date ranges setting to fetch partial data for different maximum historical date ranges. You can find this setting in the query options.


Data sourceHistorical range (HR), API delay, and recommended refresh window where available
ActiveCampaignHR: No known limitations

Refresh window: 2-3 days
Ad + Google Analytics Data
HR: Depends on the selected data sources — please see data source-specific historical ranges.
AdformHR: Last 397 days of data
AdjustHR: No known limitations

Refresh window: 2-3 days
Adobe AnalyticsHR: Lifetime, but Adobe best practice is to pull historical data by incrementing it regularly instead of requesting the entire data set at once.
Adobe Analytics 2.0HR: Lifetime, but Adobe best practice is to pull historical data by incrementing it regularly instead of requesting the entire data set at once.
AdRollHR: The AdRoll API doesn't provide data older than 2012-01-01.
AdtractionHR: No known limitations

Refresh window: 3 days
AffluentHR: Account lifetime

Refresh window: 2-3 days
AhrefsHR: Up to last 5 years
Amazon AdsHR: Last 60 days of data

Refresh window: 3 days, as click verification may take that long.

API delay: 12 hours for most metrics, up to 48 hours for sales-related conversions and derived metrics (ACOS, ROAS)
Amazon Ad Server (Sizmek)HR: No known limits
Amazon DSPHR: 90 days

Refresh window: 2-3 days
Amazon Seller CentralHR: 2 years

Refresh window: 2 days
Apple Search Ads

HR:

  • Up to 24 months on a monthly level and overall
  • Up to 365 days on a weekly level
  • Up to 90 days on a daily level
AppsflyerHR: 90 days for Event export data

Refresh window: 2 days
AwinHR: No known limits

Refresh window: 2 days
BambuserHR: No known limits

Refresh window: 2-3 days
BasisHR: No known limits

Refresh window: 2-3 days
BigQueryHR: Depends on data in the data warehouse.
Bing Webmaster ToolsHR: The longest available dataset period is 6 months.
BranchHR: Data available since 2017-10-14.
BrevoHR: No known limitations

Refresh window: 2-3 days
CallRailHR: Account lifetime
Campaign MonitorHR: No known limitations

Refresh window: 2-3 days
Capterra PPCHR: No known limitations
Capterra ReviewsHR: Returns max 250 most recent reviews.

Refresh window: 1 day
CeltraHR: No known limitations

Refresh window: 2-3 days
ClockifyHR: No known limitations

Refresh window: 2-3 days
CriteoHR: Last 2 years.
Criteo Retail MediaHR: The report date window has a max of 100 days; data is retained for up to 3 years.

Refresh window: 5 days
Database (Google Apps Script)HR: Historical limits will be based on what data is available in the database.
DoubleVerifyHR: No known limitations

Refresh window: 2-3 days
EverflowHR: Site lifetime

Refresh window: 2-3 days
Facebook Ads

The Facebook Ads API doesn't provide:

  • Data older than 2012-09-28
  • Demographic data older than 2013-01-01
  • Device data older than 2014-07-03
  • Ad insights data older than 37 months (reference)

Refresh window: Set to the maximum of your attribution windows on the platform.

Facebook Billing DataHR: No known limitations

Refresh window: 2-3 days
Facebook Insights

HR: Though it doesn't appear to be recorded anywhere, organic reach values are not tracked before October 2017 (and maybe sooner, it could be a rolling window).

Insights only retains last 2 years of data, older data is subject to removal.


API delay: 0-4 days


Refresh window: 5 days

Facebook Public DataHR: Due to the post feed limitation in the Graph API, it will return approximately 600 ranked, published posts per year.
FlashtalkingHR: No known limitations

Refresh window: 2-3 days
G2 ReviewsHR: No known limitations

Refresh window: 2-3 days
Glassdoor ReviewsHR: 250 latest reviews for a company.

Refresh window: 1 day
Google Ad ManagerHR: Up to 3 years of data
Google AdSenseHR: Last 3 years
Google AdsHR: No known limits, assumed to be account lifetime.

Refresh window: Set to the maximum of your attribution windows on the platform.

Google AnalyticsHR: For most data, there is no limit after 2005-01-01.
Google Analytics 4HR: User-level data, including conversions, is deleted after 14 months, and age, gender, and interest data after 2 months. For all other event data, you may choose the length of retention to be 2 or 14 months. Read more.

Refresh window: Set to 9 days to allow for modelled conversions to be finalized.

Google Campaign Manager 360

HR: 2 years for most data; 60 days for Floodlight reports, Multi-channel Funnel reports, and Path to conversion reports. 31 days for keyword data.


API delay: 1 day


Refresh window: 3 days

Google Display & Video 360

Default: Last 2 years of data

Floodlight report: Last 2 months of data

Google Merchant CenterHR: No known limitations

Refresh window: 2-3 days
Google My BusinessHR: Last 18 months of data. 
  • Total review count: total current number of reviews, not limited to the past 18 months
  • Avg overall star rating: the current avg star rating of the location, based on all the reviews and not limited to the past 18 months


API delay: 2 days


Refresh window: 4 days

Google Search Ads 360HR: Last 2 years of data
Google Search ConsoleHR: Last 16 months of data


API delay: 2 days


Refresh window: 4 days

Google SheetsHR: No known limitations.
Google TrendsHR: Returns data from 2004 onwards and only the last 31 days for Daily Trends.
HarvestHR: No known limitations

Refresh window: 2-3 days
HotjarHR: No known limitations

Refresh window: 2-3 days
HubSpotHR: Account lifetime.
IgniteHR: Data available since 2018-08-01 for residential listings and since 2020-08-26 for commercial listings.
ImpactHR: 366 days at a time

Refresh window: 2-3 days
Indeed ReviewsHR: 200 latest reviews for a company

Refresh window: 1 day
Instagram Insights

HR: Stories disappear after 24 hours. Metrics data is stored for up to 2 years. Media endpoint gets a maximum of 10,000 of the most recently created objects.


API delay: 0-4 days


Refresh window: 5 days

Instagram Public DataHR: Profile posts up to 2 years old; Stories disappear from results after 24 hours. Post Search fetches posts published in the last 24 hours, to a maximum of 250 posts.
Integral Ad ScienceHR: No known limitations

Refresh window: 2-3 days
IQMHR: No known limitations

Refresh window: 2-3 days
JSON/CSV/XMLHR: Historical limits depend on the API/web service you are connecting to. Please check the documentation for the source system.
LINE AdsHR: No known limitations

Refresh window: 2-3 days
LinkedIn Ads

HR: Non-demographic data available for the last 10 years. Daily demographic-based analytics available for the last 6 months, and all other granularities for 2 years.

Refresh window: Set to the maximum of your attribution windows on the platform.

LinkedIn Company Pages

HR: Non-demographic data available for the last 10 years. Daily demographic-based analytics available for the last 6 months, and all other granularities for 2 years.


API delay: 2 days for post

LinkedIn Revenue AttributionHR: No known limitations

Refresh window: 2-3 days
LiveIntentHR: No known limitations

Refresh window: 3 days
MailchimpHR: No known limits, assumed to be account lifetime
MarketoAPI delay: 1 day

Refresh window: 3 days
MatomoHR: No known limitations

Refresh window: 2-3 days
MediaMathHR: No known limitations

Refresh window: 2-3 days
Microsoft Advertising

HR: Max 3 years of data, but depends on the report type. More information in Microsoft Advertising API docs.

Refresh window: Set to the maximum of your attribution windows on the platform.

MixPanel
HR: No known limits
MOATHR: No known limitations

Refresh window: 2-3 days
MozHR: No historical data is available in the API. All data is current-state.
Newsletter2GoHR: No known limitations

Refresh window: 2-3 days
Nexxen DSPHR: No known limitations

Refresh window: 2-3 days
OmnisendHR: No known limitations

Refresh window: 2-3 days
OptimizelyHR: Project lifetime
Outbrain AmplifyHR: Account lifetime
PardotHR: Earliest start date is 1999-02-01
PayPalHR: Account lifetime
Piano Analytics (AT Internet)HR: Data available from 2017-01-01 or site lifetime

Refresh window: 2-3 days
Pinterest AdsHR: UI reporting only allows up to the past 25 months of data, in some cases can be up to a year before the current date. API allows 30 months of data for non-hourly breakdowns.

Refresh window: Set to the maximum of your attribution windows on the platform.

Pinterest Organic

HR: Cannot be more than 90 days back from today.

Pinterest Public DataHR: Only reports lifetime metrics. Can only get 50 pins per user.
Piwik PRO
HR: No known limitations

Refresh window: 2-3 days
PrisjaktHR: No known limitations

Refresh window: 1 day
QuantcastHR: No known limitations

Refresh window: 2-3 days
Quora AdsHR: Quora Ads has a limit of 2000 requests per hour. Learn more in Quora's documentation.

Refresh window: Set to the maximum of your attribution windows on the platform.

Rakuten AdvertisingHR: The API is limited to the last 4 years. The reporting UI is limited to the last 3 years.

Refresh window: 2-3 days
ReadpeakHR: No known limitations

Refresh window: 2-3 days
Reddit Public DataHR: Only fetches current state of board/user/etc. No historical data
RTB HouseHR: No known limitations

Refresh window: 2-3 days
SalesforceHR: No known limitations
SearchmetricsHR: There are some historical fetches, but limitations depend on the report type. See Searchmetrics documentation for more specifics.
Semrush Analytics

HR: Can pull data from US databases from 2012 forward, other locations' historical range may be less. Users can pull current data (today), and some report types allow for pulling from past months — please note that this costs more credits.

Semrush Projects

HR: Can pull data from US databases from 2012 forward, other locations' historical range may be less. Users can pull current data (today), and some report types allow for pulling from past months — please note that this costs more credits.

ShopifyHR: No documented limit but practical limits apply (the cost of the query). See Shopify API docs for more information.

Daily demographic-based analytics are only available for the last 6 months.
SimilarwebHR: 31 days for the App data report. Until the latest completed month for the Traffic source report.

Refresh window: 1 day
SizmekHR: No known limitations

Refresh window: 7 days
SlackHR: No known limitations

Refresh window: 1 day
SmarpHR: No known limitations

Refresh window: 2-3 days
Snapchat MarketingHR: No known limitations


API delay: 2 days


Refresh window: 4 days

SnowflakeHR: Historical limits will be based on what data is available in the data warehouse.
Spotify AdsHR: No known limitations

Refresh window: 2-3 days
Sprout SocialHR: No known limitations

Refresh window: 1 day
StackAdaptHR: No known limits, assumed to be account lifetime.
StripeHR: No known limits, assumed to be account lifetime.
TaboolaHR: No known limits, assumed to be account lifetime.
TeadsHR: Reporting data is available from January 2020 onwards.

Refresh window: 2-3 days
The Trade DeskHR: API can only pull data created on or after June 20, 2017. Supermetrics supports the last 180 days from the first client login.

For example, if you connect The Trade Desk to Supermetrics for the first time on January 1, 2022, the oldest date you can pull data from is 180 days before that. This will stay the same for as long as you use this connector.
TikTok AdsHR: Account lifetime

API delay: Spend-related metrics have a latency of 48 hours. Learn more about data latency in TikTok Ads' documentation.
TikTok OrganicHR: Last 60 days

Refresh window: 3-4 days
TradedoublerHR: 730 days

Refresh window: 2-3 days
Tripadvisor ReviewsHR: 100 latest reviews for the selected location

Refresh window: 1 day
Tumblr Public DataHR: Only fetches current state of blog. No historical data other than retrieving older posts.
Twitter Premium

HR: Up to last 90 days for impressions and engagements data. 3200 Tweet limit, which includes retweets and replies. See also Twitter Premium limitations and rate limits.

Vimeo Public DataHR: No known limits
VKontakte Public DataHR: Only fetches current state of board/user/etc. No historical data is available.
X Ads (Twitter)HR: Account lifetime, though 30-day fetches are recommended.


API delay: 2 days


Refresh window: Set to the maximum of your attribution windows on the platform.

X Organic (Twitter)HR: Up to last 90 days for Tweet engagement

Refresh window: 7-8 days
X Public Data (Twitter)HR: Will fetch approx. the last 2000 tweet items (includes retweets and replies), starting from the end date given and moving backwards.
XandrHR: 45 days for Geo & Domain level reporting
Xing AdsHR: For lifetime values data is available from 2019-04-16.

Refresh window: 2-3 days
Yahoo DSPHR: Can fetch data up to 2 years; data older than that is purged and cannot be requested.
Yahoo! Japan Search AdsHR: No known limitations

Refresh window: 5 days
Yahoo! Japan Display AdsHR: No known limitations

Refresh window: 5 days
Yandex.DirectHR: Statistics are available for the last 3 years.
Yandex.MetricaHR: No known limitations
Yelp ReviewsHR: No known limitations

Refresh window: 2-3 days
YextHR: No known limitations

Refresh window: 2-3 days
YouTube
HR: No known limitations, should fetch from the beginning of the account's lifetime. Note that some query types, such as Videos Performance, only fetch the last 1000 videos published.
YouTube (Legacy)HR: No known limits, assumed to be channel lifetime.

API delay: 3 days

Refresh window: 5 days
ZemantaHR: No known limitations

Refresh window: 2-3 days

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.