Tag «blogging life»

SERIESous Tips: How I Track my Book Series in Excel

I’m highlighting some of the ways I use Excel to help my blogging productivity. Today, I’m sharing how I keep track of all the book series I have on the go!


Why I Keep Track of My Book Series Progress

Another spreadsheet I keep in my Books Read Workbook is my Series Tracking Spread. Because the bread and butter of my blog is book series, I needed something to help me keep track of all the series I had on the go and where I was in those series sequel-wise.

My first version of this spreadsheet was pretty basic. I basically just typed in things as I went and formatted along the way. But once I learned more about the drop-down boxes and conditional formatting features of Excel, it has made this spreadsheet super easy to maintain.

Series are sorted by the year I read the first series title. # TBR = number of books that have been published that I still need to read. Series Titles are listed with their position in the series. I also note when the sequels will be published; where I can access the title and if I have a blog post already made. Unknown status is for series that I suspect will have sequels but don’t have official publishing dates.

On this spreadsheet, I keep track of what series I have on the go, how many sequels I have to read, their publishing statuses, and the year that I started the series. I don’t track what year they were published in because I don’t really care for that.

From that information, I can get:

  • how many series I have on the go
  • how many series are waiting for sequels to be published
  • how many series I started in a particular year and have yet to finish
  • the total number of series I had on the go at the end of a calendar year

Why do I love using Excel for this spreadsheet instead of a Word document? It is super easy to add titles as sequels are announced by inserting new rows and letting the worksheet shift equations and entries automatically. A Word Document would still be great to use because you can add headings to quickly find a Series Name. But I like seeing my stats and having Excel automatically run those statistics as I add titles is the key.

This concludes my Excel Tips Series. I hope you found it interesting to read and perhaps I’ve inspired you to try some Excel Spreadsheets yourself! Let me know if there is anything else you’d like to see in the future.

How do you keep track of the book series you have on the go?

Excel Tips: Why I Love Excel  |  Post Calendar  |  Books I Read in a Year  |  Tracking Book Series

connect Twitter GoodReads Bloglovin' Amazon.ca Reviews RSS Email

catchphrase

Disclaimer | Request a Review | Contact

SERIESous Tips: How I Track my Reading in Excel

I’m highlighting some of the ways I use Excel to help my blogging productivity. Today, I’m sharing how I keep track of the books I read in a year!


How I Track My Reads for the Year

While I do keep track of everything I read on Goodreads, I like to keep a separate document for my own records of all the books I read in a year. I did this wayyyy before I started blogging and it’s a habit I’ve never stopped. But when I got into blogging, I started to get more interested in my reading statistics (like how many books I read in a month or how many audiobooks in a year) and I found Excel made things much easier to find out those statistics with very little effort (ie not counting all the books in my Goodreads Read list).

This is what my spreadsheet looks like:

The main data entry portion of my Reads in a Year Excel Spreadsheet.

In this spreadsheet, I keep track of all:

  • the book formats I read (ARC, audiobook, novella, book, rereads),
  • where I got the book from (library, hoopla, subscriptions, own)
  • what # it is in the series or if it is a standalone
  • when did I start that series sequel (last year, current year, completed all books in series)
  • how many books I read in a year, month and season
  • rating for the title

Thanks to the formula features in Excel, any stats I want to run on these values auto-calculate with the formulas I’ve created! Before I used to count up each line in my Word Document table and do the math with a calculator. So now it’s so easy for me to whip up stats anytime I need them for my blog posts because the spreadsheet does it for me!

Some of the stats that auto-calculate based on the main data entry of the spreadsheet

How I’ve Updated It Over the Years

My first Reads in a Year documents simply listed the books read within a seasons. Then it evolved to months and then eventually separating the titles out by their formats within a month.

I used to manually calculate the totals for each month by creating the formula every time but know I’ve learned how to name cells for calculations, allowing the worksheet to do the work for me, even if I add titles to the month after the fact.

When I started doing more analyses of my reading, I added columns for book sources, series tracking and eventually ratings. Only in the last year have I made the Series Tracking a drop-down menu instead of obscure text codes that would calculate in another part of the spreadsheet.

Do you only use Goodreads or another online service to track your annual reads? Or do you use something else? Let me know below!

Excel Tips: Why I Love Excel  |  Post Calendar  |  Books I Read in a Year  |  Tracking Book Series

connect Twitter GoodReads Bloglovin' Amazon.ca Reviews RSS Email

catchphrase

Disclaimer | Request a Review | Contact

SERIESous Tips: My Excel Post-Scheduling Calendar

I’m highlighting some of the ways I use Excel to help my blogging productivity. Today, I’m sharing my Blogging Calendar!


Why I Needed a Blogging Calendar

Back in the day when I first started using WordPress for my blog, the posting calendar wouldn’t tell you if a day already had a post scheduled. Which was a real pain for someone like me who schedules posts well in advance! (Now, WordPress does show you on the publish calendar upcoming posts but I like to know what the post is.)

The New WordPress Calendar indicates days with previously scheduled posts with a blue dot.

I tried a paper and pen method with a spare planner when I first started blogging, but I was constantly shuffling posts around for different deadlines so it wasn’t ideal to erase things all the time. I also tried Google Calendars but didn’t really like it because it felt like a lot of steps to add things. In the end, I had great success with a Word Calendar template and used this for years.

My Old Word Calendar

On this calendar, I kept track of all my ARC due dates, library book due dates and blog posting dates in a Word Document Calendar Template. Depending on what the items was, it was colour coded accordingly for quick glances:

Here’s what my old calendar looked like. Red text = library due dates | Blue text = ARC due dates | Black text = blog posts | Purple text = planned blog post | Crossed Out Text = Completed reads | Italic Text = renewed reads

This calendar was great and I used it for years with only a few colour changes over the years as my blogging and reading schedules evolved. Using a Word Template meant that the basics (table/month/dates) of the calendar were already formatted so it wasn’t a lot of work for me to set up intially.

Though for anyone who isn’t me, I’m sure this looks uber overwhelming and a lot of work. Eventually I came to the same conclusion: I found I was spending so much time formatting it–from adding new months to changing text colours by hand–that it became more cumbersome than helpful and I needed a change.

My New Excel Calendar

When I discovered how conditional formatting (rules for how data in cells should appear based on their values) worked in Excel for cells, I knew my next calendar had to be done as a spreadsheet. Using Excel meant I could create a system of rules to continuously format my data cells without me formatting each cell individually. Basically: I could type and go, letting the worksheet do the formatting for me. And once I found a template that worked, all I would have to do is copy the worksheet for additional months over and over again.

So, I found a generic Calendar Template in Excel that I could format to my liking and for what I needed it to do. I was able to have the program add the dates to the correct day of the week based on the Month I selected on the top. I added two rows for each date: one for reading due dates and another row for blog posts. I also created a button for to clear all scheduled posts without deleting each one. It took me some time and some trial and error with the formatting, but I finally found a master template that worked and this is what it looks like:

My New Excel Calendar. It features a Blog Row for Posts and a Due Row for ARCs and Library Book Due dates. Pale Yellow Boxes = Scheduled Posts | Bright Yellow Boxes = Theoretical Blog Posts | Red Boxes = To be Finalized Blog Posts | Light Blue Text = ARCs | Red Text = Library Book Due Date

My calendar tracks all the same due dates as my previous calendar. I’ve also included a pre-determined template so I know where I should be posting (since I do certain posts on specific days of the week). But the key is that I have a master formatting template that I can copy for every month that I need. Then, when I use it, all I have to do is enter in my text and the spreadsheet does all the formatting work for me! It honestly saves me a ton of time by just plugging and chugging as I go.

One of my favourite features of this calendar is that it can show me the scheduled blog posts from the last and/or the next month (dates in gray). That has saved me a few times from scheduling posts too close together since I can see it all on one screen.

When I’m done with a month, I just hide the tab from view. I’m not sure if I will delete the old tabs at the end of the year or not, I’m still deciding. But for now, I’m enjoying my simple calendar–even if it took a lot of work to find what I like!

How do you track your blog posts? Paper, digitally or wing it? Let me know below!

Excel Tips: Why I Love Excel  |  Post Calendar  |  Books I Read in a Year  |  Tracking Book Series

connect Twitter GoodReads Bloglovin' Amazon.ca Reviews RSS Email

catchphrase

Disclaimer | Request a Review | Contact

SERIESous Tips: Why you Need to Use Excel for Your Book Blog!

I know that lots of people love using a pen and paper to keep track of their books and blogging posts but I’m a digital girl. Way before I discovered Goodreads and even in the time since, I’ve always kept a list of the books I read in a Word document on my computer.

While I use a lot of other online tools–like Trello for blog posts in progress and Goodreads to track my reading dates–over the years, I’ve upgraded from my basic Word Documents to Excel Worksheets.

Just a note: I use Microsoft Excel simply because I have the program from my university days on my laptop; but I have used Google Sheets in the past too which is free if you have a Google account. It has very similar features and works in a similar way so it is a great option if you don’t have the Microsoft Office Suite.

I love reading my fellow bloggers posts about how they stay productive and so I thought that I would share how I do the same. Over the next few days, I’m going to share some more Tips posts about my experiences using Excel to help increase my blogging productivity and track my reading.

But in this post, I want to share some of the reasons why I love using Excel and how you can learn to love it to!

Don’t Be Intimated!

You don’t need to be an Excel Wizard to create a good spreadsheet! I really only knew the basic features of the program when I first started using it a few years ago. Honestly, my first spreadsheets were pretty simple and were really just me typing things into cells because it was easy to create tables in Excel than in Word.

It really has only been in the last year that I’ve learned a lot more about using Excel thanks to my job where I’ve started to use it more. I did take a basic Excel course through my library (for free!) but Google and Youtube make it super easy to teach yourself how to use Excel to its max potential. If you want to know how to do something, a quick Google search will usually do the trick!

Why I Love Using a Spreadsheet (or Two) for My Blog:

Easy to Format Cells

I’m a very visual person so I love colours in my agendas and calendars. Excel makes it super easy with its conditional formatting features to have cells or text change colours based on their contents. You can also create drop-down boxes with preset values which makes it easy to create tables for tracking things and updating them as needed.

The Worksheet’s page itself is very open unlike a Word Document. I like to think of it as a blank canvas that allows you to freely add text in any of the cells and then merge, move or erase anything you want.

An example of the conditional formatting you can apply to Excel cells

Calculate Statistics Automatically

Within an Excel cell, you can create formulas to calculate values or even create charts based on information you’ve entered. It’s a great feature for bloggers who want to see their progress at a quick glance once they’ve set up the equations. And you can really calculate anything you want in one way or another.

An example of a table that calculates stats for me based on entries to the main document table

Have Multiple Spreadsheets Within a File

I love that I can have multiple tabs within a single file! A lot of my spreadsheets are created for the year so it’s great that I can keep previous years within the same file to easily compare contents without having multiple files open at one time.

Lots of Templates To Play With!

From budgets to calendars and more, the beauty of Excel is that you can create whatever you want and need in a workbook!

Examples of Spreadsheets I Have Used for My Blog:

Here are some of the ways I’ve used Excel spreadsheets in the past and present:

Stay tuned for future tips posts where I share my Posting Calendar, Annual Reading Lists and Series Tracking spreadsheets!

Do you use spreadsheets for your blog? Let me know below!

Excel Tips: Why I Love Excel  |  Post Calendar  |  Books I Read in a Year  |  Tracking Book Series

connect Twitter GoodReads Bloglovin' Amazon.ca Reviews RSS Email

catchphrase

Disclaimer | Request a Review | Contact

SERIESous Discussion: Getting my Blogging Mojo Back

Getting my Blogging Mojo Back

SERIESous Discussions: Every once and awhile I will post my random ramblings about a bookish or blogging topic. Feel free to join in by making a comment below or linking back!


I started this blog in April 2013 and that seems absolutely bonkers to me! I can’t believe it has been that long!

I’ve done and experienced a lot in those 8 years. I moved my blog to a self-hosted site (and contemplated moving back to a free site); changed my review format and posting schedule; I started reviewing ARCs; did some blog tours… In that time, people I started blogging with years ago have either changed their blogs to suit other interests/hobbies or have just stopped posting altogether.

I can understand that last part a lot. It can be hard to come up with fresh content all the time. One of the nice things about being a book reviewer is that your posts come from the content (books) you read on a regular basis. I don’t have to travel somewhere exotic or chronical my daily life (which is not that exciting). I can stay home, read and volia! A post for my blog!

(We all know it is a little more complex than that simple statement.)

But, that can become monotonous after awhile. Sometimes I feel like I say the same things over and over again in reviews. Other times, I’m in a reading funk and my source of content just isn’t there. In the last 3 years, every time my self-hosting comes up for renewal, I contemplate if I’m still interesting in keeping my blog self-hosted. Perhaps going back to a free site is best for the number of times I blog…but I end up paying my dues and pressing on because I still love to blog and promote books I love. (And moving my site back seems like a big chore)

I’ve only ever gone on one other hiatus in my blogging career and that was in the fall of 2013 when I had a tough academic semester in university and stepped away to focus on school. Otherwise, I’ve always had enough content to keep posting months ahead of schedule so I didn’t need to write posts all the time but could still generate content for my blog.

Until the COVID-19 pandemic hit in March 2020.

I explain more about why this was a particularly rough time for my reading with my How I Fell in Love With Reading Again post last month. The gist is: I work in healthcare and my attention span just couldn’t focus on books to finish them. So while I wanted to write posts for my blog (because I found I physically had to do something), I didn’t always have the content for my blog.

For the next few months I’d go through blogging sprees and managed to schedule posts up until mid-April 2021. However, from about November 2020 to June 2021, I didn’t log into my blog at all except to write my Year in Review Summary and my Reading Plan for 2021.

My hiatus wasn’t something I consciously thought about. It’s just something that happened as my area of Canada went into a 3rd, more intense wave of COVID-19 and work once again consumed me. Netflix became my go-to stress relief. (I also had some issues with my site hosting)

Eventually, I got back into reading around May 2021, which I detail in that previous post about How I Fell Back in Love With Reading. I gave myself the rest of that month to really focus on my reading and told myself I would come up with a plan for blogging in June/July 2021 once I was satisfied with my reading progress.

Here’s How I Got my Blogging Mojo Back:

1. Using my Bullet Journal

I first brought up the idea of a bullet journal in my Reading Plan for 2021 as a way to keep myself accountable for my reading habits. And it has really worked for building up a lot of healthy lifestyle habits and routines thanks to its flexibility to be tailor-made to whatever you need it to be.

I created a habit tracker and give myself a point every time I log into the blog. I aim to login to my blog 3 times a week. Sometimes I set specific days, other times I just go with the flow. Now, it doesn’t have to be just writing reviews to get a point; cross posting reviews or updating my series spreadsheet also gets a point. While I don’t reward myself with something physical every time I get a point, just seeing that tick makes me feel like I accomplished something I set out to do.

2. Hone in on the Backlog

At first, I couldn’t remember what reviews I had written for my blog and which ones needed to be drafted. I’m a Type A person so I get excited by creating lists and that’s what I did for the first two weeks of my “get into blogging again” mission. I had a list of tasks that I set out to do:

  • Update my personal Excel “Books Read” tracking sheet with the titles on Goodreads
  • Focus on ARCs that had been read in the last few months
    • Create posts and cross-post if overdue
  • Go through books read and see if review posts have been drafted or not
  • Update Trello (how I keep track of review posts) with reviews that:
    • Needed to be Written
    • Needed Sequels Read to Complete
    • ARC due dates

I would work on these a little bit at a time, often getting really focused on one task a day before moving to the next.

3. Create a New Posting Template & Due Dates Tracker

One of the reasons it took me a while to get back into blogging was that my main blogging laptop suddenly crashed and I lost all my files. I keep my posting templates, blogging schedule, common book themes, books read spreadsheet and more as Word documents on my laptop. So I was really at a loss there for a bit but I was able to recover the files and reinstall Windows so I could use my documents once again.

From my professional job, I’ve really become obsessed with Microsoft Excel. I always appreciated the program but after learning more about what it can do (and taking a certificate course in it), I loved its potential for maximizing my efficiency when it came to formatting an all in one calendar for my blogging life.

Now, I have an Excel Workbook that is super easy to maintain and incredibly easy to read thanks to some customize formatting (lots of colours!) and keeps track of everything I need when it comes to library due dates, ARC due dates and posting schedule. I’ll share what it looks like in a future post!

4. Focusing on Different Aspects Depending on my Mood

I’m a mood reader so it shouldn’t be a surprise that I’m also a bit of a mood writer for my blog. If I’m really inspired to write a post or a review that day, that’s what I do. If I don’t feel like that, I’ll do something else for my blog: like cross post old reviews to Goodreads or Amazon; or create a brand new Series tracking sheet.

Just doing these tasks a little bit at a time helps me feel productive. I find that if I force myself to write a review post, I don’t enjoy it which in turn creates animosity–not what I want to do at all. If I don’t feel like doing anything or don’t have the time, then I don’t. Every little bit helps in the long run, even if it isn’t directly writing the review.

5. Scheduling Posts

One of the biggest lessons I learned for my personal blogging (in the last 8 years) is that I don’t need to post every single day. (Kudos to those that do!). Because of the nature of my blog, I condense the reviews of 2+ books into one single post, whereas some bloggers would post individual reviews of each book. That means I reduce the number of posts I can write in a month. So in order to keep content generating, I schedule posts way in advance.

I created a generic monthly template for how I want my blog posts to be scheduled within a month. Because I have certain features for specific days of the week, I find planning those posts out in advance keeps things fresh and stops me from posting 30 “Fresh Friday” posts in a month and keeps posting content spaced out.

But what scheduling also does is give me breathing room if I can’t log into my blog for some reason. Because I work shift work, I don’t always have the time to login to my blog. But because I usually have posts scheduled 1-2 months in advance, I don’t have to worry that I need to finish a post by tomorrow. Chances are, that post was written a month ago and the post I’m currently working on can be finish sometime in the next 2 weeks stress-free.

Moving Forward

Right now, my returning blog mojo is pretty self-centered. I’ve been focused on my content and I haven’t been exploring the blogosphere like I used to. That one really hit close to home when I was browsing my library’s new additions and realized that I knew nothing about the titles that have been released in the last year or weren’t written by an author I am already familiar with. By the fall, I hope to be blog hopping once again!

Overall, I’m just taking this all day by day and not putting any pressure on myself. It feels good to write again and get those creative juices flowing.

How has the last year affected your blogging habits?

Let me know in the comments below!

connect Twitter GoodReadsBloglovin' Amazon.ca Reviews RSS Email

catchphrase

Disclaimer | Request a Review | Contact

Still Here!

It has been a long time since I posted anything. In fact, it has been even longer since I logged into my blog to check up on it! I don’t think I’ve spent this much time away from it except in my first year when I took a brief hiatus for university.

But, I’m still here!

The truth is, this last year has been really rough in a lot of ways for me (and many others I’m sure). I work in the laboratory of a hospital and while I don’t live in a “hotspot” COVID-19 area, we had our fair share of outbreaks and waves in the last 15 months. Medical Laboratory Professionals are in short supply–and have been for a long time, even before the pandemic. So the stresses of work bleed into my reading and blogging habits.

Add to that some professional courses I am taking for work, my laptop crashing and some other life stresses, time has gotten away from me. I also had some issues with my blog hosting in April so the only thing that really got posted this year was reviews I had scheduled months in advance.

Taking a step back from both reading and blogging has allowed me to reflect on what I get out of both.

Even before the pandemic started, blogging was starting to feel like a bit of a chore. I had contemplated moving my blog away from its self-hosted status for the last 2 years but the hassle never seemed to be worth the very little I spend a month to keep it self-hosted. I just find with my shift-work, I’m forever playing catch-up with things around the house or life in general so blogging is that last thing on my mind.

Also, I just don’t seem to be reading as much as I usually do. It seems crazy to me in a world where people are encouraged to stay home that I struggle to read but I find my attention span just wanders when I pick up a book (or I just fall asleep too fast) so it takes me twice as long to finish a book than it used to. Which, in turn, generates less content for my blog — which can make creating content feel like a chore.

But I still love to read. The last two months have been a cycle of reading and reviewing titles for the various ARC teams I am on and I love contributing to that release and getting the titles I love out there.

And now that the weather is nicer in Canada; my backyard is in its prime; and my pool is ready to go, I’m hoping to spend some of my upcoming staycation in my yard, reading copious amounts of books. Mostly to catch-up on titles I’m a little behind on but also because I really miss getting lost in a book for hours.

I started a bullet journal this year–mostly to keep track of my distance ed courses–and while I’m not always the best about checking-in every day, I really do love the daily habit tracker page I created. Every month I set a knew goal and my hope for July is to get back into blogging on a semi-regular basis. Even if it is just for an hour once a week—I think it would go a long way.

So, I just wanted to write this (semi-)short message to say: I’m still here! I’m just super behind but I will be resuming my efforts to get this blog back up to its normal (ok, maybe a little slower) speed this summer.

Thanks for sticking around and let me know what you have been up to the last few months by dropping a comment below!

Cheers!

~Lauren

SERIESous Discussion: A 3 Year Reflection on Self-Hosting my Blog

I was recently updating the various guides I have on the blog and one of them is my Self-Hosting Guide. And as I was going through it, I realized I’ve been self-hosting my blog since February 2016…

That’s more than 3 years!

It was a big decision for me to go self-hosted back then. It took a lot of time and research; I talked to a lot of fellow bloggers as well. My experience prompted me to compile a guide to help others make the decision (or not to).

For the last 2 years in February, I contemplate whether or not I want to remain self-hosted as my renewal notice comes. I think when money is involved, you always get a little hesitant and take a little extra time to think your decision over. And of course, life changes from year to year so there are many factors at play.

So where do I stand as I enter Year 4?

I seriously considered not renewing my hosting this year for a variety of reasons.

 (1) The Cost to the Usage Ratio

When I started blogging, I was working on my blog everyday but that certainly isn’t the case anymore. I was a student back in university and I had a lot of downtime (and it served as a good stress reliever). Skip ahead a few years to 2018 and there were times where I didn’t touch my blog for days (let alone a book!). It’s a stat that seems unbelievable to me because in theory, I should have more free time since all I do now is work (no school). But it’s my reality so I started to ponder if I was getting enough value from my self-hosted blog ($$) when I have the option to return my free site.

I pay for my domain name annually in November and hosting is paid annually in February. I don’t mind paying for my domain every year because I like the shorter, easy to remember domain. It costs me $13 USD a year but I use my earnings from Branded Surveys (referral link) to pay for it. My hosting costs work out to $10 USD a month which I think isn’t very expensive for a hobby you enjoy and (usually) do multiple times a week. And considering I don’t buy a lot of books (I use my library for the most part or participate in promotional opportunities), I don’t have a lot of other associated costs with my blogging/reading. Even better, I use my earnings from Swagbucks (referral link) for PayPal giftcards and use that to pay for part of my self-hosting invoice so it really doesn’t cost me that much in hindsight.

While I do work more now (and shift work to boot), I no longer have to commute (2 hrs) to work everyday so I have more free time on my hands to spend blogging and reading–and I hope that will be the case shortly.

 (2) Customization

One of the biggest draws to going self-hosted in the first place was the ability to do more with the design of my blog. While the free themes on WordPress.com are great, I wanted more flexibility with colours, feeds and plug-ins and only a self-hosted site could do that for me.

I love my theme and I don’t feel the itching need to change it like I did before on my WordPress.com site. Though I had found a theme for my wordpress.com blog just before I made the switch so I know I could find something that works if need be.

The plugins have been a great addition as well; though I’ll be the first to admit that I probably don’t use them as much as I should. They can be tricky too since they often have limited features until you purchase the premium version; they might not work with your theme; or, I can’t find exactly what I am looking for. While some save me lots of time, others require some troubleshooting that I don’t always have the time to execute.

>> SERIESous Tips: My Favourite WordPress Plugins

(3) Do I Still Enjoy Blogging?

I wrote about this sentiment in my Monthly Inventory: December 2018 edition where adulting seems to have transformed my blogging and reading experience in that last year. But my so-so feelings about the last year and the fact that I have to renew my hosting for another full year made me start to question my blogging experience and if it is something I want to continue going forward.

Perhaps it’s just part of the reflective nature of the new year and new resolutions, but it’s something I often ponder around this time of year. Of course I would still read and I’d probably continue reviewing on Goodreads; but the appeal to have no commitments to regular posting and promotional deadlines is enticing.

My Final Decision?

In April, I’ll be celebrating 6 years of blogging! I can’t believe it myself…but if there is anything I’ve learned about blogging in that time: you can make this experience whatever you want it to be.

I’m having no problem churning out content on a regular basis even if my reading doesn’t always reflect that. Yes, sometimes writing those posts feel like a chore because I get behind, but I still love sharing my thoughts on what I read. I have enough posts scheduled that I have some buffer time before I need to panic about not having enough content; and even then, I can reduce how many times I post in a week. Flexibility is key and I definitely have the ability to execute that.

Another big resolution: I also plan on reducing the number of promotional opportunities I undertake this year. I love promoting all the books I request but I’m at the stage in my blogging career where less is more. And I hope that by reducing those deadlines, I can take a lighter approach to blogging and reading.

So in the end? I’ve decided to renew my self-hosting for another year. While January has been a dicey month, I’m hoping the rest of the year will be smoother in all things.


Check out my mini-guide to self-hosting complete with help links!

Check it out here:

selfhost


What are your thoughts on Self-Hosting?

connect Twitter GoodReads Riffle Bloglovin' Google Plus Amazon.ca Reviews RSS Email

catchphrase

Disclaimer | Request a Review | Contact

SERIESous Tips: Post Templates

I have a set way I like my posts to look.

I knew very early on when I created my blog that I liked my posts to look uniform. I didn’t want my readers to have to search for the details throughout the post or have to read a different format all the time. While my blog is a blog, I’ve always viewed it as a bit of an archive for series reviews so people can use it as a resource for all their book series needs. Which is why consistency is a huge thing for me.

Of course, over the years my blog has changed its formats. Series reviews used to be big chunks of text where I described what I liked about each installment in different paragraphs. Now, they are broken up into various component subheadings to provide more of an overview. The stats about each novel (like publishing date, author, etc) now appear at the top of the post, as does the book’s synopsis. I’ve also included new graphics along the way and updated the colours scheme.

Writing blog posts can take a long time; especially book ones!

You’ve got to include book images, synopsis and stats; and if you’re doing a blog tour, there are certain aspects you have to add as well. So how do you make sure you include everything in your posts?

Answer: Templates.

I started creating and using templates back when my blog was still on the free WordPress.com platform but I continue to use them even now that I’ve become self-hosted because they are so easy!

I know that self-hosted blogs have various plug-ins to help you blog faster–especially ones that import from sites like Goodreads–but I have a certain look I like and I just find it easier to add the details myself.

>> SERIESous Tips: My 5 Favourite WordPress Plugins

Which is why I use a Word Document to keep and create my master post templates. I do have my basic templates as a saved draft on my blog for when I don’t have access to Word, but the master copy is a Word Document. I use Word for a variety of reasons:

  1. I can create Headings that make it easy to jump to a particular template
  2. I can access the document without WiFi
  3. I can access the document anywhere via my OneDrive Cloud
  4. It keeps things in HTML format
    • There is a setting to make sure the ” ” marks are correct so be aware!
  5. It’s easy to Find and Replace things in bulk
    • Perfect for updating annually!

Here’s an example of the template I use for my standard Series Review posts:

A portion of my Book Series Review Template.

Everything is written in its HTML code so all I have to do is paste the full template into the “Text” section of the WordPress processor (I’m not sure how other blogging platforms work but that’s the HTML coding section for WordPress). It includes all the styling I want (like heading styles or if the text is italicized); image placeholders for covers; review heading images; and also includes the default internal links I use. Anything that needs to be customized to the specific post is written in CAPS so that it is easy to spot within the code or if I am looking on the “Visual” page (the post builder that shows what the HTML looks like).

Once the template it in, I just build everything accordingly!

I also use Word templates for other, everyday things I do/use on my blog including:

  1. Code for updated reviews
  2. Review Conclusions
  3. Subheadings for DNF or Nonfiction Reviews
  4. Text Disclaimers for Cross Posting on External Sites (source is author/Netgalley/etc)
  5. Disclaimers for conversions of reviews (formerly a post about first book…)
  6. Netgalley Notes to the publisher (when blog post is released; cross post to other sites)
  7. Reading Challenges

Everything is in that one Word Doc with the appropriate heading so I never have to search for it. I’ve shrunk every template to a single page to make for an easier select and copy. And while I compose my posts, I often have my template document on my second screen (I have a second monitor attached to my laptop) so that I don’t have to minimize and maximize the windows all the time. It makes it easy to move back and forth.

I also have template documents for my Series Recap pages and custom HTML codes for plug-ins that get updates and change.

Why do I love Templates?

Templates are great for a forgetful person like me. I never have to worry if I’m forgetting to add something to my Blog Tour posts (though I do use checklists in Trello as a double-check) or if my end signature is included.

It also saves me a ton of time because I don’t have to code/format everything from scratch every time. Instead, I just put the bones of my post down and fill in what needs to be filled. And by making it obvious what I need to fill in, it’s great for creating drafts that I will be finishing later on.

Do you use templates for creating your blog posts? What tips do you have to share?

connect Twitter GoodReads Riffle Bloglovin' Google Plus Amazon.ca Reviews RSS Email

catchphrase

Disclaimer | Request a Review | Contact

SERIESous Tips: Book Blogging When on Vacation

Finding the right balance between relaxing and being productive while on vacation isn’t always easy.

I’m a huge fan of travelling. I love exploring the world and experiencing new adventures. I’ve been very fortunate to see so many things over the last few years and I always try to go some place new every year.

I do a lot of prep before I go on a trip. Of course I do all the stuff pertinent to my trip (like packing clothes and printing itineraries) but I also get my reading and blogging habits in order as well.

>> SERIESous Tips: Picking the Perfect Travel Read!

My Philosophy:

I didn’t travel across the world (or wherever) do to things I do at home. I want to embrace everything about the place I’m travelling to and that means busy itineraries in order to see everything that I can. I travel with the philosophy that I might never return to that place and I never want to regret not doing something.

So that means I won’t be spending hours blogging or reading like I would at home. Sure, I do that stuff in my downtime or while en route to a new location while away; but I don’t plan for me to have those moments during my trip. If I do manage to get some stuff done it’s a bonus.

Basically, my blog gets neglected in the sense I’m not visiting daily while travelling but I do think about it and my content while I’m away.

Here are some of the things I do before and during my vacation to keep up with my blog’s content and reviews:

Scheduling Posts

I schedule all the posts on my blog well in advance of their posting dates. I’ve been doing this since my first year of blogging and it has paid off immensely. As I write this (February 2018), I have posts scheduled well into October 2018! (And at the time that this is published in October 2018, I have posts scheduled well into April 2019). That means I can leave my blog for a few days and not worry about posting new content on a regular basis (or getting internet access to do so). You probably didn’t even know I was away because I had been posting regularly 😉

Learn More: Scheduling Blog Posts |  How to Start Scheduling Posts

So of course, I recommend that you schedule some planned posts while away on vacation. Sure, they can be reviews but I recommend special content like tags or memes instead. This is the stuff that isn’t necessarily date specific and you can write well in advance and keep in your draft folder until you need them. It will require a bit of planning and time on your end to write some extra posts but you’ll thank yourself later when you find out you won’t have the time to hit “publish” while away.

Access to my Schedule via OneDrive

I keep track of all the book deadlines I have as well as my blog’s posting schedule in one Word Document. If anyone but me opened that document, they’d probably be confused out of their minds but it makes sense to me!

>>SERIESous Tips: Keeping Organized

OneDrive is basically a cloud for Microsoft products–it’s like DropBox or Google Drive. Now that I’m no longer in school, I don’t use it as much but I still use it for my blog. In it, I have my blogging templates, common book themes, book summaries/recaps, and my master schedule. It syncs anytime I have internet to any of my devices and I can also access it via the web. I can even access the documents offline on my phone if I need to.

My point here is that I like having my Master Book/Blog schedule handy so that I know what books to read and when. Can I start a random book or do I need to read something else for review purposes? Having that document handy wherever I go has really helped me be more productive when it comes to reading both before and during my trip.

I do have post templates saved as draft posts on the blog as well but the master/most-up-to-date file is the Word document.

Avoid Deadlines / Posting Commitments

Most of the time, you know well in advance when you are going to be on an extended vacation. Sometimes you don’t but that’s ok. My point here is make sure you don’t schedule yourself for any blog tours or promotional posts while you are away. I make sure to keep track of all tours/ARCs I’ve requested so I have a general idea of what I might be committed to reading and posting in the future.

>>SERIESous Tips: Keeping Organized — ARCS

Not only will you create pressure for yourself by creating a deadline to read something but you might find yourself in a bit of a pickle in terms of content. While most blogging tour groups provide you the necessary media and such a week in advance of a tour, some don’t! So take that into consideration before you hit request–especially if your time and/or internet connection is up in the air! You might not be able to fulfill your reviewer obligations and that may dampen future opportunities.

>>Discussion: Lessons Learned from Doing Blog Tours

Jot Down Reviews/Thoughts After Finishing a Novel

One of the biggest factors in terms of blog maintenance is my internet connection. I don’t always have one wherever I go or one readily available at all times. That means I can’t access my blog or even the Goodreads App on my phone. In the last two years, I’ve come to rely heavily on the Goodreads App to jot down some of my thoughts after finishing a novel so I have a base to create my review. But without an internet connection, I can’t really do that.

What I started doing was using my Note App on my phone and writing my thoughts there. I’d mark my start and end dates; write some common themes; note some similar reads; and write my full review. Basically, I’d do everything I normally would do in a post just without the HTML and the book’s metadata. Then, I send that to myself via email when I return home or have internet connection and copy and paste into my templates.

When I came back from my trip in February, I had 7 reviews to write. Normally this would take me hours and I would be pulling my hair out because I wouldn’t remember everything about the books I read. However, thanks to my notes, I was able to churn out reviews like a boss. All I had to do was paste in my thoughts (tweak them a little but not much) and format the post accordingly. What should have taken me a full day only took 2 hours! Amazing!

Keeping Up With Emails / Requests

I don’t get a lot of emails pertaining to my blog but I do subscribe to a lot of email lists for blog tours, book deals and author newsletters. I never realized how many until I didn’t check my Gmail account for a few days and found my inbox stuffed!

One of the nice things about Gmail is that you can separate your inbox into 4 folders that emails are automatically filtered into upon arrival. I’ve sorted mine like this:

  • Primary: Publishing contacts; request submissions on my blog; other
  • Social: commenting feeds; Bloglovin’; Hellobar updates
  • Promotions: author newsletters; book deals; giveaways; Netgalley
  • Updates: blog tour lists; review opportunity lists

I’ve found that this helps me tackle my inbox when I have to go through lots of emails. First, I glance through and delete anything that has “expired” (ex. deals for a specific day). Then I go through and swipe my way through all the emails and star anything that needs follow-up. Then I do a massive delete and work my way through the ones that need my attention.

I have a plug-in for Gmail called Boomerang which lets me pause my inbox (though I’ve never used it). I also use that plug-in to schedule emails to send out. This is especially helpful when I have some review opportunity follow-ups that require the emailed links when the post goes live.

Creating a Worklist via Trello

I’ve praised this online tool before but I wanted to share how I use it while I’m away. The great thing about Trello is that you can use it offline. I’ve got it on my phone so I can create review cards and file them accordingly offline and they will be synced when I get an internet connection. That way, I have a worklist of sorts to complete when I return and I know what I need to do for my blog.

>>SERIESous Tips: Using Trello to Keep Track of Reviews


I hope you found some of my tips and tricks helpful!

What do you do while away on vacation when it comes to reading and blogging?

connect Twitter GoodReads Riffle Bloglovin' Google Plus Amazon.ca Reviews RSS Email

catchphrase

Disclaimer | Request a Review | Contact

SERIESous Tips: Cross Posting Reviews

To Cross Post or Not to Cross Post, isn’t that the question?

 

In my early days, I used Goodreads a lot to discover new blogs to follow. That’s how I found out that book blogging was a thing actually. So I always made an effort to at least mention my blog somewhere in my review and give a link back just to get the word out once I started blogging.

But actually cross posting? Like many blogging/reviewing things, it was something I never really thought about until I started doing review copies on a regular basis. It was always “encouraged” that you posted your review on book buying sites and Goodreads in addition to your blog post to help get the word out. Makes sense right? That’s why I started to be more proactive and conscientious about it.

Does cross posting work?

I think from a publisher/author point of view it does. When buying books I think people like to see ratings and reviews before making the decision. More reviews means more people who have read and likely enjoyed the title, thereby increasing the chances that the purchaser will actually buy it. I know I glance at the reviews before deciding a book is worth the investment of my money to see if it will be enjoyable.

As a blogger, I’ll be honest and say that very (and I mean very) few of the “referrals” to my site are from Goodreads. I get more hits from search engines and blog tour participation links than anything else in the grand scheme of things. In other words: it doesn’t increase the traffic to my blog.

That being said, I still make an effort to cross post my reviews on a regular basis because I believe that the exposure (for both the book and my blog) is important. I mean those few hits linking readers to my site still got people to my site!

What Do my Cross Posted Reviews Look Like?

I think this is the biggest thing people struggle with. Do you post your full blog post? Do you just show off the highlights? Do you simply leave a link to your blog?

Given the format of my reviews (series reviews meaning multiple books generalized within separate headings), I’ve never** posted my full blog post on third party sites. It just doesn’t look nice and it doesn’t always work as an individual review. So I usually leave condensed reviews on Goodreads. Usually these reviews are just a few sentences describing my initial thoughts after reading the novel and marking the book as “finished” on Goodreads.

The other reason I do condensed reviews is because of something I read in a Goodreads 101 blog post by Brittany @ Book Bumblings. In that guide, she emphasized the idea of “repurposing” your reviews on Goodreads in an attempt to drive readers to your blog. The idea is that the shorter post will catch the attention of Goodreads users and it leaves people wanting more so they will hopefully visit your blog. Again, I don’t think this has really worked for me (if you look at my referral numbers), but I like to hope my shorter reviews and links appeal to people enough to visit my blog for more or at to least see what else I’ve reviewed.

>> I don’t know about you but I love having the reviews of my friends on Goodreads when I look up a book title. I often look at those reviews to see if it’s a book I’ll like or to see how others felt about it once I finish reading. That’s why I make an effort to post on Goodreads no matter what because I find those reviews (no matter their length) to be extremely helpful!

**The only exception to this condensed rule is for review copies. Because I’ve been asked to write a review, I try to make it as full as possible for Goodreads and book retail sites. If the book I’m reading is a sequel for a review on my site, I often post a condensed version on my own blog instead in the hopes of reducing spoilers but use the full review everywhere else.

>> Tips: How I Use Trello to Keep Track of Cross Posting Reviews

When do I Cross Post?

For a little while, I tried my hardest to cross post all my previously published blog reviews on sites. But after seeing it didn’t have a huge impact on my stats and discovering how much time it took up, I stopped with my backlisted reviews.

Now, as soon as I publish a review on my blog, I cross post it on all the sites so I don’t have to dedicate hours of time to a cross posting blitz in the future! If it’s a review copy, I cross post to all the sites on release day or the due date.

Where do I Cross Post?

When it comes to cross posting, my methods for posting my review vary depending on the site. So I thought it would be easier to break it down by website and explain what I do and why.

The only one I didn’t explain was Netgalley since that is just you submitting your review (which is the same as my Goodreads one minus the HTML portions) and the links to your cross posted reviews.

Goodreads

What I Cross Post: All reviews regardless of source
How I Cross-Post: Full reviews for ARCs and Owned reads; mini reviews for others & sequels; links to blog

Posting on Goodreads is a little complicated for me given the nature of my blog. You see, because my blog posts are usually one review for an entire series, I don’t often have individual reviews for each book in that series.

One way I’ve attempted to solve that problem is by writing a mini review of my thoughts after finishing every book I read. That way, I’ve got a few lines I can use as a base for sequel reviews and add my links to read the series review on my blog. For inaugural novels, I pick and choose lines from my series review and put them together for a little fuller review (without spoilers of course).

The only exception is when I review ARCs. I always write full reviews because that’s what I got the book for!

When do I Cross Post: As I submit my ARC review on Netgalley; when blog post goes live

I always follow the publishers/providers guideline for posting reviews. If they don’t want that review going live until two weeks before publication, I follow that. Otherwise, it’s as soon as my blog post goes live (or within 48 hours of it).

Riffle Reads & LibraryThing

What I Cross Post: All reviews regardless of source
How I Cross-Post: copy and paste the review’s HTML code from Goodreads review directly to site
When do I Cross Post: As I submit my ARC review on Netgalley; when Goodreads review is live

Riffle Reads is a site very much like Goodreads though it has a smaller user base and community. It doesn’t have a ton of bloggers on there yet so I make an effort to leave reviews for anything that I can so people can learn more. Thankfully, it follows the same coding scheme (for the most part; it doesn’t do images) as Goodreads so I simply copy and paste my Goodreads review when it goes live.

I do the same thing for the site LibraryThing. I just joined that this year but it’s a site similar to Goodreads and Riffle Reads. They have an Early Reviewers program that does look at your review postings so I make an effort to put my reviews there as well. I was also able to import all my Goodreads reviews when I joined the site so that helped immensely.

Amazon.com (Amazon.ca)

What I Cross Post: ARCs & Owned Kindle Titles

Amazon is a bit of a stickler for reviews. They have a pretty rigid review policy so I try to be conscientious of that when I post reviews. I know from some of the review groups I belong to that they will take down your reviews if they don’t comply with terms. So, I make it a point to only add reviews for titles I’ve received for review purposes as well as titles I’ve purchased for my Kindle in order to keep the reviews “legitimate” in Amazon’s eyes.

How I Cross-Post: copy and paste Goodreads review with unique disclaimer

Basically, I remove all the HTML from my Goodreads review (you can’t have links to your blog in an Amazon review which is what my HTML portions are) and post the text. I then add a disclaimer that multiple authors/publishers have told me to use at the bottom of my review. In case you’re curious, here is the disclaimer I use:

**I received an ARC/review copy of this book and this is my voluntary review.**

When do I Cross Post: As I submit my ARC review on Netgalley or when book is published or blog post is live

If I finish my review before the book is published I have to wait to add my Amazon review. Once the book is live, I make sure I go back and post my review. I also add my Amazon link to my Netgalley review (even if I’ve already submitted it) to show that I have actually cross-posted for the publisher as I mentioned I would in my notes upon my submission. Otherwise, I wait until my blog post is live and cross post to Amazon when I post to the other third party sites.

Kobo Books

I rarely cross post on Kobo anymore. Only if it’s a review copy and it has been requested that I do so by the provider do I make the effort. I own a lot of Kobo books so I always rate them when I’m finished but it isn’t linked with my blog so I never write full reviews for them. I find Kobo doesn’t have the easiest reviewing system for someone like me who is posting a lot and so I don’t do it.

Audible

What I Cross Post: All audiobooks provided via Audible
How I Cross-Post: copy and paste Amazon review with unique disclaimer
When do I Cross Post: when my Amazon Review is live

Audible has a great way of providing copies for review purposes. So when I review most audiobooks, I get them via Audible with a special gift code to add the book to my library for free. That way I’m able to review the copy as if I owned it. Audible also has a prompted review option (with headings you answer to) but I always do the freestyle review box and paste my Amazon review.

Twitter

What I Cross Post: All reviews regardless of source; blog posts
How I Cross-Post: built in tweet option on WordPress; tweet archived-post plug-in
When do I Cross Post: new posts are published; updated series reviews; daily archive throwbacks

This isn’t something I consciously do thanks to plugins that make the whole thing automatic. That being said, you can definitely use platforms like Tweetdeck to schedule tweets for promotional purposes if you don’t have a WordPress.org blog.

Barnes & Noble, iTunes, Google Play and Other Retailers

We don’t have Barnes & Noble in Canada (we have Indigo-Chapters) so I don’t see the point in my posting there as a Canadian. As for the other retailers, I don’t use their sites so it’s not of any benefit to me unless I’ve been asked to by a publisher/ARC provider.


Do you have any tips for cross-posting reviews?

connect Twitter GoodReads Riffle Bloglovin' Google Plus Amazon.ca Reviews RSS Email

catchphrase

Disclaimer | Request a Review | Contact