| B | C | D | E | F | G | H | I | J | K | M | N | O | P | Q | R | S | AA | AB | AC | BG | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | |||||||||||||||||||||
3 | Insite | ||||||||||||||||||||
4 | by Insightr Consulting | ||||||||||||||||||||
5 | Weighted Scores Comparison between Google Analytics & Yahoo Web Analytics | ||||||||||||||||||||
6 | |||||||||||||||||||||
7 | GA | YWA | GA | YWA | |||||||||||||||||
8 | |||||||||||||||||||||
9 | Insightr (Base) Scoring | 53.5% | 77.7% | 53.5% | 77.7% | ||||||||||||||||
10 | Your Own Scoring | 53.5% | 77.7% | 53.5% | 77.7% | ||||||||||||||||
11 | |||||||||||||||||||||
12 | Notes: This worksheet provides a weighted score model to compare the features of Google Analytics and Yahoo Web Analytics. The cells highlighted in Blue contain the base scores offered by Insightr Consulting. The cells lighlighted in Light Green can be edited by you to define your own scoring and weighting model. The grouped weights in column P must add to 100% (there will be a warning message if incorrect) and the same for column O must add to 100%. You are free to edit your own weights and scores and the workbook will self calculate the final scores, provided the groups add to no more than 100% | ||||||||||||||||||||
13 | |||||||||||||||||||||
14 | Overall Weight & Score | 100% | 5.35 | 7.77 | 100% | 5.35 | 7.77 | ||||||||||||||
15 | |||||||||||||||||||||
16 | Setup & Coding | 5% | 100% | 6.20 | 8.20 | 5% | 100% | 6.20 | 8.20 | ||||||||||||
17 | Account Creation | 20% | 9 | 8 | 20% | 9 | 8 | ||||||||||||||
18 | User Access Management | 30% | 4 | 8 | 30% | 4 | 8 | ||||||||||||||
19 | Data collection process | 30% | 8 | 8 | 30% | 8 | 8 | ||||||||||||||
20 | Tracking Code Customisation | 20% | 4 | 9 | 20% | 4 | 9 | ||||||||||||||
21 | Basic Reporting | 15% | 100% | 4.50 | 8.15 | 15% | 100% | 4.50 | 8.15 | ||||||||||||
22 | Data latency | 5% | 5 | 9 | 5% | 5 | 9 | ||||||||||||||
23 | Default & Custom dashboards | 15% | 5 | 7 | 15% | 5 | 7 | ||||||||||||||
24 | Report navigation | 15% | 7 | 8 | 15% | 7 | 8 | ||||||||||||||
25 | Report saving / bookmarking | 20% | 2 | 8 | 20% | 2 | 8 | ||||||||||||||
26 | Report Filtering | 25% | 5 | 9 | 25% | 5 | 9 | ||||||||||||||
27 | Report distribution / emailing | 20% | 4 | 8 | 20% | 4 | 8 | ||||||||||||||
28 | Support and Community | 15% | 100% | 8.00 | 6.00 | 15% | 100% | 8.00 | 6.00 | ||||||||||||
29 | Support network | 50% | 8 | 5 | 50% | 8 | 5 | ||||||||||||||
30 | Consultant network | 50% | 8 | 7 | 50% | 8 | 7 | ||||||||||||||
31 | Campaign Management | 15% | 100% | 4.00 | 8.50 | 15% | 100% | 4.00 | 8.50 | ||||||||||||
32 | Campaign management | 50% | 5 | 8 | 50% | 5 | 8 | ||||||||||||||
33 | Campaign attribution | 50% | 3 | 9 | 50% | 3 | 9 | ||||||||||||||
34 | API's (Import and Export) | 15% | 100% | 5.00 | 8.00 | 15% | 100% | 5.00 | 8.00 | ||||||||||||
35 | Data Import Services | 50% | 2 | 8 | 50% | 2 | 8 | ||||||||||||||
36 | Data Export Services | 50% | 8 | 8 | 50% | 8 | 8 | ||||||||||||||
37 | Advanced Reporting | 20% | 100% | 5.30 | 7.90 | 20% | 100% | 5.30 | 7.90 | ||||||||||||
38 | eCommerce Support | 30% | 4 | 9 | 30% | 4 | 9 | ||||||||||||||
39 | Visualisation & data presentation | 25% | 8 | 7 | 25% | 8 | 7 | ||||||||||||||
40 | Visitor profile analysis | 15% | 0 | 7 | 15% | 0 | 7 | ||||||||||||||
41 | Conversion / Goal tracking | 30% | 7 | 8 | 30% | 7 | 8 | ||||||||||||||
42 | Analyst Assistance | 5% | 100% | 4.50 | 6.50 | 5% | 100% | 4.50 | 6.50 | ||||||||||||
43 | Calendar Events | 50% | 0 | 8 | 50% | 0 | 8 | ||||||||||||||
44 | Auto-alerts | 50% | 9 | 5 | 50% | 9 | 5 | ||||||||||||||
45 | Data Analysis | 10% | 100% | 5.30 | 8.60 | 10% | 100% | 5.30 | 8.60 | ||||||||||||
46 | Segmentation of Data | 20% | 8 | 8 | 20% | 8 | 8 | ||||||||||||||
47 | Path, Scenario, Funnel analysis | 20% | 4 | 8 | 20% | 4 | 8 | ||||||||||||||
48 | Custom Report Design | 25% | 6 | 9 | 25% | 6 | 9 | ||||||||||||||
49 | Data Drilldown | 35% | 4 | 9 | 35% | 4 | 9 | ||||||||||||||
50 | |||||||||||||||||||||