[Collection] 45 essential tools for bidding promotion to help you master search marketing!

This time, I have separately counted some essential SEM tools and skills and shared them with you, hoping to make your work more efficient!

1. Essential tools for bidders

It’s not quantity but quality of tools that matters. Therefore, the tools I share will cover many aspects, but only 1-4 are recommended for each aspect for everyone to choose from.

There are many tools out there, but the most important thing is to find the one that suits you best.

1. Universal tool

1) 199IT Big Data Navigation

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

This is a big data website collection, which organizes various websites! Like the mobile marketing tools and website analysis and testing tools we commonly use.

2) Xilin Street

Website: www.xilinjie.com

The function of the network disk is very powerful, and it brings together all the resources of the network disk.

2. Big Data Website

1) iResearch

Website: www.iresearch.com.cn

In fact, iResearch has many products, including iResearch.com, iResearch Consulting, and iResearch Data, but iResearch Consulting covers both relevant data reports on the Internet and relevant Internet data indexes.

2) Tencent Big Data

Website: https://bigdata.qq.com

3. Website analysis and monitoring tools

1) Baidu Statistics

Website: https://tongji.baidu.com

2) 51.la

Website: http://www.51.la/

3) GrowingIO

Website: www.growingio.com

5. Internet trend analysis tools

1) Weibo Index

Website:

http://data.weibo.com/index

2) Baidu Index:

Website: http://index.baidu.com/

3) Good search index:

Website:

http://index.so.com/#index

4) Sogou Index:

Website: http://zhishu.sogou.com

6. Material collection website

1) 500PX

Website: https://500px.com/

Content introduction: 500PX is a photography community that is full of high-quality photographic works by photographers, rather than simply sharing pictures.

2) Panorama Network

Website: www.quanjing.com

Content introduction: Paid material website with exquisite pictures. You can log in directly to search for material keywords. For most pictures, downloading small samples is enough. If you want to use high-quality large images, you need to pay

3) Pexels

Website: www.pexels.com

Content introduction: A free website abroad with high-quality pictures and free downloads

4) Design

Website: www.shejibao.com

Content introduction: Although the name is a bit rustic, it does not hinder the high-quality content. On the one hand, SEMers can collect materials through this website, and on the other hand, they can browse it frequently to improve their aesthetic taste.

5) Google Image Download Assistant

It is a browser plug-in. Just install it in the browser and you can batch download pictures from any web page.

7. Keyword Expansion Tool

1) Aichi SEM keyword expansion tool

Download channel: reply to the keyword " Tuoci " in the background of Aiqi SEM public account to get the download link

Description: Free and efficient. Aiqi SEM bidding keyword expansion tool (latest V20190214 version), 20w keywords without any pressure

2) 5118 Big Data

Website: https://www.5118.com/

A keyword expansion website, and also a website suitable for self-media people.

3) Aizhan.com

Website: https://ci.aizhan.com/

8. Full network marketing case

1) Mathematics and English

2) Advertisement scandal

3) Social beta

Content introduction: A soul website frequently visited by advertisers, covering various contents such as case sharing, industry information, and practical information.

9. PPT Templates

1) 51PPT template:

Website:

www.51pptmoban.com/ppt

2) PPT 1:

Website: www.1ppt.com

3) Webmaster materials:

Website: http://sc.chinaz.com/ppt

4) Rice Husk:

Website: www.docer.com

10. Online Survey Tools

1) Tencent Questionnaire Survey

Website: http://wj.qq.com/

2) Questionnaire

Website: http://www.wenjuan.com

3) Mike

Website: http://www.mikecrm.com

11. Data Visualization Tools

1) Baidu ECharts

Website: http://echarts.baidu.com

2) Chart Show

Website: http://www.tubiaoxiu.com

3) Data perspective

Website: http://shujuguan.cn

12. GIF animation production

1) Quick Editing

Website:

http://se.360.cn/welcome/wel_kjj_2.html

Content introduction: Quick Clip is a useful tool launched by 360. The main function is to edit videos, audios and GIFs. The disadvantage is that the output quality is not high.

2) GifCam

A GIF animation production tool that integrates recording and editing. With GifCam you can quickly and easily create demonstration tutorials or turn some funny and classic clips of videos into animated pictures.

13. Marketing Website Builder

1) Toutiao-Mobile website building

The backend of Toutiao comes with a mobile website building tool, which is very convenient to use. You can say that you can stack pages like building blocks. It can also track form and button filling/click data, and count the source creativity of each behavioral data.

2) Baidu Marketing Page

It is similar to Toutiao’s mobile website building, but it is unable to count the source of behavioral data, so there is still a lot of room for improvement and optimization.

2

Required forms for bidders

We all know that traffic is the core of bidding, but data is the clear direction of traffic control. Therefore, the editor has compiled several essential form templates for bidders.

1. Keyword effect statistics table

2. Planning Statistics Table

3. Customer service multi-dimensional data table

4. Marketing process chart

3

EXCEL Essential Skills

1. Pivot Table

Function: It is a function in Excel, which is used to specifically count the overall value of a certain item.

Application: Often used for multi-dimensional data analysis.

Application explanation: When using a pivot table, it is recommended to divide the data by dimension first. For example, a monthly data report can be divided into upper, middle and lower parts according to the data. A time period data report can be divided into morning, noon and afternoon according to the data to allow for data comparison.

2. LEN

Function: Mainly used to count the number of characters in a phrase or a word.

Purpose: Mostly used to filter long-tail words, short-tail words, or relatively messy general words, etc.

Function formula: = LEN(string)

Function explanation: The string refers to the keyword we want to calculate

3. COUNTIF

Function: Count the total number of values ​​that meet a certain condition in a set of data.

Purpose: Used to calculate the number of conversations generated by keywords, regions, time periods, etc. in consulting tools.

Function formula: =COUNTIF(range, criteria)

Function explanation: Area refers to the entire data group you want to count; Condition refers to a certain character you want to calculate.

4. VLOOKUP

Function: Used to search for keywords in a certain area and return the corresponding value of the specified column.

Purpose: To connect to keyword reports and count the number of keyword conversations.

Function formula: =VLOOKUP (lookup value, data table, column number, [matching condition])

Function explanation: Similar to =VLOOKUP (what to find, where to find, which column, precise search or approximate search)

Generally speaking, we perform an exact search, so the last parameter [matching condition] is often "0". When [matching condition] is 1, it is a fuzzy search.

5. IFERRO

Function: Used to calculate the conversation cost and avoid outputting wrong items.

Function formula: =IFERRO(value, error value)

Function explanation: The value refers to our formula for calculating the cost of the conversation.

Normally, we calculate the conversation cost, but if we don't use this formula, errors will occur when the conversation is 0. For example, the picture below.

Logically speaking, when our conversation is 0, our conversation cost should be a negative number, so at this time we need to use our IFERRO formula to calculate, and add a negative sign to the error value based on the original formula.

The above is an inventory of the daily essential tools and skills for bidders~ It is strongly recommended to forward and collect!

Source: Aichisem