ShotSpotter, Inc. (SSTI) on Q4 2022 Results - Earnings Call Transcript
Operator: Good afternoon, and welcome to ShotSpotter's Fourth Quarter and Full Year 2022 Earnings Conference Call. My name is Joe, and 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 these 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, and 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.
Ralph Clark: 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 want to 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 underpenetrated 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 in 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 a 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 multiyear agreements. Of note was the exceptional performance of our Tier 4, Tier 5 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 account to further penetrate and grow that business. Coplink X also realized strong bookings with a late Q4 2022 multiyear 7-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 per dollar 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 percent of those alerts did not have a corresponding 911 call. And without ShotSpotter, it would have hobbled the efforts of any agency to respond to and investigate criminal gunfire. Our Tulsa 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 Tulsa 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're starting the year on a strong footing with approximately $80 million in ARR, a large booked and growing pipeline of domestic and international Tulsa gunshot detection deals, along with a growing pipeline of investigative and patrol management transactions, which exhibit faster and compressed contractor revenue time lines. These factors give us some degree of confidence in reaffirming our $94 million to $96 million revenue guidance for the year, which Alan will outline in more detail. And with that, let me turn the call over to Alan.
Alan Stewart: Thank you, Ralph. I'll cover highlights for both the 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're 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, and 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, was 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 11.7 million weighted average shares outstanding on both a basic and diluted basis outstanding for the prior-year period. In Q4 and 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 earnout 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 affects 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 earnouts. 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 concluding our 3G sensor replacement or even slowed 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. Additionally, 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 31 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 third 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 to $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 Leeds 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 are 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. Now back to Ralph for some final thoughts, and then we'll be happy to take your questions.
Ralph Clark: As you can tell, there's a lot to be excited about in growing our business and having positive impact on public safety outcomes and communities globally. I think we're now ready to take your questions.
Operator: And our first question here will come from Brian Ruttenbur with Imperial Capital. Please go ahead.
Brian Ruttenbur: Great. Thank you very much. So I had a couple of 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 contract you had before it was canceled and how long it was canceled? Just walk us through the history and how long the contract is kind of going forward and what the opportunity is?
Ralph Clark: Yes. So this is Ralph. I'll start. So the current contract is a 3-year contract, I believe, and correct me if I'm wrong there, Alan. We're 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 want to say 2015 to maybe 2019, we were there for approximately four or so years before. And they ran out of money. They basically had a funder outside of the country that funded that initial deployment, and 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 are some other cities there that could leverage this service.
Brian Ruttenbur: Okay. And just one other follow-up on that. Outside of Cape Town, internationally, can you talk about any other pipeline that you have on the international basis?
Ralph Clark: Sure. So this year, we had a fairly major expansion in Bahamas, which is international. We have ongoing dialogue going with a few Latin American countries, and we expect that we're going to land one or two of those opportunities this year, 2023.
Brian Ruttenbur: Great. And then last question, number of miles, and I didn't catch it that you're projecting in 2023.
Ralph Clark: 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 the call that we've gone live with 17 of those 80 miles already. And I just got an e-mail saying that we just went live with another four square miles in Detroit. So we're making really good progress. There's another 30 square miles that have been awarded, but have yet to be formally contracted between Suffolk County and Cleveland. And 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. So we basically have a pipeline of about 110 miles that we're going to be working on as of this particular moment.
Brian Ruttenbur: Great. Thank you.
Operator: Our next question will come from Richard Baldry with ROTH MKM. Please go ahead.
Richard Baldry: 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. Can you talk about how and why it spiked in the fourth quarter? Where you see the long-term trends there? And maybe 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.
Alan Stewart: Yes, sure. This is Alan. I'll go ahead and start. I think, well, first off, comparing where we are now versus where we ended '21, we also have a deferred revenue from Forensic Logic. So 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 ARR. ARR went from $16 million last year to over almost $31 million already. So that's the offset related to the additional deferred revenue. So 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 thought 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 debt. It's always something that we would consider, of course, and work with the Board to see if we're going to do that.
Richard Baldry: Thanks. And with the sensor replacement cycle done, was that a drag somewhere in the P&L that would sort of ease off in '23? And where would we see that impact?
Alan Stewart: Yes. Great question. This is Alan, again. The biggest thing that you would see is in our CapEx. Our CapEx was over $10 million related to that. So we had to replace 5,500 sensors, started halfway through '21, finished and did the majority of them in '22. So our actual CapEx being north of $10 million is going to go back to somewhat normal, somewhere between $6 million and $7 million per year. So you'll see improvement there.
Richard Baldry: And you're starting the year with a lot of contracted and soon-to-be-finalized contracted miles. Could you maybe speak to the - what's also out there in the pipeline of things that are less visible? Are there any sort of Tier 1 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.
Ralph Clark: Do you want to start on that? Well, maybe I'll just start by saying that we talked in the past about a fairly large investigate opportunity that we're 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. So I would expect in the next 90 days or so, that's going to be a fairly large deal. We're going to be really excited to talk about. It's a substantive deal in unleashes, we think, a very big opportunity for us to go, apply, investigate to other Department of Corrections once we bring this one across the line.
Alan Stewart: Yes. And this is Alan. I can only add one more thing, too. We've already seen, as we mentioned, Forensic Logic, it's going to be somewhat flat, adding about $6 million in '22. That's pretty much what they did. That said, as Ralph mentioned earlier, they've already got a multiyear 7-figure deal with another state that's already helping to add revenues in '23. We also just got another award for a second Forensic Logic contract, which is also significant, close to 7 figures as well some of the multiyear as well. So we see a lot going on in basically every aspect of our products and every product that we're selling.
Richard Baldry: Maybe to play off that then for my last question. Could you - thinking about the software group, just those new offerings that you have. Could you talk about how you feel about your - 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?
Ralph Clark: Yes. So 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 organization between ShotSpotter and then our Forensic Logic colleagues. So this year, we're going to 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're 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 control management solutions. So we're 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 products. And we're going to see some wins in 2023, that, frankly, are going to set us up for 2024 and beyond. We're not going to take 2023 for granted. But as you can see from Alan's commentary, we have a lot of visibility to get to our guidance. So 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 going to set us up pretty nicely for 2024.
Richard Baldry: And the last for me is just in terms of trying to normalize the earnings, the impact of taxes as a result of the changes to your earnouts that's a onetime impact, right? So for most people's purposes, they would look at that as a onetime event, not a long-term change to your tax structure?
Alan Stewart: Yes. This is Alan. That's correct. If there's any changes related to that, they would be small going forward.
Richard Baldry: Great. Thanks.
Operator: Our next question will come from Jeremy Hamblin with Craig-Hallum Capital Group. Please go ahead.
Jeremy Hamblin: Hi, guys. Congrats on the strong results. I 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 earnout from that. But can you just talk us through a little more detail in terms of thinking about where you might be tracking lower than you expected a year ago? Is that deal - 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?
Ralph Clark: Yes. So this is Ralph. I'll start and Alan jump in. I think what we're learning about Forensic Logic is that their buying center is a little bit different than our traditional buying center, whereas we've been very focused on, I'd say, local law enforcement, local policing agency, 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. So 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's another deal in the state of California. There's a state agency in California. They recently closed a deal on. That is a multiyear 7-figure deal. But from an ARR point of view, it's kind of in the think $250,000 to $350,000 per year range. So we're seeing those deals come along. And I think with those state oriented deals and even some federal opportunities we see in the pipeline is just those are much more, I would say, a long sale cycles than what we might find at the local level with local police departments, but they're much bigger too, much chunkier and bigger.
Jeremy Hamblin: And are the contract lengths also longer?
Ralph Clark: Well, they're about the same because what we're finding in our core business is we're getting multiyear contracts. I think I commented that about 37% of our transactions, both on new miles as well as renewals were multiyear. And multiyear, I think two, three as much as long as five years, we're getting a number of our transactions. So it's about the same, frankly. But I think that might be - you might have a different view because I think there's an assumption that we don't have the multiyear 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 multiyear contracts.
Jeremy Hamblin: 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?
Alan Stewart: Wow. This is Alan. I can say that last year, we talked about between 37% and 40% in multiyears, which is fantastic. I would say, maybe not pre-COVID, but certainly four or five years when we first went public, that would have been in the teens in terms of multiyear. So it significantly increased. And for several reasons, I mean it's no longer people are concerning does the technology work? They know it works. So even when new customers that used to sign up for one year, now they're signing up for 3- to 5-year contracts.
Jeremy Hamblin: Got it. No, that's helpful context. Just changing gears here, then I wanted to get a sense operationally speaking, looking at the gross margins, you noted that the sensor upgrades, that replacement cycle, that's taken some time. It sounds like you're either at the end of that or you fully completed it, but wanted to get a sense for what you think the benefit will be to your gross margin once that's done? And then 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%?
Alan Stewart: Yes. This is Alan, it's a great question. Yes, we did have - '22 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. So there was a little bit more cost in there and a little bit more cost per actual mileage going live, which increased the COGS, which lower the gross margin. We do believe that our gross margins are going to be 60% and 60-plus percent. And ultimately, we expect it's going to get closer to 70% or 70-plus percent over the next several years because the majority of - well, all of our projects right now, especially the three new ones, are all software of nature that are going to have gross margins closer to what you would see with the software product.
Jeremy Hamblin: And let me just clarify because that's a huge jump. So the time frame that you think you could be in the upper 60s you're close to 70% total company gross margins that's like four or five years?
Alan Stewart: Yes, you should think four years.
Jeremy Hamblin: And the 60% or 60%-plus you're talking about FY '23, correct?
Alan Stewart: We're expecting to get close to 60%, assuming - I mean, we are going live in more miles than we did in '22, as we mentioned. We are expecting that we're going to be able to cut back on some of the costs related to some of the miles. So that will directly affect us going up - we're like the 58% right now. So it's not going to be too hard to get us to 59% and probably 60%. So I would say you should expect us to get somewhere between 59% and 60% in '23.
Jeremy Hamblin: Great, thanks for taking all those questions, guys. Best wishes this year.
Alan Stewart: Thank you.
Operator: Our next question will come from Michael Latimore with Northland Capital Markets. Please go ahead.
Michael Latimore: Thanks. Great results for 2022 here. In terms of the miles that are either under contract or seem to be the 110 miles talked about, how does that statistic compare to prior February, like a year ago?
Alan Stewart: Yes. So this is Alan. I'll go ahead and start. I would say there's more sooner, and we'll be going live faster. So when you think about, when I said, adding $4.5 million of GAAP revenue for miles, when we built our guidance last year in '22, 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 a lot faster.
Michael Latimore: And the pipeline for the Respond gunshot detection, can you talk a little bit about other opportunities for new wins or expansions? How does that pipeline look and has it grown year-over-year?
Ralph Clark: Yes. So it continues to grow. It's probably the healthiest it's ever been, and there's a mix of Tier 1, Tier 2 and Tier 3 opportunities. And the thing that we're really excited about is the success we've seen in the Tier 4, Tier 5 market. As I think we mentioned on our call, 20% of the book miles came from Tier 4, Tier 5, and that was one salesperson across the entire United States. So one of the things that we're doing is quite intentionally expanding are kind of go-to-market resources there in terms of direct selling efforts. So our plan is to go from one sales rep to four sales reps and have them attached to each of the territory reps. We're already 50% there. We've got two now, and we're going to 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 that are kind of Tier 4, Tier 5. The sales cycles appear to be shorter than what we find in the higher-tier sales. Is this, I guess, easier for a Chief of Police along with the City Manager, Mayor and City Council to kind of come together really quickly and make a decision to move forward with the technology. I think it also helps and Mayors 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. So up and down the stack of money and budget is available for technology at large, and we're seeing a significant portion of those dollars being allocated toward gunshot detection because that's a specific potential solution to address violent crime, which is on the uptick across the board.
Michael Latimore: Interesting. Okay. Got it. And then did you give a kind of revenue churn assumption in your guidance in the past that I'd give you on that?
Alan Stewart: I'm sorry, I didn't hear the question.
Michael Latimore: Revenue, yes, revenue churn.
Alan Stewart: Yes. I think previously, you talked about a 1% churn, and we've always done better than that. I think the last couple of years, it's been for 2020, I think it might have been 0.25% or 0.5%. And then 2021, I think it was 0.25%. 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. And then there's a super small city of less kind of $50,000 of ARR that didn't renew. But we're able to execute fairly broad-based price increases across a number of customers that more than offset that attrition from those customers that decided not to renew - those three customers that decided not to renew.
Michael Latimore: And have you baked in the normal kind of 1% in the forecast for '23 or...
Alan Stewart: I think it's less than that. Yes. With the price increases that we get and what we know right now, we expect it to be certainly less than 1%, hopefully closer to zero again.
Michael Latimore: Got it. And then just last, what's the kind of appetite for additional acquisitions? And what kind of - if you're looking around what kind of value expectations are out there?
Alan Stewart: This is Alan, I'll start - go ahead, Ralph.
Ralph Clark: No, go ahead.
Alan Stewart: No, I was going to say that it's almost similar to what you were going to say. We have done acquisitions about one every two years. We're now fully past one year integrating the Forensic Logic acquisition. We're not the type of company that's going to acquire a company just to staple on revenues. It's got to be a much greater reason to do that. And - but we're also always looking for something that makes strategic importance to be able to do that. If we find something that makes sense to do that, we would absolutely consider that.
Michael Latimore: Okay. Great. Thanks very much.
Operator: Our next question will come from Matt Pfau with William Blair. Please go ahead.
Matt Pfau: Great. Thanks for taking my questions. I wanted to circle back to the delayed investigate 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, but I wanted to note, did that have any impact on revenue in the quarter relative to what you had included in your guidance?
Alan Stewart: Yes. So this is Alan. I'll start. And 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. So it effectively did lower some of the actual revenue that we got, now for a good reason, though, because originally, we thought that would be around $4 million to $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 a 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.
Matt Pfau: Understood. Got it. And then just last one for me, just on the campus opportunity. You called out you had a win there. Have you seen more interest in that segment, particularly with 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?
Ralph Clark: Yes, we continue to make steady progress on campuses. But I think we're probably a little bit more excited about the linear freeway opportunities, frankly. And we're 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 people are organizing themselves to try to attack those things through weapons discharges. So we've got a lot of stuff that we're working on in the security space that we're pretty excited about. And 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.
Alan Stewart: Yes, this is Alan. I would just add one comment. Just everything Ralph said in terms of importance and focus is true. We did add three 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.
Matt Pfau: Okay. And those - the highways, would those be through the state versus cities? And then what about the infrastructure, who's contracting for those deals?
Ralph Clark: Yes. So 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're having conversations about how we can organize ourselves to go take a run at that particular market. And those will be commercial enterprises, utility companies.
Matt Pfau: Thank you.
Operator: Our next question will come from Erik Suppiger with JMP Securities. Please go ahead.
Erik Suppiger: Yes. Thanks for taking the questions. In addition to the investigate, 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? And then you talked about gross margins expanding towards 70%. Can we still assume that you're anticipating EBITDA margins moving up into the 40% type range in kind of fiscal '27?
Alan Stewart: Yes. So this is Alan. I'll start and then Ralph, you can add, too. Certainly, we always have - there will be some delays in terms of renewals. If a quarterly delay happens, I mean it could be anywhere from a couple of hundred thousand dollars to even $0.5 million that gets caught up or picked up. We did get that in Q4. We now have those. There's other ones that if they're waiting for a December renewal, and we don't get it until January or February, that will shift to Q1. So 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 '23. And we still believe that the next 4-ish years will be at 40% to 45% adjusted EBITDA. There are several reasons for that. Number one, 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. So we're going to 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. So all of that flows and contributes towards that adjusted EBITDA continuing to grow.
Erik Suppiger: Okay. Then can you parse out the organic growth that you're expecting in '23 or at least parse out the inorganic contribution in fiscal '23?
Alan Stewart: Well, yes, this is Alan again. I would say, at this point, it's probably all organic since we've had everything more than a year. So from that perspective, the entire 17% expected growth in the $14-plus million is all going to be organic.
Erik Suppiger: Okay. Very good. Thank you.
Operator: 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 e-mailing SSTI@gatewayir.com. I'd now like to turn the call back over to Mr. Clark for his closing remarks.
Ralph Clark: Awesome. Great. And thank you, everyone, for joining the call. Great question. As you can tell, we're incredibly excited about 2023. We're 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. And so with that, thank you all very much, and looking forward to chatting with you over the next several days.
Operator: The conference has now concluded. Thank you very much for joining us on today's call. You may now disconnect your lines.