Simple methods and tools for through-Train keyword data analysis

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

At present, most people do through-train to promote the main or use keyword promotion, if a lot of keywords, analysis is a very troublesome thing, in many cases, just "look" data is very easy to make mistakes. Through train is a precise marketing tool, we also want to strive for the most accurate data analysis. Let me share with you some of the through-Train keyword data analysis form.

Data acquisition, each baby about three minutes time.

1, download the baby's three-day conversion keyword report:

Enter the quantum constant road shop through-conversion data-three days conversion, here choose Baby Conversion Report, promotion plan, data time, start the query.

Click on the word and open the keyword report for this baby.

Click to download

4, open the downloaded document, copy all the word information to the keyword analysis form. Lines 1th and 2 do not need to be copied.

5. Replace All "￥" in the form

Then drag the cell. So all the keywords are out of the data.

6, fill in the current conversion rate, the expected ROI (or current ROI), profit. This can be compared to the flow value, conversion costs, ROI. Each parameter can be arranged by size, very convenient.

Here we add the average show rankings, click on the small arrow on the right side of the click, and choose descending order to maintain consistency with the underlying data. #p # subtitle #e#

Then go back to the quantum statistical interface and select the underlying data, as well as the selected baby report, promotion plan, and data period (to be the same as the period selected above). Click Start Query

Click again, more keywords.

Copy these keywords to excel tables, delete irrelevant columns, keep only the display and average display rankings, and then add the two columns of data to the keyword analysis form.

So far, the data for this form is complete.

II. Analysis of data

For the data processing method everyone is different, in our example above, this is already a mature explosion, the monthly sales volume is 16000, natural flow is enough, through the through train traffic has been done as a supplement, so the train itself will be profitable, or at least not lose money.

From the figure above, baby's conversion rate is 15.12%,roi is 1:5.8.

Unfortunately, the profit is very low, only 5 yuan.

Flow value = Profit * conversion rate =5*15.12%=0.756

Conversion fee = through train cost/turnover =7000.25/2301=3.04

So we can draw the following conclusion:

1, delete 30 days without a deal keyword

2, roi below average keyword lower bid

3, the flow value of less than 0.756 keyword, delete, or appropriate lower bid. Above 0.756 keyword can be appropriately raised bid

4, conversion costs above 3.04 keywords, delete, or appropriate lower bid. Bids below 3.04 can be raised appropriately. In fact, the relationship between conversion cost and flow value is the corresponding ~_~

5, ROI below the average level of 5.8, can appropriately reduce the bid, or delete as appropriate. Higher than 5.8 can be appropriately raised bids.

6, it should be noted that the number of clicks is too low keyword, ROI is meaningless.

7, keyword card position can refer to the average show ranking

Have you noticed the above analysis? It has not considered the quality score, the average price per click, the conversion rate and other factors. This should also be my last Post said: Short-term conversion rate-oriented, long-term ROI-oriented.

In fact, baby to the explosion stage, the through train is very good operation, only to observe the daily limit on the day. Basically every keyword will not let us down.

I am here just to give you a demo, we do data analysis can be added to the table analysis every week, but also in accordance with market conditions for fine-tuning. Like your baby's on the rise stage, the flow is not enough, below the average ROI of the large flow of words is not appropriate to lower the bid, this degree to their own grasp. The table only provides the accurate data, the concrete operation also must use flexibly.

such as market conditions (product homogeneity is not very serious, competitor positioning, in not playing price war, promotion start time, etc.), baby's growth stage and so on. Look at this stage baby to the through train flow dependence degree. Because the concrete operation is still depend on the person, cannot follow a data step by step completely.

The data analysis is finished, the operation is very simple. Select each word in the form, or do a good job with notes. Then sort the ~_~ by the list of countermeasures. What to do, at a glance. It's easier if you're working with software. Add high ROI words to software, set up automatic bidding, and get it done.

PS: For the above card is just a person's preference, there is no absolute good location, you can change the form according to their preferences. For example, the previous 14, 15 is very bad position, but now is a good position. And some popular classes are currently a few pages want to card bit is not so easy things, the card to a fixed number of pages is OK.

http://x.paidai.com/view/65209 sharing Form

Original: http://bbs.paidai.com/topic/107325