ABCDEFIJKLMNOPQRSTUVWXYZ
1
KeywordPredicted ImpressionsPredicted CTRPredicted ClicksPredicted CPCPredicted Cost
2
craft100,0000.10%100$1.50$150.00
3
crafts100,0000.15%150$1.50$225.00
4
upcycling crafts30,0000.50%150$0.75$112.50
5
reuse crafts30,0000.65%195$0.75$146.25
6
crafts from trash40,0000.95%380$0.80$304.00
7
crafts from recycling50,0001.00%500$0.85$425.00
8
recycled crafts60,0000.80%480$0.90$432.00
9
environmental-friendly art20,0000.80%160$0.60$96.00
10
environment art15,0000.60%90$0.70$63.00
11
environment crafts5,0000.80%40$0.75$30.00
12
crafts from waste40,0001.25%500$0.85$425.00
13
waste crafts25,0000.90%225$0.40$90.00
14
shop for crafts50,0000.80%400$0.90$360.00
15
craft shopping45,0000.65%293$0.95$277.88
16
art shopping60,0000.20%120$1.00$120.00
17
art shops75,0000.25%188$1.50$281.25
18
craft shops50,0000.30%150$1.25$187.50
19
eco-friendly shops60,0000.50%300$0.75$225.00
20
eco-friendly art65,0000.75%488$1.00$487.50
21
eco-friendly crafts50,0001%500$0.80$400.00
22
art200,0000.05%100$2.00$200.00
23
Total (selected keywords)1,425$0.69 avg.$986.50
24
Remaining budget$13.50
25
26
27
28
29
Predicted clicks
30
31
The total 5,509 is the sum of all keywords in your list.
32
33
The 1,425 is the sum of only the selected six keywords used in optimized planr.
34
35
36
Predicted CPC
37
38
There are 21 values.
39
40
So,
41
20.50 ÷ 21 = 0.976... ≈ $0.98 average CPC
42
43
44
Predicted Cost
45
46
Selected six keywords (optimized for best performance) total $986.50 - well under $1,000.
47
48
So the remaining budget =
49
$1,000.00 − $986.50 = $13.50
50
51
That’s why sheet shows:
52
Total (selected keywords): $986.50
53
Remaining budget: $13.50
54
55
56
57
Reflection on My Keyword Adjustment Activity
58
59
In my completed keyword adjustment activity, I selected six keywords - upcycling crafts, environmental-friendly art, environment art, waste crafts, eco-friendly shops, and eco-friendly art. These were chosen to align with the Sinclair Verde Lamp Company’s mission of sustainability and waste reduction.
60
61
My goal was to maximize clicks within a $1,000 monthly budget. The total predicted cost of my selected keywords is $986.50, leaving $13.50 remaining. This combination produced 1,425 predicted clicks at an average CPC of $0.69, which represents strong cost efficiency and high engagement potential.
62
63
The selected keywords reflect eco-friendly and creative themes that appeal to the target audience of environmentally conscious customers aged 30–55 who value home décor and style. By focusing on sustainability-related search terms, my plan not only stays within budget but also supports brand awareness and traffic growth for both the online and physical store.
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