Membership Report Generator
Build custom lists of members for renewals, birthdays etc.
Build custom lists of members for renewals, birthdays etc.
The Membership Report Generator is a powerful tool that allows you to create lists of members according to various criteria.
When you first open the form, it will default to the Custom Report option as shown in the image above. This then allows you to filter the member records that will be returned according to various different fields. You can set values for any number of these fields in combination;
Next there are a selection of date fields. As with Age, you can select a From Date, a To Date or both;
The next section of choices relate to Postcodes. If you’re trying to contact members within a certain geographical area, this section can help. The choices here are;
You can add as much or as little of the postcode as you require here – for example all postcodes starting ‘C’, or all postcodes starting ‘CM3 1Q’.
Next is a section of filters around the choices customers have made about marketing communications. As above, Not Specified means ‘Either’ for these selections, and is the default;
Next you can filter members by the interests they have ticked on their membership record. You can add interests in Membership>Membership Settings on the Lists tab. Select the Interests radio button. Naturally only members created or edited after you add an interest will be able to have that interest selected in their record. This list can scroll if you have more than 6 interests to choose from.
Finally, there’s an option ‘Only quick create’ to only include members whose record has been created using the quick create option. This is so that you can identify those members whose records only have the basic details stored and so need to be completed on the system to remove their Quick Create status, but filter them using the previous options.
In addition to the custom report, there are some preset reports that you can choose to generate. These are listed on the left as radio buttons, and all fullfil specific purposes relating to membership and renewals etc. These are as follows;
With all reports you can choose how to sort the results using the Order by drop-down. MemberID is the default but you can choose from;
There is also the option to use ‘Reverse order’, so Z-A rather than A-Z, newest to oldest rather then oldest to newest etc.
Once you have made your selection of report type or criteria, and chosen the desired sorting order, simply press ‘Generate’. Your report will be built and a list of members created. The report will always have every avaiable field shown, even if they’re hidden in your membership form setup. These are as follows;
The report displays like this;
At the bottom of this form you can see various buttons that allow you to work with the data. View Member lets you view the selected member in the normal membership form, but with scroll options that will allow you to move back and forward through the selection.
You can also edit the member by clicking the Edit button here. You’ll then be able to amend details and Save prior to working further with the report.
Add Member allows you to include in the list somebody who hasn’t met the criteria for the selected report, whether it’s a custom report or one of the standard lists. You’ll see a search screen, and matches will appear for whatever you type. Once you have found the required member, click Add Member at the bottom of the screen and they’ll be added to the list. If they’re already in the list, their name will be selected and you’ll see a message to that effect.
Remove member allows you to take members out of the list even though they match the chosen criteria. You’ll be asked to confirm that you wish to remove them;
If you answer yes the selected member will be removed from the list. You can then add them back in if required using the Add Member option.
Next to the green member edit buttons is the Save Template button. This is really only applicable to custom reports, though there’s nothing to stop you from saving any of the standard reports as a new template and then editing them to your requirements. All that’s required for saving a template is a name, which you’ll be prompted to enter.
Next is the Export button, which is where the real power of the Membership Report Generator lies. As with all reports in Memsec7, clicking the Export button provides a number of options, though here there are more than usual;
As usual, there is the option to Export the list to a CSV (Comma Separated Values) file, or an Excel spreadsheet. Again as usual, these can also be emailed rather than saved locally.
The last 3 options here are where you’re able to use the list of members in order to send them marketing material.
This option provides a means of sending an email shot to your selection of members. You’ll be presented with a screen like this;
In order to send an email in this way you must first create a template, which you can do under General>Email Settings on the Templates tab, Membership selection. For more about this, see our help page here.
You can see at the bottom of this template selection screen the number of members selected. This might differ from the number of results in your overall report, as you may only send marketing emails to those members who’ve explicitly agreed to this. If the email you want to send is not a marketing email, you can tick the box at the top to signify this, and the number of members selected will most likely increase to include all members in the list with an email address.
All you need to do once you’ve selected the relevant template is enter a subject line for the email, then click ‘Send’. You’ll see a number of prompts, as shown below. Naturally if you answer No to any of the questions the process will stop.
You will be able to view the progress of the emails in General>Email Settings on the Queue tab.
This option is similar to the email send, but rather than pre-prepared templates you can type the message you wish to send directly into the form that appears.
Your site name, or the first 11 characters of it, will be shown in the From box but you can change this if you wish. Please note that spaces aren’t allowed and only 11 characters can be used. As with emails, you can tick to say that this isn’t a marketing message, and the number of members selected at the bottom will change to show all those with mobile numbers stored.
As you type the message you’ll see the character count decrease, and each time you go over the character threshold the Credits Used count will increase.
Once you have written the message, just click Send. You’ll be asked to confirm that you want to send the number of messages and the overall cost;
Clicking confirm will send the messages straight away.
This option requires an A4 report printer to be available to print to. It uses the same templates as the email option, but produces paper copies rather than electronic messages. As such, you should take care to use templates without coloured fonts or images included unless your printer will support colour and you have plenty of ink! The template selection screen looks like this;
There’s no need to distinguish between marketing and non-marketing messages, as only members who’ve agreed to receive mail will be included in the merge run, and the number of members the mail merge will be printed for is shown at the bottom left. If there are none, you’ll see this message;
Assuming you have at least one match you’ll see the template selection screen, just select the template you want and press ‘Print’. You’ll see a message confirming that the job has been sent to the print queue.