ETSY Inc
NASDAQ:ETSY
US |
Fubotv Inc
NYSE:FUBO
|
Media
|
|
US |
Bank of America Corp
NYSE:BAC
|
Banking
|
|
US |
Palantir Technologies Inc
NYSE:PLTR
|
Technology
|
|
US |
C
|
C3.ai Inc
NYSE:AI
|
Technology
|
US |
Uber Technologies Inc
NYSE:UBER
|
Road & Rail
|
|
CN |
NIO Inc
NYSE:NIO
|
Automobiles
|
|
US |
Fluor Corp
NYSE:FLR
|
Construction
|
|
US |
Jacobs Engineering Group Inc
NYSE:J
|
Professional Services
|
|
US |
TopBuild Corp
NYSE:BLD
|
Consumer products
|
|
US |
Abbott Laboratories
NYSE:ABT
|
Health Care
|
|
US |
Chevron Corp
NYSE:CVX
|
Energy
|
|
US |
Occidental Petroleum Corp
NYSE:OXY
|
Energy
|
|
US |
Matrix Service Co
NASDAQ:MTRX
|
Construction
|
|
US |
Automatic Data Processing Inc
NASDAQ:ADP
|
Technology
|
|
US |
Qualcomm Inc
NASDAQ:QCOM
|
Semiconductors
|
|
US |
Ambarella Inc
NASDAQ:AMBA
|
Semiconductors
|
Utilize notes to systematically review your investment decisions. By reflecting on past outcomes, you can discern effective strategies and identify those that underperformed. This continuous feedback loop enables you to adapt and refine your approach, optimizing for future success.
Each note serves as a learning point, offering insights into your decision-making processes. Over time, you'll accumulate a personalized database of knowledge, enhancing your ability to make informed decisions quickly and effectively.
With a comprehensive record of your investment history at your fingertips, you can compare current opportunities against past experiences. This not only bolsters your confidence but also ensures that each decision is grounded in a well-documented rationale.
Do you really want to delete this note?
This action cannot be undone.
52 Week Range |
47.48
87.03
|
Price Target |
|
We'll email you a reminder when the closing price reaches USD.
Choose the stock you wish to monitor with a price alert.
Fubotv Inc
NYSE:FUBO
|
US | |
Bank of America Corp
NYSE:BAC
|
US | |
Palantir Technologies Inc
NYSE:PLTR
|
US | |
C
|
C3.ai Inc
NYSE:AI
|
US |
Uber Technologies Inc
NYSE:UBER
|
US | |
NIO Inc
NYSE:NIO
|
CN | |
Fluor Corp
NYSE:FLR
|
US | |
Jacobs Engineering Group Inc
NYSE:J
|
US | |
TopBuild Corp
NYSE:BLD
|
US | |
Abbott Laboratories
NYSE:ABT
|
US | |
Chevron Corp
NYSE:CVX
|
US | |
Occidental Petroleum Corp
NYSE:OXY
|
US | |
Matrix Service Co
NASDAQ:MTRX
|
US | |
Automatic Data Processing Inc
NASDAQ:ADP
|
US | |
Qualcomm Inc
NASDAQ:QCOM
|
US | |
Ambarella Inc
NASDAQ:AMBA
|
US |
This alert will be permanently deleted.
Hi, everyone, and welcome to Etsy's Second Quarter 2023 Earnings Conference Call. I'm Deb Wasser, VP of Investor Relations. And joining me today are Josh Silverman, Chief Executive Officer, Rachel Blazer, our Chief Financial Officer, and Jessica Schmidt, Senior Director of Investor Relations.
Today's prepared remarks have been prerecorded. This slide deck has also been posted to our website for your reference. Once we are finished with Josh and Rachel's presentations, we will transition to a live video webcast Q&A session. Questions can be submitted via the Q&A window chat displayed on your screen. Feel free to use it at any time as it will remain open throughout the entire conference call. I'll be reading your questions, and Jessica will help me try to get to as many as we can.
Forward-looking statements involve risks and uncertainties and some of which are described in today's earnings release and our most recent Form 10-Q, and which will be updated in future periodic reports that we file with the SEC. Any forward-looking statements that we make on this call are based on our beliefs and assumptions today, and we disclaim any obligation to update them.
Also during the call, we'll present both GAAP measures and non-GAAP financial measures, which are reconciled to GAAP financial measures when available in the appendix to today's slide deck posted on our IR website, along with a replay of this call.
With that, I'll turn it over to Josh.
Thanks, Deb, and good afternoon, everyone. Etsy's results landed in line with our expectations. Consolidated GMS was $3 billion about flat to last year, revenue grew 7.5% to $629 million and our adjusted EBITDA margin was again strong and 26.4%. GMS for the Etsy marketplace was about $2.6 billion this past quarter, about flat with the prior year.
Digging deeper, we've seen many of our key metrics trending positively again. Our negative year-over-year growth rate improved sequentially, and even more important GMS grew year-over-year in May June and in July as well. Quarterly active buyers reached 91 million an all-time high and when adding new and reactivated buyers together, we saw healthy growth in buyer additions on a year-over-year basis.
Additional green shoots included GMS growth outside of the U.S., improvement in trends in important category and early signs of stabilization in our GMS per buyer and habitual buyer metrics. Overall, this performance is quite encouraging especially given the tremendous gains we've maintained from our pandemic growth and the stiff headwinds we've continued to face in consumer discretionary spending. Economic cycles are just that cyclical. The Etsy brand stands for something different in a sea of sameness and I believe we've proven our resiliency. I'm confident that we're well set up for future growth as we continue to move through this cycle.
On our last call, we explained that Etsy's 2023 product roadmap is focused on welcoming new buyers to the joy of Etsy, elevating the best of Etsy to keep buyers coming back, instilling trust when transacting with us and being the platform sellers love to sell on. As we progress through the year, we continue to prioritize our investments to ensure that we're funding the biggest, boldest, and most impactful initiatives on our roadmap to make our marketplace even more organized, curated, and reliable.
Regardless of whether you're new to the Etsy experience, or habitual buyer, we know we have so much more opportunity to gain your mind and wallet share. We’ve made so much progress improving the relevant of our search results, our ability to find what you meant compared to what you searched for. We've explained some examples of these search technologies in prior calls, which are featured in this slide. The next frontier is to better identify the quality of each listing, so that from this relevant result set, we bring the very best of Etsy to the top. Our data shows that high quality listings attract a higher value buyer than our average listings, attract more repeat and habitual buyers, and most importantly, they often convert over 2 times better than other listings. We have a lot of opportunity here, and I couldn't be more excited about some of the progress we're already making, starting with our work in organization and curation.
With over 115 million items for sale on Etsy, and our average search result yielding well over a 1,000 listings This incredible abundance continues to not only be one of Etsy's greatest strengths, but also one of our greatest challenges and where we have so much potential. Our product teams are helping buyers more easily navigate the breadth and depth of our sellers' inventory leveraging the latest AI advances to improve our discovery and inspiration experiences, while surfacing the very best of Etsy. These latest technologies, combined with training and guidance from our own talented team is making the superhuman possible in terms of organizing and curating it scale, which I believe can unlock an enormous amount of growth in the years to come.
One great example, over the past quarter, we've more than doubled the size of our best of Etsy library, which is curated by expert merchandisers based on the visual appeal, uniqueness, and apparent craftsmanship of an item. We're now using this library to train our ML models to better predict of quality of items as perceived by humans. We're seeing encouraging results from first iterations on these models and I’m optimistic that this work will have a material impact helping us to surface the best of Etsy in every search.
Finding the good stuff also comes to light in two other second quarter product launches, as does our focus on highlighting home and living, style and gifting purchase occasions. First, we launched a curated Shop the Look in home and living on our home page, which drove higher conversion rate. Second, buyer participation in our new Etsy wedding registry showed strong and steady growth from the May launch through the end of June, not only has this initiative driven buzz for Etsy through earned and social media, about 14% of registry GMS has come from new buyers and we're seeing higher than average order value from items purchased. Since the success of that launch, we've fast tracked our expansion to more categories including a baby registry, which will be live this month.
In addition to solving for a buyer's tastes and preferences, we're also working on several compelling initiatives to better highlight specific Etsy seller merchandise, which fits an individual buyer's budget. We're starting to elevate great deals on Etsy, such as through prominent on-site promotional merchandising on our homepage. And we're developing a new feature on the Etsy app, which will help buyers find deals for items in which they've already shown an interest. There's no question this is a very promotional environment. So our team is pulling out all the stops to help Etsy sellers compete and win.
Etsy's been on a journey to make shopping and selling in our marketplace more joyful and more reliable than ever before. We're doing this by focusing on quality, doubling down on enforcement and up leveling customer support. Specific to our trust and safety work, advances in ML capabilities have enabled our enforcement models to detect an increasing number of policy violations, which combined with human knowhow is starting to have a meaningful impact on the buyer and seller experience.
Since Etsy purchase protection was launched about a year ago, we've reduced the issue resolution time for cases by approximately 85%, dramatically streamlining the service experience on the rare occasion that something goes wrong. Demonstrating to buyers and sellers that we have their backs in these key moments. The opportunity now is to ensure that more of our customers know about this, which is why you'll see us embed even more purchase protection messaging and customer touch points. We've got a lot of conviction that we can increase both frequency and AOV as we build consumer confidence in Etsy.
We're always focused on helping our sellers grow and thrive. Towards this end, we're investing in our seller growth suite, a group of programs designed to give sellers personalized insights in the tools they need to grow their business in a sustainable way. One area I'm really excited about, we're running tests of a new price discovery functionality utilizing buyer demand data to help sellers think about how to price their items and when or how they might best use promotions as part of their mix.
Our recently launched Make an Offer program currently focused on U.S. vintage sellers is another example of our investments to help sellers price their items appropriately, and especially challenging task in a world where items don't have MSRPs. And as we improve the seller experience, this in turn enhances the buyer experience as items on Etsy are priced appropriately, we facilitate better matches between our buyers and our sellers.
During the second quarter, we held our annual engineering week designed for our engineers to connect, share ideas, learn new skills, and technologies. Of course, much of the focus was on the myriad ways we can continue to harness AI and ML Technologies in almost every customer touch point with the potential to further transform buyer facing experiences like enhancing search and recommendations, seller tools like streamlining the listing process and assisting with answering customer queries, improving fraud detection and trust and safety models, et cetera, the opportunities are nearly endless.
But all of this innovation also takes time and effort and relies on our relatively small, but mighty team of ML experts, talent that is obviously in high demand. Historically, all new ML models have been created by this team of highly specialized data scientists. And the full process of creating a new model from cleaning and organizing the data to training and testing the model, then putting it into production could take as long as four months, that's why we kicked off a major initiative over a year ago. We call democratizing ML with the goal to streamline and automate much of this work, so that virtually any Etsy engineer can deploy their own ML models in a matter of days instead of months.
And I'm thrilled to report that we're starting to see the first prototypes from this effort come live now. For example, if you're on the Etsy team working on buyer recommendations, you can now use a drag and drop modeling tool to create a brand new recommendations module without needing or ML team to build that model for you, it’s a great example of the, kind of, longer term infrastructure investments we've been making that we believe will pay very significant dividends over the medium term as we work to get even faster and more efficient as we scale.
Turning to marketing. We've released a new Creator Collab with the award winning artist and entrepreneur, John Legend, featuring handcrafted home decor and wardrobe staples produced in partnership with female sellers from the Etsy Uplift Initiative and other underrepresented communities. To-date, we've seen this collection deliver above order value and strong awareness, engagement, and frequency. The 5th annual Etsy Design Awards has once again created wonderful buzz for Etsy. This year with the winners handpicked by Sarah Jessica Parker and Etsy's Dayna Isom Johnson. And early indications are that our Etsy has it campaigns in the U.S., U.K., and Germany that emphasize home and living, style and gifting are performing well and driving brand association for these purchase occasions.
While GMS per buyer has shown early signs of stabilization, taking this metric to new heights is a top priority for us. With over a quarter of our GMS coming from buyers, who purchased again within 14 days of their prior purchase, one way we can influence this metric is to bring buyers back to the platform faster for their next purchase. We're leaning into this work in the second-half of 2023, including leveraging post purchase touch points, better outreach and promotional campaigns, and improvements to seller funded offers. Given all Etsy has to offer, we're highly confident that we can make Etsy a place where buyers want to shop with us much more than our average of three purchase days and spend significantly more than a $128 per year.
Moving to our House of Brands, two weeks ago, we announced an agreement to sell our Brazil based handmade goods marketplace, Elo7 to Enjoei a Brazilian company, which operates an online marketplace for clothes and furniture. Our House of Brands philosophy has been to operate standalone marketplaces that together accelerate value creation for each brand and Etsy Inc. We evaluate each company's performance on a case by case basis, and given Elo7's performance over the past two years, due in part to the unique macroeconomic conditions in Brazil, as well as their small scale, it became clear that we needed a different approach for that business.
We considered various alternatives and determined that the best to sustain the marketplace and it’s 1,000s of sellers would be for Elo7 to join force with a local like-minded marketplace. The transaction is expected to close shortly, and Rachel will review its financial implications in a moment. We remain committed to doing what is best for our remaining marketplaces and we'll invest with discipline in compelling long-term growth plans that further our global scale and shared mission.
The Depop team is starting to see very encouraging signs of success, transforming the business by narrowing their focus and improving operations to reignite growth. In the second quarter, Depop delivered both GMS and revenue growth on a year-over-year basis. U.S. GMS growth accelerated by over 25 percentage points since the end of 2022, where we believe Depop is taking share. We believe this performance is a direct result of improvements in the customer experience and marketing efficiency, powered to a significant degree by Depop CEO, Kruti Patel Goyal’s, more streamlined focus, organizational structure, and processes. Product development velocity has remained strong, and the Depop team has been leveraging deep expertise from the Etsy, core marketplace to great effect.
Some examples are shown on the slide, including new personalized buyer recommendations, greater search relevance, and new Make an Offer capabilities. Depop also expanded its performance marketing data feeds to additional listings, driving a strong increase in paid marketing contribution. Depop is building a playbook for community driven marketing, such as branded events, pop-up shops, and influencer marketing. We're seeing really encouraging signs the business is recapturing its mojo with significant opportunity to scale and drive improved profitability over time.
Although macroeconomic factors are pressuring consumer discretionary spend, Reverb has continued to outperform the musical instruments sector over all. Similar to Depop, Reverb has increased its product experiment velocity to more quickly deliver better buyer and seller experiences with its best quarter ever in terms of the number of product wins. Reverb’s focus on affordability and helping musicians find good deals has continued. For example, we launched new offer and negotiation tools, making it easier for buyers to save money on a wide range of year.
Over the last few years, Etsy has gone from a period where we grew tremendously with so many tailwinds at our back to a period of stiff headwinds and uncertain macroeconomic conditions. While we're cautiously optimistic for the near-term, the macroeconomic climate remains challenging, at least for the moment. Consumers continue to make very tough choices on where and how to spend their money, and we're fighting hard to help our sellers get their share. We're up for the challenge. We have an energized world-class team, who are all in on helping our sellers and Etsy grow. We couldn't be more proud that our already high employee engagement score increased 3% from lasty year and is now 6% above the industry benchmark. We're acting with focus, speed, and boldness and our work to reignite GMS growth in the second-half of 2023 and beyond.
In fact, you'll see us making some big moves so that Etsy is even more special and a better place to shop for the holidays this year. Building on our Etsy has a theme, this year, we're working to better connect our brand and on-site experiences to become your gifting accomplice. In other words, helping our buyers to be gifting heroes. Buyers will see some new AI assisted ways to find crafted quality gifts for the loved ones at great value with even more confidence that these gifts will arrive on time.
Our goal will be to help buyers gift better in 2023. We continue to believe that we're doing something truly important and different and are in the very early days of unpacking Etsy's enormous potential.
Thank you for your time, and I'll now turn the call over to Rachel.
Thanks, Josh, and thank you, everyone, for joining our second quarter earnings call. My commentary today will cover consolidated results for our House of Brands, key drivers of performance and Etsy marketplace stand-alone results were appropriate.
Last quarter, I commented that one of the things I'm most proud of is Etsy's ability to navigate through choppy waters, and our second quarter performance further demonstrated the resiliency of our business, the benefit of our capital light, highly profitable business model, and our team's strong execution. We delivered strong second quarter consolidated GMS of $3 billion roughly flat year-over-year. Revenue increased 7.5% year-over-year to $629 million and adjusted EBITDA was $166 million with a healthy 26.4% adjusted EBITDA margin.
We are pleased to have delivered strong profitability through this challenging business cycle, while also investing in future growth. It's worth noting that our adjusted EBITDA has grown at a 43% CAGR since the second quarter of 2019. While year-over-year consolidated GMS growth were made negative in April, trends turned positive in May and June, driven primarily by strong Etsy marketplace growth in several of our international markets and continued growth in active buyers.
FX headwind softened to 20 basis points, down from 200 basis points in the first quarter. GMS for our three subsidiaries was largely flat in the second quarter, driven by a return to year-over-year GMS growth at Depop, which was offset by some softness at Reverb and Elo7. Our solid revenue growth can be attributed to continued growth in our marketplace revenue, which increased 3% year-over-year. In addition to the impact of the Etsy marketplace transaction fee change that we fully lapped during the quarter, marketplace revenue also benefited from a mix shift to more international transactions that often yield higher payments fees and some positive contribution from our subsidiaries.
While a smaller percentage of revenue overall, services revenue was our standout growth driver in the quarter with a 21% year-over-year increase, the highest growth rate in this component since Q4 of ‘21. Etsy ads was the key driver here due to continued product optimization. For example, we utilized multiple retrieval systems to increase the relevance of paid ads, including integrating XWalk, our real time retrieval engine. These enhancements allowed us to show more ads in our search results without negatively impacting conversion rate. These contributions drove consolidated take rate to 20.9%, modestly ahead of the take rate implied at the midpoint of our quarterly guidance.
We are pleased with the strength of our profitability and the returns we are getting on our investments in both product development and marketing. Q2 was another excellent quarter for returns in both areas, and you'll see that even as we have gained further leverage in market we have leaning a little bit more into product development where we see very strong value creation, productivity, and velocity as we have scaled. We believe the investments we are making will continue to be drivers of long-term growth and differentiation as we unpack the significant opportunity ahead.
And as I just alluded to, our consolidated product development spend increased 19% year-over-year to $122 million in the second quarter. Meanwhile, for the Etsy marketplace, product launches increased over 50% year-over-year. A great sign that we're getting bolder and faster despite getting bigger. We continuously realign resources to focus our talent on the areas we believe will have the highest yield, which is why we have some of the highest revenue per count amongst our peer set. We have strong conviction that our teams are working on the true vital few to enable 2023 and 2024 growth.
Our consolidated marketing spend increased 1% year-over-year to $166 million, driven by a 1% year-over-year increase in consolidated brand spend. We leaned into our Etsy has it campaigns in our top three markets highlighting home and living, style, and gifting purchase occasions. Our performance marketing spend was largely flat to last year as we ran incrementality tests on our ROI models and selectively pulled back on performance marketing spend in several key channels.
Overall, we gained leverage on our marketing spend in the second quarter, with marketing as a percentage of revenue decreasing 160 basis points year-over-year to 26%. While we primarily utilize ROI model to drive our marketing spend, we understand investors focus on LTV to CAC and thought we could use this opportunity to provide our view of how you should think about this metric specifically for the Etsy marketplace.
Let's start with CAC. Many of you have concluded that the rate of growth of our total Etsy marketplace marketing spend has outpaced our new buyer growth. That is correct. In fact, from 2019 to 2022, blended new buyer customer acquisition cost increased about 50% after accounting for off-site ads revenue. Effectively, off-site ads revenue offsets a portion of our performance marketing spend. And as such, OSA revenue is important when considering your CAC calculations. And we've seen that omitting this factor leads to incorrect conclusions.
And then moving to LTV, the Etsy marketplace's customer lifetime value also increased about 50% over the same period, which allowed us to spend deeper while maintaining very strong efficiencies. This very impressive increase in LTV was driven by a higher GMS per active buyer, transaction fee increases, Etsy ads growth, and Etsy payments expansion. The stability in our CAC to LTV reflects our long stated philosophy of investing to a marginal ROI threshold that we establish for all of our marketing spend worldwide.
So what do we mean when we say that we have maintained very strong efficiencies? We think this slide should help clarify our view. While our blended LTV to CAC has held steady, our performance marketing ROI has increased over 40% since 2019, due to the following. Successful expansion of our paid marketing to new channels and more countries was drove an increase in paid GMS in which we believe has contributed to significant non-U.S. GMS growth and as our buyer mix evolved, we increase the amount of performance marketing spend that goes to retaining and reactivating buyers and encouraging purchase frequency. We have worked hard to maintain the gains we achieved during the pandemic period, as well as through reopening and challenging macro conditions.
Given our healthy buyer retention rate, as well as the significant retention of our GMS and scale of Etsy, we believe this investment has been well made. And as a reminder, our LTV models assume that the majority of the payback comes within the first 30-days after acquisition, but there is a tail on the investment, which drives future retention and frequency, which is the L, a lifetime value.
In connection with that, we also have significantly expanded our brand investments during this period, which as we have reported moved brand awareness up materially in our core markets, contributing to Etsy now being more of a household name than we were several years ago. In summary, we feel great about the returns our marketing spend has generated, and we will continue to invest with discipline and focus as the marketplace scales in the future.
Moving now to our review of Etsy marketplace, GMS and buyer metrics. During the second quarter, Etsy marketplace GMS was nearly flat year-over-year declining just 0.7% to $2.6 billion. While we continue to experience week-to-week volatility, year-over-year growth trends turned positive during the quarter. These results can be attributed to several factors, including easier year ago comparisons, positive order growth, moderating FX headwinds, and healthy growth in select international markets.
We also saw our average order values remain largely unchanged on a year-over-year basis. Data suggests that Etsy marketplace GMS remains pressured by consumer wallet share shifts from goods to services and headwinds to consumer discretionary spending, particularly for lower household incomes, when using U.S. census average household income data by ZIP code, we have seen a clear delineation of GMS trends between buyers with income above $1,000 where we experienced meaningful GMS growth and lows below that level where we continue to see declines.
This slide shows a monthly view of Etsy marketplace performance where we have seen an encouraging trajectory towards positive GMS growth since the beginning of the year, despite the stiff macro headwinds. In fact, the Etsy marketplaces GMS was marginally positive year-over-year in July, making our third consecutive month of growth. From a geographic perspective 47% of Etsy marketplace GMS in the second quarter was from transactions where either the buyer or the seller or both were outside of the U.S. GMS, excluding U.S. domestic, returned positive year-over-year trends increasing 5% in the second quarter. While we had a modest year-over-year decline in the U.K., we reported year-over-year growth in some of our core markets, including Germany and France.
We also saw strength in select non-core Western European countries, an encouraging testament to our growing awareness in these markets, particularly as we have carefully expand our performance marketing with limited, very targeted spend, and improve our overall search and discovery capabilities in those markets.
We are pleased to report that year-over-year GMS trends improve sequentially in three of our top categories: home and living, apparel, and craft supplies, as shown on the left side of this slide. We also had year-over-year growth in horizontal categories such as gifts and personalized items with Etsy being a great mother's and father's day destination. We remain extremely excited about our long-term ability to gain market share in our top categories, as well as improve awareness of Etsy for specific purchase occasion where we have so much great and unique merchandise to offer.
The Etsy marketplace ended the second quarter with a new all-time high of 90.6 million active buyers, and our positive year-over-year growth rate accelerated sequentially to 3% from 1% in the first quarter. Growth in our non-U.S. active buyers continued to outpace trends in the U.S. as the majority of our active buyers are still in the U.S. We also continue to see strength in active buyers, who identify as men, which increased 8% year-over-year.
While our GMS per active buyer on a trailing 12-month basis for the Etsy marketplace declined 6% year-over-year to $128 in the second quarter. We are seeing early signs of stabilization on a sequential basis as you can see from the chart. Overall, our GMS per buyer has held up fairly well, up 28% since the second quarter of 2019. And we continued to maintain nearly all of our pandemic gains. We remain optimistic in our ability to once again inflect GMS per buyer over the long-term, both in the U.S. and Internationally.
We added 6 billion new buyers in the second quarter, which is over 40% higher than the average number of new buyers we acquired on a quarterly basis in pre-pandemic periods. We also saw the negative year-over-year new buyer trend moderate to 3% in the second quarter, compared to a 6% year-over-year decline in the first quarter. We reactivated nearly 6 million lapse buyers, up 21% year-over-year. Overall, we've done a really good job of keeping our active buyers engaged.
In fact, our active buyer's retention rate on a trailing 12-month basis remained above pre-COVID levels. On a quarterly basis, retention trends improved from both the prior year and prior quarter. We ended the quarter with 7 million habitual buyers, up 218% from the second quarter of 2019, but down 9% year-over-year. Encouragingly, our habitual buyers were largely flat on a sequential basis as the strong pandemic-related periods fully rolled out of the trailing 12-month figure.
Germany, France, and several non-core Western European markets experienced strong habitual buyer growth. We also saw a year-over year increase in the number of habitual buyers, who identify as men. Continuing the trend we previously reported the vast majority of the year-over-year decline in habitual buyers can be attributed to buyers moving into the repeat purchase category with very few of these buyers lapsing entirely. Strong performance in Western Europe also contributed to a 2% year-over-year increase in repeat buyers.
Before moving to the balance sheet, we recorded a non-cash impairment charge of $68 million to the long-lived tangible and intangible assets related to Elo7. This impairment charge was fully offset by tax benefits related to Elo7, which netted to a neutral impact to our quarterly net income and earnings per share. As of June 30, we had $1.2 billion in cash, cash equivalents and short and long-term investments.
During the second quarter, we repurchased $39 million in stock under our $600 million May 2022 Board authorized repurchase program, of which approximately $114 million remained available as of June 30th. On June 14th, the Board authorized a new $1 billion share repurchase program. Our free-cash flow this quarter was a healthy $128 million. We continued to convert nearly 90% of our adjusted EBITDA to free cash flow on a trailing 12-month basis as our marketplace operates with minimal cash requirements.
Now turning to our outlook. We expect to complete the Elo7 divestiture shortly, so that business is only included in our guidance for half of the quarter. As a reminder, Elo7 reported $70 million in GMS for all of 2022, so 0.5% of our consolidated total GMS. Elo7 represented less than a 50 basis point headwind to our consolidated adjusted EBITDA margin last year. We currently estimate our third quarter 2023 consolidated GMS to be approximately $2.95 billion to $3.1 billion, about $3.03 billion at the midpoint, up slightly compared to last year.
External factors we're keeping an eye on for the third quarter include those that could influence consumer discretionary spending including wind-down of previously high levels of consumer savings, potential negative impact from the resumption of student loan payments this fall and discontinuation of child tax credits.
On the plus side, we are reading all the same data you are about the potential for a soft landing for the U.S. economy. So given the continued uncertainty, we are forecasting the midpoint of our guidance to land with a slightly positive year-over-year performance similar to what we delivered in July. We are forecasting revenue of $610 million to $645 million, up nearly 6% at the midpoint, compared to the third quarter of last year. The implied take rate for the third quarter is down slightly sequentially, and please keep in mind that we sometimes see seasonal pressure on our fourth quarter take rate.
We currently expect another very strong margin quarter for Q3 with an adjusted EBITDA margin of 27% to 28%. It's quite encouraging to be guiding to a slightly positive GMS at the midpoint of our guidance, with another sequential improvement in our GMS trendline currently anticipated for the third quarter. We aren't economists, so it's hard to predict how the macro-environment fares from here.
But as Josh highlighted, we have an impressive pipeline of product and marketing initiatives where we continued to see strong value creation and return on investments and strongly believe we are on the right path to reaccelerate growth.
Thank you all for your time today and I will now turn the call back to Deb to take your questions.
Hey, everyone. Good evening. Thank you for joining us. I'm going to dive right into Q&A. First one, I'm going to give to Josh from Mike Morton at Moffett Nathanson. Looking beyond domestic buyer growth, can you discuss Etsy's expectations for the biggest contributors to GMS growth in 2023 and 2024, for example, do you see this from improved curation, international expansion or recovery in the software category -- in the softer categories such as home and living?
Thanks for the question. Happy to take it. First, I don't want to look beyond domestic buyer growth without talking about domestic buyer growth for a second, because I do think it's important. We're happy about the fact that we have the highest-ever level of active buyers of this quarter and we think it's early days. We think we have a lot of opportunity both domestically and international.
As we've said, many times before, most people who identify as women in the United States have still have not shopped on Etsy in the last 12 months. Only about one and 10 people, who identify as men have shopped on Etsy in the last 12 months in the United States. And so we think there continues to be a big opportunity to continue to grow active buyers in the United States, both new buyers and reactivating that, you know, pool of a 100 million lapsed buyers, and we saw great evidence of that, in this quarter.
And as you say, there is a very big opportunity for Etsy to grow, Internationally. And we're seeing very promising signs of that again this quarter. So, Etsy, just began to buy Google PLAs in markets, outside of the U.S., outside of the U.K., Germany, and our core markets, you know, recently, and we're seeing that we're able to do that in an ROI positive way immediately. You know, the Etsy site is translated into many languages, and it turns out there's demand for Etsy products in many parts of Western Europe, for example. And so we're able to grow in a pretty cost efficient way in those markets. And those markets collectively, can be very big. You know, can have the GDP of the United States, for example, the 15 markets beyond our core, have a population that's even larger than the U.S. and GDP equal to the U.S. So we're very encouraged by that.
In addition to that, I think there's a very meaningful opportunity for us to do even more with the traffic that we have to drive GMS per active buyer to drive conversion rate up, and I see lots of opportunities, to do that. I talked on the call about quality in the recorded part of the call about quality. And I'm really excited about this next chapter for Etsy. We've done so much over the past six years to do a better job with relevancy to understand what you meant, not just what you said in your keyword, and to give you search results that are relevant. It is still the case that most of the time, we have 1,000s of search results to choose from and finding the ones that are the most visually appealing that you're most likely to like, the ones that feel priced appropriately, and the ones that deliver really great service quality and of course, doing ever better at making sure that, we can enforce all of our policies in a really scalable way. All of that means we're serving only the highest quality things to you, which is going to, I think, do a lot to make a more delightful experience to drive conversion rate up, to drive frequency up, to even further enhance the appeal of the Etsy brand.
I talked in the recorded part about pricing and the tools that we have to do -- to help our sellers come up with the right price. I think that's another example of where we can really help to improve the conversion rate of the site and make our sellers be more successful. And then things like promotions, we're investing even more in tooling to help sellers run the right promotions at the right time in the right way, that's more important now than ever. We want to make sure that our sellers can compete and win. If you go look at the homepage of Etsy right now, you're going to see some big bold banners around items that are, you know, running promotions right now, that's new. We haven't done something that bold in the past, I think it's appropriate in fitting with the times. I think there's a lot of levers we can pull, that will continue to drive conversion rate, drive the quality of the experience.
Oh, one more that I would want to talk about is curation. When you look at the Etsy search results page right now, you'll often see many variants of the same thing, many similar versions of the same thing. We can do a better job of organizing those and collapsing those into, you know, a set of things that are different and showing you just the very best of each of a set of very different items. And I think that can also do a lot to drive conversion rate, perception of quality and a better customer experience in time. So, I'm really excited about our roadmap, and we've got a lot underway right now that I think can really help to even further improve and differentiate Etsy.
Okay. Great, Josh. next one is from Laura Champine at Loop. I'm going to give this one to Rachel. What do you expect to be the ceiling on total take rate now that Elo7 is being divested and the rate seems to be naturally climbing on an organic basis?
Hi, Laura. Thank you for the question. You know, we've never said anything about a ceiling on take rate that you're right. We have actually been able to improve take rate almost every single year since, this management team has been in place. And we've done that in part from transaction fee increases and in part from offering, expanded services that naturally bring the take rate up.
At the ads, for instance, was not even a new service in the past couple of years or a transaction fee increase. It was just continuation of optimization of that particular product, where we keep making the search results better on a sponsored ad, which increases click through rate, and therefore increases our ability to drive incremental revenue. So, we haven't fixed a price on, you know, a ceiling on take rate in, I'm not going to do so here. I will say we are neither the highest take rate for marketplaces nor the lowest take rate for marketplaces, and we really always stick to our credo of a fair exchange of value. So where we see there are products or needs or services that will benefit our sellers and we can provide a service that will or a product that will benefit them. We will charge a fair fee for that, and we feel that all boats arise in that scenario, and we see lots of opportunities to do so.
Thank you, Rachel. Alright, I'm going to move to the next one from Tom Forte at D.A. Davidson and this is going to be for Josh. Can you provide an update, on your M&A strategy and why was it the right time to divest Elo7? We've had quite a few questions about that and also related to our House of Brands, strategy going forward? I think we'll just -- I'll end the question there. And if you can just address those kind of two factors of it, it would be great. Thanks, Josh.
Sure. So we look at each of our acquisitions on a stand-alone basis, and we have a thesis. And so we bought Elo7 with a thesis, which is that when coming out of the pandemic, we would see real tailwinds to Elo7's growth. Elo7's merchandise centers a lot around events and activities that happen offline, things like birthday parties, Kinzinetas, weddings, et cetera. And it's now been two years since we've come through the pandemic, and we've not seen the growth rates that we've expected from the Elo7 business. I think it's a good team doing good work, but they've faced quite a lot of headwinds.
And so the thesis hasn't played out. We haven't seen what we've expected, and we thought that this is the time to call it. And I think that's part of taking risks. We're prepared to take calculated risks, thoughtful risk as a business, but we also want to be clear on and call it when we see it, acknowledge when it didn't work out and move on. We're really excited about the opportunities in our core. We're seeing great progress. Depop is doing fantastic things. Reverb, we think, continues to gain share in its industry. And we want to keep our focus, and so that's what we're going to do.
Okay. Great. Thank you. I'm going to give this next one to Josh. Hold on a second. Give me one second. Okay, actually, for Rachel on a couple of guidance questions. The high -- it's from Lee Horowitz at Deutsche Bank. The high end of guidance suggests quarter-over-quarter growth of 40 basis points. In the past, back to school demand has supported growth in the low to mid-single-digit range. Why is it that you are no longer replicating past seasonality? Is it the continued pressure from the macro environment?
So thank you for the question. We -- let's talk about what's implied in the guidance that we gave. The midpoint of the guidance is about 0.7% growth -- 0.5% growth, rather. And that implies that the conditions that we have seen today, as far as macro headwinds, remain roughly the same. They don't get better, they don't get worse. At the high end of the guidance, we would assume that macro headwinds improve so that we are able to hit the high-end of the range. And the low end of the range, we would say that they would slightly worsen.
It's still a very volatile market. We don't actually have our crystal ball to say they'll get more or less volatile. So we do -- the guidance does imply that August and September are sequentially a little bit worse than July. We do think we stand to get a fair share of the back-to-school and Labor Day market. We've been, as Josh talked about, leaning much more into promotional opportunities, similar to all e-commerce retailers and more so than Etsy has really ever done before. And we're very excited to be able to talk about back-to-school as an occasion for which you can find many, many special things that people will be shopping for at this point.
There was a -- thank you, Rachel. There was actually another question related to guidance that was from Curtis Nagle at BofA. And it was really about -- we already answered the part about the midpoint and where it was hitting in terms of macro factors. But there was another one about whether our product categories had any impact, how we were thinking about product categories in the guidance. Did you want to answer that one as well?
Well, what are the things that we've said -- we did talk about is that some of our horizontal categories, so specifically gifting and occasions are actually growing quite nicely. And so while we do see headwinds from some of our larger categories like Home & Living, and those have continued to be a little bit under pressure, some of the other categories are actually starting to see sequential improvement. And a category like gifting when we're heading into holiday, we feel pretty strong opportunity for growth.
Thanks, Rachel. All right. Josh, I want to give you the next one from Maria Ripps at Canaccord. Recently, there have been reports of some sellers taking issue with the company's reserve system and its process for withholding and distributing funds. Can you first refresh us on what that policy is around payment reserves and why it's important to the overall health of the marketplace? And maybe comment on how you are addressing this cohort of sellers who are unhappy with the current policy.
Yes. Thanks for the question. So Etsy has an unusually generous payment policy relative to most marketplaces. And that historically, when a buyer buys an item, 100% of that money is transferred to the seller right away. We take it on faith that the seller is going to ship the item to the buyer. And the good news is the vast majority of the time, that happens. But things do go wrong, and sometimes, for example, seller sales really ramp faster than they can deliver on, and things go wrong. And Etsy, of course, steps in to the gap in those times to make sure that the buyer has held whole so that the Etsy brand is a great brand and other sellers' reputations are not hurt by that.
So it's really important for the overall health of the marketplace that we can always stand behind every single sale and buyers have a lot of confidence that Etsy will always have their back. As part of that then in 2021 we introduced a payment reserve, where a very small number of sellers that are high risk, perceived to be high risk, predicted to be high risk, we withhold some of the payment from those sellers.
And we continue to iterate. We continue to learn on that program, how do we make the models more precise, how do we withhold the smallest amount that we need to and how do we communicate better with sellers about what the thresholds are, why they're in that program and not. And so we just announced yesterday some improvements in being even clearer with sellers about why they're in the program. We announced actually we're going to be reducing the amount we're holding from the vast majority of sellers.
So we continue to listen. We continue to learn. We continue to work together with sellers and buyers to make sure that the marketplace stays safe. And just to put some dimension around this, it's in the low single digits of sellers that are in reserve right now. 70% of those sellers have less than $50 in payment reserve. And I don't want to -- we recognize for every seller being in payment reserve is -- can be a hardship. So we want to do it only when necessary, only the mount one necessary, and we want to be communicating as well as we can with the sellers and get them out of reserve as quickly as possible. And so we're working hard to make sure all those improvements happen.
Okay. Great. Thank you, Josh. One from Ed Yruma at Piper Sandler. Can you talk about inflation, if any, observed on the marketplace? Does the pricing tool help sellers understand when they have pricing power? And could this help drive GMS? I'll give that one to Josh.
Sure. Thanks for the question. Yes, we see a lot of opportunity, and I think we've talked for a few years about how helping sellers set better pricing is a big opportunity. And it's one that we hadn't yet leaned into, but we want to. Now we really are. So we've kicked off a couple of squads focused on what we call sustainable pricing, and there's really two separate areas that we're focused on.
The first part is how do we help sellers get the right data so they can set the right price for their listing at the start. And so we can share with them, for example, data about items that appear to be similar to theirs and what has been the final selling price for those items. And we showed a screenshot of an example of a test of that, that we're going to be launching. We'll see. We'll iterate and learn exactly how to do that, how to give sellers the right context. But probably, there are some sellers that are really underpricing and some sellers that are really overpricing and some that are getting it just right. But in our market, there are no MSRPs, right? Every item is unique and made by the seller. And so it's, I think, particularly helpful to be able to give sellers context.
The second piece is having set your initial price appropriately when, how and if should you use promotions. And I think a lot of sellers are just winging it, and so we're doing a lot of research to see when do promotions pay off and when do they not. For example, is a 10% promotion worth it? Maybe a 10% promotion isn't enough to get a seller to buy, so you're just kind of wasting that sale, if you will. So giving them more insight about when it makes sense and what doesn't make sense to use promotion and how much promotion may make sense. I think that's also an opportunity for us to gather a lot of insights that we get through the marketplace and then share those insights back. So sellers, it's always up to sellers what they want to do, but we give them the insights so they can make better informed decisions that build their business better.
Okay. Great. Rachel, I want to give you one from Shweta Khajuria from Evercore. Just to clarify the guidance comment that you made. Does the guidance assume August worse than July and September worse than August? She was just following up on that, and I think that's an important one we want to clarify.
Yes. So first of all, the midpoint of our guidance is actually 0.7%, not 0.5%. So I want to clarify that first and foremost. Second, we don't guide to the months. So we don't guide to August or September individually. My comment was meant to say at the low point of our guidance, it would imply some decel. July was positive, as we said several times in our call. It would imply some decel in August and September.
Thank you, Rachel. That's perfect. And then I'm going to give another one from Shweta since I have her right here. I'm going to give to Rachel also. Etsy ads once again drove revenue growth and take rate expansion. Where do you see the clear growth opportunity? Is it driving relevance, ad load, more sellers, something else? And maybe Josh wants to comment on that one, too. It's an exciting one. So Rachel you go first.
Thanks for the question, Shweta. Yes, we've continued to be able to grow Etsy ads, I want to say, organically, but it's not without a lot of hard work from a lot of release. Smart machine learning engineers making the algorithm and better, better retrievable engines. And because we are able to make the ad results so relevant to a buyer's query, we're able to increase the CPC, which increases our revenue and also at the same time, maintaining the ROAS for our sellers. And as you know, we get a lot of budget from our sellers, and we don't spend it if we can't give them a certain amount -- a minimum amount of ROAS. So the more that we can match a buyer's query to a seller's product, the more of that budget we can utilize. So we see some continued growth and opportunity for Etsy Ads.
I will remind you that we do see Etsy -- our take rate actually, it's softer in the fourth quarter. We called that out on the call. And that's because Etsy Ads, even though it's the gift that keeps on giving relative to the growth we usually see in GMS in the fourth quarter, is lower. So that's the one thing to think about is the seasonality of that product.
Okay. Great. Did you want to add anything, Josh? Or are you good? Okay. Fabulous. And I'll go to the one for both of you from Ygal Arounian from Citi. I'll start with Rachel. Are you able to quantify the AI and ML investments? What they are and how they're impacting margins? And then perhaps -- and then connected to that, I'm going to have Josh talk a little bit about the benefits we're seeing from Gen AI and whether it's helping develop better product development velocity? And do you have any proof points yet that the AR tools are driving GMS growth? And sort of for both of your questions. Rachel, do you want to start? And then…
Sure. Thanks, Ygal. We've been doing machine learning at Etsy for a very long time. So we have a lot of talent of the company that is in machine learning, and that's already embedded into our cost base. And one of the things that we are focused on is doing what Josh described as democratizing ML, so that many people throughout the company can leverage the suite of tools for machine learning and AI and do their own -- leverage that capability and that technology themselves without having to sort of ask for that service from a separate group.
So that means that our entire installed base of engineers and maybe even others, like people in my finance organization, will be able to really leverage the capabilities there without having to hire armies of people to go do machine learning for us. We've also been leveraging the investments that other companies, many of them are existing partners have invested already in machine learning. And so we're doing a lot of beta testing and experimentation with other companies. And at the moment, that is coming at a very low cost to us. We would imagine that at some point, there will be some kind of license fee arrangement. But we are -- typically, we do not invest in anything unless we see a high ROI for that investment.
So if we decide to license different tools that are out there or to invest in our own workforce to be able to lean more heavily into machine learning and large language models, that would be because we see significant GMS opportunities from doing so. And as you know, we measure everything pretty carefully. We expect about an 18-month return on those investments and that things that, say, way we would measure any kind of new product development as well.
And then on how Gen AI might affect the customer, I would talk about internal and external customers for that. So there's a set of productivity potential benefits that come from Gen AI, for example, for our software developers. And I'm really pleased by the data we shared in this earnings call about just how much velocity continues to improve in spite of getting better. Velocity per squad continues to get better, and we're really excited about the value creation per squad we're seeing right now.
So we continue to focus on making Etsy more efficient and more nimble even as we get bigger. Gen AI, things like CoPilot are going to be another tool to help with that. I would caution, I don't think we're testing, and we're leaning in and we're excited about it, and I think it's going to be helpful, but it's not the only thing. It's not a silver bullet. We're actually constantly looking at how can we streamline our processes, how can we be more agile and how can we get more productivity and more value creation out of every squad. I do think that the way that we measure value creation per squad in this company is part of our secret sauce. We've always been obsessed with that.
I think it can be a tool that can really help our sellers. So for example, answering queries from buyers. Can it help to auto generate some suggested responses? But the seller is still going to want to look at that, put eyes on that before they send it. So it will be helpful for them, and we want to help sellers every way that we can, help them auto generate listings over time, things like that. Yes, maybe. It could be good again if it helps sellers save time, that's great. We wouldn't want to do anything that makes the cycle homogenous or boring, though, so we're going to be very careful about that. And more listings doesn't necessarily translate into more sales for Etsy. So if it's useful for sellers, we'll lean in.
For buyers, the idea that the search experience can become more conversational, I think, can be a very big deal for Etsy, and maybe more for Etsy than for most people. I talked to two earnings calls ago now about how you don't walk into a store and shout, Dress blue, linen, to a sales agent. You actually have a conversation with them that has more context. And I think that's especially important in a place like Etsy, where we've got 115 million listings to choose from and no catalog. So the idea that it can be conversational, I think, can give a lot of context and really help.
And I think a lot of the technology behind that is becoming a self-problem. What's going to be longer is the consumer adoption curve. What do customers expect when they enter something into a search bar? And how do they get used to interacting with chatbots? And what's the UI look like? And that's something that I think we're going to need to -- we're testing a lot right now. What do people expect? How do they like to interact with things? And in my experience now, having a few decades of consumer technology leadership, the consumer adoption curve is often the long pole in the tent, but I think over time, can yield really big gains for us.
Great. Thanks, Josh. I'm going to give one from Alexandra Steiger from Goldman Sachs, and I think I'll get this one to Josh. In terms of GMS per buyer, how should we think about declines in that metric? And can you talk about what you're seeing at the cohort level that gives you confidence that you can actually return to positive GMS provider growth once macro conditions normalize?
Yes. Great. Thanks for the question. So let me talk about GMS per buyer in the U.S. and international. In the United States -- well, around the world, when the pandemic happened, most places you could shop shut down or were out of stock, and Etsy had enormous tailwinds. And during that time, in the U.S., we saw GMS per active buyer grow by over 30%.
Since that time, there's been an onslaught of competition. There's been inflation and all the other things everyone knows about, and yet the GMS proactive buyer in the U.S. has stayed almost exactly the same. We've held almost all of those games. The declines we're seeing in GMS productive buyer are that we're growing faster in international than we are in the U.S., and we've seen a little bit of pullback in GMS per active buyer in international. I'm not mad about us growing faster in international. There's a lot of opportunity in international. There's a lot of buyers to be added in international.
And the fact that we've done such a good job maintaining a GMS per active buyer in the U.S. in spite of these headwinds, in spite of all the new competition says, wow, people came to Etsy and they loved it and it was something really different. And now with a lot fewer dollars to spend and a lot more places to spend it, they are continuing to come back and spend in roughly the same amounts today as they were back then. As a platform from which to drive further growth, I take a lot of optimism, excitement, confidence from that.
I talked at I think the first question about all the things we think we can do to grow and drive even more from there. But I take that as very encouraging. Rachel talked in the call -- in her part of the call about the difference we're seeing between households over 100,000 and households under 100,000. And we see this not just in Etsy results, but all around that it does seem like for households under 100,000, they're just under enormous pressure right now and having to make very, very difficult trade-offs in life. And if it's not something that's absolutely essential, then people are having a hard time prioritizing that, and we may be feeling some of that. We're still getting a pretty good amount of GMS proactive buyer from people under 100,000 considering the times we're in.
But I would say cycles are cycles. And now being over 50, having lived through a few cycles myself, cycles are that. They come and they go, and we are in a tougher part of the cycle. And at the time we're in a tougher part of the cycle, and we are still maintaining the GMS gain to the pandemic and putting up EBITDA margins in the core of 30% feels like a pretty good business if this is what bad times look like, and I'm very optimistic that there's much better times to come.
Great. Thanks, Josh. I'm going to just slip in one more for Rachel from Nick Jones at JMP Securities. The press release indicated there will be more investments in noncore markets and performance marketing in particular. How are you thinking about the pace at which Etsy can capture share in Europe? Can success in North America and U.K. help accelerate the pace at which you can win active buyers in the European -- rest of Europe?
I really -- we're super excited about what's going on internationally, and what we said on the call was that we've seen growth in non-U.S. markets up 5%. And we've been able to invest profitably in our core markets with performance marketing and within the U.K. and Germany with brand marketing as well. We've also been investing with performance marketing in our noncore markets. And we're seeing this lovely yield from that spend, where we're getting lots of visits in GMS coming from some of these noncore, especially Western European markets.
So look, we'll stay tuned for that. We'll talk more about it. It's a nonhuman intervention kind of things, so we're able to spend there with a fairly light lift and with good ROI on our adjustment.
Okay. Great. Thank you, Rachel. I think we went over by a few minutes, so we're going to end it there. Thank you all for your time and attention, and we'll talk to you very soon.