Good afternoon, welcome to ShotSpotter's fourth quarter and full year 2022 earnings conference call. My name is Joe, I will be your operator for today's call. Joining us are ShotSpotter's CEO, Ralph Clark, and CFO, Alan Stewart. Please note that certain information discussed on the call today will include forward-looking statements about future events and ShotSpotter's business strategy and future financial and operating performance. These forward-looking statements are only predictions and are subject to risks, uncertainties, and assumptions that are difficult to predict and may cause actual results to differ materially from those stated or implied by their statements. Certain of these risks and assumptions are discussed in ShotSpotter's SEC filings, included in its registration statement on Form S-1. These forward-looking statements reflect management's beliefs, estimates, and predictions as of the date of this live broadcast, February 22, 2023.
ShotSpotter undertakes no obligation to revise or update any forward-looking statements to reflect events or circumstances after the date of this call. Finally, I would like to remind everyone that this call will be recorded and made available for replay via a link available in the investor relations section of the company's website at ir.shotspotter.com. Now, I would like to turn the call over to ShotSpotter's CEO, Ralph Clark. Sir, please proceed.
Good afternoon, and thank you for joining us today. Before I report on the company's Q4 fiscal year 2022 outcomes and our fiscal year 2023 outlook, I wanna first start by expressing my gratitude for being entrusted to lead this incredible company on a remarkable journey in engaging local law enforcement agencies in their digital transformation. We have assembled a powerful suite of complementary solutions in a precision policing platform that agencies are demanding in their pursuit of driving smarter, more efficient, effective, and equitable policing strategies. Our opportunity remains significantly attractive and under-penetrated despite some selected headline noise from a vocal but increasingly discredited Defund the Police movement.
We continue to see success because of the strong support from community residents, their elected officials, and our buying center of local police departments that understand and appreciate the value of investing technology in order to drive better community-focused public safety outcomes. Turning to financial performance, our Q4 2022 revenues increased 50% to $21 million from the prior year's $14 million in Q4 2021. Adjusted EBITDA increased 131% to $4.3 million, or 20% of revenues, compared to $1.9 million, or 13% of revenues for Q4 2021. Revenues for the full year increased 39% to $81 million, with $15.9 million of Adjusted EBITDA or 20% of revenues.
We finished the year with over 100 miles taken live for the second year in a row. In the quarter we took four new cities live and implemented five expansion projects, in addition to a security deployment at a college campus in Virginia. Going into 2023, we have 21 projects representing over 80 new contracted miles that are in the process of being deployed. Over 15 of the 80 miles are already live as of today. These miles do not include the 30-plus awarded but yet to be contracted miles from both Cleveland and Suffolk County, which when executed, will be added to the project list.
One notable new city go live was our international recapture of Cape Town, South Africa, which has already seen remarkable success that has been publicly trumpeted by Alderman JP Smith, who owns the security portfolio for the city of Cape Town. As recently as late last week, ShotSpotter led to the arrest of several shooters and the recovery of firearms and spare ammunition. In addition a number of ShotSpotter alerts have led to gunshot wound victims that have been successfully treated due to those ShotSpotter alerts. The city of Cape Town, along with the provincial government of the Western Cape, are in early discussions to motivate for an expansion to several other suburbs of Cape Town that are equally challenged with respect to gun violence.
Overall, we had another strong bookings year with 145 new miles and 77 subscription renewals booked, with 37.5% of those transactions representing multi-year agreements. Of note was the exceptional performance of our tier four, tier five initiative, which represented over 20% of the domestic new miles booked for 2022. We view this specific segment as a significant untapped TAM expansion opportunity and are in the process of significantly increasing our direct sales headcount to further penetrate and grow that business. COPLINK X also realized strong bookings with a late Q4 2022 multi-year seven-figure deal representing $1.2 million in annual recurring revenue.
We are taking intentional steps to more tightly integrate the COPLINK X solution and sales motion into ShotSpotter sales, customer success and support, and product management infrastructure in order to accelerate ShotSpotter Respond upsell opportunities in combination with the state and federal agency pipeline that our acquisition of Forensic Logic brought to the company. Our customer retention results remain best in class as an operating SaaS company. In 2022, we were able to realize negative GAAP revenue attrition net of pricing increases. As I reported in our last earnings call, our customer success organization, robust customer onboarding program, and our diligent Net Promoter Score process are central to our customer retention strategy. In addition to helping drive positive outcomes that promote stickiness, it also contributed to a best-in-class sales and marketing spend of $0.40 for a $1 worth of annualized contract value for 2022.
This is the second year in a row our sales and marketing spend per ACV has been below $0.50. Our demand drivers remain strong as there is increasing pressure on cities to deal with the rising violent crime in a transparent and community-inspired fashion. As a reference point, we published over 250,000 gunshot alerts in 2022. The overwhelming % of those alerts did not have a corresponding 911 call. Without ShotSpotter, it would have hobbled the efforts of any agency to respond to and investigate criminal gunfire. Our acoustic gunshot detection technology helps improve the speed and response to criminal gunfire in order to save lives and deter shooters. Our complementary investigative solutions accelerate the investigative process and helps improve case closure rates.
In our patrol management solution democratizes the crime analyst function in order to drive scientifically proven, smarter, and more effective patrol strategies without over-policing. These force-multiplying solutions are critical as agencies remain significantly below their budgeted staffing levels as they grapple with the great resignation, which has resulted in a 3.5% decline in police officers over 2020 and 2021. We believe the combination of these factors create a unique opportunity for proven technology solutions like ours to address the growing gap between increasing demand for policing services versus the limited and shrinking supply of those services. The funding and budgetary environment continues to be constructive, not only at the local and state level, but also at the federal level.
The Biden administration has committed $10 billion in American Rescue Plan funds to public safety, of which $450 million have been allocated to public safety technology, including gunshot detection, which was specifically called out in a White House press release of May 2022. For example, Detroit Mayor Mike Duggan and Police Chief James White allocated $7 million of ARP funds expressly for gunshot detection, which resulted in a 20-mile expansion of ShotSpotter. Given these demand drivers and the robust funding environment, we are very bullish on our ability to drive profitable growth for the foreseeable near and medium term. We have the breadth and depth of a high-quality suite of proprietary technology solutions that are proven, and in the case of our acoustic gunshot detection core, remain mostly unchallenged from a competitive point of view.
Our solution suite meets the needs of the market, and our brand reputation positions us as a trusted provider of these solutions to our buying center core and their appropriators. We are starting the year on a strong footing with approximately $80 million in ARR, a large book and growing pipeline of domestic and international acoustic gunshot detection deals, along with a growing pipeline of investigative and patrol management transactions, which exhibit faster and compressed contractor revenue timelines. These factors give us some degree of confidence in reaffirming our $94 million-$96 million revenue guidance for the year, which Alan will outline in more detail. With that, let me turn the call over to Alan.
Thank you, Ralph. I will cover highlights for both fourth quarter and 2022 as a whole. In fourth quarter, we went live in four new cities, one of which was international in Cape Town, South Africa, and one new security customer, a university in Virginia. We also went live with five response city expansions and achieved revenue growth of 50% compared to the fourth quarter of 2021. We did lose one small city with three miles of coverage. That said, our 2022 GAAP revenue attrition, net of price increases, will actually be negative. We are also pleased to report that we had total bookings for the year of approximately $75 million, including three new Investigate contracts that have not yet gone live. Let me provide more details on the quarter, then I will share some thoughts around 2022 and guidance for this year.
Fourth quarter revenues came in at $21 million, a 50% increase over the $14 million in the fourth quarter of 2021. Revenues increased as our deployed miles increased year-over-year, and we had a full quarter of revenues from Forensic Logic. Gross profit for the fourth quarter of 2022 was $11.9 million or 57% of revenue versus $7.5 million or 54% of revenue for the prior year period. Gross margin was higher than last year as our revenue base grows, but slightly lower than expected due to the increase in sensor maintenance costs that were slightly delayed during a replacement of 3G sensors that we also completed in the fourth quarter.
Our net loss for the fourth quarter was $1 million or a loss of $0.09 per share on 12.2 million weighted average shares outstanding on both a basic and diluted basis. This compares to a net loss of $3.3 million or a loss of $0.28 per share on an 11.7 million weighted average shares outstanding on both a basic and diluted basis outstanding for the prior year period. In Q4, similar to Q2 and Q3 of 2022, our expenses for the quarter were reduced due to a reduction in the contingent consideration liability related to the Forensic Logic earn-out by approximately $300,000, as the Forensic Logic-related revenue in 2023 is slightly lower than originally expected.
This contingent consideration adjustment by itself reduced our expenses for the quarter, but these ongoing reductions in contingent consideration also affected our tax projections and increased our tax expenses by slightly over $1 million for the year in total, which reduced our overall net income. Adjusted EBITDA for the fourth quarter was $4.3 million, a significant increase from the $1.9 million in the fourth quarter of 2021. As a reminder, Adjusted EBITDA is calculated by taking our GAAP net income or loss and adding back interest taxes, depreciation, amortization, stock-based compensation, and acquisition-related expenses, including adjustments to our contingent consideration liability related to earn-outs. Our operating expenses for the fourth quarter were $11.9 million, or 57% of revenue versus $10.7 million or 76% of revenue in the fourth quarter of 2021.
Breaking down our expenses, sales and marketing expense for the fourth quarter was $5.7 million or 27% of total revenue versus $3.6 million or 26% of total revenue for the prior year period. We continue to focus on investing appropriately to grow our sales and marketing capabilities for all of our products. These investments are important for our continued growth and are working well as we continue to build our sales pipeline and expand our marketing efforts. We continue to focus on maintaining high levels of customer satisfaction, which helps keep our attrition rates low. Our R&D expenses for the fourth quarter were $2.5 million or 12% of total revenue compared to $1.9 million or 13% of total revenue for the prior year period.
We continue to invest in increasing the functionality of all of our products. G&A expenses for the quarter were $4 million or 19% of total revenue compared to $5.2 million or 37% of total revenue for the prior year period. G&A expenses in absolute dollars were reduced to $3.7 million due to the $300,000 reduction in the contingent consideration liability related to the Forensic Logic acquisition. Our revenue results for 2022 were $81 million, an increase of over 39% from 2021. The increase was due to revenues related to Forensic Logic and significant expansion in customers using our gunshot detection solutions, having added over 100 miles live during the year.
Gross profit for 2022 was $46.8 million or 58% of revenue versus $32.5 million or 56% of revenue for the prior year period. Challenges with the global supply chain did not prevent us from completing our 3G sensor replacement or even slow down the deployment of newly contracted respond miles or expansions. Our net income for 2022 was $6.4 million or income of $0.52 per share on 12.2 million weighted average shares outstanding basic and 12.3 million weighted average shares outstanding computed on a diluted basis. This compares to a net loss of $4.4 million or $0.38 per share based on 11.6 million weighted average shares outstanding on both a basic and diluted basis for the prior year period.
Adjusted EBITDA for 2022 was $15.9 million, a 54% increase from the $10.4 million in 2021. Our revenue retention rate remains outstanding at 124% in 2022, essentially the same as the 125% in 2021. Our sales and marketing costs to acquire $1 of annualized contract value for the next 12 months stayed impressive at only $0.40 per dollar in 2022 versus $0.37 per dollar in 2021. Deferred revenue as of December 31st was $43.7 million, which was up from $26.7 million at the end of 2021. We ended Q4 with $10.5 million in cash and cash equivalents versus $9.6 million at the end of the 3rd quarter.
We have no short or long-term debt outstanding and approximately $25 million available on our line of credit if we ever need it. Our annual recurring revenue started on January 1, 2023, was $79.7 million, up significantly from the $63.2 million that we started with in 2022. The $63.2 million does not include additional recurring revenue of $6 million from Forensic Logic that was acquired after January 1, 2022. Our revenue guidance for 2023 is $94 million-$96 million. To provide a bit more explanation as to how we got to that range, the following may be helpful. We start with almost $80 million in ARR.
Adding approximately $4.5 million of GAAP revenue from the pace of expected go live miles and $4 million of professional services from our Leads division totals over $88 million. The GAAP revenue from international expansion and increased sales of Investigate, Connect, Security, and COPLINK X make up the difference to get to our revenue guidance. We're also providing guidance for our 2023 Adjusted EBITDA. We expect to increase our Adjusted EBITDA from the 20% we achieved in 2022 to between 24% and 26% Adjusted EBITDA in 2023. Back to Ralph for some final thoughts, and then we will be happy to take your questions.
As you can tell, there's a lot to be excited about in growing our business and having positive impact on public safety outcomes in communities globally. I think we're now ready to take your questions.
We will now begin the question and answer session. To ask a question, you may press star, then one on your telephone keypad. If you're using a speakerphone, please pick up your handset before pressing the keys. To withdraw a question, please press star then two. At this time, we will pause just momentarily to assemble our roster. Our first question here will come from Brian Ruttenbur with Imperial Capital. Please go ahead.
Great. Thank you very much. I had a couple questions around the South African situation. Can you walk us through the history, how long you were there, how long a contract you currently have, how long the contract you had before it was canceled, and how long it was canceled? Just walk us through the history and, you know, how long the contract is kinda going forward and what the opportunity is.
Yeah. This is Ralph. I will start. The current contract is a three-year contract, I believe, and correct me if I'm wrong, there, Alan. We are covering a number of communities in and around the Cape Town area, and we expect that there is going to be some expansion opportunity there. This is being paid for by the local city, Cape Town, South Africa, although they are engaged with the national police force, SAPS, to respond to these gunfire alerts that we're producing. Our previous deployment in Cape Town, and I don't recall the exact dates, but I think I wanna say 2015 to maybe 2019. We were there for approximately four or so years before. They ran out of money.
They basically had a funder outside of the country that funded that initial deployment. They weren't able to motivate themselves to get local funding to continue that deployment, although the need for the technology has been ongoing in Cape Town, and frankly, a large portion of South Africa. We think there is some other cities there that could leverage this service.
Okay. Just one other follow-up on that. Outside of Cape Town, internationally, can you talk about any other, you know, pipeline that you have on the international basis?
Sure. This year we had a fairly major expansion in Bahamas, which is international. We have a ongoing dialogue going with a few Latin American countries, we expect that we are gonna land 1 or 2 of those opportunities this year, 2023.
Great. Then last question. Number of miles, and I didn't catch it, that you are projecting in 2023?
Yes. I don't think we said that. I think what we did state is that we currently have approximately 21 projects totaling 80 or so miles that are already under contract and in the process of being deployed. In fact, we've gone live. I reported on my on the call that we have gone live with 17 of those 80 miles already, and I just got an email saying that we just went live with another 4 square miles in Detroit. We're making really good progress. There is another 30 square miles that have been awarded but have yet to be formally contracted between Suffolk County and Cleveland.
We expect those to be coming online from a contractual basis in the next 30 days or so, and we'll add those to the project list. We basically have a pipeline of about 110 miles that we're gonna be working on as of this particular moment.
Great. Thank you.
Our next question will come from Richard Baldry with ROTH MKM . Please go ahead.
Thanks. When you look at your deferred revenue growth year-over-year, it's pretty sharp, and it's something on the order of $1.25 to $1.30 per share in just cash generation from your deferred growth. How and why it spiked in the fourth quarter, where you see the long-term trends there, and maybe, you know, with that significant receivables likely to come in in the first quarter, how likely you'd be to maybe be aggressive on a buyback or some other way to deploy that cash? Thanks.
Yeah, sure. This is Alan. I'll go ahead and start. I think, well, first off, comparing where we are now versus where we ended 2021, we also have a deferred revenue from Forensic Logic. That helps a significant amount. That said, we also have some expansions and renewals that we have already included in and you see it in our AR. Our AR went from $16 million last year to over almost $31 million already. That's the offset related to the additional deferred revenue. That's primarily why that has increased significantly. In terms of what that will cause us to do or determine whether we do any kind of share buyback, we have authorization to do so.
We have historically repurchased shares in the past when we felt the market wasn't properly viewing our valuation. I don't see things being much different going forward. Our cash is good. We haven't used that. It's always something that we would consider, of course, and work with the board to see if we're gonna do that.
Thanks. With the sensor replacement cycle done, was that a drag somewhere in the P&L that would sort of ease off in 2023? Where would we sort of see that impact?
Yeah, great question. It's Alan again. The biggest thing that you would see is in our CapEx. Our CapEx was over $10 million related to that. We had to replace 5,500 sensors started halfway through 2021, finished and did the majority of them in 2022. Our actual CapEx being north of $10 million is gonna go back to somewhat normal, somewhere between $6 million and $7 million per year. You'll see improvement there.
You know, you are starting the year with a lot of contracted and soon to be, you know, finalized contracted miles. Could you maybe speak to what's also out there in the pipeline of things that are less visible? Are there any sort of, you know, tier one cities that you're working with? Do you feel like that pipeline has really come in, and that's why you have such a strong backlog right now, or is it still building going forward? Thanks.
Do you wanna start on that? Maybe I'll just start by saying that, we talked in the past about a fairly large CaseBuilder opportunity that we are working on with a large department of corrections entity. That particular opportunity has taken longer than we'd like, but it's because it's expanded in size considerably. I would expect in the next 90 days or so, that's gonna be a fairly large deal we are gonna be really excited to talk about. It's a substantive deal and unleashes, we think, a very big opportunity for us to go apply CaseBuilder to other department of corrections once we bring this one across the line.
This is Alan. I'd only add one more thing, too. We have already seen, as we mentioned, Forensic Logic, what's gonna be somewhat flat, adding about $6 million in 2022. That is pretty much what they did. That said, as Ralph mentioned earlier, they've already got a multi-year, you know, seven-figure deal with another state that's already helping to add revenues in 2023. We also just got another award for a second Forensic Logic contract, which is also significant, close to seven figures as well for the multi-years as well. We see a lot going on in basically every aspect of our products and every product that we're selling.
Maybe to play off that for my last question. Could you thinking about the software group, just those new offerings that you have, could you talk about, you know, how you feel about your it now that it's been in the organization for a little while, about your go-to-market, sort of the awareness on your client side, the pipeline there, and how we should think about opportunities for 2023 and beyond?
Yeah. I think it's still very early in the process for us. I mean, we were pretty intentional this year in terms of, like, tightly integrating our respective sales organizations between ShotSpotter and then our Forensic Logic colleagues. This year, we are gonna see a lot more integration between those organizations. Our current territory sales reps on the ShotSpotter side are now carrying specific Forensic Logic quota. We are also working on a fairly interesting internal transformation project to really think of ourselves more as a precision policing platform provider as opposed to an acoustic gunshot detection technology with side gigs on Investigate and data services and patrol management solutions. We are really focused on that area, and that's what makes us really quite excited. On the marketing side, the pipeline continues to grow with those with those products.
We are gonna see some wins in 2023 that frankly are gonna set us up for 2024 and beyond. We're not gonna take 2023 for granted, but as you can see from Alan's commentary, we have a lot of visibility to get to our guidance. A lot of the work that we're doing really to drive growth is expanding out beyond domestic acoustic gunshot detection into these other interesting areas that are super compelling on their own, and we think that's gonna set us up pretty nicely for 2024.
The last for me is just in terms of trying to normalize the earnings, the impact to taxes as a result of the changes to your earn-outs, that's a one-time impact, right? For most people's purposes, they would look at that as a one-time event, not a long-term change to your tax structure.
Yeah, this is Alan. That is correct. If there's any changes related to that, they would be small, going forward.
Great. Thanks.
Our next question will come from Jeremy Hamblin with Craig-Hallum Capital Group. Please go ahead.
Hey, guys. Congrats on the strong results. wanted to come back to the Forensic Logic deal. You noted that it wasn't quite tracking on a revenue basis where you expected it to be a year later. You get a reduction in the contingent, you know, the earn-out from that. Can you just talk us through a little more detail in terms of thinking about, you know, where, you know, you might be tracking lower than you expected a year ago? Is that, you know, deal, you know, the pipeline is not as large in terms of opportunity or it's just it takes longer to get results on some of those deals.
This is Ralph. I'll start, and Alan, jump in. I think what we are learning about Forensic Logic is that their buying center is a little bit different than our traditional buying center, whereas we have been very focused on, I'd say, local law enforcement, local policing agencies. They have a portion of their business associated with that. But the real kind of growth opportunities are some of these kind of much larger, I would call them state and federal opportunities. For example, they had already brought on the State of Tennessee just prior to us acquiring them. Their deal that came a little bit later than we expected and therefore not contributing to GAAP revenue, but definitely contributing to ARR, was this very large state deal with Massachusetts State Police.
There is another deal in the State of California. There's a state agency in California they recently closed a deal on that is a multi-year 7-figure deal, from an ARR point of view, is kind of in the, I think, $250,000-$350,000 per year range. We're seeing those deals come along. I think with those state-oriented deals and even some federal opportunities we see in the pipeline, it's just those are much more, I would say, long sell cycles than what we might find at the local level with local police departments. They're much bigger too, much, you know, much chunkier and bigger.
Are the contract lengths also longer?
They are about the same because what we're finding in our core business is we're getting multi-year contracts. I think I commented that about 37% of our transactions, both on new miles as well as renewals, were multi-year. Multi-year, think, you know, 2, 3, as much as long as 5 years, we're getting on a number of our transactions. It's about the same, frankly, but I think that might be. You might have a different view because I think there is an assumption that we don't have the multi-year contracts, and in fact, we do. We've got really good protection. If you look across our mileage of 1,000-plus miles or so, there's a substantial portion of those miles that are covered with multi-year contracts.
And for reference sake, would you be able to kind of if it's 37% today, where would that have been, let's say, kind of pre-COVID basis, just to see how that's changed over time here?
Wow.
Yeah. This is, this is Alan. I can say that, you know, last year we talked about, you know, between 37%-40%, in multi-years, which is fantastic. I would say maybe not pre-COVID, but certainly, you know, 4 or 5 years when we first went public, that would have been in the teens.
Teens, yeah.
in terms of multi-year.
Yes.
Yeah. Yeah.
It significantly increased and for several reasons. I mean, it's no longer people are concerning does the technology work. They know it works, you know. Even with new customers that used to sign up for 1 year, now they're signing up for 3 to 5-year contracts.
Got it. No, that's helpful context. Just changing gears here, wanted to get a sense, you know, operationally speaking, looking at the gross margins, you noted that, you know, the sensor upgrades, that replacement cycle, that's taken some time. It sounds like you're either at the end of that or you've fully completed it. Wanted to get a sense for what you think the benefit will be, you know, to your gross margin once that's done. Kind of post upgrade cycle, where would you anticipate, given your current revenue mix, your gross margins to be tracking? Are you still looking at 60%?
Yeah, this is Alan, and it's a great question. We did have 2022 was a little odd because we not only did almost 4,000 of those 3G sensors, which uses a lot of the same people, plus some of the vendors that we use to help do the normal go lives. There was a little bit more cost in there and a little bit more cost, you know, per actual mileage going live, which increased the COGS, which lowered the gross margin. We do believe that our gross margins are gonna be 60 and 60+%. Ultimately, we expect it's gonna get closer to 70 or 70+% over the next several years because the majority of...
Well, all of our, you know projects right now, especially the three new ones, are all software of nature that are gonna have gross margins closer to what you would see with a software product.
Let me just clarify, 'cause that's a huge jump. The timeframe that you think you could be in the upper 60s or you are close to 70% total company gross margins is... That's like 4 or 5 years?
Yeah, you should think four years.
Mm-hmm.
Four years.
Mm-hmm.
Absolutely.
The 60% or 60% plus, you're talking about FY 2023, correct?
We are expecting to get close to 60%. You know, assuming I mean, we are going live in, you know, more miles than we did in 2022, as we mentioned. We are expecting that, you know, we are gonna be able to cut back on some of the costs related to some of the miles, so that will directly affect us going up. You know, we're like to 58% right now, so it's not gonna be too hard to get us to 59 and probably 60%. I would say you should expect us to get somewhere between 59%-60% in 2023.
Great. Thanks for taking all those questions, guys. Best wishes this year.
Thank you.
Thanks.
Our next question will come from Mike Latimore with Northland Capital Markets. Please go ahead.
All right. Thanks. Yeah, great results for 2022 here. In terms of the miles that are either under contract or soon to be, the 110 miles you talked about, how does that statistic compare to, you know, prior February, like, you know, a year ago?
Yeah. Go ahead, Al.
This is Alan, and I'll go ahead and start. I would say, there's more sooner, and we will be going live faster. When you think about when I said adding four and a half million dollars of GAAP revenue for miles when we built our guidance, last year in 2022, it was probably closer to about $3.7 million. So there's a significant increase because we're going live in more miles, we're going live faster.
The pipeline for the Respond gunshot detection, you know, can you talk a little bit about, you know, other opportunities for new wins or expansions? You know, how does that pipeline look and has it grown year-over-year?
It continues to grow. It's probably the healthiest it's ever been, and there is a mix of, you know, tier one, tier two, and tier three opportunities. And the thing that we're really excited about is the success we've seen in the tier four, tier five market. As I think we mentioned on our.
Mm-hmm.
20% of the booked miles came from tier four, tier five, and that was 1 salesperson across the entire United States.
Mm.
Doing is quite intentionally expanding our kind of go-to-market resources there in terms of direct selling efforts. Our plan is to go from one sales rep to four sales rep and have them attached to each of the territory reps. We're already 50% there. We've got two now, and we're gonna be adding another two, and we're continuing to win business at that level. In fact, just this year, I think we have added three new logos on a booked basis...
Mm-hmm.
that are kinda tier four, tier five. The sales cycles appear to be shorter than what we find in the higher tier sales. It's just, I guess, easier for a chief of police, along with the city manager, mayor, and city council to kinda come together really quickly and make a decision to move forward with the technology. I think it also helps, and bears mentioning that the funding environment is very robust, not at the federal level, but also at the state level and even at the local level. You know, up and down the stack of money and budget is available for technology at large.
You know, we're seeing a significant portion of those dollars being allocated toward gunshot detection, 'cause that's a specific potential solution to address violent crime, which is on the uptick across the board.
Interesting. Okay. Got it. Did you give a kind of revenue churn assumption in your guidance on the passive that you gave on that?
I'm sorry. I didn't hear the question.
Revenue. Yeah, revenue churn. Yeah. I think previously we talked about, you know, a 1%, 1% churn, and we've always done better than that. I think the last couple of years it's been, you know, you know. Well, 2020, I think it might have been a quarter, half a %. 2021, I think it was a quarter of a %. This year, on a net attrition basis, it's actually negative because the price increases have been greater than the net GAAP revenue that we've lost from one city not renewing, along with a security project not renewing. There's a super small city of less kind of $50,000 of ARR that didn't renew.
We're able to execute, you know, fairly broad-based price increases across a number of customers that more than offset that attrition from those three customers that decided not to renew.
Mm-hmm. Have you baked in the normal kind of, 1% in the forecast for 23, or?
I think we-
Well, it's actually it's less than that, yeah. With the price increases that we.
Less than that. Yep.
What we know right now, we expect it to be certainly less than 1%, hopefully closer to 0 again.
Got it. Then just last, what is the kind of appetite for additional acquisitions and, you know, if you're looking around, what kind of value expectations are out there?
Yeah, I think we have a pretty good-
Yeah. This is Alan. I'll start. Go ahead, Ralph.
No, go ahead.
No, I was gonna say that, it's almost similar to what you were gonna say. you know, we have done acquisitions, about one every two years. We are now fully past one year integrating, the Forensic Logic acquisition. We're not the type of company that is going to acquire a company just to staple on revenues. It's gotta be a much greater reason to do that. We are also always looking for something that makes, you know, strategic importance to be able to do that. If we find something that makes sense to do that, we would absolutely consider that.
Mm-hmm. Okay. Great. Thanks very much.
Our next question will come from Matt Pfau with William Blair. Please go ahead.
Yeah, great. Thanks for taking my questions. Wanted to circle back to the delayed CaseBuilder contract that you cited. If I remember correctly, I think on the last earnings call, you had originally expected that to close in the fourth quarter, so it seems like it's delayed again. Wanted to know, did that have any impact on revenue in the quarter relative to what you had included in your guidance?
This is Alan. I will start. I will say that when we gave our original guidance for 22, we had expected that contract to already be underway and producing revenue for us in 22. It effectively did lower some of the actual revenue that we got. Now, for a good reason, though, 'cause originally, we thought that would be around $4 million-$5 million. Now it's significantly higher than that. So it's taking longer to get, but when we get that signed, it's eight figures plus and multiyear. So it's a good reason to have it delayed, but yes, it did affect a little bit in our 22 guidance versus what we originally expected.
Understood. Got it. Then just a last one from me just on the campus opportunity. You called out you had a win there. Have you seen more interest in that segment, particularly with, you know, some of the recent events that have happened? I know that's an area that you'd sort of put a little bit less focus on, but now it seems like you've had a few wins there. Is anything picking up in that segment?
Yeah. I mean, we continue to make steady progress on campuses. I think we're probably a little bit more excited about the linear freeway opportunities, frankly. We are also quite excited about the potential of trying to take another run at more infrastructure protection, particularly around some of these substation grids that we're now seeing. You know, people are, you know, organizing themselves to try to attack those things through weapons discharges. We got a lot of stuff that we're working on in the security space that we are pretty, we're pretty excited about. I would say the campus opportunity is there, but there are probably more pressing opportunities for us, near-term opportunities with freeways and infrastructure protection.
Yeah. This is Alan.
With those freeways.
I would just add one comment. Just everything Ralph said in terms of importance and focus is true. We did add 3 more or 3 more universities though, so it's not slowing down. We are still seeing interest there, and we still expect to see that continue to grow as well as we focus on the other things like the highways.
Okay. The highways, would those be through the state versus cities? What about the infrastructure? Who's contracting for those deals?
Yeah. We know in the case of highways, those tend to be kind of state-oriented deals. With respect to infrastructure, we don't have any of those deals done yet, but we are having conversations about how we can organize ourselves to go take a run at that particular market. Those would be commercial enterprises. Utility companies.
Perfect. Thank you.
Yeah. Mm-hmm.
Our next question will come from Erik Suppiger with JMP Securities. Please go ahead.
Yeah. Thanks for taking the question. In addition to the CaseBuilder, I think you also had some renewals that had slipped from Q3 into Q4. Can you give us a sense for what contribution those deals that slipped into Q4, what contribution that was in Q4? You talked about gross margins expanding towards 70. Can we still assume that you are anticipating EBITDA margins moving up into the 40% type range in kind of fiscal 2027?
Yeah. This is Alan. I'll start and then, Ralph, you can add, too. Certainly, there will be some delays in terms of renewals. If a quarterly delay happens, I mean, it can be anywhere from $200,000 to, you know, even half a million dollars that gets caught up or picked up. That we did get that in Q4. We now have those. There's other ones that, you know, if they are waiting for a December renewal and we don't get it till January, February, that will ship to Q1. That is something that is a little bit lumpy in nature and will always be there. To answer your second question, I think, absolutely.
We are expecting our Adjusted EBITDA to go from 20% this year to 25% in 2023. We still believe that the next, you know, four-ish years we'll be at 40%-45% Adjusted EBITDA. There are several reasons for that. Number 1, our gross margin continues to go up as the software products continue to grow. If you took a look and actually looked at our OpEx every quarter this year, we're basically even lower right now than we were in Q1 in terms of our overall OpEx. We're gonna continue to add appropriately in certain of the OpEx categories, but we don't need to add a ton as we continue to grow revenue. All of that flows and contributes towards that Adjusted EBITDA continuing to grow.
Okay. Can you parse out the organic growth that you're expecting in 2023? Or, at least parse out the inorganic contribution in fiscal 2023?
Well, yeah. This is Alan again. I would say at this point it's probably all organic since we've had everything more than a year.
Yeah.
You know, from that perspective, the entire 17% expected growth in the $14, you know, plus million dollars is all gonna be organic.
Okay. Very good. Thank you.
At this time, this concludes our question and answer session. If your question was not taken, you may contact ShotSpotter's investor relations team by emailing ssti@gatewayir.com. I'd now like to turn the call back over to Mr. Clark for his closing remarks.
Awesome. Great. Thank you everyone for joining the call. Great questions. As you can tell, we're incredibly excited about 2023. We are very pleased with our position in this vibrant and growing vertical market space. We have the people, we have the product, we have the processes, and most importantly, we have the brand reputation amongst our buying centers to be able to execute to the plan. With that, thank you all very much and looking forward to chatting with you over the next several days.
The conference is now concluded. Thank you very much for joining us on today's call. You may now disconnect.