If you’re reading this post, it means you were probably looking for my Word Count Tracker Spreadsheet that I had been offering for sale for several years. I’ve also received several emails asking for an updated version of my Word Count Tracker Spreadsheet, so I figure I would provide this update.
The TLDNR is that I’m no longer using that spreadsheet, so I’m no longer having it updated. And I don’t want to sell something that I’m using for my writing. Below, I’ll update on what I’m using to track my word count goals, and offer some alternatives for you.
Word Count Tracker Spreadsheet (Background)Writing, much like any other art form, requires dedication, practice, and a touch of discipline. One of the most effective ways to hone your craft is by setting clear, tangible goals, and what’s more tangible than the number of words you pen down each day? This blog delves into the significance of tracking your daily word count and how it can transform your writing journey.
It’s what helped me be more productive with my writing (14 published novels and counting), so I’m a true believer in setting project word count goals and daily word count goals to meet that target.
Benefits of Tracking Daily Word CountConsistency in Writing: The key to mastering any skill is consistent practice. By setting a daily word count goal, you’re committing to write regularly, which not only improves your skills but also keeps your project steadily moving forward.
Motivation and Accountability: Watching those word counts climb each day is incredibly satisfying. It’s a visual representation of your effort and progress, serving as a motivator to keep going, especially on days when inspiration seems to be on a vacation.
Measuring Progress: It’s easy to feel overwhelmed by a large writing project. Breaking it down into daily word count goals makes it more manageable, allowing you to see your gradual progress towards the finish line.
Identifying Patterns: By tracking your daily word count, you may begin to notice patterns in your writing habits – what time of day you write best, which environments boost your productivity, and how your mood influences your output.
The ConceptThe concept is simple. You set a daily word count goal which you try to hit every day. I first learned about this from Stephen King, who famously writes 2,000 words a day. He wrote about this in his wonderful book On Writing.
Many other writers do this. On my podcast, “Meet the Thriller Author,” I’ve interviewed over two hundred authors. Including legends like Dean Koontz, Walter Mosley, and Lee Child. I always ask if they set word count goals. And just about every single one answered yes. So this is an important strategy used by bestselling authors, so I too would do this in my writing process.
Developing my Word Count Tracking SpreadsheetI’ve tried just about every software program, word app, and spreadsheet out there to track my word count goals. Even though my writing software (Scrivener) had a word count tracker built it in, I found a spreadsheet helped me even more. I started with a basic word count tracking spreadsheet, then kept trying others with more features. Unhappy with what was available, I decided to create my own spreadsheet. There was an enormous obstacle for me to overcome, though. I knew what I wanted on my word tracking spreadsheet, but to achieve that was well beyond my Excel skills. So, I posted a job on Upwork and hired an Excel programming whiz to create my dream Word Tracking Spreadsheet.
I shared it with writer friends who love it. So, I decided to put it up for sale. My primary goal was to recoup my out-of-pocket cost of paying the Excel whiz to create it. To my surprise, I sold way more than I thought I would. Every year, I would hire the Exel whiz on Upwork to update the spreadsheet, and would offer that spreadsheet for sale.
By mid-2022, I found myself not using it daily, like I used to. And I used other forms of tracking my word count goals (more on that in a bit).
By the end of 2022, I knew I wouldn’t be using my tracker anymore, so I didn’t have it updated for 2023. It was abrupt, and I didn’t let anyone know, so when I got messages asking for the 2023 version, I felt guilty. As 2023 ends, I won’t be using the tracker next year either, so I will longer be selling it. So I wrote this post for previous customers, or folks who found my tracker whilst searching online for one. I figured this is better than a 404-error page. I also wanted to provide some alternatives and share what I’m doing now, since, yes, I still track my word count every day.
Tracking my Word Count NowAs clear from this post, how I track my word count might change, again. That’s the main takeaway from all this. It doesn’t matter how you do it, just that you’re tracking your word count will help you achieve your writing goals. I know writers that track their word count longhand on a notebook.
Currently, I’m using the word count tracker in Scrivener. They really amped up the word count tracker a few years ago, and it’s fantastic. I found I no longer needed the spreadsheet.
Using this tool, you can easily set writing goals by setting up your word count goals. Then you can manage your writing schedule so that you can meet those goals.
You can get more detailed information about the Scrivener word count tracker from the Scrivener website. But here is the quick lowdown on it.
To track word count in Scrivener, you can:
You can also hover over the Quick Search bar to see the word count and progress bars.
I enable notifications so it alerts me where I’m at with my goals. My daily goal is 1,667 words per day. If you’re familiar with Nanowrimo, you’ll know that’s how many words you need to write a day to hit 50K. My manuscript goal is 50,000-60,000 words for my thrillers, so that’s a nice goal to try to write a novel in 30-45 days.
Honarable MentionsPacemaker PlannerOne of the best online tools to track word count is Pacemaker Planner which helps you plan out your entire year and manage multiple deadlines without spreadsheets. I recorded a video and wrote about using Pacemaker Planner and it’s fun features to write a cozy mystery novel in less than thirty days.
Word Counter AppI love this app! It’s Mac only (sorry). It sits on my computer and tracks my word count on all apps (Chrome, Scrivener, Text, etc). And it generates beautiful graphics to help visualize it. It’s only $19.99. Like Scrivener, that’s a onetime fee, not those annoying yearly subscription plans.
Keep on Tracking and WritingAs mentioned before, there are many ways to track your word count. Try the one that works best for you. If you miss my Word Count Tracker spreadsheet, feel free to update it. If you can’t do this yourself, you can go to Upwork and hire someone to do it for you for around $50. Feel free to use one of my old spreadsheets and just tell them to update it for 2024.
Good luck with your writing!
The post Word Count Tracker Spreadsheet: An Update appeared first on Fictive Universe.
Migrating WordPress site to a new web host isn’t as daunting of an ordeal as you might think (or fear). I wasn’t happy with my web host. My sites loaded slowly and after the one-year promotional price, the cost was much higher compared to other web hosting companies out there. With my annual renewal approaching and the incredible Black Friday and Cyber Monday deals from several web hosting companies, I mustered the courage to move my five websites, despite my initial apprehension. Luckily, most web hosting companies making it easy to move, especially if, like me, you use WordPress for your website.
Migrating WordPress Site to New Host (DreamHost)As previously mentioned, I use WordPress, which makes setting up and maintaining a website easy, in my opinion. If you don’t use WordPress, this article, and the video below, won’t apply to you.
This isn’t the first time I changed web hosts, requiring me to move my websites. The last time was a few years ago and I used a third-party WordPress plugin to move my websites. This time, I went with DreamHost, which often makes the top of the best web host deals out there.
Source: ZDNET DreamHost has their own WordPress migration plugin, which I found much easier to use than the other one I used the last time I changed web hosts.
But don’t worry, if you get stuck, you’re not your own. I had an issue with the migration key and with one of my sites moved to the wrong server, and support was fast to help me. But after those hiccups, the process was smooth thanks to the plugin. I’ll break down my process step-by-step. I also recorded a video moving my last website, so you can check that out below or on my YouTube channel (be like and subscribe).
The MovePreparation Steps:
Using the DreamHost Migration Plugin:
Post-Migration Checks:
Remember, successful migration hinges on careful planning and execution. With the DreamHost Migration Plugin, the process is streamlined, but attention to detail is key to a smooth transition.
Real time VideoI recorded myself moving one of my websites. You can watch the video down below or on YouTube.
The post Migrating WordPress Site to New Host: A Step-by-Step Guide appeared first on Fictive Universe.
SiteStripe unable to generate link? I feel your pain. Here you’ll find my workaround that annoyance using ChatGPT.
BackgroundAs an author, blogger, or online marketer, creating customized Amazon links is a crucial skill. It not only helps in tracking the performance of your products but also in marketing them efficiently in order to receive an affiliate commission from Amazon.
I use these a lot for my podcast website and book review site. The easiest way to generate Amazon affiliate links is using their SiteStripe add-on, but the problem with that is that it often bugs out on me, and it won’t work when I need it.
SiteStripe Unable to generate linkAmazon will fix it, but it takes a while. Other fixes I’ve tried are convoluted, especially since I’ve already carved out time to set up these posts with the tracking id at that time.
How to Create Customized Amazon LinksThe easiest way is to have a standard Amazon link ready to go, so you can just replace the ASIN.
In this post, we’ll walk through the simple steps to create these links.
Step 1: Locate Your ASIN or ISBN
First, you need the ASIN (Amazon Standard Identification Number) or ISBN (for books) of the product. You can find this on the product’s Amazon page, usually listed in the product details section.
Step 2: Understand the Basic Amazon Link StructureA standard Amazon link looks like this:
https://www.amazon.com/gp/product/ASIN?&linkCode=sl1&tag=YourTag-20
Here, ASIN is where you’ll insert your product’s ASIN or ISBN, and YourTag-20 is where your unique Amazon affiliate tag goes.
Step 3: Insert Your ASIN or ISBN
Replace ASIN in the link with your product’s specific ASIN or ISBN. For instance, if your ASIN is B0BWNW9G8X, your link should look like:
https://www.amazon.com/gp/product/B0BWNW9G8X?&linkCode=sl1&tag=YourTag-20
Step 4: Add Your Affiliate TagReplace YourTag-20 with your Amazon affiliate tag. This is essential for tracking sales or referrals.
Step 5: Test Your Link
Always test the link to ensure it directs to your product’s page. A simple click should tell you if everything is set up correctly.
Using ChatGPT to create Amazon LinksAll the process described above is simple. I saved a standard custom link in a Google sheet, then when I needed a new one, I would open it up and replace the ASIN. But that wasn’t as smooth as I wanted it to be, so I tried ChatGPT, and it did a nifty job creating the Amazon link!
The first prompt was simple and straightforward:
Use this link: https://www.amazon.com/gp/product/ASIN?&linkCode=sl1&tag=trbookreviews-20 and replace this text: ASIN with this text: B07QGQCDVF to create an updated link.
ChatGPT created the link…
Once you have that first prompt completed, you can go into that chat history, and then just use this prompt:
Create another link with this text: B0BQLKNTYR
Just update it with the new ASIN, and ChatGPT will generate the Amazon link with your tracking id for you. Saves some time, then using a spreadsheet.
SiteStripe Unable to generate link (watch the video to see this in action)The post SiteStripe unable to generate link? Use ChatGPT, instead. appeared first on Fictive Universe.
As indie authors, we’re always in need of royalty free images for book covers and more. We need affordable quality royalty free images for our book covers, Facebook Ads, website graphics, email newsletter, and more.
We often face challenges when it comes to finding the perfect images. The use of copyrighted images can lead to legal issues, but thankfully, there are royalty-free images that indie authors can use. Here are a few reasons why indie authors should use royalty-free images.
First and foremost, using royalty-free images protects indie authors from copyright infringement. Copyright laws can be complex and confusing, and even unintentionally using copyrighted images can lead to legal issues. By using royalty-free images, indie authors can avoid any potential legal trouble.
Additionally, royalty-free images are often more cost-effective for indie authors. Purchasing images from stock photo websites can be expensive, especially for indie authors who may be on a tight budget. Royalty-free images are typically much cheaper and can be a great alternative for indie authors looking to save money.
Using royalty-free images also allows indie authors to have more control over their book cover designs. When using copyrighted images, indie authors may be limited in how they can use and manipulate the images. With royalty-free images, indie authors have more flexibility to create the perfect book cover design for their work.
Lastly, using royalty-free images can be a great way for indie authors to support other artists. Many royalty-free image websites are created and maintained by artists who want to share their work with others. By using royalty-free images, indie authors can help support these artists and potentially discover new artists to collaborate with in the future.
In conclusion, indie authors should consider using royalty-free images for their book cover designs. Not only does it protect them from legal issues, but it can also be more cost-effective and offer more creative control. Plus, it’s a great way to support other artists in the community.
Where to Find Royalty Free Images?I use Depositphotos. They have 195+ million premium images on their website and thanks to a fantastic deal via AppSumo, you can purchase blocks of 100 images for just $39! These credits never expire on Depositphoto, so there is no worry or rush. Get your royalty free images and use them as needed. You can also get multiple packs of 100, so if you want 300 images, pay $117 and you can get even more than that! Just pay $39 per pack of 100 royalty free images from Depositphoto and you’ll be set for life.
In this video, I’ll show you the deal and walk you through how to order since I just bought a 100-image pack to add to my account. This is a limited time deal via AppSumo, so don’t lollygag if you’re looking for quality royalty free stock images. Get this amazing deal now.
The post Royalty Free Images for Book Covers and More appeared first on Fictive Universe.
How to write an action-packed thriller.
As a thriller author and podcast host of MEET THE THRILLER AUTHOR, I’m sometimes asked for tips on how to write a thriller. Here is my take on the subject.
But first, writing techniques are subjective. What works great for me might not for you. But these strategies have been around since the start of the thriller genre.
Writing a thriller is one of the most difficult things you can do as a writer. It requires a lot of planning and a deep understanding of character and plot development. The genre is full of cliched elements, so it’s important to find creative ways to make your story stand out. Here are seven strategies to help you write an action-packed thriller that will keep your readers on the edge of their seats.
1. Start with an exciting event.
The very first element of a good thriller is a gripping opening sequence. It should be high in energy and suspense and make your readers immediately interested in what’s going to happen next. You can do this by setting up a scene of suspense and danger, introducing a mysterious character, or even starting off with a murder.
2. Create interesting characters.
No thriller would be complete without interesting characters. Make sure your characters are well-developed, with distinct personalities, motivations, and conflicts. Create characters that your readers can relate to and care about, so they’ll be invested in the story and concerned with their fate.
3. Build suspense.
Suspense is the key to a successful thriller. It’s what keeps your readers hooked and turning the pages. To create suspense, use techniques like foreshadowing, red herrings, and cliffhangers. Start each chapter with a question or an event that will keep your readers engaged.
4. Introduce twists and turns.
Twists and turns are an essential part of any thriller. They make the story more unpredictable and keep your readers guessing. To create these twists, use shocking revelations, unexpected plot points, and surprise endings.
5. Make it unpredictable.
Nothing kills a thriller faster than predictability. Make sure your story is full of unexpected plot points and unexpected characters. Leave your readers guessing and make them wonder what will happen next.
6. Keep the pacing fast.
A thriller should be fast-paced and full of action. Don’t let your story drag or bog down; keep the pacing tight and the action moving. Make sure your readers never get bored or lose interest.
7. Add a touch of realism.
Although a thriller should be high in suspense and danger, it should also be grounded in reality. Make sure your story and characters have depth and complexity; add details that make the story and characters more believable and relatable.
By following these seven strategies, you can write an action-packed thriller that will keep your readers hooked and wanting more. Just remember to start with an exciting event, create interesting characters, build suspense, introduce twists and turns, make it unpredictable, keep the pacing fast, and add a touch of realism. With these tips, you can create an exciting, suspenseful thriller that will have your readers on the edge of their seats.
The post How to write an action-packed thriller (7 Strategies) appeared first on Fictive Universe.
Finally! A long, often requested feature from Amazon’s Kindle Direct Publishing account is to remove a book from our KDP Bookshelf account.
Until recently, this was not possible. Even if you unpublished a book, it sat there on the KDP Bookshelf cluttering up space forever!
I started self-publishing on KDP in 2012 and had some trial-and-error books that I long ago unpublished and never plan to make public again. So it was annoying to see those books sitting there on my KDP Bookshelf cluttering it up. So yes, I’m very excited that I can now archive those books away so I don’t have to see them in my KDP account.
How to Remove Books from KDPNow we can archive those old books, so they’re not cluttering our account. Watch this short video to see how easy it’s to archive those old books from the KDP Bookshelf.
The post How to Remove Book From KDP Bookshelf appeared first on Fictive Universe.
Affordable book cover design on Fiverr case study.
I’ve been harping about the importance of book cover design on this website for ten years! I used to be dead set against using Fiverr and for years, I would dissuade any author asking online in forums or Facebook Groups from using Fiverr to find a book cover designer. In the last year or so, I’ve changed my tune. I’ll share my thoughts on using Fiverr for book cover designs and offer a case study with actual book cover design examples I had created on Fiverr.
The Video Case StudyFiverr. Really?Before I get to the examples, and the video case study, let me explain my train of thought about using Fiverr for book covers over the years.
The logline on Fiverr as per Wikipedia:
Fiverr is a global online marketplace for freelance services. Fiverr’s platform connects freelancers (sellers) to people or businesses looking to hire (buyers).
They launched Fiverr in 2010. During that time, I was doing a lot of affiliate marketing and hanging out in digital marketing forums where Fiverr became very popular, right off the bat.
According to Wikipedia, Fiverr went live in February 2010. I opened my Fiverr account in May 2010… within three months, so I was an early adopter of the site!
When the first site started out, I viewed more sort of like a gag site where you could find silly gigs for just five bucks. Back then, all gigs were just $5, thus the name of the site, Fiverr.
Also, back then, as I recall, Fiverr didn’t seem to put much thought to things like copyright protection or keeping scammers off the site, so it kind of became a shady spot.
You also had to worry about a scammer claiming to have designed the cover for Stephen King and will do your cover for five bucks, only for them to send you a crap cover. Or they would rip off talented designers’ covers, and use unlicensed images to boot. It was a mess.
I didn’t take Fiverr too seriously. If I wanted a book cover design, I would go to E-lance or oDesk (both gone now having become Upwork) which is why I would tell anyone that asked not to use Fiverr for book covers.
But they’ve come a long way since those days. They ditched the five buck shtick which allowed its sellers to make more than just a buck or two after Fiverr and PayPal fees, which attracted more reputable and professional people to Fiverr.
Now you can find amazingly talented people on there and affordable prices. Podcast editors, marketing services, writers, formatters and, of course, book cover designers.
You can find a ton of book cover designers on Fiverr (hundreds if not thousands).
There are three that are my go-to ones that I’ve used in the past couple of years (you can find the links to their Fiverr page below).
These book cover designers I’ve hired from Fiverr create quality book covers and they only use licensed images, which goes without saying is of utmost importance, knowing you won’t run afoul of copyright laws over the images used in the covers.
You can even be more at ease by sending them your own royalty free stock images. But you will need to send them the license agreement you have. They will ask and they won’t use the image if you don’t have proof that you have the license to use it. A long way from 2010, Fiverr, in my opinion.
How Much?Honestly, what first drove me to try Fiverr again for book cover design was the pricing. But, I would never choose them if they couldn’t deliver a genre-focused, gorgeous cover.
Book cover designers outside of Fiverr run the gamut from around $200 to well over a $1,000. And many of them get booked out for months in advance and the process can take a lot longer than expected.
Fiverr book cover designers usually turn around their covers in 2-3 days!
So how much? If you just need the ebook cover, the price is $5. After Fiverr’s fees, it’s around $7.
Most of the designers also offer a package that includes the ebook and paperback print version of the cover. As well as a premium package, which also includes the source file (a PSD Photoshop file).
Even though I don’t use Photoshop, it’s above my tech level, I select the premium package, anyway.
I like having the source file. I can always get someone to make tweaks if needed. And I can use it in Photopea if needed.
The premium package includes all the goods:
All that for just $25. Note… ends up being around $28 after the Fiverr fee is added.
It truly is an affordable book cover design!
The Design BriefThe book cover design cost via Fiverr is so affordable, that when I was trying to decide which designer to hire for a cover rebrand project I was working on for my first thriller series, I hired three of them and see which style I liked best.
I put together my design brief.
Side note: I highly recommend you put together a tight design brief which I show you in the case study video below.
I was a business analyst in my previous life (I was Tom Smykowski from Office Space), so the more details I can provide to the tech people (cover designer in this case) the better!
Doing this ensures that the delivered cover is usually spot on. Maybe a single revision is needed for minor aesthetics.
Another bonus is these designers offer free revisions so you can get the book cover just right. But usually they nail it right off the boat because I’m very clear about what I want.
Check out the video case study on how I put the document with the design specifications together.
Affordable Book Cover Design from Three Fiverr Book Cover DesignersLike I mentioned above, I’m redesigning the covers for my three Pete Maddox thriller books.
Original cover of 2013I published THE ASSET in 2013, so it’s almost a ten-year-old cover!
I loved that cover. It was the first fiction book I ever published, so it was near to my heart. But book cover design styles change, big time. And the original covers just weren’t cutting it anymore. They needed an update. But I also didn’t want to spend hundreds of dollars per cover, which is why I went to Fiverr.
I ordered three gigs from three different book cover designers, so I could see what they came up with and which one was the best.
In the end, I liked all three covers, but one was the winner in my book (pun). I’ll tell you which one I chose at the end of this post, but first the three designers and their covers.
Designer #1: dhananjayaeffecThis designer is based in Sri Lanka and wow, do they have talent!
This is the cover they designed for THE ASSET:
Designer #2: rebecacoversI’ve them frequently, and other friends have used rebecacovers. I believe they’re one of the most popular book cover designers on Fiverr, with almost 19,000 reviews with a 4.9 average rating! They’re in the Ukraine.
They also did a banger job on the cover!
Designer #3: printok They’re in Bahrain and did a nice job with bright, vibrant colors I was after.
Affordable Book Cover Design: The WinnerI liked all the three covers, so all three designers were winners in my book, but I had to pick one, and I went with Designer #1, dhananjayaeffec. They seemed to really nail the look and feel of the book cover comps I sent them of the bestselling books in the genre and Amazon categories I’m after.
Affordable book cover design on Fiverr is possible without sacrificing quality.
Affordable Book Cover Design on FiverrThe post Affordable Book Cover Design appeared first on Fictive Universe.
How does amazon attribution work for authors? It’s a question that I’ve seen asked a lot about the indie author Facebook groups and forums. In...
The post How Does Amazon Attribution Work for Author’s Facebook Ads appeared first on Fictive Universe.
Targeting authors for Amazon ads
The post Targeting Authors for Amazon Ads appeared first on Fictive Universe.
My email campaign for my upcoming book launch.
The post Book Launch Marketing Ideas: Email Campaign appeared first on Fictive Universe.
Canva for authors in real time (watch video below). I’ll be sharing another author tool which I find indispensable for my author business and that’s...
The post Canva for Authors appeared first on Fictive Universe.
How to edit photoshop PSD files without Photoshop.
The post How to Edit PSD Files Without Photoshop appeared first on Fictive Universe.
Last update on querying literary agents.
The post Query Rejections appeared first on Fictive Universe.
Manuscript proofreading video in real time...
The post Manuscript Proofreading in Real Time appeared first on Fictive Universe.
Writing cozy mysteries update: I’m excited to share this update on my October writing challenge to write the fifth book in my cozy mystery series...
The post Writing Cozy Mysteries (Update) appeared first on Fictive Universe.
My October writing challenge to write a cozy mystery novel in 31 days is going well. I hit the 63% mark of my goal on...
The post Pacemaker Planner Review & October Writing Challenge Update appeared first on Fictive Universe.
Writing a cozy mystery book in 31 days starts on October 1...
The post Writing a Cozy Mystery Book in 31 Days appeared first on Fictive Universe.
2022 Word Count Tracker Spreadsheet is now available!
The post Word Count Tracker Spreadsheet for 2022 appeared first on Fictive Universe.