商标续展监控数据集

1、数据采集：通过在公司商标管理系统上获取客户商标续展信息； 2、数据加工：按企业名称、商标号、商标名称、商标申请日期、商标到期日期、是否发送短信提醒、联系人、联系电话、备注类目汇总形成公司客户商标监控数据集；按照企业名称进行升序排列，将同一企业的商标汇集起来；对收集的数据进行清洗，包括去除空格、转变日期格式、根据备注内容（客户自行处理、已过期、无效、待审中等）进行处理；3、数据应用：根据备注类目下的内容整理，再形成商标销亡过期清单、商标驳回及无效清单、商标客户自行处理清单；对剩余有效商标，开展动态监控。当商标即将到期，对客户发送短信提醒；其计算规则是利用IF函数，输入公式：IF=(TODAY()=到期日期-365,1,0）“1”表示发送短信提醒，“0”表示不进行短信提醒。1. Data Collection: Obtain customer trademark renewal information via the company's trademark management system. 2. Data Processing: Compile a corporate customer trademark monitoring dataset by summarizing the following fields: enterprise name, trademark number, trademark name, trademark application date, trademark expiration date, whether an SMS reminder is sent, contact person, contact phone number, and remark category; sort the dataset in ascending order by enterprise name and aggregate trademarks belonging to the same enterprise; clean the collected data, including removing redundant whitespace, standardizing date formats, and processing based on remark contents such as customer self-handled, expired, invalid, pending review, etc. 3. Data Application: Organize data based on remark categories to generate three specialized lists: the Trademark Expiration and Cancellation List, the Trademark Rejection and Invalidity List, and the Customer Self-Handled Trademark List; conduct dynamic monitoring on the remaining valid trademarks. Send SMS reminders to customers when their trademarks are about to expire, with the calculation rule utilizing the IF function: =IF(TODAY()=expiration_date - 365, 1, 0), where "1" indicates that an SMS reminder will be sent, and "0" indicates no SMS reminder will be sent.

搜集汇总

背景与挑战

背景概述

商标续展监控数据集包含2640条记录，用于监控商标续展时间节点，避免商标失效。数据集提供动态监控和短信提醒功能，适用于知识产权代理服务。