Hello!
A little background: We are TNEW and Wordfly users. We have been on Wordfly for a little over a year, and we have been using the Wordfly email signup page for email signup on our website. Over this time, we have also uploaded lists in to Wordfly manually outside of Tessitura (from our previous email system and various other lists we have acquired outside of Tessitura). So, we have email accounts in Wordfly that do not have an associated Tessitura ID. I would like change our email operation so that we are using the Tessitura/ TNEW brief account signup page for our email signups, and use Tessitura as the baseline for all Wordfly lists. In Wordfly, we do have a group of email accounts with a high engagement rating but no corresponding Tessitura ID. So we don't lose out on contacting this group, I would like to do a constituent import so that we can include this group in our Tessitura segmentation moving forward. Before doing the import, I'd like to compare ALL Tessitura emails with these Wordfly emails in Excel, to see what emails might exist in Tessitura as non-primary emails.
So, my primary question is - how can I output ALL Tessitura emails from Tessitura so I can then compare to the emails from Wordfly? The standard eaddress output criteria is based on the primary email address of an account.
Thanks for any insight you have on this!
Andrew
We did the same centralizing our marketing almost exactly 2 years ago. I went about it the other way and exported all of the WF customers as WF Subscriber lists. Then bulk matched the email with VS_EADDRESS (in Tess) and if there was a match pulled the Customer_no. We wanted to keep the WF Subscriber List info, so if there was a match I added that list as an attribute in Tessitura and (if relevant) opted them into the Tessitura interest or Contact Point Purpose.
The remainder that didn't match I used constituent import to get them in - made sure I saved them into a list - and updated the relevant interest/attributes from whence they came.
I was a monster job but really stopped us sending 3 versions of the same email to the same person because we had their details all over the place. Now we can do one Extraction waterfall for a Production and not spam people until they optout.
Hi Heath,
Thanks so much - your process explanation makes sense and I may try to match that in some way. I like the concept of preserving the Wordfly lists for future use. Do you have a suggestion for the best way to pull out the T_EADDRESS and corresponding Tess ID from Tessitura? Perhaps with a special output set? I have been struggling to pull out the non-primary email addresses.
Thanks again,
how sequel-y (that's a word right? ie: SQL) do you want to get? The code is pretty simple and as I was modding the process as I went it went that way.
So I went for Primary both 'Y' and 'N' - but active eaddresses only
Hi Heath - great timing, as I was able to do a simple pull in our SQL Server Management Studio. I admit that while I have a general understanding of SQL, my biggest struggle is understanding how everything is connected in Tessitura. But in summary, I was able to do a simple query:
select * from T_EADDRESS
and I was able to save a CSV file of all email addresses - and I noted that there were some Tess ID's that had multiple rows (multiple email addresses), so my hope is that I found them all!
So I think I found what I was looking for! Thanks so much for following up and your insight, seeing all the numbers of what does/ does not match up between Wordfly and Tessitura puts the scope of this transition in to much better perspective.
So WF outputs to a spreadsheet. I pulled huge list of address in by =concatenate("'", , "',") to get 'heathwilder@hotmail.com', from the email address in E2 and fill down the whole sheet. Then you can cut paste that into the and address in ( ) below.
____
In SQL to get Primary on top and most recent customer_no as vlookup will us the first eaddress it finds
use impresarioselect address, customer_no, primary_ind, from VS_eaddress ejoin VS_constituent c on e.customer_no = c.customer_no
where e.inactive = 'N'and c.inactive = 1and address in (
'heathwilder@hotmail.com', 'heathw@sydneydancecompany.com', .... --from WF as above)
order by primary_ind desc, e.customer_no desc
___
Once you get the result from SSMS paste it in a new tab of your WordFly data spread sheet and use a VLOOKUP to match the WF email address to the SSMS data and return the customer_no. Anything with out a customer_no is the thing you want to import. If it does have a match then import customer_no's into a Tessitura list and make sure that they get updated with WordFly list info (attribute/interest/etc)Hope that helps (can't resist kibozing myself)