Using Excel to Calculate Advertising AdStock
ฝัง
- เผยแพร่เมื่อ 29 ส.ค. 2024
- Excel functions covered: Column Charts, Advertising Scheduling: Blitz, Pulsing, Even
TH-cam users who are not students of UH may download the data file using the following Patreon link (subscription required):
/ data-files-for-71223065
How did you calculate Lambda?
Usually by modeling historical market response data.
@@YeHu4ps but the formula for doing this in excel? What inputs would be required
@@craigleslie10 This will be well beyond the scope of what's covered here. You may read further from this book: englishonlineclub.com/pdf/Market%20Response%20Models%20Econometric%20and%20Time%20Series%20Analysis%20[EnglishOnlineClub.com].pdf and this book: www.amazon.com/Accountable-advertising-handbook-managers-analysts/dp/189931461X/
@@YeHu4ps Thank you! Appreciate the support