Friday, January 1, 2016

Keep Track of Your Link Parties

Ah, Link Parties. So much fun, such a good way to promote yourself, but so much work!



Are you new to blog parties? They are a great way to connect with other bloggers. When a website hosts a party, they allow you to add a link to your own blog post, which will then add a thumbnail photo and link back to your blog. Then everyone who comes to the party will see your thumbnail and can go straight to your blog post. It's like Pinterest but just for bloggers trying to make connections.

I love how many new ideas I've found from scrolling through the link party thumbnails. Also, a lot of the party hosts will feature their favorites from the week before. I'm amazed at the creativity and hard work that so many people put into their blogs.

Make sure you check the rules, since each party has their own set of rules. And I've always felt like there were some link party rules that everyone seems to know but never talks about. For more on that, check my post on Unwritten Link Party Rules, which also has a list of my personal favorite parties.

I've been blogging for just over a month, and already I know how difficult it is to find good parties, link up to them, and keep track of what you posted where!

After linking up just a couple of posts, I knew I needed something to help organize my posts and link parties. And what else would I do except build a spreadsheet?!

My Tracking Sheet

I built my tracking sheet with simplicity in mind. I wanted to just be able to click to add a check mark whenever I linked up to a party. I also wanted to be able to easily see when the parties go live, since it is so hard to remember all of them!

You can easily add or delete columns to fit however many blog parties you go to. For other tips and tricks, I recommend watching the video below.

You can download the full file here:

Link Party Tracking Sheet



  1. I recommend listing your posts with the oldest on top, and adding new posts as you publish them. But if you want to have newest on top, that would work fine, just insert new rows as you need them.
  2. I have this filled in with my favorite link parties in order of when they go live (as best I can tell). Some link parties claim to be a Tuesday party, for example, but they go live on Monday evening EST. I find it easier to display based on when I need to link up. Changing and adding new link parties is easy, but make sure to insert new columns within the day you want them.
  3. To add or remove a check, simply click the cell. This uses Visual Basic code, which is pretty advanced if you are new to Excel, so I'm not going to go into it. If you want to see the code, let me know.
  4. Just because I prefer to keep the file saved on my computer and use it there, does not mean you have to! I formatted the file so that you can print it and keep it in a binder or anywhere that works for you. Just be aware that I formatted it to print one day of link parties per page. If you have lots of parties (or maybe you have only a few), then you might want to reformat the page breaks. I also built in about 2000 rows, so if you just click print, you'll get nearly 200 pages! Tell Excel to only print the pages that you need. If you don't know how to do that, check out my post on How to Format Excel for Printing or send me an email!
I hope you find this file as helpful as I do. If you need help with it at all, please send me an email at excelathome.blogspot@gmail.com.

Good luck and have fun partying!

Mummy Do ItPhotobucketThis Is How We Roll Feature

68 comments:

  1. Love this post! I'm all about organizing to keep things simpler and trackable! Thanks for linking up to the Weekend Wind Down Link Party tonight! Happy New Year!!!

    ReplyDelete
    Replies
    1. Hi Danielle! I totally agree. I feel like I've been bit by the organization bug at the start of the year. Thanks for visiting!
      Megan

      Delete
  2. This is awesome! I love link parties but right now I just use the old pen & paper technique. I love your excel sheet and plan to start using it. Thanks so much for sharing! Visiting from the Weekend Wind Down
    xoxo
    Lisa @ Fun Money Mom

    ReplyDelete
    Replies
    1. I hope that my spreadsheet proves easier than pen and paper! :) I personally love it, but please let me know if you find anything confusing. Thanks for visiting, Lisa!
      Megan

      Delete
  3. Subscribing from Meet and Greet 12! Brilliant idea! And you've only been blogging a couple of months? I can use this either for link-ups or maybe modify it a bit and use it to make sure my reading challenge check-ins get posted where and when they need to!

    ReplyDelete
    Replies
    1. Hi LuAnn. It would absolutely work for your reading challenges. Let me know if you would like help modifying it. Thanks for stopping by!

      Delete
  4. Great tool. I discovered link-parties about two weeks ago, and dove right in. Yet, keeping track of everything isn't easy. Thanks for the tips. And it's great to connect--it just so happens that I'm here because I saw your post on one of these parties :) Thanks again for the organization tips. Wishing you an incredible 2016!

    ReplyDelete
    Replies
    1. Thanks, Jed. I agree that trying to keep track of parties can be a challenge. But I have found my spreadsheet to be super helpful. Good luck and have fun!

      Delete
  5. This is great. I just put them in my bookmarks (sorted by day) and do them twice a day. If I miss, I don't track it. (Is that totally unprofessional? Gah, I think it might be! Yikes.) Your way is much more professional. I bet you miss fewer opportunities than I do!

    ReplyDelete
    Replies
    1. Hi Giftie. I do still miss opportunities, but mostly due to my own personal schedule and not because I don't know which parties I've already joined. I hope this helps you keep better track in the future!

      Delete
  6. Hey hi, found your link via Janice of mostly blogging dot com. This is awesome, i am so going to benefit from your tutorials. Happy 2016 to you and all yours, Cheerios.

    ReplyDelete
    Replies
    1. Hi Mary, I'm glad you stopped by! I hope you find my tutorials helpful and please let me know if you have questions on anything. Happy New Year!
      Megan

      Delete
  7. Thanks so much for sharing your wonder tutorial. This is going to come in so handy, I've been needing a way to keep track of the link parties I join. Pinning! Thanks!

    ReplyDelete
    Replies
    1. I'm glad to help out as you try to get more organized. Thanks so much for stopping by and adding to Pinterest!

      Delete
  8. Hi Megan,
    I know LuAnne, Mary, and MixedCreations. Your site sounded so cool, I just had to see it. It is cool! I hope you promote it by advertising your linky party spreadsheet. Very cool.
    Janice

    ReplyDelete
    Replies
    1. Hi Janice! I'm so glad you stopped by and like what I've been doing. I'm clearly new to blogging (and the best ways to get my name out there) but love all the tips you have on your site. Keep the advice coming! And please let me know if there is anything I can do for you! :)

      Delete
  9. I used to do pen and paper and it was a mess! Now that I have a google doc (not as pretty as your excel sheet!) it's much more manageable! :)
    www.stayathomeyogi.com

    ReplyDelete
    Replies
    1. Good for you! A google doc is a great way to keep track. I hope my sheet gives you some new ideas.

      Delete
  10. Yes! I've been writing them down but my sheet is a mess!

    ReplyDelete
    Replies
    1. I know what you mean! My list was a disaster at first. I hope you like using my spreadsheet!

      Delete
  11. Great idea! I just joined a few linky parties so need to get myself organized.

    ReplyDelete
    Replies
    1. Hi Carolyn. Welcome to the wonderful world of link parties! Good luck finding your favorite parties and keeping them all straight!

      Delete
  12. Great idea!!! Thanks for sharing!!! #howweroll
    I host a link party on Thursdays at 7 am (just in case you need one more! HAHA!!!) http://www.akreativewhim.com/100-happy-days-12/

    ReplyDelete
    Replies
    1. Hi Kate! Thanks for stopping by and for the info on your link party. I will definitely add it to my list. I'm constantly adding/refining my favorite party list. Thanks!

      Delete
  13. Replies
    1. I'm so glad I could help. Good luck and have fun partying!

      Delete
  14. This is a great post. I was ill in 2014 and stopped linking to parties and now I am getting back into the swing of things. I am now co-hosting Share Your Cup Thursdays which actually goes live on Wednesday. I have to get my mind set around that.

    Thanks for Sharing Your Cup!

    ReplyDelete
    Replies
    1. Hi! I am constantly updating my parties as I find new ones and better learn when they go live. I just fixed Share Your Cup to show it as live on Wednesday at 7pm. How exciting for you to co-host it! Thanks for stopping by and good luck keeping track of your new parties in 2016!

      Delete
  15. This is super helpful! Thank you for sharing. I'm new to all of this and trying to figure out my link party strategy so having a place to write all of this down and organize it is fantastic

    ReplyDelete
    Replies
    1. Hi Nicole. I think it becomes obvious to anyone who wants to promote their blog that you have to have a strategy for your link parties. I hope my spreadsheet helps. Good luck!

      Delete
  16. Love this! I use Onenote for my Blog planning and I was able to add this spreadsheet to my notes. Can't wait to get started using it. Hopefully I can be more organized now and make these linky parties work better for me. Thanks :)

    ReplyDelete
    Replies
    1. Hi Catherine. I'm so glad you were able to add this spreadsheet and I hope it works well for you. Good luck trying to be more organized. It's something I'm always working on. :)

      Delete
  17. Thanks for this Megan. I can get a bit swamped with link parties, so I'm trying to do better this year! This was our most popular post at last week's Blog Fair, so make sure you pop over this week and grab a featured button!

    ReplyDelete
    Replies
    1. Thank you, Karen! I will definitely grab a button. I hope this helps you be more organized and thanks for the feature!

      Delete
  18. Such a great idea. Now I just need a little help to know how to edit. I have no excel experience. You look like the lady to go to!!! Thank you for sharing at the Faith Filled Parenting LinkUp.

    ReplyDelete
    Replies
    1. Hi tealea. Thanks for coming by. Editing is pretty easy, though I understand it can be daunting if you're new to Excel. Just download the file, click "Enable Editing" and then "Enable Content" (it will be right at the top). Then you type your post info and click under which party you joined. That easy! My video walks through the whole process if you're still confused.

      Delete
  19. I like your spreadsheet. I made one for myself in November but I may add a column to track what link parties I add posts to like you show. Good idea.

    ReplyDelete
    Replies
    1. Wow, that's the first time someone has told me they already made a spreadsheet. I find most people are afraid of Excel. :) Good luck with your file and your parties!

      Delete
  20. Great idea. Thanks for sharing this tool! I am new to blogging as well and this will be very helpful.

    ReplyDelete
    Replies
    1. Hi Carolyn. It's nice to meet another new blogger. Thanks for visiting and I hope my tracking sheet helps!

      Delete
  21. Very helpful thanks so much! Would love for you to share this at Celebrate Your Story!Link Party. We go live at 8am on Sundays. The collection is open for another three days. Link up at http://www.thesweetsensations.com. Hope to see you there!

    ReplyDelete
    Replies
    1. Thanks for the tip on your link party! I just added my post. I love finding new parties! Thanks for hosting and visiting my blog!

      Delete
  22. Well how smart is this!! Thanks for sharing at Home Sweet Home!

    ReplyDelete
  23. Great post! I'm new to blogging too, glad I'm not the only one :) Thanks for sharing!

    ReplyDelete
    Replies
    1. I'm learning that blogging takes lots of work and practice, so I love getting and sharing tips with newbies like me! Good luck!

      Delete
  24. I will feature this today at the Home Sweet Home party. I love how you have introduced this at the start of the year while we are all trying to get more organized. Lol! Me included! Thank you for sharing at HSH!

    ReplyDelete
  25. I will feature this today at the Home Sweet Home party. I love how you have introduced this at the start of the year while we are all trying to get more organized. Lol! Me included! Thank you for sharing at HSH!

    ReplyDelete
  26. I normally put my party on Thursday mostly at noon CT but, sometimes it may be as late as 3-4 pm if having a Dr.'s appt or something. That's why I never claim a time so it can be flexible. When I was new I always tried to find out the times (of link parties)so I could get my link on first! It does help!
    Sherry

    ReplyDelete
    Replies
    1. Hi Sherry! Thank you so much for the feature and the information about your link party. I try to refresh my blogs throughout the day, but it's nice to know approximately when they will go live so I can be ready. :) Thank you again!

      Delete
  27. Like some of the others, I kept records on paper. I hope I can learn your method.

    ReplyDelete
    Replies
    1. Pen and paper seems to have been popular, but I hope you like my method and that it works for you. Thanks for visiting!

      Delete
  28. Love how organized your Link Party Sheet is. Congrats on being featured this week on the #ThisIsHowWeRoll Link Party at Organized 31.

    ReplyDelete
    Replies
    1. Thanks, Susan, it has certainly helped me to be better organized and I hope it helps others, too! Thanks so much for the feature!

      Delete
  29. Such an amazing idea! SO helpful!!!

    ReplyDelete
    Replies
    1. Thanks, Cristina! I hope you find it helpful!

      Delete
  30. So helpful and useful. Thanks for sharing at mybusybeehives.com BEE PARTY!

    ReplyDelete
    Replies
    1. Thanks, Julie, I hope that people are able to use it and stay organized!

      Delete
  31. This comment has been removed by the author.

    ReplyDelete
  32. Very helpful! This is definitely something I will have to employ. Thank you for sharing at Link It Up Wednesday!

    ReplyDelete
  33. This is SO cool! I do a fair share of link parties and it would help to have someplace to list them all so I don't forget any of them!

    ReplyDelete
    Replies
    1. I don't know how anyone remembers which posts they've linked to which party without some kind of tracking sheet. I hope this one works for you. Thanks for visiting, LuAnn!

      Delete
  34. I needed this one for sure, thanks! Hope you schedule TADA! thursdays on yours...we have a few monthlies you may like as well :)

    ReplyDelete
    Replies
    1. I'm always updating my list, so I'll be sure to add TADA Thursdays. Thanks for visiting!

      Delete
  35. Megan this is a great way to organize them all!! I have tried to hand write them, but I always forget when they are or what I have linked up. Thank you very much for sharing this with us at TaDa Thursday!!

    ReplyDelete
    Replies
    1. If you want, you can print this list and still mark your parties by hand, but I love having a saved file that I can constantly update. Good luck organizing and thanks for visiting!

      Delete