{"id":2479,"date":"2020-04-21T18:23:25","date_gmt":"2020-04-21T18:23:25","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-calculer-le-nombre-de-mois-entre-la-derniere-vente-dun-client-et-lavant-derniere\/"},"modified":"2026-07-28T18:26:00","modified_gmt":"2026-07-28T18:26:00","slug":"comment-calculer-le-nombre-de-mois-entre-la-derniere-vente-dun-client-et-lavant-derniere","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-calculer-le-nombre-de-mois-entre-la-derniere-vente-dun-client-et-lavant-derniere\/","title":{"rendered":"Comment calculer le nombre de mois entre la derni\u00e8re vente d\u2019un client et l\u2019avant-derni\u00e8re"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"Calculez le temps \u00e9coul\u00e9 entre la derni\u00e8re vente d'un client et l'avant-derni\u00e8re afin de faciliter l'analyse de r\u00e9activation marketing.","ga_short_answer":"Pour calculer le nombre de mois entre la derni\u00e8re vente d\u2019un client et l\u2019avant-derni\u00e8re, utilisez la fonction MONTHS_BETWEEN. Cela implique d\u2019identifier la date de l\u2019avant-derni\u00e8re transaction \u00e0 l\u2019aide de la fonction DENSE_RANK(), partitionn\u00e9e par nom de client et tri\u00e9e par date de transaction par ordre d\u00e9croissant, puis de la comparer \u00e0 la date de la derni\u00e8re vente.","ga_scenario":"Les entreprises ont souvent besoin d\u2019une m\u00e9thode pour identifier les clients r\u00e9activ\u00e9s dans le cadre de leurs initiatives marketing. La r\u00e9activation est d\u00e9finie comme une nouvelle vente intervenant apr\u00e8s une p\u00e9riode de 24 mois ou plus sans aucune activit\u00e9 de vente pr\u00e9alable. Pour d\u00e9terminer cela, il est n\u00e9cessaire de <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-calculate-the-number-of-days-in-a-month-in-netsuite\/\">calculer la diff\u00e9rence de temps<\/a> entre la date de la derni\u00e8re vente d\u2019un client et celle de son avant-derni\u00e8re vente.","ga_solution":"Pour calculer le nombre de mois entre la derni\u00e8re vente d\u2019un client et son avant-derni\u00e8re vente, utilisez la formule suivante. Cette formule utilise la fonction MONTHS_BETWEEN pour comparer la date de la derni\u00e8re vente du client \u00e0 celle de son avant-derni\u00e8re transaction, identifi\u00e9e \u00e0 l\u2019aide de DENSE_RANK().MONTHS_BETWEEN({customer.lastsaledate}, (CASE WHEN (DENSE_RANK() OVER(PARTITION BY {name} ORDER BY {trandate} DESC))=2 THEN {trandate} END))","ga_source_author":"Louis Morin","ga_source_author_email":"","ga_date_original":"2020-04-21T11:23:25-07:00","ga_date_verified":"2026-07-05","ga_source_subject":"How do I calculate the number of months between the Customer's 2nd Last Sale And Last Sale","ga_ans_id":"ANS-0003","ga_publish_decision":"publish","ga_staleness_risk":"medium","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89,89],"ga_difficulty":[92,92],"class_list":["post-2479","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-administrateur-netsuite","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":91,"label":"Recherches enregistr\u00e9es et formules"},{"value":3,"label":"Saved Searches & Formulas"},{"value":91,"label":"Recherches enregistr\u00e9es et formules"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"},{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":92,"label":"Niveau interm\u00e9diaire"},{"value":92,"label":"Niveau interm\u00e9diaire"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2479","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2479\/revisions"}],"predecessor-version":[{"id":2499,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2479\/revisions\/2499"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2479"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2479"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2479"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}