DATABASE MARKETING
- Course
- MRKT313 - DATABASE MARKETING
- Department
- Digital Media and Marketing - English - Undergraduate
- Course Type
- Course
- Status
- Required
- Language
- English
- Credit
- 3
- ECTS
- 6
- T+P+L
- 3 + 0 + 0
- Course Coordinator(s)
- Assoc. Prof. Dr. Gamze GÜNER KİBAROĞLU
- Prerequisite
- -
- Keywords
Course Description
.
DATABASE MARKETING
Evaluation Tools (Active Term)
| Item | Type | Weight (%) |
|---|---|---|
| Midterm Exam (Written) | Midterm | 30 |
| Term Project | Project | 30 |
| Final Exam (Practical/Applied) | Final | 40 |
| Total | 100 | |
Course outcomes
No course outcomes have been defined yet.
Course Syllabus
| Week | Topic |
|---|---|
| Week 1 | Theory: Introduction to database marketing: the definition of Database Marketing, how it differs from Database Management, the database concept (Excel analogy), and a conceptual introduction to Python |
| Week 2 | Practice: AI-assisted Python (Google Colab): reading, cleaning, and exploring the sample customer dataset |
| Week 3 | Theory: CRM systems and customer database management |
| Week 4 | Practice: AI-assisted Python: filtering and grouping customer records, basic CRM-style data management |
| Week 5 | Theory: Customer segmentation: demographic and behavioral segmentation, the RFM concept |
| Week 6 | Practice: AI-assisted Python: RFM scoring on the sample dataset |
| Week 7 | Theory: Customer Lifetime Value (CLV) / General review |
| Week 8 | Midterm Exam (written) |
| Week 9 | Practice: AI-assisted Python: CLV calculation with the sample customer data |
| Week 10 | Theory: Direct marketing strategies, email marketing, and campaign design |
| Week 11 | Practice: AI-assisted Python: target segment identification and personalized campaign message generation |
| Week 12 | Theory: Loyalty programs, data privacy, and ethics (GDPR and local regulations) |
| Week 13 | Practice: AI-assisted Python: campaign performance/ROI analysis and visualization + term project work session |
| Week 14 | Practice: Term project presentations |
| Week 15 | Practice: Pre-final application and review |
Reference Books & Course Materials
- 01 Course notes and slides
Learning Outcomes
- L01 Define direct and digital marketing SOLO 2
- L02 Discuss database and database marketing SOLO 4
- L03 Elaborate database analysis and applications SOLO 4
- L04 Explain external databases SOLO 2
- L05 Hypothesis strategic influences on marketing SOLO 4
- L06 Explain relationship marketing and CRM SOLO 2
Program Outcomes
- P01 1. Recognized and applied all the learning tools and techniques learnt which they will implement throughout their lives and future careers.
- P02 2. Become confident in their knowledge and skills so that they can successfully study and work on their own.
- P03 3. Attained a high level of professionalism through the fundamental knowledge and skills gained in both marketing and digital fields.
- P04 4. Demonstrated a solid understanding of core business principles in the primary areas of digital marketing, web technologies, new media and management, as well as the interconnectedness of these disciplines in the running of an organization.
- P05 5. Been able to critically implement their knowledge and skills in both written, oral and digital forms to an intended audience, based on creative and analytical approaches.
- P06 6.Demonstrated their understanding of the ethical and protected use of various new media such as social media, mobile technology, web analytics, search engine optimization, and viral advertising in both their studies and careers.
- P07 7. Implemented best practices in business for planning, decision-making, and problem-solving based on collaborative work and studies.
- P08 8. Demonstrated effective communication skills in addition to in-depth of analysis and synthesis which are essential in multicultural educational and work contexts.
- P09 9. Demonstrated critical thinking characterized by the ability to define business problems with the evidence available, discern fact from opinion, determine underlying causes, formulate and evaluate potential solutions.
- P10 10. Been able to implement ideas and concepts through the development and creation of digital content for effective social media marketing strategies, and designing and evaluating the effectiveness of interactive web sites to increase web traffic flows, visibility, consumer satisfaction and response rates.
- P11 11. Embodied integrity in their work and actions, honor confidentiality, followed generally accepted codes of conduct in the digital marketing industry.
- P12 12. Devoted themselves to follow the codes of ethics, improve privacy issues with social media, conflict, and citizenship in order to frame a better understanding of digital marketing.
Po-Lo Matrix
| LO | P01 | P02 | P03 | P04 | P05 | P06 | P07 | P08 | P09 | P10 | P11 | P12 | Average |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| L01 | 4 | 4 | 2 | 4 | 4 | 2 | 0 | 0 | 4 | 4 | 0 | 0 | 2.33 |
| L02 | 4 | 4 | 4 | 4 | 0 | 0 | 5 | 0 | 5 | 1 | 0 | 4 | 2.58 |
| L03 | 5 | 5 | 5 | 5 | 3 | 4 | 5 | 3 | 0 | 5 | 0 | 4 | 3.67 |
| L04 | 4 | 4 | 3 | 3 | 4 | 4 | 5 | 0 | 4 | 0 | 3 | 0 | 2.83 |
| L05 | 3 | 3 | 5 | 4 | 3 | 5 | 4 | 4 | 3 | 0 | 0 | 0 | 2.83 |
| L06 | 4 | 4 | 4 | 5 | 4 | 3 | 3 | 3 | 0 | 0 | 5 | 0 | 2.92 |