What reports show/group by source media?

Stephen Geahry $organization over 16 years ago

Hey all-

Just looking at maybe doing a little more slicing and dicing with source code reporting and wondering what reports group by the source code media field? It's not a field we currently use.

Thanks,
Steve

Parents

Anna Wessely (Past Staff Member) $organization over 16 years ago

This is a great candidate for a custom criterion for lists and extractions. When running lists based on promotion response you can then filter by media - i.e. people who responded to an email offer in the last 6 months, or suppress people who have received the brochure for 5 years with no response.

Here is a sample of the entries in T_KEYWORD for a criterion for promotion media:

DESCRIPTION	Promotion Media
DATA_TYPE	Number
EDIT_MASK	vs_promotion
DETAIL_TBL	!.media_type
DETAIL_COL	tr_media_type
REF_TBL	id
REF_IDCOL	description
REF_DESCCOL
REF_WHERE
REF_SORT	Promotions
CATEGORY	List Only
USE_FOR_LIST
MULTIPLE_VALUE
CONTROL_GROUP
CUSTOM_ID
CUSTOM_LIMIT
CUSTOM_REQUIRED
CUSTOM_DEFAULT_VALUE
INCL_IN_BASIC_SEARCH	N
KEYWORD_DESC

Best,

Anna

Anna E. Wessely

Manager Asia Pacific/Senior Application Specialist

Tessitura Network, Inc

+1 888 643 5778 x 308

awessely@tessituranetwork.com

www.tessituranetwork.com

Reply