Dataset statistics
Number of variables | 23 |
---|---|
Number of observations | 100 |
Missing cells | 258 |
Missing cells (%) | 11.2% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 18.8 KiB |
Average record size in memory | 192.3 B |
Variable types
Numeric | 3 |
---|---|
Categorical | 18 |
Unsupported | 2 |
Dataset
Description | Sample |
---|---|
Author | 원투씨엠 |
URL | https://www.bigdata-culture.kr/bigdata/user/data_market/detail.do?id=cc523c10-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 |
CLUSTR_ID is highly imbalanced (55.0%) | Imbalance |
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 58 (58.0%) missing values | Missing |
SEQ_NO 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 09:50:47.268273 |
---|---|
Analysis finished | 2023-12-10 09:50:47.596431 |
Duration | 0.33 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
SEQ_NO
Real number (ℝ)
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 |
14 |
---|
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 14 |
---|---|
2nd row | 14 |
3rd row | 14 |
4th row | 14 |
5th row | 14 |
Common Values
Value | Count | Frequency (%) |
14 | 100 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
14 | 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 |
PROMTN_NM
Categorical
Distinct | 7 |
---|---|
Distinct (%) | 7.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
盖盖章,饮品免费拿U | |
---|---|
. | |
Twosome Coffe 2020 | |
盖盖章,饮品免费拿 | |
盖盖章,饮品免费拿~ | 1 |
Other values (2) | 2 |
Length
Max length | 18 |
---|---|
Median length | 11 |
Mean length | 9.36 |
Min length | 1 |
Unique
Unique | 3 ? |
---|---|
Unique (%) | 3.0% |
Sample
1st row | 盖盖章,饮品免费拿U |
---|---|
2nd row | 盖盖章,饮品免费拿 |
3rd row | 盖盖章,饮品免费拿 |
4th row | 盖盖章,饮品免费拿 |
5th row | 盖盖章,饮品免费拿U |
Common Values
Value | Count | Frequency (%) |
盖盖章,饮品免费拿U | 32 | |
. | 26 | |
Twosome Coffe 2020 | 23 | |
盖盖章,饮品免费拿 | 16 | |
盖盖章,饮品免费拿~ | 1 | 1.0% |
喜迎周年庆·感恩大回馈 | 1 | 1.0% |
盖盖章,饮品免费拿VV | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
盖盖章,饮品免费拿u | 32 | |
26 | ||
twosome | 23 | |
coffe | 23 | |
2020 | 23 | |
盖盖章,饮品免费拿 | 17 | |
喜迎周年庆·感恩大回馈 | 1 | 0.7% |
盖盖章,饮品免费拿vv | 1 | 0.7% |
PROMTN_BNEF_CN
Categorical
Distinct | 9 |
---|---|
Distinct (%) | 9.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 优惠券有效期:从获得之日90天内有效; | |
---|---|
折扣后任意消费满20元即可获得印章1枚 可累计集章,满20元集1枚,满40元集2枚… · 累积3枚印章,获赠咖啡免费升杯券或秋季饮品7折券 · 累积6枚印章,获得中杯美式或拿铁兑换券1张 · 累积9枚印章,获赠甜品券1张 券有效期 :发券后30日(*秋季饮品7折券截止日期为9月30日) 使用店铺:途尚咖啡直营店 | |
订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 所集印章仅限本店累计,不可和其他门店通用; 优惠券有效期:从获得之日90天内有效; | |
购买10个产品即可获得2张免费兑换券 Buy 10 get 2 for FREE | |
消费任意饮品即可集章 一杯集一张 集满10个印章即可免费获赠任意饮品一杯 (M杯型不参与集印章) | |
Other values (4) |
Length
Max length | 157 |
---|---|
Median length | 76 |
Mean length | 78.51 |
Min length | 40 |
Unique
Unique | 4 ? |
---|---|
Unique (%) | 4.0% |
Sample
1st row | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 优惠券有效期:从获得之日90天内有效; |
---|---|
2nd row | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 所集印章仅限本店累计,不可和其他门店通用; 优惠券有效期:从获得之日90天内有效; |
3rd row | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 所集印章仅限本店累计,不可和其他门店通用; 优惠券有效期:从获得之日90天内有效; |
4th row | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 所集印章仅限本店累计,不可和其他门店通用; 优惠券有效期:从获得之日90天内有效; |
5th row | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 优惠券有效期:从获得之日90天内有效; |
Common Values
Value | Count | Frequency (%) |
订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 优惠券有效期:从获得之日90天内有效; | 32 | |
折扣后任意消费满20元即可获得印章1枚 可累计集章,满20元集1枚,满40元集2枚… · 累积3枚印章,获赠咖啡免费升杯券或秋季饮品7折券 · 累积6枚印章,获得中杯美式或拿铁兑换券1张 · 累积9枚印章,获赠甜品券1张 券有效期 :发券后30日(*秋季饮品7折券截止日期为9月30日) 使用店铺:途尚咖啡直营店 | 23 | |
订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 所集印章仅限本店累计,不可和其他门店通用; 优惠券有效期:从获得之日90天内有效; | 16 | |
购买10个产品即可获得2张免费兑换券 Buy 10 get 2 for FREE | 16 | |
消费任意饮品即可集章 一杯集一张 集满10个印章即可免费获赠任意饮品一杯 (M杯型不参与集印章) | 9 | 9.0% |
每消费满15元盖一个章,集满7个章,兑换10元代金劵一张;集满14个章,兑换第二个10元代金劵一张; | 1 | 1.0% |
每次消费满128元·可集一枚尊贵虾章 第一次消费满128元·送50元代金券 每集满5个虾章·赠送一次霸王餐 | 1 | 1.0% |
消费满25元即可集章1次 集章10次,即可兑换一张兑换券 在漫咖啡可兑换一杯咖啡 或者 在蜂馥兑换面包或者咖啡一杯 | 1 | 1.0% |
1.订单实付款满20元集章一个; 2.集齐10个印章兑换10元代金券1张; 3.外卖和其他优惠活动不参与集章; | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
· | 69 | 12.0% |
订单实付每满15元可盖一个章; | 48 | 8.4% |
优惠券有效期:从获得之日90天内有效; | 48 | 8.4% |
集齐5个印章可兑换1张10元优惠券; | 48 | 8.4% |
折扣后任意消费满20元即可获得印章1枚 | 23 | 4.0% |
可累计集章,满20元集1枚,满40元集2枚… | 23 | 4.0% |
累积3枚印章,获赠咖啡免费升杯券或秋季饮品7折券 | 23 | 4.0% |
累积6枚印章,获得中杯美式或拿铁兑换券1张 | 23 | 4.0% |
累积9枚印章,获赠甜品券1张 | 23 | 4.0% |
券有效期 | 23 | 4.0% |
Other values (26) | 222 |
BRAND_NM
Categorical
Distinct | 6 |
---|---|
Distinct (%) | 6.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
茶百道 | |
---|---|
途尚咖啡 | |
楽哆啦 | |
TEAMACC茶玛(爱琴海) | |
虾吃虾涮 | 1 |
Length
Max length | 14 |
---|---|
Median length | 3 |
Mean length | 4.26 |
Min length | 3 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 2.0% |
Sample
1st row | 茶百道 |
---|---|
2nd row | 茶百道 |
3rd row | 茶百道 |
4th row | 茶百道 |
5th row | 茶百道 |
Common Values
Value | Count | Frequency (%) |
茶百道 | 50 | |
途尚咖啡 | 23 | |
楽哆啦 | 16 | 16.0% |
TEAMACC茶玛(爱琴海) | 9 | 9.0% |
虾吃虾涮 | 1 | 1.0% |
蜂馥&漫咖啡 | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
茶百道 | 50 | |
途尚咖啡 | 23 | |
楽哆啦 | 16 | 16.0% |
teamacc茶玛(爱琴海) | 9 | 9.0% |
虾吃虾涮 | 1 | 1.0% |
蜂馥&漫咖啡 | 1 | 1.0% |
CSTMR_ID
Categorical
Distinct | 32 |
---|---|
Distinct (%) | 32.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
okzZ81CHgWTToAtpFoVxkXqfc1Ag | |
---|---|
oxGQgxFCWgOpqg_nihPMSJhDmk3M | |
oxGQgxKBCbYJDd-bOCcpXG3p1Gc0 | |
oxGQgxI7sKcygIltBxmeQ6MxecUU | |
oxGQgxGQVLuF8klhfcfBPHUShjmg | 4 |
Other values (27) |
Length
Max length | 28 |
---|---|
Median length | 28 |
Mean length | 28 |
Min length | 28 |
Unique
Unique | 19 ? |
---|---|
Unique (%) | 19.0% |
Sample
1st row | oxGQgxMcjOIV8vY4Fx80F8Q63lnE |
---|---|
2nd row | oxGQgxKBCbYJDd-bOCcpXG3p1Gc0 |
3rd row | oxGQgxKBCbYJDd-bOCcpXG3p1Gc0 |
4th row | oxGQgxKBCbYJDd-bOCcpXG3p1Gc0 |
5th row | oxGQgxFCWgOpqg_nihPMSJhDmk3M |
Common Values
Value | Count | Frequency (%) |
okzZ81CHgWTToAtpFoVxkXqfc1Ag | 23 | |
oxGQgxFCWgOpqg_nihPMSJhDmk3M | 18 | |
oxGQgxKBCbYJDd-bOCcpXG3p1Gc0 | 9 | 9.0% |
oxGQgxI7sKcygIltBxmeQ6MxecUU | 6 | 6.0% |
oxGQgxGQVLuF8klhfcfBPHUShjmg | 4 | 4.0% |
otw4q0hdnAW8a856gZCfGhGLocqg | 4 | 4.0% |
otw4q0qqTygF0iCU0qmUFMc-OOO0 | 3 | 3.0% |
otw4q0rcJ5hrEQetLT14u537Tevk | 3 | 3.0% |
otw4q0i102GqGYBuV7NmxqI86LlA | 3 | 3.0% |
oxGQgxEfGlYmz8rLdeOHbCvBSZkY | 2 | 2.0% |
Other values (22) | 25 |
Length
Value | Count | Frequency (%) |
okzz81chgwttoatpfovxkxqfc1ag | 23 | |
oxgqgxfcwgopqg_nihpmsjhdmk3m | 18 | |
oxgqgxkbcbyjdd-boccpxg3p1gc0 | 9 | 9.0% |
oxgqgxi7skcygiltbxmeq6mxecuu | 6 | 6.0% |
oxgqgxgqvluf8klhfcfbphushjmg | 4 | 4.0% |
otw4q0hdnaw8a856gzcfghglocqg | 4 | 4.0% |
otw4q0qqtygf0icu0qmufmc-ooo0 | 3 | 3.0% |
otw4q0rcj5hreqetlt14u537tevk | 3 | 3.0% |
otw4q0i102gqgybuv7nmxqi86lla | 3 | 3.0% |
otw4q0jeoy-oxlmcrloxs1qkoyle | 2 | 2.0% |
Other values (22) | 25 |
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 |
CRTFC_DT
Real number (ℝ)
Distinct | 55 |
---|---|
Distinct (%) | 55.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 | 33789 |
Interquartile range (IQR) | 19601 |
Descriptive statistics
Standard deviation | 8691.0979 |
---|---|
Coefficient of variation (CV) | 4.3023256 × 10-10 |
Kurtosis | -1.0869648 |
Mean | 2.020093 × 1013 |
Median Absolute Deviation (MAD) | 9476 |
Skewness | 0.35031589 |
Sum | 2.020093 × 1015 |
Variance | 75535182 |
Monotonicity | Decreasing |
Value | Count | Frequency (%) |
20200930201236 | 7 | 7.0% |
20200930201238 | 7 | 7.0% |
20200930201240 | 7 | 7.0% |
20200930222603 | 6 | 6.0% |
20200930222601 | 6 | 6.0% |
20200930222559 | 6 | 6.0% |
20200930212402 | 3 | 3.0% |
20200930214416 | 3 | 3.0% |
20200930212404 | 3 | 3.0% |
20200930224429 | 3 | 3.0% |
Other values (45) | 49 |
Value | Count | Frequency (%) |
20200930201234 | 2 | 2.0% |
20200930201236 | 7 | |
20200930201238 | 7 | |
20200930201240 | 7 | |
20200930202301 | 1 | 1.0% |
20200930202307 | 1 | 1.0% |
20200930202521 | 1 | 1.0% |
20200930202728 | 1 | 1.0% |
20200930202807 | 1 | 1.0% |
20200930203458 | 1 | 1.0% |
Value | Count | Frequency (%) |
20200930235023 | 1 | 1.0% |
20200930224429 | 3 | |
20200930222603 | 6 | |
20200930222601 | 6 | |
20200930222559 | 6 | |
20200930222124 | 1 | 1.0% |
20200930222121 | 1 | 1.0% |
20200930222106 | 1 | 1.0% |
20200930222056 | 1 | 1.0% |
20200930220555 | 1 | 1.0% |
CRTFC_FLAG_NM
Categorical
Distinct | 3 |
---|---|
Distinct (%) | 3.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
사용 | |
---|---|
적립 | |
쿠폰발급 |
Length
Max length | 4 |
---|---|
Median length | 2 |
Mean length | 2.52 |
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 (%) |
사용 | 42 | |
적립 | 32 | |
쿠폰발급 | 26 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
사용 | 42 | |
적립 | 32 | |
쿠폰발급 | 26 |
CRTFC_STR_NM
Categorical
Distinct | 13 |
---|---|
Distinct (%) | 13.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
茶百道(新疆汇嘉时代店) | |
---|---|
途尚_北京望京soho店 | |
苏宁广场 | |
茶百道(温江财大东门店) | |
爱琴海 | |
Other values (8) |
Length
Max length | 14 |
---|---|
Median length | 12 |
Mean length | 9.79 |
Min length | 3 |
Unique
Unique | 6 ? |
---|---|
Unique (%) | 6.0% |
Sample
1st row | 茶百道(新疆汇嘉时代店) |
---|---|
2nd row | 茶百道(温江财大东门店) |
3rd row | 茶百道(温江财大东门店) |
4th row | 茶百道(温江财大东门店) |
5th row | 茶百道(新疆汇嘉时代店) |
Common Values
Value | Count | Frequency (%) |
茶百道(新疆汇嘉时代店) | 32 | |
途尚_北京望京soho店 | 23 | |
苏宁广场 | 16 | |
茶百道(温江财大东门店) | 9 | 9.0% |
爱琴海 | 9 | 9.0% |
茶百道(长沙黄兴路步行街店) | 3 | 3.0% |
茶百道(安徽广德升平街店) | 2 | 2.0% |
茶百道(金银潭永旺店) | 1 | 1.0% |
茶百道(美领馆店) | 1 | 1.0% |
金牛万达店 | 1 | 1.0% |
Other values (3) | 3 | 3.0% |
Length
Value | Count | Frequency (%) |
茶百道(新疆汇嘉时代店) | 32 | |
途尚_北京望京soho店 | 23 | |
苏宁广场 | 16 | |
茶百道(温江财大东门店) | 9 | 9.0% |
爱琴海 | 9 | 9.0% |
茶百道(长沙黄兴路步行街店) | 3 | 3.0% |
茶百道(安徽广德升平街店) | 2 | 2.0% |
茶百道(金银潭永旺店) | 1 | 1.0% |
茶百道(美领馆店 | 1 | 1.0% |
金牛万达店 | 1 | 1.0% |
Other values (3) | 3 | 3.0% |
CRTFC_STR_ADDR
Categorical
Distinct | 13 |
---|---|
Distinct (%) | 13.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | |
---|---|
望京soho | |
苏宁广场 | |
四川省成都市温江区柳浪湾北一街224号 | |
爱琴海 | |
Other values (8) |
Length
Max length | 29 |
---|---|
Median length | 27 |
Mean length | 12.14 |
Min length | 3 |
Unique
Unique | 6 ? |
---|---|
Unique (%) | 6.0% |
Sample
1st row | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 |
---|---|
2nd row | 四川省成都市温江区柳浪湾北一街224号 |
3rd row | 四川省成都市温江区柳浪湾北一街224号 |
4th row | 四川省成都市温江区柳浪湾北一街224号 |
5th row | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 |
Common Values
Value | Count | Frequency (%) |
新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 32 | |
望京soho | 23 | |
苏宁广场 | 16 | |
四川省成都市温江区柳浪湾北一街224号 | 9 | 9.0% |
爱琴海 | 9 | 9.0% |
湖南省长沙市天心区黄兴南路537号(酷壳花甲隔壁) | 3 | 3.0% |
安徽省广德市桃州镇升平街茶百道 | 2 | 2.0% |
武汉市东西湖区金银潭大道7号 凯旋名居5-1-2901 | 1 | 1.0% |
成都市武侯区领事馆路2号附3号 | 1 | 1.0% |
金牛区一环路北三段1号 | 1 | 1.0% |
Other values (3) | 3 | 3.0% |
Length
Value | Count | Frequency (%) |
新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 32 | |
望京soho | 23 | |
苏宁广场 | 16 | |
四川省成都市温江区柳浪湾北一街224号 | 9 | 8.9% |
爱琴海 | 9 | 8.9% |
湖南省长沙市天心区黄兴南路537号(酷壳花甲隔壁) | 3 | 3.0% |
安徽省广德市桃州镇升平街茶百道 | 2 | 2.0% |
武汉市东西湖区金银潭大道7号 | 1 | 1.0% |
凯旋名居5-1-2901 | 1 | 1.0% |
成都市武侯区领事馆路2号附3号 | 1 | 1.0% |
Other values (4) | 4 | 4.0% |
COUPON_NM
Categorical
Distinct | 7 |
---|---|
Distinct (%) | 7.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
恭喜你获得一张10元代金券 | |
---|---|
<NA> | |
咖啡免费升杯券或秋季饮品7折券 | |
中杯美式或拿铁兑换券 | |
甜品券 | |
Other values (2) | 2 |
Length
Max length | 30 |
---|---|
Median length | 15 |
Mean length | 9.49 |
Min length | 3 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 2.0% |
Sample
1st row | <NA> |
---|---|
2nd row | 恭喜你获得一张10元代金券 |
3rd row | 恭喜你获得一张10元代金券 |
4th row | 恭喜你获得一张10元代金券 |
5th row | 恭喜你获得一张10元代金券 |
Common Values
Value | Count | Frequency (%) |
恭喜你获得一张10元代金券 | 43 | |
<NA> | 32 | |
咖啡免费升杯券或秋季饮品7折券 | 9 | 9.0% |
中杯美式或拿铁兑换券 | 7 | 7.0% |
甜品券 | 7 | 7.0% |
50元代金券 | 1 | 1.0% |
在【漫咖啡】可兑换一杯咖啡或者在【蜂馥】兑换面包或者咖啡一杯 | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
恭喜你获得一张10元代金券 | 43 | |
na | 32 | |
咖啡免费升杯券或秋季饮品7折券 | 9 | 9.0% |
中杯美式或拿铁兑换券 | 7 | 7.0% |
甜品券 | 7 | 7.0% |
50元代金券 | 1 | 1.0% |
在【漫咖啡】可兑换一杯咖啡或者在【蜂馥】兑换面包或者咖啡一杯 | 1 | 1.0% |
COUPON_ID
Categorical
Distinct | 28 |
---|---|
Distinct (%) | 28.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
쿠폰미발급 | |
---|---|
fed0d6a425b649e1bb5196b627fe1cb2 | 4 |
5820e8f2a73f419cb7e326d525f5276f | 4 |
4456eb188c4540ee9896472e701f5d69 | 4 |
39cac3b74b3144d5b64b33d3de8041c5 | 3 |
Other values (23) |
Length
Max length | 32 |
---|---|
Median length | 32 |
Mean length | 23.36 |
Min length | 5 |
Unique
Unique | 6 ? |
---|---|
Unique (%) | 6.0% |
Sample
1st row | 쿠폰미발급 |
---|---|
2nd row | 4a8e0af715b24cb2aec65fa919897d67 |
3rd row | f46ff1856d1746eabf89ea484867a951 |
4th row | edc50af88eb1490abf93c1fcf6c5935f |
5th row | 3277c57e472242d3ba090533fb24a2df |
Common Values
Value | Count | Frequency (%) |
쿠폰미발급 | 32 | |
fed0d6a425b649e1bb5196b627fe1cb2 | 4 | 4.0% |
5820e8f2a73f419cb7e326d525f5276f | 4 | 4.0% |
4456eb188c4540ee9896472e701f5d69 | 4 | 4.0% |
39cac3b74b3144d5b64b33d3de8041c5 | 3 | 3.0% |
827f2dd08f584f2f8da96b1a14a98d03 | 3 | 3.0% |
892f82cf0537457280123c1ac9602be3 | 3 | 3.0% |
3277c57e472242d3ba090533fb24a2df | 3 | 3.0% |
edc50af88eb1490abf93c1fcf6c5935f | 3 | 3.0% |
f46ff1856d1746eabf89ea484867a951 | 3 | 3.0% |
Other values (18) | 38 |
Length
Value | Count | Frequency (%) |
쿠폰미발급 | 32 | |
5820e8f2a73f419cb7e326d525f5276f | 4 | 4.0% |
4456eb188c4540ee9896472e701f5d69 | 4 | 4.0% |
fed0d6a425b649e1bb5196b627fe1cb2 | 4 | 4.0% |
9232fdb487c14e08af41e2c40e39cd44 | 3 | 3.0% |
c7c6a34855e649f4b3b54e92a3794b1f | 3 | 3.0% |
245f8def0adb4dd9952d9276c4b9019b | 3 | 3.0% |
0f72293538e344889f8bae2538453101 | 3 | 3.0% |
82c753cdb8bf4d239ada4f0e94826d94 | 3 | 3.0% |
4a8e0af715b24cb2aec65fa919897d67 | 3 | 3.0% |
Other values (18) | 38 |
COUPON_USGSTT_NM
Categorical
Distinct | 3 |
---|---|
Distinct (%) | 3.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
사용 | |
---|---|
<NA> | |
발급 |
Length
Max length | 4 |
---|---|
Median length | 2 |
Mean length | 2.64 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | <NA> |
---|---|
2nd row | 사용 |
3rd row | 사용 |
4th row | 사용 |
5th row | 사용 |
Common Values
Value | Count | Frequency (%) |
사용 | 42 | |
<NA> | 32 | |
발급 | 26 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
사용 | 42 | |
na | 32 | |
발급 | 26 |
COUPON_USE_DT
Real number (ℝ)
MISSING
 
Distinct | 17 |
---|---|
Distinct (%) | 40.5% |
Missing | 58 |
Missing (%) | 58.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.0200917 × 1013 |
Minimum | 2.0200717 × 1013 |
---|---|
Maximum | 2.0201016 × 1013 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 2.0200717 × 1013 |
---|---|
5-th percentile | 2.0200717 × 1013 |
Q1 | 2.0200901 × 1013 |
median | 2.020092 × 1013 |
Q3 | 2.020101 × 1013 |
95-th percentile | 2.0201016 × 1013 |
Maximum | 2.0201016 × 1013 |
Range | 2.9896394 × 108 |
Interquartile range (IQR) | 1.0898695 × 108 |
Descriptive statistics
Standard deviation | 1.1318324 × 108 |
---|---|
Coefficient of variation (CV) | 5.6028764 × 10-6 |
Kurtosis | -0.67319047 |
Mean | 2.0200917 × 1013 |
Median Absolute Deviation (MAD) | 90008809 |
Skewness | -0.8984905 |
Sum | 8.484385 × 1014 |
Variance | 1.2810446 × 1016 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20201016124822 | 4 | 4.0% |
20200901183806 | 3 | 3.0% |
20201016124851 | 3 | 3.0% |
20201003122356 | 3 | 3.0% |
20201011144623 | 3 | 3.0% |
20201008210035 | 3 | 3.0% |
20200720193505 | 3 | 3.0% |
20200905193242 | 3 | 3.0% |
20200717160908 | 3 | 3.0% |
20200725184218 | 3 | 3.0% |
Other values (7) | 11 | 11.0% |
(Missing) | 58 |
Value | Count | Frequency (%) |
20200717160908 | 3 | |
20200720193505 | 3 | |
20200725184218 | 3 | |
20200901183806 | 3 | |
20200903190548 | 1 | 1.0% |
20200905151225 | 1 | 1.0% |
20200905151250 | 1 | 1.0% |
20200905193242 | 3 | |
20200911204225 | 2 | |
20200920161949 | 2 |
Value | Count | Frequency (%) |
20201016124851 | 3 | |
20201016124822 | 4 | |
20201011144623 | 3 | |
20201010170758 | 3 | |
20201009181722 | 1 | 1.0% |
20201008210035 | 3 | |
20201003122356 | 3 | |
20200920161949 | 2 | |
20200911204225 | 2 | |
20200905193242 | 3 |
COUPON_USE_STR_NM
Categorical
Distinct | 6 |
---|---|
Distinct (%) | 6.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
<NA> | |
---|---|
茶百道(新疆汇嘉时代店) | |
茶百道(温江财大东门店) | |
途尚_北京望京soho店 | |
漫咖啡&蜂馥 | 1 |
Length
Max length | 12 |
---|---|
Median length | 4 |
Mean length | 7.29 |
Min length | 4 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 2.0% |
Sample
1st row | <NA> |
---|---|
2nd row | 茶百道(温江财大东门店) |
3rd row | 茶百道(温江财大东门店) |
4th row | 茶百道(温江财大东门店) |
5th row | 茶百道(新疆汇嘉时代店) |
Common Values
Value | Count | Frequency (%) |
<NA> | 58 | |
茶百道(新疆汇嘉时代店) | 24 | |
茶百道(温江财大东门店) | 9 | 9.0% |
途尚_北京望京soho店 | 7 | 7.0% |
漫咖啡&蜂馥 | 1 | 1.0% |
茶百道(双楠人人乐店) | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
na | 58 | |
茶百道(新疆汇嘉时代店) | 24 | |
茶百道(温江财大东门店) | 9 | 9.0% |
途尚_北京望京soho店 | 7 | 7.0% |
漫咖啡&蜂馥 | 1 | 1.0% |
茶百道(双楠人人乐店 | 1 | 1.0% |
COUPON_USE_STR_ADDR
Categorical
Distinct | 6 |
---|---|
Distinct (%) | 6.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
<NA> | |
---|---|
新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | |
四川省成都市温江区柳浪湾北一街224号 | |
望京soho | |
漫咖啡&蜂馥 | 1 |
Length
Max length | 19 |
---|---|
Median length | 4 |
Mean length | 9.2 |
Min length | 4 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 2.0% |
Sample
1st row | <NA> |
---|---|
2nd row | 四川省成都市温江区柳浪湾北一街224号 |
3rd row | 四川省成都市温江区柳浪湾北一街224号 |
4th row | 四川省成都市温江区柳浪湾北一街224号 |
5th row | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 |
Common Values
Value | Count | Frequency (%) |
<NA> | 58 | |
新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 24 | |
四川省成都市温江区柳浪湾北一街224号 | 9 | 9.0% |
望京soho | 7 | 7.0% |
漫咖啡&蜂馥 | 1 | 1.0% |
成都市武侯区双楠路273号 | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
na | 58 | |
新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 24 | |
四川省成都市温江区柳浪湾北一街224号 | 9 | 9.0% |
望京soho | 7 | 7.0% |
漫咖啡&蜂馥 | 1 | 1.0% |
成都市武侯区双楠路273号 | 1 | 1.0% |
COUPON_BNEF_CN
Categorical
Distinct | 6 |
---|---|
Distinct (%) | 6.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
可兑换店内任意一款饮品补差价即可 | |
---|---|
<NA> | |
优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | |
秋季饮品7折券截止日期为9月30日 优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | |
下次消费满198元,立减50元 本券不与其他优惠活动同享,重大节假日不可用,每桌限用一张。 | 1 |
Length
Max length | 56 |
---|---|
Median length | 45 |
Mean length | 19.14 |
Min length | 4 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 2.0% |
Sample
1st row | <NA> |
---|---|
2nd row | 可兑换店内任意一款饮品补差价即可 |
3rd row | 可兑换店内任意一款饮品补差价即可 |
4th row | 可兑换店内任意一款饮品补差价即可 |
5th row | 可兑换店内任意一款饮品补差价即可 |
Common Values
Value | Count | Frequency (%) |
可兑换店内任意一款饮品补差价即可 | 43 | |
<NA> | 32 | |
优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | 14 | 14.0% |
秋季饮品7折券截止日期为9月30日 优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | 9 | 9.0% |
下次消费满198元,立减50元 本券不与其他优惠活动同享,重大节假日不可用,每桌限用一张。 | 1 | 1.0% |
不与店内其他优惠同享,不可叠加使用 | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
可兑换店内任意一款饮品补差价即可 | 43 | |
na | 32 | |
优惠不可同享,不找零不兑换现金,不计入开发票金额; | 23 | |
可在途尚咖啡直营门店兑换 | 23 | |
秋季饮品7折券截止日期为9月30日 | 9 | 6.8% |
下次消费满198元,立减50元 | 1 | 0.8% |
本券不与其他优惠活动同享,重大节假日不可用,每桌限用一张。 | 1 | 0.8% |
不与店内其他优惠同享,不可叠加使用 | 1 | 0.8% |
CLUSTR_ID
Categorical
IMBALANCE
 
Distinct | 3 |
---|---|
Distinct (%) | 3.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
0 | |
---|---|
1 | |
2 | 1 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 1.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 83 | |
1 | 16 | 16.0% |
2 | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 83 | |
1 | 16 | 16.0% |
2 | 1 | 1.0% |
ESNTL_ID
Categorical
Distinct | 9 |
---|---|
Distinct (%) | 9.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
V00A020B007S0022FSC040 | |
---|---|
V00A004B005S0005FSC011 | |
V00A020B007S0022FSC018 | |
V00A015B265S0016FSC001 | |
V00A015B255S0016FSC001 | |
Other values (4) |
Length
Max length | 22 |
---|---|
Median length | 22 |
Mean length | 22 |
Min length | 22 |
Unique
Unique | 4 ? |
---|---|
Unique (%) | 4.0% |
Sample
1st row | V00A020B007S0022FSC040 |
---|---|
2nd row | V00A020B007S0022FSC018 |
3rd row | V00A020B007S0022FSC018 |
4th row | V00A020B007S0022FSC018 |
5th row | V00A020B007S0022FSC040 |
Common Values
Value | Count | Frequency (%) |
V00A020B007S0022FSC040 | 32 | |
V00A004B005S0005FSC011 | 23 | |
V00A020B007S0022FSC018 | 16 | |
V00A015B265S0016FSC001 | 16 | |
V00A015B255S0016FSC001 | 9 | 9.0% |
V00A020B007S0022FSC041 | 1 | 1.0% |
V00A031B008S0032FSC001 | 1 | 1.0% |
V00A015B256S0016FSC001 | 1 | 1.0% |
V00A020B007S0022FSC045 | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
v00a020b007s0022fsc040 | 32 | |
v00a004b005s0005fsc011 | 23 | |
v00a020b007s0022fsc018 | 16 | |
v00a015b265s0016fsc001 | 16 | |
v00a015b255s0016fsc001 | 9 | 9.0% |
v00a020b007s0022fsc041 | 1 | 1.0% |
v00a031b008s0032fsc001 | 1 | 1.0% |
v00a015b256s0016fsc001 | 1 | 1.0% |
v00a020b007s0022fsc045 | 1 | 1.0% |
SEQ_NO | PROMTN_TY_CD | PROMTN_TY_NM | PROMTN_NM | PROMTN_BNEF_CN | BRAND_NM | CSTMR_ID | TRMNL_MODL_NM | TRMNL_MODL_OPERSYSM_TY_CD | TRMNL_MODL_OPERSYSM_TY_NM | CRTFC_DT | CRTFC_FLAG_NM | CRTFC_STR_NM | CRTFC_STR_ADDR | COUPON_NM | COUPON_ID | COUPON_USGSTT_NM | COUPON_USE_DT | COUPON_USE_STR_NM | COUPON_USE_STR_ADDR | COUPON_BNEF_CN | CLUSTR_ID | ESNTL_ID | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | 14 | 중국할인프로모션참여고객성향 | 盖盖章,饮品免费拿U | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 优惠券有效期:从获得之日90天内有效; | 茶百道 | oxGQgxMcjOIV8vY4Fx80F8Q63lnE | <NA> | 단말모델미분류 | <NA> | 20200930235023 | 적립 | 茶百道(新疆汇嘉时代店) | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | <NA> | 쿠폰미발급 | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | V00A020B007S0022FSC040 |
1 | 2 | 14 | 중국할인프로모션참여고객성향 | 盖盖章,饮品免费拿 | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 所集印章仅限本店累计,不可和其他门店通用; 优惠券有效期:从获得之日90天内有效; | 茶百道 | oxGQgxKBCbYJDd-bOCcpXG3p1Gc0 | <NA> | 단말모델미분류 | <NA> | 20200930224429 | 사용 | 茶百道(温江财大东门店) | 四川省成都市温江区柳浪湾北一街224号 | 恭喜你获得一张10元代金券 | 4a8e0af715b24cb2aec65fa919897d67 | 사용 | 20201008210035 | 茶百道(温江财大东门店) | 四川省成都市温江区柳浪湾北一街224号 | 可兑换店内任意一款饮品补差价即可 | 0 | V00A020B007S0022FSC018 |
2 | 3 | 14 | 중국할인프로모션참여고객성향 | 盖盖章,饮品免费拿 | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 所集印章仅限本店累计,不可和其他门店通用; 优惠券有效期:从获得之日90天内有效; | 茶百道 | oxGQgxKBCbYJDd-bOCcpXG3p1Gc0 | <NA> | 단말모델미분류 | <NA> | 20200930224429 | 사용 | 茶百道(温江财大东门店) | 四川省成都市温江区柳浪湾北一街224号 | 恭喜你获得一张10元代金券 | f46ff1856d1746eabf89ea484867a951 | 사용 | 20201003122356 | 茶百道(温江财大东门店) | 四川省成都市温江区柳浪湾北一街224号 | 可兑换店内任意一款饮品补差价即可 | 0 | V00A020B007S0022FSC018 |
3 | 4 | 14 | 중국할인프로모션참여고객성향 | 盖盖章,饮品免费拿 | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 所集印章仅限本店累计,不可和其他门店通用; 优惠券有效期:从获得之日90天内有效; | 茶百道 | oxGQgxKBCbYJDd-bOCcpXG3p1Gc0 | <NA> | 단말모델미분류 | <NA> | 20200930224429 | 사용 | 茶百道(温江财大东门店) | 四川省成都市温江区柳浪湾北一街224号 | 恭喜你获得一张10元代金券 | edc50af88eb1490abf93c1fcf6c5935f | 사용 | 20201010170758 | 茶百道(温江财大东门店) | 四川省成都市温江区柳浪湾北一街224号 | 可兑换店内任意一款饮品补差价即可 | 0 | V00A020B007S0022FSC018 |
4 | 5 | 14 | 중국할인프로모션참여고객성향 | 盖盖章,饮品免费拿U | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 优惠券有效期:从获得之日90天内有效; | 茶百道 | oxGQgxFCWgOpqg_nihPMSJhDmk3M | <NA> | 단말모델미분류 | <NA> | 20200930222603 | 사용 | 茶百道(新疆汇嘉时代店) | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 恭喜你获得一张10元代金券 | 3277c57e472242d3ba090533fb24a2df | 사용 | 20200725184218 | 茶百道(新疆汇嘉时代店) | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 可兑换店内任意一款饮品补差价即可 | 0 | V00A020B007S0022FSC040 |
5 | 6 | 14 | 중국할인프로모션참여고객성향 | 盖盖章,饮品免费拿U | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 优惠券有效期:从获得之日90天内有效; | 茶百道 | oxGQgxFCWgOpqg_nihPMSJhDmk3M | <NA> | 단말모델미분류 | <NA> | 20200930222603 | 사용 | 茶百道(新疆汇嘉时代店) | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 恭喜你获得一张10元代金券 | 892f82cf0537457280123c1ac9602be3 | 사용 | 20200717160908 | 茶百道(新疆汇嘉时代店) | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 可兑换店内任意一款饮品补差价即可 | 0 | V00A020B007S0022FSC040 |
6 | 7 | 14 | 중국할인프로모션참여고객성향 | 盖盖章,饮品免费拿U | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 优惠券有效期:从获得之日90天内有效; | 茶百道 | oxGQgxFCWgOpqg_nihPMSJhDmk3M | <NA> | 단말모델미분류 | <NA> | 20200930222603 | 사용 | 茶百道(新疆汇嘉时代店) | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 恭喜你获得一张10元代金券 | 827f2dd08f584f2f8da96b1a14a98d03 | 사용 | 20200905193242 | 茶百道(新疆汇嘉时代店) | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 可兑换店内任意一款饮品补差价即可 | 0 | V00A020B007S0022FSC040 |
7 | 8 | 14 | 중국할인프로모션참여고객성향 | 盖盖章,饮品免费拿U | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 优惠券有效期:从获得之日90天内有效; | 茶百道 | oxGQgxFCWgOpqg_nihPMSJhDmk3M | <NA> | 단말모델미분류 | <NA> | 20200930222603 | 사용 | 茶百道(新疆汇嘉时代店) | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 恭喜你获得一张10元代金券 | 39cac3b74b3144d5b64b33d3de8041c5 | 사용 | 20200720193505 | 茶百道(新疆汇嘉时代店) | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 可兑换店内任意一款饮品补差价即可 | 0 | V00A020B007S0022FSC040 |
8 | 9 | 14 | 중국할인프로모션참여고객성향 | 盖盖章,饮品免费拿U | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 优惠券有效期:从获得之日90天内有效; | 茶百道 | oxGQgxFCWgOpqg_nihPMSJhDmk3M | <NA> | 단말모델미분류 | <NA> | 20200930222603 | 사용 | 茶百道(新疆汇嘉时代店) | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 恭喜你获得一张10元代金券 | f161b1b422794f759538f8608b2672af | 사용 | 20200901183806 | 茶百道(新疆汇嘉时代店) | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 可兑换店内任意一款饮品补差价即可 | 0 | V00A020B007S0022FSC040 |
9 | 10 | 14 | 중국할인프로모션참여고객성향 | 盖盖章,饮品免费拿U | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 优惠券有效期:从获得之日90天内有效; | 茶百道 | oxGQgxFCWgOpqg_nihPMSJhDmk3M | <NA> | 단말모델미분류 | <NA> | 20200930222603 | 사용 | 茶百道(新疆汇嘉时代店) | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 恭喜你获得一张10元代金券 | 9232fdb487c14e08af41e2c40e39cd44 | 사용 | 20201011144623 | 茶百道(新疆汇嘉时代店) | 新疆库尔勒朝阳路汇嘉时代广场5楼茶百道 | 可兑换店内任意一款饮品补差价即可 | 0 | V00A020B007S0022FSC040 |
SEQ_NO | PROMTN_TY_CD | PROMTN_TY_NM | PROMTN_NM | PROMTN_BNEF_CN | BRAND_NM | CSTMR_ID | TRMNL_MODL_NM | TRMNL_MODL_OPERSYSM_TY_CD | TRMNL_MODL_OPERSYSM_TY_NM | CRTFC_DT | CRTFC_FLAG_NM | CRTFC_STR_NM | CRTFC_STR_ADDR | COUPON_NM | COUPON_ID | COUPON_USGSTT_NM | COUPON_USE_DT | COUPON_USE_STR_NM | COUPON_USE_STR_ADDR | COUPON_BNEF_CN | CLUSTR_ID | ESNTL_ID | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90 | 91 | 14 | 중국할인프로모션참여고객성향 | Twosome Coffe 2020 | 折扣后任意消费满20元即可获得印章1枚 可累计集章,满20元集1枚,满40元集2枚… · 累积3枚印章,获赠咖啡免费升杯券或秋季饮品7折券 · 累积6枚印章,获得中杯美式或拿铁兑换券1张 · 累积9枚印章,获赠甜品券1张 券有效期 :发券后30日(*秋季饮品7折券截止日期为9月30日) 使用店铺:途尚咖啡直营店 | 途尚咖啡 | okzZ81CHgWTToAtpFoVxkXqfc1Ag | <NA> | 단말모델미분류 | <NA> | 20200930201238 | 쿠폰발급 | 途尚_北京望京soho店 | 望京soho | 咖啡免费升杯券或秋季饮品7折券 | c7c6a34855e649f4b3b54e92a3794b1f | 발급 | <NA> | <NA> | <NA> | 秋季饮品7折券截止日期为9月30日 优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | 0 | V00A004B005S0005FSC011 |
91 | 92 | 14 | 중국할인프로모션참여고객성향 | Twosome Coffe 2020 | 折扣后任意消费满20元即可获得印章1枚 可累计集章,满20元集1枚,满40元集2枚… · 累积3枚印章,获赠咖啡免费升杯券或秋季饮品7折券 · 累积6枚印章,获得中杯美式或拿铁兑换券1张 · 累积9枚印章,获赠甜品券1张 券有效期 :发券后30日(*秋季饮品7折券截止日期为9月30日) 使用店铺:途尚咖啡直营店 | 途尚咖啡 | okzZ81CHgWTToAtpFoVxkXqfc1Ag | <NA> | 단말모델미분류 | <NA> | 20200930201236 | 사용 | 途尚_北京望京soho店 | 望京soho | 中杯美式或拿铁兑换券 | 5820e8f2a73f419cb7e326d525f5276f | 사용 | 20201016124822 | 途尚_北京望京soho店 | 望京soho | 优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | 0 | V00A004B005S0005FSC011 |
92 | 93 | 14 | 중국할인프로모션참여고객성향 | Twosome Coffe 2020 | 折扣后任意消费满20元即可获得印章1枚 可累计集章,满20元集1枚,满40元集2枚… · 累积3枚印章,获赠咖啡免费升杯券或秋季饮品7折券 · 累积6枚印章,获得中杯美式或拿铁兑换券1张 · 累积9枚印章,获赠甜品券1张 券有效期 :发券后30日(*秋季饮品7折券截止日期为9月30日) 使用店铺:途尚咖啡直营店 | 途尚咖啡 | okzZ81CHgWTToAtpFoVxkXqfc1Ag | <NA> | 단말모델미분류 | <NA> | 20200930201236 | 쿠폰발급 | 途尚_北京望京soho店 | 望京soho | 甜品券 | fed0d6a425b649e1bb5196b627fe1cb2 | 발급 | <NA> | <NA> | <NA> | 优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | 0 | V00A004B005S0005FSC011 |
93 | 94 | 14 | 중국할인프로모션참여고객성향 | Twosome Coffe 2020 | 折扣后任意消费满20元即可获得印章1枚 可累计集章,满20元集1枚,满40元集2枚… · 累积3枚印章,获赠咖啡免费升杯券或秋季饮品7折券 · 累积6枚印章,获得中杯美式或拿铁兑换券1张 · 累积9枚印章,获赠甜品券1张 券有效期 :发券后30日(*秋季饮品7折券截止日期为9月30日) 使用店铺:途尚咖啡直营店 | 途尚咖啡 | okzZ81CHgWTToAtpFoVxkXqfc1Ag | <NA> | 단말모델미분류 | <NA> | 20200930201236 | 쿠폰발급 | 途尚_北京望京soho店 | 望京soho | 甜品券 | 82c753cdb8bf4d239ada4f0e94826d94 | 발급 | <NA> | <NA> | <NA> | 优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | 0 | V00A004B005S0005FSC011 |
94 | 95 | 14 | 중국할인프로모션참여고객성향 | Twosome Coffe 2020 | 折扣后任意消费满20元即可获得印章1枚 可累计集章,满20元集1枚,满40元集2枚… · 累积3枚印章,获赠咖啡免费升杯券或秋季饮品7折券 · 累积6枚印章,获得中杯美式或拿铁兑换券1张 · 累积9枚印章,获赠甜品券1张 券有效期 :发券后30日(*秋季饮品7折券截止日期为9月30日) 使用店铺:途尚咖啡直营店 | 途尚咖啡 | okzZ81CHgWTToAtpFoVxkXqfc1Ag | <NA> | 단말모델미분류 | <NA> | 20200930201236 | 쿠폰발급 | 途尚_北京望京soho店 | 望京soho | 咖啡免费升杯券或秋季饮品7折券 | 445372890c8c4ad58b9e0a12f1e91da2 | 발급 | <NA> | <NA> | <NA> | 秋季饮品7折券截止日期为9月30日 优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | 0 | V00A004B005S0005FSC011 |
95 | 96 | 14 | 중국할인프로모션참여고객성향 | Twosome Coffe 2020 | 折扣后任意消费满20元即可获得印章1枚 可累计集章,满20元集1枚,满40元集2枚… · 累积3枚印章,获赠咖啡免费升杯券或秋季饮品7折券 · 累积6枚印章,获得中杯美式或拿铁兑换券1张 · 累积9枚印章,获赠甜品券1张 券有效期 :发券后30日(*秋季饮品7折券截止日期为9月30日) 使用店铺:途尚咖啡直营店 | 途尚咖啡 | okzZ81CHgWTToAtpFoVxkXqfc1Ag | <NA> | 단말모델미분류 | <NA> | 20200930201236 | 쿠폰발급 | 途尚_北京望京soho店 | 望京soho | 中杯美式或拿铁兑换券 | 0f72293538e344889f8bae2538453101 | 발급 | <NA> | <NA> | <NA> | 优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | 0 | V00A004B005S0005FSC011 |
96 | 97 | 14 | 중국할인프로모션참여고객성향 | Twosome Coffe 2020 | 折扣后任意消费满20元即可获得印章1枚 可累计集章,满20元集1枚,满40元集2枚… · 累积3枚印章,获赠咖啡免费升杯券或秋季饮品7折券 · 累积6枚印章,获得中杯美式或拿铁兑换券1张 · 累积9枚印章,获赠甜品券1张 券有效期 :发券后30日(*秋季饮品7折券截止日期为9月30日) 使用店铺:途尚咖啡直营店 | 途尚咖啡 | okzZ81CHgWTToAtpFoVxkXqfc1Ag | <NA> | 단말모델미분류 | <NA> | 20200930201236 | 사용 | 途尚_北京望京soho店 | 望京soho | 咖啡免费升杯券或秋季饮品7折券 | 245f8def0adb4dd9952d9276c4b9019b | 사용 | 20201016124851 | 途尚_北京望京soho店 | 望京soho | 秋季饮品7折券截止日期为9月30日 优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | 0 | V00A004B005S0005FSC011 |
97 | 98 | 14 | 중국할인프로모션참여고객성향 | Twosome Coffe 2020 | 折扣后任意消费满20元即可获得印章1枚 可累计集章,满20元集1枚,满40元集2枚… · 累积3枚印章,获赠咖啡免费升杯券或秋季饮品7折券 · 累积6枚印章,获得中杯美式或拿铁兑换券1张 · 累积9枚印章,获赠甜品券1张 券有效期 :发券后30日(*秋季饮品7折券截止日期为9月30日) 使用店铺:途尚咖啡直营店 | 途尚咖啡 | okzZ81CHgWTToAtpFoVxkXqfc1Ag | <NA> | 단말모델미분류 | <NA> | 20200930201236 | 쿠폰발급 | 途尚_北京望京soho店 | 望京soho | 咖啡免费升杯券或秋季饮品7折券 | c7c6a34855e649f4b3b54e92a3794b1f | 발급 | <NA> | <NA> | <NA> | 秋季饮品7折券截止日期为9月30日 优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | 0 | V00A004B005S0005FSC011 |
98 | 99 | 14 | 중국할인프로모션참여고객성향 | Twosome Coffe 2020 | 折扣后任意消费满20元即可获得印章1枚 可累计集章,满20元集1枚,满40元集2枚… · 累积3枚印章,获赠咖啡免费升杯券或秋季饮品7折券 · 累积6枚印章,获得中杯美式或拿铁兑换券1张 · 累积9枚印章,获赠甜品券1张 券有效期 :发券后30日(*秋季饮品7折券截止日期为9月30日) 使用店铺:途尚咖啡直营店 | 途尚咖啡 | okzZ81CHgWTToAtpFoVxkXqfc1Ag | <NA> | 단말모델미분류 | <NA> | 20200930201234 | 사용 | 途尚_北京望京soho店 | 望京soho | 中杯美式或拿铁兑换券 | 5820e8f2a73f419cb7e326d525f5276f | 사용 | 20201016124822 | 途尚_北京望京soho店 | 望京soho | 优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | 0 | V00A004B005S0005FSC011 |
99 | 100 | 14 | 중국할인프로모션참여고객성향 | Twosome Coffe 2020 | 折扣后任意消费满20元即可获得印章1枚 可累计集章,满20元集1枚,满40元集2枚… · 累积3枚印章,获赠咖啡免费升杯券或秋季饮品7折券 · 累积6枚印章,获得中杯美式或拿铁兑换券1张 · 累积9枚印章,获赠甜品券1张 券有效期 :发券后30日(*秋季饮品7折券截止日期为9月30日) 使用店铺:途尚咖啡直营店 | 途尚咖啡 | okzZ81CHgWTToAtpFoVxkXqfc1Ag | <NA> | 단말모델미분류 | <NA> | 20200930201234 | 쿠폰발급 | 途尚_北京望京soho店 | 望京soho | 甜品券 | fed0d6a425b649e1bb5196b627fe1cb2 | 발급 | <NA> | <NA> | <NA> | 优惠不可同享,不找零不兑换现金,不计入开发票金额; 可在途尚咖啡直营门店兑换 | 0 | V00A004B005S0005FSC011 |