To evaluate campaigns and analyze the impact of various media channels, you need to be able to identify every source of traffic. You probably are already doing this now by
connecting Google Analytics with your AdWords account and by customizing links from other purchased channels with custom campaign parameters. Google’s
URL builder is often used to generate these links containing campaign parameters.
In large organizations, it is not uncommon for different parts of the organization to purchase and drive traffic to the website. One group might be responsible for paid search, another for affiliates, and a third for driving traffic from social media. This division places high demands on the structure of your data if you want to be able to compare the various media channels or see the combined effect of a campaign – no matter which channel the message was communicated in.
To set a naming convention for campaign names and decide how to name all media channels is challenging when many people within the organization must comply to the naming guidelines. Without having consistent definition of the site’s traffic sources, it is also more difficult to create attribution models, as these require good-quality data in order to be reliable.
To simplify the generation of consistent links tagged with custom campaign parameters Outfox, a GACP and Google Analytics 360 Reseller, have developed
GA Campaign URL, an add-on for Google Sheets. This tool helps you to create tag sheets, where you can guide users regarding which parameters are to be used and let users select, for example, the medium, sources, and campaigns in
drop-down lists. Since you can easily share the spreadsheet among various users and control (by using permissions) which users can add and change the values in drop-down lists, you can create tag sheets tailored to the needs and organization of your company.

Read more about how to use
GA Campaign URL on our Help page or
install it for Google Sheets!
Posted by Christoffer Luthman, Director of Analytics at Google Analytics Certified Partner Outfox