Did you know?
This course is part of the certified Master Class "Marketing & Sales Analyst". If you book the entire Master Class, you save 28 percent compared to booking the individual modules.
- Getting started with the course.
- Organizational matters.
- Clarify the course schedule and expectations.
- Introduction to the course topic.
- Identify and evaluate data sources in the area of marketing & sales along the customer journey (ACCRA model).
- The importance of different channels and touchpoints for data acquisition.
- Data specifics of online and offline channels.
- Approaches to overcoming cross-channel data collection challenges.
- Practical exercise for application.
- Data sources and data collection in practice.
- Discussion of the practical exercises.
- Open questions and case studies.
- Overview of data collection methods: Automated data collection (web tracking and data sources from other funnel stages), manual data collection (surveys, feedback).
- Development of a targeted tracking concept including selection of suitable tracking tools and technologies.
- Implementation and validation of tracking, including best practices and methods for testing correct data collection.
- Extract - Data extraction from various sources (databases, APIs, flat files).
- Transform - data cleansing, enrichment and integration.
- Load - loading the prepared data into target systems: understanding of staging areas, data marts and direct connection to analysis tools.
- Visualize (preparation) - Optimally prepare data for analysis and visualization.
- Continuous data quality assurance (data quality management).
- Ensure up-to-date data and manage it strategically.
- Tool landscape and practical application in the ETLV context
- Insight into relevant tool categories for the ETLV process.
- Overview of tools for data extraction, integration, cleansing and transformation.
- The role of tag management systems and customer data platforms (CDPs) in the data process.
- Practical exercise for application.
- Consolidate ETLV knowledge.
- Transfer to everyday working life.
- Discuss practical applications.
Contents
The database for marketing & sales
- Identify and evaluate data sources in Marketing & Sales along the customer journey (ACCRA model).
- The importance of different channels and touchpoints for data acquisition.
- Practical exercise for application.
Data collection and tracking strategies
- Overview of data collection methods: automated data collection (web tracking and data sources from other funnel stages), manual data collection (surveys, feedback).
- Development of a targeted tracking concept including selection of suitable tracking tools and technologies.
- Implementation and validation of tracking, including best practices and methods for testing correct data collection.
- Practical exercise for application.
The ETLV process: making data systematically usable
- Extract - Data extraction from various sources (databases, APIs, flat files).
- Transform - data cleansing, enrichment and integration.
- Load - loading the prepared data into target systems: understanding of staging areas, data marts and direct connection to analysis tools.
- Visualize (preparation) - Optimally prepare data for analysis and visualization.
Excellence in data: Quality and timeliness as key success factors
- Continuous data quality assurance (data quality management): Data quality metrics, improving data quality, importance of roles and data dictionaries, automated validation rules and alerts.
- Ensure up-to-date data and manage it strategically.
Tool landscape and practical application in the ETLV context
- Insight into relevant tool categories for the ETLV process.
- Overview of tools for data extraction, integration, cleansing and transformation.
- The role of tag management systems and customer data platforms (CDPs) in the data process.
This is how you learn in this course
This online course offers you a digital blended concept that has been specially developed for part-time learning. With a time budget of at least 4-5 hours per week, you are sure to reach your goal. Alternatively, you can schedule the learning units flexibly. This is how you learn in the course:
Self-study phases:Learn independently, at your own pace and whenever you want. Our courses offer you didactically high-quality learning material with videos, articles, interactive exercises, quizzes and learning checks.
Live webinars:In regular online seminars, you will meet the trainers in person. You will receive answers to your questions, specific assistance and instructions on how to deepen your knowledge and apply the skills you have acquired in practical exercises.
Learning community: A digital learning community is available to you throughout the course. Exchange ideas with other participants and the trainers and clarify your questions.
Certificate of attendance and Open Badge: As a graduate of the course, you will receive a certificate and an Open Badge that you can easily share in professional networks (e.g. LinkedIn).
Future Jobs Club: Get exclusive access to a business network, micro-learnings (sparks), news and future work hacks.
Your benefit
- You will learn which internal and external data sources along the customer journey offer the greatest added value for marketing & sales.
- You will learn how to use automated and manual data collection methods to obtain relevant information - including best practices for implementation and validation.
- You understand the steps of data extraction, cleansing, enrichment and integration as well as their preparation for analysis purposes.
- You will develop an understanding of data quality management (DQM) with methods for continuously ensuring the quality and up-to-dateness of your databases.
- You have an overview of important technologies such as tag management systems or customer data platforms (CDPs) that support the entire data process.
- You learn in a practice-oriented way through application exercises and can transfer what you have learned directly into your everyday work.
- You lay a solid data foundation to better understand customer behavior, precisely control campaigns and make well-founded decisions in Marketing & Sales.
Methods
Teaching content via digital components such as e-learning, interactive exercises, webinars, learning assessments and more. Exchange with learners and experts via a community. Location-independent and accessible at any time. Mobile learning when and where you want!
Recommended for
The course is suitable for all data-savvy people who want to make marketing and sales more efficient and successful in their role. This includes the job roles of Marketing Manager, Online Marketer, Growth Manager, Sales Manager, sales manager, Digital Marketer, Customer Experience Manager, E-Commerce Manager, product manager, Data Analyst, Data Scientist, Business Analyst, decision maker, Managing Director, and many more.
Further recommendations for "Marketing & Sales Analytics: Tracking Strategies and Data Preparation"
Start dates and details


