portfolioBack to Portfolio

Marketing Analyzer

single-project-video-cover

Goal

The project is designed to collect and analyze data by email addresses.
The service allows for aggregate accounts of 6 email/marketing providers as MailChimp, GetResponse, Campaign Monitor, AWeber, InfusionSoft, Active Campaign, import lists of email addresses, and gets social and financial information from TowerData API and Full Contact.
The major task of the service is the calculation and visualization of statistical (calculation) data in graph and widget form.
Also, there is an option to send obtained data and calculation data back to the email/marketing providers via their APIs.

 

Main features:
1. User registration, and online payment via Stripe. Division of services provided among subscriptions plans – Light, Plus, Premium;
2. Widget management system and dashboards customization;
3. Ability to import data from mail services: Mailchimp, ActiveCampaign, Aweber, GetResponse, CampaignMonitor;
4. Import data from CSV file;
5. Mail services account management system;
6. Collecting data about email addresses from TowerData and Full Contact with automatic data synchronization once in 3 months;
7. Construction of graphs (widgets) about selected lists of email addresses. Using 15 different widgets according to the subscription plan;
8. Ability to filter data for real-time display;
9. Ability to compare lists added by a user;
10. Ability to export to CSV file;
11. Ability to create additional tags/labels for email addresses and send them to mail services;
12. Content and user management system for the administrator.


Solution

After we analyzed the client's requirements, our team decided to use PHP framework Laravel in the backend and VueJS 2 in frontend. MySQL and MongoDB were chosen as databases. MySQL is used to store user data and web framework.
MongoDB is used for storing data imported from third-party services. This database is ideal because the data has a different structure and a document-oriented structure.
For operations with API of mail services, we used official libraries with further modification.


Technologies

AmCharts, Laravel, MongoDB, MySQL, Stripe API, Vue.js


Team

- backend developer;

- frontend developer.

Duration

The development of this project took us 3 months.