{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["转码设置","URLBuilder","说明"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"转码设置","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["表名：","URLBuilder"]
["源数据列：","14"]
["目标数据列：","15"]
["状态（当前/总）：","228/228"]

{"sheet":"URLBuilder","index":1,"n_rows":246,"n_cols":14,"rows_kept":246,"cut":false,"hidden":false,"merged":[[0,6,0,11],[0,0,0,5]]}
["索引区(注释)",null,null,null,null,null,"填写区",null,null,null,null,null,null,"生成区"]
["序号","活动名称","渠道/媒体","投放方式","关键字","媒体_位置_创意类别序列号/关键字序号","活动地址\nURL","*来源\nutm_source","*媒介\nutm_medium","*活动名称\nutm_campaign","搜索关键字\nutm_term","内容\nutm_content","nooverride","最终URL"]
["01",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G3&(IF(H3=\"\",\"\",(IF(ISNUMBER(FIND(\"?\",G3)),\"&utm_source=\",\"?utm_source=\")))&SUBSTITUTE((H3),\" \",\"\")&(IF(I3=\"\",\"\",\"&utm_medium=\")&I3)&(IF(J3=\"\",\"\",\"&utm_campaign=\")&SUBSTITUTE(UrlToUTF8(J3),\" \",\"\"))&(IF(K3=\"\",\"\",\"&utm_term=\")&SUBSTITUTE(UrlToUTF8(K3),\" \",\"\"))&(IF(L3=\"\",\"\",\"&utm_content=\")&SUBSTITUTE(getpy(L3),\" \",\"\"))&IF(M3=1,\"&utm_nooverride=1\",\"\"))","v":""}]
["02",null,null,null,null,null,null,null,null,null,null,null,null,""]
["03",null,null,null,null,null,null,null,null,null,null,null,null,""]
["04",null,null,null,null,null,null,null,null,{"$f":"IF(B6=\"\",\"\",B6)","v":""},"",{"$f":"IF(F6=\"\",\"\",F6)","v":""},null,""]
["05",null,null,null,null,null,null,null,null,"","","",null,""]
["06",null,null,null,null,null,null,null,null,"","","",null,""]
["07",null,null,null,null,null,null,null,null,"","","",null,""]
["08",null,null,null,null,null,null,null,null,"","","",null,""]
["09",null,null,null,null,null,null,null,null,"","","",null,""]
["10",null,null,null,null,null,null,null,null,"","","",null,""]
["11",null,null,null,null,null,null,null,null,"","","",null,""]
["12",null,null,null,null,null,null,null,null,"","","",null,""]
["13",null,null,null,null,null,null,null,null,"","","",null,""]
["14",null,null,null,null,null,null,null,null,"","","",null,""]
["15",null,null,null,null,null,null,null,null,"","","",null,""]
["16",null,null,null,null,null,null,null,null,"","","",null,""]
["17",null,null,null,null,null,null,null,null,"","","",null,""]
["18",null,null,null,null,null,null,null,null,"","","",null,""]
["19",null,null,null,null,null,null,null,null,"","","",null,""]
["20",null,null,null,null,null,null,null,null,"","","",null,""]
["21",null,null,null,null,null,null,null,null,"","","",null,""]
["22",null,null,null,null,null,null,null,null,"","","",null,""]
["23",null,null,null,null,null,null,null,null,"","","",null,""]
["24",null,null,null,null,null,null,null,null,"","","",null,""]
["25",null,null,null,null,null,null,null,null,"","","",null,""]
["26",null,null,null,null,null,null,null,null,"","","",null,""]
["27",null,null,null,null,null,null,null,null,"","","",null,""]
["28",null,null,null,null,null,null,null,null,"","","",null,""]
["29",null,null,null,null,null,null,null,null,"","","",null,""]
["30",null,null,null,null,null,null,null,null,"","","",null,""]
["31",null,null,null,null,null,null,null,null,"","","",null,""]
["32",null,null,null,null,null,null,null,null,"","","",null,""]
["33",null,null,null,null,null,null,null,null,"","","",null,""]
["34",null,null,null,null,null,null,null,null,"","","",null,""]
["35",null,null,null,null,null,null,null,null,"","","",null,""]
["36",null,null,null,null,null,null,null,null,"","","",null,""]
["37",null,null,null,null,null,null,null,null,"","","",null,""]
["38",null,null,null,null,null,null,null,null,"","","",null,""]
["39",null,null,null,null,null,null,null,null,"","","",null,""]
["40",null,null,null,null,null,null,null,null,"","","",null,""]
["41",null,null,null,null,null,null,null,null,"","","",null,""]
["42",null,null,null,null,null,null,null,null,"","","",null,""]
["43",null,null,null,null,null,null,null,null,"","","",null,""]
["44",null,null,null,null,null,null,null,null,"","","",null,""]
["45",null,null,null,null,null,null,null,null,"","","",null,""]
["46",null,null,null,null,null,null,null,null,"","","",null,""]
["47",null,null,null,null,null,null,null,null,"","","",null,""]
["48",null,null,null,null,null,null,null,null,"","","",null,""]
["49",null,null,null,null,null,null,null,null,"","","",null,""]
["50",null,null,null,null,null,null,null,null,"","","",null,""]
["51",null,null,null,null,null,null,null,null,"","","",null,""]
["52",null,null,null,null,null,null,null,null,"","","",null,""]
["53",null,null,null,null,null,null,null,null,"","","",null,""]
["54",null,null,null,null,null,null,null,null,"","","",null,""]
["55",null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,{"$f":"G67&(IF(H67=\"\",\"\",(IF(ISNUMBER(FIND(\"?\",G67)),\"&utm_source=\",\"?utm_source=\")))&SUBSTITUTE((H67),\" \",\"\")&(IF(I67=\"\",\"\",\"&utm_medium=\")&I67)&(IF(J67=\"\",\"\",\"&utm_campaign=\")&SUBSTITUTE(UrlToUTF8(J67),\" \",\"\"))&(IF(K67=\"\",\"\",\"&utm_term=\")&SUBSTITUTE(UrlToUTF8(K67),\" \",\"\"))&(IF(L67=\"\",\"\",\"&utm_content=\")&SUBSTITUTE(getpy(L67),\" \",\"\"))&IF(M67=1,\"&utm_nooverride=1\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B68=\"\",\"\",B68)","v":""},"",{"$f":"IF(F68=\"\",\"\",F68)","v":""},null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,{"$f":"G131&(IF(H131=\"\",\"\",(IF(ISNUMBER(FIND(\"?\",G131)),\"&utm_source=\",\"?utm_source=\")))&SUBSTITUTE((H131),\" \",\"\")&(IF(I131=\"\",\"\",\"&utm_medium=\")&I131)&(IF(J131=\"\",\"\",\"&utm_campaign=\")&SUBSTITUTE(UrlToUTF8(J131),\" \",\"\"))&(IF(K131=\"\",\"\",\"&utm_term=\")&SUBSTITUTE(UrlToUTF8(K131),\" \",\"\"))&(IF(L131=\"\",\"\",\"&utm_content=\")&SUBSTITUTE(getpy(L131),\" \",\"\"))&IF(M131=1,\"&utm_nooverride=1\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B132=\"\",\"\",B132)","v":""},"",{"$f":"IF(F132=\"\",\"\",F132)","v":""},null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,{"$f":"G195&(IF(H195=\"\",\"\",(IF(ISNUMBER(FIND(\"?\",G195)),\"&utm_source=\",\"?utm_source=\")))&SUBSTITUTE((H195),\" \",\"\")&(IF(I195=\"\",\"\",\"&utm_medium=\")&I195)&(IF(J195=\"\",\"\",\"&utm_campaign=\")&SUBSTITUTE(UrlToUTF8(J195),\" \",\"\"))&(IF(K195=\"\",\"\",\"&utm_term=\")&SUBSTITUTE(UrlToUTF8(K195),\" \",\"\"))&(IF(L195=\"\",\"\",\"&utm_content=\")&SUBSTITUTE(getpy(L195),\" \",\"\"))&IF(M195=1,\"&utm_nooverride=1\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B196=\"\",\"\",B196)","v":""},"",{"$f":"IF(F196=\"\",\"\",F196)","v":""},null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]

{"sheet":"说明","index":2,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,24,4],[0,6,19,11]]}
["UTM标记规则说明：\n填充完规则表后，点击中文转码，对utm标记的URL进行转码（GA不支持GB2312编码，需要转码为相应的UTF-8编码）\n广告投放标记规则：\nhttp://www.test.com.cn?utm_source=CCE&utm_medium=Display&utm_campaign=Q1Verticalkickoffcampaign&utm_content=CCE_HPLeaderboard_b01\nutm_source={媒体名称}&utm_medium=Display(标记为展示广告类型)&utm_campaign={活动名称}&utm_content={媒体_位置_创意类别_序列号}\n\nSEM标记规则：\nhttp://www.test.com.cn?utm_source=baidu&utm_medium=PPC&utm_campaign=richangtuiguang&utm_term=%E6%96%B0%E8%92%99%E8%BF%AA%E6%AC%A7&utm_content=SiYuPCDuanaSiYup01\nutm_source={SEM投放网站}&utm_medium=PPC{不建议使用CPC进行标记，统一使用PPC}&utm_campaign={活动名称}&utm_term={经过UTF8编码的关键字}&utm_content={关键字序号或者其他信息}\n\nEmail营销标记规则:\nhttp://www.test.com.cn?utm_source=VVIP&utm_medium=Email&utm_campaign=Q1VerticalkickoffEmail\n?utm_source={投放会员类型或者其他Email投放类别信息}&utm_medium=Email{标记为Email营销}&utm_campaign={营销活动信息}\n\n本文档通过使用VBA进行写成，如果不需要使用中文转码，则可以任意使用，若需要中文转码，则不能在文档中增加或者删减行列，以造成VBA无法正常工作。如果需要使用说明文字占用的单元格，可直接删除并使用取消合并即可。",null,null,null,null,null,"文档使用说明：\n注意：文档中使用了VBA对中文标记进行转码，使用时应在文档中启用宏功能\n\n建议：复制本Excel文档，对展示广告投放，SEM投放，Email营销投放分别进行处理"]