Content audit template

Content audit template

What is it?

A content audit template is a tool that helps you organize and analyze existing presentation content. It provides a step-by-step process to evaluate content and identify gaps, redundancies, and areas that need improvement. This includes aspects like the structure, flow, message clarity, and alignment with objectives.

When undertaking content overhauls or updates, utilizing a spreadsheet allows for easy visibility and understanding of the content landscape. It enables the team to "see" the entirety of the content, which can be challenging in a traditional slide show format. Tracking and documenting changes is easier and any modifications or updates can be accurately recorded, ensuring transparency, accountability, and effective project management.

You can also use it if you’re building a template system for a client. It enables you to gain a deep understanding of their content landscape, identify common elements or patterns that can be incorporated into the template system, and uncover gaps or areas where the templates can be optimized. This ensures that the template system meets the client's needs, makes content creation easier, and improves the overall consistency and effectiveness of their presentation development process.

      When to use it

      1. Comprehensive content overhauls and updates: When you need to make significant changes to your content and want to keep track of those changes in an organized manner.
      2. When you need a bird's-eye view: If you want to see all your content at once, understand its overall structure, and identify any gaps or areas that need improvement.


      Remember to

      1. Customize the spreadsheet: You can modify the layout, formatting, and styling of the template to make it more readable and user-friendly according to project scope and preferences.
      2. Ensure that the spreadsheet is easily accessible to all team members involved in the content audit.



      Set-up the spreadsheet

      Open a new spreadsheet in your preferred spreadsheet software (e.g., Google Sheets, Microsoft Excel). Create separate tabs or sheets for each section of the content audit, such as "Project Details," "Existing Content and Analysis," "Gap Analysis," "Updated Presentation," and "Summary and Conclusion."


      Project details (Tab 1)

      In the "Project Details" tab, include sections to capture key project information, including the presentation title, summary, and objectives. Use columns labeled "Existing," "Analysis," and "Recommended Update" to document your review of these details.


      Existing content analysis (Tab 2)

      Within the "Existing Content" tab, set up columns reflecting the presentation's structure, such as sections, slide titles, content summary, time, resources, and notes. Document and review the existing content, analyze its structure, flow, and alignment with objectives.


      Gap analysis (Tab 3)

      Create a "Gap Analysis" tab to document any identified gaps or missing content elements that need attention. Plan out sections for documenting these gaps, ensuring consistency in your documentation.


      Updated content (Tab 4)

      Duplicate the "Existing Content Analysis" tab into the "Updated Content" tab to make changes and updates. Consider using a color key to visually distinguish the extent of changes made, such as different colors for minor edits, substantial revisions, or new content.


      Summary and conclusion (Tab 5)

      In the "Summary and Conclusion" tab, include sections to summarize your findings, highlight key takeaways from the content audit, and provide recommended actions based on your analysis.

      Template coming soon