{
  "version": 21,
  "sheets": [
    {
      "id": "sheet1",
      "name": "Main Dashboard",
      "colNumber": 26,
      "rowNumber": 103,
      "rows": {
        "29": { "size": 38 },
        "47": { "size": 40 },
        "48": { "size": 34 },
        "49": { "size": 32 },
        "50": { "size": 32 },
        "51": { "size": 32 },
        "52": { "size": 32 },
        "53": { "size": 32 },
        "54": { "size": 32 },
        "55": { "size": 32 },
        "56": { "size": 32 },
        "57": { "size": 32 },
        "58": { "size": 27 },
        "60": { "size": 38 },
        "61": { "size": 32 },
        "62": { "size": 32 },
        "63": { "size": 32 },
        "64": { "size": 32 },
        "65": { "size": 32 },
        "66": { "size": 32 },
        "67": { "size": 32 },
        "68": { "size": 32 },
        "69": { "size": 32 },
        "70": { "size": 32 },
        "71": { "size": 32 },
        "73": { "size": 39 },
        "74": { "size": 31 },
        "75": { "size": 32 },
        "76": { "size": 32 },
        "77": { "size": 32 },
        "78": { "size": 32 },
        "79": { "size": 32 },
        "80": { "size": 32 },
        "81": { "size": 32 },
        "82": { "size": 32 },
        "83": { "size": 32 },
        "84": { "size": 32 },
        "86": { "size": 37 },
        "87": { "size": 34 },
        "88": { "size": 32 },
        "89": { "size": 32 },
        "90": { "size": 32 },
        "91": { "size": 32 },
        "92": { "size": 32 }
      },
      "cols": {
        "0": { "size": 139 },
        "1": { "size": 239 },
        "2": { "size": 87 },
        "3": { "size": 112 },
        "4": { "size": 109 },
        "5": { "size": 107 },
        "6": { "size": 124 },
        "7": { "size": 125 },
        "8": { "isHidden": true, "size": 135 },
        "9": { "isHidden": true, "size": 120 },
        "10": { "isHidden": true, "size": 127 },
        "11": { "isHidden": true, "size": 127 },
        "12": { "isHidden": true, "size": 127 },
        "13": { "isHidden": true },
        "14": { "isHidden": true },
        "15": { "isHidden": true },
        "16": { "isHidden": true },
        "17": { "isHidden": true },
        "18": { "isHidden": true },
        "19": { "isHidden": true },
        "20": { "isHidden": true },
        "21": { "isHidden": true },
        "22": { "isHidden": true },
        "23": { "isHidden": true },
        "24": { "isHidden": true },
        "25": { "isHidden": true }
      },
      "merges": [
        "B62:D62",
        "B63:D63",
        "B64:D64",
        "B65:D65",
        "B66:D66",
        "B67:D67",
        "B68:D68",
        "B69:D69",
        "B70:D70",
        "B71:D71",
        "B72:D72",
        "E63:F63",
        "E62:F62",
        "E64:F64",
        "E65:F65",
        "E66:F66",
        "E67:F67",
        "E68:F68",
        "E69:F69",
        "E70:F70",
        "E71:F71",
        "E72:F72",
        "E75:F75",
        "E76:F76",
        "E77:F77",
        "E78:F78",
        "E79:F79",
        "E80:F80",
        "E81:F81",
        "E82:F82",
        "E83:F83",
        "E84:F84",
        "E85:F85",
        "B85:D85",
        "B84:D84",
        "B83:D83",
        "B82:D82",
        "B81:D81",
        "B80:D80",
        "B79:D79",
        "B78:D78",
        "B77:D77",
        "B76:D76",
        "B75:D75",
        "A88:B88",
        "A89:B89",
        "A90:B90",
        "A91:B91",
        "A92:B92",
        "A93:B93"
      ],
      "cells": {
        "A12": { "content": "=_t(\"Mails sent per month\")" },
        "A30": { "content": "=_t(\"Mails sent over previous period\")" },
        "A48": { "content": "=_t(\"Top 10 recent mailing campaigns\")" },
        "A49": { "content": "=ODOO.LIST.HEADER(2,\"sent_date\")" },
        "A50": { "content": "=ODOO.LIST(2,1,\"sent_date\")" },
        "A51": { "content": "=ODOO.LIST(2,2,\"sent_date\")" },
        "A52": { "content": "=ODOO.LIST(2,3,\"sent_date\")" },
        "A53": { "content": "=ODOO.LIST(2,4,\"sent_date\")" },
        "A54": { "content": "=ODOO.LIST(2,5,\"sent_date\")" },
        "A55": { "content": "=ODOO.LIST(2,6,\"sent_date\")" },
        "A56": { "content": "=ODOO.LIST(2,7,\"sent_date\")" },
        "A57": { "content": "=ODOO.LIST(2,8,\"sent_date\")" },
        "A58": { "content": "=ODOO.LIST(2,9,\"sent_date\")" },
        "A59": { "content": "=ODOO.LIST(2,10,\"sent_date\")" },
        "A61": { "content": "=_t(\"Mailing campaigns in preparation\")" },
        "A62": { "content": "=ODOO.LIST.HEADER(3,\"schedule_date\")" },
        "A63": { "content": "=ODOO.LIST(3,1,\"schedule_date\")" },
        "A64": { "content": "=ODOO.LIST(3,2,\"schedule_date\")" },
        "A65": { "content": "=ODOO.LIST(3,3,\"schedule_date\")" },
        "A66": { "content": "=ODOO.LIST(3,4,\"schedule_date\")" },
        "A67": { "content": "=ODOO.LIST(3,5,\"schedule_date\")" },
        "A68": { "content": "=ODOO.LIST(3,6,\"schedule_date\")" },
        "A69": { "content": "=ODOO.LIST(3,7,\"schedule_date\")" },
        "A70": { "content": "=ODOO.LIST(3,8,\"schedule_date\")" },
        "A71": { "content": "=ODOO.LIST(3,9,\"schedule_date\")" },
        "A72": { "content": "=ODOO.LIST(3,10,\"schedule_date\")" },
        "A74": { "content": "=_t(\"Top 10 best link trackers\")" },
        "A75": { "content": "=ODOO.LIST.HEADER(4,\"create_date\")" },
        "A76": { "content": "=ODOO.LIST(4,1,\"create_date\")" },
        "A77": { "content": "=ODOO.LIST(4,2,\"create_date\")" },
        "A78": { "content": "=ODOO.LIST(4,3,\"create_date\")" },
        "A79": { "content": "=ODOO.LIST(4,4,\"create_date\")" },
        "A80": { "content": "=ODOO.LIST(4,5,\"create_date\")" },
        "A81": { "content": "=ODOO.LIST(4,6,\"create_date\")" },
        "A82": { "content": "=ODOO.LIST(4,7,\"create_date\")" },
        "A83": { "content": "=ODOO.LIST(4,8,\"create_date\")" },
        "A84": { "content": "=ODOO.LIST(4,9,\"create_date\")" },
        "A85": { "content": "=ODOO.LIST(4,10,\"create_date\")" },
        "A87": { "content": "=_t(\"Top 5 failed reasons\")" },
        "A88": { "content": "=_t(\"Reason\")" },
        "A89": { "content": "=PIVOT.HEADER(10,\"#failure_type\",1)" },
        "A90": { "content": "=PIVOT.HEADER(10,\"#failure_type\",2)" },
        "A91": { "content": "=PIVOT.HEADER(10,\"#failure_type\",3)" },
        "A92": { "content": "=PIVOT.HEADER(10,\"#failure_type\",4)" },
        "A93": { "content": "=PIVOT.HEADER(10,\"#failure_type\",5)" },
        "B49": { "content": "=ODOO.LIST.HEADER(2,\"subject\")" },
        "B50": { "content": "=ODOO.LIST(2,1,\"subject\")" },
        "B51": { "content": "=ODOO.LIST(2,2,\"subject\")" },
        "B52": { "content": "=ODOO.LIST(2,3,\"subject\")" },
        "B53": { "content": "=ODOO.LIST(2,4,\"subject\")" },
        "B54": { "content": "=ODOO.LIST(2,5,\"subject\")" },
        "B55": { "content": "=ODOO.LIST(2,6,\"subject\")" },
        "B56": { "content": "=ODOO.LIST(2,7,\"subject\")" },
        "B57": { "content": "=ODOO.LIST(2,8,\"subject\")" },
        "B58": { "content": "=ODOO.LIST(2,9,\"subject\")" },
        "B59": { "content": "=ODOO.LIST(2,10,\"subject\")" },
        "B62": { "content": "=ODOO.LIST.HEADER(3,\"subject\")" },
        "B63": { "content": "=ODOO.LIST(3,1,\"subject\")" },
        "B64": { "content": "=ODOO.LIST(3,2,\"subject\")" },
        "B65": { "content": "=ODOO.LIST(3,3,\"subject\")" },
        "B66": { "content": "=ODOO.LIST(3,4,\"subject\")" },
        "B67": { "content": "=ODOO.LIST(3,5,\"subject\")" },
        "B68": { "content": "=ODOO.LIST(3,6,\"subject\")" },
        "B69": { "content": "=ODOO.LIST(3,7,\"subject\")" },
        "B70": { "content": "=ODOO.LIST(3,8,\"subject\")" },
        "B71": { "content": "=ODOO.LIST(3,9,\"subject\")" },
        "B72": { "content": "=ODOO.LIST(3,10,\"subject\")" },
        "B75": { "content": "=ODOO.LIST.HEADER(4,\"title\")" },
        "B76": { "content": "=ODOO.LIST(4,1,\"title\")" },
        "B77": { "content": "=ODOO.LIST(4,2,\"title\")" },
        "B78": { "content": "=ODOO.LIST(4,3,\"title\")" },
        "B79": { "content": "=ODOO.LIST(4,4,\"title\")" },
        "B80": { "content": "=ODOO.LIST(4,5,\"title\")" },
        "B81": { "content": "=ODOO.LIST(4,6,\"title\")" },
        "B82": { "content": "=ODOO.LIST(4,7,\"title\")" },
        "B83": { "content": "=ODOO.LIST(4,8,\"title\")" },
        "B84": { "content": "=ODOO.LIST(4,9,\"title\")" },
        "B85": { "content": "=ODOO.LIST(4,10,\"title\")" },
        "C49": { "content": "=ODOO.LIST.HEADER(2,\"sent\")" },
        "C50": { "content": "=ODOO.LIST(2,1,\"sent\")" },
        "C51": { "content": "=ODOO.LIST(2,2,\"sent\")" },
        "C52": { "content": "=ODOO.LIST(2,3,\"sent\")" },
        "C53": { "content": "=ODOO.LIST(2,4,\"sent\")" },
        "C54": { "content": "=ODOO.LIST(2,5,\"sent\")" },
        "C55": { "content": "=ODOO.LIST(2,6,\"sent\")" },
        "C56": { "content": "=ODOO.LIST(2,7,\"sent\")" },
        "C57": { "content": "=ODOO.LIST(2,8,\"sent\")" },
        "C58": { "content": "=ODOO.LIST(2,9,\"sent\")" },
        "C59": { "content": "=ODOO.LIST(2,10,\"sent\")" },
        "C88": { "content": "=_t(\"Count\")" },
        "C89": {
          "content": "=PIVOT.VALUE(10,\"__count:sum\",\"#failure_type\",1)"
        },
        "C90": {
          "content": "=PIVOT.VALUE(10,\"__count:sum\",\"#failure_type\",2)"
        },
        "C91": {
          "content": "=PIVOT.VALUE(10,\"__count:sum\",\"#failure_type\",3)"
        },
        "C92": {
          "content": "=PIVOT.VALUE(10,\"__count:sum\",\"#failure_type\",4)"
        },
        "C93": {
          "content": "=PIVOT.VALUE(10,\"__count:sum\",\"#failure_type\",5)"
        },
        "D49": { "content": "=_t(\"Received (%)\")" },
        "D50": { "content": "=ODOO.LIST(2,1,\"received_ratio\")" },
        "D51": { "content": "=ODOO.LIST(2,2,\"received_ratio\")" },
        "D52": { "content": "=ODOO.LIST(2,3,\"received_ratio\")" },
        "D53": { "content": "=ODOO.LIST(2,4,\"received_ratio\")" },
        "D54": { "content": "=ODOO.LIST(2,5,\"received_ratio\")" },
        "D55": { "content": "=ODOO.LIST(2,6,\"received_ratio\")" },
        "D56": { "content": "=ODOO.LIST(2,7,\"received_ratio\")" },
        "D57": { "content": "=ODOO.LIST(2,8,\"received_ratio\")" },
        "D58": { "content": "=ODOO.LIST(2,9,\"received_ratio\")" },
        "D59": { "content": "=ODOO.LIST(2,10,\"received_ratio\")" },
        "E49": { "content": "=_t(\"Opened (%)\")" },
        "E50": { "content": "=ODOO.LIST(2,1,\"opened_ratio\")" },
        "E51": { "content": "=ODOO.LIST(2,2,\"opened_ratio\")" },
        "E52": { "content": "=ODOO.LIST(2,3,\"opened_ratio\")" },
        "E53": { "content": "=ODOO.LIST(2,4,\"opened_ratio\")" },
        "E54": { "content": "=ODOO.LIST(2,5,\"opened_ratio\")" },
        "E55": { "content": "=ODOO.LIST(2,6,\"opened_ratio\")" },
        "E56": { "content": "=ODOO.LIST(2,7,\"opened_ratio\")" },
        "E57": { "content": "=ODOO.LIST(2,8,\"opened_ratio\")" },
        "E58": { "content": "=ODOO.LIST(2,9,\"opened_ratio\")" },
        "E59": { "content": "=ODOO.LIST(2,10,\"opened_ratio\")" },
        "E62": { "content": "=ODOO.LIST.HEADER(3,\"user_id\")" },
        "E63": { "content": "=ODOO.LIST(3,1,\"user_id\")" },
        "E64": { "content": "=ODOO.LIST(3,2,\"user_id\")" },
        "E65": { "content": "=ODOO.LIST(3,3,\"user_id\")" },
        "E66": { "content": "=ODOO.LIST(3,4,\"user_id\")" },
        "E67": { "content": "=ODOO.LIST(3,5,\"user_id\")" },
        "E68": { "content": "=ODOO.LIST(3,6,\"user_id\")" },
        "E69": { "content": "=ODOO.LIST(3,7,\"user_id\")" },
        "E70": { "content": "=ODOO.LIST(3,8,\"user_id\")" },
        "E71": { "content": "=ODOO.LIST(3,9,\"user_id\")" },
        "E72": { "content": "=ODOO.LIST(3,10,\"user_id\")" },
        "E75": { "content": "=ODOO.LIST.HEADER(4,\"url\")" },
        "E76": { "content": "=ODOO.LIST(4,1,\"url\")" },
        "E77": { "content": "=ODOO.LIST(4,2,\"url\")" },
        "E78": { "content": "=ODOO.LIST(4,3,\"url\")" },
        "E79": { "content": "=ODOO.LIST(4,4,\"url\")" },
        "E80": { "content": "=ODOO.LIST(4,5,\"url\")" },
        "E81": { "content": "=ODOO.LIST(4,6,\"url\")" },
        "E82": { "content": "=ODOO.LIST(4,7,\"url\")" },
        "E83": { "content": "=ODOO.LIST(4,8,\"url\")" },
        "E84": { "content": "=ODOO.LIST(4,9,\"url\")" },
        "E85": { "content": "=ODOO.LIST(4,10,\"url\")" },
        "F49": { "content": "=_t(\"Replied (%)\")" },
        "F50": { "content": "=ODOO.LIST(2,1,\"replied_ratio\")" },
        "F51": { "content": "=ODOO.LIST(2,2,\"replied_ratio\")" },
        "F52": { "content": "=ODOO.LIST(2,3,\"replied_ratio\")" },
        "F53": { "content": "=ODOO.LIST(2,4,\"replied_ratio\")" },
        "F54": { "content": "=ODOO.LIST(2,5,\"replied_ratio\")" },
        "F55": { "content": "=ODOO.LIST(2,6,\"replied_ratio\")" },
        "F56": { "content": "=ODOO.LIST(2,7,\"replied_ratio\")" },
        "F57": { "content": "=ODOO.LIST(2,8,\"replied_ratio\")" },
        "F58": { "content": "=ODOO.LIST(2,9,\"replied_ratio\")" },
        "F59": { "content": "=ODOO.LIST(2,10,\"replied_ratio\")" },
        "G49": { "content": "=_t(\"Clicks (%)\")" },
        "G50": { "content": "=ODOO.LIST(2,1,\"clicks_ratio\")" },
        "G51": { "content": "=ODOO.LIST(2,2,\"clicks_ratio\")" },
        "G52": { "content": "=ODOO.LIST(2,3,\"clicks_ratio\")" },
        "G53": { "content": "=ODOO.LIST(2,4,\"clicks_ratio\")" },
        "G54": { "content": "=ODOO.LIST(2,5,\"clicks_ratio\")" },
        "G55": { "content": "=ODOO.LIST(2,6,\"clicks_ratio\")" },
        "G56": { "content": "=ODOO.LIST(2,7,\"clicks_ratio\")" },
        "G57": { "content": "=ODOO.LIST(2,8,\"clicks_ratio\")" },
        "G58": { "content": "=ODOO.LIST(2,9,\"clicks_ratio\")" },
        "G59": { "content": "=ODOO.LIST(2,10,\"clicks_ratio\")" },
        "G62": { "content": "=ODOO.LIST.HEADER(3,\"state\")" },
        "G63": { "content": "=ODOO.LIST(3,1,\"state\")" },
        "G64": { "content": "=ODOO.LIST(3,2,\"state\")" },
        "G65": { "content": "=ODOO.LIST(3,3,\"state\")" },
        "G66": { "content": "=ODOO.LIST(3,4,\"state\")" },
        "G67": { "content": "=ODOO.LIST(3,5,\"state\")" },
        "G68": { "content": "=ODOO.LIST(3,6,\"state\")" },
        "G69": { "content": "=ODOO.LIST(3,7,\"state\")" },
        "G70": { "content": "=ODOO.LIST(3,8,\"state\")" },
        "G71": { "content": "=ODOO.LIST(3,9,\"state\")" },
        "G72": { "content": "=ODOO.LIST(3,10,\"state\")" },
        "G75": { "content": "=ODOO.LIST.HEADER(4,\"mass_mailing_id\")" },
        "G76": { "content": "=ODOO.LIST(4,1,\"mass_mailing_id\")" },
        "G77": { "content": "=ODOO.LIST(4,2,\"mass_mailing_id\")" },
        "G78": { "content": "=ODOO.LIST(4,3,\"mass_mailing_id\")" },
        "G79": { "content": "=ODOO.LIST(4,4,\"mass_mailing_id\")" },
        "G80": { "content": "=ODOO.LIST(4,5,\"mass_mailing_id\")" },
        "G81": { "content": "=ODOO.LIST(4,6,\"mass_mailing_id\")" },
        "G82": { "content": "=ODOO.LIST(4,7,\"mass_mailing_id\")" },
        "G83": { "content": "=ODOO.LIST(4,8,\"mass_mailing_id\")" },
        "G84": { "content": "=ODOO.LIST(4,9,\"mass_mailing_id\")" },
        "G85": { "content": "=ODOO.LIST(4,10,\"mass_mailing_id\")" },
        "H49": { "content": "=_t(\"Bounced (%)\")" },
        "H50": { "content": "=ODOO.LIST(2,1,\"bounced_ratio\")" },
        "H51": { "content": "=ODOO.LIST(2,2,\"bounced_ratio\")" },
        "H52": { "content": "=ODOO.LIST(2,3,\"bounced_ratio\")" },
        "H53": { "content": "=ODOO.LIST(2,4,\"bounced_ratio\")" },
        "H54": { "content": "=ODOO.LIST(2,5,\"bounced_ratio\")" },
        "H55": { "content": "=ODOO.LIST(2,6,\"bounced_ratio\")" },
        "H56": { "content": "=ODOO.LIST(2,7,\"bounced_ratio\")" },
        "H57": { "content": "=ODOO.LIST(2,8,\"bounced_ratio\")" },
        "H58": { "content": "=ODOO.LIST(2,9,\"bounced_ratio\")" },
        "H59": { "content": "=ODOO.LIST(2,10,\"bounced_ratio\")" },
        "H62": { "content": "=ODOO.LIST.HEADER(3,\"mailing_model_id\")" },
        "H63": { "content": "=ODOO.LIST(3,1,\"mailing_model_id\")" },
        "H64": { "content": "=ODOO.LIST(3,2,\"mailing_model_id\")" },
        "H65": { "content": "=ODOO.LIST(3,3,\"mailing_model_id\")" },
        "H66": { "content": "=ODOO.LIST(3,4,\"mailing_model_id\")" },
        "H67": { "content": "=ODOO.LIST(3,5,\"mailing_model_id\")" },
        "H68": { "content": "=ODOO.LIST(3,6,\"mailing_model_id\")" },
        "H69": { "content": "=ODOO.LIST(3,7,\"mailing_model_id\")" },
        "H70": { "content": "=ODOO.LIST(3,8,\"mailing_model_id\")" },
        "H71": { "content": "=ODOO.LIST(3,9,\"mailing_model_id\")" },
        "H72": { "content": "=ODOO.LIST(3,10,\"mailing_model_id\")" },
        "H75": { "content": "=ODOO.LIST.HEADER(4,\"count\")" },
        "H76": { "content": "=ODOO.LIST(4,1,\"count\")" },
        "H77": { "content": "=ODOO.LIST(4,2,\"count\")" },
        "H78": { "content": "=ODOO.LIST(4,3,\"count\")" },
        "H79": { "content": "=ODOO.LIST(4,4,\"count\")" },
        "H80": { "content": "=ODOO.LIST(4,5,\"count\")" },
        "H81": { "content": "=ODOO.LIST(4,6,\"count\")" },
        "H82": { "content": "=ODOO.LIST(4,7,\"count\")" },
        "H83": { "content": "=ODOO.LIST(4,8,\"count\")" },
        "H84": { "content": "=ODOO.LIST(4,9,\"count\")" },
        "H85": { "content": "=ODOO.LIST(4,10,\"count\")" },
        "M49": { "content": "=ODOO.LIST.HEADER(2,\"opened\")" },
        "M50": { "content": "=ODOO.LIST(2,1,\"opened\")" },
        "M51": { "content": "=ODOO.LIST(2,2,\"opened\")" },
        "M52": { "content": "=ODOO.LIST(2,3,\"opened\")" },
        "M53": { "content": "=ODOO.LIST(2,4,\"opened\")" },
        "M54": { "content": "=ODOO.LIST(2,5,\"opened\")" },
        "M55": { "content": "=ODOO.LIST(2,6,\"opened\")" },
        "M56": { "content": "=ODOO.LIST(2,7,\"opened\")" },
        "M57": { "content": "=ODOO.LIST(2,8,\"opened\")" },
        "M58": { "content": "=ODOO.LIST(2,9,\"opened\")" },
        "M59": { "content": "=ODOO.LIST(2,10,\"opened\")" },
        "M63": { "content": "=ODOO.LIST(3,1,\"clicks_ratio\")" },
        "M64": { "content": "=ODOO.LIST(3,2,\"clicks_ratio\")" },
        "M65": { "content": "=ODOO.LIST(3,3,\"clicks_ratio\")" },
        "M66": { "content": "=ODOO.LIST(3,4,\"clicks_ratio\")" },
        "M67": { "content": "=ODOO.LIST(3,5,\"clicks_ratio\")" },
        "M68": { "content": "=ODOO.LIST(3,6,\"clicks_ratio\")" },
        "M69": { "content": "=ODOO.LIST(3,7,\"clicks_ratio\")" },
        "M70": { "content": "=ODOO.LIST(3,8,\"clicks_ratio\")" },
        "M71": { "content": "=ODOO.LIST(3,9,\"clicks_ratio\")" },
        "M72": { "content": "=ODOO.LIST(3,10,\"clicks_ratio\")" },
        "N49": { "content": "=ODOO.LIST.HEADER(2,\"pending\")" },
        "N50": { "content": "=ODOO.LIST(2,1,\"pending\")" },
        "N51": { "content": "=ODOO.LIST(2,2,\"pending\")" },
        "N52": { "content": "=ODOO.LIST(2,3,\"pending\")" },
        "N53": { "content": "=ODOO.LIST(2,4,\"pending\")" },
        "N54": { "content": "=ODOO.LIST(2,5,\"pending\")" },
        "N55": { "content": "=ODOO.LIST(2,6,\"pending\")" },
        "N56": { "content": "=ODOO.LIST(2,7,\"pending\")" },
        "N57": { "content": "=ODOO.LIST(2,8,\"pending\")" },
        "N58": { "content": "=ODOO.LIST(2,9,\"pending\")" },
        "N59": { "content": "=ODOO.LIST(2,10,\"pending\")" },
        "O49": { "content": "=ODOO.LIST.HEADER(2,\"process\")" },
        "O50": { "content": "=ODOO.LIST(2,1,\"process\")" },
        "O51": { "content": "=ODOO.LIST(2,2,\"process\")" },
        "O52": { "content": "=ODOO.LIST(2,3,\"process\")" },
        "O53": { "content": "=ODOO.LIST(2,4,\"process\")" },
        "O54": { "content": "=ODOO.LIST(2,5,\"process\")" },
        "O55": { "content": "=ODOO.LIST(2,6,\"process\")" },
        "O56": { "content": "=ODOO.LIST(2,7,\"process\")" },
        "O57": { "content": "=ODOO.LIST(2,8,\"process\")" },
        "O58": { "content": "=ODOO.LIST(2,9,\"process\")" },
        "O59": { "content": "=ODOO.LIST(2,10,\"process\")" },
        "P49": { "content": "=ODOO.LIST.HEADER(2,\"delivered\")" },
        "P50": { "content": "=ODOO.LIST(2,1,\"delivered\")" },
        "P51": { "content": "=ODOO.LIST(2,2,\"delivered\")" },
        "P52": { "content": "=ODOO.LIST(2,3,\"delivered\")" },
        "P53": { "content": "=ODOO.LIST(2,4,\"delivered\")" },
        "P54": { "content": "=ODOO.LIST(2,5,\"delivered\")" },
        "P55": { "content": "=ODOO.LIST(2,6,\"delivered\")" },
        "P56": { "content": "=ODOO.LIST(2,7,\"delivered\")" },
        "P57": { "content": "=ODOO.LIST(2,8,\"delivered\")" },
        "P58": { "content": "=ODOO.LIST(2,9,\"delivered\")" },
        "P59": { "content": "=ODOO.LIST(2,10,\"delivered\")" },
        "Q49": { "content": "=ODOO.LIST.HEADER(2,\"replied\")" },
        "Q50": { "content": "=ODOO.LIST(2,1,\"replied\")" },
        "Q51": { "content": "=ODOO.LIST(2,2,\"replied\")" },
        "Q52": { "content": "=ODOO.LIST(2,3,\"replied\")" },
        "Q53": { "content": "=ODOO.LIST(2,4,\"replied\")" },
        "Q54": { "content": "=ODOO.LIST(2,5,\"replied\")" },
        "Q55": { "content": "=ODOO.LIST(2,6,\"replied\")" },
        "Q56": { "content": "=ODOO.LIST(2,7,\"replied\")" },
        "Q57": { "content": "=ODOO.LIST(2,8,\"replied\")" },
        "Q58": { "content": "=ODOO.LIST(2,9,\"replied\")" },
        "Q59": { "content": "=ODOO.LIST(2,10,\"replied\")" },
        "R49": { "content": "=ODOO.LIST.HEADER(2,\"clicked\")" },
        "R50": { "content": "=ODOO.LIST(2,1,\"clicked\")" },
        "R51": { "content": "=ODOO.LIST(2,2,\"clicked\")" },
        "R52": { "content": "=ODOO.LIST(2,3,\"clicked\")" },
        "R53": { "content": "=ODOO.LIST(2,4,\"clicked\")" },
        "R54": { "content": "=ODOO.LIST(2,5,\"clicked\")" },
        "R55": { "content": "=ODOO.LIST(2,6,\"clicked\")" },
        "R56": { "content": "=ODOO.LIST(2,7,\"clicked\")" },
        "R57": { "content": "=ODOO.LIST(2,8,\"clicked\")" },
        "R58": { "content": "=ODOO.LIST(2,9,\"clicked\")" },
        "R59": { "content": "=ODOO.LIST(2,10,\"clicked\")" },
        "S49": { "content": "=ODOO.LIST.HEADER(2,\"bounced\")" },
        "S50": { "content": "=ODOO.LIST(2,1,\"bounced\")" },
        "S51": { "content": "=ODOO.LIST(2,2,\"bounced\")" },
        "S52": { "content": "=ODOO.LIST(2,3,\"bounced\")" },
        "S53": { "content": "=ODOO.LIST(2,4,\"bounced\")" },
        "S54": { "content": "=ODOO.LIST(2,5,\"bounced\")" },
        "S55": { "content": "=ODOO.LIST(2,6,\"bounced\")" },
        "S56": { "content": "=ODOO.LIST(2,7,\"bounced\")" },
        "S57": { "content": "=ODOO.LIST(2,8,\"bounced\")" },
        "S58": { "content": "=ODOO.LIST(2,9,\"bounced\")" },
        "S59": { "content": "=ODOO.LIST(2,10,\"bounced\")" },
        "T49": { "content": "=ODOO.LIST.HEADER(2,\"canceled\")" },
        "T50": { "content": "=ODOO.LIST(2,1,\"canceled\")" },
        "T51": { "content": "=ODOO.LIST(2,2,\"canceled\")" },
        "T52": { "content": "=ODOO.LIST(2,3,\"canceled\")" },
        "T53": { "content": "=ODOO.LIST(2,4,\"canceled\")" },
        "T54": { "content": "=ODOO.LIST(2,5,\"canceled\")" },
        "T55": { "content": "=ODOO.LIST(2,6,\"canceled\")" },
        "T56": { "content": "=ODOO.LIST(2,7,\"canceled\")" },
        "T57": { "content": "=ODOO.LIST(2,8,\"canceled\")" },
        "T58": { "content": "=ODOO.LIST(2,9,\"canceled\")" },
        "T59": { "content": "=ODOO.LIST(2,10,\"canceled\")" },
        "U49": { "content": "=ODOO.LIST.HEADER(2,\"failed\")" },
        "U50": { "content": "=ODOO.LIST(2,1,\"failed\")" },
        "U51": { "content": "=ODOO.LIST(2,2,\"failed\")" },
        "U52": { "content": "=ODOO.LIST(2,3,\"failed\")" },
        "U53": { "content": "=ODOO.LIST(2,4,\"failed\")" },
        "U54": { "content": "=ODOO.LIST(2,5,\"failed\")" },
        "U55": { "content": "=ODOO.LIST(2,6,\"failed\")" },
        "U56": { "content": "=ODOO.LIST(2,7,\"failed\")" },
        "U57": { "content": "=ODOO.LIST(2,8,\"failed\")" },
        "U58": { "content": "=ODOO.LIST(2,9,\"failed\")" },
        "U59": { "content": "=ODOO.LIST(2,10,\"failed\")" },
        "V49": { "content": "=ODOO.LIST.HEADER(2,\"total\")" },
        "V50": { "content": "=ODOO.LIST(2,1,\"total\")" },
        "V51": { "content": "=ODOO.LIST(2,2,\"total\")" },
        "V52": { "content": "=ODOO.LIST(2,3,\"total\")" },
        "V53": { "content": "=ODOO.LIST(2,4,\"total\")" },
        "V54": { "content": "=ODOO.LIST(2,5,\"total\")" },
        "V55": { "content": "=ODOO.LIST(2,6,\"total\")" },
        "V56": { "content": "=ODOO.LIST(2,7,\"total\")" },
        "V57": { "content": "=ODOO.LIST(2,8,\"total\")" },
        "V58": { "content": "=ODOO.LIST(2,9,\"total\")" },
        "V59": { "content": "=ODOO.LIST(2,10,\"total\")" },
        "W49": { "content": "=ODOO.LIST.HEADER(2,\"expected\")" },
        "W50": { "content": "=ODOO.LIST(2,1,\"expected\")" },
        "W51": { "content": "=ODOO.LIST(2,2,\"expected\")" },
        "W52": { "content": "=ODOO.LIST(2,3,\"expected\")" },
        "W53": { "content": "=ODOO.LIST(2,4,\"expected\")" },
        "W54": { "content": "=ODOO.LIST(2,5,\"expected\")" },
        "W55": { "content": "=ODOO.LIST(2,6,\"expected\")" },
        "W56": { "content": "=ODOO.LIST(2,7,\"expected\")" },
        "W57": { "content": "=ODOO.LIST(2,8,\"expected\")" },
        "W58": { "content": "=ODOO.LIST(2,9,\"expected\")" },
        "W59": { "content": "=ODOO.LIST(2,10,\"expected\")" }
      },
      "styles": {
        "A12": 1,
        "A30": 1,
        "A48": 1,
        "A61": 1,
        "A74": 1,
        "A87": 1,
        "A49:B49": 2,
        "A50:A59": 3,
        "A63:A72": 3,
        "A76:A85": 3,
        "A89:A93": 3,
        "C89:C93": 3,
        "C50:H59": 3,
        "A88": 4,
        "A62:B62": 4,
        "A75:B75": 4,
        "E62": 4,
        "E75": 4,
        "G62:H62": 4,
        "G75:H75": 4,
        "B50:B59": 5,
        "B63:B72": 5,
        "B76:B85": 5,
        "C49:H49": 6,
        "C88": 7,
        "E63:E72": 8,
        "E76:E85": 8,
        "G63:H72": 8,
        "G76:H85": 8,
        "M72": 8,
        "M50:W59": 8,
        "M63:M71": 9
      },
      "formats": {},
      "borders": {
        "A87:C87": 1,
        "A12:H12": 1,
        "A30:H30": 1,
        "A48:H48": 1,
        "A61:H61": 1,
        "A74:H74": 1,
        "A13:H13": 2,
        "A32:H32": 2,
        "A49:H49": 2,
        "A62:H62": 2,
        "A75:H75": 2,
        "A31:H31": 3,
        "A88": 4,
        "A89:A92": 5,
        "A93": 6,
        "B88": 7,
        "B89:B92": 8,
        "B93": 9,
        "C88": 10,
        "C89:C92": 11,
        "C93": 12
      },
      "conditionalFormats": [
        {
          "rule": {
            "type": "DataBarRule",
            "color": 15531509,
            "rangeValues": "C89:C93"
          },
          "id": "38154ecb-77b2-457b-b251-3d5dd68a43ff",
          "ranges": ["A89:A93"]
        }
      ],
      "figures": [
        {
          "id": "15bc3d3b-444b-4332-9253-c70d05c13922",
          "x": 0,
          "y": 10,
          "width": 202,
          "height": 104,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#E06666",
            "baselineColorUp": "#6AA84F",
            "baselineMode": "percentage",
            "title": {
              "text": "# of mails sent",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#EFF6FF",
            "baseline": "'Mailing Statistics'!C10",
            "baselineDescr": "vs last period",
            "keyValue": "'Mailing Statistics'!B10",
            "humanize": false
          }
        },
        {
          "id": "b15c80fb-33e5-4c7c-9637-3120004b1479",
          "x": 628,
          "y": 10,
          "width": 202,
          "height": 104,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#E06666",
            "baselineColorUp": "#6AA84F",
            "baselineMode": "percentage",
            "title": {
              "text": "Delivery Rate",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#ECFDF5",
            "baseline": "'Mailing Statistics'!C11",
            "baselineDescr": "vs last period",
            "keyValue": "'Mailing Statistics'!B11",
            "humanize": false
          }
        },
        {
          "id": "788392ce-cc56-40fd-8b1e-0dde698dde42",
          "x": 628,
          "y": 121,
          "width": 202,
          "height": 108,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#E06666",
            "baselineColorUp": "#6AA84F",
            "baselineMode": "percentage",
            "title": {
              "text": "Bounce Rate",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#FEF2F2",
            "baseline": "'Mailing Statistics'!C17",
            "baselineDescr": "vs last period",
            "keyValue": "'Mailing Statistics'!B17",
            "humanize": false
          }
        },
        {
          "id": "821a7c97-27ae-4186-b164-750c7b383677",
          "x": 209,
          "y": 122,
          "width": 202,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#E06666",
            "baselineColorUp": "#6AA84F",
            "baselineMode": "percentage",
            "title": {
              "text": "Click-Through Rate (CTR)",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#ECFDF5",
            "baseline": "'Mailing Statistics'!C14",
            "baselineDescr": "vs last period",
            "keyValue": "'Mailing Statistics'!B14",
            "humanize": false
          }
        },
        {
          "id": "79341445-3077-45f4-b2cd-8f5bd8c914f0",
          "x": 0,
          "y": 121,
          "width": 202,
          "height": 108,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#E06666",
            "baselineColorUp": "#6AA84F",
            "baselineMode": "percentage",
            "title": {
              "text": "Click-to-open Rate (CTOR)",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#ECFDF5",
            "baseline": "'Mailing Statistics'!C13",
            "baselineDescr": "vs last period",
            "keyValue": "'Mailing Statistics'!B13",
            "humanize": false
          }
        },
        {
          "id": "bab9bd74-affe-46a7-bb69-d1d222a8642b",
          "x": 838,
          "y": 10,
          "width": 202,
          "height": 104,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#E06666",
            "baselineColorUp": "#6AA84F",
            "baselineMode": "percentage",
            "title": { "text": "Open Rate", "bold": true, "color": "#434343" },
            "type": "scorecard",
            "background": "#ECFDF5",
            "baseline": "'Mailing Statistics'!C12",
            "baselineDescr": "vs last period",
            "keyValue": "'Mailing Statistics'!B12",
            "humanize": false
          }
        },
        {
          "id": "33928488-81ad-4159-a6eb-4bc756eeb172",
          "x": 418,
          "y": 122,
          "width": 202,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#E06666",
            "baselineColorUp": "#6AA84F",
            "baselineMode": "percentage",
            "title": {
              "text": "Engagement Rate",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#ECFDF5",
            "baseline": "'Mailing Statistics'!C16",
            "baselineDescr": "vs last period",
            "keyValue": "'Mailing Statistics'!B16",
            "humanize": false
          }
        },
        {
          "id": "ff80c592-1b87-4703-9715-3f408953e11e",
          "x": 418,
          "y": 10,
          "width": 202,
          "height": 104,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#E06666",
            "baselineColorUp": "#6AA84F",
            "baselineMode": "percentage",
            "title": {
              "text": "Unsubscribed",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#FEF2F2",
            "baseline": "'Mailing Statistics'!C21",
            "baselineDescr": "vs last period",
            "keyValue": "'Mailing Statistics'!B21",
            "humanize": false
          }
        },
        {
          "id": "3a24c73f-11f9-4477-8bd4-f1bc47a3a252",
          "x": 0,
          "y": 709,
          "width": 1043,
          "height": 390,
          "tag": "chart",
          "data": {
            "type": "bar",
            "dataSetsHaveTitle": true,
            "dataSets": [
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status (previous)'!B1:B",
                "yAxisId": "y",
                "trend": { "type": "polynomial", "order": 1, "display": false }
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status (previous)'!C1:C"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status (previous)'!D1:D"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status (previous)'!E1:E"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status (previous)'!F1:F"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status (previous)'!G1:G"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status (previous)'!H1:H"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status (previous)'!I1:I"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status (previous)'!J1:J"
              }
            ],
            "legendPosition": "top",
            "labelRange": "'Mailing sent Statistics by Created on (Month & Year) & status (previous)'!A1:A",
            "title": { "text": "" },
            "stacked": true,
            "aggregated": false
          }
        },
        {
          "id": "24a85627-ba30-45a6-8370-635a37722349",
          "x": 0,
          "y": 280,
          "width": 1042,
          "height": 388,
          "tag": "chart",
          "data": {
            "type": "bar",
            "dataSetsHaveTitle": true,
            "dataSets": [
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status'!B1:B",
                "yAxisId": "y",
                "trend": { "type": "polynomial", "order": 1, "display": false }
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status'!C1:C"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status'!D1:D"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status'!E1:E"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status'!F1:F"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status'!G1:G"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status'!H1:H"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status'!I1:I"
              },
              {
                "dataRange": "'Mailing sent Statistics by Created on (Month & Year) & status'!J1:J"
              }
            ],
            "legendPosition": "top",
            "labelRange": "'Mailing sent Statistics by Created on (Month & Year) & status'!A1:A",
            "title": { "text": "" },
            "stacked": true,
            "aggregated": false,
            "showValues": false
          }
        },
        {
          "id": "93997682-c4c5-4605-8847-5d18d1791a95",
          "x": 209,
          "y": 10,
          "width": 202,
          "height": 104,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#E06666",
            "baselineColorUp": "#6AA84F",
            "baselineMode": "percentage",
            "title": {
              "text": "# of mails opened",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#EFF6FF",
            "baseline": "'Mailing Statistics'!C7",
            "baselineDescr": "vs last period",
            "keyValue": "'Mailing Statistics'!B7",
            "humanize": false
          }
        }
      ],
      "tables": [],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": {
        "ROW": [],
        "COL": [{ "start": 12, "end": 22, "isFolded": false }]
      },
      "dataValidationRules": [],
      "comments": {}
    },
    {
      "id": "fa4045b5-0334-42a9-b5cf-60071ab8ac47",
      "name": "Mailing Statistics",
      "colNumber": 24,
      "rowNumber": 102,
      "rows": {
        "3": { "size": 23 },
        "4": { "size": 23 },
        "5": { "size": 23 },
        "8": { "size": 23 }
      },
      "cols": {
        "0": { "size": 267 },
        "1": { "size": 106 },
        "2": { "size": 109 },
        "5": { "size": 116 },
        "10": { "size": 138 }
      },
      "merges": [],
      "cells": {
        "A3": { "content": "=PIVOT.HEADER(1,\"trace_status\",\"error\")" },
        "A4": { "content": "=PIVOT.HEADER(1,\"trace_status\",\"bounce\")" },
        "A5": { "content": "=PIVOT.HEADER(1,\"trace_status\",\"pending\")" },
        "A6": { "content": "=PIVOT.HEADER(1,\"trace_status\",\"sent\")" },
        "A7": { "content": "=PIVOT.HEADER(1,\"trace_status\",\"open\")" },
        "A8": { "content": "=PIVOT.HEADER(1,\"trace_status\",\"reply\")" },
        "A9": { "content": "=_t(\"Clicked\")" },
        "A10": { "content": "=PIVOT.HEADER(1)" },
        "A11": { "content": "=_t(\"Delivery  Rate\")" },
        "A12": { "content": "=_t(\"Open Rate\")" },
        "A13": { "content": "=_t(\"Click-to-open Rate (CTOR)\")" },
        "A14": { "content": "=_t(\"Click-Through Rate (CTR)\")" },
        "A15": { "content": "=_t(\"Conversion Rate\")" },
        "A16": { "content": "=_t(\"Engagement Rate\")" },
        "A17": { "content": "=_t(\"Bounce Rate\")" },
        "A18": { "content": "=_t(\"Bounce details\")" },
        "A19": { "content": "=_t(\"New Subscribers\")" },
        "A20": { "content": "=_t(\"Subscribers Growth Rate\")" },
        "A21": { "content": "=_t(\"Unsubscribers\")" },
        "A22": { "content": "=_t(\"Unsubscribe Rate\")" },
        "A23": { "content": "=_t(\"Visits\")" },
        "A24": { "content": "=_t(\"Revenue Generated\")" },
        "A25": { "content": "=_t(\"Average Order Value (AOV)\")" },
        "A26": { "content": "=_t(\"Number of orders\")" },
        "A27": { "content": "=_t(\"Top products sold\")" },
        "B1": { "content": "=_t(\"N\")" },
        "B2": { "content": "=PIVOT.HEADER(1,\"measure\",\"__count:sum\")" },
        "B3": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"trace_status\",\"error\")"
        },
        "B4": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"trace_status\",\"bounce\")"
        },
        "B5": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"trace_status\",\"pending\")"
        },
        "B6": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"trace_status\",\"sent\")"
        },
        "B7": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"trace_status\",\"open\")"
        },
        "B8": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"trace_status\",\"reply\")"
        },
        "B9": { "content": "=PIVOT.VALUE(3,\"__count:sum\")" },
        "B10": { "content": "=PIVOT.VALUE(1,\"__count:sum\")" },
        "B11": { "content": "=iferror((B6+B7+B8)/B10,0)" },
        "B12": { "content": "=iferror((B7+B8)/B10,0)" },
        "B13": { "content": "=iferror((B9)/SUM(B7:B8),0)" },
        "B14": { "content": "=iferror((B9)/B10,0)" },
        "B16": { "content": "=iferror(B7/B10,0)" },
        "B17": { "content": "=iferror(B4/B10,0)" },
        "B21": { "content": "=PIVOT.VALUE(6,\"__count\")" },
        "C1": { "content": "=_t(\"N-1\")" },
        "C2": { "content": "=PIVOT.HEADER(2,\"measure\",\"__count:sum\")" },
        "C3": {
          "content": "=PIVOT.VALUE(2,\"__count:sum\",\"trace_status\",\"error\")+0"
        },
        "C4": {
          "content": "=PIVOT.VALUE(2,\"__count:sum\",\"trace_status\",\"bounce\")+0"
        },
        "C5": {
          "content": "=PIVOT.VALUE(2,\"__count:sum\",\"trace_status\",\"pending\")+0"
        },
        "C6": {
          "content": "=PIVOT.VALUE(2,\"__count:sum\",\"trace_status\",\"sent\")+0"
        },
        "C7": {
          "content": "=PIVOT.VALUE(2,\"__count:sum\",\"trace_status\",\"open\")+0"
        },
        "C8": {
          "content": "=PIVOT.VALUE(2,\"__count:sum\",\"trace_status\",\"reply\")+0"
        },
        "C9": { "content": "=PIVOT.VALUE(4,\"__count:sum\")" },
        "C10": { "content": "=PIVOT.VALUE(2,\"__count:sum\")" },
        "C11": { "content": "=iferror((C6+C7+C8)/C10,0)" },
        "C12": { "content": "=iferror((C7+C8)/C10,0)" },
        "C13": { "content": "=iferror((C9)/SUM(C7:C8),0)" },
        "C14": { "content": "=iferror((C9)/C10,0)" },
        "C16": { "content": "=iferror(C7/C10,0)" },
        "C17": { "content": "=iferror(C4/C10,0)" },
        "C21": { "content": "=PIVOT.VALUE(7,\"__count\")" },
        "D13": {
          "content": "=_t(\"Requires # of click date defined -> worth ? change ?\")"
        },
        "D14": {
          "content": "=_t(\"Requires # of click date defined -> worth ? change ?\")"
        },
        "D15": {
          "content": "=_t(\"Requires # of click date defined -> worth ? change ?\")"
        },
        "D16": {
          "content": "=_t(\"Requires # of click date defined -> worth ? change ?\")"
        }
      },
      "styles": {
        "A9": 10,
        "A13": 10,
        "A15": 11,
        "A18:A20": 11,
        "B21": 12,
        "B1:C14": 12,
        "B16:C17": 12
      },
      "formats": { "B11:C14": 1, "B16:C17": 1, "C9:C10": 2 },
      "borders": { "A13": 13, "A14": 14 },
      "conditionalFormats": [],
      "figures": [],
      "tables": [
        {
          "range": "A1:C27",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": true,
            "lastColumn": false,
            "numberOfHeaders": 2,
            "bandedRows": true,
            "bandedColumns": false,
            "styleId": "TableStyleMedium5"
          }
        }
      ],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": { "ROW": [], "COL": [] },
      "dataValidationRules": [],
      "comments": {}
    },
    {
      "id": "504f7cd1-9e6e-432e-a733-fbc37e70192c",
      "name": "Mailing sent Statistics by Created on (Month & Year) & status",
      "colNumber": 26,
      "rowNumber": 100,
      "rows": {},
      "cols": {
        "0": { "size": 412 },
        "1": { "size": 85 },
        "2": { "size": 69 }
      },
      "merges": [],
      "cells": { "A1": { "content": "=PIVOT(\"8\",,0,1,9)" } },
      "styles": {},
      "formats": {},
      "borders": {},
      "conditionalFormats": [],
      "figures": [],
      "tables": [
        {
          "range": "A1",
          "type": "dynamic",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": true,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "styleId": "TableStyleMedium5"
          }
        }
      ],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": { "ROW": [], "COL": [] },
      "dataValidationRules": [],
      "comments": {}
    },
    {
      "id": "6506fe8c-1103-47ec-8eb6-278110d5bddd",
      "name": "Mailing sent Statistics by Created on (Month & Year) & status (previous)",
      "colNumber": 26,
      "rowNumber": 100,
      "rows": {},
      "cols": {
        "0": { "size": 412 },
        "1": { "size": 85 },
        "2": { "size": 69 }
      },
      "merges": [],
      "cells": { "A1": { "content": "=PIVOT(\"9\",,0,1,9)" } },
      "styles": {},
      "formats": {},
      "borders": {},
      "conditionalFormats": [],
      "figures": [],
      "tables": [
        {
          "range": "A1",
          "type": "dynamic",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": true,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "styleId": "TableStyleMedium5"
          }
        }
      ],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": { "ROW": [], "COL": [] },
      "dataValidationRules": [],
      "comments": {}
    }
  ],
  "styles": {
    "1": { "fontSize": 16, "textColor": "#2D7E84", "bold": true },
    "2": { "bold": true, "fontSize": 11, "textColor": "#434343" },
    "3": { "textColor": "#434343", "verticalAlign": "middle" },
    "4": { "bold": true, "fontSize": 11 },
    "5": { "textColor": "#2D7E84", "verticalAlign": "middle" },
    "6": {
      "bold": true,
      "align": "center",
      "fontSize": 11,
      "textColor": "#434343"
    },
    "7": { "bold": true, "fontSize": 11, "align": "center" },
    "8": { "verticalAlign": "middle" },
    "9": { "strikethrough": true, "verticalAlign": "middle" },
    "10": { "bold": true },
    "11": { "strikethrough": true },
    "12": { "align": "center" }
  },
  "formats": { "1": "0.00%", "2": "#,##0.00" },
  "borders": {
    "1": { "bottom": { "style": "thin", "color": "#CCCCCC" } },
    "2": { "top": { "style": "thin", "color": "#CCCCCC" } },
    "3": {
      "top": { "style": "thin", "color": "#CCCCCC" },
      "bottom": { "style": "thin", "color": "#CCCCCC" }
    },
    "4": {
      "top": { "style": "thin", "color": "#CCCCCC" },
      "bottom": { "style": "thick", "color": "#FFFFFF" }
    },
    "5": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" }
    },
    "6": { "top": { "style": "thick", "color": "#FFFFFF" } },
    "7": {
      "top": { "style": "thin", "color": "#CCCCCC" },
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "right": { "style": "thick", "color": "#FFFFFF" }
    },
    "8": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "right": { "style": "thick", "color": "#FFFFFF" }
    },
    "9": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "right": { "style": "thick", "color": "#FFFFFF" }
    },
    "10": {
      "top": { "style": "thin", "color": "#CCCCCC" },
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "left": { "style": "thick", "color": "#FFFFFF" }
    },
    "11": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "left": { "style": "thick", "color": "#FFFFFF" }
    },
    "12": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "left": { "style": "thick", "color": "#FFFFFF" }
    },
    "13": {
      "bottom": { "color": "#B498AE", "style": "thin" },
      "left": { "color": "#B498AE", "style": "thin" }
    },
    "14": { "top": { "color": "#B498AE", "style": "thin" } }
  },
  "revisionId": "START_REVISION",
  "uniqueFigureIds": true,
  "settings": {
    "locale": {
      "name": "English (US)",
      "code": "en_US",
      "thousandsSeparator": ",",
      "decimalSeparator": ".",
      "dateFormat": "mm/dd/yyyy",
      "timeFormat": "hh:mm:ss",
      "formulaArgSeparator": ",",
      "weekStart": 7
    }
  },
  "pivots": {
    "b428d4bc-b120-4ef9-bb05-389e1b91c8cb": {
      "type": "ODOO",
      "domain": [],
      "context": {
        "active_id": 1,
        "active_ids": [1],
        "default_mass_mailing_id": 1
      },
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "__count",
        "order": "desc",
        "originIndexes": [0]
      },
      "measures": [
        { "id": "__count:sum", "fieldName": "__count", "aggregator": "sum" }
      ],
      "model": "mailing.trace",
      "columns": [
        { "fieldName": "open_datetime", "order": "asc", "granularity": "month" }
      ],
      "rows": [{ "fieldName": "trace_status" }],
      "name": "Mailing Statistics by Opened on (Month) and Status",
      "actionXmlId": "studio_customization.mailing_traces_dd609272-6199-4b1e-83b3-332f2545a116",
      "formulaId": "1",
      "fieldMatching": {
        "52262898-66ee-4e22-b038-c36cbd0e15d4": {
          "chain": "mass_mailing_id",
          "type": "many2one"
        },
        "538ee908-65e8-49ca-9bc5-e9081ac75a3f": {
          "chain": "mass_mailing_id.user_id",
          "type": "many2one"
        },
        "36252475-7a85-482c-b6da-ba74ef40b71f": {
          "chain": "medium_id",
          "type": "many2one"
        },
        "68397898-aab8-400e-9f49-875fa34f04a4": {
          "chain": "source_id",
          "type": "many2one"
        },
        "eb89bf39-7f4d-41c7-939a-d85c0841c9c2": {
          "chain": "create_date",
          "type": "datetime",
          "offset": 0
        }
      }
    },
    "975259f6-e2aa-46b6-a2d8-7c30e513671d": {
      "type": "ODOO",
      "domain": [],
      "context": {
        "active_id": 1,
        "active_ids": [1],
        "default_mass_mailing_id": 1
      },
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "__count",
        "order": "desc",
        "originIndexes": [0]
      },
      "measures": [
        { "id": "__count:sum", "fieldName": "__count", "aggregator": "sum" }
      ],
      "model": "mailing.trace",
      "columns": [
        { "fieldName": "open_datetime", "order": "asc", "granularity": "month" }
      ],
      "rows": [{ "fieldName": "trace_status" }],
      "name": "Mailing Statistics by Opened on (Month) and Status (previous)",
      "actionXmlId": "studio_customization.mailing_traces_dd609272-6199-4b1e-83b3-332f2545a116",
      "formulaId": "2",
      "fieldMatching": {
        "52262898-66ee-4e22-b038-c36cbd0e15d4": {
          "chain": "mass_mailing_id",
          "type": "many2one"
        },
        "538ee908-65e8-49ca-9bc5-e9081ac75a3f": {
          "chain": "mass_mailing_id.user_id",
          "type": "many2one"
        },
        "36252475-7a85-482c-b6da-ba74ef40b71f": {
          "chain": "medium_id",
          "type": "many2one"
        },
        "68397898-aab8-400e-9f49-875fa34f04a4": {
          "chain": "source_id",
          "type": "many2one"
        },
        "eb89bf39-7f4d-41c7-939a-d85c0841c9c2": {
          "chain": "create_date",
          "type": "datetime",
          "offset": -1
        }
      }
    },
    "cb9d8059-5a4b-4929-988e-3a0a19722006": {
      "type": "ODOO",
      "domain": [["links_click_datetime", "!=", false]],
      "context": {
        "active_id": 1,
        "active_ids": [1],
        "default_mass_mailing_id": 1
      },
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "__count",
        "order": "desc",
        "originIndexes": [0]
      },
      "measures": [
        { "id": "__count:sum", "fieldName": "__count", "aggregator": "sum" }
      ],
      "model": "mailing.trace",
      "columns": [
        {
          "fieldName": "links_click_datetime",
          "order": "asc",
          "granularity": "month"
        }
      ],
      "rows": [{ "fieldName": "trace_status" }],
      "name": "Mailing Click Statistics by Clicked on (Month) and Status",
      "actionXmlId": "studio_customization.mailing_traces_dd609272-6199-4b1e-83b3-332f2545a116",
      "formulaId": "3",
      "fieldMatching": {
        "52262898-66ee-4e22-b038-c36cbd0e15d4": {
          "chain": "mass_mailing_id",
          "type": "many2one"
        },
        "538ee908-65e8-49ca-9bc5-e9081ac75a3f": {
          "chain": "mass_mailing_id.user_id",
          "type": "many2one"
        },
        "36252475-7a85-482c-b6da-ba74ef40b71f": {
          "chain": "medium_id",
          "type": "many2one"
        },
        "68397898-aab8-400e-9f49-875fa34f04a4": {
          "chain": "source_id",
          "type": "many2one"
        },
        "eb89bf39-7f4d-41c7-939a-d85c0841c9c2": {
          "chain": "links_click_datetime",
          "type": "datetime",
          "offset": 0
        }
      }
    },
    "0ecf7bbf-2317-4a89-ad53-d0d606d3e1e8": {
      "type": "ODOO",
      "domain": [["links_click_datetime", "!=", false]],
      "context": {
        "active_id": 1,
        "active_ids": [1],
        "default_mass_mailing_id": 1
      },
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "__count",
        "order": "desc",
        "originIndexes": [0]
      },
      "measures": [
        { "id": "__count:sum", "fieldName": "__count", "aggregator": "sum" }
      ],
      "model": "mailing.trace",
      "columns": [
        {
          "fieldName": "links_click_datetime",
          "order": "asc",
          "granularity": "month"
        }
      ],
      "rows": [{ "fieldName": "trace_status" }],
      "name": "Mailing Click Statistics by Clicked on (Month) and Status (previous)",
      "actionXmlId": "studio_customization.mailing_traces_dd609272-6199-4b1e-83b3-332f2545a116",
      "formulaId": "4",
      "fieldMatching": {
        "52262898-66ee-4e22-b038-c36cbd0e15d4": {
          "chain": "mass_mailing_id",
          "type": "many2one"
        },
        "538ee908-65e8-49ca-9bc5-e9081ac75a3f": {
          "chain": "mass_mailing_id.user_id",
          "type": "many2one"
        },
        "36252475-7a85-482c-b6da-ba74ef40b71f": {
          "chain": "medium_id",
          "type": "many2one"
        },
        "68397898-aab8-400e-9f49-875fa34f04a4": {
          "chain": "source_id",
          "type": "many2one"
        },
        "eb89bf39-7f4d-41c7-939a-d85c0841c9c2": {
          "chain": "links_click_datetime",
          "type": "datetime",
          "offset": -1
        }
      }
    },
    "6ccf163b-26fc-43f8-b160-5ab9cb473b5b": {
      "type": "ODOO",
      "domain": [["opt_out", "=", true]],
      "context": {},
      "sortedColumn": null,
      "measures": [{ "id": "__count", "fieldName": "__count" }],
      "model": "mailing.subscription",
      "columns": [{ "fieldName": "list_id" }],
      "rows": [{ "fieldName": "opt_out_reason_id" }],
      "name": "Mailing List Subscriptions by Mailing List & Failure Type",
      "actionXmlId": "mass_mailing.mailing_subscription_action_report_optout",
      "formulaId": "6",
      "fieldMatching": {
        "eb89bf39-7f4d-41c7-939a-d85c0841c9c2": {
          "chain": "opt_out_datetime",
          "type": "datetime",
          "offset": 0
        },
        "52262898-66ee-4e22-b038-c36cbd0e15d4": {
          "chain": "list_id.mailing_ids",
          "type": "many2many"
        },
        "538ee908-65e8-49ca-9bc5-e9081ac75a3f": {
          "chain": "list_id.mailing_ids.user_id",
          "type": "many2one"
        },
        "36252475-7a85-482c-b6da-ba74ef40b71f": {
          "chain": "list_id.mailing_ids.medium_id",
          "type": "many2one"
        },
        "68397898-aab8-400e-9f49-875fa34f04a4": {
          "chain": "list_id.mailing_ids.source_id",
          "type": "many2one"
        }
      }
    },
    "62e76fdb-221d-4635-81e1-8eea32c3905f": {
      "type": "ODOO",
      "domain": [["opt_out", "=", true]],
      "context": {},
      "sortedColumn": null,
      "measures": [{ "id": "__count", "fieldName": "__count" }],
      "model": "mailing.subscription",
      "columns": [{ "fieldName": "list_id" }],
      "rows": [{ "fieldName": "opt_out_reason_id" }],
      "name": "Mailing List Subscriptions by Mailing List & Failure Type (previous)",
      "actionXmlId": "mass_mailing.mailing_subscription_action_report_optout",
      "formulaId": "7",
      "fieldMatching": {
        "eb89bf39-7f4d-41c7-939a-d85c0841c9c2": {
          "chain": "opt_out_datetime",
          "type": "datetime",
          "offset": -1
        },
        "52262898-66ee-4e22-b038-c36cbd0e15d4": {
          "chain": "list_id.mailing_ids",
          "type": "many2many"
        },
        "538ee908-65e8-49ca-9bc5-e9081ac75a3f": {
          "chain": "list_id.mailing_ids.user_id",
          "type": "many2one"
        },
        "36252475-7a85-482c-b6da-ba74ef40b71f": {
          "chain": "list_id.mailing_ids.medium_id",
          "type": "many2one"
        },
        "68397898-aab8-400e-9f49-875fa34f04a4": {
          "chain": "list_id.mailing_ids.source_id",
          "type": "many2one"
        }
      }
    },
    "36c27301-46ca-4b87-adb4-0c3aa15c9235": {
      "type": "ODOO",
      "domain": [],
      "context": {},
      "sortedColumn": null,
      "measures": [{ "id": "__count", "fieldName": "__count" }],
      "model": "mailing.trace",
      "columns": [{ "fieldName": "trace_status", "order": "desc" }],
      "rows": [{ "fieldName": "create_date", "granularity": "month" }],
      "name": "Mailing sent Statistics by Created on (Month & Year) & status",
      "actionXmlId": "studio_customization.mark_trace_94207eb2-4f40-4815-b60a-9c583e0539c8",
      "formulaId": "8",
      "fieldMatching": {
        "eb89bf39-7f4d-41c7-939a-d85c0841c9c2": {
          "chain": "create_date",
          "type": "datetime"
        },
        "52262898-66ee-4e22-b038-c36cbd0e15d4": {
          "chain": "mass_mailing_id",
          "type": "many2one"
        },
        "538ee908-65e8-49ca-9bc5-e9081ac75a3f": {
          "chain": "mass_mailing_id.user_id",
          "type": "many2one"
        },
        "36252475-7a85-482c-b6da-ba74ef40b71f": {
          "chain": "medium_id",
          "type": "many2one"
        },
        "68397898-aab8-400e-9f49-875fa34f04a4": {
          "chain": "source_id",
          "type": "many2one"
        }
      }
    },
    "f20d2578-f101-4c9e-9e39-b0013003a53b": {
      "type": "ODOO",
      "domain": [],
      "context": {},
      "sortedColumn": null,
      "measures": [{ "id": "__count", "fieldName": "__count" }],
      "model": "mailing.trace",
      "columns": [{ "fieldName": "trace_status", "order": "desc" }],
      "rows": [{ "fieldName": "create_date", "granularity": "month" }],
      "name": "Mailing sent Statistics by Created on (Month & Year) & status (previous)",
      "actionXmlId": "studio_customization.mark_trace_94207eb2-4f40-4815-b60a-9c583e0539c8",
      "formulaId": "9",
      "fieldMatching": {
        "eb89bf39-7f4d-41c7-939a-d85c0841c9c2": {
          "chain": "create_date",
          "type": "datetime",
          "offset": -1
        },
        "52262898-66ee-4e22-b038-c36cbd0e15d4": {
          "chain": "mass_mailing_id",
          "type": "many2one"
        },
        "538ee908-65e8-49ca-9bc5-e9081ac75a3f": {
          "chain": "mass_mailing_id.user_id",
          "type": "many2one"
        },
        "36252475-7a85-482c-b6da-ba74ef40b71f": {
          "chain": "medium_id",
          "type": "many2one"
        },
        "68397898-aab8-400e-9f49-875fa34f04a4": {
          "chain": "source_id",
          "type": "many2one"
        }
      }
    },
    "c7016614-68e7-4928-9b6b-7f99741209d6": {
      "type": "ODOO",
      "domain": [
        "&",
        ["trace_status", "in", ["bounce", "error", "cancel"]],
        ["failure_type", "!=", false]
      ],
      "context": {
        "active_id": 1,
        "active_ids": [1],
        "default_mass_mailing_id": 1
      },
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "__count",
        "order": "desc",
        "originIndexes": [0]
      },
      "measures": [
        { "id": "__count:sum", "fieldName": "__count", "aggregator": "sum" }
      ],
      "model": "mailing.trace",
      "columns": [
        { "fieldName": "sent_datetime", "order": "asc", "granularity": "month" }
      ],
      "rows": [{ "fieldName": "failure_type", "order": "desc" }],
      "name": "Mailing Statistics by Sent Date (Month) and Failed Reason",
      "actionXmlId": "studio_customization.mailing_traces_dd609272-6199-4b1e-83b3-332f2545a116",
      "formulaId": "10",
      "fieldMatching": {
        "52262898-66ee-4e22-b038-c36cbd0e15d4": {
          "chain": "mass_mailing_id",
          "type": "many2one"
        },
        "538ee908-65e8-49ca-9bc5-e9081ac75a3f": {
          "chain": "mass_mailing_id.user_id",
          "type": "many2one"
        },
        "36252475-7a85-482c-b6da-ba74ef40b71f": {
          "chain": "medium_id",
          "type": "many2one"
        },
        "68397898-aab8-400e-9f49-875fa34f04a4": {
          "chain": "source_id",
          "type": "many2one"
        },
        "eb89bf39-7f4d-41c7-939a-d85c0841c9c2": {
          "chain": "create_date",
          "type": "datetime",
          "offset": 0
        }
      }
    }
  },
  "pivotNextId": 11,
  "customTableStyles": {
    "c0afab57-16fa-4413-87a7-0145a7c7be11": {
      "displayName": "Custom Table Style",
      "templateName": "darkNoBorders",
      "primaryColor": "#C9DAF8"
    }
  },
  "odooVersion": 12,
  "globalFilters": [
    {
      "id": "eb89bf39-7f4d-41c7-939a-d85c0841c9c2",
      "type": "date",
      "label": "Period",
      "defaultValue": "last_year",
      "rangeType": "relative"
    },
    {
      "id": "52262898-66ee-4e22-b038-c36cbd0e15d4",
      "type": "relation",
      "label": "Mailing Campaign",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "modelName": "mailing.mailing",
      "includeChildren": false
    },
    {
      "id": "538ee908-65e8-49ca-9bc5-e9081ac75a3f",
      "type": "relation",
      "label": "Responsible",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "modelName": "res.users",
      "includeChildren": false
    },
    {
      "id": "36252475-7a85-482c-b6da-ba74ef40b71f",
      "type": "relation",
      "label": "Medium",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "modelName": "utm.medium",
      "includeChildren": false
    },
    {
      "id": "68397898-aab8-400e-9f49-875fa34f04a4",
      "type": "relation",
      "label": "Source",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "modelName": "utm.source",
      "includeChildren": false
    }
  ],
  "lists": {
    "2": {
      "columns": [
        "calendar_date",
        "subject",
        "user_id",
        "sent",
        "received_ratio",
        "opened_ratio",
        "clicks_ratio",
        "replied_ratio",
        "state"
      ],
      "domain": [
        "&",
        "&",
        ["mailing_type", "=", "mail"],
        ["use_in_marketing_automation", "=", false],
        ["state", "=", "done"]
      ],
      "model": "mailing.mailing",
      "context": { "default_user_id": 2, "default_mailing_type": "mail" },
      "orderBy": [{ "name": "calendar_date", "asc": false }],
      "id": "2",
      "name": "Mass mailing list per launch date (active)",
      "fieldMatching": {
        "eb89bf39-7f4d-41c7-939a-d85c0841c9c2": {
          "chain": "create_date",
          "type": "datetime",
          "offset": 0
        },
        "52262898-66ee-4e22-b038-c36cbd0e15d4": {
          "chain": "campaign_id.mailing_mail_ids",
          "type": "one2many"
        },
        "538ee908-65e8-49ca-9bc5-e9081ac75a3f": {
          "chain": "user_id",
          "type": "many2one"
        },
        "36252475-7a85-482c-b6da-ba74ef40b71f": {
          "chain": "medium_id",
          "type": "many2one"
        },
        "68397898-aab8-400e-9f49-875fa34f04a4": {
          "chain": "source_id",
          "type": "many2one"
        }
      }
    },
    "3": {
      "columns": [
        "calendar_date",
        "subject",
        "user_id",
        "sent",
        "received_ratio",
        "opened_ratio",
        "clicks_ratio",
        "replied_ratio",
        "state"
      ],
      "domain": [
        "&",
        "&",
        ["mailing_type", "=", "mail"],
        ["use_in_marketing_automation", "=", false],
        ["state", "!=", "done"]
      ],
      "model": "mailing.mailing",
      "context": { "default_user_id": 2, "default_mailing_type": "mail" },
      "orderBy": [{ "name": "calendar_date", "asc": false }],
      "id": "3",
      "name": "Mass mailing list (draft)",
      "fieldMatching": {
        "eb89bf39-7f4d-41c7-939a-d85c0841c9c2": {
          "chain": "create_date",
          "type": "datetime",
          "offset": 0
        },
        "52262898-66ee-4e22-b038-c36cbd0e15d4": {
          "chain": "campaign_id.mailing_mail_ids",
          "type": "one2many"
        },
        "538ee908-65e8-49ca-9bc5-e9081ac75a3f": {
          "chain": "user_id",
          "type": "many2one"
        },
        "36252475-7a85-482c-b6da-ba74ef40b71f": {
          "chain": "medium_id",
          "type": "many2one"
        },
        "68397898-aab8-400e-9f49-875fa34f04a4": {
          "chain": "source_id",
          "type": "many2one"
        }
      }
    },
    "4": {
      "columns": ["create_date", "title", "label", "url", "count"],
      "domain": [],
      "model": "link.tracker",
      "context": {
        "params": {
          "debug": 1,
          "action": 225,
          "actionStack": [{ "action": 225 }]
        }
      },
      "orderBy": [{ "name": "count", "asc": false }],
      "id": "4",
      "name": "Link Tracker by Number of Clicks",
      "fieldMatching": {
        "eb89bf39-7f4d-41c7-939a-d85c0841c9c2": {
          "chain": "create_date",
          "type": "datetime",
          "offset": 0
        },
        "52262898-66ee-4e22-b038-c36cbd0e15d4": {
          "chain": "mass_mailing_id",
          "type": "many2one"
        },
        "538ee908-65e8-49ca-9bc5-e9081ac75a3f": {
          "chain": "create_uid",
          "type": "many2one"
        },
        "36252475-7a85-482c-b6da-ba74ef40b71f": {
          "chain": "medium_id",
          "type": "many2one"
        },
        "68397898-aab8-400e-9f49-875fa34f04a4": {
          "chain": "source_id",
          "type": "many2one"
        }
      }
    }
  },
  "listNextId": 5,
  "chartOdooMenusReferences": {
    "ff80c592-1b87-4703-9715-3f408953e11e": "mass_mailing.mailing_menu_report_subscribe_reason"
  }
}
