Ongoing Coverage Spreadsheet

Do you keep an ongoing spreadsheet with all of your client coverage?

We've done some pretty elaborate ones ourselves.  Valuable to have all of the data in one place, but not exactly fun to maintain.  

I'm looking at one right now and it had the following columns:

• Date
• Publication
• Title
• Author
• Link
• Feature/Mention
• Article Type (this was specific to the client) 
• Secured Coverage (Yes/No)
• Reach
• Alexa Rank
• Tier (1-3)
• Type of Publication (National/Local/Trade/etc...)
• Sentiment (Positive, Negative, Neutral)
• Country
• Score (we came up with a custom scoring system to weigh the significance of each clip)

While this information lived in a shared Google Doc, we first used Report Mule to automate as much of it as possible.   Then we created custom fields within Report Mule for any of the extra information that we wanted to track.   As we entered the URLs into the program we also filled out the rest of the information that would ultimately be transferred to the Google spreadsheet.  When our report was done we'd simply export our results to a CSV file and copy in the information.   With our automation and easy to use interface it really cut back on tedious data entry.  

Plus - with all of the information already in Report Mule we're able to create different report layouts to create more readable reports with custom information.  Two birds, one stone. Nice

Want help setting up your reporting spreadsheet?

Email me - christophe@reportmule.com and we'll get to work customizing your account with you.