ANZA Admin Links

WordPress Admin

Google Analytics

MembershipWorks

ANZA Reporting System

Stripe

CampaignMonitor

 

Snippets

Inserting an image into MembershipWorks emails:

<p><img src="https://anza.org.sg/assets/newsletter-header.jpg" alt="" width="600" height="96" /></p>

 

Inserting a menu into a sports page (remove the spaces directly inside the brackets):

[ insert page='athletics-menu' display='content' ]

This will display as follows:


 

Inserting a menu into a sports page (remove the spaces directly inside the brackets):

[ insert page='sponsored-content-tag' display='content' ]

This will display as follows:

  •  Sponsored Content 


 

This is an Excel formula to convert MembershipWorks’ date format to an Excel date:

=DATE(RIGHT(BC2,4),(MONTH(DATEVALUE(LEFT(LEFT(BC2,FIND(",",BC2)-1),3)&" 1"))),(RIGHT(LEFT(BC2,FIND(",",BC2)-1),2)))

Change the BC2 to refer to the source cell for the address in format ‘Mar 12, 2017’.

 


 

These links take to you to the 3 reports

New members

Renewed members

All Members