endorsedCompleted

Google Analytics ETL & Campaign Management Tool for Promotional Products Manufacturer

Services Covered:

Custom Software Development

Industry

Consumer Goods

Duration

36 months

Budget

10K - 49K

Start Date

1 February 2015

Team Size

1-5 Employees

Engagement Model

Nearshore

Project Capability Score (PCS)

73/100

Good

Project Capability Score (PCS) estimates how capable Blogic 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

Confidential

Switzerland

Project Summary

Business Logic delivered two custom applications for a promotional products manufacturer: a Google Analytics data extractor and reporting system and a campaign management tool (CMT). Both solutions were built with C# and SQL Server and automated previously manual processes. The automation saved substantial time for marketing and reporting teams and the vendor provided clear, well-documented code and ongoing support.

Key Challenges

Needed to improve visibility across 20+ countries
Needed to extract Google Analytics data and build a data warehouse for at-a-glance reporting
Needed to streamline marketing campaigns and integrate list processing and forecasting

Project Deliverables

Data reporting system
Google Analytics extractor / data warehouse
Campaign management tool (CMT)
C# application with SQL Server stored procedures

Project Solution

The vendor analyzed requirements from the client's e-commerce and business logic teams, learned the Google Analytics API and implemented a C# program that extracts analytics data and pipes it via stored procedures into a SQL Server data platform. They trained the client on the system and provide occasional troubleshooting and maintenance. For the second project they developed a campaign management tool (CMT) using similar technologies, including a URL-triggered plug-in to streamline mailing campaigns, gather results and generate reports, and they are gradually transferring control to the client.

Project Outcome

Google Analytics extractor saved over 50 hours of work per week
Campaign management tool increased marketing production and saved an estimated 15 marketers three hours per day
Clean, well-documented code and responsive support improved maintainability

Platforms

API/Integration Platform

Tech Stack

C#
REST API
Microsoft SQL Server

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“The automation and efficiency of the two processes save considerable time each week. Business Logic provides clean, logical code and are quick to make necessary changes. They are responsive and professional.”
Anonymous
Data Warehouse Specialist
Date: 04/30/2018