Content Tracker - April 2023
Tracker is condensed and has more info. Same checkbox mechanics. Assigned clients on the left. Additional work to the right. Do your assigned clients first unless something from the previous months comes through. Any additional pieces will go to the right of your assigned pieces (including previous month’s requests). This is how we showcase how SEO’s late requests and responses affect us. New package clients have been distributed evenly. Grab requests from The Overflow column (DS Writing Board) when you’re done with your assigned pieces.
What is it?
Same tracker with same mechanics (mark checkbox when done).
New info on pieces.
One column for assigned work.
One column for additional work.
...
In April, we decided that each DS writer should be assigned 100 piece-hours of work.
Piece-hours: The hours it requires to complete 1 piece.
New packages take twice as long in the first 3 months, thus:
(1) 2022 Silver package = 2 piece-hours: 1 piece, 2 hours to complete each.
(1) 2022 Gold package = 4 piece-hours. 2 pieces, 2 hours to complete each.
(1) 2022 Platinum package = 4 piece-hours. 2 pieces, 2 hours to complete each.
After 3 months, these pieces go back to consuming maintenance piece-hours because the requests go back to pagefooters, articles, etc.
We have also implemented a new countdown timer on our DS assignment sheet in order to evenly distribute work each month.
This shows us how many days are remaining in the client’s first 3 months (see orange column).
...
Column S (Pkg.): Additional piece’s package. It should be Gold for April, unless you’re working on leftovers from the previous month.
...
A Note on Notes!
There certainly is, but we should start using spreadsheets the way they’re meant to be used! Lengthy notes do not belong in cells.Often, lengthy notes can affect the size of a row, or cover up data in other cells. If you would prefer to hide your notes, follow the steps below:
Right click on the name of the client you’d like to write a note about, then select Insert Note and start typing. Once you’re done, click away from the note window.
...
Hover over the cell to read or edit your notes. If you want to delete it completely, click on the same cell and click Delete Notes.
Now I won’t know if a card is missing!
You can begin color-coding your client’s cells. Refer
Color-Code Your Clients
If you need at-a-glance information about your client, refer to the Legend tab on the tracker for more informationand use colors to organize information about clients. This is helpful, but not required.
Keeping a clean spreadsheet that can be universally understood is great business practice! It also reduces anxiety for the user and the viewer.
Thanks for reading. Let Reina Underwood know if you have questions!