top of page

Auto-SEO forecasting with StreamProphet! ๐Ÿš€

You guys have asked for it, so here's my StreamProphet app in early Beta! ๐Ÿค—

With this app you can:

  • Connect to Google Search Console and visualise your forecasted SEO traffic in just a few clicks

  • Visualise your time series' trends and seasonality

  • Export your predictions to CSV and your models to JSON! ๐Ÿ”ฅ

Link to the app

How to get started!

  1. Click the 'sign-in with Google' button to reach the consent screen

  2. Copy the Oauth token and paste it back in the app

  3. Type the Web Property

  4. Define your forecast horizon (from 1 month to 1 year)

  5. Press the 'Fetch GSC data & get predictions' button! ๐Ÿ”ฅ

๐Ÿ“ˆ Checking predictions

  • Once that's done, you can then visualise past data and predictions in the right-hand side chart

  • Left-hand side charts show you the decomposed trend, weekly and yearly seasonality (when available) of the time series

  • You can export predictions via CSV + your forecast model via JSON

๐Ÿ› ๏ธ Hereโ€™s the stack I used:

  • Web framework: the mighty @streamlit! ๐ŸŽˆ

  • Forecasting library: @fb_engineering Prophet

  • PyStan

  • Pandas

  • 100% Python! ๐Ÿ๐Ÿ”ฅ

๐ŸŒ… Early Beta

  • StreamProphet's still in early beta, with possible rough edges! You. Have. Been. Warned! ๐Ÿ˜Š

  • Issues, feedback or suggestions are welcome. Head-off to my Gitter page for a chat:


๐Ÿ“ To-Dos

  • Add session state so parameters can be tweaked w.o. having to re-authenticate

  • Add seasonality parameters

  • Holidays import so they can be factored in the forecast

  • Add cross-validation to optimise parameters

  • More forecasting models: ARIMA, HWAAS and more!๐Ÿ”ฅ

๐Ÿ™Œ Shout-outs!

Kudos to @JoshCarty and @_okld for their precious help!

Thanks also to @jakubmotyka, @KorayGubur, @periklispapanik and @RichardFergie for that early testing session! Lastly, this app is completely free. If it's useful to you, you can buy me a coffee to support my work! ๐Ÿ™


2,409 views1 comment
bottom of page