1) trend analysis
Trend analysis is to summarize the trend of traffic based on time dimension. In excel, you can right-click the chart and then "Add Trend Line" to see the recent overall performance of this site. After adding data labels, you can monitor the traffic data of specific dates at a glance.
You can also analyze the sales trend of an ASIN in a certain period of time and choose products. For example, combining inventory sales forecast method and category ranking forecast method, with date as the horizontal axis and sales volume as the vertical axis, make a chart and get such a sales figure. This chart can also be combined with the daily ranking, for example, taking the daily ranking as a secondary vertical axis, and then combining the analysis. According to the progressive degree of ranking, the upward trend of sales, combined with market capacity, fierce competition, patent issues, resources at hand, and then determine whether the product is suitable for sale.
2) Comparative analysis
Through comparative analysis, we can find the differences between the data, which can be compared horizontally or deeply, so as to further explore the problem. This contrast can be reflected in the comparison of year-on-year and month-on-month in time. It can also be manifested in the comparative analysis between indicators.
For example, for the year-on-year and quarter-on-quarter growth of traffic and sales in time, these two indicators can intuitively see the work effect of business personnel. If there is a big increase or decrease in these two indicators, then it is necessary to investigate what is going on.
Or, by summarizing the ASIN data of a certain category of stores in a certain period of time, and then conducting data perspective. The line label is the product name of each ASIN.