A breakdown of a competitor's social posts into a spreadsheet

The scenario gathers a competitor's social posts, computes engagement for each and puts the posts and average figures into Google Sheets.

  • See what lands for the competitor
  • Likes, comments, reach — all counted
  • Average figures across posts
  • Everything accumulates in Google Sheets
Google Sheets