Telemarketing Data Pull

Hi Brian,

We use an output set to pull data for our telemarketing firm – using the Ticket season and ticket performance name, as well as subscription season and pkg. It returns a million rows, but the telemarketing firm uses that.

Adrienne

From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Brian Jones
Sent: April-22-13 2:35 PM
To: Adrienne Steer
Subject: [Tessitura Shared Reports Forum] Telemarketing Data Pull

Normal 0 false false false EN-US X-NONE X-NONE

While I'm putting in a ticket on TASK, I'm curious if the community has any thoughts on a situation I presently find myself in ...

I'm trying to cobble together a few data sets for a telemarketing firm that's working with us, and I'm wondering what the easiest way is make the dream a reality. Here's what my telemarketing friends need--
 
All the standard constituent information like:
Constituent ID
Salutation
First Name & Last Name
Address
City
State
Zip
Phone #s
Email

All of that's pretty easy to get at in a single place, so I'm not too terribly stressed about that. I have my extractions already together and have saved the lists, so this info is easy. HOWEVER, I'm having trouble figuring out how best to also include the following information that my tele-friends desire:

Up to 8 year ticket purchase info for subscriptions and single ticket purchases, including ...
Performance Date
Performance Name
Subscription Year & Series (if applicable)
Total Cost of ticket or Subscription Purchase
# of Seats purchased
Seating section/location

So what I'm currently considering is cross referencing different reports and combining the data into one sheet for my telemarketers. However, I've yet to find the combination of reports to make this happen. That said, if there's a smarter (or easier) way to do this using something like SQL, I'm game to giving it the old college try (with a little bit of coaching). Knowing what I know about SQL, I'm actually wondering if this would be terribly easy in SQL if one were so inclined as to know how to tease out such information? I presume somebody somewhere out there has done this without creating custom reports and the like?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the 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!

Hi Brian,

We use an output set to pull data for our telemarketing firm – using the Ticket season and ticket performance name, as well as subscription season and pkg. It returns a million rows, but the telemarketing firm uses that.

Adrienne

From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Brian Jones
Sent: April-22-13 2:35 PM
To: Adrienne Steer
Subject: [Tessitura Shared Reports Forum] Telemarketing Data Pull

Normal 0 false false false EN-US X-NONE X-NONE

While I'm putting in a ticket on TASK, I'm curious if the community has any thoughts on a situation I presently find myself in ...

I'm trying to cobble together a few data sets for a telemarketing firm that's working with us, and I'm wondering what the easiest way is make the dream a reality. Here's what my telemarketing friends need--
 
All the standard constituent information like:
Constituent ID
Salutation
First Name & Last Name
Address
City
State
Zip
Phone #s
Email

All of that's pretty easy to get at in a single place, so I'm not too terribly stressed about that. I have my extractions already together and have saved the lists, so this info is easy. HOWEVER, I'm having trouble figuring out how best to also include the following information that my tele-friends desire:

Up to 8 year ticket purchase info for subscriptions and single ticket purchases, including ...
Performance Date
Performance Name
Subscription Year & Series (if applicable)
Total Cost of ticket or Subscription Purchase
# of Seats purchased
Seating section/location

So what I'm currently considering is cross referencing different reports and combining the data into one sheet for my telemarketers. However, I've yet to find the combination of reports to make this happen. That said, if there's a smarter (or easier) way to do this using something like SQL, I'm game to giving it the old college try (with a little bit of coaching). Knowing what I know about SQL, I'm actually wondering if this would be terribly easy in SQL if one were so inclined as to know how to tease out such information? I presume somebody somewhere out there has done this without creating custom reports and the like?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the 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!