DATA-DRIVEN DIGITAL MARKETING
Quick Start Accelerator Services Package with Snowflake, Fivetran, Looker, and dbt
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
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 for ingestion of data sources (Google Analytics, AdWords, Facebook Ads, etc.)
-
Integration of Fivetran 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 with Looker
-
Looker connectivity to Snowflake
-
Further data transformation development
DAY 5
-
Looker Development and Handoff
-
Looker dashboard development
-
Final documentation
-
Notes
-
This has been deployed in AWS and Azure, not in GCP
-
