Using auto-generated UTM tagged URLs within Google AdWords along with auto-tagging for Google Analytics
You want to use Google AdWords' auto-tagging for a deep integration with Google Analytics, but you need to use UTM parameters with your other analytics and marketing systems, but don't want to manually tag all of your ads.
Within AdWords, you can use ValueTrack and custom parameters along with a tracking template to automatically generate a tagged URL with all of the information you need. A tracking template which populates the query string with campaignid, adgroupid and keywork looks like this:
{lpurl}?campaignid={campaignid}&adgroupid={adgroupid}&term={keyword}