Email MKT Template

In today’s competitive business landscape, making informed decisions is crucial for success. One area that often poses challenges for businesses is determining the efficiency of their email marketing spend. To address this, we are excited to introduce powerful models that can help companies answer critical questions such as:

  • How efficient is our marketing spend?

  • What’s the impact of cutting marketing spending?

  • If I have to keep only one campaign up and running, which is it?

Description

This template offers the following list of models, each with its own unique perspective, to help you make informed decisions based on the email marketing dataset in Klaviyo, Marketo, and Hubspot.

 

Model Description
fct__email_mkt__campaign_performance
Each record represents an email/sms campaign in Klaviyo, Marketo, Hubspot.
fct__klaviyo__campaigns
Table of unique campaign versions. A campaign with 2 variations will have 2 distinct rows.
      **Counts** of the unique users and instances of the events, as well as **sums** of the numeric value associated with events (i.e. revenue) will be pivoted out into columns, as configured by the `klaviyo__count_metrics` and `klaviyo__sum_revenue_metrics` variables, respectively. See the dbt_project.yml file for the default metrics used. These columns will be prefixed with `count_`, `unique_count_`, and `sum_revenue_`.
fct__klaviyo__flows
Table of unique flow versions. A flow with 2 variations will have 2 distinct rows.
      **Counts** of the unique users and instances of the events, as well as **sums** of the numeric value associated with events (i.e. revenue) will be pivoted out into columns, as configured by the `klaviyo__count_metrics` and `klaviyo__sum_revenue_metrics` variables, respectively. See the dbt_project.yml file for the default metrics used. These columns will be prefixed with `count_`, `unique_count_`, and `sum_revenue_`.
fct__marketo__campaigns
Each record represents a deal stage in Hubspot, enriched with metrics deal activities.
fct__hubspot__email_campaigns
Each record represents a deal in Hubspot, enriched with metrics about engagement activities.
Na Nguyen Thi
Latest posts by Na Nguyen Thi (see all)