NGO

테이블 (11)

dimension_date (Untitled3)

  • Date키 (Key) — 기본 키 — NOT NULL
  • 연 (Field)
  • 월 (Field2)
  • 일 (Field3)
  • 요일 (Field4)
  • 주중/주말 (Field5)
  • 주차 (Field6)
  • 연월 (Field7)

dimension_daypart (Untitled4)

  • Daypart (Key) — 기본 키 — NOT NULL
  • 시간대 (Field)

dimension_film (Untitled5)

  • Film (Key) — 기본 키 — NOT NULL
  • 대표소재명 (Field)
  • 구분 (Field2)
  • 장르 (Field3)
  • Asklevel (Field4)
  • 소재등록일 (Field5)

dimension_station (Untitled)

  • Station (Key) — 기본 키 — NOT NULL
  • 대표채널 (Field)
  • 매체구분 (Field2)
  • 장르 (Field3)

dimension_연월 (Untitled2)

  • 연월 (Key) — 기본 키 — NOT NULL
  • 연도 (Field)
  • 분기 (Field2)
  • 월 (Field3)

fact_송출내역 (Untitled8)

  • station (Key) — 기본 키 — NOT NULL
  • Date (Field)
  • Time (Field2)
  • Secs (Field3)
  • Film (Field4)
  • Programme (Field5)
  • Genre (Field6)
  • Net Price (Field7)
  • Cost (Field8)
  • Audience (Field9)
  • Salehouse (Field10)
  • promocode (Field11)
  • pib (Field12)
  • pip (Field13)
  • origin (Field14)
  • telno (Field15)
  • SPOT (Field16)
  • Daypart (Field17)
  • 연월 (Field18)

fact_집행실적_ml분석 (Untitled9)

  • Date (Key) — 기본 키 — NOT NULL
  • Copyline (Field9) — 기본 키
  • Stataion (Field)
  • Reach (Field5)
  • Reach 3+ (Field6)
  • Reach 5+ (Field7)
  • SPOT (Field8)
  • Audience (Field2)
  • 30M_Audience (Field3)
  • 40M_Audience (Field4)
  • 50M_Audience (Field10)
  • 60M_Audience (Field11)
  • 30F_Audience (Field12)
  • 40F_Audience (Field13)
  • 50F_Audience (Field14)
  • 60F_Audience (Field15)
  • 30M_Reach (Field16)
  • 40M_Reach (Field17)
  • 50M_Reach (Field18)
  • 60M_Reach (Field19)
  • 30F_Reach (Field20)
  • 40F_Reach (Field21)
  • 50F_Reach (Field22)
  • 60F_Reach (Field23)
  • 30M_Reach3+ (Field24)
  • 40M_Reach3+ (Field25)
  • 50M_Reach3+ (Field26)
  • 60M_Reach3+ (Field27)
  • 30F_Reach3+ (Field28)
  • 40F_Reach3+ (Field29)
  • 50F_Reach3+ (Field30)
  • 60F_Reach3+ (Field31)
  • 30M_Reach5+ (Field32)
  • 40M_Reach5+ (Field33)
  • 50M_Reach5+ (Field34)
  • 60M_Reach5+ (Field35)
  • 30F_Reach5+ (Field36)
  • 40F_Reach5+ (Field37)
  • 50F_Reach5+ (Field38)
  • 60F_Reach5+ (Field39)
  • Net Cost (Field40)
  • Cost (Field41)
  • CPM (Field42)

fact_채널별CPM (Untitled11)

  • station (Key) — 기본 키 — NOT NULL
  • ch_group (Field)
  • CPM (Field2)

fact_최그1개월샘플_ROI시뮬레이션 (Untitled10)

  • Date (Key) — 기본 키 — NOT NULL
  • Advertiser (Field)
  • Product (Field2)
  • Feature_1 (Field3)
  • Feature_2 (Field4)
  • Feature_3 (Field5)
  • Feature_4 (Field6)
  • Feautre_5 (Field7)
  • Ch1_Audience (Field8)
  • ChN_Audience (Field9)
  • Cost (Field10)
  • Predict_call (Field11)
  • Predict_donour (Field12)
  • Predict_donouramount (Field13)
  • ROI (Field14)

fact_큐시트 (Untitled7)

  • Station (Key) — 기본 키 — NOT NULL
  • Programme (Field)
  • Time (Field2)
  • Daypart (Field3)
  • Class (Field4)
  • Sec (Field5)
  • Kind (Field6)
  • Unit price (Field7)
  • Bonus Rate (Field8)
  • Net price (Field9)
  • Insertion (Field10)
  • Ad value (Field11)
  • Cost (Field12)
  • Date (Field13)
  • Film (Field14)
  • 연월 (Field15)
  • Field16

fact_후원내역 (Untitled6)

  • Date (Key) — 기본 키 — NOT NULL
  • Time
  • 시간대 (Field)
  • Dnis (Field2)
  • Station (Field3)
  • I/B콜수 (Field4)
  • 응대호 (Field5)
  • 정기후원 (Field6)
  • 후원금액 (Field7)
  • Film (Field8)