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