Berlin Flat Finder

Open data · Berlin

When Berlin sublets get posted

Most people assume flats get posted late at night, when the person leaving finally writes the ad. They do not. We have the send time for 2175 posts from Berlin's Telegram housing groups, and most of them go up during office hours.

65% of sublet posts land between 9am and 6pm, Berlin time. If posting were spread evenly across the day you would expect 38%.

By hour of day

Berlin local time. Peak: 11:00.

HourPosts
00:00 24
01:00 14
02:00 5
03:00 7
04:00 6
05:00 5
06:00 3
07:00 33
08:00 95
09:00 122
10:00 146
11:00 193
12:00 177
13:00 171
14:00 178
15:00 165
16:00 140
17:00 121
18:00 121
19:00 108
20:00 106
21:00 81
22:00 93
23:00 61

By day of week

DayPosts
Monday 341
Tuesday 356
Wednesday 306
Thursday 365
Friday 310
Saturday 228
Sunday 269

What to do with this

The useful takeaway is not “check at the peak”. It is that the window in which a listing is fresh, the first hour, when a reply still lands near the top of the poster's inbox, falls almost entirely inside the working day. If you only check your phone at eleven at night, you see each flat half a day late, behind everyone who saw it over lunch.

The quiet hours are quiet for posting, not for reading. Almost nothing new appears between midnight and 8am, so a late-night search mostly turns up listings everybody else has already answered.

This is also the case for what we do: nobody can watch a dozen group chats through a working day. A free account puts every listing from those groups and the big listing sites into one feed, and a pass shows each one as soon as it is posted rather than 48 hours later.

Method, and what this is not

Telegram only, on purpose. Our corpus has three sources and the timestamp means something different in each. A Telegram message carries the moment somebody hit send. Kleinanzeigen publishes an ad's date but no time, so every ad would land at midnight. WG-Gesucht publishes no date at all to a logged-out request, so the only timestamp available is the moment our scraper fetched it. Blending those would chart our own crawler's schedule and present it as the behaviour of Berlin's landlords.

2175 posts, all of them offers rather than people looking, de-duplicated so a flat cross-posted to five groups counts once. Hours are converted to Berlin local time, including across the October clock change. This describes the Telegram end of the market, which skews towards English-speaking and newly arrived people. The same coverage caveat applies as for the rent data.

Free to use with attribution, like everything else on our data page. If you want the underlying histogram as a file, ask.