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:

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 on 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

  • Create a spreadsheet. You can use Google Sheets or Microsoft Excel.
  • Save the file using the syntax “[Subject Name]_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 4 columns for authority-- 3 to score each of the components and then a grand total column.
Image

When you find an article, podcast, or mention online, copy the link and paste it 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.
Image

How to Find Mentions Online:

  1. Type the subject’s name into Google
  2. Click on the “News” tab
  3. Scan URLs/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
Image
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
Image

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
Image

Same for Instagram

Image
Okay to do this in Google Sheets.