任务描述
需求描述
业务背景
根据24814需求构建的三张表，缺少算法训练模型所需的部分产品信息字段（原24814需求中有列明），现对该部分进行补充说明。
需求描述
涉及功能：1、智能选品提报ASIN详情采集（最优先） 2、历史数据：正/负项库采集。（日常补充）
补充说明采集卖家精灵如下界面：
（一）【查竞品】板块，补充前台没有的产品信息
采集搜索条件-->>ASIN+站点
采集补充放在：t_putgoods_asin_us-->>ASIN采集详情表
以下是序号对应说明，采集位置参考上图标记。如有【已有该字段】标识，说明在t_putgoods_asin_XX有类似字段。
（二）【关键词挖掘】板块，补充关键词相关信息
采集搜索条件-->>关键词
采集补充放在：t_putgoods_20XXXX-->>待提报业务表
补充以下界面的字段信息（红框）
重点字段-->>关键词的月搜索趋势，其中月搜索量走势和ABA排名走势都需要按月储存下来。
注：关键词对应的信息，只采可提报（经过滤后可用可推）关键词的其中一个（按排序靠前的优先采），不用全部关键词都采。
验收标准
提报对应得采集数据正常采集，用于智选模型提报与训练
1、添加字段
ALTER TABLE `zhcxkj_aidata`.`t_putgoods_asin_us`
ADD COLUMN `symbol` varchar(10) NULL COMMENT '是否畅销Y/N',
ADD COLUMN `variations` int NULL COMMENT '变体数',
ADD COLUMN `amzUnit` int NULL COMMENT '字体销量',
ADD COLUMN `subTotalAmount` decimal(18, 2) NULL COMMENT '字体销售额',
ADD COLUMN `totalUnits` int NULL COMMENT '父体销量',
ADD COLUMN `totalAmount` decimal(18, 4) NULL COMMENT '父体销售额',
ADD COLUMN `totalUnitsGrowth` decimal(18, 2) NULL COMMENT '父体销量月增速',
ADD COLUMN `newRelease` decimal(18, 2) NULL COMMENT '新品榜Y/N',
ADD COLUMN `bsrRankCv` INT NULL COMMENT '大类增长数',
ADD COLUMN `bsrRankCr` decimal(18, 2) NULL COMMENT '大类增长率',
ADD COLUMN `video` varchar(10) NULL COMMENT '是否有视频Y/N',
ADD COLUMN `ebc` varchar(10) NULL COMMENT '有APlusY/N',
ADD COLUMN `questions` INT NULL COMMENT 'QA数',
ADD COLUMN `reviewsIncreasement` int NULL COMMENT '月新增评论',
ADD COLUMN `reviewsRate` decimal(18, 2) NULL COMMENT '留评率',
ADD COLUMN `fba` decimal(18, 2) NULL COMMENT 'Fba运费',
ADD COLUMN `profit` decimal(18, 2) NULL COMMENT '毛利率',
ADD COLUMN `sellerType` varchar(10) NULL COMMENT '配送方式',
ADD COLUMN `sellerName` varchar(100) NULL COMMENT '卖家名称',
ADD COLUMN `sellerNation` varchar(10) NULL COMMENT '卖家国别';
newRelease，#1 New Release in Violin Shoulder & Chin Rests，不为空赋值Y，否则N。
已有的字段：
小类，subcategories，[{"code": "11969001","rank": 199,"label": "Violin Shoulder & Chin Rests"}]
销量趋势，salesTrend
大类排名，大类排名
卖家信息（卖家数），sellers
2、增加关键词采集信息表，zhcxkj_aidata》t_putgoods_keyword_us
3、增加关键词采集任务表，mongodb》irobotbox》Seller_Keyword_Detail_US，采集状态status，1采集成功，2采集失败
4、增加服务，PutSpecimenCron2，同步关键词采集结果
5、关键词采集数据案例：
{
"market": "GLOBAL",
"marketId": 1,
"website": "https://www.amazon.com",
"keyword": "phone stand",
"keywordCn": "手机支架",
"keywordJp": "フォーンスタンド",
"departments": [{
"code": "wireless",
"label": "Cell Phones & Accessories"
}, {
"code": "videogames",
"label": "Video Games"
}, {
"code": "electronics",
"label": "Electronics"
}
],
"trends": [{
"month": "202202",
"search": 308941,
"searchRank": 1368
}, {
"month": "202203",
"search": 283642,
"searchRank": 1621
}, {
"month": "202204",
"search": 264425,
"searchRank": 1736
}, {
"month": "202205",
"search": 251276,
"searchRank": 1939
}, {
"month": "202206",
"search": 246015,
"searchRank": 1952
}, {
"month": "202207",
"search": 214444,
"searchRank": 2377
}, {
"month": "202208",
"search": 275490,
"searchRank": 1705
}, {
"month": "202209",
"search": 273484,
"searchRank": 1611
}, {
"month": "202210",
"search": 251038,
"searchRank": 1887
}, {
"month": "202211",
"search": 236432,
"searchRank": 2020
}, {
"month": "202212",
"search": 282546,
"searchRank": 1529
}, {
"month": "202301",
"search": 349067,
"searchRank": 1167
}, {
"month": "202302",
"search": 301499,
"searchRank": 1397
}, {
"month": "202303",
"search": 268967,
"searchRank": 1727
}, {
"month": "202304",
"search": 238017,
"searchRank": 2023
}, {
"month": "202305",
"search": 237376,
"searchRank": 2141
}, {
"month": "202306",
"search": 249025,
"searchRank": 1977
}, {
"month": "202307",
"search": 223872,
"searchRank": 2290
}, {
"month": "202308",
"search": 252641,
"searchRank": 1866
}, {
"month": "202309",
"search": 213709,
"searchRank": 2745
}, {
"month": "202310",
"search": 233979,
"searchRank": 1963
}, {
"month": "202311",
"search": 237326,
"searchRank": 1959
}, {
"month": "202312",
"search": 263998,
"searchRank": 1706
}, {
"month": "202401",
"search": 258418,
"searchRank": 1696
}, {
"month": "202402",
"search": 266272,
"searchRank": 1646
}, {
"month": "202403",
"search": 308600,
"searchRank": 1878
}, {
"month": "202404",
"search": 298941,
"searchRank": 1963
}, {
"month": "202405",
"search": 278204,
"searchRank": 2237
}, {
"month": "202406",
"search": 260024,
"searchRank": 2397
}, {
"month": "202407",
"search": 264506,
"searchRank": 2419
}, {
"month": "202408",
"search": 297678,
"searchRank": 2042
}, {
"month": "202409",
"search": 314775,
"searchRank": 1765
}, {
"month": "202410",
"search": 287433,
"searchRank": 2147
}, {
"month": "202411",
"search": 264016,
"searchRank": 1977
}, {
"month": "202412",
"search": 299641,
"searchRank": 1711
}, {
"month": "202501",
"search": 297171,
"searchRank": 1725
}
],
"month": "2025.01",
"supplement": "N",
"searches": 297171,
"purchases": 12303,
"purchaseRate": 0.0414,
"monopolyAsinDtos": [{
"asin": "B07F8S18D5",
"title": null,
"imageUrl": "https://m.media-amazon.com/images/I/31OR4pkm28L._AC_US200_.jpg",
"clickRate": 0.1382,
"conversionShareRate": 0.1201
}, {
"asin": "B09MCKK9NX",
"title": null,
"imageUrl": "https://m.media-amazon.com/images/I/41gleueVKkL._AC_US200_.jpg",
"clickRate": 0.0591,
"conversionShareRate": 0.0462
}, {
"asin": "B07Z82895W",
"title": null,
"imageUrl": "https://m.media-amazon.com/images/I/417iJirME2L._AC_SR200,200_.jpg",
"clickRate": 0.0539,
"conversionShareRate": 0.0426
}
],
"monopolyClickRate": 0.2511,
"gkDatas": [{
"station": "US",
"asin": "B0DDCHGF4G",
"asinImage": "https://m.media-amazon.com/images/I/41uQNGsPlBL._AC_SR200,200_.jpg",
"bigAsinImage": null,
"asinPrice": 12.99,
"asinReviews": 66,
"asinRating": 4.5,
"asinBrand": null,
"asinTitle": "Magnetic Phone Tripod Mount Adapter with 1/4"-20 Screw Hole, Compatible with Magsafe for iPhone 16/15/14/13/12 Plus Pro Max Mini Series, Adjustable Phone Holder for Tripod, Ring Light, Selfie Sticks"
}, {
"station": "US",
"asin": "B09TQY66NH",
"asinImage": "https://m.media-amazon.com/images/I/313DpjqFdhL._AC_US200_.jpg",
"bigAsinImage": null,
"asinPrice": 19.99,
"asinReviews": 32976,
"asinRating": 4.6,
"asinBrand": null,
"asinTitle": "SENSYNE 62" Phone Tripod & Selfie Stick, Extendable Cell Phone Tripod Stand with Wireless Remote and Phone Holder, Compatible with iPhone Android Phone, Camera"
}, {
"station": "US",
"asin": "B07F8S18D5",
"asinImage": "https://m.media-amazon.com/images/I/31OR4pkm28L._AC_US200_.jpg",
"bigAsinImage": null,
"asinPrice": 9.99,
"asinReviews": 54406,
"asinRating": 4.7,
"asinBrand": null,
"asinTitle": "Nulaxy Dual Folding Cell Phone Stand, Fully Adjustable Foldable Desktop Phone Holder Cradle Dock Compatible with Phone 16 15 14 13 12 11 Pro Xs Xs Max Xr X 8, Nintendo Switch, All Phones"
}, {
"station": "US",
"asin": "B0D6VZS7HR",
"asinImage": "https://m.media-amazon.com/images/I/41D69Sn1D4L._AC_US200_.jpg",
"bigAsinImage": null,
"asinPrice": 24.99,
"asinReviews": 57,
"asinRating": 4.6,
"asinBrand": null,
"asinTitle": "Magnetic Phone Pillow Stand, Adjustable Phone Holder for Bed,Lap,Desk, Cozy Phone Pillow Holder with Bowl and Suction Cup Bottom, Compatible with 3.5-7" Phones/E-Readers/Kindles, Pink"
}, {
"station": "US",
"asin": "B0D86NHRSL",
"asinImage": "https://m.media-amazon.com/images/I/41xpi-zqAIL._AC_US200_.jpg",
"bigAsinImage": null,
"asinPrice": 29.99,
"asinReviews": 67,
"asinRating": 4.4,
"asinBrand": null,
"asinTitle": "Gifts for Men Women,Adjustable Cell Phone Stand with Bluetooth Speaker and Charging Function,Cool Tech Gadgets Gift Idea for Dad Mom Birthday"
}, {
"station": "US",
"asin": "B0DG4YK96S",
"asinImage": "https://m.media-amazon.com/images/I/31HVetcs6NL._AC_US200_.jpg",
"bigAsinImage": null,
"asinPrice": 6.0,
"asinReviews": 234,
"asinRating": 5.0,
"asinBrand": null,
"asinTitle": "Cell Phone Stand,Aluminum Desktop Phone Holder Cradle Dock Compatible with Nintendo Switch,iPhone 15 14 13 12 11 Pro, All 4-8" Phones, Silver"
}, {
"station": "US",
"asin": "B0DJ2C46M3",
"asinImage": "https://m.media-amazon.com/images/I/41UYCNHUS0L._AC_SR200,200_.jpg",
"bigAsinImage": null,
"asinPrice": 14.99,
"asinReviews": 83,
"asinRating": 4.2,
"asinBrand": null,
"asinTitle": "Klearlook Magnetic Suction Cup Phone Ring Grip for MagSafe, Adjustable Phone Stand for iPhone 16/15/14/13/12 Series, Hands-Free Selfie/Video for TikTok Influencers, Women Girl Teen Gift, Light Pink"
}, {
"station": "US",
"asin": "B0744DM3Y3",
"asinImage": "https://m.media-amazon.com/images/I/41b6TfhOl7L._AC_SR200,200_.jpg",
"bigAsinImage": null,
"asinPrice": 9.99,
"asinReviews": 64201,
"asinRating": 4.8,
"asinBrand": null,
"asinTitle": "Adjustable Cell Phone Stand, OMOTON Aluminum Desktop Cellphone Stand with Anti-Slip Base and Convenient Charging Port, Fits All Smart Phones, Silver"
}, {
"station": "US",
"asin": "B09HKN6M19",
"asinImage": "https://m.media-amazon.com/images/I/41wG4t579PL._AC_US200_.jpg",
"bigAsinImage": null,
"asinPrice": 6.99,
"asinReviews": 4005,
"asinRating": 4.7,
"asinBrand": null,
"asinTitle": "JSAUX Cell Phone Stand, Foldable Aluminum Adjustable Phone Holder for Desk Portable Travel Essentials Office Accessories Compatible with iPhone 16 15 14 13 Pro Max Samsung S24 S23 Ultra Kindle-Gray"
}, {
"station": "US",
"asin": "B09MCKK9NX",
"asinImage": "https://m.media-amazon.com/images/I/41gleueVKkL._AC_US200_.jpg",
"bigAsinImage": null,
"asinPrice": 9.99,
"asinReviews": 27755,
"asinRating": 4.8,
"asinBrand": null,
"asinTitle": "Lamicall Foldable Phone Stand for Desk - Height Adjustable Cell Phone Holder Portable Cellphone Cradle Desktop Dock Compatible with iPhone 16 15 14 13 Pro Max Mini, 12 11 XR X 8 Plus SE, Smartphone"
}
],
"products": 21596,
"adProducts": 127,
"supplyDemandRatio": 13.76,
"avgPrice": 9.99,
"avgReviews": 54406,
"avgRating": 4.5,
"bidMin": 1.1,
"bidMax": 1.83,
"bid": 1.46,
"cvsShareRate": 0.2089,
"wordCount": 2,
"titleDensity": 50,
"spr": 279,
"relevancy": 100.0,
"absoluteRelevancy": 82,
"amazonChoice": true,
"searchRank": 1725,
"searchWeeklyRank": 1673,
"clicks": 139360,
"impressions": 7801381
}