How To Collect Positive Mentions



This webpage is designed to provide detailed instructions about how to collect positive mentions about anyone across multiple channels. To do this effectively, you need to be sure you have their full name and an image of their face, at a minimum, so you can follow them between digital properties.

Please follow these directions in order to create a spreadsheet with articles that have positive notes about each location.

Place each in an individual sheet inside the spreadsheet

How to store mentions:

  • Create a spreadsheet. You can use Google Sheets, Microsoft Excel.
  • Save the file using the syntax “[SubjectName]_mentions_[version#]”, where you replace values within square brackets, “[“ and “]”.
  • Make a seventeen-column table labeled: “URL”, “Date”, “Title”, “Brief Description”, “Author”, “Social Media Platform”, “Positive”, “Negative”, “Quote”, “Actions to Take”, “Action Completed?”
  • You’ll need to add in 4 columns for authority-- 3 to score each of the components and then a grand total column.

Include 4 columns after that for reviews. "Review Site", "Rating", "Description", and a final column for "Local Ranking". Collect reviews from Google, Yelp, Facebook and other review sites and then provide a total ranking based upon other local chiropractic offices in a 10 mile radius.

Here's a video on how to rank content by authority on a 30 point scale.
https://www.youtube.com/watch?v=UoFnF-87fpM

When you find an article, podcast, or mention online, copy the link and paste into the URL column.

Add the following information:

  • The date the article was posted
  • It’s title
  • A brief description of what the article discusses
  • The author of the article
  • The social media platform where the article was discovered.
  • Then add a checkmark in the “Positive” column or” Negative” column, depending on the content of the article/mention.
  • If the article is positive, extract a quote and add it in the Quote column.

How to Find Mentions Online:

  1. Type subject’s name into Google
  2. Click on the “News” tab
  3. Scan URL’s/articles for mentions of your subject
  4. Might show articles for different people with the same name so make sure you pick the right one
  5. Add the URL for your selected article into your spreadsheet, along with the other necessary column information

How to Find Mentions on Social Media:

Twitter

  1. Click on the “Notifications” tab
  2. Then click on the “Mentions” tab
  3. Copy the URL to the excel document (along with other necessary column information

LinkedIn Public Figure Page

  1. Click on the “Activity” tab
  2. Click on the “Mentions” tab
  3. Add to your spreadsheet, along with the other necessary column information

Facebook Public Figure Page

  1. Click on the “Notifications” tab
  2. Click on the “Activity” tab
  3. Click on the “Mentions” tab
  4. Add to your spreadsheet, along with other necessary column information

Same for Instagram

Okay to do this in Google Sheets.