Hopted Amazon Data Tutorial: Custom Date Ranges & Historical Sales Analysis

Sometimes you need to compare this month with last month, check a specific holiday period, or review a year-over-year sales window to understand what actually changed.

Hopted helps Amazon sellers bring Seller Central, Vendor Central, and Amazon Ads data into Google Sheets, and custom date ranges make those reports more useful for deeper analysis.

In this guide, I will explain how custom date ranges work in Hopted, when to use them, and how to build side-by-side historical comparisons inside one spreadsheet.

Why Custom Date Ranges Matter

Basic date presets are helpful for quick checks, but they do not always match how sellers actually review performance.

For example, a 30-day report may not show the full story if your product has a long sales cycle, seasonal demand, or a promotion that ran during a specific date window.

Custom date ranges help you ask better questions, such as:

• How did this product perform during the last holiday period?

• Was this month better than the same month last year?

• Are recent sales improving compared with the previous baseline?

• Did a campaign, price change, or inventory issue affect the numbers?

This is where Hopted’s custom range options become useful.

You can build reports around the time periods that matter to your business instead of forcing every analysis into a simple 7-day, 14-day, or 30-day view.

Master Look-Back Options and Limits

Hopted can help you work with both preset and custom date ranges, depending on the report you choose.

Some reports may support recent windows such as the last 7, 14, 30, or 90 days.

Other reports may allow longer historical look-backs, such as many months or even a few years, depending on Amazon’s own report and API limits.

The important point is that the limit is not always the same for every report.

A sales report, an orders report, and an inventory report may each have different available history.

So instead of assuming every report can go back the same amount of time, check the date options inside the selected Hopted report before building your analysis.

Step-by-Step Selection of Custom Parameters

To use a custom date range, start inside the Hopted sidebar in your Google Sheet.

Open your active sync or create a new one, choose the report you want, and look for the date range dropdown.

From there, you can choose a preset range or move into custom date settings.

Common custom options may include:

• Custom last N days: useful when you want a rolling window, such as the last 45 or 60 days.

• Custom days ago range: useful when you want a specific period from the past, such as a promotion window.

• Previous calendar month: useful for monthly reporting and finance-style reviews.

• Custom calendar months range: useful when you want to compare full seasonal blocks or older periods.

The best range depends on the question you are trying to answer.

If you are checking weekly sales momentum, a short rolling window may be enough.

If you are reviewing Q4 seasonality, a calendar-month or historical range will usually be more useful.

Combining Multiple Time Periods in One Sheet

One of the most useful ways to use custom date ranges is to place different periods side by side.

For example, you can build a report where one column shows recent 7-day sales, another shows the last 30 days, and another shows a historical seasonal block. That gives you a much clearer view than looking at each report separately.

This setup is useful because it keeps the comparison inside one spreadsheet row for each product or SKU.

Your team does not need to manually export several reports and stitch them together every time.

Still, the report should be checked before you rely on it.

Make sure each column is using the intended date range, report type, marketplace, and metric.

Best Use Cases for Historical Amazon Data

Historical ranges are most useful when you are trying to understand context, not just read today’s numbers.

For example, you can use them to review seasonal demand, compare pre-promotion and post-promotion performance, check whether a product is recovering after a stockout, or understand if current sales are stronger or weaker than last year’s baseline.

This makes the report more useful for planning, not just tracking.

If you know what happened during the last major sales period, you can make better decisions about inventory, PPC budget, pricing, and launch timing.

Final Thoughts: Start With One Useful Comparison

Custom date ranges are powerful, but you do not need to build a massive historical dashboard on day one.

Start with one comparison that would actually help your business.

For example, compare the last 30 days with the same period from a previous season, or compare recent sales momentum against a longer baseline.

Once that first report is working, you can add more time windows, more metrics, and more product-level views.

That keeps the setup practical and helps you avoid building a sheet full of numbers your team never uses.