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 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.
For this example, we’ll set up links to promote the Fine Arts Alumni home page on Facebook, Twitter and in an email newsletter.
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 (http://finearts.utexas.edu/alumni)
- 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)
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.
The following image shows how the worksheet might look after adding parameters for Twitter and an email newsletter for the same 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 (http://links.utexas.edu) or goo.gl.
4 Steps to Better Campaign Data in Google Analytics
Using a Campaign Worksheet: