• Replies 10 replies
  • Subscribers 332 subscribers
  • Views 435 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!

  • $organization

    Yes, it is possible. Here's more info (other articles also available): https://support.wordfly.com/hc/en-us/articles/204768504-Email-responses-and-the-Tessitura-integration

    This is helpful for segmenting in Tessitura extractions/lists rather than using WF's segmentation.

  • $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

  • $organization
    Tessitura constituent records will display the "highest ranked" response; WordFly all instances of them. WordFly also has details about device, etc that don't--at least without undertaking a bunch of custom work--pass back to Tess.

    Beware though--there is a significant reporting error in terms of Opens. I have no reason to suspect accuracy of unique responses, but some addresses will record dozens of opens with the variation between them being literally half seconds. For us, these all display as happening via Firefox; peers have confirmed similar trends though not necessarily identical presentation. I was able to truly confirm the issue as false data when two of the people with the slew of responses were my co-workers, who were able to swear that they had not even had Firefox running in recent history. WordFly tech has been able to trace this to an issue involving Google image servers, but not yet found a solution. I have no idea if this applies only within the US or is more global. 

    I generally prefer to focus on the 'unique' customer count etc so don't necessarily view this as a huge problem, but it's disappointing to know that I have to discount most of the nice dashboards and graphs about how people are viewing our campaigns.
  • $organization in reply to Jamie O'Brien

    Thanks for bringing up the Firefox problem. I've found in my testing that the "open" is erroneously attributed to Firefox, but a "click" is attributed correctly (Gmail, etc).

  • $organization in reply to Haley Rayburn

    Just fyi, if someone registers an Abuse Complaint on one of your WordFly campaigns, by default that registers as an Unsubscribe in Tessitura. You'll have to create an Abuse Complaint response in Tessitura. 

  • $organization in reply to Karen McKevitt

    That's interesting, I think that we do have it set up that way, but our CRM manager would know more about that.

  • $organization in reply to Karen McKevitt

    This page was very helpful, by the way!

  • $organization in reply to Jamie O'Brien

    Do a search on Google's Gmail image caching and it will explain this issue. In a nutshell, Google caches images received and their user agent is regularly Firefox.

  • $organization in reply to Karen McKevitt

    I should clarify that my testing was on my own WordFly account. I do not have Firefox installed on any of my devices, yet all of my opens were attributed to Firefox.