Campaign Link Tracking Worksheet

If you are new to campaign tracking, please read Outreach Campaign Link Tracking before following the instructions on this page.

The instructions below show how to use a Google worksheet to set up and keep track of your campaign data.  The advantages of using a worksheet instead of the Google URL Builder are that multiple people can collaborate and you’ll have a record of all the campaign links you’ve created in the same document.  This will help you keep the labels consistent.  For example, whenever you create a campaign link to post in Facebook, you’ll want to use facebook as the “source”, not Facebook. Google Analytics is case sensitive so these would be counted separately.

Starting a New Worksheet

  • Log into Google Drive in another browser tab
  • Click the link below:
    Download the Multi-User Campaign Tracking Worksheet (Google Sheet)
  • Save Copy of Campaign Worksheet

    Save Copy of Campaign Worksheet

    Save a copy of the worksheet in your Google Drive (see illustration).  You may want to check the sharing settings on the new document by clicking Share on the top right of the Google Sheet.


Campaign Example

For this example, we’ll set up links to promote the Fine Arts Alumni home page on Facebook, Twitter and in an email newsletter.

Details about the campaign

Details about the campaign

We’ll use fa-alumni-spr16 as the Campaign (short for Fine Arts Alumni Sprint 2016) for the three links.  You can use whatever makes sense to you. The columns for Start Date, End Date, and Opportunity are for your own record keeping and are not required to create the links.

We’ve filled in the four required cells with the following values:

  • Actual Landing Page (
  • Source (facebook)
  • Medium (the Medium for any post to a social network like Facebook & Twitter would be social)
  • Campaign (fa-alumni-spr16 – short, descriptive, and only uses lower case characters and numbers)
Required - Source, Medium, and Campaign

Required – Source, Medium, and Campaign

As soon as the required fields are filled in, the Final Landing Page URL is automatically created in the column labelled Final Landing Page URL.  This is the link you will paste in Facebook.

Alumni Page URL with added parameters

Alumni Page URL with added parameters

The following image shows how the worksheet might look after adding parameters for Twitter and an email newsletter for the same Campaign:

example of campaign details for alumni campaign

On the rightmost column of the worksheet you’ll notice a column labelled Shortened Link.  If you need a short link for printed materials such as a postcard, use the University Short Links Service (

Learn More:

4 Steps to Better Campaign Data in Google Analytics

Using a Campaign Worksheet:

Leave a Reply