How to Update Content Library

Workflow [IMPORTANT]:

Spreadsheet Template:

Enterprise: Content Library Template
ChiroRevenue or Chiropractors: TEMPLATE Chirorevenue Content Library

Overview:

Steps:

1. Set Up the “Content Library” Spreadsheet



A. Open the Content Library spreadsheet in Google Sheets.

B. Click File > Make a Copy.


Image
C. Rename the sheet using this format: _mentions_. Select a location to save the file and click OK.

Image
Note: Version number depends on how many times a file is recreated. For this instance, the first version is BrennanAgranoff_mentions_1 and the second version of the same file would be named BrennanAgranoff_mentions_2

D. Once the copy is made, share the file by clicking Share on the upper right.

Image
E. On the Share with others window, enter the email address/es of the people you need to share the file to (which is also indicated in the document) and click the pencil icon on the right side to enable the ‘Can edit’ option. Click Send.

Image

2. Update “Video Library” Sheet


A. Search for the subject on

  1. Google
  2. Facebook
  3. Instagram
  4. LinkedIn
  5. Twitter
  6. Youtube

B. Scan videos for mentions of your subject

C. Check if the video is already in the spreadsheet

D. Add new videos to the “Video Library” sheet

Select “Video Library” tab

  1. In the “Video Title” column, add the title of the video
  2. In the “URL” column, add the URL of the video
  3. In the “Duration” column, add how long the video is in the format 0:00:00

    • E.g. a 1 hour video would be marked as “1:00:00”
    • E.g. a 2 minute and 30 second video would be marked as “0:02:30”
  1. In the “Date Posted” column, add the date the video was posted
  2. In the “Notes” column, add a short description of the video
  3. In the “Type of Content” column, indicate where you found the video

    • E.g. Facebook Video
    • E.g. IGTV

Video: https://www.loom.com/share/4ab2c6e3fd4248c8971ae1ec638cf766


3. Update “FB Content” Sheet


A. Search for the subject on Facebook

  1. Scan posts, videos, and photos for mentions of your subject

B. Check if the post is already in the spreadsheet

C. Add new content to the “FB Content” sheet

  1. Select “FB Content” tab
  • In the “Date” column, add the date of the Facebook post
  • In the “Time” column, add the time of the Facebook post
  • In the “Content” column

    1. 1 If the post has text
      • Copy and paste the text from the Facebook post
    1. 2 If the post does NOT have text
      • Write a short description
  • In the “URL” column, add the URL of the Facebook post
  • In the “Content Type” column, select the type of post
    1. 1 If the post has text
      • Copy and paste the text from the Facebook post
D. Add new videos to the “Video Library” sheet

Select “Video Library” tab

  • In the “Video Title” column, add the title of the video
  • In the “URL” column, add the URL of the video
  • In the “Duration” column, add how long the video is in the format 0:00:00

    1. E.g. a 1 hour video would be marked as “1:00:00”
    2. E.g. a 2 minute and 30 second video would be marked as “0:02:30”
  • In the “Date Posted” column, add the date the video was posted
  • In the “Notes” column, add a short description of the video
  • In the “Type of Content” column, indicate where you found the video

    1. E.g. Facebook Video
    2. E.g. IGTV

Video: https://www.loom.com/share/4ab2c6e3fd4248c8971ae1ec638cf766


Image
Note: Version number depends on how many times a file is recreated. For this instance, the first version is BrennanAgranoff_mentions_1 and the second version of the same file would be named BrennanAgranoff_mentions_2

D. Once the copy is made, share the file by clicking Share on the upper right.

Image
E. On the Share with others window, enter the email address/es of the people you need to share the file to (which is also indicated in the document) and click the pencil icon on the right side to enable the ‘Can edit’ option. Click Send.

Image
Plumbing is the basic foundation that will allow for remarketing to website visitors. With plumbing properly configured, you will be able to analyze which website visitors are buyers, build custom audiences, and run warm traffic through the 6 Phase Social Amplification Engine to convert.

The plumbing setup uses a central tool called Google Tag Manager (GTM). The tool is used to easily manage all tracking pixels on a website (Facebook, AdWords, Google Analytics, etc.)

By setting up and installing GTM, we set the stage to create powerful marketing campaigns inside of Facebook and Google AdWords.

Let's do it!

What happens next?

After you purchase the EXPRESS: Digital Plumbing package, we'll need to understand your goals, content and targeting (GCT). You can complete our strategy "GCT" form immediately! As soon as you sign-up we'll be able to gauge what you're doing well, what you'll need to improve on and where we can intervene and help.

We have this in place to ensure you that your hard-earned cash is put into good use.

What we will do for you...


  • Create your Facebook Ads account using "Business Manager."

  • Create your Google Ads account and tie it to your Google Manager Account.

  • Create your Google Tag Manager (GTM) account.

  • Create your Google Analytics account.

  • Set up Google Analytics with GTM.

  • Create your Website Custom Audience on Facebook.

  • Set up Facebook Pixels & Standards Events with GTM.

  • Set up Google Remarketing Pixel using GTM.

  • Set up AdWords Conversion Tracking with GTM.

  • Publish your GTM container and tags to website.

  • Verify everything is set up correctly.

Let's do it!

-