Dataset statistics
Number of variables | 18 |
---|---|
Number of observations | 100 |
Missing cells | 263 |
Missing cells (%) | 14.6% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 15.0 KiB |
Average record size in memory | 153.3 B |
Variable types
Numeric | 4 |
---|---|
Categorical | 9 |
Text | 3 |
Unsupported | 2 |
Dataset
Description | Sample |
---|---|
Author | 원투씨엠 |
URL | https://www.bigdata-culture.kr/bigdata/user/data_market/detail.do?id=4f0d72b0-3e96-11eb-af9a-4b03f0a582d6 |
PROMTN_TY_CD has constant value "" | Constant |
PROMTN_TY_NM has constant value "" | Constant |
TRMNL_MODL_OPERSYSM_TY_CD has constant value "" | Constant |
COUPON_NM is highly overall correlated with COUPON_USE_DT and 5 other fields | High correlation |
COUPON_BNEF_CN is highly overall correlated with COUPON_NM and 3 other fields | High correlation |
BRAND_NM is highly overall correlated with COUPON_USE_DT and 4 other fields | High correlation |
COUPON_USGSTT_NM is highly overall correlated with COUPON_USE_DT and 5 other fields | High correlation |
CLUSTR_ID is highly overall correlated with COUPON_USE_DT and 5 other fields | High correlation |
ESNTL_ID is highly overall correlated with COUPON_USE_DT and 5 other fields | High correlation |
SEQ_NO is highly overall correlated with COUPON_ISSU_DT and 2 other fields | High correlation |
COUPON_ISSU_DT is highly overall correlated with SEQ_NO and 2 other fields | High correlation |
COUPON_USE_DT is highly overall correlated with SEQ_NO and 7 other fields | High correlation |
COUPON_ID is highly overall correlated with SEQ_NO and 2 other fields | High correlation |
TRMNL_MODL_NM has 100 (100.0%) missing values | Missing |
TRMNL_MODL_OPERSYSM_TY_NM has 100 (100.0%) missing values | Missing |
COUPON_USE_DT has 21 (21.0%) missing values | Missing |
CRTFC_STR_NM has 21 (21.0%) missing values | Missing |
CRTFC_STR_ADDR has 21 (21.0%) missing values | Missing |
SEQ_NO has unique values | Unique |
COUPON_ISSU_DT has unique values | Unique |
COUPON_ID has unique values | Unique |
TRMNL_MODL_NM is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
TRMNL_MODL_OPERSYSM_TY_NM is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
Analysis started | 2023-12-10 10:06:23.760935 |
---|---|
Analysis finished | 2023-12-10 10:06:29.385198 |
Duration | 5.62 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
SEQ_NO
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 100 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 50.5 |
Minimum | 1 |
---|---|
Maximum | 100 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 5.95 |
Q1 | 25.75 |
median | 50.5 |
Q3 | 75.25 |
95-th percentile | 95.05 |
Maximum | 100 |
Range | 99 |
Interquartile range (IQR) | 49.5 |
Descriptive statistics
Standard deviation | 29.011492 |
---|---|
Coefficient of variation (CV) | 0.57448499 |
Kurtosis | -1.2 |
Mean | 50.5 |
Median Absolute Deviation (MAD) | 25 |
Skewness | 0 |
Sum | 5050 |
Variance | 841.66667 |
Monotonicity | Strictly increasing |
Value | Count | Frequency (%) |
1 | 1 | 1.0% |
65 | 1 | 1.0% |
75 | 1 | 1.0% |
74 | 1 | 1.0% |
73 | 1 | 1.0% |
72 | 1 | 1.0% |
71 | 1 | 1.0% |
70 | 1 | 1.0% |
69 | 1 | 1.0% |
68 | 1 | 1.0% |
Other values (90) | 90 |
Value | Count | Frequency (%) |
1 | 1 | |
2 | 1 | |
3 | 1 | |
4 | 1 | |
5 | 1 | |
6 | 1 | |
7 | 1 | |
8 | 1 | |
9 | 1 | |
10 | 1 |
Value | Count | Frequency (%) |
100 | 1 | |
99 | 1 | |
98 | 1 | |
97 | 1 | |
96 | 1 | |
95 | 1 | |
94 | 1 | |
93 | 1 | |
92 | 1 | |
91 | 1 |
PROMTN_TY_CD
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
3 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 3 |
---|---|
2nd row | 3 |
3rd row | 3 |
4th row | 3 |
5th row | 3 |
Common Values
Value | Count | Frequency (%) |
3 | 100 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
3 | 100 |
PROMTN_TY_NM
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
대만게임프로모션참여고객성향 |
---|
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 대만게임프로모션참여고객성향 |
---|---|
2nd row | 대만게임프로모션참여고객성향 |
3rd row | 대만게임프로모션참여고객성향 |
4th row | 대만게임프로모션참여고객성향 |
5th row | 대만게임프로모션참여고객성향 |
Common Values
Value | Count | Frequency (%) |
대만게임프로모션참여고객성향 | 100 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
대만게임프로모션참여고객성향 | 100 |
COUPON_NM
Categorical
HIGH CORRELATION
 
Distinct | 5 |
---|---|
Distinct (%) | 5.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
酩悅軒尼詩集點抽獎趣 | |
---|---|
全家單店活動驗證券 | |
孕媽咪保養體驗券 | |
三澧企業活動驗證 | 3 |
手部潤澤再生抗老保養課程60分鐘1堂 | 3 |
Length
Max length | 18 |
---|---|
Median length | 10 |
Mean length | 9.87 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 酩悅軒尼詩集點抽獎趣 |
---|---|
2nd row | 酩悅軒尼詩集點抽獎趣 |
3rd row | 酩悅軒尼詩集點抽獎趣 |
4th row | 全家單店活動驗證券 |
5th row | 酩悅軒尼詩集點抽獎趣 |
Common Values
Value | Count | Frequency (%) |
酩悅軒尼詩集點抽獎趣 | 72 | |
全家單店活動驗證券 | 13 | 13.0% |
孕媽咪保養體驗券 | 9 | 9.0% |
三澧企業活動驗證 | 3 | 3.0% |
手部潤澤再生抗老保養課程60分鐘1堂 | 3 | 3.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
酩悅軒尼詩集點抽獎趣 | 72 | |
全家單店活動驗證券 | 13 | 13.0% |
孕媽咪保養體驗券 | 9 | 9.0% |
三澧企業活動驗證 | 3 | 3.0% |
手部潤澤再生抗老保養課程60分鐘1堂 | 3 | 3.0% |
COUPON_BNEF_CN
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | 4.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
<NA> | |
---|---|
1 2 3 | |
<h4><b>注意事項</b></h4><ol><li>本券使用期限請以券上標示為準。</li><li>本券限本人使用,每人使用一次,不得與克蘭詩其他同期活動重複兌換。</li><li>本券恕不兌換現金、掛失、或轉發與轉賣。</li><li>本券限使用於克蘭詩全台灣百貨實體通路專櫃。</li><li>本券核發與使用辦法以現場公告為準。</li><li>克蘭詩保有提前結束兌換或更換兌換內容之權利,恕不另行通知。</li></ol> | |
<h5>使用注意事項</h5><ol><li>本券請在有效期限前使用完畢,逾期恕無法使用</li><li>本券每人每次限抵用一張</li><li>本券恕不兌換現金、找零、或轉賣</li><li>本券限使用於實體通路</li><li>本券發放及使用辦法以現場標示為主</li><li>本券為無償取得之贈品,使用時恕不開立統一發票</li></ol> | 3 |
Length
Max length | 216 |
---|---|
Median length | 4 |
Mean length | 28.28 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | <NA> |
---|---|
2nd row | <NA> |
3rd row | <NA> |
4th row | 1 2 3 |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
<NA> | 75 | |
1 2 3 | 13 | 13.0% |
<h4><b>注意事項</b></h4><ol><li>本券使用期限請以券上標示為準。</li><li>本券限本人使用,每人使用一次,不得與克蘭詩其他同期活動重複兌換。</li><li>本券恕不兌換現金、掛失、或轉發與轉賣。</li><li>本券限使用於克蘭詩全台灣百貨實體通路專櫃。</li><li>本券核發與使用辦法以現場公告為準。</li><li>克蘭詩保有提前結束兌換或更換兌換內容之權利,恕不另行通知。</li></ol> | 9 | 9.0% |
<h5>使用注意事項</h5><ol><li>本券請在有效期限前使用完畢,逾期恕無法使用</li><li>本券每人每次限抵用一張</li><li>本券恕不兌換現金、找零、或轉賣</li><li>本券限使用於實體通路</li><li>本券發放及使用辦法以現場標示為主</li><li>本券為無償取得之贈品,使用時恕不開立統一發票</li></ol> | 3 | 3.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
na | 75 | |
1 | 13 | 10.3% |
2 | 13 | 10.3% |
3 | 13 | 10.3% |
h4><b>注意事項</b></h4><ol><li>本券使用期限請以券上標示為準。</li><li>本券限本人使用,每人使用一次,不得與克蘭詩其他同期活動重複兌換。</li><li>本券恕不兌換現金、掛失、或轉發與轉賣。</li><li>本券限使用於克蘭詩全台灣百貨實體通路專櫃。</li><li>本券核發與使用辦法以現場公告為準。</li><li>克蘭詩保有提前結束兌換或更換兌換內容之權利,恕不另行通知。</li></ol | 9 | 7.1% |
h5>使用注意事項</h5><ol><li>本券請在有效期限前使用完畢,逾期恕無法使用</li><li>本券每人每次限抵用一張</li><li>本券恕不兌換現金、找零、或轉賣</li><li>本券限使用於實體通路</li><li>本券發放及使用辦法以現場標示為主</li><li>本券為無償取得之贈品,使用時恕不開立統一發票</li></ol | 3 | 2.4% |
BRAND_NM
Categorical
HIGH CORRELATION
 
Distinct | 5 |
---|---|
Distinct (%) | 5.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
Moet Hennessy Taiwan | |
---|---|
<NA> | |
三澧企業 | 3 |
Minou Nail | 3 |
Clarins | 2 |
Length
Max length | 20 |
---|---|
Median length | 20 |
Mean length | 15.6 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Moet Hennessy Taiwan |
---|---|
2nd row | Moet Hennessy Taiwan |
3rd row | Moet Hennessy Taiwan |
4th row | <NA> |
5th row | Moet Hennessy Taiwan |
Common Values
Value | Count | Frequency (%) |
Moet Hennessy Taiwan | 71 | |
<NA> | 21 | 21.0% |
三澧企業 | 3 | 3.0% |
Minou Nail | 3 | 3.0% |
Clarins | 2 | 2.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
moet | 71 | |
hennessy | 71 | |
taiwan | 71 | |
na | 21 | 8.6% |
三澧企業 | 3 | 1.2% |
minou | 3 | 1.2% |
nail | 3 | 1.2% |
clarins | 2 | 0.8% |
CSTMR_ID
Text
Distinct | 88 |
---|---|
Distinct (%) | 88.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
Length
Max length | 36 |
---|---|
Median length | 36 |
Mean length | 35.19 |
Min length | 27 |
Characters and Unicode
Total characters | 3519 |
---|---|
Distinct characters | 27 |
Distinct categories | 4 ? |
Distinct scripts | 2 ? |
Distinct blocks | 1 ? |
Unique
Unique | 81 ? |
---|---|
Unique (%) | 81.0% |
Sample
1st row | f80a9f04-d427-4689-aa4a-ea41c550dda5 |
---|---|
2nd row | 4b28ba56-165e-482b-8fa9-5c2ae81f01b1 |
3rd row | 50f60339-1c32-49cc-a54e-3756f752983c |
4th row | 075e4afe-51a6-48e8-b680-e3f4bd11df3a |
5th row | feabbc38-6123-4a34-991b-d4b8d3d8069d |
Value | Count | Frequency (%) |
762e9ccf-0487-4aa9-b2b1-ba6e051fcb1c | 5 | 5.0% |
8f88380a-1838-4eb7-9f9e-c6f11e51e69e | 3 | 3.0% |
4a02928e-9b1b-4d8c-aed5-9410fd655130 | 3 | 3.0% |
a16fd392-dcb3-4c58-a405-68043d9f830a | 2 | 2.0% |
cc47b8bb-141c-4f77-9986-088811f0ef85 | 2 | 2.0% |
511b61cd-8fd3-4a3b-8433-2cb159b0f633 | 2 | 2.0% |
c05194e0-e35e-4171-a30b-ae23f3e98226 | 2 | 2.0% |
47845538-0b52-43eb-9720-238e779dd609 | 1 | 1.0% |
d8334bd1-0106-4f20-b53b-9b4bc3ca9571 | 1 | 1.0% |
threedom_clarins_c851555582 | 1 | 1.0% |
Other values (78) | 78 |
Most occurring characters
Value | Count | Frequency (%) |
- | 364 | 10.3% |
4 | 252 | 7.2% |
8 | 235 | 6.7% |
b | 205 | 5.8% |
e | 202 | 5.7% |
1 | 200 | 5.7% |
a | 196 | 5.6% |
9 | 195 | 5.5% |
3 | 193 | 5.5% |
5 | 192 | 5.5% |
Other values (17) | 1285 |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 1923 | |
Lowercase Letter | 1214 | |
Dash Punctuation | 364 | 10.3% |
Connector Punctuation | 18 | 0.5% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
b | 205 | |
e | 202 | |
a | 196 | |
f | 179 | |
c | 173 | |
d | 169 | |
r | 18 | 1.5% |
t | 9 | 0.7% |
h | 9 | 0.7% |
o | 9 | 0.7% |
Other values (5) | 45 | 3.7% |
Decimal Number
Value | Count | Frequency (%) |
4 | 252 | |
8 | 235 | |
1 | 200 | |
9 | 195 | |
3 | 193 | |
5 | 192 | |
0 | 174 | |
6 | 171 | |
7 | 157 | |
2 | 154 |
Dash Punctuation
Value | Count | Frequency (%) |
- | 364 |
Connector Punctuation
Value | Count | Frequency (%) |
_ | 18 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 2305 | |
Latin | 1214 |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
b | 205 | |
e | 202 | |
a | 196 | |
f | 179 | |
c | 173 | |
d | 169 | |
r | 18 | 1.5% |
t | 9 | 0.7% |
h | 9 | 0.7% |
o | 9 | 0.7% |
Other values (5) | 45 | 3.7% |
Common
Value | Count | Frequency (%) |
- | 364 | |
4 | 252 | |
8 | 235 | |
1 | 200 | |
9 | 195 | |
3 | 193 | |
5 | 192 | |
0 | 174 | |
6 | 171 | |
7 | 157 | |
Other values (2) | 172 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 3519 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
- | 364 | 10.3% |
4 | 252 | 7.2% |
8 | 235 | 6.7% |
b | 205 | 5.8% |
e | 202 | 5.7% |
1 | 200 | 5.7% |
a | 196 | 5.6% |
9 | 195 | 5.5% |
3 | 193 | 5.5% |
5 | 192 | 5.5% |
Other values (17) | 1285 |
TRMNL_MODL_NM
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 100 |
---|---|
Missing (%) | 100.0% |
Memory size | 1.0 KiB |
TRMNL_MODL_OPERSYSM_TY_CD
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
단말모델미분류 |
---|
Length
Max length | 7 |
---|---|
Median length | 7 |
Mean length | 7 |
Min length | 7 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 단말모델미분류 |
---|---|
2nd row | 단말모델미분류 |
3rd row | 단말모델미분류 |
4th row | 단말모델미분류 |
5th row | 단말모델미분류 |
Common Values
Value | Count | Frequency (%) |
단말모델미분류 | 100 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
단말모델미분류 | 100 |
TRMNL_MODL_OPERSYSM_TY_NM
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 100 |
---|---|
Missing (%) | 100.0% |
Memory size | 1.0 KiB |
COUPON_ISSU_DT
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 100 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.020093 × 1013 |
Minimum | 2.020093 × 1013 |
---|---|
Maximum | 2.020093 × 1013 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 2.020093 × 1013 |
---|---|
5-th percentile | 2.020093 × 1013 |
Q1 | 2.020093 × 1013 |
median | 2.020093 × 1013 |
Q3 | 2.020093 × 1013 |
95-th percentile | 2.020093 × 1013 |
Maximum | 2.020093 × 1013 |
Range | 61776 |
Interquartile range (IQR) | 36209.75 |
Descriptive statistics
Standard deviation | 19336.929 |
---|---|
Coefficient of variation (CV) | 9.5722964 × 10-10 |
Kurtosis | -1.2523376 |
Mean | 2.020093 × 1013 |
Median Absolute Deviation (MAD) | 17846 |
Skewness | 0.090546605 |
Sum | 2.020093 × 1015 |
Variance | 3.7391682 × 108 |
Monotonicity | Strictly decreasing |
Value | Count | Frequency (%) |
20200930115719 | 1 | 1.0% |
20200930072349 | 1 | 1.0% |
20200930064656 | 1 | 1.0% |
20200930065834 | 1 | 1.0% |
20200930070124 | 1 | 1.0% |
20200930070313 | 1 | 1.0% |
20200930070440 | 1 | 1.0% |
20200930070731 | 1 | 1.0% |
20200930071607 | 1 | 1.0% |
20200930071714 | 1 | 1.0% |
Other values (90) | 90 |
Value | Count | Frequency (%) |
20200930053943 | 1 | |
20200930054042 | 1 | |
20200930054157 | 1 | |
20200930054223 | 1 | |
20200930054821 | 1 | |
20200930054924 | 1 | |
20200930054940 | 1 | |
20200930054954 | 1 | |
20200930055035 | 1 | |
20200930060020 | 1 |
Value | Count | Frequency (%) |
20200930115719 | 1 | |
20200930115155 | 1 | |
20200930114920 | 1 | |
20200930114407 | 1 | |
20200930114240 | 1 | |
20200930113534 | 1 | |
20200930113529 | 1 | |
20200930113421 | 1 | |
20200930113357 | 1 | |
20200930112858 | 1 |
COUPON_USGSTT_NM
Categorical
HIGH CORRELATION
 
Distinct | 2 |
---|---|
Distinct (%) | 2.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
사용 | |
---|---|
발급 |
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 사용 |
---|---|
2nd row | 사용 |
3rd row | 사용 |
4th row | 발급 |
5th row | 사용 |
Common Values
Value | Count | Frequency (%) |
사용 | 79 | |
발급 | 21 | 21.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
사용 | 79 | |
발급 | 21 | 21.0% |
COUPON_USE_DT
Real number (ℝ)
HIGH CORRELATION
  MISSING
 
Distinct | 79 |
---|---|
Distinct (%) | 100.0% |
Missing | 21 |
Missing (%) | 21.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.0200934 × 1013 |
Minimum | 2.020093 × 1013 |
---|---|
Maximum | 2.0201007 × 1013 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 2.020093 × 1013 |
---|---|
5-th percentile | 2.020093 × 1013 |
Q1 | 2.020093 × 1013 |
median | 2.020093 × 1013 |
Q3 | 2.020093 × 1013 |
95-th percentile | 2.0200937 × 1013 |
Maximum | 2.0201007 × 1013 |
Range | 77030653 |
Interquartile range (IQR) | 35957.5 |
Descriptive statistics
Standard deviation | 16391121 |
---|---|
Coefficient of variation (CV) | 8.1140413 × 10-7 |
Kurtosis | 15.936804 |
Mean | 2.0200934 × 1013 |
Median Absolute Deviation (MAD) | 18115 |
Skewness | 4.1850962 |
Sum | 1.5958738 × 1015 |
Variance | 2.6866885 × 1014 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20200930115200 | 1 | 1.0% |
20200930064707 | 1 | 1.0% |
20200930065845 | 1 | 1.0% |
20200930070320 | 1 | 1.0% |
20200930070447 | 1 | 1.0% |
20200930070741 | 1 | 1.0% |
20200930071648 | 1 | 1.0% |
20200930071810 | 1 | 1.0% |
20200930071737 | 1 | 1.0% |
20200930071812 | 1 | 1.0% |
Other values (69) | 69 | |
(Missing) | 21 | 21.0% |
Value | Count | Frequency (%) |
20200930053952 | 1 | |
20200930054239 | 1 | |
20200930054833 | 1 | |
20200930054935 | 1 | |
20200930054947 | 1 | |
20200930055000 | 1 | |
20200930055041 | 1 | |
20200930060026 | 1 | |
20200930060844 | 1 | |
20200930061001 | 1 |
Value | Count | Frequency (%) |
20201007084605 | 1 | |
20201005122344 | 1 | |
20201004013600 | 1 | |
20201001124106 | 1 | |
20200930115724 | 1 | |
20200930115200 | 1 | |
20200930114927 | 1 | |
20200930114248 | 1 | |
20200930113536 | 1 | |
20200930113425 | 1 |
CRTFC_STR_NM
Text
MISSING
 
Distinct | 42 |
---|---|
Distinct (%) | 53.2% |
Missing | 21 |
Missing (%) | 21.0% |
Memory size | 932.0 B |
Value | Count | Frequency (%) |
吉昌菸酒 | 9 | 11.0% |
收藏家 | 7 | 8.5% |
上醇 | 4 | 4.9% |
海珊 | 4 | 4.9% |
力盛門市 | 3 | 3.7% |
合歡東門 | 3 | 3.7% |
名家 | 3 | 3.7% |
典藏洋酒 | 3 | 3.7% |
建成(隆興 | 3 | 3.7% |
mo-mo-paradise | 3 | 3.7% |
Other values (33) | 40 |
Most occurring characters
Value | Count | Frequency (%) |
酒 | 17 | 4.5% |
- | 13 | 3.5% |
) | 12 | 3.2% |
( | 12 | 3.2% |
家 | 11 | 2.9% |
菸 | 10 | 2.7% |
藏 | 10 | 2.7% |
昌 | 9 | 2.4% |
吉 | 9 | 2.4% |
收 | 7 | 1.9% |
Other values (137) | 265 |
Most occurring categories
Value | Count | Frequency (%) |
Other Letter | 294 | |
Lowercase Letter | 29 | 7.7% |
Dash Punctuation | 13 | 3.5% |
Close Punctuation | 12 | 3.2% |
Open Punctuation | 12 | 3.2% |
Uppercase Letter | 10 | 2.7% |
Space Separator | 3 | 0.8% |
Decimal Number | 2 | 0.5% |
Most frequent character per category
Other Letter
Value | Count | Frequency (%) |
酒 | 17 | 5.8% |
家 | 11 | 3.7% |
菸 | 10 | 3.4% |
藏 | 10 | 3.4% |
昌 | 9 | 3.1% |
吉 | 9 | 3.1% |
收 | 7 | 2.4% |
門 | 6 | 2.0% |
上 | 6 | 2.0% |
力 | 5 | 1.7% |
Other values (121) | 204 |
Lowercase Letter
Value | Count | Frequency (%) |
o | 7 | |
a | 6 | |
e | 4 | |
d | 3 | |
i | 3 | |
s | 3 | |
r | 3 |
Uppercase Letter
Value | Count | Frequency (%) |
M | 6 | |
P | 3 | |
N | 1 | 10.0% |
Decimal Number
Value | Count | Frequency (%) |
9 | 1 | |
1 | 1 |
Dash Punctuation
Value | Count | Frequency (%) |
- | 13 |
Close Punctuation
Value | Count | Frequency (%) |
) | 12 |
Open Punctuation
Value | Count | Frequency (%) |
( | 12 |
Space Separator
Value | Count | Frequency (%) |
3 |
Most occurring scripts
Value | Count | Frequency (%) |
Han | 294 | |
Common | 42 | 11.2% |
Latin | 39 | 10.4% |
Most frequent character per script
Han
Value | Count | Frequency (%) |
酒 | 17 | 5.8% |
家 | 11 | 3.7% |
菸 | 10 | 3.4% |
藏 | 10 | 3.4% |
昌 | 9 | 3.1% |
吉 | 9 | 3.1% |
收 | 7 | 2.4% |
門 | 6 | 2.0% |
上 | 6 | 2.0% |
力 | 5 | 1.7% |
Other values (121) | 204 |
Latin
Value | Count | Frequency (%) |
o | 7 | |
a | 6 | |
M | 6 | |
e | 4 | |
P | 3 | |
d | 3 | |
i | 3 | |
s | 3 | |
r | 3 | |
N | 1 | 2.6% |
Common
Value | Count | Frequency (%) |
- | 13 | |
) | 12 | |
( | 12 | |
3 | 7.1% | |
9 | 1 | 2.4% |
1 | 1 | 2.4% |
Most occurring blocks
Value | Count | Frequency (%) |
CJK | 294 | |
ASCII | 81 | 21.6% |
Most frequent character per block
CJK
Value | Count | Frequency (%) |
酒 | 17 | 5.8% |
家 | 11 | 3.7% |
菸 | 10 | 3.4% |
藏 | 10 | 3.4% |
昌 | 9 | 3.1% |
吉 | 9 | 3.1% |
收 | 7 | 2.4% |
門 | 6 | 2.0% |
上 | 6 | 2.0% |
力 | 5 | 1.7% |
Other values (121) | 204 |
ASCII
Value | Count | Frequency (%) |
- | 13 | |
) | 12 | |
( | 12 | |
o | 7 | |
a | 6 | |
M | 6 | |
e | 4 | 4.9% |
P | 3 | 3.7% |
d | 3 | 3.7% |
i | 3 | 3.7% |
Other values (6) | 12 |
CRTFC_STR_ADDR
Text
MISSING
 
Distinct | 42 |
---|---|
Distinct (%) | 53.2% |
Missing | 21 |
Missing (%) | 21.0% |
Memory size | 932.0 B |
Length
Max length | 28 |
---|---|
Median length | 27 |
Mean length | 14.405063 |
Min length | 9 |
Characters and Unicode
Total characters | 1138 |
---|---|
Distinct characters | 133 |
Distinct categories | 6 ? |
Distinct scripts | 3 ? |
Distinct blocks | 2 ? |
Unique
Unique | 26 ? |
---|---|
Unique (%) | 32.9% |
Sample
1st row | 屏東縣枋寮鄉中山路75號1樓 |
---|---|
2nd row | 屏東縣枋寮鄉中山路75號1樓 |
3rd row | 桃園市龜山區忠義路2段395號 |
4th row | 屏東縣枋寮鄉中山路75號1樓 |
5th row | 屏東縣枋寮鄉中山路75號1樓 |
Value | Count | Frequency (%) |
屏東縣枋寮鄉中山路75號1樓 | 9 | 11.4% |
台中市南屯區永春東路198號 | 7 | 8.9% |
花蓮縣吉安鄉中華路二段159號 | 4 | 5.1% |
桃園市大園區新興路50號 | 4 | 5.1% |
新北市中和區中正路1196號 | 3 | 3.8% |
台南市東區東門路一段188號 | 3 | 3.8% |
台南市新營區新進路二段183號 | 3 | 3.8% |
雲林縣斗六市建成路5號 | 3 | 3.8% |
嘉義市西區建成街62樓 | 3 | 3.8% |
新竹市香山區牛埔南路532號 | 2 | 2.5% |
Other values (32) | 38 |
Most occurring characters
Value | Count | Frequency (%) |
號 | 77 | 6.8% |
路 | 75 | 6.6% |
市 | 62 | 5.4% |
1 | 61 | 5.4% |
區 | 54 | 4.7% |
中 | 40 | 3.5% |
5 | 33 | 2.9% |
2 | 31 | 2.7% |
8 | 29 | 2.5% |
段 | 28 | 2.5% |
Other values (123) | 648 |
Most occurring categories
Value | Count | Frequency (%) |
Other Letter | 876 | |
Decimal Number | 252 | 22.1% |
Uppercase Letter | 4 | 0.4% |
Close Punctuation | 2 | 0.2% |
Open Punctuation | 2 | 0.2% |
Dash Punctuation | 2 | 0.2% |
Most frequent character per category
Other Letter
Value | Count | Frequency (%) |
號 | 77 | 8.8% |
路 | 75 | 8.6% |
市 | 62 | 7.1% |
區 | 54 | 6.2% |
中 | 40 | 4.6% |
段 | 28 | 3.2% |
台 | 27 | 3.1% |
東 | 26 | 3.0% |
新 | 24 | 2.7% |
縣 | 23 | 2.6% |
Other values (106) | 440 |
Decimal Number
Value | Count | Frequency (%) |
1 | 61 | |
5 | 33 | |
2 | 31 | |
8 | 29 | |
9 | 25 | |
3 | 22 | 8.7% |
7 | 16 | 6.3% |
6 | 14 | 5.6% |
0 | 12 | 4.8% |
4 | 9 | 3.6% |
Uppercase Letter
Value | Count | Frequency (%) |
F | 1 | |
N | 1 | |
E | 1 | |
O | 1 |
Close Punctuation
Value | Count | Frequency (%) |
) | 2 |
Open Punctuation
Value | Count | Frequency (%) |
( | 2 |
Dash Punctuation
Value | Count | Frequency (%) |
- | 2 |
Most occurring scripts
Value | Count | Frequency (%) |
Han | 876 | |
Common | 258 | 22.7% |
Latin | 4 | 0.4% |
Most frequent character per script
Han
Value | Count | Frequency (%) |
號 | 77 | 8.8% |
路 | 75 | 8.6% |
市 | 62 | 7.1% |
區 | 54 | 6.2% |
中 | 40 | 4.6% |
段 | 28 | 3.2% |
台 | 27 | 3.1% |
東 | 26 | 3.0% |
新 | 24 | 2.7% |
縣 | 23 | 2.6% |
Other values (106) | 440 |
Common
Value | Count | Frequency (%) |
1 | 61 | |
5 | 33 | |
2 | 31 | |
8 | 29 | |
9 | 25 | |
3 | 22 | 8.5% |
7 | 16 | 6.2% |
6 | 14 | 5.4% |
0 | 12 | 4.7% |
4 | 9 | 3.5% |
Other values (3) | 6 | 2.3% |
Latin
Value | Count | Frequency (%) |
F | 1 | |
N | 1 | |
E | 1 | |
O | 1 |
Most occurring blocks
Value | Count | Frequency (%) |
CJK | 876 | |
ASCII | 262 | 23.0% |
Most frequent character per block
CJK
Value | Count | Frequency (%) |
號 | 77 | 8.8% |
路 | 75 | 8.6% |
市 | 62 | 7.1% |
區 | 54 | 6.2% |
中 | 40 | 4.6% |
段 | 28 | 3.2% |
台 | 27 | 3.1% |
東 | 26 | 3.0% |
新 | 24 | 2.7% |
縣 | 23 | 2.6% |
Other values (106) | 440 |
ASCII
Value | Count | Frequency (%) |
1 | 61 | |
5 | 33 | |
2 | 31 | |
8 | 29 | |
9 | 25 | |
3 | 22 | 8.4% |
7 | 16 | 6.1% |
6 | 14 | 5.3% |
0 | 12 | 4.6% |
4 | 9 | 3.4% |
Other values (7) | 10 | 3.8% |
COUPON_ID
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 100 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.1464012 × 1011 |
Minimum | 2.1463823 × 1011 |
---|---|
Maximum | 2.1464161 × 1011 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 2.1463823 × 1011 |
---|---|
5-th percentile | 2.1463834 × 1011 |
Q1 | 2.1463891 × 1011 |
median | 2.1464045 × 1011 |
Q3 | 2.1464124 × 1011 |
95-th percentile | 2.1464155 × 1011 |
Maximum | 2.1464161 × 1011 |
Range | 3371519 |
Interquartile range (IQR) | 2321952 |
Descriptive statistics
Standard deviation | 1170784.6 |
---|---|
Coefficient of variation (CV) | 5.4546399 × 10-6 |
Kurtosis | -1.4687156 |
Mean | 2.1464012 × 1011 |
Median Absolute Deviation (MAD) | 1021184 |
Skewness | -0.26395878 |
Sum | 2.1464012 × 1013 |
Variance | 1.3707365 × 1012 |
Monotonicity | Strictly decreasing |
Value | Count | Frequency (%) |
214641606215 | 1 | 1.0% |
214639379371 | 1 | 1.0% |
214638915810 | 1 | 1.0% |
214639031415 | 1 | 1.0% |
214639070140 | 1 | 1.0% |
214639097138 | 1 | 1.0% |
214639116070 | 1 | 1.0% |
214639160747 | 1 | 1.0% |
214639259554 | 1 | 1.0% |
214639271282 | 1 | 1.0% |
Other values (90) | 90 |
Value | Count | Frequency (%) |
214638234696 | 1 | |
214638245333 | 1 | |
214638257400 | 1 | |
214638262166 | 1 | |
214638323671 | 1 | |
214638338795 | 1 | |
214638339124 | 1 | |
214638342190 | 1 | |
214638346252 | 1 | |
214638427353 | 1 |
Value | Count | Frequency (%) |
214641606215 | 1 | |
214641590262 | 1 | |
214641581108 | 1 | |
214641563555 | 1 | |
214641560817 | 1 | |
214641545878 | 1 | |
214641544522 | 1 | |
214641542339 | 1 | |
214641540391 | 1 | |
214641529686 | 1 |
CLUSTR_ID
Categorical
HIGH CORRELATION
 
Distinct | 5 |
---|---|
Distinct (%) | 5.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
6 | |
---|---|
3 | |
0 | |
2 | 5 |
4 | 2 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 6 |
---|---|
2nd row | 6 |
3rd row | 6 |
4th row | 0 |
5th row | 6 |
Common Values
Value | Count | Frequency (%) |
6 | 71 | |
3 | 14 | 14.0% |
0 | 8 | 8.0% |
2 | 5 | 5.0% |
4 | 2 | 2.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
6 | 71 | |
3 | 14 | 14.0% |
0 | 8 | 8.0% |
2 | 5 | 5.0% |
4 | 2 | 2.0% |
ESNTL_ID
Categorical
HIGH CORRELATION
 
Distinct | 5 |
---|---|
Distinct (%) | 5.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
V00A004S0013FCS00434 | |
---|---|
V00A004S0013FCS00470 | |
V00A004S0013FCS00516 | |
V00A004S0013FCS00597 | 3 |
V00A004S0013FCS00430 | 3 |
Length
Max length | 20 |
---|---|
Median length | 20 |
Mean length | 20 |
Min length | 20 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | V00A004S0013FCS00434 |
---|---|
2nd row | V00A004S0013FCS00434 |
3rd row | V00A004S0013FCS00434 |
4th row | V00A004S0013FCS00470 |
5th row | V00A004S0013FCS00434 |
Common Values
Value | Count | Frequency (%) |
V00A004S0013FCS00434 | 72 | |
V00A004S0013FCS00470 | 13 | 13.0% |
V00A004S0013FCS00516 | 9 | 9.0% |
V00A004S0013FCS00597 | 3 | 3.0% |
V00A004S0013FCS00430 | 3 | 3.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
v00a004s0013fcs00434 | 72 | |
v00a004s0013fcs00470 | 13 | 13.0% |
v00a004s0013fcs00516 | 9 | 9.0% |
v00a004s0013fcs00597 | 3 | 3.0% |
v00a004s0013fcs00430 | 3 | 3.0% |
SEQ_NO | COUPON_NM | COUPON_BNEF_CN | BRAND_NM | CSTMR_ID | COUPON_ISSU_DT | COUPON_USGSTT_NM | COUPON_USE_DT | CRTFC_STR_NM | CRTFC_STR_ADDR | COUPON_ID | CLUSTR_ID | ESNTL_ID | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SEQ_NO | 1.000 | 0.000 | 0.000 | 0.174 | 0.906 | 0.988 | 0.000 | 0.000 | 0.906 | 0.906 | 0.965 | 0.000 | 0.000 |
COUPON_NM | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.785 | 0.844 | 1.000 | 1.000 | 0.000 | 0.958 | 1.000 |
COUPON_BNEF_CN | 0.000 | 1.000 | 1.000 | 0.611 | 1.000 | 0.000 | 0.499 | 0.000 | 1.000 | 1.000 | 0.000 | 0.660 | 1.000 |
BRAND_NM | 0.174 | 1.000 | 0.611 | 1.000 | 1.000 | 0.000 | NaN | 0.844 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 |
CSTMR_ID | 0.906 | 1.000 | 1.000 | 1.000 | 1.000 | 0.873 | 1.000 | 0.000 | 1.000 | 1.000 | 0.888 | 1.000 | 1.000 |
COUPON_ISSU_DT | 0.988 | 0.000 | 0.000 | 0.000 | 0.873 | 1.000 | 0.000 | 0.000 | 0.881 | 0.881 | 0.972 | 0.000 | 0.000 |
COUPON_USGSTT_NM | 0.000 | 0.785 | 0.499 | NaN | 1.000 | 0.000 | 1.000 | NaN | NaN | NaN | 0.000 | 0.792 | 0.785 |
COUPON_USE_DT | 0.000 | 0.844 | 0.000 | 0.844 | 0.000 | 0.000 | NaN | 1.000 | 0.847 | 0.847 | 0.000 | 0.365 | 0.844 |
CRTFC_STR_NM | 0.906 | 1.000 | 1.000 | 1.000 | 1.000 | 0.881 | NaN | 0.847 | 1.000 | 1.000 | 0.882 | 1.000 | 1.000 |
CRTFC_STR_ADDR | 0.906 | 1.000 | 1.000 | 1.000 | 1.000 | 0.881 | NaN | 0.847 | 1.000 | 1.000 | 0.882 | 1.000 | 1.000 |
COUPON_ID | 0.965 | 0.000 | 0.000 | 0.000 | 0.888 | 0.972 | 0.000 | 0.000 | 0.882 | 0.882 | 1.000 | 0.321 | 0.000 |
CLUSTR_ID | 0.000 | 0.958 | 0.660 | 1.000 | 1.000 | 0.000 | 0.792 | 0.365 | 1.000 | 1.000 | 0.321 | 1.000 | 0.958 |
ESNTL_ID | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.785 | 0.844 | 1.000 | 1.000 | 0.000 | 0.958 | 1.000 |
COUPON_NM | COUPON_BNEF_CN | BRAND_NM | COUPON_USGSTT_NM | CLUSTR_ID | ESNTL_ID | |
---|---|---|---|---|---|---|
COUPON_NM | 1.000 | 1.000 | 1.000 | 0.903 | 0.710 | 1.000 |
COUPON_BNEF_CN | 1.000 | 1.000 | 0.347 | 0.742 | 0.670 | 1.000 |
BRAND_NM | 1.000 | 0.347 | 1.000 | 1.000 | 0.993 | 1.000 |
COUPON_USGSTT_NM | 0.903 | 0.742 | 1.000 | 1.000 | 0.909 | 0.903 |
CLUSTR_ID | 0.710 | 0.670 | 0.993 | 0.909 | 1.000 | 0.710 |
ESNTL_ID | 1.000 | 1.000 | 1.000 | 0.903 | 0.710 | 1.000 |
SEQ_NO | COUPON_ISSU_DT | COUPON_USE_DT | COUPON_ID | COUPON_NM | COUPON_BNEF_CN | BRAND_NM | COUPON_USGSTT_NM | CLUSTR_ID | ESNTL_ID | |
---|---|---|---|---|---|---|---|---|---|---|
SEQ_NO | 1.000 | -1.000 | -0.919 | -1.000 | 0.000 | 0.000 | 0.093 | 0.000 | 0.000 | 0.000 |
COUPON_ISSU_DT | -1.000 | 1.000 | 0.919 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
COUPON_USE_DT | -0.919 | 0.919 | 1.000 | 0.919 | 0.632 | 0.000 | 0.632 | 1.000 | 0.577 | 0.632 |
COUPON_ID | -1.000 | 1.000 | 0.919 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.131 | 0.000 |
COUPON_NM | 0.000 | 0.000 | 0.632 | 0.000 | 1.000 | 1.000 | 1.000 | 0.903 | 0.710 | 1.000 |
COUPON_BNEF_CN | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.347 | 0.742 | 0.670 | 1.000 |
BRAND_NM | 0.093 | 0.000 | 0.632 | 0.000 | 1.000 | 0.347 | 1.000 | 1.000 | 0.993 | 1.000 |
COUPON_USGSTT_NM | 0.000 | 0.000 | 1.000 | 0.000 | 0.903 | 0.742 | 1.000 | 1.000 | 0.909 | 0.903 |
CLUSTR_ID | 0.000 | 0.000 | 0.577 | 0.131 | 0.710 | 0.670 | 0.993 | 0.909 | 1.000 | 0.710 |
ESNTL_ID | 0.000 | 0.000 | 0.632 | 0.000 | 1.000 | 1.000 | 1.000 | 0.903 | 0.710 | 1.000 |
SEQ_NO | PROMTN_TY_CD | PROMTN_TY_NM | COUPON_NM | COUPON_BNEF_CN | BRAND_NM | CSTMR_ID | TRMNL_MODL_NM | TRMNL_MODL_OPERSYSM_TY_CD | TRMNL_MODL_OPERSYSM_TY_NM | COUPON_ISSU_DT | COUPON_USGSTT_NM | COUPON_USE_DT | CRTFC_STR_NM | CRTFC_STR_ADDR | COUPON_ID | CLUSTR_ID | ESNTL_ID | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | f80a9f04-d427-4689-aa4a-ea41c550dda5 | <NA> | 단말모델미분류 | <NA> | 20200930115719 | 사용 | 20200930115724 | 吉昌菸酒 | 屏東縣枋寮鄉中山路75號1樓 | 214641606215 | 6 | V00A004S0013FCS00434 |
1 | 2 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | 4b28ba56-165e-482b-8fa9-5c2ae81f01b1 | <NA> | 단말모델미분류 | <NA> | 20200930115155 | 사용 | 20200930115200 | 吉昌菸酒 | 屏東縣枋寮鄉中山路75號1樓 | 214641590262 | 6 | V00A004S0013FCS00434 |
2 | 3 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | 50f60339-1c32-49cc-a54e-3756f752983c | <NA> | 단말모델미분류 | <NA> | 20200930114920 | 사용 | 20200930114927 | 瀧德 | 桃園市龜山區忠義路2段395號 | 214641581108 | 6 | V00A004S0013FCS00434 |
3 | 4 | 3 | 대만게임프로모션참여고객성향 | 全家單店活動驗證券 | 1 2 3 | <NA> | 075e4afe-51a6-48e8-b680-e3f4bd11df3a | <NA> | 단말모델미분류 | <NA> | 20200930114407 | 발급 | <NA> | <NA> | <NA> | 214641563555 | 0 | V00A004S0013FCS00470 |
4 | 5 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | feabbc38-6123-4a34-991b-d4b8d3d8069d | <NA> | 단말모델미분류 | <NA> | 20200930114240 | 사용 | 20200930114248 | 吉昌菸酒 | 屏東縣枋寮鄉中山路75號1樓 | 214641560817 | 6 | V00A004S0013FCS00434 |
5 | 6 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | 762e9ccf-0487-4aa9-b2b1-ba6e051fcb1c | <NA> | 단말모델미분류 | <NA> | 20200930113534 | 사용 | 20201007084605 | 吉昌菸酒 | 屏東縣枋寮鄉中山路75號1樓 | 214641545878 | 6 | V00A004S0013FCS00434 |
6 | 7 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | e8bf2536-0e67-4d59-ae55-47f36a31e31e | <NA> | 단말모델미분류 | <NA> | 20200930113529 | 사용 | 20200930113536 | 吉昌菸酒 | 屏東縣枋寮鄉中山路75號1樓 | 214641544522 | 6 | V00A004S0013FCS00434 |
7 | 8 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | 762e9ccf-0487-4aa9-b2b1-ba6e051fcb1c | <NA> | 단말모델미분류 | <NA> | 20200930113421 | 사용 | 20200930113425 | 吉昌菸酒 | 屏東縣枋寮鄉中山路75號1樓 | 214641542339 | 6 | V00A004S0013FCS00434 |
8 | 9 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | 762e9ccf-0487-4aa9-b2b1-ba6e051fcb1c | <NA> | 단말모델미분류 | <NA> | 20200930113357 | 사용 | 20200930113402 | 吉昌菸酒 | 屏東縣枋寮鄉中山路75號1樓 | 214641540391 | 6 | V00A004S0013FCS00434 |
9 | 10 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | <NA> | a7c1260e-ddb9-4bfe-b335-367b98104a11 | <NA> | 단말모델미분류 | <NA> | 20200930112858 | 발급 | <NA> | <NA> | <NA> | 214641529686 | 3 | V00A004S0013FCS00434 |
SEQ_NO | PROMTN_TY_CD | PROMTN_TY_NM | COUPON_NM | COUPON_BNEF_CN | BRAND_NM | CSTMR_ID | TRMNL_MODL_NM | TRMNL_MODL_OPERSYSM_TY_CD | TRMNL_MODL_OPERSYSM_TY_NM | COUPON_ISSU_DT | COUPON_USGSTT_NM | COUPON_USE_DT | CRTFC_STR_NM | CRTFC_STR_ADDR | COUPON_ID | CLUSTR_ID | ESNTL_ID | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90 | 91 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | 4bd22bf6-f9fc-4d3b-aed4-fb04bd4cc3b9 | <NA> | 단말모델미분류 | <NA> | 20200930060020 | 사용 | 20200930060026 | 名家 | 台南市新營區新進路二段183號 | 214638427353 | 6 | V00A004S0013FCS00434 |
91 | 92 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | cc47b8bb-141c-4f77-9986-088811f0ef85 | <NA> | 단말모델미분류 | <NA> | 20200930055035 | 사용 | 20200930055041 | 合歡東門 | 台南市東區東門路一段188號 | 214638346252 | 6 | V00A004S0013FCS00434 |
92 | 93 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | 733f5a5b-074e-49e8-80c9-a8d039603dd4 | <NA> | 단말모델미분류 | <NA> | 20200930054954 | 사용 | 20200930055000 | 開普鳳山 | 高雄市鳳山市青年路一段360號 | 214638342190 | 6 | V00A004S0013FCS00434 |
93 | 94 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | 3a5c5bb6-b847-4cd3-a663-f6f1cbe7b9a9 | <NA> | 단말모델미분류 | <NA> | 20200930054940 | 사용 | 20200930054947 | 新生活 | 宜蘭縣礁溪鄉礁溪路一段149號 | 214638339124 | 6 | V00A004S0013FCS00434 |
94 | 95 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | ddc0bebd-04dc-4349-a659-777c21a58f86 | <NA> | 단말모델미분류 | <NA> | 20200930054924 | 사용 | 20200930054935 | 名家 | 台南市新營區新進路二段183號 | 214638338795 | 6 | V00A004S0013FCS00434 |
95 | 96 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | cc47b8bb-141c-4f77-9986-088811f0ef85 | <NA> | 단말모델미분류 | <NA> | 20200930054821 | 사용 | 20200930054833 | 合歡東門 | 台南市東區東門路一段188號 | 214638323671 | 6 | V00A004S0013FCS00434 |
96 | 97 | 3 | 대만게임프로모션참여고객성향 | 孕媽咪保養體驗券 | <h4><b>注意事項</b></h4><ol><li>本券使用期限請以券上標示為準。</li><li>本券限本人使用,每人使用一次,不得與克蘭詩其他同期活動重複兌換。</li><li>本券恕不兌換現金、掛失、或轉發與轉賣。</li><li>本券限使用於克蘭詩全台灣百貨實體通路專櫃。</li><li>本券核發與使用辦法以現場公告為準。</li><li>克蘭詩保有提前結束兌換或更換兌換內容之權利,恕不另行通知。</li></ol> | Clarins | threedom_clarins_c305414535 | <NA> | 단말모델미분류 | <NA> | 20200930054223 | 사용 | 20200930054239 | 新光三越嘉義垂楊店 | 嘉義市西區垂楊路726號 | 214638262166 | 2 | V00A004S0013FCS00516 |
97 | 98 | 3 | 대만게임프로모션참여고객성향 | 孕媽咪保養體驗券 | <h4><b>注意事項</b></h4><ol><li>本券使用期限請以券上標示為準。</li><li>本券限本人使用,每人使用一次,不得與克蘭詩其他同期活動重複兌換。</li><li>本券恕不兌換現金、掛失、或轉發與轉賣。</li><li>本券限使用於克蘭詩全台灣百貨實體通路專櫃。</li><li>本券核發與使用辦法以現場公告為準。</li><li>克蘭詩保有提前結束兌換或更換兌換內容之權利,恕不另行通知。</li></ol> | <NA> | threedom_clarins_c727318579 | <NA> | 단말모델미분류 | <NA> | 20200930054157 | 발급 | <NA> | <NA> | <NA> | 214638257400 | 3 | V00A004S0013FCS00516 |
98 | 99 | 3 | 대만게임프로모션참여고객성향 | 全家單店活動驗證券 | 1 2 3 | <NA> | ff6f9b77-ba96-47a7-91f9-040598cef6f4 | <NA> | 단말모델미분류 | <NA> | 20200930054042 | 발급 | <NA> | <NA> | <NA> | 214638245333 | 0 | V00A004S0013FCS00470 |
99 | 100 | 3 | 대만게임프로모션참여고객성향 | 酩悅軒尼詩集點抽獎趣 | <NA> | Moet Hennessy Taiwan | e81d56f3-4b43-4c63-9b02-f67ffd7d1211 | <NA> | 단말모델미분류 | <NA> | 20200930053943 | 사용 | 20200930053952 | 收藏家 | 台中市南屯區永春東路198號 | 214638234696 | 6 | V00A004S0013FCS00434 |