After completing the distribution analysis of product exposure prices, operators can analyze the exposure price trend for all product data exposed under different keywords. The most commonly used indicator is the “cumulative average of exposure prices.”
Calculation method of “cumulative average of exposure prices”.
Sequence exposure price 0 26.99
The exposure price of the product in sequence 0 is 26.99, so its “cumulative average exposure price” is: 26.99-1=26.99; the exposure price of the product in sequence 1 is 25.9923 is 27.98, so its “cumulative average exposure price” 26.9923.99 is: (27.98+26.99)-2=27.485; the exposure price of the product in sequence 2 is 25.99, so its “cumulative average exposure price” is (26.99+27.98+25.99)-3=26.986 7; the exposure price of the product in sequence 3 is 26.99, so its “cumulative average exposure price” is (26.99+27.98+25.99+26.99)-4=26.987 5; The exposure price of the product in sequence 4 is 23.99, so its “cumulative average exposure price” is (26.99+27.98+25.99+26.99+23.99)-5
=26.388.
By analogy, the corresponding “cumulative average exposure price” can be calculated through the exposure prices of products in different sequences and the exposure prices of products in the previous sequences.
In the “cleaned product portrait data” Excel table, add a column after the “exposure price” column and name it “cumulative average exposure price”. It should be noted that the “S” symbol needs to be added to the calculation formula of the cumulative average exposure price to fix the selected value range.
After completing the calculation of all “cumulative average exposure prices”, you can generate the corresponding line chart in the Excel table and select the “cumulative average exposure price” column.
Then follow the chart and select “Line Chart” in “All Charts” in the pop-up interface.
The horizontal axis of the line chart is the product number sorted from front to back, and the vertical axis is the “cumulative average exposure price”. It can be seen that when the product ranking is less than 100, the “cumulative average exposure price” is less than 30 US dollars, which means that the average price of high search ranking products (products exposed in the first few pages) is generally low. At the same time, when the product ranking is higher than 500, the “cumulative average exposure price” begins to be higher than 40 US dollars, and this value slowly increases with the increase in ranking, which means that as the price of the product increases, the competitiveness of the product gradually decreases, resulting in poor product search ranking.