• Replies 4 replies
  • Subscribers 333 subscribers
  • Views 58 views
  • Users 0 members are here
Related

What reports show/group by source media?

Stephen Geahry
$organization

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

  • $organization

    Hi Steve,

    I didn't mean to reply to the group, but since it's posted I should at least clarify. The Media Type field from Sources is available as a field in T-Stats. Feel free to send me a conversation if you'd like to hear anything more about that.

    Chris



    [edited by: Chris Wallingford at 12:19 PM (GMT -6) on 5 Jun 2009]
  • $organization

    No standard reports group sources by media.  The primary purpose of the media field is to record media related expenses (like the per piece cost of a brochure) for sources.

     

    -Kevin

     

  • $organization

    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

     

  • Former Member
    Former Member $organization

    Steve-

     

    Chris had that question mark in his answer about T stats and so I had to try it out and Media type does exist under Ticket Appeals (just in case you were wondering) in the Tickets Cube.  I never really went looking for it.  Thanks for sending me that way!  It seems to work.  We use that field but never really use it again.   But now that I see I can pull the data out in T-stats.. it gets me thinking!!

     

    Thanks!

     

    Amanda Sheehan

    Ticket System Administrator

    Cincinnati Playhouse in the Park

     

     

     

    From: Stephen Geahry [mailto:bounce-stevegeahry9525@tessituranetwork.com]
    Sent: Thursday, June 04, 2009 8:39 PM
    To: Amanda Sheehan
    Subject: [Tessitura Marketing Forum] What reports show/group by source media?

     

    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




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

    P Please consider the environment before printing this email.