הצגת מגמות קנייה

SELECT
  topic_trends.customer_country_code,
  topic_trends.topic,
  topic_trends.date,
  topic_trends.search_interest,
  topic_trends.last7_days_search_interest,
  topic_trends.last30_days_search_interest,
  topic_trends.last90_days_search_interest,
  topic_trends.last120_days_search_interest,
  topic_trends.next7_days_search_interest
FROM TopicTrendsView
WHERE topic_trends.customer_country_code = 'US'
  AND topic_trends.date BETWEEN '2023-07-01' AND '2023-07-03'
ORDER BY topic_trends.date DESC

  "results": [
    {
      "topicTrends": {
        "customerCountryCode": "US",
        "topic": "Cell Phone Cases",
        "date": {
          "year": 2023,
          "month": 7,
          "day": 3
        },
        "searchInterest": 50.2,
        "last7DaysSearchInterest": 49.5
        "last30DaysSearchInterest": 51.1
        "last90DaysSearchInterest": 50.7
        "last120DaysSearchInterest": 49.3
        "next7DaysSearchInterest": 60
      }
    },
    {
      "topicTrends": {
        "customerCountryCode": "US",
        "topic": "Cell Phones",
        "date": {
          "year": 2023,
          "month": 7,
          "day": 2
        },
        "searchInterest": 70.2,
        "last7DaysSearchInterest": 69.8
        "last30DaysSearchInterest": 71.4
        "last90DaysSearchInterest": 70.6
        "last120DaysSearchInterest": 69.0
        "next7DaysSearchInterest": 70.1
      }
    },
{
      "topicTrends": {
        "customerCountryCode": "US",
        "topic": "Wireless Speakers",
        "date": {
          "year": 2023,
          "month": 7,
          "day": 1
        },
        "searchInterest": 40.6,
        "last7DaysSearchInterest": 41.4
        "last30DaysSearchInterest": 40.6
        "last90DaysSearchInterest": 40.3
        "last120DaysSearchInterest": 39.8
        "next7DaysSearchInterest": 41.1
      }
    }
  ]