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.
| Hour | Posts | |
|---|---|---|
| 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
| Day | Posts | |
|---|---|---|
| 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.