Key Vega Queries

Here are some key Vega queries are:

All Contacts By Attribute / Attribute Type - This is one of the most useful Vega Query that allows you to list the contacts that has a specific 'Attribute Type' and/or 'Attribute'. You can get the list based on whether the contacts are 'OK to contact' or with/without an email address.

All Contacts with Emails - This query gives you the contacts with an email address. There are 2 types of queries - one that returns all contacts with an email address and other that gives contacts with an email address but no physical address. 

Widget Results - This shows all widget results in the given time frame, from Donation, Membership, Registration, Survey, Event, Contact Us and Unsubscribe widgets.

All Contacts (OK To Contact) - This query gives the option to export all contacts that are Ok to contact.

All Current Members - This query gives the list of all members where the membership end date is greater than or equal to today. There are also similar queries to get the list based on whether the contacts have an email address or not.

All Members Due For Renewal - You can get the list of members that are due renewal on a specific date.

All Regular Contributors (OK To Contact) - It gives you a report of all current (Active) Recurring Donors List

All Current Contributors (OK To Contact) - You can get the list of contacts that donated in last 2 years.

All Successful Payments - This shows all the successful payments, it also includes the payments from contacts that are not OK to contact. There is also another query to get a list of successful payments in last month. 

All Members - If you want a list of all contacts who have been members ever, this is the query you are looking for.

All Contacts (Active) With Relationships - Gives you a list of all active contacts with relationships filtered by relationship.

All Contacts With Relationships And Attributes - This gives you a list of all contacts with selected relationship and attribute.

All Declined Payments - You can get the list of declined payments for a given time period. 

12 Month Email Metrics - This gives the overall email metrics for all the email campaigns sent from vega in the last 12 months.

All Lapsed Contributors (Ok to contact) - This shows the contacts that are Ok to contact with no gift in the last two years.