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

Shane Holmes
Shane Holmes
Fourth Anniversary Kudos 1 Facilitator 1
in Blackbaud Altru® General Discussions

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

Thanks


Shane

Tagged:

Comments

  • John Ryan
    John Ryan
    Seventh Anniversary Kudos 2 Participant Facilitator 1

    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.

    0ab9d20ec89e9d2faef97d52f1b64f8a-origina
  • Shane Holmes
    Shane Holmes
    Fourth Anniversary Kudos 1 Facilitator 1

    Thank You!


    Shane

  • John Ryan
    John Ryan
    Seventh Anniversary Kudos 2 Participant Facilitator 1
    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
    Regina Holten
    Tenth Anniversary Kudos 5 Name Dropper Participant

    oh, this is juicy! thank you!

  • Regina Holten
    Regina Holten
    Tenth Anniversary Kudos 5 Name Dropper Participant

    Is this a Constituent or Sales Order query? Thanks again

  • Shane Holmes
    Shane Holmes
    Fourth Anniversary Kudos 1 Facilitator 1

    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)

    a9afdba574552746ed9cfc3e3a41147b-origina
  • Shane Holmes
    Shane Holmes
    Fourth Anniversary Kudos 1 Facilitator 1

    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
    John Ryan
    Seventh Anniversary Kudos 2 Participant Facilitator 1
    Use primary email address rather than just email address. Multiple email addresses may be causing your dupes.
  • Shane Holmes
    Shane Holmes
    Fourth Anniversary Kudos 1 Facilitator 1

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

    Shane

  • Tamara Christensen
    Tamara Christensen
    Ninth Anniversary Kudos 3 Name Dropper Participant

    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
    Shane Holmes
    Fourth Anniversary Kudos 1 Facilitator 1

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

    bd0954cfb27fbf63009028884db6a107-huge-sc

Categories