Automated Scraping and Twitter Posts

The following is a project that involved the daily scraping of property data from various sources, with this data then analysed, and a tweet constructed and automatically sent out on a recurring basis.

 

Automated Scraping and Twitter Posts Wrekin Data

 

Process:

  • Cloud based scraping system runs at a designated time each morning, collecting property for sale counts from various sources, for every county in England.

 

  • Automated script detects that new data is present in the scraping system and imports this data into a shared Google Sheet.

 

  • Using a mix of formulas and macros, the data is analysed and a tweet constructed, using basic rules. These tweets are added to a separate sheet.

 

  • A second automation script detects that there are changes / updates to sheet in question and automatically posts these updates as tweets.

 

The result is an automated twitter feed, providing followers with up to date aggregated performance data along with a steady traffic stream.

Twitter Feed:

Properties for sale in Hampshire: Day on day change = -0.69% ( -105 ). Week on week = -0.99% ( -152 ). Month on month = -1.32% ( -203 ). #Property #PropertyData #PropertForSaleInHampshire #Hampshire

Properties for sale in Greater Manchester: Day on day change = -0.2% ( -29 ). Week on week = +0.18% ( +26 ). Month on month = -1.93% ( -285 ). #Property #PropertyData #PropertForSaleInGreaterManchester #GreaterManchester

Properties for sale in Gloucestershire: Day on day change = -0.12% ( -9 ). Week on week = +0.7% ( +50 ). Month on month = +0.44% ( +32 ). #Property #PropertyData #PropertForSaleInGloucestershire #Gloucestershire

Properties for sale in Essex: Day on day change = -0.34% ( -76 ). Week on week = +0.09% ( +20 ). Month on month = +0.48% ( +106 ). #Property #PropertyData #PropertForSaleInEssex #Essex

Load More...
Contact Us

We are glad that you preferred to contact us. Please fill our short form and one of our friendly team members will contact you back.

X