Milestone Statistics, Unnecessarily Detailed Data

Welcome to part two of three in a series of posts thanking readers, and taking a step back to review Amdall Gallery’s status as we approach a subscriber milestone. In the first, I dropped a poll asking what sort of giveaway subscribers might be interested in, and shared a few cool artists I’ve come across through working on this website. In this post, we’re going to focus on data and statistics! Then, for the final entry to the series, we’ll have a giveaway/contest.

As part of this thought process related to subscribers, I also wanted to get a better idea of activity on the site. The WordPress dashboard gives you some basics, but doesn’t provide a full accounting of everything you might wonder about your site. I wanted to get more in-depth with number of interactions, user comments, likes, etc., so I made an unnecessarily detailed spreadsheet. I started by copying the full list of comments and posts from WP-Admin, highlighting and copying “likes” from each individual post, and then pasting each into their own Excel tabs. Then, I utilized functions and formulas to massage the data into structured columns, and dug into some Pivot Tables and graphs.

I uncovered a ton of information, but here are some interesting tidbits:

  • I am responsible for 49% of the comments on Amdall Gallery (175 of the 356 total comments). That makes sense for the most part, because I try to respond to every comment.
  • Slightly more views (53%) have occurred on research/analysis posts than on art posts (47%).
  • The vast majority of likes have been for art posts (91%), which is logical because I believe likes only come from WordPress accounts. Artists who come across my site tend to come from WordPress, since they probably browse tags similar to mine.
  • Most comments (79%) have been on art posts, compared to analysis posts (21%).
  • So, overall: More people look at the analysis posts, but more people interact with the art posts.
  • Adding up all total interactions (comments and likes), 41% are from a core group of 29 people who have commented or liked 10+ times. You could possibly consider these 29 users to be Amdall Gallery’s core audience, since they engage with posts most frequently.
  • 11% of all interactions are from one-off visitors. 12% of interactions have actually been from me, all of which were comments (usually replies).
  • 48% of users (152 people) who visited only have one interaction. 9% of users who have visited have 10+ interactions (these are the 29 users I mentioned before).
  • Referral sites are a bit surprising; there is a very clear top three that includes the WordPress Reader (hurrah), Reddit, and Bing (seriously). The WP Reader is a personal favorite, so I’m glad to see that. Reddit is…well…a great example of how toxic the internet can be, so I share there sparingly now. But it’s an incredible source of traffic if you have thick skin. And Bing is well ahead of Google here!

And naturally, what would an analytic post be without some graph mania?

Sum of All Interactions Apr 2018

Figure 1. Sum of all interactions. Likes and comments all totaled, then grouped by user types.

Count of Users w Numbers of Interactions Apr 2018

Figure 2. Count of users with specified interaction numbers. First column is number of users with one interaction (like or comment), second is users with two or more, etc.

Art vs Analysis Posts Apr 2018

Figure 3. Posts categorized as Art versus categorized as Analysis. Listed by (left to right) total likes, views, and comments.

Likes and Comments Top 20 Posts Apr 2018

Figure 4. Scatter chart of the top 20 posts (ranking based on weighted interaction totals), with likes on the x-axis and comments on the y-axis.

Top 30 Posts Weighted Totals Apr 2018

Figure 5. Top 30 posts based on weighted interaction totals. Formula for weighted interaction normalizes each category using the highest totals for each (Weighted = Views + [Likes x 34] + [Comments x 68].

Traffic Referrers by percentage 2018

Figure 6. Traffic referrers by percentage of total.

Traffic Referrers by Total Number 2018

Figure 7. Traffic referrers by total numbers.

Traffic by Country

Figure 8. Traffic by country, shown as percentage.

After I processed this data, I actually contacted WordPress to discuss more robust statistical data for administrators (something similar to info obtained through my data crunching). They were very receptive! Maybe at some point in the future, they will beef up the dashboard for weird spreadsheet junkies like me.

Anywho, that’s it for my over-analysis near the 300 subscriber (291 right now I think) milestone. This was incredibly interesting and fun for me, but something tells me I might be the only one who cared about this portion. Hopefully, the next post will be more interesting, since it involves a contest! And since I doubt we’ll have many entries, the chances of winning are probably fairly high. The only question now is, do I save the giveaway for when the site actually reaches 300? Or am I too impatient for that?



  • Pingback: One Year Site Anniversary | Amdall Gallery

  • Oh yeah, something I forgot to mention. No one may notice this, because it’s so small and insignificant, but on figure 7 (traffic referrers by total numbers), there’s one that says “” If anyone has ever seen that on their own site and wondered what it was, my understanding is that it’s Google’s web crawler robot. Basically, it seems that is Google indexing your pages for the search engine.

  • Pingback: Subscriber Appreciation Giveaway | Amdall Gallery

  • Wow, that must have taken very long to analyze. I admire your dedication. I find it fascinating! I didn’t even know WordPress provided all those statistics – it might be fun to look into for my own site too πŸ™‚

    Peculiar how it varies, depending on Art of Analysis.:)

    I do the same; it’s always nice to get a response if you make a comment.

    Where did your Poll link go? I voted, but can’t find it now – wanted to take a peek at what others wanted, heh. πŸ™‚

    Hm, can one even see at which time/date one gets the most “trafic” on their site? Sometimes it seems as if timing matters a great deal.

    Maybe you’ll reach 300 while making these posts πŸ™‚

    • I absolutely love doing stuff like that – I feel like I owe whoever invented the spreadsheet a debt of gratitude!

      I’m not 100% sure about the poll, but on my end, under the vote button you can click where it says “view results” if you’ve already voted. Although, I’m not sure if that’s there just because I created the poll…but, I can tell you right now we’ve got 80% (4 votes) who would want a portrait/drawing, and 20% (one vote) who would want art supplies.

      As for when you get the most traffic, with the basic WordPress plans you can see dates you get the most traffic. Just click “My Sites” and click “Stats.” The Traffic button should show your daily views and visitors, which you can change to daily, weekly, monthly, or yearly views. You can also click Insights, which will show you an all-time view graphic. If you are upgraded to the Business plan, you can associate your WordPress site with Google Analytics, which will show you hourly data!

      • I understand – I wish I had the brain to do it!

        Aha, I see, thank you for the insight πŸ™‚

        Oh, you can? I should look into the whole WordPress behind the scenes- thing. Sounds as if there is a lot of info to be gained there. Thank you for the explanation πŸ™‚

      • You are quite welcome – I’m always glad to discuss data and stats!

Leave a Reply