Offer the customer recommendations on methods for retrieving data
from marketing platforms. Assist the customer in organizing the data to
ensure its suitability for analytical purposes. Implement the proof of
concept into production

The Challenge

Data resides in various sources and in inconsistent formats and structure.
Widely available integration tools were expensive and hardly scalable.
The challenge was to bring the data into a single warehouse in a
consistent format to enable value add marketing analytics so that the
business stakeholders are taking informed decisions. The solution
must be replicable for many customers with minimal effort.

The Solution

The solution consists of data ingestion pipelines in FiveTran as a
marketplace deployment. Data is stored in BigQuery to allow for
seamless transformation and storage. Data transformation pipelines
are built using the Extract, Load, Transform (ELT) process using the data                         build tool within BigQuery. Additional transformation and API calls were built
via cloud functions. Looker studio was used for visualization.

The Result

A customer-facing marketing platform that provides insights on how
their marketing data is converted to actual leads and opportunities, the
cost per conversion, and cost per marketing campaign.

The level of strategic architecture consulting and data
engineering of the Cloud Office team was outstanding.
The true game changer for the success of the project,
however, was their approach to understanding our
unique business requirements.

Ivo Shipochky 

Head of Paid Growth, VertoDigital

About: VertoDigital

Value-Based Digital Marketing consulting agency for B2B growth-stage companies supported by the leading technology VC funds.

vertodigital.com

Bulgaria

Advertising Services

Solution

About Cloud Office

Cloud Office is a Premier Google Cloud partner with a specialisation in Work Transformation and experts in Google Cloud Compute,Cloud Productivity, Digital Natives and Data Analytics.