The Daily Sales Report – part 2 (at last!)

Posted on Abril 26th, 2007 in Comentarios y opiniones,Web Analytics by mike

In part 1 of this little trilogy I looked at why the daily sales report should be an essential part of your online business. Some of you will say that I was a little “e-commerce” orientated in the last post and you’d be right. I am no expert in the more content related areas of online measurement, but i am learning. Perhaps i’ll adapt this post in the future to focus on non e-commerce areas.

So onto part 2. This is all about the “what” of the DSR. What are the key performance indicators (KPI’s) that should be included. And how to you set up the report to make an anaysis of the data.

Less is more

Some important/critical points to remember:

  • this is NOT a competition of how many KPI’s you can get onto a spreadsheet or email
  • this IS about selecting the KPI’s that best reflect success or failure

Ask yourself why you are in business. What are the KPI’s that measure absolute success and failure. Look at your targets and objectives and translate these into the KPI’s that you report daily. And if you don’t work in a numbers and results orientated business yet, when the boss sees that you are reporting important data, and only important data, then you will likely see a huge change in philosophy.

Important KPI’s for e-comm business

I have worked in a few e-comm businesses and have (mostly) based my daily sales report on roughly the same stuff. First the raw data:

  • Unique users/visitors – how many people came to the site
  • Visits – how many visits (or user sessions) were there
  • Buyers – how many people (unique ones) actually bought from the site
  • Revenue – what was the value of sales you made
  • Sales transactions – how many transactions were made
  • Units sold – how many distinct units (number of apples or whatever) were sold

(For hotel sites, for instance, you might add total room nights sold, or booking window here as well, for sites selling CD’s a total number of CD’s might be essential)

Then some relevant calculations:

  • Revenue per transaction
  • Revenue per buyer
  • Visits per visitor
  • Visits (sales) conversion rate (transactions/total visits)
  • Visitor (sales) conversion rate (buyers/visitors)

For most e-comm businesses there is little else that you actually need to measure at this “high” level.

As a side note, I suggest you read an excellent summary of why to measure the two sales conversion rates by Eric T Peterson. His post “On visits and visitors…” is a fantastic analysis of the differences between the two metrics and why both are critical.

Analysis

Lastly, for this post anyway, a little bit of what analysis to do with your raw data and calculations. In my DSR i always present information in an analytical form. This means listing the critical daily figures, and then comparing them to the same day last week (both as data and in % change terms). Also I try and give some trends to the data by giving average 7, 15 and 30 day run rates for the most important numbers. This means the reader gets a good idea of whether the trend is up, down or stable.

Next week a little on the process of the DSR, plus a sample DSR to download.

The importance of the Daily Sales Report – part 1

Posted on Abril 6th, 2007 in Comentarios y opiniones,Web Analytics by mike

The daily sales report (DSR) is such an important part of running an online business that I am going to dedicate a few posts this subject (3 in fact). I hope that you are already dying to know not just what a daily sales report is, but what it should contain, why it`s important, and how to apply it to your online business. Plus, as a bonus for visiting our humble blog, I will provide a link to download a workable example of a DSR in the final post. All your Christmases at once!

So, what is a daily sales report?
Actually the daily sales report, in various guises, has been around for ever in retail organisations. For the online business manager though, I would define the DSR as:

A way of pushing your most important key performance indicators ( KPI’s), in an understandable way, at every manager, team member and stakeholder in your online business.

The DSR should contain elements of sales data, web usage data, and analysis. In its final form it is most likely to be an email contain a simple summary of a KPI spreadsheet, sent to anybody that you think should have an interest, including the boss and the boss`s boss. (No-one ever got fired for sending out well organised and interesting information after all). It should contain the benchmarks for the business, the numbers that operate as the final check on success or failure. And if done properly it should provide a focus, a challenge, an incentive and a way to motivate.

Why is it important?
Perhaps this is a basic for doing business, but I have been involved with plenty of businesses that don’t do this. It is my clear experience that companies that do not partake in this basic are also the ones where the management can’t answer simple questions about the performance of their business. This leads to a complete lack of appreciation of analytics generally, followed by a lack of appreciation in marketing optimisation and development ROI, followed by a………You get the point, its not good!

So the daily sales report is important because:

  • It gives you complete understanding of whether a day has been good, bad or indifferent, because you see the data EVERYDAY and can follow the trends
  • It PUSHES web analytics data in the faces of management and business teams; it makes EVERYONE better understand the critical metrics and have a better appreciation of web analytics generally
  • When people receive this data, they talk about it. This means that they understand better their place in affecting results – and consequently makes them responsible for driving KPI’s in the right direction
  • It allows you to report the metrics that are important to you, not only the metrics that the management believes are important. This means that perhaps you’ll be able to ask for a bigger investment come budget time

Starting something basic like the DSR means that the next stage is always more comprehensive. For anybody struggling to gain traction with their web analytics programme, this is an essential, and might just give you the promotion you need to start expanding your capabilities.

The power of motivation
One of the great things that I experienced when working at Expedia was that nothing was ever done without a deep understanding of the metrics. This culture existed all the way through the business, but was manifested most clearly in the “flagging” of records. Each and every day where a sales record (number of sales or revenue) was recorded for any part of the business a red flag would appear on the daily report. This was as true for the small business units as it was for Expedia.com.

It becomes addictive to try and achieve a record, and this is tremendously motivational. In this way web analytics, through the daily sales report, can directly influence the way that people feel about their jobs. This is the best part of the daily sales report in my opinion.

Next week, part 2, what are the KPI’s and presentation elements that should be included in the DSR.

¿Cómo medir correctamente los resultados de SEO?

Posted on Abril 2nd, 2007 in Comentarios y opiniones by nando

Una de las grandes discusiones o problemáticas al hablar de resultados en SEO, es su correcta interpretación y medición; sobretodo cuando se trata de sitios web que tienen unos niveles de tráfico bastante elevados o gran número de páginas web.

Generalmente, una de las primeras cosas que se le pide a la persona responsable del posicionamiento en buscadores, es aparecer en las primeras posiciones de las páginas de resultados por unos términos en partícular, sin llegar a analizar la dificultad y el coste que implica conseguir esos resultados.

Una de las consultas más repetitivas que me han llegado durante estos años es del tipo:

Ayer estuve buscando XXXX en Google y nuestro sitio web no aparecía, mientras que los de la competencia si que estaban

Por tanto, podríamos decir que el valor de un buen proyecto de posicionamiento, estaría medido inicialmente por la consecución de unos resultados concretos en las páginas de resultados.

Cuando uno se va adentrando en todo lo que es y significa el marketing en buscadores, puede ver que esta medición de resultados por posiciones conseguidas es totalmente errónea, ya que la manera correcta de medir las acciones de posicionamiento en buscadores deberán estar basadas en cálculos basados en:

  • Incremento del tráfico que proviene de buscadores
  • Porcentaje de conversión de las visitas que provienen de los buscadores
  • Volumen de ventas que se han generado
  • Retorno de inversión de las acciones de posicionamiento
  • Presencia del sitio web en los buscadores

Como se puede observar, antes de medir la posición de una página web (y sobretodo, como se ha conseguido esa posición), es importante tener en cuenta si las acciones que se están llevando a cabo están consiguiendo incrementar el volumen de tráfico que llega a nuestra página web; así como la calidad de ese tráfico a la hora de conseguir generar ventas.

El retorno de la inversión es otro punto de importancia, ya que si después de realizar una inversión de cierto dinero para conseguir mejorar la página web para que los buscadores puedan encontrar más fácilmente el contenido, no se consigue recuperar la inversión; será mejor que empecemos a revisar lo que está pasando y si las palabras escogidas son las adecuadas, ya que iremos camino de la ruina.

Finalmente, si que revisaremos las posiciones conseguidas en los buscadores, pero no sólo la posición en si misma, sino la manera en como se ha conseguido, ya que si la presencia que tiene nuestra página web en la página de resultados del buscador no refleja nuestra marca y sus activos, el posicionamiento en buscadores estará en plena batalla con las directrices de marketing, causando un grave perjuicio.

Finalmente me gustaría destacar que, el posicionamiento en buscadores, es más que algunas técnicas para destacar el contenido de la página y conseguir aparecer en los resultados de los buscadores, sino que es una de las principales herramientas de marketing online para generar tráfico cualificado hacia la página web, y que en función de como se lleve a cabo, puede provocar grandes beneficios o pérdidas.

Related Posts with Thumbnails