How to Make a Benchmark

Yesterday I had the pleasure of teaching the first session of the new edition of Digital Marketing Course for Cultural Industries organized by the SDE (Servei and Business Development, the Catalan Institute of Cultural Industries).

This course consists of two parts, one aimed at discovering how it should be the website of a company dedicated to some kind of cultural industry and the other more properly dedicated to Digital Marketing part. At the beginning of this second part we saw 2 of the main techniques to attract visitors (SEO and the tools of Web 2.0). The other techniques will be discussed during today's class.

In my class yesterday one of the points we saw was the Benchmarking and explained to the students that can not be Marketing regardless of the market and therefore it is essential that we know what our position on the companies with which we compete or regarding companies similar to ours.

How to make a benchmark?

This requires defining the variables we want to analyze, to know what our position is based on these variables, see what the position of the competition, then, is ideal capture it all in a positioning map.

The variables that I propose in my classes are as follows:

Benchmark technical level:Ficha de competencia/benckmark

  • How many pages indexed in Google have a website? (: (Without quotation marks and domain name who wish to analyze) in Google this information looking for " site" is obtained).
  • What PageRank has a website? (Obtained from the Google toolbar, any SEO plugin or from an online tool).
  • How many pages are linking to the page you analyze? (I recommend obtaining these data from which offers).
  • What position does that website ranking in

Marketing Benchmark level:

  • What is the target audience for that enterprise and which segments attacks through its online communication?
  • What is your value proposition?
  • What Digital Marketing actions have detected that performs this company? (This can see watching who linkea to page [online news, blogs, directories ...] and looking for his name on Google [see social networking profiles, quotes, articles, etc.]).
  • What features we would highlight their website.

With this a good record for each of our competitors and also for our own company is obtained. And these data will help us know where we want to be, where we want to go and how we will do it.

The positioning map that I use is a graph showing bubble techniques 3 variables: the PageRank (the radius of the bubble), the position in the Alexa ranking (egComo hacer un benchmarkand abscissa) and the size of the page (vertical axis).

The attached image is of one of these maps, the other image corresponds to a record of competence (in this case corresponds to a theater).

Yesterday I promised the students would write this post and would hang up Excel I had created from the websites of some of the companies attending the class, so that you have sample and was not needed to start it from scratch (the graph it is complicated to make, the axis scales are logarithmic, the axes are reversed so that the best position appears on the top right, and definitely not a chart by selecting data from a table is displayed by pressing a button ... of Hence recommend students to use mine as a basis for their work).

Anyway ... here goes the Excel worksheet for creating the graphic benchmarking.
Excel Chart "How to Make a Benchmark"For you to base.

(If you do not see the graphic good or bubbles are not 3D is because you are using an older version of Excel. Although I have saved the file in .xls format so that everyone can open, you are actually created using the .xlsx )

I hope you find it useful and now already know cow do a good benchmark.

If you attended the event and want the full-slide of the entire course of Digital Marketing for Cultural Industries, recalls that shortly the SDE will send an email with a link to their servers from which you can download.

A hug.

Getting information on the profiles of visitors of a website

Things are changing on the internet and luckily, every time we learn more about the web pages you visit people and what behaviors and which profiles have the people who visit.

If we had so far few sites that actually offered information on visiting a website either, these last few months things are changing and we have really useful tools in estimating traffic on a website and when knowing the characteristics of people who visit this website.

Consider some of these new services:

The new Alexa: A principios de abril Alexa cambió su interface y pasó a proporcionar muchos más datos sobre las páginas que aparecen en su índice. Ahora por ejemplo, podemos saber hacia qué páginas navega la gente que sale de un site, o bien qué páginas traen tráfico a una página web. También por qué palabras se posiciona una página y las páginas que contienen links a ese site. Pero lo más interesante, aunque no lo ofrece para todas las páginas es información sobre las vistas (edad, sexo, nivel formativo, lugar desde el que se conectan, etc.) Toda esta información la obtiene del registro que la gente rellena al descargarse la barra de Alexa. Aquí podemos ver, por ejemplo, el perfil demográfico de las visitas de Softonic:

Quantcast: La información que provee Quantcast es parecida a la de Alexa pero más completa, por ejemplo, podemos obtener información sobre la raza de las visitas, si hay niños que visitan el portal, el nivel de ingresos de las visitas, etc… Quantcast funciona sobre todo para Estados Unidos. Para ofrecer datos fiables Quantcast invita a los sites a que instalen un pequeño código en sus páginas que a su vez instala una cookie en los usuarios y que permite realizar el seguimiento de su navegación en los sites que Quantcast tiene asociados y una estimación para los que no tiene asociados. Esta es la ficha para Softonic en Quantcast (Softonic no es un site asociado, pero aún así la información es realmente interesante):

Compete: This is a really interesting service. It works much like Alexa and also uses a bar to collect data from users' browsing a website, but also use American ISP logs to know which people visit and how. And other data services using American ISP, the data provided are unrealistic for Spanish sites, yet, here we can see the tab Softonic:

Google Ad PlannerThis is a new Google service that serves agencies can plan campaigns on sites associated with Google, but also provides information on sites that are not. The information is not as detailed as in previous cases, but at least provides information that until now could not access. All plans can be made for different countries and Spain is one of them.

The four services are interesting both when performing a benchmark positioning of a site (especially if the site is international), as well as when planning an advertising campaign taking into account the demographic characteristics of the target audience of the campaign.