Page Comparison

When submitting a pagefooter, the writer will only be required to fill out the top portion of the template above the solid line. Writers are expected to provide:

Complete - Month (Request Month) #/# (Batch Number)
Title: (Title of Piece as it appears in the content)
Content Type: (Content Format)
Link to Content: (Link to Original Google Doc)

Example:

Complete - April 1/2
Title: Why Buy a Used Harley-Davidson Motorcycle?
Content Type: Pagefooter
Link to Content: https://docs.google.com/document/d/13XnoaMyDo7UK_q-Cepe2V3Es3tpzHidZSxWipqKMwjg/edit

When submitting an article, the writer must fill out the entire template. Writers are expected to provide:

Complete - Month (Request Month) #/# (Batch Number)
Title: (Title of Piece as it appears in the content)
Content Type: (Content Format)
Link to Content: (Link to Original Google Doc)

Articles Only
Image link: (A link to an appropriate image to be published with the article)
Title Tag: (A relevant, SEO-optimized title tag)
Tags: (Related blog tags)
Category: (The content category as it’s organized in the rewrite index)
Meta Description: (A relevant, SEO-optimized meta description)

Example:

Complete - April 2/2
Title: Driving tips for Towable RVs
Content Type: Article
Link to Content: https://docs.google.com/document/d/1ywpRDAkBAW28w8BNZV2iJUnJnBp3cBl5boqfNiEvQq0/edit

Articles Only
Image link: https://cdn.dealerspike.com/imglib/seo/stock/rv/rv_family_d.jpg
Title Tag: RV Towing Tips | Great RVs | RV Dealership
Tags: Towable RVs, RVs, Fifth Wheels, Travel Trailers, Toy Haulers, Towing Tips, Ownership Tips
Category: Ownership Tips
Meta Description: Let this guide help you become a master at towing your RV!

The Work Done Import tab in each client sheet is designed to keep an inventory of all content that has been written for one client by the content writers. Each completed piece must be entered into column M in the following way:

• Look for the corresponding row by checking the Date (column A), Content Focus (column F), and Type (column H) of the piece.

• Enter the document title as it is written in the title of the Google Doc, not the H1 or H2.

• Link the Google Doc to the title.

Which row do we put our Google Doc link?
The google doc link should always be pasted into the Content Google Doc Link column as you have been doing, and ideally it would be dropped in the row that specifies the content focus and content type. Sometimes the rep has not created additional lines for all the monthly foci when content goes to drop the Google doc, in which case it can be dropped into the single month row that has been made.  

When there is a discrepancy between the topic in the Work Done Import and the Trello card, how do we know where to put our Google Doc link?
You can just drop the doc link in the correct month's row, and if the topic is different and the SEO rep just hasn't changed it in the WDI tab, they should get it done before reporting. If they don't then they will probably get a QA comment to fix it before reports get sent out. 

When there is a discrepancy between the type of topic requested on the Work Done Import and the Trello card, how do we know where to put our Google Doc link?
Links will still go in the monthly row that best matches, but it might be a good idea to send the rep a quick message to confirm the content type before Juniper posts it so they can change that in the WDI tab if needed. 

When there isn't a row mentioning content (for example, the month only has two rows and both say "YouTube"), should content team kick that card back and ask the rep to adjust the Google sheet? Do you want content to add the rows (and if so, where do they go? Above the YouTube content? Below the Youtube content?)
Content should not need to add the rows or kick it back, and the doc link can just be dropped in whatever monthly row is available. When the content is posted by Juniper and they go in to paste the WD URL, the lines should be created by the rep by then, but if not Juniper may create a skeleton row to drop the URL for the rep to finish formatting later (I think). 

What information do you want us to put in the cell? Do you simply need the keyword (like "travel trailer)? Do you need the topic (like "travel trailer - buying guide")? Do you need the type of content (like "travel trailer - buying guide (article)")?
I believe that the topic is what content has been labeling the docs as, and that works just fine. 

If the rep has incorrectly placed text/URL in the content column, what should we do? Kick it back?  Remove the text (where do we place it instead)?
If the work done URL is being put in the Content Google Doc Link column instead of the Content Link column, then that is usually a Juniper error and will be caught by QA during reporting if not caught by the rep when they are formatting the WDI tabs for reporting.  

Is it okay for content writers to freeze the left hand column and top row for easier scrolling to the Content Link?
If freezing the first 2-4 columns and freezing the top row is helpful to see where to put links, then you can do that. It should not affect reporting formatting.  

Is it okay for content writers to make the content document column a light gray so it's easier for us to keep track of where our entry needs to go?
You may change the content doc column to whatever color you'd like to make things easier to see. It will not affect reporting.