MKTG 376 Marketing
Analytics Exam 1 | Study
Guide, Exam Review &
Practice Questions
|Guaranteed success|
, 3 VLOOKUP 4 Skewness
Don't know?
Terms in this set (55)
What is Marketing Analytics? Managing and studying data to enable marketers to evaluate their success of
their marketing initiatives.
What is the objective of Marketing Analytics? To create a consolidated view of data and provide insights.
Examples of Marketing Data Sales, demographics. Descriptive statistics. Useful and Informative Information.
YEAR Function =YEAR(date)
- gives you the year value
VLOOKUP =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
=VLOOKUP(cell of lookup value, cell range of table, corresponding column)
- =Vlookup(@[weekday},daylook, 2) showed all of the numbered days as words
by pulling data from column 2
What are pivot tables? Summaries the data of a more extensive table and summary can include sums,
averages, and other stats. (can be used for sum of sales for stores etc). 70% of
MBA students only use pivot tables.
Pivot Table Component - Rows
- Columns
- Value
- Filter/Slicer
pivot table slicers More viewer friendly summary of data in the table. click on pivot table fields ->
select filter -> add slicer and select values to show them.
Pivot table filter allow you to click on certain options to have information shown on chart
80% rule 80% of revenue come from 20% of products
Demographics Age, gender, social class, income, fam structure, race, ethnicity, lifestyle,
geography, behavior, etc.
Pivot Chart quick summary of data. A chart that provides a graphical representation of the
data in a pivot table. Insert -> pivot chart
Analytics Exam 1 | Study
Guide, Exam Review &
Practice Questions
|Guaranteed success|
, 3 VLOOKUP 4 Skewness
Don't know?
Terms in this set (55)
What is Marketing Analytics? Managing and studying data to enable marketers to evaluate their success of
their marketing initiatives.
What is the objective of Marketing Analytics? To create a consolidated view of data and provide insights.
Examples of Marketing Data Sales, demographics. Descriptive statistics. Useful and Informative Information.
YEAR Function =YEAR(date)
- gives you the year value
VLOOKUP =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
=VLOOKUP(cell of lookup value, cell range of table, corresponding column)
- =Vlookup(@[weekday},daylook, 2) showed all of the numbered days as words
by pulling data from column 2
What are pivot tables? Summaries the data of a more extensive table and summary can include sums,
averages, and other stats. (can be used for sum of sales for stores etc). 70% of
MBA students only use pivot tables.
Pivot Table Component - Rows
- Columns
- Value
- Filter/Slicer
pivot table slicers More viewer friendly summary of data in the table. click on pivot table fields ->
select filter -> add slicer and select values to show them.
Pivot table filter allow you to click on certain options to have information shown on chart
80% rule 80% of revenue come from 20% of products
Demographics Age, gender, social class, income, fam structure, race, ethnicity, lifestyle,
geography, behavior, etc.
Pivot Chart quick summary of data. A chart that provides a graphical representation of the
data in a pivot table. Insert -> pivot chart
