Introducing Crest — a fresh, modern location analytics tool for Etsy sellers

Today, I’m absolutely thrilled to announce the immediate release of Crest, an analytics tool for Etsy sellers that differs from competitors due to its dedicated focus on location. For the first time, Etsy sellers will now be able to obtain deep insight into where their shop customers are buying from.

In this article, I’ll cover a bit of background into why I built Crest, as well as its feature set, and the sort of things you can do with it.

Want to get started right away? Head on over to https://getcrest.app and sign up for an account.

Okay, so why does Crest exist?

The short answer, is that it offers features that you can’t get anywhere else. The longer answer involves a short story…

My fiancée has been an Etsy seller for years. Through a lot of time and effort, she has risen to the ranks of the top 1% of Etsy sellers. However, despite this achievement, she still often felt in the dark about her customers. She didn’t know where she sold her highest priced items or where she should invest her marketing budget when it came to location.

After consulting the Etsy developer platform, I realised I could build an app for her that would provide some insight. As this app began to take shape, ideas for improvements and features started flowing. Pretty quickly, we realised that this was a tool that other sellers would kill for. So we polished it up, added a few more bells and whistles, then shipped it!

How exactly does Crest work?

At its core, Crest connects with Etsy and imports your shop data (listings, orders and transactions). We then examine the customer addresses for each order and perform geolocation (a fancy term for separating an address into its constituent parts — city, state, country etc.)

Once that’s done, we synchronise anything that might change (once per hour) to ensure that you have the latest information.

The shop manager / importing data from Etsy

So, why is that important?

Well, firstly, because we’re importing / syncing every hour, when you’re using Crest it’s fast! If you’ve ever used other seller tools, then you know that when you make changes you have to wait anywhere from 30 seconds to a minute, or more, for the changes to be reflected.

That’s because these tools have to fetch the relevant data from Etsy every time, which is slow. By contrast, you won’t see any progress bars within Crest.

Secondly, addresses are not simple. Technically, all they need to do is satisfy the postal requirements of the origin country, but those requirements differ widely between nations. Take the following example:

Darlot, PERTH WA 6025, Australia.

There are abbreviations, numbers and street names that are not helpful. If you live in Australia, you might know what they mean, but if you don’t, then you probably won’t. Crest solves this problem by parsing and geolocating the address. We fill in the blanks, strip out anything that is unlikely to have any real value, and then finally convert it into a standard format...

Lansdale, Perth, Western Australia, Australia

Now we can begin to group your orders by country, state or province, county, city, and even district. When we do that, we can begin to learn a great deal!

What can I do with Crest?

Let’s begin by looking at the main dashboard. This pulls data from all of the shops that you’ve added to Crest. You can see the total numbers of listings and orders, revenue broken down by period, as well as activity (likes & views in the last 30 days). We also compare this data to the previous period so you can see if you’re doing better or worse.

The main Crest dashboard

Each shop has its own individual dashboard with statistics that are derived exclusively from its own data. These dashboards also include beautiful graphs that can be adjusted to different time periods.

Listings

When browsing through the listings for a shop, you’ll find critical information within each listing card including price, quantity, likes, views, as well as order count and total revenue. You can also filter the list by a range of criteria such as ID, title, section, date, status, price and quantity.

The listing manager

When clicking through to a specific listing, you’ll find a card that highlights how many purchases have been made from a specific country, allowing quick insight into the item’s popularity across the world.

The main card for a listing

Next, you’ll find a set of orders for the listing grouped by location, allowing you to see city, county, state and country information.

Orders by location for a listing

Finally, you’ll also find adjustable graphs for the listing’s likes and views.

Views for the listing in the last seven days

Orders

When browsing through a shop’s orders, you’ll find adjustable graphs for the orders over a certain period, as well as graphs for derived revenue. Further down, you’ll see the orders themselves, along with thumbnail icons for each listing item that was purchased. Customers that have made multiple purchases are easily spotted thanks to the gold stars next to their names.

The orders for the shop

Clicking through to an individual order allows you to see additional data about the transactions, as well as links to view the individual transactions on Etsy should you ever need to do so.

An individual order

So far, we’ve only seen some of the minor location power of Crest, now we’ll see just what its truly capable of by exploring its reporting tools.

Location Report

By far and way, the location report provides the most detailed insight into your orders by location. It allows you to drill down from a global level, all the way down to the districts of individual cities, making it very powerful.

At the world level, you’ll find a map that you can hover over. Each country will provide a tip indicating total number of orders and revenue. Further down, you’ll find the same information organised by highest values, as well as the average order spend from each country and a link to view listings that have been sold within each specific country.

Location report — world view

Clicking on a country, either on the map or list, will take you to the country view of the report. This page includes cards and graphs indicating number of orders and total revenue from the country for specific periods, as well as performance compared to the previous period.

Below that, you’ll see a breakdown of orders, revenue and average spend for each state, province or region within the country. You may also filter this list by period e.g. 24 hours, 7 days, 30 days, 6 months etc.

Location report — country view

You can continue to drill down further by clicking on a state, province or region. Crest will present you with similar views for orders and revenue by city, and when clicking again, by individual district.

At the district level, you will find the orders that have been made from there. As in the screenshot of the individual orders seen earlier on in this article, you will see thumbnails of the listings that were purchased.

Popular Report

This report allows you to identify your best selling listings. It displays the total number of times they have sold, as well as how much revenue has been derived from them. Initially, no filter is applied, however you can restrict the results to a country, state or even a city… want to know your best selling listing in San Francisco? With this report, it’s trivial to find out.

Popular report — filtered to the United States of America

Goal Report

This report allows you to set shop-specific targets for revenue, number of orders, and listing activity. By setting the desired figure and deadlines for each of these options, you are able to easily track your progress with helpful cards, graphs and ring progress bars.

Revenue target for a shop

Forecast Report

Crest is able to use your shop’s past activity over a period of 1, 2 or 4 years to generate a projection of orders, revenue and listing activity. It goes without saying that this is only a prediction and cannot ever be assumed to be exactly what will happen, however it can be useful to see where you may be heading.

Projection of revenue over the next 90 days

Marketing Report

Crest also includes a marketing / SEO report built upon Etsy’s ultimate guide to search. The report focuses on a listing’s title, description, tags, as well as a few miscellaneous items such as image count.

One particularly nice feature, is that each section of the report can be edited. The feedback provided will then update in real time. This allows you to instantly see whether the changes you make will address any issues.

Editing a listing’s title for SEO improvement

When you’ve made changes on Etsy, you can use the ‘Refresh listing’ menu option to import changes. There’s no need to wait for the next hourly update.

Event Calendar

Finally, Crest also features an events calendar drawn from many international countries including the United States, UK, France, Spain, Italy, Canada, Germany, China, Mexico and Australia. Knowing about these events can help you to plan your marketing / listing SEO for maximum exposure to customers.

The upcoming event schedule

Pricing

For just $12.99 per month, you’ll get access to the full set of features and can add up to 3 shops. You’ll also benefit from regular app updates and a chance to help set the direction for new features.

Ready to get started?

Head on over to Crest’s website and sign up for an account. Thanks so much for reading, and if you have any questions, feel free to get in touch!

Software developer. Most of the time, I’m working with PHP, Laravel, Vue and TailwindCSS.