Good day, ladies and gentlemen, and welcome to Red Violet's Second Quarter 2021 Earnings Conference Call. At this time, all participants are in a listen only mode. Later, we will conduct a question and answer session and instructions will follow at that time. As a reminder, this call is being recorded. I would now like to introduce your host for today's conference, Camilo Ramirez, Director of Finance and Investor Relations.
Please go
ahead. Good afternoon, and welcome. Thank you for joining us today to discuss our Q2 2021 financial results. With me today is Eric Dutner, our Chairman and Chief Executive Officer and Dan McLaughlin, our Chief Financial Officer. Our call today will begin with comments from Derek and Dan, followed by a question and answer session.
I would like to remind you that this call is
being webcast live and recorded. A replay of the event will be available following the call on our website. To access the webcast, please visit our Investors page on our website, www.redviolet.com. Before we begin,
I would like to advise listeners
that certain information discussed by management During this conference call are forward looking statements covered under the Safe Harbor provisions of the Private Securities Litigation Reform Act of 19 95. Actual results could differ materially from those stated or implied by our forward looking statements due to risks and uncertainties associated with the company's business. The company undertakes no obligation to update the information provided on this call. For a discussion of risks and uncertainties associated with Red Violet's business, I encourage you to review the company's filings with the Securities and Exchange Commission, including the most recent annual report on Form 10 ks and subsequent 10 Qs. During the call, we may present certain non GAAP financial information relating to adjusted gross profit, adjusted gross margin, adjusted EBITDA margin and adjusted EBITDA.
Reconciliations of these non GAAP financial measures to their most directly comparable GAAP financial measure are provided in the earnings press release issued earlier today. In addition, certain supplemental metrics that are not necessarily derived from any underlying financial statement amounts may be discussed and these metrics and their definitions can also be found in the earnings press release issued earlier today. With that, I am pleased to introduce Red Violet's Chairman and Chief Executive Officer, Derek Dubnick. Thanks, Camilo. Good afternoon to those joining us today to discuss the results of our Q2 2021.
We are pleased to report yet another terrific quarter, delivering our highest quarterly revenue in our history and breaking our previous record achieved last Quarter. With improving economic conditions, we experienced continued increased demand for our innovative solutions, Driven by our cloud native platform, differentiated data assets and analytic capabilities. Thank you to our dedicated team who seized upon these opportunities moving up and across customer markets And to all members across the organization for their hard work and dedication in support of these results. Of particular importance, we have a strong balance sheet and cash generation, which as I will discuss in a bit, is enabling us to invest in the business to further expand our capabilities and seize upon opportunities. Now to our quarterly results.
We generated record revenue of $10,900,000 A 54% increase over the Q2 of last year. Platform revenue increased 54% to $10,600,000 Services revenue increased 46 percent to $300,000 Adjusted gross profit increased 83 percent to $8,200,000 and adjusted gross margin increased to 75% from 63% compared to the same period of 2020. Adjusted EBITDA increased 2.45 percent to a record $3,100,000 We set another new record for contractual revenue at 81%. We generated $2,300,000 in cash From operating activities in the Q2 and as of June 30, 2021, we had $13,900,000 in cash and cash equivalents on our balance sheet. We added 239 new IDI customers During the Q2, ending the quarter with 6,141 customers.
ForWearn added over 8,700 users, ending the quarter with 67,578 users. Over 150 Realtor Associations throughout the U. S. Are now contracted to use for war. I would like to switch gears to cite 2 examples, which highlight the strides we have made in various industries Due to the utility of our innovative technology and solutions in solving for various complex problems faced by target markets.
We have said often that organizations are struggling to glean real time actionable insights From increasing volumes of disparate, structured and unstructured data, we are solving this problem. For example, a leading identity verification services provider needed a solution with extensive U. S. Consumer coverage, including traditional and non traditional consumer identities and meaningful insights that could be delivered in real time to reduce friction in customer onboarding and payment transactions, while ensuring fraud capture. We provided a solution and won their business in early 2020 due to the combination of our cloud native platform and comprehensive unified data assets.
Since then, we have forged and expanded additional relationships like this one are highly focused on our penetration in this market. Another example, A leading property technology company that provides powerful tools to its customers using comprehensive real estate data Sought an information solutions provider to not only augment its property coverage, but more importantly, to Resolve information back to households and even consumers, creating tools for their customers that provide predictive insights. This PropTech leader leveraged our consumer identity graph and flexible platform driven API To improve their solutions and outcomes, a customer since 2018, their volumes with us have grown significantly since integrating our solutions. These examples illustrate the opportunities before us In high growth and disparate markets, our solid cash generation is enabling us to execute our long term strategy of the expansion of our capabilities, which further bolsters our value proposition. We continue to enhance our technology, thus widening the moat between us and competitive technologies.
We continue to apply analytic processes for better outcomes, resulting in more customer centric solutions. In our quest to be all things identity, We see significant opportunities to augment current relationships and to enter new relationships across the identity verification space. In furtherance of that objective, we were excited to appoint Jim Greenwell as General Manager of Identity to lead our efforts. Jim has extensive knowledge and experience in identity with a view informed by not only prior C suite positions, Including CEO of Denal through its sale to Boku, but also as an advisor to prominent companies in the industry, including Thomson Reuters. We welcome Jim to the team.
Throughout the last year, with a customer centric view, We have engaged with some of the largest players in commercial and residential real estate to understand their data driven challenges. We have identified blind spots, if you will, in their ability to convert data into intelligence. And we are strategically working with these parties to develop solutions that not only address their own issues, But perhaps those of the real estate sector at large. In light of our endeavors, We are pleased to bring James Frechet on board as EVP, Property Solutions. James brings deep property centric analytics, Product and business development knowledge and experience to the company.
James has held key positions at various industry leading Property data and analytics companies, including serving as Chief Client Officer at Equifax. We are excited to have James as part of the team. Lastly, we appointed a new Director to our Board of Directors. We welcome Lisa Stanton to the Board. Lisa has a significant background in financial services, FinTech, Identity and Security, serving in various capacities at companies including Washington Trust Bancorp, Trulio, American Express, INOTH and Citizens Financial.
Lisa's strategic input will be a valuable asset to the Board and the company in our pursuit of all things identity. As we continue to demonstrate each quarter, our business is strong across the enterprise. We continue to evolve our cloud native platform, Differentiated data assets and analytic capabilities, all with a view towards our long term strategic vision for the company. We not only set records in key financial metrics this quarter, but this is the healthiest and most well positioned the company has been in its history. I will now turn it over to Dan to discuss the financials.
Thank you, Derek, and good afternoon. It was another great quarter for the company, again hitting records in nearly every key financial metric. As Derek mentioned, With improving economic conditions, we continue to see increasing demand for our solutions. We are pleased with our new customer growth And strong growth revenue from existing customers. Contractual revenue continues to trend nicely and revenue attrition returned to its pre COVID norms.
Across the board, the business is performing well. So let's dive into the 2nd quarter results. For clarity, All the comparisons I will discuss today will be against the Q2 of 2020, unless noted otherwise. Total revenue was $10,900,000 a 54% increase over prior year and our highest quarterly revenue ever. Platform revenue increased 54 percent to a record $10,600,000 Services revenue was up $100,000 or 46 percent to $300,000 Our services revenue continues to be impacted by COVID related government imposed Our adjusted gross margin was the highest it has ever been at 75%, up 12 percentage points, Which translated nicely into a record $3,100,000 in adjusted EBITDA, up 2 45% over prior year.
Our adjusted EBITDA margin was 29% for the quarter compared to 13% in prior year. Continuing through the details of our P and L, as mentioned, revenue was $10,900,000 for the 2nd quarter, Consisting of revenue from new customers of $900,000 base revenue from existing customers of $8,400,000 And growth revenue from existing customers of $1,600,000 Our IDI core billable customer base Grew by 239 customers sequentially from the Q1, ending the 2nd quarter at 6,141 customers. ForWarn added over 8,700 users during the Q2. Our contractual revenue was 81% For the quarter, a 2 percentage point increase over prior year and our highest quarterly contractual revenue ever. Our revenue attrition percentage was 6% compared to 11% in prior year.
Revenue attrition percentage calculated on a trailing 12 month basis and has continued to trend nicely over the last several quarters as the lingering to trend between 5% 10% on a normalized basis. Moving on from our revenue metrics and down the P and L, Our cost of revenue, exclusive of depreciation and amortization, increased $100,000 or 5 percent to $2,700,000 This $100,000 increase was a result of an increase in data acquisition costs. Adjusted gross profit increased 83% to a record $8,200,000 producing an adjusted gross margin of 75%, a 12 percentage point Increase over Q2 2020 and our highest adjusted gross margin ever. Sales and marketing General and administrative expenses increased $600,000 or 15 percent to $4,900,000 for the quarter. The increase was primarily the result of $8,600,000 increase in payroll and benefits.
The $4,900,000 in general and administrative expenses for the quarter consisted primarily of non cash share based compensation expense, dollars 1,600,000 of employee salaries and benefits and $700,000 in accounting, IT and other professional fees. Depreciation and amortization increased $300,000 or 34 percent to $1,300,000 for the quarter. This increase was primarily the result of the amortization of internally developed software. During the quarter, our CARES Act loan was fully forgiven. We reported a one time gain of $2,200,000 on the compared to a loss of $2,500,000 in prior year.
Excluding the one time gain of $2,200,000 We would have reported a net loss of $400,000 for the Q2 2021. This net loss of $400,000 excluding the one time gain would still represent our best quarter ever. We reported earnings of $0.14 per share basic and $0.13 per share diluted based on a weighted average share count of 12,300,000 shares and 13,600,000 shares respectively. Moving on to the balance sheet. Cash and cash equivalents were $13,900,000 at June 30, 2021, compared to $13,000,000 at December 31, 2020.
Current assets were $18,600,000 compared to $16,700,000 and current liabilities were $3,200,000 compared to $5,000,000 We generated $3,500,000 in cash from operating activities for the 6 months ending June 30, 2021, compared to generating $3,000,000 in cash from operating activities for the same period in 2020. Based on our operational earn burn analysis, we earned $1,900,000 in cash during the Q2 2021 compared to burning $700,000 for the Q2 2020. Internally, we track our operational earn versus burn on a monthly basis by calculating adjusted EBITDA and subtracting the cash we use for the development of internal use software and other capital expenses, which can be found on the statement of cash flows. Cash used in investing activities was $2,600,000 for the 6 months ended June 30, 2021, mainly the result of $2,400,000 used for software developed There were no financing activities during the period. In closing, We had another great quarter across the board.
We continue to see sequential improvement in the business across all our key financial metrics. Throughout the organization, our teams continue to deliver as we harden our current resources and expand our breadth and knowledge with the onboarding Key industry professionals. We see strong secular tailwinds and are extremely excited about our positioning within the broader identity space. With that, our operator will now open the line for Q and A.
Please wait till the caller's queue for their questions. Your first question comes from the line of Pamela Carter from Carter Management. Your line is open.
Hi. First, congratulations on the quarter. Very impressive.
Thank you.
So speaking to that, since you continue your ability to drive gross margin, your continued ability to drive gross margin has been impressive. Today you're at 75%, but what I'm wondering is can you really drive the margin materially higher from where it is today? What does your adjusted gross margin look like a year or 2 from now?
Hi, Pamela, and thanks. This is Dan. Thank you for the question. So The short answer is yes. We can continue to drive adjusted gross margin materially higher from here.
The great thing about the business model and where we're at today, Because our cost of revenue is relatively fixed, each incremental dollar of growth provides nearly 100% contribution. So As many of our shareholders know, we have previously created 2 companies in this space, which we sold to global information technology providers. And We know those 2 companies, due to their maturity, are generating gross margins in excess of 90%. So for us, when we talk about a year or 2 from now, We're going to be trending and approaching that 90% number. So we're really excited about being able to leverage the business at this point.
Wonderful. Okay. Very helpful. Thank you.
Thank you.
There are no further questions at this time. I would now like to turn the conference back to Mr. Derek Dubner.
Thank you again for joining us today. We posted a very strong second quarter and first half of the year and we feel great about our positioning going forward. We are making aggressive moves in executing upon our strategy in order to continue disruption of the status quo in the marketplace. Our customers are realizing the benefits of our competitive advantages in technology, data assets and analytics. The health of our business has never been stronger and we are very optimistic about our future.
Good afternoon.