Step three: Based on the recorded data, you can create horizontal and vertical analysis reports of the sources of effects. This is very helpful for your ad placement. You can clearly see the effectiveness of each source as well as the trend chart of each source's effectiveness. I won't go into detail here because Excel is quite powerful. As long as you can think of it, you can uncover meaningful data. This method is very helpful for renting out Taobao online stores, but it can only be used temporarily because it has significant limitations. It is more suitable for the initial stage of a store or for stores with not extremely high daily traffic and not particularly frequent transactions. First, it requires relatively high tracing ability from the data analysts; Second: When a customer places an order, we can immediately obtain their order time and location. It’s best to check the chat records between the user and the customer service representative to see the start time of the conversation. We take the earlier of the two times, which theoretically is closer to the time the customer visited our store. With the time and location, we can trace back in real-time customer visits, locate the access record of that customer, find their first visit, and see where they came from. This way, we can record it. Taobao online store promotion should be based on data rather than intuition. If you follow your intuition, you will only go further off track, but if you follow the data, the path will become wider. How do you analyze Taobao store data? Here, I recommend a tool called Quantum Hengdao Statistics. Let's talk about Quantum. The development team probably aimed to develop data at the quantum level. From the perspective of the store, Quantum is currently the best data statistics tool. I remember during a communication meeting at the Shanghai Crown Club, when the merchant asked the Quantum staff member Ni Hao why some Quantum data sometimes didn't match with other tools' data, he confidently replied: "This is normal because Quantum is the most accurate." This left a deep impression on me; and when consulting questions with Quantum's Bingyi and Ni Hao via Wangwang, they basically answered every question, which moved me greatly. The recent sub-account login feature released by Quantum also shows that the Quantum team is continuously striving towards quantum-level accuracy. Many friends have already explained Quantum's functions clearly enough, with screenshots provided, so I won't elaborate further here.
We specialize in collagen protein, and currently have three products, which is quite a lot in the collagen protein industry, but compared to other industries, the number of products is still relatively small. We were once eliminated in the second round of applying for the Taobao Cloud Brand due to the issue of product quantity, which was quite regrettable. The small number of products, high cost, and high per-customer spending make us particularly focus on data mining. Because of the small number of products, we cannot operate loosely with the idea that "if one market doesn't work, another will". Due to the high cost, every penny spent must consider its return; because of the high per-customer spending, losing each customer means a huge loss. We have always hoped for such data analysis that could directly tell us the source of every transaction, so we would have a direction to quickly adjust our ad placements. However, this has never been found, and we even thought whether Taobao could open up the user visit record interface so we could develop it ourselves, but we never found the entry point, and even if we did, development would require human and material resources. The real-time visit data report provided by Quantum Statistics allowed us to use this report combined with Excel to create a basic data report that can analyze promotional effects. I would like to share our report with everyone, and please correct any areas where it is not used properly.
Step one: We first familiarize ourselves with each column of the real-time customer visit report. Sequence number, the record serial number; Visit time, self-explanatory; Entry source, here displays the visit source. The Quantum team lists some common ones, such as Direct Express, Diamond Booth, etc., while other uncommon ones are grouped under other sources. What we actually want to use is not what we see directly, but the specific address of the source that appears when the mouse hovers over it. For example, when we hover the mouse over the "other sources" position of the first record, we can see the specific URL address of the source in the browser's address bar or prompt box. This is very important, through these, we can know where the source is; Visited page, shows the current position the user is visiting; Visitor location, self-explanatory, visitor's address; Customer tracking, this column is very important and can be used for tracing; Repeat customer, can be used to judge whether the user is a first-time visitor.
Thirdly, Quantum only retains 40 pages, or 1000 records, of data for the day. If the store's traffic is large, there may be issues with tracing unless the data is regularly saved in Excel or imported into a database.
Fourthly, we have discovered possible data loss, making tracing difficult. For instance, if a customer generates a few page views around 16:00 without purchasing, then revisits around 20:00 and places an order, we trace back and find that the page view records from the 16:00 time period are gone, even though the total number of visits at that time had not exceeded 1000.
The ideal situation would be for the Quantum team to provide an effect analysis report. I believe the Quantum team will eventually develop it. But as for us, we can't wait. I'm sure all buyers are eagerly looking forward to it. When the analysis tools are not yet sufficient, being able to lead competitors in operating details gives us an earlier opportunity for self-breakthrough and increases our chances of success.
To operate a store well, we need both macroscopic and microscopic reports. The process of gradually digging from the macroscopic aspect to the microscopic aspect is the process of a store or a company moving towards refined management. Quantum Statistics undoubtedly helps us manage our business more precisely. Thank you, Quantum Statistics, and hope that the Quantum Statistics team becomes stronger, achieving greater breakthroughs in the expressiveness, accuracy, and development speed of reports.
Secondly, data from the previous day cannot be traced because Quantum clears yesterday's data after midnight. Thus, if a customer sees the product through a search on the first day and directly enters the website on the second day, we cannot trace the real source of the user.