TASK#26655 Shopee广告费数据采集 / 平台财务数据自动化获取（接口/小工具）

任务描述

暂无

需求描述

一、数据说明：店铺的广告数据

二、采集时间：每月2日下载上月的

三、采集字段：（采集字段+登录账号+添加时间+站点）

__LoginUserName
__CrawlDate
__SiteHost
排序
广告名称
状态
商品编号
广告类型
关键字/展示位置
开始日期
结束日期
浏览数
点击数
点击率
转化
直接转化
转化率
直接转化率
每一转化的成本
每一直接转化的成本
商品已出售
直接已售商品
销售金额
直接销售金额
花费
投资产出比
直接投资产出比
成本收入对比
直接成本收入对比
商品浏览数
商品点击数
商品点击率

三、采集路径

1、营销中心>Shopee广告，选择上月，点击导出，下载第一个表格
2、切换国家站点继续采集（一个国家下面可能包含多个店铺，店铺名称带有“SIP附属店铺”的无须采集）

验收标准

暂无

历史记录

2022-05-12 09:44:06, 由 舒鹏明 创建。
2022-05-12 09:47:31, 由 舒鹏明 编辑。
修改了 最初预计，旧值为 "0"，新值为 "10"。
修改了 预计剩余，旧值为 "0"，新值为 "10"。
2022-05-13 13:51:40, 由 zhubin 添加备注。

平台此模块有错误信息，不支持：
2022-05-13 17:44:09, 由 zhubin 添加备注。

抓包地址：https://seller.shopee.cn/api/marketing/v3/pas/homepage/?SPC_CDS=35cf7d1e-d058-46fd-8c1d-205231fe6481&SPC_CDS_VER=2&campaign_state=all&sort_key=mtime&sort_direction=1&search_content=&start_time=1651334400&end_time=1652371199&offset=0&limit=20&cnsc_shop_id=80886732
2022-05-13 17:46:02, 由 zhubin 添加备注。

广告接口返回的Json:

{
"message": "success",
"code": 0,
"data": {
"total_count": 73,
"campaign_ads_list": [{
"report": {
"impression": {
"ratio": 0,
"value": 0
},
"direct_roi": {
"ratio": 0,
"value": 0
},
"broad_order": {
"ratio": 0,
"value": 0
},
"shop_item_impression": {
"ratio": 0,
"value": 0
},
"direct_gmv": {
"ratio": 0,
"value": 0
},
"cost": {
"ratio": 0,
"value": 0
},
"shop_ctr": {
"ratio": 0,
"value": 0
},
"cr": {
"ratio": 0,
"value": 0
},
"click": {
"ratio": 0,
"value": 0
},
"direct_cir": {
"ratio": 0,
"value": 0
},
"direct_order_amount": {
"ratio": 0,
"value": 0
},
"broad_cir": {
"ratio": 0,
"value": 0
},
"gmv_expense_ratio": {
"ratio": 0,
"value": 0
},
"cpdc": {
"ratio": 0,
"value": 0
},
"cpc": {
"ratio": 0,
"value": 0
},
"ctr": {
"ratio": 0,
"value": 0
},
"broad_gmv": {
"ratio": 0,
"value": 0
},
"order_amount": {
"ratio": 0,
"value": 0
},
"direct_cr": {
"ratio": 0,
"value": 0
},
"cir": {
"ratio": 0,
"value": 0
},
"broad_roi": {
"ratio": 0,
"value": 0
},
"broad_order_amount": {
"ratio": 0,
"value": 0
},
"direct_order": {
"ratio": 0,
"value": 0
},
"shop_item_click": {
"ratio": 0,
"value": 0
},
"order": {
"ratio": 0,
"value": 0
},
"order_gmv": {
"ratio": 0,
"value": 0
}
},
"product": {
"itemid": 1545346649,
"state": "normal",
"name": "Mediterranean Style Hanging Ornaments Anchor Wall Hooks Nautical Decor",
"is_unlisted": false,
"images": "f2b7e3c30fb74b84081c13e87afe0b2c,3cdf9b2057b120c48a0fa702eb262580,7d1f2a02f5d4aac0cb739206604a4854,763f43cfbd015ca13f5afdae0d96670a,9150e4da8f9cdebd5ddd18bb1ca05c46,4e25033536f70c0acbddb0cf8b5eedde,d42d70509832d92f58ceb5ac3b69ace6,e095e69093865aa4206c6109ccd0b97e,f856044be2941e261b00545392753966",
"stock": 944
},
"advertisements": [{
"itemid": 1545346649,
"status": 1,
"placement": 4,
"ctime": 1591772057,
"campaignid": 2128041,
"adsid": 3437591,
"mtime": 1652429471,
"extinfo": {
"keywords": [],
"shop_customisation": {},
"pricing_type": 4,
"target_roi": 0,
"target": {}
}
}],
"campaign": {
"status": 1,
"name": "",
"campaignid": 2128041,
"total_quota": "0.00",
"start_time": 1652371200,
"daily_expense": "0.18",
"daily_quota": "2.00",
"state": "ongoing",
"end_time": 0,
"mtime": 1652429471,
"total_expense": "0.18",
"type": "keyword"
}
}, {
"report": {
"impression": {
"ratio": 0,
"value": 0
},
"direct_roi": {
"ratio": 0,
"value": 0
},
"broad_order": {
"ratio": 0,
"value": 0
},
"shop_item_impression": {
"ratio": 0,
"value": 0
},
"direct_gmv": {
"ratio": 0,
"value": 0
},
"cost": {
"ratio": 0,
"value": 0
},
"shop_ctr": {
"ratio": 0,
"value": 0
},
"cr": {
"ratio": 0,
"value": 0
},
"click": {
"ratio": 0,
"value": 0
},
"direct_cir": {
"ratio": 0,
"value": 0
},
"direct_order_amount": {
"ratio": 0,
"value": 0
},
"broad_cir": {
"ratio": 0,
"value": 0
},
"gmv_expense_ratio": {
"ratio": 0,
"value": 0
},
"cpdc": {
"ratio": 0,
"value": 0
},
"cpc": {
"ratio": 0,
"value": 0
},
"ctr": {
"ratio": 0,
"value": 0
},
"broad_gmv": {
"ratio": 0,
"value": 0
},
"order_amount": {
"ratio": 0,
"value": 0
},
"direct_cr": {
"ratio": 0,
"value": 0
},
"cir": {
"ratio": 0,
"value": 0
},
"broad_roi": {
"ratio": 0,
"value": 0
},
"broad_order_amount": {
"ratio": 0,
"value": 0
},
"direct_order": {
"ratio": 0,
"value": 0
},
"shop_item_click": {
"ratio": 0,
"value": 0
},
"order": {
"ratio": 0,
"value": 0
},
"order_gmv": {
"ratio": 0,
"value": 0
}
},
"product": {
"itemid": 1372082390,
"state": "normal",
"name": "Anchor Clock Beach Sea Theme Nautical Starfish Decor Wall Mounting Room Decor",
"is_unlisted": false,
"images": "5f45c91be4ea2736a1e2662bd7f6887f,6492233147ba81cedb4ee504d493108a,ef6b6b79b55436a4792de8a603849f58,3ec5d742bd77e4579ccc93ee8128af46,bd0b680e34807c69f9c36c38c1683b62",
"stock": 939
},
"advertisements": [{
"itemid": 1372082390,
"status": 1,
"placement": 4,
"ctime": 1591772057,
"campaignid": 2128044,
"adsid": 3437594,
"mtime": 1652429471,
"extinfo": {
"keywords": [],
"shop_customisation": {},
"pricing_type": 4,
"target_roi": 0,
"target": {}
}
}],
"campaign": {
"status": 1,
"name": "",
"campaignid": 2128044,
"total_quota": "0.00",
"start_time": 1652371200,
"daily_expense": "0.05",
"daily_quota": "2.00",
"state": "ongoing",
"end_time": 0,
"mtime": 1652429471,
"total_expense": "0.05",
"type": "keyword"
}
}, {
"report": {
"impression": {
"ratio": 0,
"value": 0
},
"direct_roi": {
"ratio": 0,
"value": 0
},
"broad_order": {
"ratio": 0,
"value": 0
},
"shop_item_impression": {
"ratio": 0,
"value": 0
},
"direct_gmv": {
"ratio": 0,
"value": 0
},
"cost": {
"ratio": 0,
"value": 0
},
"shop_ctr": {
"ratio": 0,
"value": 0
},
"cr": {
"ratio": 0,
"value": 0
},
"click": {
"ratio": 0,
"value": 0
},
"direct_cir": {
"ratio": 0,
"value": 0
},
"direct_order_amount": {
"ratio": 0,
"value": 0
},
"broad_cir": {
"ratio": 0,
"value": 0
},
"gmv_expense_ratio": {
"ratio": 0,
"value": 0
},
"cpdc": {
"ratio": 0,
"value": 0
},
"cpc": {
"ratio": 0,
"value": 0
},
"ctr": {
"ratio": 0,
"value": 0
},
"broad_gmv": {
"ratio": 0,
"value": 0
},
"order_amount": {
"ratio": 0,
"value": 0
},
"direct_cr": {
"ratio": 0,
"value": 0
},
"cir": {
"ratio": 0,
"value": 0
},
"broad_roi": {
"ratio": 0,
"value": 0
},
"broad_order_amount": {
"ratio": 0,
"value": 0
},
"direct_order": {
"ratio": 0,
"value": 0
},
"shop_item_click": {
"ratio": 0,
"value": 0
},
"order": {
"ratio": 0,
"value": 0
},
"order_gmv": {
"ratio": 0,
"value": 0
}
},
"product": {
"itemid": 1545346690,
"state": "normal",
"name": "Nautical Mediterranean Style Welcome on Board Life Ring Swim Tube Wall Decor",
"is_unlisted": false,
"images": "ef80c3c9855fd4cc1eb3e17abdf22a2f,8e82a1441e2bfa4cd74fda56b51feb16,18c9b1fa401fef6e487f1ae319afee35,3a37565fa76417e3de77a0c9da86e61b,0ed0755e0ce966ba5e8e2feb9cd97387,b55f02647a357587d02850d3bbb82673,c1d531ce6c2066225d6f7f0da2246941",
"stock": 958
},
"advertisements": [{
"itemid": 1545346690,
"status": 1,
"placement": 4,
"ctime": 1591772058,
"campaignid": 2128050,
"adsid": 3437600,
"mtime": 1652429471,
"extinfo": {
"keywords": [],
"shop_customisation": {},
"pricing_type": 4,
"target_roi": 0,
"target": {}
}
}, {
"itemid": 1545346690,
"status": 1,
"placement": 0,
"ctime": 1597131090,
"campaignid": 2128050,
"adsid": 5473763,
"mtime": 1652429471,
"extinfo": {
"keywords": [{
"status": 0,
"price": "0.11",
"match_type": 1,
"keyword": "home decor",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.11",
"match_type": 1,
"keyword": "wall decoration",
"algorithm": "kwrcmdv2"
}],
"shop_customisation": {},
"pricing_type": 1,
"target": {}
}
}],
"campaign": {
"status": 1,
"name": "",
"campaignid": 2128050,
"total_quota": "0.00",
"start_time": 1652371200,
"daily_expense": "0.00",
"daily_quota": "2.00",
"state": "ongoing",
"end_time": 0,
"mtime": 1652429471,
"total_expense": "0.00",
"type": "keyword"
}
}, {
"report": {
"impression": {
"ratio": 0,
"value": 0
},
"direct_roi": {
"ratio": 0,
"value": 0
},
"broad_order": {
"ratio": 0,
"value": 0
},
"shop_item_impression": {
"ratio": 0,
"value": 0
},
"direct_gmv": {
"ratio": 0,
"value": 0
},
"cost": {
"ratio": 0,
"value": 0
},
"shop_ctr": {
"ratio": 0,
"value": 0
},
"cr": {
"ratio": 0,
"value": 0
},
"click": {
"ratio": 0,
"value": 0
},
"direct_cir": {
"ratio": 0,
"value": 0
},
"direct_order_amount": {
"ratio": 0,
"value": 0
},
"broad_cir": {
"ratio": 0,
"value": 0
},
"gmv_expense_ratio": {
"ratio": 0,
"value": 0
},
"cpdc": {
"ratio": 0,
"value": 0
},
"cpc": {
"ratio": 0,
"value": 0
},
"ctr": {
"ratio": 0,
"value": 0
},
"broad_gmv": {
"ratio": 0,
"value": 0
},
"order_amount": {
"ratio": 0,
"value": 0
},
"direct_cr": {
"ratio": 0,
"value": 0
},
"cir": {
"ratio": 0,
"value": 0
},
"broad_roi": {
"ratio": 0,
"value": 0
},
"broad_order_amount": {
"ratio": 0,
"value": 0
},
"direct_order": {
"ratio": 0,
"value": 0
},
"shop_item_click": {
"ratio": 0,
"value": 0
},
"order": {
"ratio": 0,
"value": 0
},
"order_gmv": {
"ratio": 0,
"value": 0
}
},
"product": {
"itemid": 1545346657,
"state": "normal",
"name": "500g Mixed Natural Beach Seashells Crafts Set",
"is_unlisted": false,
"images": "4e252d3bb3e678b3d8d4d71671750a1b,d2108a882e79b87a295aa7cd76d3c544,ef6350e1c16e45bf605d1130522833c2",
"stock": 989
},
"advertisements": [{
"itemid": 1545346657,
"status": 1,
"placement": 4,
"ctime": 1652429471,
"campaignid": 28778319,
"adsid": 47255980,
"mtime": 1652429471,
"extinfo": {
"keywords": [],
"shop_customisation": {},
"pricing_type": 4,
"target_roi": 0,
"target": {}
}
}],
"campaign": {
"status": 1,
"name": "",
"campaignid": 28778319,
"total_quota": "0.00",
"start_time": 1652371200,
"daily_expense": "0.00",
"daily_quota": "2.00",
"state": "ongoing",
"end_time": 0,
"mtime": 1652429471,
"total_expense": "0.00",
"type": "keyword"
}
}, {
"report": {
"impression": {
"ratio": "0",
"value": "737"
},
"direct_roi": {
"ratio": "0",
"value": "0.0"
},
"broad_order": {
"ratio": "0",
"value": "0"
},
"shop_item_impression": {
"ratio": "0",
"value": "0"
},
"direct_gmv": {
"ratio": "0",
"value": "0.00"
},
"cost": {
"ratio": "0",
"value": "1.97"
},
"shop_ctr": {
"ratio": "0",
"value": "0"
},
"cr": {
"ratio": "0",
"value": "0.0"
},
"click": {
"ratio": "0",
"value": "17"
},
"direct_cir": {
"ratio": "0",
"value": "0"
},
"direct_order_amount": {
"ratio": "0",
"value": "0"
},
"broad_cir": {
"ratio": "0",
"value": "0"
},
"gmv_expense_ratio": {
"ratio": "0",
"value": "0.0"
},
"cpdc": {
"ratio": "0",
"value": "0.00"
},
"cpc": {
"ratio": "0",
"value": "0.00"
},
"ctr": {
"ratio": "0",
"value": "0.0230664857531"
},
"broad_gmv": {
"ratio": "0",
"value": "0.00"
},
"order_amount": {
"ratio": "0",
"value": "0"
},
"direct_cr": {
"ratio": "0",
"value": "0.0"
},
"cir": {
"ratio": "0",
"value": "0"
},
"broad_roi": {
"ratio": "0",
"value": "0.0"
},
"broad_order_amount": {
"ratio": "0",
"value": "0"
},
"direct_order": {
"ratio": "0",
"value": "0"
},
"shop_item_click": {
"ratio": "0",
"value": "0"
},
"order": {
"ratio": "0",
"value": "0"
},
"order_gmv": {
"ratio": "0",
"value": "0.00"
}
},
"product": {
"itemid": 2128793483,
"state": "normal",
"name": "2pcs 18-22mm Adjustable Curtain Holder Curtain Drapery Rod Bracket (Black)",
"is_unlisted": false,
"images": "5062a93857cc5375e237f66c258ee540,570f017d27214b1a488a0b591e38b2ee,70edc164a4ea9f1f3115e6c3821b10b0,b051d8ac81dc820ca5cd41fcbf5f7c17,3f801340ddfde866f90fb11342afd8a4,3d621ef01579cfae426088eb16e95fff,a27490107f1a86d3669eb392d0662286,288a6c85b681ea103d125f4b654846ec",
"stock": 515
},
"advertisements": [{
"itemid": 2128793483,
"status": 1,
"placement": 4,
"ctime": 1591689071,
"campaignid": 2096460,
"adsid": 3373150,
"mtime": 1651541117,
"extinfo": {
"keywords": [],
"shop_customisation": {},
"pricing_type": 4,
"target_roi": 0,
"target": {}
}
}, {
"itemid": 2128793483,
"status": 1,
"placement": 0,
"ctime": 1598600548,
"campaignid": 2096460,
"adsid": 6214202,
"mtime": 1651541117,
"extinfo": {
"keywords": [{
"status": 0,
"price": "0.23",
"match_type": 1,
"keyword": "adjustable curtain rod",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.11",
"match_type": 1,
"keyword": "blind curtain",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.13",
"match_type": 1,
"keyword": "curtain",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.18",
"match_type": 1,
"keyword": "curtain hook",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.36",
"match_type": 1,
"keyword": "curtain rod",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.14",
"match_type": 1,
"keyword": "rod holder",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.17",
"match_type": 1,
"keyword": "rod langsir",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.29",
"match_type": 1,
"keyword": "window curtain",
"algorithm": "kwrcmdv2"
}],
"shop_customisation": {},
"pricing_type": 1,
"target": {}
}
}],
"campaign": {
"status": 1,
"name": "",
"campaignid": 2096460,
"total_quota": "0.00",
"start_time": 1651507200,
"daily_expense": "0.07",
"daily_quota": "2.00",
"state": "ongoing",
"end_time": 0,
"mtime": 1651541117,
"total_expense": "2.04",
"type": "keyword"
}
}, {
"report": {
"impression": {
"ratio": "0",
"value": "545"
},
"direct_roi": {
"ratio": "0",
"value": "0.0"
},
"broad_order": {
"ratio": "0",
"value": "0"
},
"shop_item_impression": {
"ratio": "0",
"value": "0"
},
"direct_gmv": {
"ratio": "0",
"value": "0.00"
},
"cost": {
"ratio": "0",
"value": "1.22"
},
"shop_ctr": {
"ratio": "0",
"value": "0"
},
"cr": {
"ratio": "0",
"value": "0.0"
},
"click": {
"ratio": "0",
"value": "13"
},
"direct_cir": {
"ratio": "0",
"value": "0"
},
"direct_order_amount": {
"ratio": "0",
"value": "0"
},
"broad_cir": {
"ratio": "0",
"value": "0"
},
"gmv_expense_ratio": {
"ratio": "0",
"value": "0.0"
},
"cpdc": {
"ratio": "0",
"value": "0.00"
},
"cpc": {
"ratio": "0",
"value": "0.00"
},
"ctr": {
"ratio": "0",
"value": "0.0238532110092"
},
"broad_gmv": {
"ratio": "0",
"value": "0.00"
},
"order_amount": {
"ratio": "0",
"value": "0"
},
"direct_cr": {
"ratio": "0",
"value": "0.0"
},
"cir": {
"ratio": "0",
"value": "0"
},
"broad_roi": {
"ratio": "0",
"value": "0.0"
},
"broad_order_amount": {
"ratio": "0",
"value": "0"
},
"direct_order": {
"ratio": "0",
"value": "0"
},
"shop_item_click": {
"ratio": "0",
"value": "0"
},
"order": {
"ratio": "0",
"value": "0"
},
"order_gmv": {
"ratio": "0",
"value": "0.00"
}
},
"product": {
"itemid": 2141126547,
"state": "normal",
"name": "2pcs 18-22mm Adjustable Curtain Holder Curtain Drapery Rod Bracket",
"is_unlisted": false,
"images": "c981dcc7765b24f55b3f5de1e769c859,6466aeb0382a11e3bb11b2a143bc86fb,cbc226af7169965e4d29438dcf1d2df0,ee79bda34160202df7b80e7521039de4,33b7b105c61e9d1f785dbf5facf36b21,89f9fed73a7dd3a8aefce8dbc25d6bad,8f48a3daa4a704d64a5a01085d8fd4d5,d6b8960af95dcf6bbba7b7e17fb0a46e,087e2d706b582be19bdab40536679ab9",
"stock": 934
},
"advertisements": [{
"itemid": 2141126547,
"status": 1,
"placement": 4,
"ctime": 1600235018,
"campaignid": 3993994,
"adsid": 7178336,
"mtime": 1651541117,
"extinfo": {
"keywords": [],
"shop_customisation": {},
"pricing_type": 4,
"target_roi": 0,
"target": {}
}
}],
"campaign": {
"status": 1,
"name": "",
"campaignid": 3993994,
"total_quota": "0.00",
"start_time": 1651507200,
"daily_expense": "0.00",
"daily_quota": "2.00",
"state": "ongoing",
"end_time": 0,
"mtime": 1651541117,
"total_expense": "1.22",
"type": "keyword"
}
}, {
"report": {
"impression": {
"ratio": "5.33843797856",
"value": "4139"
},
"direct_roi": {
"ratio": "0",
"value": "0.0"
},
"broad_order": {
"ratio": "0",
"value": "0"
},
"shop_item_impression": {
"ratio": "0",
"value": "0"
},
"direct_gmv": {
"ratio": "0",
"value": "0.00"
},
"cost": {
"ratio": "5.08486445359",
"value": "21.59"
},
"shop_ctr": {
"ratio": "0",
"value": "0"
},
"cr": {
"ratio": "0",
"value": "0.0"
},
"click": {
"ratio": "4.07692307692",
"value": "66"
},
"direct_cir": {
"ratio": "0",
"value": "0"
},
"direct_order_amount": {
"ratio": "0",
"value": "0"
},
"broad_cir": {
"ratio": "0",
"value": "0"
},
"gmv_expense_ratio": {
"ratio": "0",
"value": "0.0"
},
"cpdc": {
"ratio": "0",
"value": "0.00"
},
"cpc": {
"ratio": "0",
"value": "0.00"
},
"ctr": {
"ratio": "-0.199026149014",
"value": "0.0159458806475"
},
"broad_gmv": {
"ratio": "0",
"value": "0.00"
},
"order_amount": {
"ratio": "0",
"value": "0"
},
"direct_cr": {
"ratio": "0",
"value": "0.0"
},
"cir": {
"ratio": "0",
"value": "0"
},
"broad_roi": {
"ratio": "0",
"value": "0.0"
},
"broad_order_amount": {
"ratio": "0",
"value": "0"
},
"direct_order": {
"ratio": "0",
"value": "0"
},
"shop_item_click": {
"ratio": "0",
"value": "0"
},
"order": {
"ratio": "0",
"value": "0"
},
"order_gmv": {
"ratio": "0",
"value": "0.00"
}
},
"product": {
"itemid": 7158959976,
"state": "normal",
"name": "12pcs Red Wine Bag Elegant Kraft Paper Red Wine Handbag Gift Bag for Christmas",
"is_unlisted": false,
"images": "bbf9cf8fa6ec10190b42767f3afabf1c,0ee3cb41ae9dff24544a2633136f62ac,bb71b3c8458a69ea51bdf485baa5efb0,b03faf64c182c19510d95226ed5f0981,56209f972a20519dcd3c59483afcf92b,3d0800db9e79117f0cf9630f659306d3,f3227fc121e08db4d99c7d89d046af5c,48576279c4492dac43eb181c602dcc40,5fd762466a6669b969cb80ad0abedf98",
"stock": 684
},
"advertisements": [{
"itemid": 7158959976,
"status": 1,
"placement": 4,
"ctime": 1651213264,
"campaignid": 28270573,
"adsid": 46404364,
"mtime": 1651213264,
"extinfo": {
"keywords": [],
"shop_customisation": {},
"pricing_type": 4,
"target_roi": 0,
"target": {}
}
}],
"campaign": {
"status": 1,
"name": "",
"campaignid": 28270573,
"total_quota": "0.00",
"start_time": 1651161600,
"daily_expense": "2.00",
"daily_quota": "2.00",
"state": "ongoing",
"end_time": 0,
"mtime": 1651213264,
"total_expense": "27.14",
"type": "keyword"
}
}, {
"report": {
"impression": {
"ratio": "14.6875",
"value": "502"
},
"direct_roi": {
"ratio": "0",
"value": "0.0"
},
"broad_order": {
"ratio": "0",
"value": "0"
},
"shop_item_impression": {
"ratio": "0",
"value": "0"
},
"direct_gmv": {
"ratio": "0",
"value": "0.00"
},
"cost": {
"ratio": "21.3423333333",
"value": "1.34"
},
"shop_ctr": {
"ratio": "0",
"value": "0"
},
"cr": {
"ratio": "0",
"value": "0.0"
},
"click": {
"ratio": "17.0",
"value": "18"
},
"direct_cir": {
"ratio": "0",
"value": "0"
},
"direct_order_amount": {
"ratio": "0",
"value": "0"
},
"broad_cir": {
"ratio": "0",
"value": "0"
},
"gmv_expense_ratio": {
"ratio": "0",
"value": "0.0"
},
"cpdc": {
"ratio": "0",
"value": "0.00"
},
"cpc": {
"ratio": "0",
"value": "0.00"
},
"ctr": {
"ratio": "0.147410358566",
"value": "0.0358565737052"
},
"broad_gmv": {
"ratio": "0",
"value": "0.00"
},
"order_amount": {
"ratio": "0",
"value": "0"
},
"direct_cr": {
"ratio": "0",
"value": "0.0"
},
"cir": {
"ratio": "0",
"value": "0"
},
"broad_roi": {
"ratio": "0",
"value": "0.0"
},
"broad_order_amount": {
"ratio": "0",
"value": "0"
},
"direct_order": {
"ratio": "0",
"value": "0"
},
"shop_item_click": {
"ratio": "0",
"value": "0"
},
"order": {
"ratio": "0",
"value": "0"
},
"order_gmv": {
"ratio": "0",
"value": "0.00"
}
},
"product": {
"itemid": 7752377254,
"state": "normal",
"name": "10/20pcs Transparent Plastic Mousse Cup Square Container for Jelly Yogurt Dessert (with Cover)",
"is_unlisted": false,
"images": "4878c220e01615b9ba866a960995548a,a1981dcefe46cbd03d8d96e073b398c0,5b7a7b43f4faa3462e57d724cab7356b,cefbe223f0d6380b55c17e339195dced,b283db7aeede42629928baed8cb9ba7a,0c206bc57cd76bd1c9c294ca4b2d3455,9d926972cc0627bfa51cfc18f13fe965,ca43f21ec159bc2cc069fde6cb39e558,d7befbe4d0e90cca3d440bf4d73bae8e",
"stock": 183
},
"advertisements": [{
"itemid": 7752377254,
"status": 1,
"placement": 4,
"ctime": 1651213264,
"campaignid": 28270574,
"adsid": 46404365,
"mtime": 1651213264,
"extinfo": {
"keywords": [],
"shop_customisation": {},
"pricing_type": 4,
"target_roi": 0,
"target": {}
}
}],
"campaign": {
"status": 1,
"name": "",
"campaignid": 28270574,
"total_quota": "0.00",
"start_time": 1651161600,
"daily_expense": "0.62",
"daily_quota": "2.00",
"state": "ongoing",
"end_time": 0,
"mtime": 1651213264,
"total_expense": "2.02",
"type": "keyword"
}
}, {
"report": {
"impression": {
"ratio": "15.6470588235",
"value": "283"
},
"direct_roi": {
"ratio": "0",
"value": "0.0"
},
"broad_order": {
"ratio": "0",
"value": "0"
},
"shop_item_impression": {
"ratio": "0",
"value": "0"
},
"direct_gmv": {
"ratio": "0",
"value": "0.00"
},
"cost": {
"ratio": "13.0134292566",
"value": "0.29"
},
"shop_ctr": {
"ratio": "0",
"value": "0"
},
"cr": {
"ratio": "0",
"value": "0.0"
},
"click": {
"ratio": "1.0",
"value": "2"
},
"direct_cir": {
"ratio": "0",
"value": "0"
},
"direct_order_amount": {
"ratio": "0",
"value": "0"
},
"broad_cir": {
"ratio": "0",
"value": "0"
},
"gmv_expense_ratio": {
"ratio": "0",
"value": "0.0"
},
"cpdc": {
"ratio": "0",
"value": "0.00"
},
"cpc": {
"ratio": "0",
"value": "0.00"
},
"ctr": {
"ratio": "-0.879858657244",
"value": "0.00706713780919"
},
"broad_gmv": {
"ratio": "0",
"value": "0.00"
},
"order_amount": {
"ratio": "0",
"value": "0"
},
"direct_cr": {
"ratio": "0",
"value": "0.0"
},
"cir": {
"ratio": "0",
"value": "0"
},
"broad_roi": {
"ratio": "0",
"value": "0.0"
},
"broad_order_amount": {
"ratio": "0",
"value": "0"
},
"direct_order": {
"ratio": "0",
"value": "0"
},
"shop_item_click": {
"ratio": "0",
"value": "0"
},
"order": {
"ratio": "0",
"value": "0"
},
"order_gmv": {
"ratio": "0",
"value": "0.00"
}
},
"product": {
"itemid": 1545346650,
"state": "normal",
"name": "Fishing Net Shell Nautical Beach Wooden Boat Ship Steering Wheel Home Decor",
"is_unlisted": false,
"images": "00affaa7fdca98876fbc0c4106678506,ff16386e882d47cdb420fee62e35b949,0283f44a939afecb32b3dfb1e162f7fe,aa70d46320ebbecc23ceb827912c4139,d198bb5e799ea0b2114a83547ad8bc61,9ca0a53932c6c0683d9526022816a20d,d6ead08ac5df00d3fce6937270932d95,b3b46ae1f1f34727f99420536f3d9250,1d934274fb2b12cec59a2ac3b63aa5bc",
"stock": 974
},
"advertisements": [{
"itemid": 1545346650,
"status": 1,
"placement": 4,
"ctime": 1651213264,
"campaignid": 28270575,
"adsid": 46404366,
"mtime": 1651213264,
"extinfo": {
"keywords": [],
"shop_customisation": {},
"pricing_type": 4,
"target_roi": 0,
"target": {}
}
}],
"campaign": {
"status": 1,
"name": "",
"campaignid": 28270575,
"total_quota": "0.00",
"start_time": 1651161600,
"daily_expense": "0.00",
"daily_quota": "2.00",
"state": "ongoing",
"end_time": 0,
"mtime": 1651213264,
"total_expense": "0.31",
"type": "keyword"
}
}, {
"report": {
"impression": {
"ratio": "112.103448276",
"value": "3280"
},
"direct_roi": {
"ratio": "0",
"value": "2.59725913459"
},
"broad_order": {
"ratio": "0",
"value": "1"
},
"shop_item_impression": {
"ratio": "0",
"value": "0"
},
"direct_gmv": {
"ratio": "0",
"value": "39.97"
},
"cost": {
"ratio": "38.6253572624",
"value": "15.39"
},
"shop_ctr": {
"ratio": "0",
"value": "0"
},
"cr": {
"ratio": "0",
"value": "0.0120481927711"
},
"click": {
"ratio": "19.75",
"value": "83"
},
"direct_cir": {
"ratio": "0",
"value": "0.385021265949"
},
"direct_order_amount": {
"ratio": "0",
"value": "1"
},
"broad_cir": {
"ratio": "0",
"value": "0.385021265949"
},
"gmv_expense_ratio": {
"ratio": "0",
"value": "2.59725913459"
},
"cpdc": {
"ratio": "0",
"value": "15.39"
},
"cpc": {
"ratio": "0",
"value": "15.39"
},
"ctr": {
"ratio": "-0.816539634146",
"value": "0.0253048780488"
},
"broad_gmv": {
"ratio": "0",
"value": "39.97"
},
"order_amount": {
"ratio": "0",
"value": "1"
},
"direct_cr": {
"ratio": "0",
"value": "0.0120481927711"
},
"cir": {
"ratio": "0",
"value": "0.385021265949"
},
"broad_roi": {
"ratio": "0",
"value": "2.59725913459"
},
"broad_order_amount": {
"ratio": "0",
"value": "1"
},
"direct_order": {
"ratio": "0",
"value": "1"
},
"shop_item_click": {
"ratio": "0",
"value": "0"
},
"order": {
"ratio": "0",
"value": "1"
},
"order_gmv": {
"ratio": "0",
"value": "39.97"
}
},
"product": {
"itemid": 12628846444,
"state": "normal",
"name": "JH- 1pc Glass Gas Washing Bottle Professional Gas Washing Bottle for Experiment Labs",
"is_unlisted": false,
"images": "49834de8d3a6a50cdfecc18cfc18cbdf,979d3e9e2005cf43e35337e0111a26e2,2cd0d2f518244bd1c29dcfe0230f717c,e4e62affa1c74f907ce8dccc37c187cb,03985725980c53c22981644b7c602440,70c19634b1d10cd0285876e7d5e3703b,7a5371d1777843ac003d9574e288b44d,0b2be953d94a9c9995984d3b7f1e0421,beb1058126ddc00f485650480efe8cb8",
"stock": 81
},
"advertisements": [{
"itemid": 12628846444,
"status": 1,
"placement": 4,
"ctime": 1651213264,
"campaignid": 28270576,
"adsid": 46404367,
"mtime": 1651213264,
"extinfo": {
"keywords": [],
"shop_customisation": {},
"pricing_type": 4,
"target_roi": 0,
"target": {}
}
}],
"campaign": {
"status": 1,
"name": "",
"campaignid": 28270576,
"total_quota": "0.00",
"start_time": 1651161600,
"daily_expense": "0.92",
"daily_quota": "2.00",
"state": "ongoing",
"end_time": 0,
"mtime": 1651213264,
"total_expense": "16.70",
"type": "keyword"
}
}, {
"report": {
"impression": {
"ratio": "15.8201058201",
"value": "3179"
},
"direct_roi": {
"ratio": "0",
"value": "10.9911830819"
},
"broad_order": {
"ratio": "0",
"value": "3"
},
"shop_item_impression": {
"ratio": "0",
"value": "0"
},
"direct_gmv": {
"ratio": "0",
"value": "156.81"
},
"cost": {
"ratio": "78.2605",
"value": "14.27"
},
"shop_ctr": {
"ratio": "0",
"value": "0"
},
"cr": {
"ratio": "0",
"value": "0.0545454545455"
},
"click": {
"ratio": "26.5",
"value": "55"
},
"direct_cir": {
"ratio": "0",
"value": "0.090982016453"
},
"direct_order_amount": {
"ratio": "0",
"value": "3"
},
"broad_cir": {
"ratio": "0",
"value": "0.090982016453"
},
"gmv_expense_ratio": {
"ratio": "0",
"value": "10.9911830819"
},
"cpdc": {
"ratio": "0",
"value": "4.76"
},
"cpc": {
"ratio": "0",
"value": "4.76"
},
"ctr": {
"ratio": "0.634948096886",
"value": "0.0173010380623"
},
"broad_gmv": {
"ratio": "0",
"value": "156.81"
},
"order_amount": {
"ratio": "0",
"value": "3"
},
"direct_cr": {
"ratio": "0",
"value": "0.0545454545455"
},
"cir": {
"ratio": "0",
"value": "0.090982016453"
},
"broad_roi": {
"ratio": "0",
"value": "10.9911830819"
},
"broad_order_amount": {
"ratio": "0",
"value": "3"
},
"direct_order": {
"ratio": "0",
"value": "3"
},
"shop_item_click": {
"ratio": "0",
"value": "0"
},
"order": {
"ratio": "0",
"value": "3"
},
"order_gmv": {
"ratio": "0",
"value": "156.81"
}
},
"product": {
"itemid": 1372082395,
"state": "normal",
"name": "Solar Power Pool Water Pump Mini Watering Pump with Pannel for Pond Garden Patio",
"is_unlisted": false,
"images": "90c622923f782feb7948aebb665c7783,86773618f8335e8cbad04b45a3512c23,7b94b055ea11e79713f3007c248c1451,0d834a4166ebed2d0e42b753fcad53b5,112fef0cd54fcaeff8d82a83e983758d,a327219979a36440963896193a5db8be,824fe5aee644806abbd43bd4be153bdc,4620913db08554b10471542f27ad5ca8,cf7ce8fdae3a634d7a26f3e3a79a2178",
"stock": 846
},
"advertisements": [{
"itemid": 1372082395,
"status": 1,
"placement": 4,
"ctime": 1591772057,
"campaignid": 2128042,
"adsid": 3437592,
"mtime": 1651128669,
"extinfo": {
"keywords": [],
"shop_customisation": {},
"pricing_type": 4,
"target_roi": 0,
"target": {}
}
}, {
"itemid": 1372082395,
"status": 1,
"placement": 0,
"ctime": 1596872529,
"campaignid": 2128042,
"adsid": 5366878,
"mtime": 1651128669,
"extinfo": {
"keywords": [{
"status": 0,
"price": "0.12",
"match_type": 1,
"keyword": "aquarium pump",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.10",
"match_type": 1,
"keyword": "aquarium water pump",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.36",
"match_type": 1,
"keyword": "hitachi water pump",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.17",
"match_type": 1,
"keyword": "mini water pump",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.08",
"match_type": 1,
"keyword": "solar pump",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.08",
"match_type": 1,
"keyword": "solar water pump",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.15",
"match_type": 1,
"keyword": "water pressure pump",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.08",
"match_type": 0,
"keyword": "water pump",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.14",
"match_type": 1,
"keyword": "water tank",
"algorithm": "kwrcmdv2"
}, {
"status": 0,
"price": "0.11",
"match_type": 1,
"keyword": "waterpump",
"algorithm": "kwrcmdv2"
}],
"shop_customisation": {},
"pricing_type": 1,
"target": {}
}
}],
"campaign": {
"status": 1,
"name": "",
"campaignid": 2128042,
"total_quota": "0.00",
"start_time": 1651075200,
"daily_expense": "1.60",
"daily_quota": "2.00",
"state": "ongoing",
"end_time": 0,
"mtime": 1651128669,
"total_expense": "16.05",
"type": "keyword"
}
}, {
"report": {
"impression": {
"ratio": "11.9375",
"value": "1242"
},
"direct_roi": {
"ratio": "0",
"value": "0.0"
},
"broad_order": {
"ratio": "0",
"value": "0"
},
"shop_item_impression": {
"ratio": "0",
"value": "0"
},
"direct_gmv": {
"ratio": "0",
"value": "0.00"
},
"cost": {
"ratio": "15.1034916521",
"value": "4.22"
},
"shop_ctr": {
"ratio": "0",
"value": "0"
},
"cr": {
"ratio": "0",
"value": "0.0"
},
"click": {
"ratio": "10.0",
"value": "22"
},
"direct_cir": {
"ratio": "0",
"value": "0"
},
"direct_order_amount": {
"ratio": "0",
"value": "0"
},
"broad_cir": {
"ratio": "0",
"value": "0"
},
"gmv_expense_ratio": {
"ratio": "0",
"value": "0.0"
},
"cpdc": {
"ratio": "0",
"value": "0.00"
},
"cpc": {
"ratio": "0",
"value": "0.00"
},
"ctr": {
"ratio": "-0.149758454106",
"value": "0.0177133655395"
},
"broad_gmv": {
"ratio": "0",
"value": "0.00"
},
"order_amount": {
"ratio": "0",
"value": "0"
},
"direct_cr": {
"ratio": "0",
"value": "0.0"
},
"cir": {
"ratio": "0",
"value": "0"
},
"broad_roi": {
"ratio": "0",
"value": "0.0"
},
"broad_order_amount": {
"ratio": "0",
"value": "0"
},
"direct_order": {
"ratio": "0",
"value": "0"
},
"shop_item_click": {
"ratio": "0",
"value": "0"
},
"order": {
"ratio": "0",
"value": "0"
},
"order_gmv": {
"ratio": "0",
"value": "0.00"
}
},
"product": {
"itemid": 7465394235,
"state": "normal",
"name": "to the Lord Wall Decal Bible Verse Quote Christian Decor Psalm 107:1 Wall Sticker",
"is_unlisted": false,
"images": "d8884e870210ca11baa4aac2695296d7,10df8663a55e06145186e73901d3b3bc,b5cad0ee67e7a07df30d85a9bf699e61,935691059eae31141c3d416e1fc975fb,5b1283615a913ce5276c759c43980122,1cc71e7cfdd122dd5662b5a8b82caa40,869171e02b2251516f7ef0598ddb2e7d,6d7857a3942833053553a1960cb63336,789968754999ce116a9cd6a41b6a956b",
"stock": 90
},
"advertisements": [{
"itemid": 7465394235,
"status": 1,
"placement": 4,
"ctime": 1651128645,
"campaignid": 28229929,
"adsid": 46335326,
"mtime": 1651128669,
"extinfo": {
"keywords": [],
"shop_customisation": {},
"pricing_type": 4,
"target_roi": 0,
"target": {}
}
}],
"campaign": {
"status": 1,
"name": "",
"campaignid": 28229929,
"total_quota": "0.00",
"start_time": 1651075200,
"daily_expense": "0.00",
"daily_quota": "2.00",
"state": "ongoing",
"end_time": 0,
"mtime
2022-05-13 17:58:16, 由 zhubin 添加备注。

本地调试我的广告接口：
2022-05-17 09:04:53, 由 zhubin 添加备注。

广告数据，存广告Json和SiteHost：
2022-05-17 17:21:25, 由 zhubin 完成。
修改了 总计消耗，旧值为 "0"，新值为 "10"。
修改了 指派给 ，旧值为 "zhubin"，新值为 "shupengming"。
修改了 实际完成，旧值为 ""，新值为 "2022-05-17 17:21:21"。
修改了 任务状态，旧值为 "wait"，新值为 "done"。
修改了 实际开始，旧值为 "0000-00-00 00:00:00"，新值为 "2022-05-17 17:21:25"。
修改了 预计剩余，旧值为 "10"，新值为 "0"。
修改了 由谁完成，旧值为 ""，新值为 "zhubin"。
2023-10-31 14:51:34, 由周杰关闭。
修改了 任务状态，旧值为 "done"，新值为 "closed"。
修改了 指派给 ，旧值为 "shupengming"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "zhoujie"。
修改了 关闭时间，旧值为 "0000-00-00 00:00:00"，新值为 "2023-10-31 14:51:34"。
修改了 关闭原因，旧值为 ""，新值为 "done"。

基本信息
任务的一生

所属迭代	平台财务数据自动化获取（接口/小工具）
所属模块	/
相关需求	Shopee广告费数据采集
指派给	Closed 于 2023-10-31 14:51:34
任务类型	后端
任务标签	初始
开发组
任务状态	已关闭
进度	100%
优先级	P2
关键词
抄送给

由谁创建	舒鹏明于 2022-05-12 09:44:06
由谁完成	zhubin 于 2022-05-17 17:21:21
由谁取消	暂无
由谁关闭	周杰于 2023-10-31 14:51:34
关闭原因	已完成
最后编辑	周杰于 2023-10-31 14:51:34

团队	最初预计	总计消耗	预计剩余

工时信息

最初预计	10工时
总计消耗	10工时
预计剩余	0工时
预计开始	0000-00-00
实际开始	2022-05-17
截止日期	0000-00-00