Audience keys in reporting schemas

When you configure the audience level for performance reports and response history or when you create reporting schemas for additional audience levels, you must specify the audience key for the audience level.

If the key includes more than one database column (sometimes referred to as a multikey audience key), you use commas between the column names. For example, ColumnX,ColumnY.

The maximum length of the string you can enter in the Audience Key field of a reporting schema is 255 characters. If the audience key is longer than 255 characters, you can work around this restriction in the generated SQL. Enter the first 255 characters of the key in the Audience Key field and generate the SQL script as usual. Then, open the generated script in an editor and replace each of the truncated audience key references with the complete string.