ALL_CONVERSION_DATA

Tables (4)

ADVER_CONV_LOG

  • adverId — String
  • domain — String
  • url — String
  • referrer — String
  • auid — String
  • remoteIp — String
  • device — String
  • deviceCode — String — 기기정보코드 | 01 PC | 02 MOBILE
  • userAgent — String
  • charset — String
  • orderCode — String
  • totalPrice — Int32
  • totalQty — Int16
  • product — String
  • paymentType — String
  • siteCode — String
  • dsck — String
  • inflowRoute — String
  • createdDate — DateTime
  • adid — String
  • omid — String — om_id' ) ENGINE = MergeTree PARTITION BY toYYYYMMDD(createdDate) PRIMARY KEY (adverI

ALL_CONVERSION_DATA (Untitled)

  • dumpType — String
  • adverId — String
  • ordCode — String
  • paySys — String
  • totalPrice — Int32
  • totalQty — Int16
  • device — String
  • inflowRoute — String
  • convType — String
  • fromUrl — String
  • fcTE — String
  • realIp — String
  • auId — String
  • omId — String
  • adId — String
  • ipInfo — String
  • siteCode — String
  • trkTpCode — String
  • regUserId — String
  • lastClickTime — String
  • eventNm — String
  • deviceCode — String
  • browserCode — String
  • browserCodeVersion — String
  • osCode — String
  • product.productCode — Array(String)
  • product.productName — Array(String)
  • product.price — Array(String)
  • product.qty — Array(String)
  • product.dcPrice — Array(String)
  • currentDate — DateTime

Copy Of ALL_CONVERSION_DATA (CopyOfUntitled)

  • dumpType — String
  • adverId — String
  • ordCode — String
  • paySys — String
  • totalPrice — Int32
  • totalQty — Int16
  • device — String
  • inflowRoute — String
  • convType — String
  • fromUrl — String
  • fcTE — String
  • realIp — String
  • auId — String
  • omId — String
  • adId — String
  • ipInfo — String
  • siteCode — String
  • trkTpCode — String
  • regUserId — String
  • lastClickTime — String
  • eventNm — String
  • deviceCode — String
  • browserCode — String
  • browserCodeVersion — String
  • osCode — String
  • product.productCode — Array(String)
  • product.productName — Array(String)
  • product.price — Array(String)
  • product.qty — Array(String)
  • product.dcPrice — Array(String)
  • currentDate — DateTime

SCRIPT_CONV_DATA

  • adverId — String — 광고주 아이디
  • currentDate — DateTime — 현재 시각
  • ordCode — Nullable(String) — 주문 번호
  • paySys — Nullable(String) — 페이 시스템
  • totalPrice — Nullable(String) — 총 가격
  • totalQty — Nullable(String) — 총 수량
  • device — Nullable(String) — 디바이스
  • adverDomain — Nullable(String) — 도메인
  • fromUrl — Nullable(String) — 유입 url
  • lsRegDate — Nullable(String) — 로컬 스토리지
  • convType — Nullable(String) — 컨버전 타입
  • siteCode — Nullable(String) — 사이트 코드
  • realIp — Nullable(String) — 유입 ip
  • userAgent — Nullable(String) — 장비 정보
  • auId — Nullable(String) — au_Id
  • ipInfo — Nullable(String) — 아이피 정보
  • dsck — Nullable(String) — 클릭 쿠키
  • dsckFrame — Nullable(String) — 클릭 프레임 쿠키
  • sessionCode — Nullable(String) — 세션 쿠키
  • refferDomain — Nullable(String) — 유입 경로 쿠키
  • keywordValue — Nullable(String) — 키워드
  • keywordType — Nullable(String) — 키워드종류
  • keywordSessionType — Nullable(String) — 키워드세션종류
  • keywordUrl — Nullable(String) — 키워드url
  • product.productCode — Array(Nullable(String)) — 상품배열
  • product.productName — Array(Nullable(String)) — 상품배열
  • product.price — Array(Nullable(String)) — 상품배열
  • product.qty — Array(Nullable(String)) — 상품배열
  • product.adverId — Array(Nullable(String)) — 상품배열
  • product.keywordValue — Array(Nullable(String)) — 상품배열
  • product.keywordType — Array(Nullable(String)) — 상품배열
  • product.keywordSessionType — Array(Nullable(String)) — 상품배열
  • product.keywordUrl — Array(Nullable(String)) — 상품배열
  • adid — String — adid' ) ENGINE = MergeTree() PARTITION BY toYYYYMMDD(currentDate) PRIMARY KEY (adverI