ASO 工具表 v0.29
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
ASO 记录表
App Store Optimization
版本19.37US 评分5USTop Free iPhone Apps2019-09-17分类PLACEHOLDER
2
App URL:
https://apps.apple.com/us/app/id427916203
更新时间2019-09-13
i Peel Good2019-09-11Games近一周入榜get App ID427916203
3
日期2019-9-18字数分词
TikTok - Make Your Day2014-04-02Entertainment非游戏App 更新时间
2019-09-13T02:24:46Z
4
USA - US标题
Expedia: Hotels, Flights & Car
30
expedia,hotels,flights,car
Gmail - Email by Google2011-11-02Productivity
5
副标题
Mobile Exclusive Deals
22
mobile,exclusive,deals
Instagram2010-10-06Photo & Video
6
关键词(填写)
Water Shooty2019-07-02Games
7
Canada - CA标题
Expedia: Hotels, Flights & Car
30
expedia,hotels,flights,car
YouTube: Watch, Listen, Stream2012-09-11Photo & Video
8
副标题
Travel Deals & Instant Booking
30
travel,deals,instant,booking
Snapchat2011-07-13Photo & Video
9
关键词(填写)
Messenger2011-08-09
Social Networking
10
Spain - ES标题
Expedia: hoteles y vuelos
25
expedia,hoteles,y,vuelos
Google Maps - Transit & Food2012-12-13Navigation
11
副标题
Vacaciones, vuelos y hoteles
28
vacaciones,vuelos,y,hoteles
Sand Balls2019-09-09Games
12
关键词(填写)
Facebook2008-07-11
Social Networking
13
Country Code标题
Google Docs: Sync, Edit, Share2014-04-30Productivity
14
副标题
Photomath2014-10-17Education
15
关键词(填写)
WhatsApp Messenger2009-05-04
Social Networking
16
Rope Rescue! - Unique Puzzle2019-09-09Games
17
Amazon - Shopping made easy2008-12-03Shopping
18
Crazy Kick!2019-06-28Games
19
Spotify New music and podcasts2011-07-14Music
20
Uphill Run2019-05-08Games
21
Cash App2013-10-16Finance
22
Netflix2010-04-01Entertainment
23
Chinese (Simplified) - zh-CN翻译标题 D4
Expedia的酒店,机票和租车
The Real Juggle2019-03-17Games
24
翻译副标题 D5手机专享优惠
Color Fill 3D2019-09-07Games
25
DoorDash - Food Delivery2013-10-10Food & Drink
26
Remind: School Communication2012-05-03Education
27
Wish - Shopping Made Fun2012-06-14Shopping
28
Venmo: Send & Receive Money2010-04-03Finance
29
Collect Cubes2019-05-26Games
30
NFL2010-09-10Sports
31
⭕存储 [标题,副标题和关键词] 修改:工具 - 脚本编辑器 - Archi.gs - openById 的值
多地区指数同时查询,不稳定🙄
32
此区域输入信息关键词USA - USUK - GBName - Country CodeName - Country Code
33
下拉菜单,切换应用商店
34
自动获取信息
35
36
37
38
39
40
41
自动获取应用商店标题,副标题和 TOP50 用于后续排查
#REF! 多数情况是官方 API 返回值为 NULL
42
在 C2 处,填写应用商店链接,并且在 B 列选择需要记录的商店
副标题备用方法正在加载...
43
点击 Archive 会对标题关键词信息存档
副标题获取网址https://apps.apple.com/us/app/id427916203
44
语言检测en
45
西文分词=LOWER(REGEXREPLACE(D4,"\W+",","))
46
替换标题分词=LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(D4,","," "),"、"," "),".", " "),"&"," "),":"," "),"–"," "),"-"," "),","," ")," ",",")," ",","),",,",","))
47
中文不分词=IF(OR(DETECTLANGUAGE(D4) = "zh",DETECTLANGUAGE(D4) = "zh-Hant"),"",LOWER(REGEXREPLACE(D4,"\W+",",")))
48
描述获取方法#N/A
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...