Greetings, and welcome to Tenable's quarter two of 2022 earnings conference call. At this time, all participants are in listen-only mode. A question- and- answer session will follow the formal presentation. If anyone should require assistance during the conference, please press star and then zero on your telephone keypad. As a reminder, this conference is being recorded. I will now turn the conference over to your host, Erin Karney, Senior Director, Investor Relations. Please go ahead.
Thank you, Operator, and thank you all for joining us on today's conference call to discuss Tenable's second quarter 2022 financial results. With me on the call today are Amit Yoran, our Chief Executive Officer, and Steve Vintz, our Chief Financial Officer. Prior to this call, we issued a press release announcing our financial results for the quarter. You can find the press release on the IR website at tenable.com.
Before we begin, let me remind you that we will make forward-looking statements during the course of this call, including statements relating to our guidance and expectations for the third quarter and full year 2022, growth and drivers in our business, changes in the threat landscape in the security industry and our competitive position in the market, growth in our customer demand for and adoption of our solutions, the potential benefits and financial impact of our acquisitions, including our recent acquisitions of Cymptom and Bit Discovery, planned innovation and new products and services, our expectations regarding long-term profitability and our ability to attract and retain employees and its impact on our business. These forward-looking statements involve risks and uncertainties, some of which are beyond our control, which could cause actual results to differ materially from those anticipated by these statements.
You should not rely upon forward-looking statements as a prediction of future events. Forward-looking statements represent our management's beliefs and assumptions only as of today and should not be considered representative of our views as of any subsequent date. We disclaim any obligation to update any forward-looking statements or outlook. For a further discussion of the material risks and other important factors that could affect our actual results, please refer to those contained in our most recent annual report on Form 10-K and subsequent reports that we file with the SEC, which are available on the SEC website at sec.gov. In addition, during today's call, we will discuss non-GAAP financial measures. These non-GAAP financial measures are in addition to and not a substitute for or superior to measures of financial performance prepared in accordance with GAAP.
There are a number of limitations related to the use of these non-GAAP financial measures versus their closest GAAP equivalent. Our earnings release that we issued today includes GAAP to non-GAAP reconciliations for these measures and is also available on the investor relations section of our website. I'll now turn the call over to Amit.
Thank you, Erin. Today, I'll discuss our strong financial performance in Q2, strong demand, and the continued progress of our Cyber Exposure Management platform. With that, let me first touch on our Q2 results. We delivered strong CCB growth for the quarter at 27%, which we achieved despite the macro environment. We believe cybersecurity, and specifically Cyber Exposure Management, remains a top strategic focus for organizations and will continue to be a spending priority. Against this backdrop, we are also very pleased to deliver compelling top and bottom-line results as EPS and unlevered free cash flow were both notably above expectations for the quarter. Our business navigated a number of ebbs and flows during the quarter that we believe are a direct result of the complicated environment our customers are operating in. We saw a few dynamics play out during the quarter.
North America delivered above expectations led by Tenable.ep platform sales. Conversely, international business in most regions did not grow as fast as we expected going into the quarter, which Steve will cover in more detail. As far as the business as a whole, deals are going through more scrutiny than they typically do. Overall demand remains strong, even with increased inspection on a customer-by-customer basis. Coming out of the quarter, there were a number of things that substantiated our conviction around our business, even in the short term. Security remains a key budget priority and a defensible spend for our customers. Customers continue to face an expanding attack surface and need to properly identify their exposure and their understanding of risk. EP is an incredibly efficient way to consume our product as customers look to a more comprehensive assessment of risk.
We have seen this with the strength in EP adoption and exposure solutions more broadly. A great example of this was a seven-figure EP competitive takeout deal with a large international financial institution. We had another strong quarter for both large six-figure deals and overall enterprise customer adds. We continue to see large deals entering and moving through our pipeline, and our confidence in the fundamentals of our business has never been stronger. Our ability to take advantage of this demand is a direct result of meaningful and critical investments we have made, organic and inorganic, to help our customers identify and manage their cyber exposure.
Continuing to enhance our platform, we closed the acquisition of Bit Discovery, a provider of External Attack Surface Management, enabling us to cover and assess internet-facing assets such as web applications, cloud resources, and open gateways. Following the closing of the acquisition, we delivered a new version of Nessus Expert, that includes external asset discovery. External asset discovery will be included at no additional cost for our enterprise platform customers. A separately sold context-aware External Attack Surface Management offering for continuous discovery and ongoing monitoring is also available today. Cyber Exposure Management as a discipline is attracting attention from industry analysts and customers alike. It is an incredibly important approach to managing cyber risk, and it is an approach that we've pioneered over the last several years.
We believe delivering on a successful Cyber Exposure Management platform requires a unified best-in-class approach across vulnerability management, cloud security, Active Directory security, OT security, and other parts of the attack surface, which we are successfully executing on. We believe our roots and laser focus position us incredibly well to be a market leader. As we continue to execute on our own vision, we're excited to see industry acknowledgment in the importance of this discipline. Continued coverage by Gartner talking about exposure management as a discipline amplifies this point. In particular, the importance of advancing Cyber Exposure Management program as critical to developing actionable posture improvement plans that can be understood by executives. As boards and executives are pressured to understand their cybersecurity posture, having a clear view of risk is increasingly critical.
Preventing cyberattacks requires full visibility into all assets and exposures, extensive context into potential security threats, and clear metrics to objectively measure cyber risk. Tenable Cyber Exposure Management platform delivers visibility across the modern attack surface with intelligent analytics to prioritize preventative actions and communicate risks to all levels of the organization. We are building the broadest understanding of cyber exposure, spanning IT assets, cloud resources, containers, web applications, and identity services. We're delivering unifying analytics, prioritized actions, and benchmarking to help our customers truly manage risk more effectively, and that's a compelling capability. I will now turn the call over to Steve for further commentary on our financial results.
Thanks, Amit. As Amit mentioned earlier, we are pleased with our results for the second quarter, highlighted by good top-line growth, a sizable beat in EPS, and strong unlevered free cash flow. There are a confluence of factors related to the broader market that impacted our results, but we are pleased with our execution in the quarter despite a more cautious spend environment. I will provide more commentary momentarily, but first, please note that all financial results we discuss today are non-GAAP financial measures, with the exception of revenue. As Erin mentioned at the start of this call, GAAP to non-GAAP reconciliations may be found in our earnings release issued earlier today, which is posted on our website. Now on to the results for our quarter.
Calculated current billings defined as the change in current deferred revenue plus revenue recognized in the quarter grew 27% year-over-year to $174.1 million, and benefited from our continued investment in our platform strategy and go-to-market efforts. The fundamentals of our business remain very strong, and we are pleased with the demand overall in the quarter. It was mixed across geographies as North America exceeded our expectations, while our international theaters encountered headwinds and fell short of expectations. As a reminder, we go to market using a two-tier channel model with our customer contracts denominated in U.S. dollars. During the quarter, the U.S. dollar strengthened compared to other currencies, which made our products more expensive, and that, combined with other macro considerations, impacted our international sales.
In addition, on a global basis, we experienced deeper levels of inspection and more approvals with some customers. Despite that, we are pleased with our CCB growth and had one of our best quarters in terms of adding new customers and transacting large deals. Specifically, we added 540 new enterprise platform customers and 79 net new six-figure customers in Q2, which represents 35% and 28% year-over-year growth, respectively. Underpinning our customer momentum is EP, Tenable.ep, which continues to see strong demand in both the large and mid-markets and has resulted in more meaningful deal sizes, amplified by the addition of cloud and identity security to our unified exposure platform.
Tenable.ep also creates a more compelling upsell path for our existing customers and benefited our dollar-based net expansion rate in the quarter, which remains elevated in comparison to prior years and is well above our 110% threshold. Revenue for the quarter was $164.3 million growth in Q2 last year. Revenue in the quarter exceeded the midpoint of our guided range by $1.3 million. As discussed earlier, we experienced less than expected international sales, which typically have a higher mix of standalone Active Directory on-premise deployments, which is our only software solution with upfront revenue recognition. Consequently, product mix limited our upside in revenue this quarter. That said, visibility remains high as our percentage of recurring revenue was 95%, which is consistent with prior periods.
I'll now turn to expenses, which include incremental investments in growth and the operating expenses related to the Bit Discovery acquisition that we closed in the quarter. I'll start with gross margin, which was 81% this quarter and essentially flat compared to last quarter. Despite increased usage of our cloud products, our public cloud costs decreased sequentially as a result of efforts to optimize the efficiency of our product delivery infrastructure, along with our procurement strategy, which resulted in credits in the quarter that reduced our compute costs. These savings were offset primarily by increased personnel costs for support of our products. In connection with the closing of Bit Discovery, we launched a new External Attack Surface Management offering in July that we will continue to integrate throughout our product portfolio.
Also, as a reminder, we plan to release a more expansive set of cyber exposure analytics in the second half of the year. This will include attack path analysis, enhance the unified analytics, and improve benchmarking and contextualization of vulnerabilities, all of which will help customers better visualize and efficiently manage risk across their hybrid environments. We expect the incremental investments for Bit Discovery and Cymptom, a portion of which are upfront costs, to modestly impact gross margins in the second half of the year, but provide runway to support future growth. As I've indicated in the past, long term, we still expect gross margins to be in the high 70 to low 80% range. Sales and marketing expense for the quarter was $75.6 million, which was up from $71.5 million last quarter.
Sales and marketing expense increased sequentially due to higher wages and benefits related to hiring more quota-carrying sales reps and associated headcount, as well as higher marketing spend related to industry and other events. Sales and marketing expense as a percentage of revenue was 46% in Q2 compared to 45% last quarter. R&D expense for the quarter was $28.1 million, which was virtually flat compared to $27.8 million last quarter. It should be noted that we added incremental engineering headcount in support of unifying our product architecture and enhancing our platform and capitalized $2.9 million of software development costs. R&D expense as a percent of revenue was 17% in Q2, which was consistent with last quarter. G&A expense was $17.3 million compared to $16.6 million last quarter.
We continue to make investments in our back-office functions and systems to support the growth and scale of our business. As a percentage of revenue, G&A expense was 11% this quarter compared to 10% last quarter. Income from operations was $12.2 million, essentially flat compared to last quarter, but $5.7 million better than the midpoint of our guided range, which had contemplated incremental COGS for our public cloud infrastructure, increased spend for industry events, and higher headcount and related costs. However, in response to the changing business climate, we were able to achieve greater operational efficiency through more focused efforts on spend optimization, which resulted in upside to op income in the quarter. It's also worth noting that a stronger U.S. dollar contributed approximately $1 million of outperformance, as approximately 40% of our employees are based outside of the U.S.
In short, we incurred less expense in our international locations due to a stronger dollar. Operating margin was 7% for Q2 compared to 8% last quarter. EPS in the second quarter was $0.05, which was $0.035 better than the midpoint of our guided range due to the same expense trends I just mentioned. EPS also includes $0.02 or $1.8 million of FX remeasurement losses included in other expense net. As a matter of clarity, this FX activity is due to the remeasurement of our non-U.S. dollar-denominated cash and other monetary assets and liabilities. The FX remeasurement losses more than offset the $1 million of OpEx savings from FX I previously discussed. Now let's turn to the balance sheet. We finished the quarter with $510.9 million in cash and short-term investments.
Accounts receivable was $109.4 million, and total deferred revenue was $548.1 million, including $415.4 million of current deferred revenue, which gives us a lot of visibility into revenue over the next 12 months. Now I would like to discuss cash flow. We paid $3.3 million of cash interest on our credit facility in the quarter. Looking ahead, we are assuming a higher interest rate environment with our floating rate debt facility when it resets at the end of July. Consequently, our full- year guidance reflects $17.9 million of interest expense, which is $2.2 million higher than our previously provided guidance. That said, our Term Loan B continues to provide a very low cost of capital, which has allowed us to fund acquisitions without equity dilution to our shareholders.
Earnings on our cash and investment balance provides a partial natural hedge to interest rate expense. As such, we expect the full- year EPS impact on interest expense net of interest income to be $0.01 as yields on our cash and investments also rise. We generated $29.1 million of unlevered free cash flow, which is an 18% margin. With 95% recurring revenue, high gross margins, and renewal rates, we feel confident that we can continue to generate attractive levels of cash flow while continuing to invest in the business. Striking the right balance between growth and profitability has always been and will continue to be an area of focus for us.
Last year, we became a Rule of 40 company, and we are confident we are well on our way to becoming a Rule of 50 company. With the results of the quarter behind us, I'd like to discuss our outlook for the third quarter and full year 2022. In terms of the top- line growth, our guidance reflects a continuation of the trends we experienced in the back half of the second quarter. Specifically, we expect the fundamentals of our business and the demand for our cyber exposure solutions to remain strong. However, given the current macro environment, we think it's prudent to expect a similar level of review and scrutiny on some deals that we experienced in Q2.
Our guidance also contemplates approximately $4 million-$5 million of less contribution from upfront AD on-prem revenue and higher levels of adoption of AD and Tenable.ep , our unified exposure platform. Now in terms of expenses, our outlook reflects the expected impact of inflationary costs, most notably on wages, the absorption of Bit Discovery, and higher interest expense on our floating rate debt. With that in mind, here are the specifics. For the third quarter, we currently expect revenue to be in the range of $169 million-$171 million. Non-GAAP income from operations to be in the range of $9 million-$10 million. Non-GAAP net income to be in the range of $3.2 million-$4.2 million, assuming interest expense of $5 million and a provision for income taxes of $2.3 million.
Non-GAAP diluted earnings per share to be in the range of $0.03-$0.04, assuming 119.5 million fully diluted weighted average shares outstanding. For the full year, we currently expect calculated current billings to be in the range of $768 million-$776 million, which reflects a $4 million increase from the midpoint of our prior guidance, including $2 million of the Q2 outperformance and $2 million of contribution from Bit Discovery, primarily in Q4. Revenue to be in the range of $673 million-$679 million, which remains unchanged.
Non-GAAP income from operations to be in the range of $45 million-$49 million, which is a $1 million increase from the midpoint of our prior guidance, reflecting a $6 million beat over the midpoint of our Q2 guidance, offset by $3 million of operating losses from Bit Discovery and $2 million of higher inflationary costs. Non-GAAP net income to be in the range of $19.7 million-$23.7 million, assuming interest expense of $17.9 million and a provision for income taxes of $7.6 million. Non-GAAP diluted earnings per share to be in the range of $0.17-$0.20, reflecting the $0.035 beat from the midpoint of our Q2 guidance, offset by approximately $0.03 related to Bit Discovery and $0.01 of higher net interest expense.
Our EPS guidance assumes 119 million fully diluted weighted average shares outstanding. In summary, we're very pleased with the results for the quarter, feel good about the fundamentals of our business, and believe we are thoughtfully navigating the current climate to deliver continued growth and profitability. I'll now turn the call back to Amit for some closing comments.
Thanks, Steve. We hope to see many of you at the Canaccord and Piper conferences in the coming weeks. We'd now like to open the call up for questions.
Thank you. Ladies and gentlemen, at this time, we will be conducting a question- and- answer session. If you would like to ask a question, please press star then one on your telephone keypad. A confirmation tone will indicate that your line is in the question queue. You may press star two if you would like to remove yourself from the question queue. For participants using speaker equipment, it may be necessary to pick up your handset before pressing the star keys. In the interest of time, we ask that you please limit yourselves to one question. You may rejoin the queue for additional questions if time allows. We will pause a moment. The first question comes from Hamza Fodderwala of Morgan Stanley.
Hey guys, good evening. Thank you for taking my question. Steve, for you, I just wanna be really specific. It seems like just the negatives in the quarter were international, sounds like Europe coming in slower than expected, the higher scrutinization of deals that was exclusively to Europe, and then FX basically making the products more expensive. Was there anything in North America or other regions that you saw that was driving that scrutinization as well, or was it just concentrated in Europe?
I would say, first of all, overall, we're pleased with our performance in the quarter. We grew CCB 27%, and as you know, we added a lot of new customers, 540 new enterprise platform customers. We transacted a bunch of large deals, so one of our best quarters in terms of momentum. As I called out earlier, performance was mixed. We saw significant strength in North America, which is our largest theater, but international fell short of expectations for some of the reasons that you mentioned. You know, generally, we are seeing more levels of scrutiny and review, but we were able to overcome this, because we saw strength in our enterprise business. We're just commenting on the current
Environment in terms of what we're seeing. By the way, I referred internationally broadly, but you know, it's more specifically in EMEA, which is what you had mentioned before. I will say this, that it's not pervasive across all countries, right? In our international theaters, and specifically in Europe, not across all countries. It's more on a customer- by- customer basis. It's based on specific company budget dynamics, industry, you know, geo, and we saw strength in major sectors, including in Europe. Obviously, overall, we're pleased with our results for the quarter. We're raising CCB guidance, you know, for the year, and we think we're set up for success for the second half of the year.
Just one quick follow-up on that. When it comes to international, are you increasing the level of discounting for your products? Is that something that's reflected in the back half guide?
No, we're not. We did not see that in the second quarter, levels of discounting increase. We're mindful of that as we enter the second half of the year, but, you know, we're spending a lot of time looking at pipelines. We feel really good about our pipelines as we head into the second half of the year, not just the size, but also the shape and maturity of it. Activity levels are high and, you know, we're looking at all forecast lenses, spending a lot of time qualifying opportunities. We feel good about the second half of the year and our setup.
Okay. Thank you.
The next question comes from Rob Owens of Piper Sandler.
Great. Thank you guys for taking my question. Maybe like Hamza, I'll sneak in one as well. Would love to better understand this, the higher levels of scrutinization, I guess, juxtapose what you're seeing with your enterprise customers in large deals, the success on that front. As we enter the third quarter, just any broad brushes around government. Thanks.
Yeah. Thanks. Great question. I'll chime in and I'll say, listen, it's just a tough macro environment. As a result, you know, many customers, and it's on a region by region basis, on a customer- by- customer basis. Many customers are looking at their spend, at their expense basis, and they're scrutinizing every contract, every opportunity. Security remains top of list. We are not seeing a high level of customers abandoning their position in pipeline. Deals continue to move forward in the pipeline. There's just additional signatures to get in the process that companies are putting in place on a customer- by- customer basis. Pipeline continues to build at a healthy rate, you know, has never been stronger than it is today.
Deals continue to move forward in the pipeline. We feel exceptionally confident in how we're set up going into the third quarter and going into the year. You asked specifically about public sector. You know, we had a good quarter in the public sector, I'd say kind of in line with expectations, including a seven-figure transaction at the state level. Globally, public sector did really well, and we continue to invest with a high degree of confidence in the public sector, you know, seeing strong opportunity in our pipe, seeing more transactions and seeing longer transactions than we've seen at any point in recent history. Again, we feel as well set up as we can going into the third quarter.
Thanks for the color.
The next question comes from Saket Kalia of Barclays.
Excellent. Hey, guys. Thanks for taking my question here. Steve, I'll keep it to one and maybe just for you. Can you just dig into the dynamic that you mentioned on AD a little bit, you know, for upfront revenue? I think you said it's about $4 million-$5 million less contribution this year. Can you just flesh that out a little bit? Is it on revenue? Is it on CCB? And why the change?
Yes. The $4 million-$5 million is on for AD on-prem, the second half of the year, specifically the second half of the year. We're taking the $4 million-$5 million out of our guidance. We're just seeing slightly different mix. You know, that said, we are very pleased overall with our ability to sell identity security as a standalone offering into our customer base. We've demonstrated success doing that, and now part of a broader offering in Tenable.ep.
You know, with regard to the latter, I think it's important to note, you know, we've integrated AD security into EP as well as cloud security, and we're actually seeing, you know, historically, we were seeing a 60% uplift in Tenable.ep, our unified exposure management platform, relative to our core VM offering, and we're now seeing a 70% uplift. So, we're having success transacting larger deals specifically because of EP. Certainly, AD is an important part of that, but our guidance reflects lower contribution due to, you know, less expected AD on-prem revenue.
Yeah. Saket, just to clarify, the AD on-prem revenue is all recognized upfront, so it has a disproportionate impact on the quarter and our expectations for the remainder of the year.
It is our only product that has upfront revenue recognition. All the other products are ratable.
Okay. Just to be clear, just to put a bow on this topic, it doesn't sound like all the CCB expectation for AD is going down in totality, just the mix of what is cloud versus on-prem. Is that right? Or are we-
Exactly.
Okay.
No, that is right. That's why you saw the outperformance in CCB. That's why we pass on ACV and we're also raising in CCB. We have not raised our outlook for revenue because we're reflecting less upfront revenue related to standalone AD on-prem.
Got it. Very helpful. Thanks for the clarification.
The next question comes from Mike Cikos of Needham & Co.
Hey, guys. Thanks for getting me on the line here. I just wanted to circle back to that increased scrutiny that you guys are seeing. Can you help us think through when that dynamic really started to come into play for the international markets, that increased scrutiny? Maybe it'd be helpful too to talk through how that trended through the quarter, through July. Like, as a result of the scrutiny, are those deals extending with more constituents sitting around the table? Has that deteriorated further as we've gone from May to June to July? Or have things been relatively stable when we start thinking through that scrutiny that you guys were talking to earlier?
Yeah. We saw that scrutiny really kick in in June, and things have been relatively consistent since then. Again, you know, the sales team has a lot of confidence. They continue to enter deals into the pipe. Deals continue to move through the pipeline. There's just more signatures to get in order to close transactions. I don't think it's specific to Tenable, and I don't think it's specific to, you know, security. I think largely speaking, we do not hear the sales team tell us that budgets are going away. We don't hear them telling us that deals are going away. It's just a matter of some transactions on a customer- by- customer basis require additional signatures. You know, as you note, in certain instances, that can prolong the sales cycle.
We feel exceptionally confident given the pipe and the progress through the pipe in second half of the year, and that's reflected in the increase in CCB.
That's very helpful. Thank you for that. If I could just squeeze one more in. When looking at the strength of the new enterprise platform customers added or even the customers over 100,000 in ACV at period end, you guys had some strong numbers when looking at those metrics. I just think it'd be helpful to frame out for the investment community here. Can you help us think through the segments that you guys are working through? If I think about like enterprise versus mid-market versus SMB, if I stratify your customer base according to those different parameters, starting to see a different behavior coming out of enterprise versus maybe mid-market. And maybe a reminder too, as far as your exposure to each of those different stratifications would be helpful as well. Thank you.
Yeah. As we commented earlier, we had one of our best quarters in terms of customer demand, in terms of new enterprise platform customers and large deals, so really strong. You know, if you kind of look disaggregate that, you know, we saw significant contribution from enterprise as well as commercial. Both are working well in aggregate globally for the company. You know, commercial, which we'll say is mid-market, is certainly an area of opportunity for us. You know, we're building out a commercial team in APAC, and you know, we're seeing outperformance there. Overall, we saw strength in both our large and mid-market, both you know, commercial as well as enterprise. Of course, exceptional strength in North America. As we commented earlier, EP is figuring prominently here.
We're transacting larger deal sizes, covering more areas of the attack surface, and we're getting, you know, now getting a 70% uplift relative to our core VM offering.
Thank you for the color.
Thank you. The next question comes from Brad Reback of Stifel.
Great. Thanks very much. Steve, with respect to the 2H guide, how should we think about what you've modeled in for international and domestic? I think you talked about international having pockets of weakness. Are you assuming that it's just those pockets going forward? Domestically, it's been very strong. Do you expect that strength to continue in the guide? Whatever type of moderation you've put in there would be great to highlight. Thanks.
Yeah. I think some, you know, of the trends that we saw in the second quarter we're expecting to play out for the second half of the year. I will say the secular trends of our business are very strong, and we're seeing healthy levels of demand. Now, North America was strong, and we expect it to continue to be the second half of the year. Our guidance reflects not only what we experienced in Q2, but what we also saw in July. We're taking everything into account. We have a lot of confidence in our ability to execute. It's really a continuation of trends.
Great. Thanks very much.
The next question comes from Brian Essex of Goldman Sachs.
Great. Thank you, and thank you for taking the question. Yeah, I was wondering if I could dig in a little bit on the sales side. You know, I mean, I think you guys last quarter talked about elevated hiring in the front half of the year. How did that pan out? Is there any way you can parse that out by geography and level of success, you know, attracting and retaining talent where you need it? Are we looking at, you know, maybe an elevated spend in the front half of the year with better leverage in the back half of the year? Or given the current macro situation, has any of that changed at all?
This is Steve, I'll start. Hiring is an area that we called out earlier, so we are continuing to hire and invest. Significant levels of hires in the first half of the year, specifically in Q2. We're adding quota capacity and obviously, you know, not just domestically, but also abroad. That's really important. Coming into the year, you know, we increased quotas. Productivity levels continue to be healthy globally. My expectation the second half of the year is that you'll see a leverage in the business, and our guidance reflects that. Overall, we think we're striking the right balance between growth and investment. We do not wanna moderate the level of investment, right?
Just given what we're seeing, outperformance in CCB and sales. You know, while performance may have been mixed globally across the board, across various theaters, we have a lot of confidence in our business, and we expect to continue success the second half of the year. Yes, we're still continuing to lean in and invest both on the sales side as well as engineering.
Great. That's super helpful. I'm gonna keep it to that one question. Thank you.
The next question comes from Jonathan Ho of William Blair.
Hi, good afternoon. Can you maybe help us understand or quantify the FX impact and international underperformance on the business this quarter, and maybe what your assumptions are around guidance on the magnitude of that impact going forward?
Sure. I think Jonathan's question's around FX. I'll start, and feel free to interject. As a reminder, our customer contracts are denominated in U.S. dollars. In terms of operating expenses, there was a $1 million benefit sequentially from the stronger dollar impacting expenses in local currency. Impact was primarily due to fluctuations in the euro, and we'll say the British pound. Further, the remeasurement of cash and other monetary balances in local currency, that means outside of the U.S., resulted in a $1.8 million loss, which is reflected in other income, so below the line. Average rate in Q2 was like 1.07 for the euro and 1.26 for the pound. We're expecting something similar for, you know, the second half of the year.
Yeah, I guess the only thing I would add to that is, you know, broadly speaking, strong demand including in international markets, and that's reflected in the, you know, increase in CCB and confidence in the business that you're hearing on the call. The primary discrepancy is probably the recognition of AD on-prem revenue, and so for that reason, not raising the revenue guide for the year. You know, more broadly speaking, feel really good about the business, the rate of growth, the deals entering the pipeline, and our ability to continue to move deals through the pipeline and increase CCB guide as a result.
Got it. Thank you.
The next question comes from Gray Powell of BTIG.
Great. Thanks for taking the question. I guess before I ask it, I wanna say thanks for the transparency, just on the headwinds that you're seeing in the international business. I'm not sure how everybody, you know, other companies would deal with that. You may have said this before, but just roughly speaking, can you help us think through how much the softness on the international side impacted billings in Q2? Like, was it a small miss? Was it a big miss? Just any sort of order of magnitude would be really helpful there.
I think it's fair to say that we would've seen a couple points of additional growth in the second quarter. Order of magnitude, we're not talking about something that's sizable. We're talking about something that's just different than what we've experienced in prior quarters. That's why we're calling it out.
Okay.
And of course-
Got it.
Since they have a procurement bias towards upfront revenue, you know, it did have an impact on revenue. That's why we're providing the transparency.
Got it. A couple of additional points of growth on Q2 total billings, had it not been for international. Just make sure I got that correct.
Yeah, I think that's a fair characterization. Yes.
Awesome. All right. Thank you very much.
The next question comes from Joshua Tilton of Wolfe Research.
Hey, guys. Thanks for taking my question. Assuming that you had some deals slip in EMEA this quarter, have you been able to close them since the quarter closed?
Yes, we have closed some of those. You know, obviously, it's very early in the quarter, and that's one of the reasons why we feel really good about our guidance for the second half of the year and why we're providing, you know, passing through the beat and also increasing. We also know there's more deals to close, right? Our pipeline, we talked about the quality, the shape, and the size of the pipe. There are a lot of large deals as we head into the third quarter. You know, we're gonna continue to focus on moving these deals through the pipeline and closing deals and obviously, you know, we think, we're set up well for success.
Just to maybe sneak one more in there. You said it's not or you don't think it's specific to Tenable, but I kinda wanna ask the question a different way. From your conversations with customers, does it sound like it's a VM issue, or is it just a broader scrutiny issue?
No, I think it's just a broader scrutiny issue. It's again, I don't think it has anything to do with VM. I don't think it has anything to do with security. Customers are, you know, changing their procurement processes as they look at their
Operating expenses. You know, I sat with a number of CSOs over the last couple of weeks and, you know, the security budgets are not changing, but procurement processes require additional hoops and jumping, and that just has added, in certain instances, a number of delays to transactions that are in process. We don't think it's specific to VM. We don't think it's specific to security, and I don't want to say we're impervious to it, but, you know, I think, to a large extent, it's just deal process, not so much change in budget.
Thank you very much.
The next question comes from Rudy Kessinger of D.A. Davidson.
Hey, guys. Thanks for taking my question. I guess I'm curious, you know, if you look at the increased level of scrutiny, obviously North America outperformed relative to EMEA in the quarter. You know, is the increased level of scrutiny kind of similar across geographies and just more deals are getting pushed across the finish line in North America or just what's the dynamic there? And then secondly, if you look at the new deals in the quarter, did you have maybe some customers that at the start of the quarter were considering maybe going with EP and then maybe they downsized their deal to maybe just going with IO? I'm curious if you saw any of that as well.
No, we certainly haven't seen that. EP continues to do very well for us. It's, you know, double-digit percentage of new sales. It's higher this quarter than it was last quarter. Penetration back into our customer base has been strong, but it's still modest in terms of the opportunity, single digit penetration. We're getting even more of an uplift. So absolutely not on the EP side. You broke up a little bit the first part of your question.
In terms of North America.
Again, we
No, go ahead.
I would just say, you know, with regard to deals, I think it really varies. Now, clearly, North America exceeded our expectations, and there's just really strong momentum there. I think just generally speaking, though, there are more levels of review across the board. Now, the good news is we were able to overcome that. You know, what we don't want to lose sight of is really the bigger picture here, which is we had a great outcome for CCB. We grew 27%. Customer momentum has never been better. It's one of our best quarters for closing deals, new enterprise customers, one of our best quarters for closing large deals. We're getting uplift from EP. So a lot of areas of our business continue to be very, very strong.
We're providing just additional color commentary on how performance varied across the board because it did have an impact on revenue. I wanna make sure we don't lose sight. We have a lot of confidence in our business, and hopefully, our guidance today reflects that. We're just providing additional color commentary for because we think it's necessary.
Thank you. The next question comes from Mike Walkley of Canaccord Genuity.
Great. Thanks for taking my question. Yeah, just to follow up to that with the EP on it, single-digit penetration, how should we think about the dollar-based net retention? Should it remain above your 110% threshold for quite some time? Are you seeing any kind of slowdown in terms of larger deal momentum with the increased scrutiny?
Let me chime in here, but in terms of the metrics itself, which is our dollar-based expansion rate, it's very healthy, well above the 110% threshold. As we commented earlier, it's elevated. EP certainly playing a big part of that because we're having success selling it back into the base as well as other products too. Absolutely healthy in terms of the expansion within the customer base.
Yeah. The only thing I would add to EP is, you know, as Steve noted, this 70% higher ASPs. The differentiation in ASPs as customers move to EP is actually increasing, which is a phenomenal sign and healthy signal. The comment about so it's a double-digit percentage of new customer growth. I think Steve's comment that it's a single-digit percentage of our existing customers that are on EP. When you look at the size of the ASP increase and our ability and success that we're showing going back into the base and upselling them to EP, it just speaks to the opportunity for net dollar expansion rate moving from individual products to EP as well as asset expansion.
Great. That's helpful. Thank you.
The next question comes from Andrew Nowinski of Wells Fargo.
Okay. Thank you for squeezing me in. I don't think you guys mentioned Log4j in the prepared remarks this quarter. I know last quarter you talked about it potentially only having an impact in Q1, but you know, then a few weeks ago, I think DHS put out a report that said Log4j would remain a risk to organizations for the next decade. Do you think it may have pulled in any deals into Q1? What impact did it have in Q2? How are you thinking about it as it relates to your pipeline going forward? Thanks.
Yeah. I think there was, you know, there's no doubt we saw some tailwind from Log4j, you know, top of mind for customers and prospects at the end of Q4 and going into Q1. Log4j will be with us for years to come. I think over time, folks will be and are integrating Log4j activities into the more standard operating pace and procedures and less of a, hey, there's an emergency spend. We really need to get visibility around this particular key issue. You know, again, it's not to say that some issue might not raise its head in the current or next quarter that would cause a similar buying behavior. It. You know, we don't.
I think it's fair to say it means vulnerability management is strategic and will continue to be, but I don't think there's the type of urgency around Log4j procurement that we saw late last year and beginning of this year.
Got it. Thanks.
The next question comes from Shebly Seyrafi of FBN Securities.
Yes. Thank you very much. Do you expect your federal and public segment business to outgrow your overall business by a larger margin in this current fiscal Q3 than, say, last year's fiscal Q3 because of the funding? And just can you provide us with an update on roughly what your current federal and public percentage of revenue is? Thank you.
It's approximately 15% of our total sales, and that's public sector as a whole. Going into Q3, you know, we think our pipelines are strong. There's a lot of opportunity, so we feel good about public sector. As Amit commented earlier, we saw areas of strength globally within public sector and specifically at the state and local level. That's been an area of investment for us. In our guidance, we didn't really break out, you know, growth rates by theater and what we're expecting. But I will say, you know, we're expecting certainly a sequential uptick in sales or CCB from our public sector theater.
Thank you.
Thank you. Ladies and gentlemen, we have reached the end of our question- and- answer session. This concludes today's conference. Thank you for your participation, and you may now disconnect your lines.