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

ความคิดเห็น • 5

  • @craigleslie4135
    @craigleslie4135 ปีที่แล้ว +1

    How did you calculate Lambda?

    • @YeHu4ps
      @YeHu4ps  ปีที่แล้ว +1

      Usually by modeling historical market response data.

    • @craigleslie10
      @craigleslie10 ปีที่แล้ว

      @@YeHu4ps but the formula for doing this in excel? What inputs would be required

    • @YeHu4ps
      @YeHu4ps  ปีที่แล้ว

      @@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/

    • @craigleslie4135
      @craigleslie4135 ปีที่แล้ว +1

      @@YeHu4ps Thank you! Appreciate the support