• Replies 10 replies
  • Subscribers 332 subscribers
  • Views 438 views
  • Users 0 members are here
Related

WordFly and Tessitura integration - also posted in Research and Analytics

Haley Rayburn
$organization

I've recently been involved in trying to track email analytics. I'm wondering if anyone knows if it is possible to pull email, click and/or any other type of email analytical data from Tessitura? I'm trying to pull information into Tableau, I had been using excel but want to see if there is a more integrated/automatic solution.

What I really need to know - Is WordFly writing to Tessitura tables, or is it just linking to the emails/customer information?

Thanks for any help anyone can give!

Parents
  • $organization
    If you use WordFly right, records are promoted in Tessitura and then updated by WordFly.  Using it right involves sending eblasts through  WordFly to lists set up in Tessitura extractions or listmanager. 
     
    I.e.
    A) You create your extraction and extract constituents, creating a file that (if your implementation is set up properly) WordFly can interact with. If you checked the TMS box when you extracted,  constituents show up in WordFly ready to be emailed.
    OR
    B) You create your list in listmanager, check the TMS box and promote from within WordFly as part of the Wordfly import process.
     
    Consequently WordFly updates the promotion records in Tessitura with opens, click-throughs, bounces…
     
    Once you have the Tessitura ID numbers and promotion records, you can get to almost anything else in Tessitura for analysis, i.e. beyond just opens and clicks. 
     
    If you just paste excel-loads of email addresses into WordFly, there’s no further automatic data updates from WordFly into Tess, so don’t do it that way unless maybe a list from another non-Tess source.
     
     
     
     
  • $organization in reply to John Trimble

    Thanks! I've been able to find the click/open/etc data, I don't work on the setup end. I was able to find the Screens Table Reference, which helped isolate the data I was looking for.

    I just wonder how much data does WordFly write to tessitura? Because, there is a lot more info about these types of emails in the individual emails in WordFly than seems to be connected to the constituent records

Reply
  • $organization in reply to John Trimble

    Thanks! I've been able to find the click/open/etc data, I don't work on the setup end. I was able to find the Screens Table Reference, which helped isolate the data I was looking for.

    I just wonder how much data does WordFly write to tessitura? Because, there is a lot more info about these types of emails in the individual emails in WordFly than seems to be connected to the constituent records

Children