TPL_SIDE_BAR

22°C

Blog de Marketing y Diseño Web de Código SEO

6 minutos de lectura ( 1238 palabras)

Cómo medir el ROI de las campañas en redes sociales

Medicion-del-ROI

Una de las preguntas más comunes entre las empresas que invierten en marketing digital es: ¿Cómo puedo medir el retorno de inversión (ROI) de mis campañas en redes sociales? Medir el ROI es fundamental para determinar si el esfuerzo, tiempo y dinero que destinas a tus campañas está generando los resultados deseados. Sin embargo, el cálculo puede ser complicado, ya que las redes sociales no solo impulsan ventas directas, sino también la interacción, reconocimiento de marca y fidelización de clientes.

En este artículo, te explicamos de manera sencilla cómo medir el ROI de tus campañas en redes sociales y cómo asegurarte de que tu inversión esté dando frutos.

¿Qué es el ROI?

El retorno de inversión (ROI) es una métrica que permite evaluar la rentabilidad de una campaña en función del dinero que se invirtió. La fórmula básica para calcularlo es:

ROI=(Ingresosgenerados−Inversioón)×100 / Inversión ROI = \frac{(Ingresos generados - Inversión) \times 100}{Inversión}ROI=Inversión(IngresosgeneradosInversn)×100

Este cálculo proporciona un porcentaje que indica el beneficio que has obtenido en relación con lo que has gastado. Si el resultado es positivo, tu campaña fue rentable; si es negativo, significa que perdiste dinero.

La importancia de medir el ROI en redes sociales

Medir el ROI en redes sociales es crucial por varias razones:

  • Evaluar el éxito: Te ayuda a determinar si tus esfuerzos en redes sociales están funcionando como esperabas.
  • Optimización: Si identificas qué campañas o tácticas generan un mayor retorno, puedes ajustar tu estrategia para enfocarte en ellas.
  • Justificación de la inversión: Si necesitas justificar ante tu equipo o tus superiores la inversión en redes sociales, el ROI te proporciona cifras concretas.
¿Qué se puede medir en una campaña de redes sociales?

Antes de sumergirnos en los pasos para calcular el ROI, es importante entender que no todo el impacto de las redes sociales se traduce en ingresos directos. Las redes sociales generan varios tipos de valor, como:

  • Ventas directas: Conversiones que resultan directamente de una interacción en redes sociales.
  • Reconocimiento de marca: El valor que aportan las impresiones y la visibilidad.
  • Interacción: Likes, comentarios, compartidos y retuits que contribuyen al engagement de tu marca.
  • Fidelización de clientes: Las redes sociales pueden ayudar a mejorar la lealtad del cliente y las relaciones a largo plazo.

Para calcular el ROI de una campaña, es fundamental que definas qué tipo de valor estás midiendo. En la mayoría de los casos, el ROI se mide a partir de las conversiones y las ventas, pero también puedes establecer métricas de éxito basadas en el crecimiento de seguidores, el reconocimiento de marca o el tráfico a tu sitio web.

Pasos para medir el ROI de las campañas en redes sociales

A continuación, te explicamos los pasos básicos para medir el ROI de tus campañas en redes sociales.

1. Establecer objetivos claros

El primer paso para medir el ROI es establecer objetivos concretos y medibles. Sin objetivos claros, es difícil evaluar si una campaña fue exitosa o no. Algunos ejemplos de objetivos pueden ser:

  • Aumentar las ventas: Este es un objetivo común para las empresas que utilizan redes sociales para impulsar sus productos o servicios.
  • Generar tráfico a tu sitio web: Puedes medir cuántos usuarios hacen clic en los enlaces de tus publicaciones para visitar tu página.
  • Incrementar el engagement: Aumentar los likes, comentarios y compartidos puede ser un objetivo si buscas mejorar la interacción con tu audiencia.
  • Capturar leads: Si tu campaña está diseñada para recopilar datos de clientes potenciales, este sería un objetivo medible.

Recuerda que estos objetivos deben ser SMART (específicos, medibles, alcanzables, relevantes y con un tiempo determinado).

2. Rastrear métricas clave

Para medir el ROI, debes rastrear las métricas que te ayudarán a cumplir los objetivos establecidos. Algunas de las métricas más comunes en redes sociales son:

  • CTR (Click-Through Rate): Porcentaje de usuarios que hicieron clic en un enlace en comparación con el total de usuarios que vieron la publicación.
  • Conversiones: Número de acciones completadas (ventas, registros, suscripciones) generadas a partir de una campaña.
  • Engagement: Número total de interacciones (likes, comentarios, compartidos) dividido por el número de impresiones.
  • CPC (Costo por clic): Costo promedio que pagas por cada clic en tus anuncios.
  • Costo por conversión: El costo total de la campaña dividido por el número de conversiones generadas.
Herramientas para medir el ROI en redes sociales

Afortunadamente, existen varias herramientas que te ayudan a rastrear las métricas de tus campañas en redes sociales. Las más populares son:

1. Google Analytics

Google Analytics es una de las herramientas más potentes para medir el rendimiento de las redes sociales. Con él, puedes rastrear el tráfico que llega a tu sitio web desde redes sociales, las conversiones generadas y el comportamiento de los usuarios en tu página. Para medir el ROI, debes configurar el seguimiento de objetivos en Google Analytics, como ventas o registros.

2. Facebook Ads Manager

Si realizas campañas pagadas en Facebook o Instagram, Facebook Ads Manager te permite ver métricas detalladas sobre el rendimiento de tus anuncios, como clics, impresiones, conversiones y costo por conversión. También te permite configurar píxeles de seguimiento, que te ayudan a rastrear el comportamiento de los usuarios después de hacer clic en tus anuncios.

3. Hootsuite o Buffer

Herramientas como Hootsuite y Buffer te permiten programar publicaciones y rastrear el rendimiento de tus campañas orgánicas. Puedes ver el engagement de tus publicaciones, el crecimiento de seguidores y el tráfico que generan a tu sitio web.

Calcular el ROI en ventas

El cálculo más directo del ROI proviene de las ventas generadas directamente por una campaña. Si has invertido $500 en una campaña y generaste $1,500 en ventas gracias a esa campaña, el cálculo sería:

ROI=(1500−500)×100500=200%ROI = \frac{(1500 - 500) \times 100}{500} = 200\%ROI=500(1500500)×100=200%

Esto significa que has obtenido un retorno del 200%, lo que indica que tu campaña fue altamente rentable.

Calcular el ROI en base a otros valores

No todas las campañas de redes sociales se enfocan en generar ventas inmediatas. Algunas tienen como objetivo mejorar el reconocimiento de marca o el engagement. Para calcular el ROI en estos casos, puedes asignar un valor monetario a estos resultados. Por ejemplo, puedes calcular cuánto te costaría conseguir la misma visibilidad o interacción a través de otros medios publicitarios y compararlo con lo que has invertido en redes sociales.

Optimización del ROI

Medir el ROI no es suficiente. Debes usar los datos para optimizar tus futuras campañas. Si notas que ciertos anuncios o tipos de contenido generan más conversiones o engagement, ajusta tu estrategia para centrarte en ellos. De igual forma, si una plataforma no te está dando los resultados esperados, considera reducir tu inversión en ella y probar nuevas estrategias.

Conclusión

Medir el ROI de tus campañas en redes sociales es esencial para saber si tu inversión está generando resultados. Al establecer objetivos claros, rastrear las métricas correctas y utilizar herramientas adecuadas, puedes obtener una visión precisa de cómo tus campañas impactan en tu negocio.

En codigoseo.com, te ayudamos a medir y mejorar el rendimiento de tus campañas en redes sociales. Con nuestra experiencia en marketing digital y análisis de datos, aseguramos que cada dólar que inviertes en redes sociales se traduzca en resultados medibles y significativos. ¡Contáctanos para optimizar tus campañas hoy mismo! 

    
×
Mantente Informado

Al suscribirte al blog te enviaremos un correo electrónico cuando haya nuevas actualizaciones en el sitio para que no te las pierdas.

Estrategias para crecer una comunidad en redes soc...
Cómo segmentar audiencias en campañas de redes soc...

Artículos relacionados

 

Al aceptar, accederá a un servicio proporcionado por un tercero externo a https://codigoseo.com/

Buscar en el Blog

Calendario de Artículos

Espera un minuto, mientras que estamos haciendo el calendario
0
Compartidos
60.881MBMemory Usage1.11sRequest Duration
Joomla! Version5.1.4
PHP Version8.1.32
Identityguest
Response200
Templateja_company
Database
Server
mysql
Version
8.0.41
Collation
utf8mb4_0900_ai_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:59 [ "USER" => "seo" "HOME" => "/home/seo" "SCRIPT_NAME" => "/index.php" "REQUEST_URI"...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744207117 "last" => 1744207117...
registry
array:3 [ "data" => array:1 [ "com_ampz" => array:1 [ "shortcodes" => array:2 [ ...
user
array:21 [ "id" => 0 "name" => "" "username" => null "email" => "" "password" => "***redac...
6360f8ed2b20c32cfb3eb0c4eb579c40
1
  • afterLoad (3.53MB) (25.07ms)
  • afterInitialise (19.41MB) (216ms)
  • afterRoute (11.65MB) (95.06ms)
  • beforeRenderComponent com_easyblog (12.79KB) (513μs)
  • Before Access::preloadComponents (all components) (160.64KB) (1.23ms)
  • After Access::preloadComponents (all components) (188.81KB) (1.05ms)
  • Before Access::getAssetRules (id:1 name:root.1) (4.04KB) (21μs)
  • After Access::getAssetRules (id:1 name:root.1) (27.21KB) (298μs)
  • beforeRenderModule mod_stackideas_toolbar (StackIdeas Toolbar) (18.74MB) (332ms)
  • afterRenderRawModule mod_stackideas_toolbar (StackIdeas Toolbar) (1018.94KB) (19.83ms)
  • beforeRenderModule mod_stackideas_toolbar (StackIdeas Toolbar) (736B) (11μs)
  • afterRenderModule mod_stackideas_toolbar (StackIdeas Toolbar) (197.46KB) (1.34ms)
  • afterRenderComponent com_easyblog (161.48KB) (549μs)
  • afterDispatch (75.81KB) (34.11ms)
  • beforeRenderModule mod_footer (Footer) (510.24KB) (4.4ms)
  • afterRenderRawModule mod_footer (Footer) (17.71KB) (2.26ms)
  • beforeRenderModule mod_footer (Footer) (704B) (10μs)
  • afterRenderModule mod_footer (Footer) (4.3KB) (215μs)
  • beforeRenderModule mod_djmegamenu (Redes Sociales) (33.77KB) (264μs)
  • afterRenderRawModule mod_djmegamenu (Redes Sociales) (185.33KB) (4.35ms)
  • beforeRenderModule mod_djmegamenu (Redes Sociales) (720B) (8μs)
  • afterRenderModule mod_djmegamenu (Redes Sociales) (2.02KB) (159μs)
  • beforeRenderModule mod_custom (Footer 3) (23.95KB) (31μs)
  • afterRenderRawModule mod_custom (Footer 3) (9.13KB) (1.83ms)
  • beforeRenderModule mod_custom (Footer 3) (720B) (10μs)
  • afterRenderModule mod_custom (Footer 3) (1.91KB) (160μs)
  • beforeRenderModule mod_page_qr_code (Código QR) (2.4KB) (76μs)
  • afterRenderRawModule mod_page_qr_code (Código QR) (54.27KB) (10.42ms)
  • beforeRenderModule mod_page_qr_code (Código QR) (720B) (10μs)
  • afterRenderModule mod_page_qr_code (Código QR) (5.77KB) (167μs)
  • beforeRenderModule mod_djmegamenu (Otros Enlaces) (23.52KB) (113μs)
  • afterRenderRawModule mod_djmegamenu (Otros Enlaces) (111.13KB) (3.74ms)
  • beforeRenderModule mod_djmegamenu (Otros Enlaces) (720B) (7μs)
  • afterRenderModule mod_djmegamenu (Otros Enlaces) (4.27KB) (133μs)
  • beforeRenderModule mod_djmegamenu (Enlaces de Interés) (200B) (92μs)
  • afterRenderRawModule mod_djmegamenu (Enlaces de Interés) (281.3KB) (4.38ms)
  • beforeRenderModule mod_djmegamenu (Enlaces de Interés) (720B) (7μs)
  • afterRenderModule mod_djmegamenu (Enlaces de Interés) (1.77KB) (134μs)
  • beforeRenderModule mod_custom (Footer logo) (23.59KB) (73μs)
  • afterRenderRawModule mod_custom (Footer logo) (976B) (137μs)
  • beforeRenderModule mod_custom (Footer logo) (720B) (5μs)
  • afterRenderModule mod_custom (Footer logo) (1.89KB) (117μs)
  • beforeRenderModule mod_acym (Boletín de Noticias) (4.94KB) (31μs)
  • afterRenderRawModule mod_acym (Boletín de Noticias) (379.46KB) (4.15ms)
  • beforeRenderModule mod_acym (Boletín de Noticias) (720B) (7μs)
  • afterRenderModule mod_acym (Boletín de Noticias) (1.77KB) (136μs)
  • beforeRenderModule mod_easyblogsearch (Buscar en el Blog) (968B) (61μs)
  • afterRenderRawModule mod_easyblogsearch (Buscar en el Blog) (78.22KB) (2.89ms)
  • beforeRenderModule mod_easyblogsearch (Buscar en el Blog) (736B) (10μs)
  • afterRenderModule mod_easyblogsearch (Buscar en el Blog) (1.91KB) (155μs)
  • beforeRenderModule mod_easyblogcategories (Categorías) (656B) (27μs)
  • afterRenderRawModule mod_easyblogcategories (Categorías) (372.71KB) (19.92ms)
  • beforeRenderModule mod_easyblogcategories (Categorías) (720B) (10μs)
  • afterRenderModule mod_easyblogcategories (Categorías) (1.77KB) (169μs)
  • beforeRenderModule mod_banners (Anuncio Google Blog) (13.38KB) (38μs)
  • afterRenderRawModule mod_banners (Anuncio Google Blog) (249.44KB) (102ms)
  • beforeRenderModule mod_banners (Anuncio Google Blog) (704B) (10μs)
  • afterRenderModule mod_banners (Anuncio Google Blog) (1.77KB) (177μs)
  • beforeRenderModule mod_easyblogcalendar (Calendario de Artículos) (3.41KB) (28μs)
  • afterRenderRawModule mod_easyblogcalendar (Calendario de Artículos) (5.55KB) (1.38ms)
  • beforeRenderModule mod_easyblogcalendar (Calendario de Artículos) (736B) (9μs)
  • afterRenderModule mod_easyblogcalendar (Calendario de Artículos) (2.03KB) (156μs)
  • beforeRenderModule mod_easyblogmostpopularpost (+Populares) (6.39KB) (42μs)
  • afterRenderRawModule mod_easyblogmostpopularpost (+Populares) (34.55KB) (2.32ms)
  • beforeRenderModule mod_easyblogmostpopularpost (+Populares) (736B) (10μs)
  • afterRenderModule mod_easyblogmostpopularpost (+Populares) (12.73KB) (199μs)
  • beforeRenderModule mod_easyblogtagcloud (Etiquetas) (5.05KB) (31μs)
  • afterRenderRawModule mod_easyblogtagcloud (Etiquetas) (424.38KB) (24.23ms)
  • beforeRenderModule mod_easyblogtagcloud (Etiquetas) (720B) (10μs)
  • afterRenderModule mod_easyblogtagcloud (Etiquetas) (1.77KB) (163μs)
  • beforeRenderModule mod_custom (Acceso Clientes) (3.46KB) (79μs)
  • afterRenderRawModule mod_custom (Acceso Clientes) (1008B) (159μs)
  • beforeRenderModule mod_custom (Acceso Clientes) (720B) (6μs)
  • afterRenderModule mod_custom (Acceso Clientes) (1.73KB) (111μs)
  • beforeRenderModule mod_whatsapppremium (Whatsapp Premium) (6.48KB) (38μs)
  • afterRenderRawModule mod_whatsapppremium (Whatsapp Premium) (21.31KB) (2.1ms)
  • beforeRenderModule mod_whatsapppremium (Whatsapp Premium) (736B) (11μs)
  • afterRenderModule mod_whatsapppremium (Whatsapp Premium) (1.74KB) (148μs)
  • beforeRenderModule mod_menu (Main Menu) (4.11KB) (86μs)
  • afterRenderRawModule mod_menu (Main Menu) (140.37KB) (5.19ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (10μs)
  • afterRenderModule mod_menu (Main Menu) (1.97KB) (159μs)
  • beforeRenderModule mod_banners (Anuncio) (1016B) (78μs)
  • afterRenderRawModule mod_banners (Anuncio) (95.71KB) (90.6ms)
  • beforeRenderModule mod_banners (Anuncio) (704B) (9μs)
  • afterRenderModule mod_banners (Anuncio) (1.71KB) (130μs)
  • beforeRenderModule mod_jux_weather_forecast (El Clima) (1.59KB) (81μs)
  • afterRenderRawModule mod_jux_weather_forecast (El Clima) (52.2KB) (39.3ms)
  • beforeRenderModule mod_jux_weather_forecast (El Clima) (720B) (13μs)
  • afterRenderModule mod_jux_weather_forecast (El Clima) (1.73KB) (209μs)
  • beforeRenderModule mod_custom ([Topbar-left] Slogan) (3.07KB) (120μs)
  • afterRenderRawModule mod_custom ([Topbar-left] Slogan) (976B) (184μs)
  • beforeRenderModule mod_custom ([Topbar-left] Slogan) (720B) (6μs)
  • afterRenderModule mod_custom ([Topbar-left] Slogan) (1.73KB) (113μs)
  • afterRender (2.02MB) (46.39ms)
  • 1 x beforeRenderModule mod_stackideas_toolbar (StackIdeas Toolbar) (18.74MB) (30.04%)
    332ms
    1 x afterInitialise (19.41MB) (19.49%)
    216ms
    1 x afterRenderRawModule mod_banners (Anuncio Google Blog) (249.44KB) (9.21%)
    102ms
    1 x afterRoute (11.65MB) (8.59%)
    95.06ms
    1 x afterRenderRawModule mod_banners (Anuncio) (95.71KB) (8.19%)
    90.60ms
    1 x afterRender (2.02MB) (4.19%)
    46.39ms
    1 x afterRenderRawModule mod_jux_weather_forecast (El Clima) (52.2KB) (3.55%)
    39.30ms
    1 x afterDispatch (75.81KB) (3.08%)
    34.11ms
    1 x afterLoad (3.53MB) (2.27%)
    25.07ms
    1 x afterRenderRawModule mod_easyblogtagcloud (Etiquetas) (424.38KB) (2.19%)
    24.23ms
    1 x afterRenderRawModule mod_easyblogcategories (Categorías) (372.71KB) (1.8%)
    19.92ms
    1 x afterRenderRawModule mod_stackideas_toolbar (StackIdeas Toolbar) (1018.94KB) (1.79%)
    19.83ms
    1 x afterRenderRawModule mod_page_qr_code (Código QR) (54.27KB) (0.94%)
    10.42ms
    1 x afterRenderRawModule mod_menu (Main Menu) (140.37KB) (0.47%)
    5.19ms
    1 x beforeRenderModule mod_footer (Footer) (510.24KB) (0.4%)
    4.40ms
    1 x afterRenderRawModule mod_djmegamenu (Enlaces de Interés) (281.3KB) (0.4%)
    4.38ms
    1 x afterRenderRawModule mod_djmegamenu (Redes Sociales) (185.33KB) (0.39%)
    4.35ms
    1 x afterRenderRawModule mod_acym (Boletín de Noticias) (379.46KB) (0.38%)
    4.15ms
    1 x afterRenderRawModule mod_djmegamenu (Otros Enlaces) (111.13KB) (0.34%)
    3.74ms
    1 x afterRenderRawModule mod_easyblogsearch (Buscar en el Blog) (78.22KB) (0.26%)
    2.89ms
    1 x afterRenderRawModule mod_easyblogmostpopularpost (+Populares) (34.55KB) (0.21%)
    2.32ms
    1 x afterRenderRawModule mod_footer (Footer) (17.71KB) (0.2%)
    2.26ms
    1 x afterRenderRawModule mod_whatsapppremium (Whatsapp Premium) (21.31KB) (0.19%)
    2.10ms
    1 x afterRenderRawModule mod_custom (Footer 3) (9.13KB) (0.16%)
    1.83ms
    1 x afterRenderRawModule mod_easyblogcalendar (Calendario de Artículos) (5.55KB) (0.12%)
    1.38ms
    1 x afterRenderModule mod_stackideas_toolbar (StackIdeas Toolbar) (197.46KB) (0.12%)
    1.34ms
    1 x Before Access::preloadComponents (all components) (160.64KB) (0.11%)
    1.23ms
    1 x After Access::preloadComponents (all components) (188.81KB) (0.09%)
    1.05ms
    1 x afterRenderComponent com_easyblog (161.48KB) (0.05%)
    549μs
    1 x beforeRenderComponent com_easyblog (12.79KB) (0.05%)
    513μs
    1 x After Access::getAssetRules (id:1 name:root.1) (27.21KB) (0.03%)
    298μs
    1 x beforeRenderModule mod_djmegamenu (Redes Sociales) (33.77KB) (0.02%)
    264μs
    1 x afterRenderModule mod_footer (Footer) (4.3KB) (0.02%)
    215μs
    1 x afterRenderModule mod_jux_weather_forecast (El Clima) (1.73KB) (0.02%)
    209μs
    1 x afterRenderModule mod_easyblogmostpopularpost (+Populares) (12.73KB) (0.02%)
    199μs
    1 x afterRenderRawModule mod_custom ([Topbar-left] Slogan) (976B) (0.02%)
    184μs
    1 x afterRenderModule mod_banners (Anuncio Google Blog) (1.77KB) (0.02%)
    177μs
    1 x afterRenderModule mod_easyblogcategories (Categorías) (1.77KB) (0.02%)
    169μs
    1 x afterRenderModule mod_page_qr_code (Código QR) (5.77KB) (0.02%)
    167μs
    1 x afterRenderModule mod_easyblogtagcloud (Etiquetas) (1.77KB) (0.01%)
    163μs
    1 x afterRenderModule mod_custom (Footer 3) (1.91KB) (0.01%)
    160μs
    1 x afterRenderModule mod_djmegamenu (Redes Sociales) (2.02KB) (0.01%)
    159μs
    1 x afterRenderModule mod_menu (Main Menu) (1.97KB) (0.01%)
    159μs
    1 x afterRenderRawModule mod_custom (Acceso Clientes) (1008B) (0.01%)
    159μs
    1 x afterRenderModule mod_easyblogcalendar (Calendario de Artículos) (2.03KB) (0.01%)
    156μs
    1 x afterRenderModule mod_easyblogsearch (Buscar en el Blog) (1.91KB) (0.01%)
    155μs
    1 x afterRenderModule mod_whatsapppremium (Whatsapp Premium) (1.74KB) (0.01%)
    148μs
    1 x afterRenderRawModule mod_custom (Footer logo) (976B) (0.01%)
    137μs
    1 x afterRenderModule mod_acym (Boletín de Noticias) (1.77KB) (0.01%)
    136μs
    1 x afterRenderModule mod_djmegamenu (Enlaces de Interés) (1.77KB) (0.01%)
    134μs
    1 x afterRenderModule mod_djmegamenu (Otros Enlaces) (4.27KB) (0.01%)
    133μs
    1 x afterRenderModule mod_banners (Anuncio) (1.71KB) (0.01%)
    130μs
    1 x beforeRenderModule mod_custom ([Topbar-left] Slogan) (3.07KB) (0.01%)
    120μs
    1 x afterRenderModule mod_custom (Footer logo) (1.89KB) (0.01%)
    117μs
    1 x beforeRenderModule mod_djmegamenu (Otros Enlaces) (23.52KB) (0.01%)
    113μs
    1 x afterRenderModule mod_custom ([Topbar-left] Slogan) (1.73KB) (0.01%)
    113μs
    1 x afterRenderModule mod_custom (Acceso Clientes) (1.73KB) (0.01%)
    111μs
    1 x beforeRenderModule mod_djmegamenu (Enlaces de Interés) (200B) (0.01%)
    92μs
    1 x beforeRenderModule mod_menu (Main Menu) (4.11KB) (0.01%)
    86μs
    1 x beforeRenderModule mod_jux_weather_forecast (El Clima) (1.59KB) (0.01%)
    81μs
    1 x beforeRenderModule mod_custom (Acceso Clientes) (3.46KB) (0.01%)
    79μs
    1 x beforeRenderModule mod_banners (Anuncio) (1016B) (0.01%)
    78μs
    1 x beforeRenderModule mod_page_qr_code (Código QR) (2.4KB) (0.01%)
    76μs
    1 x beforeRenderModule mod_custom (Footer logo) (23.59KB) (0.01%)
    73μs
    1 x beforeRenderModule mod_easyblogsearch (Buscar en el Blog) (968B) (0.01%)
    61μs
    1 x beforeRenderModule mod_easyblogmostpopularpost (+Populares) (6.39KB) (0%)
    42μs
    1 x beforeRenderModule mod_banners (Anuncio Google Blog) (13.38KB) (0%)
    38μs
    1 x beforeRenderModule mod_whatsapppremium (Whatsapp Premium) (6.48KB) (0%)
    38μs
    1 x beforeRenderModule mod_custom (Footer 3) (23.95KB) (0%)
    31μs
    1 x beforeRenderModule mod_acym (Boletín de Noticias) (4.94KB) (0%)
    31μs
    1 x beforeRenderModule mod_easyblogtagcloud (Etiquetas) (5.05KB) (0%)
    31μs
    1 x beforeRenderModule mod_easyblogcalendar (Calendario de Artículos) (3.41KB) (0%)
    28μs
    1 x beforeRenderModule mod_easyblogcategories (Categorías) (656B) (0%)
    27μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (4.04KB) (0%)
    21μs
    1 x beforeRenderModule mod_jux_weather_forecast (El Clima) (720B) (0%)
    13μs
    1 x beforeRenderModule mod_stackideas_toolbar (StackIdeas Toolbar) (736B) (0%)
    11μs
    1 x beforeRenderModule mod_whatsapppremium (Whatsapp Premium) (736B) (0%)
    11μs
    1 x beforeRenderModule mod_footer (Footer) (704B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Footer 3) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_page_qr_code (Código QR) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_easyblogsearch (Buscar en el Blog) (736B) (0%)
    10μs
    1 x beforeRenderModule mod_easyblogcategories (Categorías) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_banners (Anuncio Google Blog) (704B) (0%)
    10μs
    1 x beforeRenderModule mod_easyblogmostpopularpost (+Populares) (736B) (0%)
    10μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    10μs
    1 x beforeRenderModule mod_easyblogtagcloud (Etiquetas) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_banners (Anuncio) (704B) (0%)
    9μs
    1 x beforeRenderModule mod_easyblogcalendar (Calendario de Artículos) (736B) (0%)
    9μs
    1 x beforeRenderModule mod_djmegamenu (Redes Sociales) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_djmegamenu (Otros Enlaces) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_djmegamenu (Enlaces de Interés) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_acym (Boletín de Noticias) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Acceso Clientes) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Topbar-left] Slogan) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Footer logo) (720B) (0%)
    5μs
233 statements were executed, 20 of which were duplicates, 213 unique498ms2.61MB
  • SELECT @@SESSION.sql_mode;73μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `eua3m_session` WHERE `session_id` = ?131μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `eua3m_session` WHERE `session_id` = :session_id LIMIT 194μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `eua3m_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)83.16ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `eua3m_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1360μs34.48KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `eua3m_viewlevels`100μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `eua3m_usergroups` AS `a` LEFT JOIN `eua3m_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest190μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `eua3m_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`1.07ms60.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `eua3m_template_styles` WHERE `client_id` = 0 AND `home` = 1222μs2.09KB/components/com_sppagebuilder/parser/addon-parser.php:1335Copy
  • SELECT * FROM `eua3m_languages` WHERE `published` = 1 ORDER BY `ordering` ASC218μs2.22KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT params FROM eua3m_extensions WHERE element = 'cookiespolicynotificationbar' AND folder = 'system'173μs16.84KB/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:217Copy
  • SELECT `enabled` FROM `eua3m_extensions` WHERE `type` = 'plugin' AND `element` = 'cache' AND `folder` = 'system'127μs856B/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:2618Copy
  • SELECT * FROM eua3m_rsform_config172μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `template` FROM `eua3m_template_styles` WHERE `client_id` = 0 AND `home` = 1159μs856B/plugins/system/helix3/helix3.php:247Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `eua3m_menu` AS `m` LEFT JOIN `eua3m_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`552μs53.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `eua3m_easyblog_configs` WHERE `name` = 'config'194μs64.89KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC335μs4.55KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_acl_group` WHERE `content_id` IN (1, 9) AND `type`='group'401μs2.8KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT `id` FROM `eua3m_easyblog_post` WHERE `permalink`='como-medir-el-roi-de-las-campanas-en-redes-sociales'181μs856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_post` WHERE `id` = '104'281μs143.84KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_revisions` WHERE `id` = '116'165μs153.91KB/libraries/src/Table/Table.php:780Copy
  • SELECT COUNT(1) FROM `eua3m_easyblog_featured` WHERE `content_id`='104' AND `type`='post'202μs856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_meta` WHERE `type`='post' AND `content_id`='104'151μs1.22KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `eua3m_template_styles` AS `s` LEFT JOIN `eua3m_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1214μs1.14KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT DISTINCT a.* FROM `eua3m_ampz` AS a LIMIT 20129μs960B/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL TABLES WHERE table_type="BASE TABLE"2.16ms8.88KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:635Copy
  • SELECT * FROM eua3m_acym_configuration204μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:30Copy
  • SELECT * FROM eua3m_acym_plugin93μs2.11KB/administrator/components/com_acym/libraries/joomla/database.php:30Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'acychecker' LIMIT 1118μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'acymailer' LIMIT 1112μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'amazon' LIMIT 197μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'article' LIMIT 1111μs2.09KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'birthday' LIMIT 1111μs13.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'brevo' LIMIT 195μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'createuser' LIMIT 1112μs2.09KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM eua3m_usergroups AS `groups`83μs1.33KB/administrator/components/com_acym/libraries/joomla/database.php:30Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'elasticemail' LIMIT 1133μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'forward' LIMIT 1123μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'mailgun' LIMIT 1123μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'module' LIMIT 1133μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'online' LIMIT 1122μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'override' LIMIT 1132μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'phpmail' LIMIT 1120μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'postmark' LIMIT 1135μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'qmail' LIMIT 1120μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'segment' LIMIT 1122μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'sendgrid' LIMIT 1122μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'sendinblue' LIMIT 1132μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'luecredentials' LIMIT 1145μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'lueintegration' LIMIT 1119μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'luetransactional' LIMIT 1116μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'luelist' LIMIT 1114μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'lueusers' LIMIT 1123μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'luesender' LIMIT 1113μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'luecampaign' LIMIT 1111μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'luewebhooks' LIMIT 1111μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'sendmail' LIMIT 1117μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'smtp' LIMIT 1122μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'statistics' LIMIT 1122μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'subscriber' LIMIT 1124μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'subscription' LIMIT 1126μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'time' LIMIT 1123μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'user' LIMIT 1135μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT * FROM eua3m_acym_plugin WHERE folder_name = 'managetext' LIMIT 1123μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `eua3m_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50,:preparedArray51,:preparedArray52,:preparedArray53)643μs16.25KBParams/libraries/src/Access/Access.php:357Copy
  • DELETE FROM `eua3m_easyblog_mailq` WHERE `status`='1' AND DATEDIFF(NOW(), `created`) >='7'121μs0B/administrator/components/com_easyblog/includes/utils.php:166Copy
  • SELECT `id` FROM `eua3m_easyblog_mailq` WHERE `status`='0' ORDER BY `id` ASC LIMIT 20136μs840B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_post` WHERE `publish_up`<='2025-04-09 13:58:38' AND `published`='2' AND `state`='0' ORDER BY `id` LIMIT 1337μs7.83KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT id, created_by FROM`eua3m_easyblog_post` WHERE `publish_down` > `publish_up` AND `publish_down` <= '2025-04-09 13:58:38' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'210μs896B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_uploader_tmp` WHERE `created` <= DATE_SUB('2025-04-09 13:58:38' , INTERVAL 120 MINUTE)128μs1.17KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.`id` FROM `eua3m_easyblog_post` as a inner join `eua3m_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2025-04-09 13:58:38', INTERVAL 3 DAY)177μs840B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • DELETE a, b FROM `eua3m_easyblog_post` as a inner join `eua3m_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2025-04-09 13:58:38', INTERVAL 3 DAY)184μs0B/administrator/components/com_easyblog/includes/utils.php:166Copy
  • SELECT * FROM `eua3m_menu` WHERE `published`='1' AND `link` LIKE 'index.php?option=com_easyblog%' AND `client_id` = '0' ORDER BY `id`337μs4.09KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_post` WHERE `id` = '104'293μs143.84KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_revisions` WHERE `id` = '116'169μs153.91KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_meta` WHERE `type`='post' AND `content_id`='104'177μs1.22KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT COUNT(1) as `voted`, `uid` FROM `eua3m_easyblog_ratings` WHERE `uid` = '104' AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '07dc7687aaec6d28778d96006ffb8739' OR `ip` = '3.133.130.103') GROUP BY `uid` ORDER BY NULL182μs896B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `eua3m_easyblog_ratings` AS a WHERE a.`uid` IN(104) AND `type`='entry' GROUP BY `uid` ORDER BY NULL141μs960B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.*, b.`post_id`, b.`primary` from `eua3m_easyblog_category` as a inner join `eua3m_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN (104) order by a.`lft` asc274μs4.03KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.*, b.`post_id` from `eua3m_easyblog_tag` as a inner join `eua3m_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN (104)191μs2.13KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.* from `eua3m_easyblog_revisions` as a where a.`id` IN ( 116)202μs153.91KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`, e.`ordering` from `eua3m_users` as u left join `eua3m_easyblog_users` as e ON u.`id` = e.`id` where u.`id` = 42178μs4.31KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SHOW FULL COLUMNS FROM `eua3m_users`716μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `eua3m_users` WHERE `id` = :userid155μs4.41KBParams/libraries/src/Table/User.php:106Copy
  • SELECT `g`.`id`,`g`.`title` FROM `eua3m_usergroups` AS `g` INNER JOIN `eua3m_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid214μs1.68KBParams/libraries/src/Table/User.php:134Copy
  • select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `eua3m_easyblog_category_fields_groups` as a inner join `eua3m_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `eua3m_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `eua3m_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `eua3m_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `eua3m_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id` where `p`.`post_id` = '104' AND ( acl.`acl_id` IN(9) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )337μs4.08KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select * from `eua3m_easyblog_meta` where `content_id` in (104) and `type` = 'post'164μs1.22KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_meta` WHERE `content_id` = '104' AND `type` = 'post'151μs1.22KB/libraries/src/Table/Table.php:780Copy
  • SELECT enabled FROM `eua3m_extensions` WHERE `element` = 'com_sppagebuilder' AND `type` = 'component'233μs856B/plugins/content/sppagebuilder/sppagebuilder.php:306Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM eua3m_fields AS a LEFT JOIN `eua3m_languages` AS l ON l.lang_code = a.language LEFT JOIN eua3m_users AS uc ON uc.id=a.checked_out LEFT JOIN eua3m_viewlevels AS ag ON ag.id = a.access LEFT JOIN eua3m_users AS ua ON ua.id = a.created_user_id LEFT JOIN eua3m_fields_groups AS g ON g.id = a.group_id LEFT JOIN `eua3m_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC446μs6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT t.* FROM eua3m_seoglossary as t LEFT JOIN eua3m_seoglossaries g ON t.catid = g.id WHERE t.state = 1 AND g.state = 1 AND ((LOWER('Una de las preguntas más comunes entre las empresas que invierten en marketing digital es: ¿Cómo puedo medir el retorno de inversión (ROI) de mis campañas en redes sociales? Medir el ROI es fundamental para determinar si el esfuerzo, tiempo y dinero que destinas a tus campañas está generando los resultados deseados. Sin embargo, el cálculo puede se...\n') LIKE CONCAT('%', LOWER(t.tterm), '%')) OR (LOWER('Una de las preguntas más comunes entre las empresas que invierten en marketing digital es: ¿Cómo puedo medir el retorno de inversión (ROI) de mis campañas en redes sociales? Medir el ROI es fundamental para determinar si el esfuerzo, tiempo y dinero que destinas a tus campañas está generando los resultados deseados. Sin embargo, el cálculo puede se...\n') LIKE CONCAT('%', LOWER(t.tsynonyms), '%'))) AND g.language IN ('es-ES','*') AND (t.publish_up = '0000-00-00 00:00:00' OR t.publish_up <= '2025-04-09 13:58:38') AND ((t.publish_down = '0000-00-00 00:00:00' OR t.publish_down >= '2025-04-09 13:58:38')) AND NOT FIND_IN_SET('easyblog.blog',g.disable_context) AND NOT FIND_IN_SET(440,g.disable_menu) AND NOT FIND_IN_SET('easyblog',g.disable_component) ORDER BY t.ordering317μs4.27KB/plugins/content/seoglossary/seoglossary.php:184Copy
  • UPDATE `eua3m_easyblog_post` SET `hits` = (`hits` + 1) WHERE `id` = '104'79.13ms48B/libraries/src/Table/Table.php:1348Copy
  • SELECT `key`,`value` FROM `eua3m_easyblog_post_assets` WHERE `post_id`='104'171μs848B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT COUNT(1) FROM `eua3m_easyblog_feeds_history` WHERE `post_id`='104'133μs856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select `id` FROM `eua3m_easyblog_adsense` where user_id = '42'133μs856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_adsense` WHERE `id` = '1'116μs1.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT `id` FROM `eua3m_menu` WHERE ( `link` LIKE 'index.php?option=com_easyblog&view=entry&id=104%' OR `link` LIKE 'index.php?option=com_easyblog&view=entry&id=104%' ) AND `published`='1' AND (`language`='es-ES' OR `language`='' OR `language`='*') LIMIT 1700μs840B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.`id`, a.`title` FROM `eua3m_easyblog_post` AS `a` INNER JOIN `eua3m_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND ( NOT EXISTS ( select acp.post_id from `eua3m_easyblog_post_category` as acp inner join `eua3m_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (9)) = 0 ) ))) AND a.`source_type`='easyblog.sitewide' AND a.`id` NOT IN(104) AND a.`created` < '2024-09-20 22:40:25' ORDER BY a.`created` DESC LIMIT 11.64ms912B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.`id`, a.`title` FROM `eua3m_easyblog_post` AS `a` INNER JOIN `eua3m_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND ( NOT EXISTS ( select acp.post_id from `eua3m_easyblog_post_category` as acp inner join `eua3m_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (9)) = 0 ) ))) AND a.`source_type`='easyblog.sitewide' AND a.`id` NOT IN(104) AND a.`created` > '2024-09-20 22:40:25' ORDER BY a.`created` ASC LIMIT 11.86ms912B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_post` WHERE `id` = '103'264μs87.84KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_revisions` WHERE `id` = '114'154μs89.91KB/libraries/src/Table/Table.php:780Copy
  • SELECT COUNT(1) FROM `eua3m_easyblog_featured` WHERE `content_id`='103' AND `type`='post'140μs856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_meta` WHERE `type`='post' AND `content_id`='103'154μs1.22KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_post` WHERE `id` = '105'240μs87.84KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_revisions` WHERE `id` = '117'179μs89.91KB/libraries/src/Table/Table.php:780Copy
  • SELECT COUNT(1) FROM `eua3m_easyblog_featured` WHERE `content_id`='105' AND `type`='post'135μs856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_meta` WHERE `type`='post' AND `content_id`='105'153μs1.22KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT COUNT(1) as `voted`, `uid` FROM `eua3m_easyblog_ratings` WHERE `uid` IN (103,105) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '07dc7687aaec6d28778d96006ffb8739' OR `ip` = '3.133.130.103') GROUP BY `uid` ORDER BY NULL219μs896B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `eua3m_easyblog_ratings` AS a WHERE a.`uid` IN(103,105) AND `type`='entry' GROUP BY `uid` ORDER BY NULL162μs960B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.*, b.`post_id`, b.`primary` from `eua3m_easyblog_category` as a inner join `eua3m_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN (103,105) order by a.`lft` asc270μs4.05KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.*, b.`post_id` from `eua3m_easyblog_tag` as a inner join `eua3m_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN (103,105)202μs2.17KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.* from `eua3m_easyblog_revisions` as a where a.`id` IN ( 114,117)193μs89.92KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `eua3m_easyblog_category_fields_groups` as a inner join `eua3m_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `eua3m_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `eua3m_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `eua3m_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `eua3m_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id` where p.post_id IN (103,105) AND ( acl.`acl_id` IN(9) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )453μs4.08KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select * from `eua3m_easyblog_meta` where `content_id` in (103,105) and `type` = 'post'169μs1.23KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT t.* FROM eua3m_seoglossary as t LEFT JOIN eua3m_seoglossaries g ON t.catid = g.id WHERE t.state = 1 AND g.state = 1 AND ((LOWER('\nUna de las preguntas más comunes entre las empresas que invierten en marketing digital es: ¿Cómo puedo medir el retorno de inversión (ROI) de mis campañas en redes sociales? Medir el ROI es fundamental para determinar si el esfuerzo, tiempo y dinero que destinas a tus campañas está generando los resultados deseados. Sin embargo, el cálculo puede ser complicado, ya que las redes sociales no solo impulsan ventas directas, sino también la interacción, reconocimiento de marca y fidelización de clientes.\nEn este artículo, te explicamos de manera sencilla cómo medir el ROI de tus campañas en redes sociales y cómo asegurarte de que tu inversión esté dando frutos.\n¿Qué es el ROI?\nEl retorno de inversión (ROI) es una métrica que permite evaluar la rentabilidad de una campaña en función del dinero que se invirtió. La fórmula básica para calcularlo es:\nROI=(Ingresosgenerados−Inversioón)×100 / Inversión ROI = \\frac{(Ingresos generados - Inversión) \\times 100}{Inversión}ROI=Inversión(Ingresosgenerados−Inversión)×100\nEste cálculo proporciona un porcentaje que indica el beneficio que has obtenido en relación con lo que has gastado. Si el resultado es positivo, tu campaña fue rentable; si es negativo, significa que perdiste dinero.\nLa importancia de medir el ROI en redes sociales\nMedir el ROI en redes sociales es crucial por varias razones:\n\nEvaluar el éxito: Te ayuda a determinar si tus esfuerzos en redes sociales están funcionando como esperabas.\nOptimización: Si identificas qué campañas o tácticas generan un mayor retorno, puedes ajustar tu estrategia para enfocarte en ellas.\nJustificación de la inversión: Si necesitas justificar ante tu equipo o tus superiores la inversión en redes sociales, el ROI te proporciona cifras concretas.\n\n¿Qué se puede medir en una campaña de redes sociales?\nAntes de sumergirnos en los pasos para calcular el ROI, es importante entender que no todo el impacto de las redes sociales se traduce en ingresos directos. Las redes sociales generan varios tipos de valor, como:\n\nVentas directas: Conversiones que resultan directamente de una interacción en redes sociales.\nReconocimiento de marca: El valor que aportan las impresiones y la visibilidad.\nInteracción: Likes, comentarios, compartidos y retuits que contribuyen al engagement de tu marca.\nFidelización de clientes: Las redes sociales pueden ayudar a mejorar la lealtad del cliente y las relaciones a largo plazo.\n\nPara calcular el ROI de una campaña, es fundamental que definas qué tipo de valor estás midiendo. En la mayoría de los casos, el ROI se mide a partir de las conversiones y las ventas, pero también puedes establecer métricas de éxito basadas en el crecimiento de seguidores, el reconocimiento de marca o el tráfico a tu sitio web.\nPasos para medir el ROI de las campañas en redes sociales\nA continuación, te explicamos los pasos básicos para medir el ROI de tus campañas en redes sociales.\n1. Establecer objetivos claros\nEl primer paso para medir el ROI es establecer objetivos concretos y medibles. Sin objetivos claros, es difícil evaluar si una campaña fue exitosa o no. Algunos ejemplos de objetivos pueden ser:\n\nAumentar las ventas: Este es un objetivo común para las empresas que utilizan redes sociales para impulsar sus productos o servicios.\nGenerar tráfico a tu sitio web: Puedes medir cuántos usuarios hacen clic en los enlaces de tus publicaciones para visitar tu página.\nIncrementar el engagement: Aumentar los likes, comentarios y compartidos puede ser un objetivo si buscas mejorar la interacción con tu audiencia.\nCapturar leads: Si tu campaña está diseñada para recopilar datos de clientes potenciales, este sería un objetivo medible.\n\nRecuerda que estos objetivos deben ser SMART (específicos, medibles, alcanzables, relevantes y con un tiempo determinado).\n2. Rastrear métricas clave\nPara medir el ROI, debes rastrear las métricas que te ayudarán a cumplir los objetivos establecidos. Algunas de las métricas más comunes en redes sociales son:\n\nCTR (Click-Through Rate): Porcentaje de usuarios que hicieron clic en un enlace en comparación con el total de usuarios que vieron la publicación.\nConversiones: Número de acciones completadas (ventas, registros, suscripciones) generadas a partir de una campaña.\nEngagement: Número total de interacciones (likes, comentarios, compartidos) dividido por el número de impresiones.\nCPC (Costo por clic): Costo promedio que pagas por cada clic en tus anuncios.\nCosto por conversión: El costo total de la campaña dividido por el número de conversiones generadas.\n\nHerramientas para medir el ROI en redes sociales\nAfortunadamente, existen varias herramientas que te ayudan a rastrear las métricas de tus campañas en redes sociales. Las más populares son:\n1. Google Analytics\nGoogle Analytics es una de las herramientas más potentes para medir el rendimiento de las redes sociales. Con él, puedes rastrear el tráfico que llega a tu sitio web desde redes sociales, las conversiones generadas y el comportamiento de los usuarios en tu página. Para medir el ROI, debes configurar el seguimiento de objetivos en Google Analytics, como ventas o registros.\n2. Facebook Ads Manager\nSi realizas campañas pagadas en Facebook o Instagram, Facebook Ads Manager te permite ver métricas detalladas sobre el rendimiento de tus anuncios, como clics, impresiones, conversiones y costo por conversión. También te permite configurar píxeles de seguimiento, que te ayudan a rastrear el comportamiento de los usuarios después de hacer clic en tus anuncios.\n3. Hootsuite o Buffer\nHerramientas como Hootsuite y Buffer te permiten programar publicaciones y rastrear el rendimiento de tus campañas orgánicas. Puedes ver el engagement de tus publicaciones, el crecimiento de seguidores y el tráfico que generan a tu sitio web.\nCalcular el ROI en ventas\nEl cálculo más directo del ROI proviene de las ventas generadas directamente por una campaña. Si has invertido $500 en una campaña y generaste $1,500 en ventas gracias a esa campaña, el cálculo sería:\nROI=(1500−500)×100500=200%ROI = \\frac{(1500 - 500) \\times 100}{500} = 200\\%ROI=500(1500−500)×100=200%\nEsto significa que has obtenido un retorno del 200%, lo que indica que tu campaña fue altamente rentable.\nCalcular el ROI en base a otros valores\nNo todas las campañas de redes sociales se enfocan en generar ventas inmediatas. Algunas tienen como objetivo mejorar el reconocimiento de marca o el engagement. Para calcular el ROI en estos casos, puedes asignar un valor monetario a estos resultados. Por ejemplo, puedes calcular cuánto te costaría conseguir la misma visibilidad o interacción a través de otros medios publicitarios y compararlo con lo que has invertido en redes sociales.\nOptimización del ROI\nMedir el ROI no es suficiente. Debes usar los datos para optimizar tus futuras campañas. Si notas que ciertos anuncios o tipos de contenido generan más conversiones o engagement, ajusta tu estrategia para centrarte en ellos. De igual forma, si una plataforma no te está dando los resultados esperados, considera reducir tu inversión en ella y probar nuevas estrategias.\nConclusión\nMedir el ROI de tus campañas en redes sociales es esencial para saber si tu inversión está generando resultados. Al establecer objetivos claros, rastrear las métricas correctas y utilizar herramientas adecuadas, puedes obtener una visión precisa de cómo tus campañas impactan en tu negocio.\nEn codigoseo.com, te ayudamos a medir y mejorar el rendimiento de tus campañas en redes sociales. Con nuestra experiencia en marketing digital y análisis de datos, aseguramos que cada dólar que inviertes en redes sociales se traduzca en resultados medibles y significativos. ¡Contáctanos para optimizar tus campañas hoy mismo!&nbsp;\n\n') LIKE CONCAT('%', LOWER(t.tterm), '%')) OR (LOWER('\nUna de las preguntas más comunes entre las empresas que invierten en marketing digital es: ¿Cómo puedo medir el retorno de inversión (ROI) de mis campañas en redes sociales? Medir el ROI es fundamental para determinar si el esfuerzo, tiempo y dinero que destinas a tus campañas está generando los resultados deseados. Sin embargo, el cálculo puede ser complicado, ya que las redes sociales no solo impulsan ventas directas, sino también la interacción, reconocimiento de marca y fidelización de clientes.\nEn este artículo, te explicamos de manera sencilla cómo medir el ROI de tus campañas en redes sociales y cómo asegurarte de que tu inversión esté dando frutos.\n¿Qué es el ROI?\nEl retorno de inversión (ROI) es una métrica que permite evaluar la rentabilidad de una campaña en función del dinero que se invirtió. La fórmula básica para calcularlo es:\nROI=(Ingresosgenerados−Inversioón)×100 / Inversión ROI = \\frac{(Ingresos generados - Inversión) \\times 100}{Inversión}ROI=Inversión(Ingresosgenerados−Inversión)×100\nEste cálculo proporciona un porcentaje que indica el beneficio que has obtenido en relación con lo que has gastado. Si el resultado es positivo, tu campaña fue rentable; si es negativo, significa que perdiste dinero.\nLa importancia de medir el ROI en redes sociales\nMedir el ROI en redes sociales es crucial por varias razones:\n\nEvaluar el éxito: Te ayuda a determinar si tus esfuerzos en redes sociales están funcionando como esperabas.\nOptimización: Si identificas qué campañas o tácticas generan un mayor retorno, puedes ajustar tu estrategia para enfocarte en ellas.\nJustificación de la inversión: Si necesitas justificar ante tu equipo o tus superiores la inversión en redes sociales, el ROI te proporciona cifras concretas.\n\n¿Qué se puede medir en una campaña de redes sociales?\nAntes de sumergirnos en los pasos para calcular el ROI, es importante entender que no todo el impacto de las redes sociales se traduce en ingresos directos. Las redes sociales generan varios tipos de valor, como:\n\nVentas directas: Conversiones que resultan directamente de una interacción en redes sociales.\nReconocimiento de marca: El valor que aportan las impresiones y la visibilidad.\nInteracción: Likes, comentarios, compartidos y retuits que contribuyen al engagement de tu marca.\nFidelización de clientes: Las redes sociales pueden ayudar a mejorar la lealtad del cliente y las relaciones a largo plazo.\n\nPara calcular el ROI de una campaña, es fundamental que definas qué tipo de valor estás midiendo. En la mayoría de los casos, el ROI se mide a partir de las conversiones y las ventas, pero también puedes establecer métricas de éxito basadas en el crecimiento de seguidores, el reconocimiento de marca o el tráfico a tu sitio web.\nPasos para medir el ROI de las campañas en redes sociales\nA continuación, te explicamos los pasos básicos para medir el ROI de tus campañas en redes sociales.\n1. Establecer objetivos claros\nEl primer paso para medir el ROI es establecer objetivos concretos y medibles. Sin objetivos claros, es difícil evaluar si una campaña fue exitosa o no. Algunos ejemplos de objetivos pueden ser:\n\nAumentar las ventas: Este es un objetivo común para las empresas que utilizan redes sociales para impulsar sus productos o servicios.\nGenerar tráfico a tu sitio web: Puedes medir cuántos usuarios hacen clic en los enlaces de tus publicaciones para visitar tu página.\nIncrementar el engagement: Aumentar los likes, comentarios y compartidos puede ser un objetivo si buscas mejorar la interacción con tu audiencia.\nCapturar leads: Si tu campaña está diseñada para recopilar datos de clientes potenciales, este sería un objetivo medible.\n\nRecuerda que estos objetivos deben ser SMART (específicos, medibles, alcanzables, relevantes y con un tiempo determinado).\n2. Rastrear métricas clave\nPara medir el ROI, debes rastrear las métricas que te ayudarán a cumplir los objetivos establecidos. Algunas de las métricas más comunes en redes sociales son:\n\nCTR (Click-Through Rate): Porcentaje de usuarios que hicieron clic en un enlace en comparación con el total de usuarios que vieron la publicación.\nConversiones: Número de acciones completadas (ventas, registros, suscripciones) generadas a partir de una campaña.\nEngagement: Número total de interacciones (likes, comentarios, compartidos) dividido por el número de impresiones.\nCPC (Costo por clic): Costo promedio que pagas por cada clic en tus anuncios.\nCosto por conversión: El costo total de la campaña dividido por el número de conversiones generadas.\n\nHerramientas para medir el ROI en redes sociales\nAfortunadamente, existen varias herramientas que te ayudan a rastrear las métricas de tus campañas en redes sociales. Las más populares son:\n1. Google Analytics\nGoogle Analytics es una de las herramientas más potentes para medir el rendimiento de las redes sociales. Con él, puedes rastrear el tráfico que llega a tu sitio web desde redes sociales, las conversiones generadas y el comportamiento de los usuarios en tu página. Para medir el ROI, debes configurar el seguimiento de objetivos en Google Analytics, como ventas o registros.\n2. Facebook Ads Manager\nSi realizas campañas pagadas en Facebook o Instagram, Facebook Ads Manager te permite ver métricas detalladas sobre el rendimiento de tus anuncios, como clics, impresiones, conversiones y costo por conversión. También te permite configurar píxeles de seguimiento, que te ayudan a rastrear el comportamiento de los usuarios después de hacer clic en tus anuncios.\n3. Hootsuite o Buffer\nHerramientas como Hootsuite y Buffer te permiten programar publicaciones y rastrear el rendimiento de tus campañas orgánicas. Puedes ver el engagement de tus publicaciones, el crecimiento de seguidores y el tráfico que generan a tu sitio web.\nCalcular el ROI en ventas\nEl cálculo más directo del ROI proviene de las ventas generadas directamente por una campaña. Si has invertido $500 en una campaña y generaste $1,500 en ventas gracias a esa campaña, el cálculo sería:\nROI=(1500−500)×100500=200%ROI = \\frac{(1500 - 500) \\times 100}{500} = 200\\%ROI=500(1500−500)×100=200%\nEsto significa que has obtenido un retorno del 200%, lo que indica que tu campaña fue altamente rentable.\nCalcular el ROI en base a otros valores\nNo todas las campañas de redes sociales se enfocan en generar ventas inmediatas. Algunas tienen como objetivo mejorar el reconocimiento de marca o el engagement. Para calcular el ROI en estos casos, puedes asignar un valor monetario a estos resultados. Por ejemplo, puedes calcular cuánto te costaría conseguir la misma visibilidad o interacción a través de otros medios publicitarios y compararlo con lo que has invertido en redes sociales.\nOptimización del ROI\nMedir el ROI no es suficiente. Debes usar los datos para optimizar tus futuras campañas. Si notas que ciertos anuncios o tipos de contenido generan más conversiones o engagement, ajusta tu estrategia para centrarte en ellos. De igual forma, si una plataforma no te está dando los resultados esperados, considera reducir tu inversión en ella y probar nuevas estrategias.\nConclusión\nMedir el ROI de tus campañas en redes sociales es esencial para saber si tu inversión está generando resultados. Al establecer objetivos claros, rastrear las métricas correctas y utilizar herramientas adecuadas, puedes obtener una visión precisa de cómo tus campañas impactan en tu negocio.\nEn codigoseo.com, te ayudamos a medir y mejorar el rendimiento de tus campañas en redes sociales. Con nuestra experiencia en marketing digital y análisis de datos, aseguramos que cada dólar que inviertes en redes sociales se traduzca en resultados medibles y significativos. ¡Contáctanos para optimizar tus campañas hoy mismo!&nbsp;\n\n') LIKE CONCAT('%', LOWER(t.tsynonyms), '%'))) AND g.language IN ('es-ES','*') AND (t.publish_up = '0000-00-00 00:00:00' OR t.publish_up <= '2025-04-09 13:58:38') AND ((t.publish_down = '0000-00-00 00:00:00' OR t.publish_down >= '2025-04-09 13:58:38')) AND NOT FIND_IN_SET('easyblog.blog',g.disable_context) AND NOT FIND_IN_SET(440,g.disable_menu) AND NOT FIND_IN_SET('easyblog',g.disable_component) ORDER BY t.ordering262μs4.27KB/plugins/content/seoglossary/seoglossary.php:184Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `eua3m_modules` AS `m` LEFT JOIN `eua3m_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `eua3m_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`1.08ms18.75KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `group_id` FROM `eua3m_user_usergroup_map` WHERE `user_id` = '42'133μs856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_acl_group` WHERE `content_id` IN (8) AND `type`='group'240μs1.92KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.*, count(b.`id`) AS total FROM `eua3m_easyblog_reactions` AS a LEFT JOIN `eua3m_easyblog_reactions_history` AS b ON a.`id` = b.`reaction_id` AND b.`post_id`='104' WHERE a.`published`='1' GROUP BY a.`id`205μs1.13KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT b.* FROM `eua3m_easyblog_reactions_history` AS a LEFT JOIN `eua3m_easyblog_reactions`AS b ON a.`reaction_id` = b.`id` WHERE a.`post_id` = '104' AND a.`token_id` = '75846119cb2ee13a8e12fbb11c966858'152μs1008B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT `id` FROM `eua3m_easyblog_subscriptions` WHERE `uid` = '42' AND `utype` = 'blogger' AND `email` = ''196μs840B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `eua3m_easyblog_post` AS a INNER JOIN `eua3m_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 LEFT JOIN `eua3m_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND a.`access` = '0' AND a.`created_by` = '42' AND ( NOT EXISTS ( select acp.post_id from `eua3m_easyblog_post_category` as acp inner join `eua3m_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (9)) = 0 ) ))) AND ((a.`source_type` = 'easyblog.sitewide') ) AND a.`id` NOT IN ('104') ORDER BY a.`created` desc LIMIT 0,312.14ms103.94KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select count(1) from `eua3m_easyblog_post` AS a WHERE a.`published`='1' AND a.`state`='0' AND a.`access` = '0' AND a.`created_by` = '42' AND ( NOT EXISTS ( select acp.post_id from `eua3m_easyblog_post_category` as acp inner join `eua3m_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (9)) = 0 ) ))) AND ((a.`source_type` = 'easyblog.sitewide') ) AND a.`id` NOT IN ('104')1.69ms856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT COUNT(1) as `voted`, `uid` FROM `eua3m_easyblog_ratings` WHERE `uid` IN (302,301,300) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '07dc7687aaec6d28778d96006ffb8739' OR `ip` = '3.133.130.103') GROUP BY `uid` ORDER BY NULL231μs896B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `eua3m_easyblog_ratings` AS a WHERE a.`uid` IN(302,301,300) AND `type`='entry' GROUP BY `uid` ORDER BY NULL175μs960B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.*, b.`post_id`, b.`primary` from `eua3m_easyblog_category` as a inner join `eua3m_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN (302,301,300) order by a.`lft` asc301μs4.06KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.*, b.`post_id` from `eua3m_easyblog_tag` as a inner join `eua3m_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN (302,301,300)241μs2.33KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.* from `eua3m_easyblog_revisions` as a where a.`id` IN ( 325,324,323)204μs117.94KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `eua3m_easyblog_category_fields_groups` as a inner join `eua3m_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `eua3m_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `eua3m_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `eua3m_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `eua3m_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id` where p.post_id IN (302,301,300) AND ( acl.`acl_id` IN(9) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )448μs20.08KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select * from `eua3m_easyblog_meta` where `content_id` in (302,301,300) and `type` = 'post'180μs1.25KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT `template` FROM `eua3m_template_styles` WHERE `home`!='0' AND `client_id`='0'166μs856B/libraries/foundry/helper.php:553Copy
  • SELECT COUNT(1) FROM `eua3m_easyblog_featured` WHERE `content_id`='302' AND `type`='post'146μs856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT COUNT(1) FROM `eua3m_easyblog_featured` WHERE `content_id`='301' AND `type`='post'137μs856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT COUNT(1) FROM `eua3m_easyblog_featured` WHERE `content_id`='300' AND `type`='post'136μs856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT DISTINCT c.*, 0 as `featured` FROM `eua3m_easyblog_category` AS a INNER JOIN `eua3m_easyblog_category` AS a1 ON a.`id` = a1.`id` AND a1.`id` = '7' INNER JOIN `eua3m_easyblog_post` AS c ON a1.`id` = c.`category_id` INNER JOIN `eua3m_users` AS uu ON c.`created_by` = uu.`id` and uu.`block` = 0 WHERE c.`id`!='104' AND c.`published`='1' AND c.`state`='0' AND ( NOT EXISTS ( select acp.post_id from `eua3m_easyblog_post_category` as acp inner join `eua3m_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = c.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (9)) = 0 ) ))) ORDER BY c.`created` desc LIMIT 66.33ms243.95KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT COUNT(1) as `voted`, `uid` FROM `eua3m_easyblog_ratings` WHERE `uid` IN (300,261,260,259,240,237) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '07dc7687aaec6d28778d96006ffb8739' OR `ip` = '3.133.130.103') GROUP BY `uid` ORDER BY NULL303μs896B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `eua3m_easyblog_ratings` AS a WHERE a.`uid` IN(300,261,260,259,240,237) AND `type`='entry' GROUP BY `uid` ORDER BY NULL220μs960B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.*, b.`post_id`, b.`primary` from `eua3m_easyblog_category` as a inner join `eua3m_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN (300,261,260,259,240,237) order by a.`lft` asc336μs4.11KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.*, b.`post_id` from `eua3m_easyblog_tag` as a inner join `eua3m_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN (300,261,260,259,240,237)273μs2.39KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.* from `eua3m_easyblog_revisions` as a where a.`id` IN ( 323,283,282,281,261,258)552μs249.98KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `eua3m_easyblog_category_fields_groups` as a inner join `eua3m_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `eua3m_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `eua3m_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `eua3m_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `eua3m_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id` where p.post_id IN (300,261,260,259,240,237) AND ( acl.`acl_id` IN(9) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )520μs4.08KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select * from `eua3m_easyblog_meta` where `content_id` in (300,261,260,259,240,237) and `type` = 'post'213μs1.3KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_composer_blocks`203μs2.83KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT `template` FROM `eua3m_template_styles` WHERE `home` = '1' AND `client_id` ='0'237μs856B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160Copy
  • SELECT `id` FROM `eua3m_menu` WHERE (`link`='index.php?option=com_easyblog&view=search' OR `link` LIKE 'index.php?option=com_easyblog&view=search&limit=%') AND `published`='1'AND `client_id`='0' AND (`language`='es-ES' OR `language`='' OR `language`='*') ORDER BY `id` ASC LIMIT 1372μs840B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT `id` FROM `eua3m_menu` WHERE `link` LIKE 'index.php?option=com_easyblog&view=search%' AND `published`='1'AND `client_id`='0' AND (`language`='es-ES' OR `language`='' OR `language`='*') LIMIT 1272μs840B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT `id` FROM `eua3m_menu` WHERE `link`='index.php?option=com_easyblog&view=latest' AND `published`='1'AND `client_id`='0' AND (`language`='es-ES' OR `language`='' OR `language`='*') LIMIT 1253μs840B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT `id` FROM `eua3m_menu` WHERE `link` LIKE 'index.php?option=com_easyblog&view=%' AND `published`='1'AND `client_id`='0' AND (`language`='es-ES' OR `language`='' OR `language`='*') ORDER BY `id` LIMIT 1211μs856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT `template` FROM `eua3m_template_styles` WHERE `home` = '1' AND `client_id` ='0'131μs856B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160Copy
  • SELECT `template` FROM `eua3m_template_styles` WHERE `home` = '1' AND `client_id` ='0'131μs856B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160Copy
  • SELECT `template` FROM `eua3m_template_styles` WHERE `home` = '1' AND `client_id` ='0'137μs856B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160Copy
  • SELECT `template` FROM `eua3m_template_styles` WHERE `home` = '1' AND `client_id` ='0'139μs856B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160Copy
  • SELECT `template` FROM `eua3m_template_styles` WHERE `home` = '1' AND `client_id` ='0'146μs856B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160Copy
  • SELECT extension_id FROM eua3m_extensions WHERE type='plugin' AND element = 'cookiespolicynotificationbar' AND folder='system'202μs856B/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:769Copy
  • SELECT extension_id FROM eua3m_extensions WHERE type='plugin' AND element = 'cookiespolicynotificationbar' AND folder='system'144μs40B/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:770Copy
  • SELECT `content` FROM `eua3m_modules` WHERE `published` = 1 AND `client_id` = 0 AND `content` <> ''298μs920B/plugins/system/ampz/helper.php:88Copy
  • SELECT manifest_cache FROM eua3m_extensions WHERE element='mod_djmegamenu' LIMIT 1223μs856B/modules/mod_djmegamenu/helpers/helper.php:412Copy
  • SELECT * FROM eua3m_acym_list WHERE `type` = 'standard'204μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:30Copy
  • SELECT * FROM eua3m_acym_field WHERE `id` IN(1,2) ORDER BY `ordering` ASC183μs3.64KB/administrator/components/com_acym/libraries/joomla/database.php:30Copy
  • SELECT COUNT(1) FROM `eua3m_easyblog_category_acl` as a LEFT JOIN `eua3m_easyblog_category` as b ON a.`category_id` = b.`id` WHERE b.`published` = '1' AND a.`acl_id` = '2' AND a.`type` = 'user' AND a.`content_id` = ''267μs856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.*, count(p.`id`) as `cnt` from `eua3m_easyblog_category` as a inner join `eua3m_easyblog_category` as c on a.`lft` <= c.`lft` and a.`rgt` >= c.`rgt` left join `eua3m_easyblog_post_category` as `pcat` on c.`id` = pcat.`category_id` left join `eua3m_easyblog_post` as p on pcat.`post_id` = p.`id` and p.`published` = '1' and p.`state` = '0' and not exists ( select acp2.post_id from `eua3m_easyblog_post_category` as acp2 inner join `eua3m_easyblog_category` as cat2 on acp2.`category_id` = cat2.`id` where acp2.`post_id` = pcat.`post_id` and ( (cat2.`private` = 1 and (0 = 0)) OR (cat2.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl2 where cacl2.`category_id` = cat2.`id` and cacl2.`acl_id` = 1 and cacl2.`content_id` IN (9)) = 0) )) AND EXISTS (select uu.id from `eua3m_users` as uu where uu.`id` = p.`created_by` and uu.`block` = 0) WHERE a.`published`='1' and a.`parent_id` = 0 and (( (a.`private` = 0) OR (a.`private` = 1 AND '0' > 0) OR (a.`private` = 2 AND ( SELECT COUNT(1) FROM `eua3m_easyblog_category_acl` as ca WHERE ca.`category_id` = a.`id` AND ca.`acl_id` = '1' AND ( (ca.`content_id` IN ('9') AND ca.`type` = 'group') OR (ca.`content_id` = '0' AND ca.`type` = 'user') ) ) > 0 ) )) GROUP BY a.`id` ORDER BY `cnt` DESC LIMIT 102.15ms20.14KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select count(1) from (select a.*, count(p.`id`) as `cnt` from `eua3m_easyblog_category` as a inner join `eua3m_easyblog_category` as c on a.`lft` <= c.`lft` and a.`rgt` >= c.`rgt` left join `eua3m_easyblog_post_category` as `pcat` on c.`id` = pcat.`category_id` left join `eua3m_easyblog_post` as p on pcat.`post_id` = p.`id` and p.`published` = '1' and p.`state` = '0' and not exists ( select acp2.post_id from `eua3m_easyblog_post_category` as acp2 inner join `eua3m_easyblog_category` as cat2 on acp2.`category_id` = cat2.`id` where acp2.`post_id` = pcat.`post_id` and ( (cat2.`private` = 1 and (0 = 0)) OR (cat2.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl2 where cacl2.`category_id` = cat2.`id` and cacl2.`acl_id` = 1 and cacl2.`content_id` IN (9)) = 0) )) AND EXISTS (select uu.id from `eua3m_users` as uu where uu.`id` = p.`created_by` and uu.`block` = 0) WHERE a.`published`='1' and a.`parent_id` = 0 and (( (a.`private` = 0) OR (a.`private` = 1 AND '0' > 0) OR (a.`private` = 2 AND ( SELECT COUNT(1) FROM `eua3m_easyblog_category_acl` as ca WHERE ca.`category_id` = a.`id` AND ca.`acl_id` = '1' AND ( (ca.`content_id` IN ('9') AND ca.`type` = 'group') OR (ca.`content_id` = '0' AND ca.`type` = 'user') ) ) > 0 ) )) GROUP BY a.`id`) as x1.98ms856B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='9' GROUP BY `a`.`id` ORDER BY `cnt` desc308μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='2' GROUP BY `a`.`id` ORDER BY `cnt` desc283μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='8' GROUP BY `a`.`id` ORDER BY `cnt` desc279μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='1' GROUP BY `a`.`id` ORDER BY `cnt` desc279μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='3' GROUP BY `a`.`id` ORDER BY `cnt` desc278μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='7' GROUP BY `a`.`id` ORDER BY `cnt` desc289μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='4' GROUP BY `a`.`id` ORDER BY `cnt` desc279μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='6' GROUP BY `a`.`id` ORDER BY `cnt` desc286μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='10' GROUP BY `a`.`id` ORDER BY `cnt` desc279μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_category` WHERE `id` = '9'150μs3.97KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_category` WHERE `id` = '2'146μs3.97KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_category` WHERE `id` = '8'142μs3.97KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_category` WHERE `id` = '1'153μs3.97KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_category` WHERE `id` = '3'142μs3.97KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_category` WHERE `id` = '6'143μs3.97KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_category` WHERE `id` = '10'141μs3.97KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_banners` WHERE (`reset` <= :date AND `reset` IS NOT NULL) AND (`checked_out` IS NULL OR `checked_out` = :userId)346μs7.89KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69Copy
  • SELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions` FROM `eua3m_banners` AS `a` LEFT JOIN `eua3m_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid` WHERE ( ( (`a`.`state` = 1) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND (`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`cid` = :clientId AND `cl`.`state` = 1 AND `a`.`catid` IN (:preparedArray1) ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 1397μs2.92KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • UPDATE `eua3m_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)46.92ms856BParams/components/com_banners/src/Model/BannersModel.php:315Copy
  • UPDATE `eua3m_banner_tracks` SET `count` = `count` + 1 WHERE `track_type` = 1 AND `banner_id` = :id AND `track_date` = :trackDate48.9ms832BParams/components/com_banners/src/Model/BannersModel.php:352Copy
  • SELECT a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `eua3m_easyblog_post` AS a INNER JOIN `eua3m_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 LEFT JOIN `eua3m_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND a.`access` = '0' AND ( NOT EXISTS ( select acp.post_id from `eua3m_easyblog_post_category` as acp inner join `eua3m_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (9)) = 0 ) ))) AND a.`created` <= '2025-04-09 13:58:38' and a.`created` >= DATE_ADD('2025-04-09 13:58:38', INTERVAL -5 DAY) AND ((a.`source_type` = 'easyblog.sitewide') ) ORDER BY a.`hits` desc LIMIT 5610μs7.84KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select SQL_CALC_FOUND_ROWS a.*, count(c.`id`) as `post_count` from `eua3m_easyblog_tag` as a left join `eua3m_easyblog_post_tag` as b on a.`id` = b.`tag_id` left join `eua3m_easyblog_post` as c on b.`post_id` = c.`id` and c.`published` = '1' and c.`state` = '0' LEFT JOIN `eua3m_users` AS uu ON c.`created_by` = uu.`id` where a.`published` = '1' AND (uu.`block` = 0 OR uu.`id` IS NULL) group by (a.`id`) order by a.`title` ASC LIMIT 306.15ms2.58KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '423'130μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '371'120μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '47'118μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '49'118μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '321'117μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '351'118μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '82'117μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '171'120μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '220'127μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '320'118μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '129'127μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '22'117μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '192'125μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '53'118μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '39'119μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '147'118μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '242'117μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '36'117μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '157'116μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '200'118μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '360'118μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '405'115μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '237'117μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '98'117μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '188'118μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '241'117μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_easyblog_tag` WHERE `id` = '81'117μs2.06KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `eua3m_banners` WHERE (`reset` <= :date AND `reset` IS NOT NULL) AND (`checked_out` IS NULL OR `checked_out` = :userId)331μs7.89KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69Copy
  • SELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions` FROM `eua3m_banners` AS `a` LEFT JOIN `eua3m_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid` WHERE ( ( (`a`.`state` = 1) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND (`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`cid` = :clientId AND `cl`.`state` = 1 AND `a`.`catid` IN (:preparedArray1) ORDER BY `a`.`sticky` DESC, RAND() LIMIT 1421μs2.92KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • UPDATE `eua3m_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)46.03ms856BParams/components/com_banners/src/Model/BannersModel.php:315Copy
  • UPDATE `eua3m_banner_tracks` SET `count` = `count` + 1 WHERE `track_type` = 1 AND `banner_id` = :id AND `track_date` = :trackDate41.6ms832BParams/components/com_banners/src/Model/BannersModel.php:352Copy
  • SELECT a.* FROM eua3m_extensions AS a WHERE a.element LIKE "mod_jux_weather_forecast"302μs3.73KB/modules/mod_jux_weather_forecast/helper.php:62Copy
  • SELECT * FROM `eua3m_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'282μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `eua3m_gsd_config`495μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `eua3m_gsd_config` WHERE `name` = 'config'99μs912B/libraries/src/Table/Table.php:780Copy
  • SELECT a.* FROM eua3m_gsd a WHERE a.state = 1 AND a.plugin = 'easyblog' AND a.appview IN ('entry','*') ORDER BY a.id desc261μs2.05KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT a.* FROM eua3m_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc205μs2.14KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT * FROM eua3m_acym_list WHERE type = 'standard'190μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:30Copy
  • SELECT * FROM eua3m_acym_field129μs3.66KB/administrator/components/com_acym/libraries/joomla/database.php:30Copy
  • SELECT * FROM eua3m_acym_form WHERE active = 1 AND type != 'shortcode'110μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:30Copy
  • SELECT * FROM eua3m_jmap_metainfo WHERE `linkurl` = 'https://codigoseo.com/blog/como-medir-el-roi-de-las-campanas-en-redes-sociales' AND `published` = 1147μs1.2KB/plugins/system/jmap/jmap.php:838Copy
  • SELECT * FROM eua3m_jmap_canonicals WHERE `linkurl` = 'https://codigoseo.com/blog/como-medir-el-roi-de-las-campanas-en-redes-sociales'90μs960B/plugins/system/jmap/jmap.php:968Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `eua3m_scheduler_tasks` AS `a` WHERE `a`.`state` = 1173μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `value` FROM eua3m_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"271μs856B/plugins/system/acymtriggers/acymtriggers.php:155Copy
  • SHOW FULL TABLES WHERE table_type="BASE TABLE"2.06ms8.88KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:635Copy
  • SELECT * FROM eua3m_jmap_headings WHERE `linkurl` = 'https://codigoseo.com/blog/como-medir-el-roi-de-las-campanas-en-redes-sociales'112μs1.05KB/plugins/system/jmap/jmap.php:1192Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `eua3m_jmap_text_replacements` WHERE `published` = 196μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `session_id` FROM `eua3m_session` WHERE `session_id` = ?182μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `eua3m_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?69.73ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy