Informations commerciales Magento détaillées

Installer l' agent d'infrastructure

Notre agent d'infrastructure monitore votre hôte et rapporte des mesures telles que l'utilisation du processeur, l'utilisation de la mémoire, l'utilisation du stockage, l'utilisation du disque et le trafic réseau.

Pour installer l'agent, choisissez l'une de ces méthodes d'installation :

• Suivez les étapes de notre installation guidée pour un processus d'installation rapide et facile.
• Installez manuellement l'agent pour un processus d'installation plus avancé.

Installer l'agent PHP

Notre agent PHP rapporte les métriques liées application et au navigateur telles que les performances AJAX, le taux d'erreur, la durée, les éléments essentiels du Web et le débit.

Pour installer l'agent, choisissez l'une de ces méthodes d'installation :

• Suivez les étapes de notre installation guidée pour un processus d'installation rapide et facile.
• Installez manuellement l'agent pour un processus d'installation plus avancé.

Installer l'intégration MySQL

Notre intégration MySQL monitore votre base de données et collecte des mesures sur l'utilisation de la base de données et les connexions, telles que la requête la plus lente et les connexions actives par nœud.

Pour installer l’intégration :

1. Allez à one.newrelic.com > Integrations & Agents.

2. Recherchez et cliquez sur MySQL.

3. Sélectionnez un compte et suivez les étapes d'installation guidée.

   Si vous devez installer l' d'une agent manière différente, consultez MySQL monitoring Intégration.

Installer l'intégration Apache

Notre intégration Apache collecte des métriques réseau telles que les connexions TCP, la recherche DNS, HTTPS, SSL et les statuts du serveur et des travailleurs.

Pour installer l'intégration, suivez les étapes de notre installation guidée.

Si vous devez installer l'intégration d'une manière différente,Apache monitoring consultez Intégration .

Installer l'intégration Elasticsearch

Notre intégration Elasticsearch collecte des métriques telles que l'état du cluster et les fragments actuels. Si vous utilisez Magento version 2.4 et supérieure, vous devrez installer notre intégration Elasticsearch.

Pour installer l’intégration :

1. Allez à one.newrelic.com > Integrations & Agents.

2. Recherchez et cliquez sur Elasticsearch.

3. Sélectionnez un compte et suivez les étapes d'installation guidée.

   Si vous devez installer l'intégration d'une manière différente,Elasticsearch monitoring consultez Intégration .

Mettre en place du monitoring Synthétique

Notre moniteur Synthétique teste votre application dans différents endroits et capture les temps d'arrêt du serveur. Vous pouvez consulter ces données dans le dashboard des informations commerciales détaillées de Magento.

Pour mettre en place Synthétique Monitorer, suivez les étapes de notre guide d'installation.

Créer une intégration Flex

Notre intégration Flex personnalisée vous permet de capturer des métriques commerciales via une requête de la base de données de votre application.

Pour créer votre intégration Flex :

1. Créez un fichier de configuration nri-flex :

   • Chemin vers le fichier de configuration : /etc/newrelic-infra/integrations.d/
   • Nom du fichier de configuration : mysql-database-config.yml

2. Ajoutez le snippet de code suivant au fichier configuration . Assurez-vous de remplacer USERNAME, PASSWORD ET DATABASE_NAME:

   # NOTE: 'database' is an experimental API at this time
   # ref: https://github.com/newrelic/nri-flex/blob/master/docs/experimental/db.md
   ---
   integrations:
     - name: nri-flex
       # interval: 30s
       config:
         name: MySQLDbFlex
         apis:
           - database: mysql
             # connection string for an rds mysql instance. Be sure to use the writer endpoint here.  
             # /sys is the default database. newrelic:Password is the user:pass.
             db_conn: USERNAME:PASSWORD@tcp(localhost:3306)/DATABASE_NAME
             logging:
               open: true
             # custom_attributes: # applies to all queries
             # host: CustomMagentoMySQL # custom host name atribute
             db_async: true
             db_queries:
               - name: MYSQLSalesOrderDetails
                 run: SELECT status AS 'status', entity_id AS 'order_id' FROM sales_order;
               - name: MySQLSalesOrderCumulative
                 run: SELECT AVG(grand_total) AS 'average_grand_total', SUM(grand_total) AS 'grand_total_sum', SUM(total_item_count) AS 'total_order_item_count' FROM sales_order;
               - name: MySQLSalesOrderByStatus
                 run: SELECT status AS 'order_status', COUNT(increment_id) AS 'total_orders', (SUM(grand_total)) AS 'total_billed_amount_by_status' FROM sales_order GROUP BY status;
               - name: MYSQLSalesOrderByCustomerGroup
                 run: SELECT AVG(salesOrder.grand_total) AS 'grand_total_average_of_all_orders', customerGroup.customer_group_code AS 'customer_group_code' FROM `sales_order` salesOrder JOIN `customer_group` customerGroup ON salesOrder.customer_group_id = customerGroup.customer_group_id GROUP BY salesOrder.customer_group_id;
               - name: MYSQLSalesOrderByProduct
                 run: SELECT items.order_id AS 'Order ID', items.created_at AS 'Order Created Date', orders.status AS 'Order Status', items.name AS 'productName', items.sku AS ProductSearchcode, orders.total_item_count AS 'Order Quantity', orders.grand_total AS 'Grand Total' FROM sales_order AS orders JOIN sales_order_item AS items ON items.order_id = orders.entity_id;
               - name: MYSQLSalesOrderByCategory
                 run: SELECT items.name AS 'Category', AVG(orders.grand_total) AS 'average_order_total' FROM sales_order AS orders JOIN sales_order_item AS items ON items.order_id = orders.entity_id GROUP BY items.name;
               - name: MYSQLSalesOrderByRegion
                 run: SELECT soa.country_id, soa.region_id, dcrn.name 'Region Name', so.entity_id AS 'Order ID', so.grand_total FROM sales_order_address soa JOIN directory_country_region_name dcrn JOIN sales_order so WHERE soa.region_id = dcrn.region_id AND so.entity_id = soa.parent_id;
               - name: MySQLSalesOrderPaymentCount
                 run: SELECT count(*) as CountOfOrderByMethod, method as PaymentMethodType FROM `sales_order_payment` group by method;
               - name: MYSQLAbandonedCarts
                 run: SELECT customer_email, items_count AS 'Products', items_qty AS 'Quantity', subtotal FROM `quote` WHERE customer_email IS NOT NULL AND reserved_order_id IS NULL AND subtotal != 0.0000;
               - name: MYSQLCustomerEntityRegisteredUsers
                 run: SELECT count(*) AS 'Registered Accounts' FROM `customer_entity`;
               - name: MYSQLUnregisteredCustomers
                 run: SELECT customer_email FROM sales_order WHERE customer_is_guest = 1 GROUP BY customer_email;
               - name: MYSQLSalesOrderByUnregisteredCustomersSummary
                 run: SELECT COUNT(entity_id) AS 'Total Order Ids', SUM(grand_total) AS 'Grand Total Sum' FROM sales_order WHERE customer_is_guest = 1;
               - name: MYSQLCustomerEntityActiveUsers
                 run: SELECT count(is_active) AS 'Active Users' FROM `customer_entity` WHERE is_active = 1;
               - name: MYSQLReturningCustomers
                 run: WITH ctel1 AS (SELECT COUNT(entity_id) AS 'numberOfOrders', customer_email AS 'customerEmail' FROM sales_order GROUP BY customer_email) SELECT count(*) AS 'returningCustomers' FROM ctel1 WHERE numberOfOrders > 1;
               - name: MYSQLNewCustomers
                 run: SELECT COUNT(DISTINCT email) AS 'newCustomers' FROM customer_entity WHERE MONTH(created_at) >= MONTH(CURRENT_DATE() - INTERVAL 1 MONTH);
               - name: MYSQLBestSellersDaily
                 run: SELECT SUM(qty_ordered) as 'QuantityOrdered', product_name FROM sales_bestsellers_aggregated_daily GROUP BY product_id, product_name ORDER BY QuantityOrdered DESC;
               - name: MYSQLRevenuePerMonthAndYear
                 run: SELECT SUM(grand_total) AS 'Total Revenue', AVG(grand_total) AS 'Average Revenue', YEAR(created_at) AS 'Year', MONTH(created_at) AS 'Month' FROM sales_order WHERE status = 'complete' GROUP BY YEAR(created_at), MONTH(created_at);
               - name: MYSQLMostViewedProductsDaily
                 run: SELECT SUM(views_num) as 'View Count', product_name, product_id FROM report_viewed_product_aggregated_daily GROUP BY product_name, product_id ORDER BY View Count DESC;
               - name: MYSQLConversionRate
                 run: WITH cte1 AS (SELECT soi.product_id AS 'SalesProductId', soi.name AS 'ProductName', COUNT(soi.order_id) AS 'Total Orders' FROM `sales_order_item` soi group by soi.product_id, soi.name), cte2 AS (SELECT viewed.product_id AS 'ProductID', COUNT(viewed.product_id) AS 'Total Views' FROM `report_viewed_product_index` viewed group by viewed.product_id) SELECT SalesProductId as 'ProductID', ProductName, Total Views, Total Orders, Total Orders / Total Views * 100 as 'Conversion Rate In Percent' FROM cte1 JOIN cte2 WHERE cte1.SalesProductId = cte2.ProductID;
               - name: MYSQLTopTenSalesOrdersByValue
                 run: SELECT entity_id AS 'Order ID', total_item_count AS 'Order Quantity', created_at AS 'Created Date', grand_total AS 'Grand Total' FROM sales_order ORDER BY grand_total DESC LIMIT 10;
               - name: MYSQLOrdersAverage
                 run: SELECT AVG(order_count) AS 'Average Number Of Orders', Year AS 'Year' FROM (SELECT YEAR(created_at) AS 'Year', COUNT(DISTINCT order_id) AS order_count FROM sales_order_item GROUP BY MONTH(created_at), YEAR(created_at)) subquery GROUP BY Year;
               - name: MYSQLWishlistProducts
                 run: SELECT w.product_id, p.value AS 'Product Name', SUM(w.qty) AS 'Wishlist Count' FROM wishlist_item as w LEFT JOIN catalog_product_entity_varchar as p ON p.entity_id = w.product_id WHERE attribute_id = 73 GROUP BY w.product_id, p.value ORDER BY 'Wishlist Count' DESC;
               - name: MYSQLProductPageViewWithNoInventory
                 run: SELECT v.product_id, v.product_name, v.views_num AS 'Page Views', i.qty AS 'Inventory Quantity' FROM report_viewed_product_aggregated_daily AS v LEFT JOIN cataloginventory_stock_item i ON i.product_id = v.product_id WHERE i.qty = 0 ORDER BY v.views_num DESC;
               - name: MYSQLHighestRestockAlerts
                 run: SELECT p.value as Product Name, p.entity_id as Product ID, count(a.alert_stock_id) as Restock Alert Count FROM `product_alert_stock` AS a, `catalog_product_entity_varchar` as p where a.product_id = p.value_id GROUP BY p.value, product_id order by 2 desc;
               - name: MYSQLSlowMovingProducts
                 run: SELECT cpev.entity_id as Product ID, cpev.value as Product Name, sum(isi.quantity) as Quantity from inventory_source_item as isi join catalog_product_entity as cpe on isi.sku = cpe.sku join catalog_product_entity_varchar as cpev on cpe.entity_id = cpev.entity_id where cpev.attribute_id = 73 group by Product ID, Product Name order by Quantity desc;
               - name: MYSQLAccountWithSmallTransaction
                 run: SELECT sum(grand_total) as Grand Total, customer_email FROM sales_order group by customer_email order by Grand Total ASC LIMIT 10;
               - name: MYSQLProfitableCustomers
                 run: select sum(grand_total) as Grand Total, customer_email from sales_order group by customer_email order by Grand Total desc LIMIT 10;
               - name: MYSQLRevenueLostDueToDiscounts
                 run: SELECT SUM(base_discount_amount) as 'Due to Discounts Revenue Loss' FROM `sales_order` WHERE `status` = 'complete';
               - name: MYSQLTotalSalesCountDueToDiscounts
                 run: SELECT count(base_discount_amount) as 'Due to Discounts Total Sales Count' FROM `sales_order` WHERE `status` = 'complete';
               - name: MYSQLProdCartAbandonment
                 run: Select c.value as Product Name, sum(q.items_count) as Abandoned Products Count from quote as q join catalog_product_entity_varchar as c on q.entity_id = c.entity_id WHERE customer_email IS NOT NULL AND reserved_order_id IS NULL AND subtotal != 0.0000 AND attribute_id = 73 group by Product Name order by Abandoned Products Count;
               - name: MYSQLPaymentMethodChangedFrequently
                 run: SELECT o.customer_id, o.customer_email, o.customer_is_guest, COUNT(DISTINCT p.method) AS transaction_count FROM sales_order AS o JOIN sales_order_payment AS p ON o.entity_id = p.parent_id GROUP BY o.customer_id, o.customer_email, o.customer_is_guest HAVING COUNT(DISTINCT p.method) > 1 ORDER BY transaction_count DESC LIMIT 10;
               - name: MYSQLCustomerAddressChanging
                 run: SELECT c.entity_id AS customer_id, c.email, COUNT(DISTINCT a.entity_id) AS address_count FROM customer_address_entity AS a JOIN customer_entity AS c ON a.parent_id = c.entity_id GROUP BY c.entity_id, c.email HAVING COUNT(DISTINCT a.entity_id) > 1 ORDER BY address_count DESC;
               - name: MYSQLCustomerPurchaseSameProd
                 run: select COUNT(soi.product_id) AS purchase_count, soi.product_id, soi.name as 'Product Name', so.customer_email from sales_order_item as soi join sales_order as so on soi.order_id = so.entity_id group by so.customer_email, soi.product_id, soi.name HAVING COUNT(soi.product_id) > 1 ORDER BY purchase_count DESC;
               - name: MYSQLProductReturned
                 run: SELECT soi.product_id, count(soi.product_id) as 'Returned Product Count' FROM `sales_order` as o join `sales_order_item` as soi ON o.entity_id = soi.order_id where o.status = 'closed' and o.total_refunded is not null GROUP BY soi.product_id HAVING COUNT(soi.product_id) > 1;

   Copier

Redémarrer l'agent d'infrastructure

Avant de pouvoir commencer à lire vos données, utilisez les instructions de notre documentation suragent d'infrastructure pour redémarrer votre agent d'infrastructure.

Installer le dashboard détaillé des informations commerciales Magento

1. Allez à one.newrelic.com > Integrations & Agents > Dashboards.

2. Dans la barre de recherche, tapez « Informations commerciales Magento détaillées ». Le dashboard devrait apparaître.

3. Cliquez dessus pour l'installer.

   Votre dashboard Magento est considéré comme un dashboard personnalisé et peut être trouvé dans l' UI Dashboards. Pour plus d'informations sur l'utilisation et la modification des dashboards, consultez notre documentation dashboard.