Be More Original!

Lessons I Learned from Entering my Medium Data into a Spreadsheet

Image for post

Even though I’m a creative person, I’m also a bit of a statistics geek, and recently I decided to put the information on my Medium posts into an Excel Spreadsheet — the story titles, the number of views and reads they’d received. It I thought it would be a difficult task, but I was able to finish it fairly quickly. I did learn a few things from typing all that information into an Excel Spreadsheet, however.

I need to be more original with my titles.

When I was typing that information into the spreadsheet, I noticed I used the same post titles a lot, especially for update posts. I need to start coming up with more original post titles.

Write more responses to other people’s posts and more book reviews.

The story I wrote that got the most views was a story about how to create a running total in Google Sheets — however, most of those views came from Google. The posts that got the most views were ones that I wrote as responses to other Medium posts, or book reviews.

Submit more stories to publications.

The posts that had the next highest views were those that I wrote for Medium publications, especially The Entrepreneur’s Handbook. I’ve been removed as a writer from the Entrepreneur’s Handbook, but I am approved as a writer for two other publications, so I’ll start submitting some of my stories to them.

These are the three lessons I learned from putting my Medium data into a spreadsheet. As I publish more stories I’ll probably put more of them into the spreadsheet, but for now I think I’m done.

If you enjoyed this story, please feel free to clap for it. And if you’re interested in receiving a copy of the Excel spreadsheet I created, please sign up below.

I started writing in elementary school and never stopped. I enjoy sharing stories about my hard-learned life lessons and writing advice.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store