Model - Financial

profileBatman007
MarketingGoalProjection2021-22.xlsx
Home>Business & Finance homework help>Model - Financial

by Year

2021-22 Revenue Goal $5,025,000
2021-22 Marketing Budget $2,388,621
Close-Win Goal
Region/Segment School Non-profits Small Network/District Region Total
IL 72 25 10 107
NY/NJ/CT 26 5 3 34
DC/VA/MD 13 15 4 32
MO 20 5 9 33
Segment Total 130 50 25 205
Opportunity Goal (30 days) Cost per opportunity $1,911 Opportunity Close Rate 16%
Region/Segment School Non-profits Small Network/District Region Total
IL 436 152 61 649
NY/NJ/CT 159 30 15 204
DC/VA/MD 79 91 23 194
MO 119 30 53 203
Segment Total 793 305 152 1,250
SQL Goal (14 days) SQL Conversion Rate 33%
Region/Segment School Non-profits Small Network/District Region Total
IL 1,321 462 185 1,968
NY/NJ/CT 480 92 46 619
DC/VA/MD 240 277 69 587
MO 360 92 162 614
Segment Total 2,402 924 462 3,788
MQL Goal (60 days) Cost per MQL $95 MQL Conversion Rate 15%
Region/Segment School Non-profits Small Network/District Region Total
IL 8,808 3,080 1,232 13,119
NY/NJ/CT 3,203 616 308 4,127
DC/VA/MD 1,601 1,848 462 3,911
MO 2,402 616 1,078 4,096
Segment Total 16,014 6,159 3,080 25,253
Prospect Goal (90 days) Prospect Conversion Rate 15%
Region/Segment School Non-profits Small Network/District Region Total
IL 58,717 20,531 8,212 87,460
NY/NJ/CT 21,352 4,106 2,053 27,511
DC/VA/MD 10,676 12,318 3,080 26,074
MO 16,014 4,106 7,186 27,306
Segment Total 106,759 41,061 20,531 168,350
Simple Lead Goal Cost per SL $4 Qualifying Lead Rate 30%
Region/Segment School Non-profits Small Network/District Region Total
IL 195,724 68,435 27,374 291,533
NY/NJ/CT 71,172 13,687 6,844 91,703
DC/VA/MD 35,586 41,061 10,265 86,912
MO 53,379 13,687 23,952 91,019
Segment Total 355,862 136,870 68,435 561,167
Anonymous Visitors Cost per Visit $0.21 Filter Noise 5%
Region/Segment School Non-profits Small Network/District Region Total
IL 3,914,484 1,368,701 547,480 5,830,664
NY/NJ/CT 1,423,449 273,740 136,870 1,834,059
DC/VA/MD 711,724 821,220 205,305 1,738,250
MO 1,067,586 273,740 479,045 1,820,372
Segment Total 7,117,243 2,737,401 1,368,701 11,223,345
Lead Generation Channel Cost Per Lead $165.43 average by IT industry $208 $208
Channels/Funnel Break Down Budget Reserve Top (Brand Awareness) Middle (Lead Nurturing) Bottom Retarget Cost Per Lead # of leads with budget 11,484
Conference & Ads (O) 10% $330,195 811 average by Education $65
Email Campaign (I) 5% Y 53 Target Acquisition Cost $183,568
Webinar Hosting (O) 5% Y 72
Private Events (O) 5% Y 101
Influencer Affiliate (O) 5% Y 100
Organic Social Media (I) 0% Y Y 174
Content Marketing (I) 18% Y 92
Video 174
Blog/Case Study
Site Content Y
Press Release (O) 10% Y 294
Media Outlet 8%
Capterra 2%
Paid Digital Campaign (O) 15% Y 211
LinkedIn
Twitter
FB&IG
Vemio
PPC (I) 10% Y 110
Speaking Events (O) 0% Y 20
Re-targeting Campaign (O) 5% Y 31
Referral (I) 2% Y 73
Buyer Stats
Persona/Region IL NY/NJ/CT DC/VA/MD MO Persona Total
Board Member 0
District Leader 0
Superintendent 761 511 1,272
Assistant Superintendent 425 299 724
Principal 3,663 2,253 5,916
Assistant Principal 2,380 1,487 3,867
Director/Network Leader 27 27
Teacher 135,701 371,174 154,985 69,849 731,709
Executive Director 0
Admin 0
Regional Total 142,930 371,174 154,985 74,426 743,515
Target Organizations
Region/Segment Public Private Charter Non-profits Small Network/District Region Total
IL 4,266 1671 141 1,070 10,790
NY 4,401 311 4,712
NJ 0
CT 0
DC 0
DC 0
VA 0
MD 3,089
MO 2,276 737 76 518 16,968
Segment Total 10,943 2,408 528 0 1,588 13,879
https://linchpinseo.com/average-cost-per-lead-by-industry-and-marketing-channel/

Pivot Data

Segmet Region Month Quarter Monthly Goal Quarterly Goal Stage
Schools IL Jan Q1 22
Schools NY/NJ/CT Jan Q1 7
Schools DC/VA/MD Jan Q1 6
Schools MO Jan Q1 7
Non-profits IL Jan Q1
Non-profits NY/NJ/CT Jan Q1
Non-profits DC/VA/MD Jan Q1
Non-profits MO Jan Q1
Small Network/Districts IL Jan Q1
Small Network/Districts NY/NJ/CT Jan Q1
Small Network/Districts DC/VA/MD Jan Q1
Small Network/Districts MO Jan Q1

Supporting Data

IL Public Schools Cost Per Lead Data By Channel
Male Female Total Marketing Channel Low High Average
PreKindergarten Teachers 18 1,371 1,388 Events & Tradeshows $180 $1,442 $811
Kindergarten Teachers 158 3,943 4,102 Public Relations/Earned Media $108 $480 $294
Elementary Teachers (1-8) 11,300 53,682 64,983 Referrals $54 $92 $73
Secondary Teacher (9-12) 13,986 16,590 30,577 Video Marketing $59 $288 $174
Undefined Gradelevel Teachers 50 200 250 LinkedIn Advertising $51 $99 $75
Special Education Teachers 3,074 17,551 20,625 Webinars $45 $98 $72
District Superintendents 553 208 761 Display Advertising (Premium) $43 $82 $63
Assistant District Supuerintendents 204 220 425 Content Marketing $43 $140 $92
Principals 1,708 1,955 3,663 Display Advertising (Programmatic) $34 $42 $38
Assistant Principals 1,012 1,367 2,380 Traditional Advertising (TV, Radio, Print) $38 $1,200 $619
Other Admininstration Personnel 1,464 2,175 3,639 Search Engine Advertising $38 $181 $110
Ancillary School Staff 3,994 34,128 38,122 Social Media Advertising $34 $82 $58
Total Personnel 37,522 133,392 170,915 Email Marketing $33 $72 $53
Online Retargeting $22 $39 $31
Data Source: ISBE DW Report Card Data (EIS) Social Media Advertising $21 $73 $47
Note: Full Time Educators working at Public and Other State Funded Entities Search Engine Optimization $14 $47 $31
Table 208.30. Public elementary and secondary teachers, by level and state or jurisdiction: Selected years, fall 2000 through fall 2018
[In full-time equivalents]
State or jurisdiction Fall 2000 Fall 2005 Fall 2010 Fall 2015 Fall 2016 Fall 2017 Fall 2018
Total Elementary Secondary Ungraded Total Elementary Secondary Ungraded
1 2 3 4 5 6 7 8 9 10 11 12 13 14
United States 2,941,461 3,143,003 3,099,095 3,151,497 3,169,499 3,169,750 1,746,538 1,233,360 189,851 3,169,762 1,757,308 1,247,208 165,246
Alabama 48,194 57,757 49,363 40,766 42,533 41,802 22,301 19,501 0 42,114 22,423 19,691 0
Alaska 7,880 7,912 8,171 7,832 7,825 7,743 4,070 3,673 --- 7,657 3,990 3,667 ---
Arizona 44,438 51,376 50,031 47,944 48,220 47,868 33,299 14,569 --- 48,510 33,715 14,796 ---
Arkansas 31,947 32,997 34,273 35,804 35,730 35,800 18,177 14,862 2,760 38,019 17,259 18,230 2,530
California 298,021 309,222 260,806 263,475 271,287 271,523 181,402 85,849 4,272 271,805 180,739 87,079 3,987
Colorado 41,983 45,841 48,543 51,798 52,014 52,373 29,341 23,033 --- 53,147 29,840 23,307 ---
Connecticut 41,044 39,687 42,951 43,772 42,343 45,081 29,414 15,428 239 42,828 27,178 15,421 229
Delaware 7,469 7,998 8,933 8,962 9,208 9,399 4,788 4,611 --- 9,624 4,919 4,704 ---
District of Columbia 4,949 5,481 5,925 6,789 6,727 6,659 4,078 2,581 0 7,312 4,610 2,702 0
Florida 132,030 158,962 175,609 182,586 186,339 186,128 75,746 67,474 42,908 164,399 72,439 64,856 27,104
Georgia 91,043 108,535 112,460 113,031 114,763 116,022 53,116 45,502 17,403 117,159 53,036 45,886 18,238
Hawaii 10,927 11,226 11,396 11,747 11,782 12,033 6,518 5,450 66 12,132 6,547 5,477 108
Idaho 13,714 14,521 15,673 15,656 16,204 16,592 7,764 8,828 --- 16,745 9,189 7,556 ---
Illinois 127,620 133,857 132,983 129,948 128,893 128,204 89,854 38,018 332 132,423 92,317 39,807 300
Indiana 59,226 60,592 58,121 57,675 60,162 61,018 31,621 29,398 0 61,155 31,772 29,383 0
Iowa 34,636 35,181 34,642 35,687 35,808 35,553 25,007 10,546 --- 35,618 25,089 10,529 0
Kansas 32,742 33,608 34,644 40,035 36,193 36,387 18,729 17,658 --- 36,724 18,952 17,772 ---
Kentucky 39,589 42,413 42,042 41,902 42,029 42,064 24,701 10,092 7,270 41,827 24,476 10,005 7,346
Louisiana 49,915 44,660 48,655 58,469 48,408 40,281 27,409 12,872 --- 38,913 26,541 12,372 ---
Maine 16,559 16,684 15,384 14,857 14,750 14,760 10,329 4,431 --- 15,034 10,543 4,491 ---
Maryland 52,433 56,685 58,428 59,414 59,703 60,175 36,657 23,518 --- 60,699 36,425 24,274 ---
Massachusetts 67,432 73,596 68,754 71,969 72,413 73,381 47,733 25,648 0 73,868 47,815 26,054 0
Michigan 97,031 98,069 88,615 84,181 83,597 84,473 35,276 32,978 16,219 85,015 35,403 33,271 16,341
Minnesota 53,457 51,107 52,672 55,985 56,715 57,260 30,816 24,497 1,947 57,698 31,116 24,656 1,926
Mississippi 31,006 31,433 32,255 32,175 31,924 31,625 14,795 13,117 3,713 31,963 15,021 13,288 3,654
Missouri 64,735 67,076 66,735 67,635 67,926 68,496 35,725 32,771 --- 68,498 35,620 32,879 ---
Montana 10,411 10,369 10,361 10,412 10,555 10,515 7,383 3,097 35 10,575 7,426 3,111 38
Nebraska 20,983 21,359 22,345 23,308 23,611 23,771 15,321 8,450 --- 23,912 15,437 8,475 ---
Nevada 18,293 21,744 21,839 22,702 23,705 23,709 11,348 8,453 3,908 23,240 10,722 8,907 3,611
New Hampshire 14,341 15,536 15,365 14,770 14,760 14,589 9,859 4,730 --- 14,644 9,807 4,837 ---
New Jersey 99,061 112,673 110,202 114,968 115,729 115,496 61,197 37,635 16,664 116,189 61,735 37,639 16,814
New Mexico 21,042 22,021 22,437 21,722 21,331 21,092 9,387 7,960 3,745 21,139 9,279 8,035 3,826
New York 206,961 218,989 211,606 206,086 209,151 213,159 108,893 95,744 8,522 212,157 108,194 95,626 8,337
North Carolina 83,680 95,664 98,357 99,355 100,220 100,401 70,004 29,641 756 100,220 70,265 29,131 824
North Dakota 8,141 8,003 8,417 9,195 9,265 9,284 6,163 3,121 --- 9,470 6,309 3,161 ---
Ohio 118,361 117,982 109,282 101,742 102,600 98,912 43,987 41,543 13,382 101,739 50,828 47,213 3,698
Oklahoma 41,318 41,833 41,278 42,452 41,090 41,597 23,643 17,954 --- 42,448 24,166 18,282 ---
Oregon 28,094 28,346 28,109 29,086 29,756 29,909 21,158 8,752 --- 30,152 21,270 8,882 ---
Pennsylvania 116,963 122,397 129,911 120,893 122,552 121,918 58,334 52,638 10,946 123,350 59,141 52,805 11,404
Rhode Island 10,645 14,180 11,212 10,631 10,689 10,687 5,939 4,748 --- 10,749 6,967 3,782 ---
South Carolina 45,380 48,212 45,210 50,237 50,789 52,467 36,969 15,498 --- 52,730 37,145 15,585 ---
South Dakota 9,397 9,129 9,512 9,638 9,777 9,833 6,250 2,495 1,087 9,865 6,247 2,501 1,117
Tennessee 57,164 59,596 66,558 66,488 64,270 64,019 45,462 18,558 0 64,116 45,690 18,426 0
Texas 274,826 302,425 334,997 347,329 352,809 356,877 176,132 155,342 25,403 359,576 177,123 156,841 25,612
Utah 22,008 22,993 25,677 28,348 28,841 29,212 14,230 12,035 2,946 29,753 14,169 12,430 3,155
Vermont 8,414 8,851 8,382 8,338 8,187 8,313 3,176 2,745 2,392 8,317 3,131 2,737 2,449
Virginia 86,977 103,944 70,947 90,255 91,628 85,936 37,097 48,840 --- 86,974 37,381 49,592 ---
Washington 51,098 53,508 53,934 57,942 58,815 60,183 33,057 24,810 2,316 61,837 34,180 25,487 2,171
West Virginia 20,930 19,940 20,338 19,664 19,356 19,239 9,951 9,083 205 18,912 9,819 9,070 23
Wisconsin 60,165 60,127 57,625 58,185 59,011 58,598 28,986 29,198 414 59,484 29,976 29,103 405
Wyoming 6,783 6,706 7,127 7,653 7,506 7,335 3,948 3,387 0 7,327 3,928 3,399 0
Bureau of Indian Education --- --- --- --- --- --- --- --- --- 5,585 1,801 932 2,852
DoDEA1 7,504 7,759 --- --- --- --- --- --- --- --- --- --- ---
Other jurisdictions
American Samoa 820 989 --- --- --- --- --- --- --- --- --- --- ---
Guam 1,975 1,804 1,843 2,336 2,289 2,202 1,068 1,134 0 2,163 1,068 1,095 0
Northern Marianas 526 614 607 --- --- --- --- --- --- --- --- --- ---
Puerto Rico 37,620 42,036 36,506 30,438 28,899 28,039 16,617 6,275 5,147 25,424 14,110 6,021 5,294
U.S. Virgin Islands 1,511 1,434 1,457 1,106 1,154 1,066 500 553 13 1,020 472 541 7
---Not available.
1 DoDEA = Department of Defense Education Activity. Includes both domestic and overseas schools.
NOTE: Distribution of elementary and secondary teachers determined by reporting units. Some data have been revised from previously published figures.
SOURCE: U.S. Department of Education, National Center for Education Statistics, Common Core of Data (CCD), "State Nonfiscal Survey of Public Elementary/Secondary Education," 2000-01 through 2018-19. (This table was prepared August 2020.)
NY
Count of Schools by Grade Organization
Grade Organization Public (Statewide) Public (NYC Only) Public (Not NYC) Charter (Statewide) Charter (NYC Only) Charter (Not NYC) Non Public (Statewide) Non Public (NYC Only) Non Public (Not NYC)
PreK Only 8 0 8 0 0 0 12 8 4
Elementary 2428 808 1620 201 166 35 941 443 498
Middle 631 254 377 17 16 1 24 11 13
Junior High 80 5 75 4 4 0 5 4 1
Junior-Senior High 342 99 243 28 20 8 224 65 159
Senior High 829 393 436 34 29 5 245 142 103
K-12 91 18 73 27 20 7 173 85 88
Special 1 1 0 1 1 0 85 41 44
Other 12 7 5 39 34 5 58 30 28
Current from SEDREF as of February 12, 2021 at 2:06:58 PM

Marketing Team

Sales and Marketing Data Strategist Intern / fellow
Marketing Team Structure
Content Writer Digital Marketer PR & Events Marketing Automation Research Analyst Animations Video Production
copy writer, content and site editor for all events, blogs, case studies, e-books, photographer and videographer, product videos production social media organic and paid campaigns, SEO and SEM, email campaigns, graphic designs medium articles, PR articles, collect PR from media outlets about Innovare, collect competitor PR movement, conference planning and private event management, align branding on swags, prints, digital materials connect back-end for CRM and other integrative softwares to track leads and feed into sales, as well as follow up with customer success for referrals, analytize data and make improvements to tell a story, UI/UX pricing, opportunity research trends on educational organizations, schools, nonprofits, public policy, customer persona social media, competitor movement, content to put out to meet customer needs 6 month list of essential animations - Upwork 6 month list of essential videos
July 2021 July 2021 August 2021 October 2021 December 2021
Conference TRUE TRUE TRUE TRUE TRUE
Email Campaign TRUE TRUE FALSE TRUE FALSE
Webinar Hosting TRUE TRUE TRUE FALSE TRUE
Private Events FALSE TRUE TRUE FALSE FALSE
Influencer Affiliate FALSE TRUE TRUE TRUE TRUE
Organic Social Media TRUE TRUE FALSE TRUE FALSE
Content - Video TRUE FALSE FALSE TRUE TRUE
Content - Blog TRUE TRUE TRUE TRUE TRUE
Content - Site Writing TRUE TRUE TRUE TRUE FALSE
PR TRUE TRUE TRUE TRUE TRUE
Paid Digital Campaign TRUE TRUE TRUE TRUE FALSE
PPC FALSE TRUE FALSE TRUE TRUE
Speaking Events TRUE TRUE TRUE FALSE FALSE
Re-targeting Campaign TRUE TRUE FALSE TRUE TRUE
Referral TRUE TRUE FALSE TRUE TRUE