Report of names and email addresses from web forms e-tickets sales?

Shane Holmes

How to create a Report of names and email addresses from web forms e-tickets sales?

Thanks

Shane

John Ryan

This query pulls data such as you want but you'll want to tweek it to your specific needs. It currently captures non member ticket buyers after their visit date.

Shane Holmes

Thank You!

Shane

John Ryan

It is in analysis. Create an ad hoc query using these parameters or knes specific to your needs ( for example, don't include the one omitting members from the output if you want them included.).

Regina Holten

oh, this is juicy! thank you!

Regina Holten

Is this a Constituent or Sales Order query? Thanks again

Shane Holmes

I got this query to give me what I need , but it seems to have duplicate records. I dont know if its because its pully from two different tables (Sales Orders, Constituents)

Shane Holmes

It draws data from both, but the main source view is Sales Order

From Menu, choose Analysis, Information Library

Add an Ad-Hoc Query

Source View = Sales Orders

I believe it then has relationships with many other tables you can select from - e.g. Constituents

John Ryan

Use primary email address rather than just email address. Multiple email addresses may be causing your dupes.

Shane Holmes

Thanks John, I used Primary Email Address and I get the same results

Shane

Tamara Christensen

It is weird, you would think that choosing primary email address or the primary anything would then give you just one, but it never works out that way.

Shane Holmes

Here is what I ultimately ended up with for the query (see screenshot). Note the starting data source is Constituents and not Sales Orders.