Here is a lookup table of HubSpot’s default deal properties.
name: the internal name for data analysis, which is like variable name in a data frame;label: the label name on HubSpot platform, which is easy to remember;description: more information about a property;
Feel free to use it but please be aware that these are just the default deal properties from my test developer account. As such, please check HubSpot API if you want to have a full list of all your properties.
Here is a lookup table of HubSpot’s default company properties.
name: the internal name for data analysis, which is like variable name in a data frame;label: the label name on HubSpot platform, which is easy to remember;description: more information about a property;
Feel free to use it but please be aware that these are just the default company properties from my test developer account. As such, please check HubSpot API if you want to have a full list of all your properties.
Here is a lookup table of HubSpot’s default contact properties.
I have been working on HubSpot data analysis with R on a daily basis and having a good understanding of contact properties can save me a lot of time. HubSpot provides the properties CRM api for developers to get the contact properties list and also provides the explanations of all the default contact properties: https://knowledge.hubspot.com/contacts/hubspots-default-contact-properties.
I have been exploring a couple of marketing platforms in my new job as a Marketing Analyst. One of the daily jobs which I like most is to use R to dig into data across different marketing channels to come up with new ideas and recommendations for our marketing activities.
Google Search Console is one of the platforms I have been playing with recently. As you may already know, Google Search Console is a useful website tool for marketers to check website overall performance (e.g., search engine crawl and index issues, google search performance). For example, here is the performance report for my personal blog:
While attribution measurements are widely used in the digital marketing field, Media Mix Modeling (MMM) still plays an important role in evaluating marketing effectiveness across multiple channels at a higher level. Here is an example of how to do MMM in R with a free dataset from Kaggle.
library(tidyverse)
# Import data
media.raw <- read_csv("mediamix.csv")
# Tidy data
media <- media.raw %>%
mutate(TV = tv_sponsorships + tv_cricket + tv_RON) %>%
mutate(Digital = rowSums(.[9:13])) %>%
select(TV, radio, Magazines, OOH, Digital, sales) %>%
rename(Radio = radio, Sales = sales)
# Examining data
View(media)
Three TV-related channels are combined as TV variable. Similarly, the Digital variable is computed from channels such as Social, Display, Search, etc. The final data structure is shown as follows. This article is to examine the relationship between the dependent variable of Sales and the independent variables of TV, Radio, Magazines, OOH, and Digital. The numbers represent the media cost across channels.
Continue reading