Trustpilot & Cykelpartner - How to calculate Google Seller Ratings affect on Adwords ads
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
How to calculate Google Seller Ratings’ affect your on Adwords Ads
2
Find the related blog on
www.blog.trustpilot.com
3
4
Campaign 1Clicks
Impressions
CTRCPCCost
Position
Conversions
Conversion Rate
Cost/Conv. (CPA)
5
Total - all ad groups#DIV/0!#DIV/0!#DIV/0!#DIV/0!
6
Seller Ratings#DIV/0!#DIV/0!#DIV/0!#DIV/0!
7
W/O Seller Ratings (calculated)
00#DIV/0!#DIV/0!00#DIV/0!#DIV/0!
8
Difference#DIV/0!#DIV/0!#DIV/0!#DIV/0!
9
Seller Ratings % effect#DIV/0!#DIV/0!#DIV/0!#DIV/0!
10
11
Campaign 2Clicks
Impressions
CTRCPCCost
Position
Conversions
Conversion Rate
Cost/Conv. (CPA)
12
Total - all ad groups#DIV/0!#DIV/0!#DIV/0!#DIV/0!
13
Seller Ratings#DIV/0!#DIV/0!#DIV/0!#DIV/0!
14
W/O Seller Ratings (calculated)
00#DIV/0!#DIV/0!00#DIV/0!#DIV/0!
15
Difference#DIV/0!#DIV/0!#DIV/0!#DIV/0!
16
Seller Ratings % effect#DIV/0!#DIV/0!#DIV/0!#DIV/0!
17
18
Campaign 3Clicks
Impressions
CTRCPCCost
Position
Conversions
Conversion Rate
Cost/Conv. (CPA)
19
Total - all ad groups#DIV/0!#DIV/0!#DIV/0!#DIV/0!
20
Seller Ratings#DIV/0!#DIV/0!#DIV/0!#DIV/0!
21
W/O Seller Ratings (calculated)
00#DIV/0!#DIV/0!00#DIV/0!#DIV/0!
22
Difference#DIV/0!#DIV/0!#DIV/0!#DIV/0!
23
Seller Ratings % effect#DIV/0!#DIV/0!#DIV/0!#DIV/0!
24
25
Campaign 4Clicks
Impressions
CTRCPCCost
Position
Conversions
Conversion Rate
Cost/Conv. (CPA)
26
Total - all ad groups#DIV/0!#DIV/0!#DIV/0!#DIV/0!
27
Seller Ratings#DIV/0!#DIV/0!#DIV/0!#DIV/0!
28
W/O Seller Ratings (calculated)
00#DIV/0!#DIV/0!00#DIV/0!#DIV/0!
29
Difference#DIV/0!#DIV/0!#DIV/0!#DIV/0!
30
Seller Ratings % effect#DIV/0!#DIV/0!#DIV/0!#DIV/0!
31
32
Campaign 5Clicks
Impressions
CTRCPCCost
Position
Conversions
Conversion Rate
Cost/Conv. (CPA)
33
Total - all ad groups#DIV/0!#DIV/0!#DIV/0!#DIV/0!
34
Seller Ratings#DIV/0!#DIV/0!#DIV/0!#DIV/0!
35
W/O Seller Ratings (calculated)
00#DIV/0!#DIV/0!00#DIV/0!#DIV/0!
36
Difference#DIV/0!#DIV/0!#DIV/0!#DIV/0!
37
Seller Ratings % effect#DIV/0!#DIV/0!#DIV/0!#DIV/0!
38
39
40
41
Effect based on average
Clicks
Impressions
CTRCPCCost
Position
Conversions
Conversion Rate
Cost/Conv. (CPA)
42
Total - all ad groups00#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!
43
Seller Ratings00#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!
44
W/O Seller Ratings00#DIV/0!#DIV/0!00#DIV/0!#DIV/0!
45
Difference#DIV/0!#DIV/0!#DIV/0!#DIV/0!
46
Seller Ratings % effect#DIV/0!#DIV/0!#DIV/0!#DIV/0!
47
Your yearly Adwords spend$0.00
48
Seller Ratings (+) saves / (-) cost you#DIV/0!
49
50
51
Find the related blog on
www.blog.trustpilot.com
52
53
54
55
-- EXAMPLE --
56
57
Campaign 1Clicks
Impressions
CTRCPCCost
Position
Conversions
Conversion Rate
Cost/Conv. (CPA)
58
Total - all ad groups4,01630,71813.07%3.2913,2122.201934.81%68.46
59
Seller Ratings2,31818,07012.83%3.387,8442.301255.39%62.75
60
W/O Seller Ratings (calculated)
1,69812,64813.43%3.165,368684.00%78.94
61
Difference-0.60%0.221.39%-16.19
62
Seller Ratings % effect-4.45%7.04%34.66%-20.51%
63
64
Campaign 2Clicks
Impressions
CTRCPCCost
Position
Conversions
Conversion Rate
Cost/Conv. (CPA)
65
Total - all ad groups6,96153,16313.09%3.9027,1751.002874.12%94.69
66
Seller Ratings4,17330,21713.81%3.9616,5251.101764.22%93.89
67
W/O Seller Ratings (calculated)
2,78822,94612.15%3.8210,6501113.98%95.95
68
Difference1.66%0.140.24%-2.05
69
Seller Ratings % effect13.66%3.67%5.93%-2.14%
70
71
Campaign 3Clicks
Impressions
CTRCPCCost
Position
Conversions
Conversion Rate
Cost/Conv. (CPA)
72
Total - all ad groups2,42825,7039.45%2.365,7271.701245.11%46.19
73
Seller Ratings1,46416,3628.95%2.433,5581.60875.94%40.90
74
W/O Seller Ratings (calculated)
9649,34110.32%2.252,169373.84%58.62
75
Difference-1.37%0.182.10%-17.72
76
Seller Ratings % effect-13.30%8.03%54.83%-30.23%
77
78
Campaign 4Clicks
Impressions
CTRCPCCost
Position
Conversions
Conversion Rate
Cost/Conv. (CPA)
79
Total - all ad groups1,36416,8828.08%1.401,9101.50402.93%47.75
80
Seller Ratings72210,3246.99%1.401,0101.50223.05%45.92
81
W/O Seller Ratings (calculated)
6426,5589.79%1.40900182.80%49.99
82
Difference-2.80%0.000.24%-4.06
83
Seller Ratings % effect-28.56%-0.15%8.68%-8.13%
84
85
Campaign 5Clicks
Impressions
CTRCPCCost
Position
Conversions
Conversion Rate
Cost/Conv. (CPA)
86
Total - all ad groups2,26119,49511.60%3.708,3623.201325.84%63.35
87
Seller Ratings1,0958,88012.33%3.944,3143.40676.12%64.39
88
W/O Seller Ratings (calculated)
1,16610,61510.98%3.474,048655.57%62.28
89
Difference1.35%0.470.54%2.11
90
Seller Ratings % effect12.26%13.48%9.76%3.39%
91
92
93
94
Effect based on average
Clicks
Impressions
CTRCPCCost
Position
Conversions
Conversion Rate
Cost/Conv. (CPA)
95
Total - all ad groups17,030145,96111.67%3.3156,3871.927764.56%72.66
96
Seller Ratings9,77283,85311.65%3.4033,2521.984774.88%69.71
97
W/O Seller Ratings7,25862,10811.69%3.1923,1352994.12%77.37
98
Difference-0.03%0.220.76%-7.66
99
Seller Ratings % effect-0.28%6.75%18.49%-9.91%
100
Your yearly Adwords spend$100,000.00
Loading...
 
 
 
Sheet 1