ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
TikTok Ad Set Budget CalculatorInstructions: DUPLICATE THIS SHEET, THEN FOLLOW THE INSTRUCTIONS BELOW!
2
Average Cost Per Add To Cart$5.00
<- Enter in your average cost per add to cart here. You can enter in the cost per add to cart you are currently getting with TikTok ads, or if you haven't ran TikTok ads yet, take your Facebook average cost per add to cart in prospecting. Alternatively, use the calculator below "Cost Per Add To Cart Estimator" to get a cost per add to cart estimate
3
Add To Carts Needed Per Ad Set Per Week50
<- This is static (DO NOT CHANGE NUMBER FROM 50). You need 50 add to carts per week per ad set in order for the ad set to optimize and exit the learning phase.
4
Budget Needed Weekly Per Ad Set (To Exit Learning) $250.00<- Do not change this number, this is the weekly budget for the ad set that you need for it to exit the learning phase (50 conversions a week)
5
Minimum Daily Ad Set Budget$35.71
<- This is the final calculation of what your ad set daily budget should be in order to exit the learning phase (50 conversions a week) based on your average cost per add to cart
6
7
Cost Per Add To Cart Estimator
8
% of Traffic That Adds Something To Cart20%
<- This is the % of traffic that comes to your site that adds to cart. You can get this % by looking at your site data. I like to look at Facebook ads manager and take the outbound clicks and divide it by the add to carts in the last 30 days
9
CPM (Cost per 1000 Impressions)$3.00
<- $5 is the average CPM on TikTok right now for my clients, but it will be different based on your position in the auction and targeted audience. You can enter the CPM that you see in your own ad account, or use $5 as the default until you start spending and know what this is
10
Ad Click Through Rate (CTR)1%<- 1% is the average CTR on TikTok for my clients, but once you start spending on TikTok, you can enter in your actual click through rate
11
Cost Per Click (CPC) $0.30<- Do not change this number, this is based on the CPM of your TikTok ads campaign and the CTR of your ad creatives
12
Estimated Traffic per 1000 Impressions10<- Do not change this number, this is based on the CTR of your TikTok ad creatives
13
Estimated Add To Carts per 1000 Impressions2<- Do not change this number, this is based on the % of site traffic that adds something to cart
14
Estimated Cost Per Add To Cart$1.50<- This is the final calculation of your estimated cost per add to cart based on your % of traffic that adds to carts, the CPM, and the CTR of your ad creatives
15
16
Cost Per Purchase Estimator (Based On Add To Carts)
17
Average Cost Per Add To Cart$5.00
<- Enter in your average cost per add to cart here. You can enter in the cost per add to cart you are currently getting with TikTok ads, or if you haven't ran TikTok ads yet, take your Facebook average cost per add to cart in prospecting. Alternatively, use the calculator "Cost Per Add To Cart Estimator" to get a cost per add to cart estimate
18
Add To Cart to Purchase %30%
<- This is the % of users who have added something to cart and end up purchasing. You can go to your Facebook ads and divide your total add to carts by your total purchases in your Facebook ad dashboard in the last 30 days. So if you have 100 add to carts and 50 purchases, you have a 50% add to card to purchase %
19
Estimated Cost Per Purchase$16.67<- This is the final calculation of your estimated cost per add to purchase based on your % of traffic that adds to carts and ends up purchasing
20
21
Weekly Metrics Calculator
22
Budget Needed Weekly Per Ad Set (To Exit Learning) $250.00<- Enter in your weekly budget needed to get to 50 conversions a week. This is based off of cell B4
23
CPM (Cost per 1000 Impressions)$3.00
<- $5 is the average CPM on TikTok right now for my clients, but it will be different based on your position in the auction and targeted audience. You can enter the CPM that you see in your own ad account, or use $5 as the default until you start spending and know what this is
24
Ad Click Through Rate1%<- 1% is the average CTR on TikTok for my clients, but once you start spending on TikTok, you can enter in your actual click through rate
25
% of Traffic That Adds Something To Cart20%<- Enter in your % of traffic that adds something to cart. This is based off of cell B8
26
Add To Cart to Purchase %30%
<- This is the % of users who have added something to card and end up purchasing. You can go to your Facebook ads and divide your total add to carts by your total purchases in your Facebook ad dashboard in the last 30 days. So if you have 100 add to carts and 50 purchases, you have a 50% add to card to purchase %
27
Estimated Weekly Ad Impressions83333.33333<- This is the final calculation of your estimated weekly ad impressions based on your weekly budget and the current CPM's on TikTok
28
Estimated Weekly Site Traffic833.3333333<- This is the final calculation of your estimated weekly site traffic based on the estimated impressions and CTR
29
Estimated Weekly Add To Carts166.6666667
<- This is the final calculation of your estimated weekly add to carts based on the % of traffic that adds something to cart. REMEMBER: YOU NEED A MINUMUM OF 50 ADD TO CARTS A WEEK PER AD SET TO OPTIMIZE
30
Estimated Average Cost Per Add To Cart$1.50<- This is the final calculation of your estimated cost per add to cart based on the amount spent and the number of add to carts
31
Estimated Weekly Purchases50<- This is the final calculation of your estimated weekly # of purchases based on the Add To Cart to Purchase %
32
Estimated Average Cost Per Purchase$5.00<- This is the final calculation of your estimated cost per purchase based on the amount spent and the number of estimated purchases
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100