Need some work done? Post a Project Today
I want to create a loyalty program that will turn dollars into points. The database would collect data on the following:
Who signed up including:
When they spent
Where they spent
What they spent it on
Reporting Data -
A report wizard would create reports based on field selection and date range. Reports on this information would include:
Total dollars spent
When the dollars were spent
Average amount of a spend
Average number of times someone visits and spends based on a (select date range)
Who hasn't spent in the last (select date range)
Who are the top spenders based on percentage of total spent
Who are the top 20% spenders (or whatever percentage you insert)
Business Connectivity -
The program would be online and accessible by anyone with an internet connection. As a business, the business owner would scan a QR code or Bar code via a scanner or smart phone. That would open the loyalty members account info and show their account activity. As they reach certain points the system would unlock pre-set benefits or incentives. The system would allow for multiple locations with logins for each business. There would be 5 levels of access:
Super Admin Access
Business Owner Access
Program would email the customer anytime they earn points or make changes to their membership. The emails would be formatted to look like they came from the business that signed up for the loyalty program.
The Accessible information for each member would be set by the Super Admin.
Members would be able to access their point totals from their smart phones.
The system would be able to track referrals by dynamically creating a QR code or bar code for customers to hand out to their friends and family. When one is turned in to the business the scan would reveal who referred and add X points or incentive (pre-set in setup for business) to the referrers account.
System can also offer loyalty based on time of day or week or offers based on a special time frame (minutes, hours, days, weeks etc,)