How do you know what's working on Instagram

There’s many things that people do not know about managing their Instagram accounts effectively, but this is one that won’t take up too much of your time, and will help guide your efforts moving forward. I’ve said this before on my broadcasts, but I like to approach Instagram as one big science experiment. Whatever strategy you create for Instagram, you won’t know if your efforts are working unless you keep track.

There are two tools you can use to keep track of your posts- one I’ve been using for a while, and a new tool I just came across that I am so excited about.

Google Drive

The thing I love most about Google Drive is that it’s so easy to use, it’s accessible anywhere, AND it’s free. Almost everyone is familiar with using the apps, so the Spreadsheet app is a perfect tool to keep track of how your posts perform. My big reason for keeping track of how my Instagram content performs, is to compare the content you share month by month and adjust my strategy accordingly. Ya know- do more of that works, and less of what isn’t working. By keeping track of my posts, I have seen what my audience connects with best, and I’ve removed some of the “themes” or Instagram post categories that my audience didn’t engage with; and am able to experiment with new themes and post types.

By keeping track of my engagement, I was able to see proof that my audience responds best to images of my face. Posting self portraits more often wasn’t my favorite idea, but because that’s what my audience wants, I have made an effort to add more and more images of myself in my feed, because it will only help my brand to be more present personally on Instagram.


The spreadsheet template I use can be downloaded and used with your own information. I have added the columns that I find helpful, which includes dates of posts, post theme or category, time of posting, hashtags you’ve used, and then your engagement rate for the posts. I try and enter the values every week, so I’m not stuck with entering tons and tons of data at the end of the month.


I came across Airtable and thought it could be the perfect solution to the fact that I couldn’t upload the images in the cells on the Google Spreadsheet. I’ve been looking for a solution to this, that can enable my clients to check through their content and be able to look at the images we share and how their audience engaged with what they shared. Airtable is an amazing new app, that is less about crunching numbers with functions, and more about a “database”. You can easily upload the images you schedule for Instagram into the table cells, then add in your client’s emails to share the table with them. The perfect tools for a social media manager, or a boss lady that wants the cold hard data to see the ROI for all the time they spend on Instagram.

Please let me know your thoughts or leave questions below in the comments! I’d love for you to share your results from your tracking spreadsheet, so please share in the comments as well!

Please feel free to share this if you found it useful! You can share using the buttons below- thanks in advance, friend!

Pin It on Pinterest