58 must-have planning tools for planners in 2020

I have divided these tools into the following types: Taobao backend data, e-commerce plug-ins, advertising and marketing case websites, data report websites, media and channel backend data, high-definition image material websites, font websites, PDF to PPT conversion websites, one-click cutout websites, and advertising law inquiries. There are 10 categories and 58 tools in total.

1. Taobao backend data

01. Business Advisor

Business Advisor is a data management platform for Alibaba merchants. It is a business advisor for TP and a strategic advisor for planning. So, what can planners do with business advisors?

• Industry overview: market trend insights

Sales data: Look at the year-on-year growth in GMV and the number of sellers to determine the overall market competition coefficient.

Crowd portrait : Understand the crowd from multiple dimensions such as age, gender, occupation, and city.

Overall trend of sub-categories: Under the overall market, the market share of each sub-category over the years, as well as the year-on-year growth compared to the previous year, can be used to find opportunity categories through sales share and year-on-year growth.

• Category market analysis

Sales trends of each sub-category: Check GMV and number of visitors to see if there are opportunities to enter the market.

Business growth trends of each sub-category: IYA of GMV in the past two years "compared to the same period last year", the main focus dimensions are: GMV, number of visitors, number of paying people, conversion rate, and average order value.

Each sub-category丨Others: Mainly through the hot search words in the past 30 days, look at the proportion of brand words and category words. The age and gender of the consumer group, the sales ranking of the functions that consumers are concerned about, and the categories that this group of consumers prefer to buy.

From the perspective of GMV, look at the GMV of the top 20 brands in the past year, as well as this year’s GMV and IYA, to find the top or popular brands.

• Competitive product and brand analysis

Sales of competing brand stores: annual sales are based on year-on-year sales, and monthly sales are based on the proportion of each brand’s sales during big promotions and daily sales.

Comparison of store traffic, customer orders, and conversion rates in each month: See whether the big promotion and daily sales are going well, and whether the customer orders and conversion rates can take over the incoming traffic.

Analysis of traffic sources of each brand: mainly look at the ratio of paid and free. A healthy store has a ratio of 4:6 "paid: free", and which channel of traffic is mainly relied on among the paid sources.

Analysis of the category structure of each brand: Here we mainly look at the brand’s core categories and the concentration of the categories. Analysis of consumer groups of each brand: looking at the rejuvenation of brands from the perspective of age groups, and screening competing brands from the perspective of population.

• Store operation planning

Analysis of the overall store structure: Through visitors, customer orders and conversion rates, we can see which link has problems from the GMV level. Store traffic structure planning: From the perspective of mature stores, check whether there is any abnormality in the traffic structure and the amount of traffic that needs to be increased or decreased.

Store product structure planning: Based on the number and sales volume of SKUs, find out the fast-selling and slow-selling SKUs, and merge or delete the slow-selling SKUs that affect the weight. Analysis of the store’s main products: As the main source of store sales, we can use traffic sources to see if there is a possibility of being suppressed by competing products.

2. E-commerce plug-in

02. Little W God

Transaction index restoration: You can directly convert the transaction index into specific transaction amounts in Business Advisor, making it easier to view the sales trends of competing stores.

Main image/video download: used for competitive product analysis. Wireless terminal details: The PC terminal can view the mobile terminal details with one click.

Review download/analysis: The product review data can be exported to Excel, and then the number of occurrences can be analyzed by keyword search.

New product entry pool detection: mainly to see whether the new product has entered the Taobao search traffic pool. Most of Taobao's channels (such as search, homepage guess what you like, promotion venues, etc.) use a horse racing mechanism, and only those who enter the pool have a chance to race. If the product channel data is not included in the pool, it will not be included in the statistics and the promotion will be in vain.

Douyin promotion/Taobao live broadcast: Here we mainly look at the promotion of this product on these channels. Of course, it will be imported into Douyin Business Eye and Taobao Live Eye to see the promotion data of these channels. I will briefly introduce Douyin Business Eye later.

New products in the store: You can see the new products that have been recently released in this store. This is useful for competitive product analysis and to understand the latest market trends of competitors. Category: You can quickly see which category this product belongs to in Taobao.

03. W Superman

It is mainly a plug-in used on e-commerce pages to supplement Xiao W's functions in operational analysis.

Operational analysis: You can quickly see the number of payers, visitors, transaction amount, add-to-cart rate, 30-day GMV, conversion rate, UV value, and average order value for this product.

The above Little W God and W Superman are all plug-ins. It’s hard to say their full names. If you really don’t know the website, you can send me a private message in the background.

04, 58 pictures

This is good news for those who want to find the e-commerce page of a brand at a certain point in the past, as well as those who do MOCKUP . This website captures the past e-commerce history pages , which is great for reference.

Website: http://www.58tu.com/Top/index.html

05. Axure

A professional rapid prototyping tool that is easy to use and stable. It is a good helper for e-commerce copywriters to plan pages .

3. Advertising and Marketing Case Website

06. Shuying.com

Advertising and marketing cases/articles/agent index comprehensive recommendation TOP1 , if I can only choose one, I will choose this.

Website: https://www.digitaling.com

07. ADGuider

The most comprehensive advertising creative intelligent search tool , intelligent search by combination of categories + brands + festivals + celebrities + countries + types + awards + agents, etc.

Website: https://www.adguider.com

08.TOPYS

There are many international cases.

Website: https://www.topys.cn

09. New Studio

If you want to watch video cases and find image inspiration, this is a must-have website. "Changku, formerly V Movie" is from the same company and it basically has all the videos you want.

Website: https://www.xinpianchang.com/square

10. Qinggua Media

A must-have website that integrates operations, promotion and marketing, and reads useful articles!

Website: //www.opp2.com/

11. Online advertising community

Lots of foreign cases.

Website: http://iwebad.com

12. TVCBOOK

A website dedicated to watching various TVCs.

Website: https://www.tvcbook.com/homepage.html

4. Data Reporting Website

13. Useit Knowledge Base

Basically all the reports are here. You can search and see the ranking of popular reports. Downloading a report costs 5 points, or 1 yuan.

Website: https://www.useit.com.cn/portal.php

14. Discovery Report

There are many brokerage reports in it. Of course, this also costs money, ¥298/year, but you can earn points by sharing it with friends.

Website: https://www.fxbaogao.com/rp/?order=2&nop=-1

15. Frontier Report Library

The free version will have download restrictions, and the paid version will be more.

Website: https://wk.askci.com

16. Check the report

When I bought it, it seemed to be 99 yuan per year.

Website: http://report.seedsufe.com/#/report

I mainly use the above four because they collect most of the reports. Others such as China Business Network and 199IT are also good.

17. CBNData-China Business Data Center

Website: https://www.cbndata.com/home

18. 199IT

Website: http://www.199it.com

19. Fat Whale

Website: https://socialone.com.cn/?source=header_logo

20. Alibaba Research Institute

Website: http://www.aliresearch.com/cn/presentation

21. iResearch Institute (internal and external)

Website: https://www.iyiou.com/intelligence/report/

22. Jiguang Big Data

Website: https://www.jiguang.cn/reports

23. Headline Index (data report)

Website: https://index.toutiao.com/report

24. Baidu Index

Website: http://index.baidu.com/v2/index.html#/

25. TalkingData (Mobile Observatory)

Website: http://mi.talkingdata.com

26. QuestMobile

Website: https://www.questmobile.com.cn/research/report-new

27. Zhongyikang (home appliances)

Website: http://www.monitor.com.cn/report.aspx?id=464

28. National Bureau of Statistics

Website: http://data.stats.gov.cn

5. Media/channel background data

29. Flying Melon

The short video ecological service platform is mainly for Tik Tok, Kuaishou, and Bilibili . Here we mainly talk about Tik Tok, and then talk about some commonly used functions.

Website: https://www.feigua.cn/?chl=baidu-dy

• KOL Data

Data overview (likes, comments, reposts, fan trends, word cloud of works), fan feature analysis (gender, age, region, zodiac sign), host video (past video titles, hot words), e-commerce data analysis (past sales and prices of live broadcast products)

• View KOL list by industry tag

• View product sales and pageview rankings based on industry tags

30. Dou Shang Yan

In fact, what I would like to recommend more is this one, which is under E-commerce Yi, and has the same father as Little W God and W Superman. It basically has everything that Feigua has. In short, it costs less, works better, and comes with complete facilities.

• Live Monitoring

You can monitor the influencers, including the number of units sold, sales revenue, number of people online, and cumulative number of viewers. These points are pretty good, and the rest are routine basic operations.

Website: https://doushangyan.com/monitor/live/?uid=58544496104

31. WeiboEasy

The ranking quotations of Weibo, WeChat, and Xiaohongshu KOLs here can be used as a reference.

Website: http://www.weiboyi.com

32. Search Show

Xiaohongshu data analysis platform.

Website: https://souxiu.cn/index/

33. Ali V Mission

Taobao graphics/live broadcast/short video can be used as a reference for Taobao content marketing, which contains the host’s past data and quotations.

Website: https://v.taobao.com

34. Taobangdan

The only official ranking and data service platform of Taobao's content ecosystem, jointly produced and launched by Tianxia.com and Taobao's content ecosystem department.

Website: https://tbd.wshang.com/navi/homePage

As for the quotations mentioned above, everyone understands them. Just take a look at them. You need to find first-hand resources and bargain again and again.

6. High-definition picture material website

35. Pexelx

The pictures are many, good and free, and the website loads quickly when searching in English.

Website: https://www.pexels.com

36. VCG.COM

A website owned by Visual China, it is very convenient to search in Chinese. After registration, you will have the permission to download samples. Each account is limited to 200 pictures, but you can register a few more and that is basically enough.

Website: https://www.vcg.com

37. Masterpiece

Dazuo’s Big Rabbit Column, I usually search for pictures in this column, ¥196/year.

Website: https://p.bigbigwork.com/freecopyright

38. Shashaye

A website where images can be downloaded by size.

Website: https://www.ssyer.com

39. Huaban.com

A design website that everyone knows, and the pictures inside are also good.

Website: https://huaban.com/home/

40. ZCOOL

A relatively high-quality design and creative website.

Website: https://www.zcool.com.cn

41. Apple style high-end gradient color

Make the PPT background flat and simple in one second.

Website: https://uigradients.com/#FacebookMessenger

42. Automatic Gradient Generator

Generate the desired gradient color, which is more convenient to adjust. The adjustment of the gradient direction can be seen in the preview image.

At the same time, the page supports direct adjustment of color, brightness, highlights, etc., and the entire page changes synchronously, which is very convenient.

Website: https://gradient.shapefactory.co/?a=4568EE&b=0EC5BE&d=25

43. Two-color image generator

Unify PPT style with one click.

Website: https://duotone.shapefactory.co/?f=10c5f8&t=4d36dd&q=_

7. Font Website

44. Font World

It’s free and has a lot of fonts. I’ve tried it and it works great.

Website: http://www.fonts.net.cn

45. Font Search Network

When you see a good font, take a screenshot to download the font, upload the picture for automatic recognition, and then download the font resource.

Website: http://www.qiuziti.com

46. ​​Founder Font

Website: https://www.foundertype.com

47. Character Creation Studio

Website: https://www.makefont.com/fonts.html?yishu

48. Hanyi Font Library

Website: http://www.hanyi.com.cn/home

8. Convert PDF to PPT

49. smallpdf (Apple style)

Website: https://smallpdf.com/cn

50. iLovePDF (local style)

Website: https://www.ilovepdf.com/zh-cn

51. Apowersoft PDF Converter

An APP has a faster conversion speed than the two websites above.

9. One-click cutout

I have to say that the one-click cutout function is really useful, especially when you want to delete the background image in PPT, it can be done in just 3 seconds.

52. removebg

Website: https://www.remove.bg/en/upload

53. Finalization and Cutting Out

Website : https://www.gaoding.com/koutu

10. Advertising Law

54. New Advertising Law Prohibited Words Lookup Tool

You can monitor the language used in advertisements here to see if they comply with the new advertising law.

Website: https://zbp.toyean.com/tools/

55. Juyi.com

You can also see banned words in the beauty industry and news.

Website: http://www.ju1.cn

11. Others

56. Downie

Want to download videos on the web, but don't have permission to do so? Video download plug-ins are here. The Mac version of Downie is very easy to use. You can download by pasting the website. The high-definition version is really good. "The copyright of the creator is not easy to protect. Just watch it yourself after downloading."

57. Video Downloader professional

Windows version requires 360 browser.

58. Big company financial report website

Finally, I recommend that you read the financial reports of major companies as a pastime when you are bored.

Alibaba financial report: https://www.alibabagroup.com/cn/ir/earnings

Tencent financial report: https://www.tencent.com/zh-cn/investors.html

Baidu financial report: http://ir.baidu.com/investor-overview?c=188488&p=irol-irhome

Pinduoduo financial report: http://investor.pinduoduo.com/news-releases

Summarize

The tools shared above are both free and paid. If you think it is necessary, it is okay to pay for them. Overall, it is worthwhile. This is version 2.0. We will try to update to version 3.0 as soon as possible.

Author: Zang Feng

Source: Zangfeng