DATA-DRIVEN DIGITAL MARKETING
Quick Start Accelerator Services Package
Our Data-Driven Digital Marketing Accelerator Services collaboratively guide you to a better understanding of applying data, the cloud, and associated technologies to digital marketing insights and effectiveness.
Did you know...
-
Worldwide digital ad spend is predicted to reach over $375B by 2021.
-
70% of advertisers plan to increase budgets for mobile social ads.
-
On average, 46% of users act after viewing a video ad.
Stats courtesy of Lyfe Marketing Oct 2019 Blog Post
ON DEMAND WEBINAR
Website Conversion Tracking
with Snowflake, Fivetran, and Looker
DAY 1
-
Snowflake Focus
-
Data and role design for storing and accessing usage data
-
Snowflake cost and usage persistence
DAY 2
-
Digital Marketing Data Ingestion Focus
-
Instance setup of Fivetran (or another data integration tool for ingestion of data sources (Google Analytics, AdWords, Facebook Ads, etc.)
-
Integration of the ingestion tool with Snowflake
-
Permissions structure and data masking for regulatory compliance
DAY 3
-
Cloud Data Transformation Focus
-
DevOps architecture on version control tool (Gitlab, Github, Azure DevOps)
-
Initial dbt + CI/CD tool or Stored Procedures + Orchestrator transformation implementation
DAY 4
-
Cloud Data Transformation + BI Focus
-
BI connectivity to Snowflake
-
Further data transformation development
DAY 5
-
BI Development and Handoff
-
BI dashboard development
-
Final documentation
-
Notes
-
Assumes a managed ELT solution such as Fivetran + dbt will be used
-
This has been deployed in AWS and Azure, not in GCP
-
