Apartment for Rent (Category 1) - User Listing Views Analysis 2025

Date: 2026-01-14 Category: Apartment for Rent (شقة للإيجار) Data Source: sadb_user_listing_views joined with sadb_listings

Summary

Analysis of month-over-month user listing views for the “Apartment for Rent” category throughout 2025 to identify periods of dramatic growth.

Key Finding

The most dramatic increase occurred in April 2025 with a +36.5% month-over-month growth, adding nearly 3 million views compared to March. This reversed a declining trend from Q1.

Monthly Data

Month	Total Views	MoM Change	% Change	Unique Listings	Unique Users
2025-01	10,212,593	–	–	30,834	366,176
2025-02	8,266,173	–1,946,420	–19.06%	28,295	329,044
2025-03	8,063,690	–202,483	–2.45%	29,308	308,125
2025-04	11,007,111	+2,943,421	+36.50%	32,918	378,268
2025-05	11,259,246	+252,135	+2.29%	37,262	377,481
2025-06	11,139,201	–120,045	–1.07%	37,568	367,824
2025-07	12,747,810	+1,608,609	+14.44%	35,324	404,857
2025-08	13,672,652	+924,842	+7.25%	37,464	427,451
2025-09	12,634,091	–1,038,561	–7.60%	38,700	411,489
2025-10	11,758,318	–875,773	–6.93%	38,215	386,282
2025-11	10,590,093	–1,168,225	–9.94%	37,741	355,818
2025-12	10,853,677	+263,584	+2.49%	38,496	364,231

Significant Growth Periods

1. April 2025 (Primary Spike)

+36.5% growth (8.06M → 11.0M views)
Absolute increase: +2,943,421 views
Likely driven by end of Ramadan 2025 (late March) when rental activity typically rebounds

2. July 2025 (Secondary Spike)

+14.4% growth (11.1M → 12.7M views)
Absolute increase: +1,608,609 views
Summer moving season effect

3. August 2025 (Peak Month)

Highest total views: 13,672,652
Highest unique users: 427,451
Continued momentum from July

Observations

Seasonality Pattern: Clear Q1 dip (Ramadan effect), strong Q2-Q3 recovery, Q4 normalization
Supply Growth: Unique listings increased from ~29K (March) to 38K+ (Sept onwards), indicating significant inventory expansion
User Engagement: Unique users peaked at 427K in August, correlating with the highest view counts
Year-End Stability: December showed slight recovery (+2.49%) after the Q4 decline

SQL Query Used

WITH
  category_listings AS (
    SELECT
      id AS listing_id
    FROM
      default.sadb_listings FINAL
    WHERE
      category = 1
      AND _peerdb_is_deleted = 0
  ),
  monthly_views AS (
    SELECT
      formatDateTime(toStartOfMonth(createdAt), '%Y-%m') AS MONTH,
      count(*) AS total_views,
      count(DISTINCT listing_id) AS unique_listings_viewed,
      count(DISTINCT user_id) AS unique_users
    FROM
      default.sadb_user_listing_views FINAL
    WHERE
      _peerdb_is_deleted = 0
      AND toYear(createdAt) = 2025
      AND listing_id IN (
        SELECT
          listing_id
        FROM
          category_listings
      )
    GROUP BY
      MONTH
    ORDER BY
      MONTH
  )
SELECT
  MONTH,
  total_views,
  lagInFrame(total_views, 1) OVER (
    ORDER BY
      MONTH
  ) AS prev_month_views,
  total_views - lagInFrame(total_views, 1) OVER (
    ORDER BY
      MONTH
  ) AS absolute_change,
  round(
    (
      total_views - lagInFrame(total_views, 1) OVER (
        ORDER BY
          MONTH
      )
    ) * 100.0 / lagInFrame(total_views, 1) OVER (
      ORDER BY
        MONTH
    ),
    2
  ) AS pct_change,
  unique_listings_viewed,
  unique_users
FROM
  monthly_views
ORDER BY
  MONTH

Recommendations

Marketing Planning: Allocate increased marketing budget for late March/early April to capitalize on post-Ramadan demand surge
Inventory Preparation: Ensure sufficient listing inventory before April and July to meet demand spikes
Further Analysis: Investigate April 2025 spike by city/district to identify geographic hotspots