Monday, September 3, 2012

How to count total number of posts from archive in any Blog?

If I visit any of the blog online, I used to see their archive to know the total number of posts. I do, bit analysis about the age of the blog, frequency of number of posts, number of feedburner subscribers etc.,

If number of posts are less, we can easily count the total. If number of posts are more and they enabled archive for weekly subtotal, it is very difficult to calculate the total number of posts for aged blogs.

Today, I will explain you how to count total number of posts from archive for any of the blog by using our MS Excel.


What is 'archive' in blog?


Blog 'archives' are history of your blog. These archives are acting as additional webpages, that contain all of your older posts. In simple terms, blog archives stores all of your posts so that they will always be there for others to read.

The following are the screenshots of archives in different blogs.













If you observe the first blog archive has the weekly frequency and the second has monthly frequency.

Steps to count total number of posts from archive in blog

1. Go to any of the blog (which should enable the archive feature on the home page)

Ex: www.lostinexcel.blogspot.com

2. Right click on the homepage

3. Click View page source (then webpage code window opens)

4. Find for "archive" by using Ctrl+F shortcut


5. If you find more than one "archive" you have to choose the correct "archive" word (where the list of months / weeks)

6. Copy the code just above from the first month/week code till last month / week code (see reference screenshot below)

7. Open an Excel and Paste the code over there. (either by using Paste special Values / Paste special Text) - Let say, you have pasted in column A from Cell A1

8. Enter the below formula in Cell B1

=MID(A1,SEARCH("(",A1)+1,SEARCH(")",A1)-SEARCH("(",A1)-1)

9. Drag the formula from Cell B1 to the last Cell till data ends

10. Copy Column B - Paste as Paste special values in Column C - Convert all the items as numbers

11. Total it by using Sum function.

12. Thats All !!

6 comments:

  1. There is not a soul who does not have to beg alms of another, either a smile, a handshake, or a fond eye. See the link below for more info.

    #beg
    www.inspgift.com


    ReplyDelete
  2. I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often..


    Chix
    www.imarksweb.org

    ReplyDelete
  3. please keep us informed like this; it carries awesome and actually good data in favor of readers.

    www.n8fan.net

    ReplyDelete
  4. I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article.


    edupdf.org

    ReplyDelete
  5. Good day! I found your site very interesting and informative . Thanks for taking time sharing it with us. I really enjoyed reading your post.

    triciajoy.com

    www.triciajoy.com

    ReplyDelete
  6. I read your blog.I thought it was great.. Hope you have a great day. God bless.

    Rica
    www.imarksweb.org

    ReplyDelete

Share your comment here..