Create Microsoft Excel (MS Excel): Boom, Bust and Echo crosstab spreadsheets with plugins and an age cohort flag. Boom (Boomers) segments are born between 1946-1964, Bust (Busters) between 1965 and 1981, and the Echo generation are about 29 years of age or younger. One’s age influences how marketers must communicate with him or her: frequency, style, tone, and marketing channel. MS Excel crosstabs can do age cohort predictive analytics segmentation. Free Microsoft Office Data Analysis Presentation Templates can present age cohort segments. Also learn about Microsoft Excel (MS Excel) Control Chart Data Analysis. Also Watch Free Microsoft Excel (MS Excel) Video Tutorials.
Google Analytics MS Excel Plugin
A Microsoft Excel (MS Excel) plugin – Excellent Analytics – can import Google Analytics data into Excel and combine it with age cohorts. MS Excel crosstabs may evaluate age cohort segments against key business measures. The MS Excel Data Analysis ToolPack add-in is useful for exploring data: looking for extreme data values, identifying small variable categories and or analyzing relationships between age and other data. Learn more about Microsoft Excel (MS Excel)’s statistical analysis and data analysis tools. Microsoft® Excel® Data Analysis and Business Modeling covers MS Excel data analysis.
Microsoft Excel (MS Excel): Boom, Bust and Echo Crosstab Reports
After data exploration in Microsoft Excel (MS Excel), age cohort crosstabs may evaluate customer loyalty: the ‘% of visitors who have a blog bookmarked’, for example. MS Excel crosstabs might find product revenue and brand preference differences between age cohorts. And findings may require that marketing action be taken to communicate core messages and calls to action directed at certain customer sub-segments. And the frequency, style, tone, and marketing channels for communicating to individuals in the Boomer, Bust and Echo age cohort segments differ. For example, Echo generation consumers require constant wireless communications that is eye-catching, fun, and earns respect. Alternatively, Bust generation individuals respond best to marketing that questions authority delivered via a mix of online and face-to-face marketing channels.