Over the last year, our team noticed a need for a solution that helped us scale our data requests and our lifecycle marketing tactics.
Enter the email marketing data mart (also known as Email Marketing Database), which integrates several disparate data sources to help us reach our users, customers, and prospects in a more intelligent and scalable way.
In partnership with enterprise applications and marketing teams, we have created a solution that will enable GitLab to more quickly communicate critical customer and user updates, understand the overlap between prospects and users, and enable us to market to them more efficiently.
Coming SoonAssess your understanding by taking a certification most applicable to your role at GitLab.
To get started we want to make sure you understand:
group_owner_of_saas_ultimate_tierwhich are boolean fields. It is possible that a group owner could have a TRUE value for both of these fields if they are owners of both a Premium and Ultimate plan.
Entity Relationship Diagram (ERD):
Let's pull some email lists. You can use these queries in both Snowflkae and Sisense.
--Pull ALL owners and individual namespaces for Paid SaaS Plans SELECT DISTINCT email_address FROM "PREP"."SENSITIVE"."MART_MARKETING_CONTACT" WHERE GROUP_OWNER_OF_SAAS_BRONZE_TIER = TRUE OR GROUP_OWNER_OF_SAAS_PREMIUM_TIER = TRUE OR GROUP_OWNER_OF_SAAS_ULTIMATE_TIER = TRUE OR INDIVIDUAL_NAMESPACE_IS_SAAS_BRONZE_TIER OR INDIVIDUAL_NAMESPACE_IS_SAAS_PREMIUM_TIER OR INDIVIDUAL_NAMESPACE_IS_SAAS_ULTIMATE_TIER
The (WIP) Enterprise Dimensional Model Validation Dashboard reports on latest Enterprise Dimensional model test and runs.
PROD.COMMON_MART_MARKETING, but is available in
PREP.SENSITIVE. Customer Metadata (such as customer company name) is available in