When you use manual campaign tracking variables the value of the utm_content tracking parameter is displayed. When you use AdWords with auto tagging enabled the first line of the text from your text ad is displayed as the value, otherwise the value is set to (not-set). This dimension can be used in the Google Analytics segments feature.

When written in queries it appears as: