ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Abweichung - 28/1 vs. 7/0 Attribution
2
MonthWebsite purchases 28/1Website purchases 7/0AbweichungMultiplikator purchasesPurchase conversion value 28/1Purchase conversion value 7/0Abweichung purchase valueMultiplikator Purchase conversion value
3
124219232244,96%181,70%139.417,72 €74.935,64 €46,25%186,05%
4
113741247433,87%151,21%116.052,88 €74.599,19 €35,72%155,57%
5
102030154323,99%131,56%57.041,26 €41.200,90 €27,77%138,45%
6
9126992627,03%137,04%34.387,25 €24.629,43 €28,38%139,62%
7
81621121125,29%133,86%46.240,59 €33.785,26 €26,94%136,87%
8
7124894624,20%131,92%33.780,67 €24.559,36 €27,30%137,55%
9
61471113922,57%129,15%40.609,80 €30.167,24 €25,71%134,62%
10
51802135524,81%132,99%55.933,66 €42.717,46 €23,63%130,94%
11
41650131420,36%125,57%52.071,77 €41.901,74 €19,53%124,27%
12
31456124214,70%117,23%44.177,44 €37.346,07 €15,46%118,29%
13
21603131018,28%122,37%57.934,43 €47.847,54 €17,41%121,08%
14
11351108519,69%124,52%44.389,96 €36.741,48 €17,23%120,82%
15
234611686728,11%139,09%722.037,43 €510.431,31 €29,31%141,46%
16
17
18
DATA IMPORT
19
Month
Amount Spent (EUR)
Purchase ROAS (Return on Ad Spend) [1 Day After Viewing]
Purchase ROAS (Return on Ad Spend) [7 Days After Clicking]
Purchase ROAS (Return on Ad Spend) [28 Days After Clicking]
Purchase ROAS (Return on Ad Spend)
Purchases [1 Day After Viewing]
Purchases [7 Days After Clicking]
Purchases [28 Days After Clicking]
Purchases
Cost per Purchase [1 Day After Viewing]
Cost per Purchase [7 Days After Clicking]
Cost per Purchase [28 Days After Clicking]
Cost per Purchase
Purchases Conversion Value [1 Day After Viewing]
Purchases Conversion Value [7 Days After Clicking]
Purchases Conversion Value [28 Days After Clicking]
Purchases Conversion Value
Reporting Starts
Reporting Ends
20
2020-12-01 - 2020-12-3143489,241,2927825371,7230846071,9130154953,205798032168523222534421925,8096379818,7292161917,1622888710,3079497556222,1374935,6483195,59139417,722020-12-012020-12-31
21
2020-11-01 - 2020-11-3038742,750,7128069121,9255006422,2826665632,99547347686024742881374145,049709315,6599636213,4476744210,3562550127616,174599,1988436,78116052,882020-11-012020-11-30
22
2020-10-01 - 2020-10-3125169,280,4348594791,6369518711,8314453172,26630519433115431699203076,0401208516,3119118614,8141730412,398660110945,141200,946096,1657041,272020-10-012020-10-31
23
2020-09-01 - 2020-09-3016855,180,4458872581,4612380291,5942719092,0401591682679261002126963,1280149818,2021382316,8215369313,282253747515,5124629,4326871,7434387,252020-09-012020-09-30
24
2020-08-01 - 2020-08-3119842,090,4109919871,7027067211,9194374182,33042940528412111337162169,8665140816,3848802614,8407554212,240647758154,9433785,2638085,6546240,592020-08-012020-08-31
25
2020-07-01 - 2020-07-3115002,680,4869230031,636998191,764719372,2516423732359461013124863,8411914915,8590697714,8101480812,021378217305,1524559,3626475,5233780,672020-07-012020-07-31
26
2020-06-01 - 2020-06-3020268,260,3985675141,4883981161,6050479912,00361550527111391200147174,7906273117,794784916,8902166713,77855888078,2730167,2432531,5340609,82020-06-012020-06-30
27
2020-05-01 - 2020-05-3124198,510,3889140281,7652929871,9225365532,31145058135013551452180269,138617,8586789716,665640513,428695899411,1442717,4646522,5255933,662020-05-012020-05-31
28
2020-04-01 - 2020-04-3025626,180,2787844311,6351145591,7531910732,031975503238131414121650107,673025219,5024200918,1488526915,531018187144,1841901,7444927,5952071,772020-04-012020-04-30
29
2020-03-01 - 2020-03-3122585,360,196481261,6535521241,7595398081,956021069133124213231456169,814736818,1846698917,0713227515,511923084437,637346,0739739,8444177,442020-03-012020-03-31
30
2020-02-01 - 2020-02-2925989,070,2560295541,8410639551,9731548692,229184423204131013991603127,39740219,8389847318,5768906416,212769816653,9747847,5451280,4657934,432020-02-012020-02-29
31
2020-01-01 - 2020-01-3124870,340,1565258051,4773211791,6283295681,784855374153108511981351162,551241822,9219723520,7598831418,40883793892,8536741,4840497,1144389,962020-01-012020-01-31
32
33
34
HINWEIS
35
Um das Sheet nutzen zu können, kannst du dir über “Datei, Kopie erstellen” eine Kopie des Sheets anlegen.
36
Update, 19.01.2021: In den ersten Werbeanzeigenberichten wurde das Standard-Attributionsfenster auf 7 Day Click umgestellt. Wir haben unsere Kalkulationstabelle angepasst!
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