Develop an investment platform, digitalize a running business.
About the product
UKRINVESTCLUB is the largest investment platform in Ukraine. It publishes a weekly analysis of investment transactions with a return of 20% + per annum.
The website lists offers in the categories below: • loan; • energy; • finance; • vehicles; • commerce; • real estate; • real sector; • agriculture; • stock markets; • business and franchises; • alternative investments.
The interactive interface diagrams are available here.
Data Management in Google Sheets
For data storage and management, 2 tools were considered: Odoo and Google Sheets + Google Apps Script Made the decision to use Google tools because of the ease of making changes.
During business support, we:
Split 1 table with 5000+ rows into 3 tables.
Synchronized data from Google Sheets to the WordPress platform.
Standardized data using regular expressions and Google Apps Script.
Developed a Dashboard to search and manage customer data, their payments and subscriptions.
Google Sheet Dashboard
It took a total of 100 days to develop.
Over this time we: • Made the admin panel. • Added the feedback page. • Audited advertising campaigns. • Created 2 versions of the design. • Modified the display of notifications. • Created and set up a Telegram chatbot. • Created a landing page to attract customers. • Added registration by email, Facebook, and Google. • Collected statistics of Telegram chats using MProto. • Implemented a filter for searching and sorting offers. • Added the ability to confirm the phone number by SMS. • Developed a pixel-perfect website with a responsive layout. • Conducted an SEO audit of the website and implemented the recommendations.
The earlier version of the website
The filter on the offers page allows search by: • type of offer; • minimum return; • minimum amount of entry.
The website users can have the status of: • a moderator; • a registered user; • an anonymous user; • a member of the club.