Önceki temas

Bu egzersiz setinde, her teması ilk temas ya da son temas olarak sınıflandırmak için kullanacağımız bir dizi bayrak oluşturacağız. Bu sayede, bir kullanıcının satın alma yolculuğundaki eğilimleri inceleyebileceğiz. Örneğin, kullanıcı satın alma anına kıyasla pazarlama ile ne zaman etkileşime geçtiğine bağlı olarak pazarlamanın (ör. hangi kanalların tüketildiği) nasıl değiştiğine bakabiliriz.

İlerlemeni kaybettiysen, açık tüm çalışma kitaplarını kapat ve Masaüstü'ndeki Workbooks klasöründen 1_4_prior_touch.twbx dosyasını yükle.

Bu egzersiz

Tableau ile Pazarlama Analitiği

kursunun bir parçasıdır

Kursu Görüntüle

Uygulamalı interaktif egzersiz

İnteraktif egzersizlerimizden biriyle teoriyi pratiğe dökün

Egzersizi başlat

Bu egzersiz

Tableau ile Pazarlama Analitiği

kursunun bir parçasıdır

IntermediárioNível de habilidade

4.8+

81 reviews

Kursa Ücretsiz Başlayın

In chapter one, you will gain a thorough understanding of the basics of marketing data and analytics, starting with how data is generated and stored. You will cover marketing channels, journeys, and understand how they are defined. By the end of this chapter, you will be able to restructure data to identify those journeys and assign credit to interactions via different attribution models.

Exercise 1: Tableau ile pazarlama analitiği Exercise 2: Çerez işlevselliği Exercise 3: Web verisi örneği Exercise 4: Tanımlanabilir trafik Exercise 5: Müşteri segmentasyonu Exercise 6: Kullanıcı satın alma bayrağı Exercise 7: Temaslar, yolculuklar ve atıf Exercise 8: Atıf modelleri Exercise 9: Veri ofsetleme Exercise 10: Önceki temas

Geçerli Egzersiz

Exercise 11: Sonraki dokunuş Exercise 12: Dokunuş sınıflandırması Exercise 13: İlk temas vs. son temas

In chapter two, you will dive deeper into two specific marketing channels: email and paid social marketing. You will cover the strategies behind each channel, typical use cases, and understand the components that make up each type of marketing. By the end of this chapter, you will be able to analyze performance across several metrics unique to each channel and understand how to use data to identify areas for improvement.

Exercise 1: Marketing funnels Exercise 2: Click-through rate change Exercise 3: Calculated field aggregation Exercise 4: Click-through rate Exercise 5: Open rate Exercise 6: Email diagnostic Exercise 7: Paid social and A/B testing Exercise 8: A/B testing Exercise 9: Analytics operations Exercise 10: Click-back rate Exercise 11: Engagement and purchase rates Exercise 12: Creative Exercise 13: Follower metrics

In chapter three, you will build on analytics learned in chapter two to better understand two other heavily-used channels; paid search and organic marketing. You’ll learn how each of these channels works, their similarities and differences, and the importance of web pages and digital strategy. Additionally, you’ll examine relationships between data variables and how to manipulate data (both qualitative and quantitative) to perform analyses. By the end of this chapter, you will be able to analyze performance across various metrics unique to each channel and understand how changes in one channel may impact another.

Exercise 1: Paid search Exercise 2: Paid search review Exercise 3: String operations Exercise 4: Keyword spend Exercise 5: Mobile vs. desktop Exercise 6: Click-through rate Exercise 7: What is organic traffic Exercise 8: Organic search ranking Exercise 9: P-values, R-squared values, and moving averages Exercise 10: Engagement rate Exercise 11: URL group Exercise 12: Metric correlation Exercise 13: Channel correlation

In chapter four, you will combine what you’ve learned in previous chapters to calculate and analyze LTV, CAC, and their ratio. You’ll learn how to build these metrics, such as average order size, age, and lifespan, from their component parts and examine changes in them. Returning to earlier work on paid marketing, you’ll analyze changes in CAC over time through a unioned data set, gaining exposure to connived data sets in Tableau. You’ll then wrap up the course by calculating LTV/CAC.

Exercise 1: Introduction to LTV Exercise 2: LTV insights Exercise 3: DATEDIFF and DATEPARSE Exercise 4: Churn flag Exercise 5: Churn rate Exercise 6: Order size Exercise 7: Introduction to CAC Exercise 8: B2B vs. B2C CAC Exercise 9: Unioned data Exercise 10: Paid social CAC Exercise 11: Paid search CAC Exercise 12: Total CAC Exercise 13: LTV/CAC Exercise 14: Wrap-up video