Query Fields for Event Attendee business name, address, and primary contact

Maddy Lamers

Hi all!

I'm going a little crazy learning queries, and was asked to pull business name, primary contact name, and addresses for the contacts/businesses that participated in an event. I've figured out how to pull the business name and event, but I can't figure out which fields to pull to see the primary contact name (the person checked to be the contact for that business) or the address associated with that person. Can anyone point me to some things to try? I'm just not sure what else to try! Any advice is welcome.

Thanks!

Austen Brown

Hi @Maddy Lamers - Welcome to BB Community! The best way to pull this information is through an Export, you'll want to indicate that the individual relationship to the business is a “contact” and what “contact type” you are looking to include. If you want to include the contact's personal address (the preferred listed on their record), you will also need to include their constituent ID within the export; you can utilize the ID field to separately search for that record's preferred address to be brought in manually into your export (recommend you utilize the VLOOKUP formula in excel to aid in this process).