endorsedCompleted

ETL & Analytics Dashboard for Veterinary Marketing Company

Services Covered:

Custom Software Development

Industry

Advertising & Marketing

Duration

6 months

Budget

50K - 199K

Start Date

1 March 2020

Team Size

6-10 Employees

Engagement Model

Offshore

Project Capability Score (PCS)

74/100

Good

Project Capability Score (PCS) estimates how capable NeoITO is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Vet Marketing Pro

Kent, United States of America

Project Summary

Neoito built an ETL-style analytics platform for a veterinary marketing technology company by designing the architecture, setting up a PostgreSQL database, and connecting it to Google Data Studio. They implemented roughly 70 API calls to aggregate marketing and API call data, created dashboards for analytics, and provided documentation. The product met the client's data needs and was acquired eight months into the partnership; the vendor communicated daily and met deadlines throughout.

Key Challenges

Create an ETL platform to aggregate API call and marketing data flows
Consolidate disparate data sources into a single analytics dashboard

Project Deliverables

Set up a PostgreSQL database
Built ~70 API calls to aggregate data from different sources
Connected the database to Google Data Studio for dashboards
Created analytics dashboards
Provided documentation and transferred technology to acquiring company

Project Solution

Neoito identified the system architecture, set up a PostgreSQL database to centralize data, connected that database to Google Data Studio for graphical dashboards, and implemented approximately 70 API calls to pull data from multiple sources for redundancy testing. They developed analytics dashboards from the collected data and delivered full documentation and technology handover when the project was acquired.

Project Outcome

The team obtained the data they needed and the architecture recommendations proved correct
The API calls were implemented successfully and produced credible, detailed data
The product met success criteria and was later acquired by another company
The vendor communicated daily and met every deadline, enabling transparent project management

Platforms

Web
Cloud

Tech Stack

PostgreSQL

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Through Neoito's expertise, a credible and detailed API database was generated, seamlessly contributing to the project's success. It only took eight months before the client's project was acquired by another company. The team was professional and communicative throughout their partnership.”
River Morrell
CEO
Date: 03/05/2021