A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | "Outreach" Effectiveness: | "Support" Effectiveness: | Color Code: | ||||||||||||||
2 | |||||||||||||||||
3 | Requested Metrics: | Requested Metrics: | Requested Inputs | ||||||||||||||
4 | |||||||||||||||||
5 | Total Lifetime Post Reach (past 180 days): | Money Spent on Social Media in the Past Quarter: | Researched Inputs | ||||||||||||||
6 | 0 | 0 | |||||||||||||||
7 | Estimates | ||||||||||||||||
8 | Total Lifetime Post Reach by People Who Like Your Page (past 180 days): | Average Number of Engaged Users Over 28 Days: | |||||||||||||||
9 | 0 | 0 | Discount Factors | ||||||||||||||
10 | |||||||||||||||||
11 | Total Unique Videos Views to 95% (past 180 days): | Estimates: | Interesting Output | ||||||||||||||
12 | 0 | ||||||||||||||||
13 | Average animals spared by preventing one person's recidivism over a period of 1 month: | Most Important Output | |||||||||||||||
14 | Estimates (from the Online Ads Cost Effectiveness Spreadsheet): | Pessimistic | Realistic | Optimistic | |||||||||||||
15 | 0.425 | 0.7233333333 | 1 | ||||||||||||||
16 | Total animals spared per year of vegetarianism: | ||||||||||||||||
17 | Pessimistic | Realistic | Optimistic | Total years of suffering averted by preventing one person's recidivism over a period of 1 month: | |||||||||||||
18 | 10.2 | 17.36 | 24 | Pessimistic | Realistic | Optimistic | |||||||||||
19 | 0.1083333333 | 0.1708333333 | 0.2416666667 | ||||||||||||||
20 | Total years of suffering averted per year of vegetarianism: | ||||||||||||||||
21 | Pessimistic | Realistic | Optimistic | Average monthly rate of recidivism: | |||||||||||||
22 | 2.6 | 4.1 | 5.8 | 0.007 | |||||||||||||
23 | |||||||||||||||||
24 | Probability that a video view will create a 7.03 year vegetarian: | Probability that following a FB page will prevent recidivism: | |||||||||||||||
25 | Pessimistic | Realistic | Optimistic | Pessimistic: | Realistic: | Optimistic: | |||||||||||
26 | 0.0016 | 0.0056 | 0.0144 | 0.0001 | 0.15 | 0.3 | |||||||||||
27 | |||||||||||||||||
28 | Discount Factors: | Discount Factors: | |||||||||||||||
29 | |||||||||||||||||
30 | Video content: | In the past 3 months, did the page include any of the following features? (1="yes"; 0="no"): | |||||||||||||||
31 | |||||||||||||||||
32 | Use the second sheet of this document to calculate the number of views of videos that... | Feature: | Examples: | 1="yes"; 0="no" | |||||||||||||
33 | |||||||||||||||||
34 | ...have a strong "go veg" message (e.g. investigations, detailed animal rescue stories, arguments for going veg): | ...have a weaker "go veg" message (e.g. veg food ideas, info about nutrition, cute rescued farmed animals): | ...have a very weak or no "go veg" message (e.g. cute animals that don't reference rescue stories, <15 sec videos): | Education | News, links to informational websites, health info, environmental info | 0 | |||||||||||
35 | |||||||||||||||||
36 | |||||||||||||||||
37 | Discussion among users | Debates, discussions, sharing of resources in the comment threads | 0 | ||||||||||||||
38 | 0 | 0 | 0 | ||||||||||||||
39 | |||||||||||||||||
40 | Video content discount factor: | Interaction with leaders | Page moderators are available to answer questions and provide feedback | 0 | |||||||||||||
41 | #DIV/0! | ||||||||||||||||
42 | |||||||||||||||||
43 | Audience: | Specific strategies | Recipes, meal ideas, tips for dining out, etc. | 0 | |||||||||||||
44 | |||||||||||||||||
45 | Portion of video reach by fans: | Portion of video reach by non-fans: | |||||||||||||||
46 | Motivation | Photos and memes of cute farm animals, reminders of suffering in factory farms, etc. | 0 | ||||||||||||||
47 | #DIV/0! | #DIV/0! | |||||||||||||||
48 | |||||||||||||||||
49 | Relative probability a fan will view to 95%: | Relative probability a non-fan will view to 95%: | Group belonging | Articles or lists e.g. "Why we're proud to be vegan" or "What people get wrong about vegans" | 0 | ||||||||||||
50 | |||||||||||||||||
51 | 2.333 | 0.4286326618 | |||||||||||||||
52 | Event information | Information about vegfests, local meetup groups, direct action events, etc. | 0 | ||||||||||||||
53 | Portion of views from fans: | Portion of views from non-fans: | |||||||||||||||
54 | #DIV/0! | #DIV/0! | |||||||||||||||
55 | Discount factor for strength of page: | ||||||||||||||||
56 | Probability a fan is non-veg: | Probability a non-fan is non-veg: | 0 | ||||||||||||||
57 | 0.775 | 0.9333 | Number of Fans: | ||||||||||||||
58 | 0 | ||||||||||||||||
59 | Probability that a given video view to 95% comes from a non-veg*n: | ||||||||||||||||
60 | #DIV/0! | Is the organization a local group, likely to have many fans who do not follow other pages? | |||||||||||||||
61 | (1="yes"; 0="no") | ||||||||||||||||
62 | Calculated Estimates: | 0 | |||||||||||||||
63 | |||||||||||||||||
64 | Total animals spared per 7.03 year veg convert | Discount factor for multiple pages: | |||||||||||||||
65 | Pessimistic | Realistic | Optimistic | 0.333 | |||||||||||||
66 | 71.706 | 122.0408 | 168.72 | ||||||||||||||
67 | Discount factor for portion of fans who are veg: | ||||||||||||||||
68 | Total years of suffering averted per 7.03 year veg convert | 0.225 | |||||||||||||||
69 | Pessimistic | Realistic | Optimistic | ||||||||||||||
70 | 18.278 | 28.823 | 40.774 | Calculated Estimates: | |||||||||||||
71 | |||||||||||||||||
72 | Approximate unique 95% video views from non-veg*ns: | Number of engaged veg page fans at risk of returning to meat in a 1 month period: | |||||||||||||||
73 | #DIV/0! | 0 | |||||||||||||||
74 | |||||||||||||||||
75 | Number of 7.03-year vegetarians created: | Number of people prevented from returning to meat in a 1 month period: | |||||||||||||||
76 | Pessimistic | Realistic | Optimistic | Pessimistic | Realistic | Optimistic | |||||||||||
77 | #DIV/0! | #DIV/0! | #DIV/0! | 0 | 0 | 0 | |||||||||||
78 | |||||||||||||||||
79 | Number of lives saved by social media outreach over a three month period: | Number of lives saved by social media support over a three month period: | |||||||||||||||
80 | Pessimistic | Realistic | Optimistic | Pessimistic | Realistic | Optimistic | |||||||||||
81 | #DIV/0! | #DIV/0! | #DIV/0! | 0 | 0 | 0 | |||||||||||
82 | |||||||||||||||||
83 | Years of suffering averted by social media outreach over a three month period: | Years of suffering averted by social media support over a three month period: | |||||||||||||||
84 | Pessimistic | Realistic | Optimistic | Pessimistic | Realistic | Optimistic | |||||||||||
85 | #DIV/0! | #DIV/0! | #DIV/0! | 0 | 0 | 0 | |||||||||||
86 | |||||||||||||||||
87 | Totals and Cost Effectiveness: | ||||||||||||||||
88 | |||||||||||||||||
89 | Total animals spared by social media: | Animals spared by social media per dollar: | |||||||||||||||
90 | Pessimistic | Realistic | Optimistic | Pessimistic | Realistic | Optimistic | |||||||||||
91 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||||||||
92 | |||||||||||||||||
93 | Total years of suffering averted by social media: | Years of suffering averted by social media per dollar: | |||||||||||||||
94 | Pessimistic | Realistic | Optimistic | Pessimistic | Realistic | Optimistic | |||||||||||
95 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||||||||
96 | |||||||||||||||||
97 | |||||||||||||||||
98 | |||||||||||||||||
99 | |||||||||||||||||
100 |