PropertyChat 2018 stats

Discussion in 'News & Announcements' started by Simon Hampel, 18th Jan, 2019.

Join Australia's most dynamic and respected property investment community
  1. Scott No Mates

    Scott No Mates Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    27,282
    Location:
    Sydney or NSW or Australia
    I'm dropping in my rankings and @Sackie is catching up. :eek:
     
    iloveqld, Redwing and Sackie like this.
  2. wombat777

    wombat777 Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    3,565
    Location:
    On a Capital and Income Growth Safari
    Would like to see stats on usage keywords - "boom", "bubble", "bust", "correction", "crash" (and any others following this theme) organised by month or state or month/state (if you can work how). Perhaps organise by the property sub-forums.
     
    spludgey likes this.
  3. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    You see, this is where this idea is completely problematic.

    You assert that your post is "pointless", whereas I see it as several completely valid questions - "how do we measure value?" and then, "how do we measure the change in value added over time?".

    The question of value is so incredibly subjective that it's almost impossible to measure.

    Even a bunch of silly threads in the coffee lounge adds value to the community in their own way.

    Alas, I fear that any objective measure of "value" is likely to elude us and we just have to make do with the simplistic data that is easy to generate. Then we can just sit around and argue about exactly what that data actually means!
     
    Archaon and SatayKing like this.
  4. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    9. Threads per day in 2018 (28 day moving average)

    upload_2019-1-18_13-38-16.png

    I think that's much "flatter" than what we see in posts per day - far less fluctuation / more consistent (between the beginning of April and the end of November, we ranged between 17 and 20 new threads per day on average).

    Comparing to previous years:

    Threads per day 2016-18

    upload_2019-1-18_13-40-42.png

    Surprisingly we saw a bit more volatility in 2017 - but overall I think they are much "closer" between each year.
     
  5. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    10. Threads per month in 2018

    upload_2019-1-18_15-47-57.png
     
  6. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    11. Threads per year

    upload_2019-1-18_15-48-43.png
     
  7. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    12. Active users per day in 2018 (Number of members who have logged in each day - 28 day moving average)

    upload_2019-1-18_16-11-53.png

    You can really see the Christmas dip!

    Active users per day 2016-18

    upload_2019-1-18_16-12-40.png

    What on earth happened in July 2016 ??

    • 01 Jul - 701
    • 02 Jul - 665
    • 03 Jul - 553
    • 04 Jul - 618
    • 05 Jul - 724
    • 06 Jul - 717
    • 07 Jul - 645
    • 08 Jul - 499
    • 09 Jul - 474
    • 10 Jul - 433
    • 11 Jul - 498
    • 12 Jul - 571
    • 13 Jul - 605
    • 14 Jul - 566
    • 15 Jul - 571
    • 16 Jul - 534
    • 17 Jul - 454
    • 18 Jul - 500
    • 19 Jul - 577
    • 20 Jul - 606
    • 21 Jul - 600
    • 22 Jul - 587
    • 23 Jul - 560
    • 24 Jul - 483
    • 25 Jul - 573
    • 26 Jul - 623
    • 27 Jul - 645
    • 28 Jul - 633
    • 29 Jul - 634
    • 30 Jul - 594
    • 31 Jul - 497

    The figures in bold are way below average. I'm wondering if there was something happening at the server end of the website because that is way below the average and such sharp drops haven't happened at any other time :confused:

    The way this figure is calculated is not something I can recalculate - it's calculated daily by the software and stored, so there is scope for anomalies to creep in there.

    Anyway - as you can see we actually had more daily active users in 2018 than in 2016, but not quite as many as in 2017.

    Unfortunately, we can't generate meaningful stats for active users per month, since it's a figure stored by the database and not something I can recalculate. Since it's counting unique active members, simply adding up how many daily active users there were for the month is meaningless, since people generally log on more than once per month.

    ... but we can still look at users who post instead!
     
  8. D.T.

    D.T. Specialist Property Manager Business Member

    Joined:
    3rd Jun, 2015
    Posts:
    9,191
    Location:
    Adelaide and Gold Coast
    Do you think 2017 vs 2018 Threads Created caused by or correlates to property market activity?
     
  9. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    Absolutely.

    There was a definite change about the type of threads being posted around the time that APRA effectively put the breaks on the property market. Combined with the banking royal commission - the lending landscape changed dramatically and I think we're seeing this reflected in forum activity.

    Post volume actually went up for a while as people sought to come to terms with what that all meant - but then it dropped off quite a bit since there were a lot of people who decided to sit on the sidelines.

    I'll try and do some reports which look at which topics the posts came from.

    It would be useful if any of the brokers could go back through the finance archives and identify major announcements from APRA that were posted about on here that we can use to correlate with the post volume data.
     
  10. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    Okay - here is some data which pretty comprehensively shows what I've been saying.

    I looked at posts per day since launch for our 3 biggest topics:
    • Where to buy
    • Property Market Economics
    • Finance
    The chart below shows 90 day moving averages of daily post rates made in those topics:

    upload_2019-1-18_17-23-41.png

    You can clearly see the sharp decline in post volumes in the Where to Buy forum since July 2017.

    Similarly, there was an immediate sharp drop in finance discussions from July 2017 through to October 2017 at which point the discussion levelled off, but still maintained a definite downtrend.

    At the same time, there was a rapid increase in the volume of Property Market Economics posts from April - July 2017, with a similar peak in July 2017 followed by a sharp decline through to October 2017, then more peaks and troughs - but a definite uptrend over time to today where we now get significantly more posts in the economics forum than we do in either Where to Buy or Finance.

    I think that's a pretty clear picture of investor sentiment there.

    I'd be interested to see the dates of major announcements about APRA changes and how they correlate here - noting that the above chart uses 90 day moving averages and so the reaction to the announcements in the chart may be delayed by up to 3 months.
     
    wombat777, robboat and Terry_w like this.
  11. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    Give me a list of keywords I can add to my queries:

    Positive:
    • boom
    • bubble (is this positive or negative? - I'm going to leave it in positive because it is usually used during a growing market)
    Negative:
    • bust
    • correction
    • crash
    What other words can I use to indicate sentiment?
     
  12. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    Here is a chart showing usage of the word "APRA" in posts since we launched.

    Chart shows how many posts per day have used the term APRA.

    upload_2019-1-28_12-31-41.png

    Note that this is showing the 90 day moving average - so data may lag by up to 3 months.
     
    Last edited: 28th Jan, 2019
    wombat777 and Terry_w like this.
  13. Mike A

    Mike A Well-Known Member

    Joined:
    24th Jun, 2015
    Posts:
    2,656
    Location:
    UNIVERSE
    @Terry_w probably makes up 20 to 30% of total posts. Would love to know that stat.
     
  14. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    @Terry_w total posts: 19,515 ... PropertyChat total posts: 646,497 ... percentage: 3.0% of total :D
     
    craigc, Terry_w and Mike A like this.
  15. Mike A

    Mike A Well-Known Member

    Joined:
    24th Jun, 2015
    Posts:
    2,656
    Location:
    UNIVERSE
    Thanks. Good stat
     
  16. Angel

    Angel Well-Known Member

    Joined:
    19th Jun, 2015
    Posts:
    5,816
    Location:
    Paradise, Brisbane
    July 2016 - Was that when a few young gentlemen from Sydney would come to Brisbane with a bus load of Asian students who all purchased properties in (ahem) Logan, Moorooka or thereabouts. @Simon Hampel, check if the low-action dates coincided with the Saturday they were house-hunting and on real estate websites rather than being on this site.
     
  17. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    I found the previous chart about posts mentioning APRA curious in that we started with a very high post rate back after launch of the site - so I decided to check out the same data from Somersoft to see if there was an earlier trend.

    Here is the data from Somersoft showing the average posts per day which mention the word "APRA" (90 day moving average):

    upload_2019-1-28_14-12-19.png

    Almost nothing until 2014 - at which point it starts to pick up ... but that spike at the end!!!???

    I decided to zoom in and look at a 28 day moving average from the beginning of January 2014 to see if we can see a more definite pattern:

    upload_2019-1-28_14-13-49.png

    All this APRA stuff really kicked off in May 2015!!

    It's no wonder we were getting such high post counts with the APRA keyword right after the launch of PropertyChat in June 2015!

    I looked through some of the threads that were getting traffic back in May 2015 - here's some of the discussions we were having back then:
     
  18. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    Okay then, so using @wombat777 's suggestion of keywords - here is a chart showing the percentage of posts which contain "positive" keywords vs those which contain "negative" keywords. We can use this as a crude form of investor sentiment.

    upload_2019-1-28_15-11-13.png

    Note that this is across all forum topics.

    The crossover point where the "sentiment" changes to being predominantly negative was just before the middle of November, 2018.

    Let's look at the difference between the two values charted above:

    upload_2019-1-28_15-12-14.png
     
    Blueskies, paulF and WattleIdo like this.
  19. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    Here's the same queries run on Somersoft (2002 - 2015)

    upload_2019-1-28_21-48-40.png

    upload_2019-1-28_21-49-0.png

    Surprisingly, there was only one period where sentiment dropped into the negative - between August and October 2011!?
     
    WattleIdo likes this.
  20. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,419
    Location:
    Sydney
    Okay, back to our regularly scheduled programming ...

    13. Posting users per day in 2018
    (Number of members who have posted at least once each day - 28 day moving average)

    upload_2019-1-29_9-17-38.png

    Posting users per day 2016-18

    upload_2019-1-29_9-18-1.png