• Replies 2 replies
  • Subscribers 332 subscribers
  • Views 46 views
  • Users 0 members are here
Related

Tracking Vimeo subscribers in Tessitura

Michele Keutsch
$organization

We've recently gone live with Vimeo OTT for our streaming platform. As our patrons move over from our custom streaming platform to Vimeo, we are manually searching on the email address to find them and cancel their subscription on our custom platform. 

Moving forward, we'd like to somehow indicate which patrons have registered in Vimeo so that they get excluded from any acquistion emails that we send out through Prospect2, but all we have is an email address. 

My thought is to use a constituency with a start/end date based on the sub start and end date in Vimeo that we update each time we need to do an extraction, but my issue is how do we find all the ID's in Tessitura when all we have is an email address from Vimeo? 

  • $organization

    Do you know how to custom code a listmaker list?  If so, you can set up the commas and apostrophes in Excel, then put your comma separated 'eaddresses' instead of my examples.  If you have a lot of emails, it could exceed the character limit, requiring multiple such lists.

    SELECT DISTINCT a.customer_no
    FROM V_CUSTOMER_WITH_PRIMARY_GROUP AS a WITH (NOLOCK)
    INNER JOIN
    (SELECT a1.customer_no
    FROM vs_eaddress AS a1 WITH (NOLOCK)
    WHERE
    a1.address in (
    'huffer@gmail.com'
    ,'puffer@yahoo.com'
    ,'blower@outlook.com'

    )
    -- and ISNULL(a1.inactive, 'N') IN ('N')
    ) AS e
    ON e.customer_no = a.customer_no
    WHERE a.inactive = 1
  • $organization in reply to John Trimble

    Thanks John. After posting I thought about creating a custom table with the vimeo data and we can create a list of ID's to exclude that way as well.