wowprompt

Seasonal demand check with Google Trends before stocking up

Reads Google Trends exports and past sales for a product category and says when demand starts rising, when it peaks and when it falls, so a shop or brand can time stock, ads and content for festivals and seasons. Use it before Diwali, wedding season, winter or any yearly peak, when guessing the timing costs money.

A week-by-week demand calendar for a product category showing the rise, peak and drop, with dates to order stock, start ads and publish content
The output this prompt produced, unedited.

The prompt

Constraints first

  • Google Trends shows relative interest from 0 to 100, never search volume; never turn it into a number of searches.
  • Compare at least three years so one odd year does not set the plan.
  • Festivals that move on the calendar are aligned by their date each year, not by the calendar week.
  • Use only the data pasted.

Inputs

  • Product category and search terms: [e.g. woollen shawls, shawl for women, pashmina shawl]
  • Region: [e.g. India, or a state such as Punjab]
  • Trends export: [paste weekly rows for the last three to five years]
  • Own sales by week, if any: [paste, or none]
  • Festival or season dates for each year: [e.g. Diwali dates for the years covered]
  • Lead time to receive stock: [e.g. five weeks]

Analysis

  1. Find the week each year when interest first climbs clearly above its usual level.
  2. Find the peak week and how long the high period lasts.
  3. Compare search timing with own sales, if given, and note any gap.
  4. Note any term that is growing or shrinking year on year.

Output format

  1. | Year | Rise starts | Peak week | Drop ends | Notes |
  2. A calendar for this year: order stock by, start ads by, publish guides by, end promotions by.
  3. Terms rising in interest, as ideas for new products or pages.
  4. Two risks that could shift the timing this year.
google trends researchseasonal demandfestive demand planningsearch trend analysisinventory timingseasonality check

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity