Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Profile data can be filtered and exported in a range of formats. A range of filters, including custom fields, can be used to tailor the data that is exported.

Info

🎥 Video tutorial: Export profile data

Warning

IMPORTANT: The Export Profile Data tool allows you to download private

...

profile data. For more information on how to ensure your data remains secure refer to the page What You Can Do To Protect Your Data

From the menu on the left select Export Data > Profile Data.

Image Modified

A range of filters can be added to an export to tailor the information that is exported. These include any system and custom fields suitable to be used as filters (ie. not free text fields and file attachments) as well as filtering by Profile Relationships.

Select filters

To select a filter simply click in the relevant field and select from the list of options. If you know the field option you are searching for you can start typing and it will appear in the list.

Tip

Remember the more filters you apply to your export, the fewer results that will be returned.

...

Image Added

Relationship filter

Click on the Get field at the top of the list of filters to display the dropdown menu.

From the list you can see an option for the Parent and Child of each Profile Relationship you have set up (the name of the Profile Relationship is displayed in square brackets). The Parent for each relationship will always display first.

Select the relevant option to apply the filter.

For example, in the image below if we want to obtain a list of all Employers from the Organisation Relationship type we would select the [Organisation] Employers of Employees where... option.

...

Image Added

Export data in custom fields

You can also export data from any custom fields you have created to Excel.

At the Include Custom Fields box, select any fields you wish to include in your data export.

Image Modified

Export or view your data

Once your filters have been selected, you can now export the matched profiles in a number of ways:

  • Excel - the profile information is exported to an Excel spreadsheet

  • PDF - a list of matched profiles to PDF that can be emailed or printed

  • Data Table - A searchable on-screen list, which allows you to sort and quickly search full lists of profiles

  • Heat Maps - for more information refer to the Data Visualisation section below

...

Image Added

Data Visualisation

membes allows you to visualise where profiles in your database that meet certain criteria are on a heat map. Working with the various filters will create some very powerful insights into your association and membership.

For example, you can see where your members are located, or where new members in the past 6 months are, or where most of your lapsed members are, etc.

Filter your records as you would to export a list of profiles and click the Heat Map button to display the map.

Image Modified

Table of Contents
minLevel1
maxLevel2