Media Query Tracker

Template 1 min
Microsoft Excel Document
PAVILION MEDIA QUERY TRACKER 20211020.XLSX
Download 
Use this template to log, organize and analyze media queries to communicate to leadership.

Attention!
Check with your unit to ensure there are no local templates that should be used instead.

All media queries should be tracked media query for internal organization and data analysis. The information in this template can aid in faster response to repeated queries and can be analyzed for trends and compiled into graphs to enhance the commander’s understanding of public affairs’ impacts and effects.

Use this spreadsheet to log:

  • Status
  • Date/Time Received
  • Organization
  • Type of Organization
  • Subject
  • Location of Form
  • Reporter
  • Deadline
  • Received By
  • Coordination
  • Response By
  • Date/Time Responded
  • Time Required

Recording the total time from receiving the query to the final response is a helpful data point for evaluating a team's efficiency. Use the analysis tab to evaluate average team response times and see the types of organizations (local, national, international) that request information and the subjects they're asking about. Be sure to delete all of the instructions and examples before actively using the log.

Preview

Discover More You May Like

View All Templates
Five syringes injecting vaccines, powering a glass container, while surrounded by varieties of viruses, with a cyberpunk-themed user interface.

Combatting Information Disorder

Article
4 min
Explore tactics to prevent the spread of information disorder on the digital battlefield.
Master Sgt. Ieshea Lattimore, 406th Air Expeditionary Wing Staff Agency & A1 superintendent, left, and Master Sgt. Stephanie Williams Personnel Support for Contingency Operations team chief, collect and review in-processing documents from deployers at Ramstein Air Base, Germany, May 18, 2023.

After a Crisis: Team Self Evaluation

Template
3 min
This Excel template helps a team evaluate its crisis performance to better prepare for any future crisis.
An illustration of a website surrounded by six jigsaw puzzle pieces, with each piece containing a single icon: a clock, a book, a folder with a padlock, an image, a chat bubble and a checkmark.

Leveraging an Information Dashboard During a Crisis

Article
8 min
Learn how making a dedicated webpage is a powerful tool when handling misinformation from a sustained crisis.
An airman reads a book to children seated on the floor.

Community Relations as a Process

Article
6 min
Review how Research, Planning, Implementation and Evaluation fits into the community relations process.
Isreali Defense Forces (IDF), Sgt. Yuval Italiano, left, and Sgt. Ofir Holzman, assigned to IDF Combat Camera Company, listen to instructions from Spc. Samantha Schaffling, assigned to 55th Signal Company (Combat Camera), in “Technical Lanes” event, during the 2023 Spc. Hilda I. Clayton Best Combat Camera Competition at Fort A.P. Hill, Virginia, May 24, 2023. The annual multi-day competition tests the physical, tactical, and technical proficiency of visual information and public affairs specialists across the DOD and participating international competitors. (U.S. Army photo by Spc. Noah Martin)

Mission Strategy Worksheet

Template
2 min
Fill out this worksheet with the strategy and assets needed to ensure visual imagery is successfully captured.
U.S. Air Force Senior Airman Andrew Cranley, 423d Security Forces Squadron Base Defense Operations Controller, monitors base operations at RAF Molesworth, England, Sept. 8, 2023. SFS members at the Base Defense Operations Center are responsible for coordinating security on the installation and remain ready to coordinate responses to ensure the safety and security of the community and mission.

508 Compliance Audit: Website or Application

Checklist
7 min
Ensure your website, web applications and software are 508 compliant with this checklist.

View More