Automated Monthly Statement Notification

If the intention is to include the Statement Balance information in the Monthly Statement Notification, the fields and the associated member data will need to be exported to Frankie first. To ensure the appropriate fields and data have been exported, follow these steps:

1. Navigate to the following menu items:
   • Club Management -> Member File -> Member Import/Export -> Clubhouse Online EMM Interface Profile

Note: If you do not have access to this menu please contact the Clubhouse Online Support team for assistance.

2. Select your Club Code.
3. Click on the Fields menu on the top right.

Review the listed fields in this menu as these would have already been exported to Frankie.

If there are additional fields that need to be added, follow these steps:

4. Select the next available line at the bottom and click on the magnifying glass next to it.

5. Press F2 on your keyboard to bring up the field search bar.
6. Search for and select the field to be added.

7. Repeat steps 4-6 until all the desired fields have been added. Once satisfied, click on the Finalize menu item at the top right.

8. When prompted, click on Yes to proceed with the finalizing of the fields.

9. Then click on OK, to confirm how many fields will be finalized.

10. The next prompt will ask if you wish to synchronize information that you have just update where you will click Yes.

This will immediately initate the export of the fields and member data to Frankie. Check your Frankie account in about 30 minutes to confirm the information was uploaded successfully. If you don't believe all the field and member information has been uploaded, please ensure you have direct access to your club's server and contact our Jonas Support Team to investigate the issue.

Note: As the information will be exported to Frankie from your club's server, please be prepared to provide access to your server if you need to contact support.

Selecting a Template

The next portion of creating the Monthly Statement Notification has to do with selecting a template to create the campiagn with. Using the Drag and Drop Editor you can create a fully customized campaign the suits your club's needs. 

Should you desire something something pre-built, there are also some example templates designed by us and some that are native to Frankie Gallery.

Using the Example Template

Click on the Example from the menu on the right. If you're interested in utilizing this template please contact our Support Team to have this added to your Frankie account.

Choosing a Gallery Template

Select one of the pre-buit Templates from the gallery. All gallery templates are fully customizable utilizing the drag and drop editor and can also saved as a template should you wish to use it for another campiagn. For more information on the gallery of templates click on the Learn More below.

Creating a Campaign

As mentioned earlier, we have provided an Example tempalate that can be used to create the Monthly Statement Notification. If you choose to use your own template please review the available personalization options we recommend to add to your template.

Utilizing the Example Template

If you choose to utilize the Example Template, we have incorporated a number of personalization options that will populate the statement information to each of your membership. If some of the data specified does not pertain to your membership or you choose not to include these fields, feel free to remove that particular personalization from the content.

In the introductory content area the following personalized fields were included:

• First Name
• Date

The Date personalization in this template is configured to display dates that are in the future or in the past. The plus_days="330" parameter added to the date:month code allows a prior month to be displayed by advancing the current month by 11 months. The plus_days="20" parameter added to the date:day code allows you to advance the date by 20 days. This would be used to donate the date a payment should be made.

In the main content area we have included the following personalized fields:

• Current Balance
• Minimum Unspent Balance
• Credit Book Balance
• Levy Purse Balance

Note: This only includes the field for the first Credit Book[Credit Book A] Balance. If you wish to add additional Credit Books, you will need to upload the other Credit Book Balance fields[B, C, D etc..] using the instructing above for utilizing Back-Office fields.

As these personalized fields where added as seperate content blocks within the template, you can remove and add the content blocks as you wish.

This template also includes Online Payment Options. If you offer payment options via your Clubhouse Online website you can provide your membership instructional videos as well as links to their online statement.

Lastly this template includes the app buttons for both Android and iOS. If your club has the Premium or Clubhouse Online app you can provide the links to both App stores so your members can download your clubs app.

Utilizing a Gallery Template

If you choose to use a Gallery Template and customize is it on your own, you can add the personalization codes to the template. The codes that could be used for the template are:

• First Name: [% member:first_name default="" %]
• Last Name: [% member:last_name default="" %]
• Date(Month): [% date:month %] -
• Date(Day): [% date:day %]
• Date(Year): [% date:year %]
• Date(Month + 11 Months): [% date:month plus_days="335" %]
• Date(Day + 20 Days): [% date:day plus_days="20" %]
• Current Balance: [% member:currentbalance defualt="0.00" %]
• Minimum Unspent: [% member:minimumunpsent default="0.00" %]
• Credit Book: [% member:creditbookabalance default="0.00" %]
• Levy Purse Balance [% member:levybalance default="0.00"]
• Levy Purse Description [% member:levypursedesc default="0.00" %]

If your Clubhouse Online website offers members the ability make payments online you can include links to instructional videos as well as links to their online statement. The links that can be included are as follows:

• ACH Payments - https://www.youtube.com/watch?v=ZKEeRtCOy7E&
• Credit Card Payments - https://www.youtube.com/watch?v=RANMrWuTUQI
• Recurring Payments - https://www.youtube.com/watch?v=ZKEeRtCOy7E

Creating the Monthly Statement Subscription

Creating a Subsctiption for this notification will afford your contacts the option of unsubscribing from receiving the Monthly Statement Notification, rather than unsubscribing from all your campaigns all together.
 

1. Click on the Audience tab.

2. Click on the Subscriptions menu from the navigation on the left.
3. Click on the Create new Subscription button. 

4. Enter in the name and description of your Subscription.
   • Ex. Monthly Statement
5. Once the information is entered click on the Create Subscription button.

Once you have created the Subscriptions, you will now be able add your contacts to the Subscription. This will ensure that all active contacts uploaded to your Frankie account will initially be subscribed when the Monthly Statement Notification is scheduled.

The first step will be to create a Group for all active contacts.

1. Navigate to the Audience tab within your Email Marketing Account

2. Click on the Contacts menu item on the left.
3. Click on the ACTIONS button and select “Add all to group(s)” selection.

4. Click on the “Add a New Group” link.

5. Enter in the Group Name “All Contacts” and click on the Create button.

6. Check the box next to the “All Contacts” group and click the Add button.

This will create the Group named “All Contacts” which will add all active contacts. Once you have created the “All Contacts” Group, you can now add your contacts to each of your subscriptions.

1. Navigate to the Subscriptions menu under the Audience tab.

2. Click on the Manage Subscription button on the far right of the Monthly Statement subscription.
3. Select the Add Subscribers option from the dropdown menu.

4. From the Add Subscribers window, select “Add from a group” and click on the Next button.

5. Check the box next to the “All Contacts” group that was created and click the Add From Groups button.

This will process the list and add all active contacts as subscribers.

Creating the Monthly Statement Segment

Once the Monthly Statement Subscription has been created, the next step will be to create a segment to utilize this subscription. This segment will primarily be based on the Monthly Statement Subscription, but can incorporate additional filters such as Member Status, Member Type, Dues Class etc. 

Outlined below is a basic segment based strictly based on the Monthly Statement Subscription.
 

1. Navigate to the Audience tab within your Email Marketing account.

2. Click on the Segments menu from the navigation on the left.

3. Click on the Create A Segment button and enter in the name of Monthly Statement.

4. From the Segment Type dropdown select Subscription.
5. The Condition will stay selected as "In"
6. Select the Monthly Statement Subscription.

 

As previously stated, additional criteria can be added to this segment to ensure only specific Members Statuses, Member Types or Dues Classes are included by completing the following steps:

Member Status

1. Click on the "AND" button
2. For the second Segment Type, select the Member Status field from the available options.
3. For the second Condition, select "Is any of" from the available options.
4. For the Criteria, enter in the Member Status(es) that you wish to include.

Member Type

1. Click on the "AND" button
2. For the second Segment Type, select the Member Type field from the available options.
3. From the second Condition, select "equals" from the available options.
4. For the second Criteria, enter in Member Type(s) you wish.

Dues Class

1. Click on the "AND" button.
2. For the second Segment Type, select the Dues Class field from the available options.
3. From the second Condition, select "Is before" from the available options.
4. For the second Criteria, enter in the Dues Class(es) you wish. 

Once you are satisfied with the criteria of the Segement click on the Save button.

Scheduling Delivery

Once the segment has been created, it's now time to schedule the Monthly Statement Notification for delivery. It is assumed that this campaign will be sent on specific date each month, presumably the day of or day after a member's statement is finalized.

To schedule the campaign, you will need to follow these steps:

1. ​Click on the Campaigns menu.
2. Click on the Monthly Statement Notification Campaign you created.
3. From the editing screen, highlight and copy the personalization code similar to this:
   • [% date:month plus_days="337" %]

You will need this code for the scheduling detials next as this will allow you state the previous month name in your campaing subject line.

From the Schedulig Details screen you will fill in the following values.

• Choose Recipents - Select the Monthly Statement Segment you created
• Enter a Subject Line - Your [% date:month plus_days="337" %] Statement is Ready.
• [Optional] Enter preheader text: Your [Enter Club Name] Monthly Statement.
• Sender name - [Enter Club Name]
• Sender email - Enter in the email address of the individual you would like this campaign to come from.

Note: As part of the Email Best Practices, ensure that this is an email address beloning to an individual. Do not use emails like, admin@clubname.com, info@clubname.com, office@clubname.com. This will improve the deliverability of this campaign.

• Set a seperate reply-to email address. By default, we use your sender email address - Here is where any email address can be entered as this is only what contacts will reply to.

Once the details have been finalized, click on the Schedule for Later link.

From the calendar and clock, select the date and time you wish for the campaign to be sent out.

If you would like to receive a notification when the campaign starts sending, enter in your email address below the schedule date.

Note: Additional emails can be added if necessary.

Once you're satisfied, click on th Schedule It button.


Due to the fact that the campaign has been scheduled for the future, the values that will be populated for any of the personalized fields will be picked up on the day the campaign is scheduled for. For example, if the campaign was created on Feb 4th but scheduled for March 5th, the values that would appear in the campaign would be what they are for March 5th. 

Since this campaign's content is not likely to be changed month to month, multiple editions of this campaign could be scheduled by copying the campaign and scheduling it for the same date in subsequent months. That way every month this campaign would automatically be sent out without intervention from a user.