Amazon's operations cannot be billed, merged, not easy to sell, not easy to brush zombies and ratting, there are fewer and fewer routines, forcing many sellers to compete at low prices, so the dependence of operations will become less and less, but the product and cpc Dependency will increase. To budget for acos control and analysis of specific cpc, this table can be used to track advertising keyword spending and analysis, and can also be used as a cpc budget model, which is very important for advertising pits.

I showed you in the last article. Many children's shoes asked how to use and obtain this watch. Dean Bai spent a day making and testing it. Now it is used internally. Now this article will share and guide you how to use it. a ha ha ha. . . . .

A tool that can predict the profit and loss of advertising, and a tool that can make money by budgeting for product advertising and how much advertising is spent on natural orders.

This table can customize acos and budget to design future orders. You can budget how many orders will be issued in the future to balance advertising losses, how many orders will be added in the future to make money, how much advertising fees will be opened, and how many orders will be issued in acos. Loss, the concept of natural balance orders is introduced to offset the design of acos higher than profit, and the concept of new natural orders is introduced, so that the natural orders brought after advertising are split into orders that offset advertising costs and those that make money. Shan, according to this logic, the operating cpc personnel can quickly distinguish how much money can be earned according to the existing acos and cpc costs and the amount of orders, when the orders are placed and the natural orders are optimized to how much acos is optimized.

This table is divided into 2 parts

For the first part, check out the article " What should I do with Amazon's annual sales plan for 2022?" An entrepreneurial dog to give everyone's opinions, and at the same time share the thinking of the new product and redundant product advertising sales model control table designed by me " .

The table can track usage by day

Table 1: Baixiaotang's e-commerce advertising sales model, which is divided into estimated advertisements and actual advertisements. In the actual process, we fill in the estimated advertisements, namely

Table 2: Analysis and tracking of actual advertising spending, data changes such as daily orders for keywords and asin's number of customers for actual advertising tracking

Form download link: Extraction code: rpc7

1. Estimated advertising profit model table
Projected Ads tracked and analyzed the following separately.
Fill in the form:
Fill in the yellow area of ​​the form, from the date to the asin and its ranking and acos, you can predict the profit and loss after natural advertising and actual advertising. Budget hard and control your ad spend.
date – store – product name – asin – unit price – ranking – estimated profit margin – set ad list – set ad acos – set ad sales – ad spend – ad sales Profit – Estimated Natural Balance Order – Natural Balance Sales – Natural Balance Profit – Growth Point Order – Growth Point Sales – Growth Point Profit – Total Orders – Total Sales – Virtual Estimated Profit – -Advertising loss profit -Actual total profit -Comprehensive profit margin -Advertising proportion
Note: The yellow area in the table is manually filled in by yourself , and the green area in the table is set with a formula that can be directly automated.

Fill in the form:
From the date to the yellow areas such as the number of advertisement views and advertisement orders, the actual advertising spending and profitability can be obtained, which can be used to register the actual spending of the product.
Date – registration time – week – store – product name – a certain total parent asin – unit price – expected profit margin – ranking – a certain total session visitors – page views – conversion rate – A certain total ad exposure – ad click – ad conversion – ad acos – ad sales $ – ad spend $ – ad billing – natural billing – natural sales $ – total billing – – Proportion of current advertising – total sales – profit and loss after advertising – natural profit and loss – total profit and loss – profit and loss ratio – future forecast – natural percentage – future expected profit