Untitled
unknown
plain_text
2 years ago
21 kB
7
Indexable
{
"result": {
"networkId": "7c77eca3e93b4bd6b309ad4f37a5aba3",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"dbId": "2dd891b2fa8648ab8106a052ef77ef24",
"masterNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"masterColId": "91aa97744d904660a0ce9aa3036aaf4d",
"nodesInfo": [
{
"uniqueIdentifier": "3bd6076bfdda4181b306f11eb326b991",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "5546888c85c94072a29f6b9605ddb71f",
"nodeName": "CARRYOVER",
"nodeColName": "SALES_SALES_ZIP_SALESY_GEOID_ZIP_previous",
"modelType": 1,
"impactPercent": 0.9226989191364081,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "e2c393ee64e34cd184f4078a6e4136b2",
"parentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"childColumnId": [],
"childNodeId": [],
"parentNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"baseMetricInfo": {
"baseMetric": "SALES_SALES_ZIP_SALESY_GEOID_ZIP_previous",
"baseMetricId": "e2c393ee64e34cd184f4078a6e4136b2",
"alias": "SALES_ZIP_SALESY_previous",
"genType": 1,
"level": "GEOID_ZIP"
}
},
{
"uniqueIdentifier": "8a995b371bf34aa2b594400cc8f598a1",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "4270df5abf7e4e6f8fd347beb5ed962f",
"nodeName": "TimeAggregateSameLVouchers",
"nodeColName": "ACTIVITY_TIMEAGGREGATESAMELVOUCHERS_GEOID_ZIP",
"modelType": 1,
"impactPercent": 0.010975224402355698,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "839d818bfcda4409a6857958b4d02d43",
"parentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"childColumnId": [],
"childNodeId": [],
"parentNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"baseMetricInfo": {
"baseMetric": "ACTIVITY_ACTIVITY_ZIP_VOUCHERS_GEOID_ZIP",
"baseMetricId": "23ebad03648a414ab8717402171ee429",
"alias": "ACTIVITY_ZIP_VOUCHERS",
"genType": 1,
"level": "GEOID_ZIP"
}
},
{
"uniqueIdentifier": "f27ace13e31046259f69b116504752c1",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "4c272123bb044f22acf9d75682243dc5",
"nodeName": "TimeAggregateLowerLEmails",
"nodeColName": "ACTIVITY_TIMEAGGREGATELOWERLEMAILS_GEOID_ZIP",
"modelType": 1,
"impactPercent": 0.016501720889285577,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "90a33400d3134234a929e222c8541fb5",
"parentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"childColumnId": [],
"childNodeId": [],
"parentNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"baseMetricInfo": {
"baseMetric": "ACTIVITY_ACTIVITY_HCP_EMAILS_CUSTID_HCP",
"baseMetricId": "289b049e6bb64abd830fa3e4a0ef83ac",
"alias": "ACTIVITY_HCP_EMAILS",
"genType": 1,
"level": "CUSTID_HCP"
}
},
{
"uniqueIdentifier": "c1d5c0b50bce4fb68d52a0697f69aa0e",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "5c96c068963143f39919a298c9a0b5b2",
"nodeName": "CountRaw",
"nodeColName": "ACTIVITY_COUNTRAW_GEOID_ZIP",
"modelType": 1,
"impactPercent": 0.0016577560700541726,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "c64b4d73933e47b8ba73865e40b64c1d",
"parentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"childColumnId": [],
"childNodeId": [],
"parentNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"baseMetricInfo": {
"baseMetric": "ACTIVITY_ACTIVITY_HCP_SAMPLES_CUSTID_HCP",
"baseMetricId": "2801e92ba19348988a63b7641f01fa43",
"alias": "ACTIVITY_HCP_SAMPLES",
"genType": 1,
"level": "CUSTID_HCP"
}
},
{
"uniqueIdentifier": "1a7e2cb69da149fd95a315ef01fad000",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "24aa7a3c70e94c45bca8cffe9ad21d66",
"nodeName": "VolTrans",
"nodeColName": "ACTIVITY_VOLTRANS_GEOID_ZIP",
"modelType": 1,
"impactPercent": 0.011031600192055343,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "5be8bff79a054becbbf9fa46ab8151f7",
"parentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"childColumnId": [],
"childNodeId": [],
"parentNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"baseMetricInfo": {
"baseMetric": "ACTIVITY_ACTIVITY_HCP_SAMPLES_CUSTID_HCP",
"baseMetricId": "2801e92ba19348988a63b7641f01fa43",
"alias": "ACTIVITY_HCP_SAMPLES",
"genType": 1,
"level": "CUSTID_HCP"
}
},
{
"uniqueIdentifier": "22de851b073d40749f26a10313e267b4",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "feac8f0cb7354ff6aba39ad883d625ef",
"nodeName": "MiscRaw",
"nodeColName": "ACTIVITY_MISCRAW_GEOID_ZIP",
"modelType": 1,
"impactPercent": -0.022700524645573893,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "377a08f69183448bb90e3728e03aae10",
"parentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"childColumnId": [],
"childNodeId": [],
"parentNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"baseMetricInfo": {
"baseMetric": "ACTIVITY_VOLTRANS_GEOID_ZIP",
"baseMetricId": "42af40aeea41418e83edfb8fdee411c8",
"alias": "VolTrans",
"genType": 2,
"level": "GEOID_ZIP"
}
},
{
"uniqueIdentifier": "ae2caea59f3642728b66a9a4e7778a1d",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "7c149115ace7422fb480bf82c7b4aaca",
"nodeName": "CountDB",
"nodeColName": "ACTIVITY_COUNTDB_GEOID_ZIP",
"modelType": 1,
"impactPercent": -0.0034551697827192233,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "42092003b2e44f1d85af9b7ec442f5c3",
"parentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"childColumnId": [],
"childNodeId": [],
"parentNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"baseMetricInfo": {
"baseMetric": "SALES_SALES_HCP_MARKETNRX_CUSTID_HCP",
"baseMetricId": "cc5cbbae85b94498b81f547e18d48aca",
"alias": "SALES_HCP_MARKETNRX",
"genType": 1,
"level": "CUSTID_HCP"
}
},
{
"uniqueIdentifier": "e99bd914128444b0a1dfcfaadc43e2d6",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "9d433c42db464d7a81b995fd27babf5f",
"nodeName": "TImeAggregateDB",
"nodeColName": "ACTIVITY_TIMEAGGREGATEDB_GEOID_ZIP",
"modelType": 1,
"impactPercent": -0.0012750685419665897,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "5f2a1eb3010c47799a260862846ba8f4",
"parentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"childColumnId": [],
"childNodeId": [],
"parentNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"baseMetricInfo": {
"baseMetric": "ACTIVITY_ACTIVITY_ZIP_SOCIALMEDIA_GEOID_ZIP",
"baseMetricId": "ad775bed70074417b3dfe126397bf823",
"alias": "ACTIVITY_ZIP_SOCIALMEDIA",
"genType": 1,
"level": "GEOID_ZIP"
}
},
{
"uniqueIdentifier": "f449472d24214cddb7f95e34984667f1",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "36be28abe2d241118a0862a3287c2411",
"nodeName": "MiscDB",
"nodeColName": "ACTIVITY_MISCDB_GEOID_ZIP",
"modelType": 1,
"impactPercent": 0.0679989041225348,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "337da3ec333d46d2bcdd07f5ce5edd71",
"parentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"childColumnId": [],
"childNodeId": [],
"parentNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"baseMetricInfo": {
"baseMetric": "ACTIVITY_ACTIVITY_ZIP_DIGITALDISPLAY_GEOID_ZIP",
"baseMetricId": "e8422b7f9af54770ad22f67605c0f68a",
"alias": "ACTIVITY_ZIP_DIGITALDISPLAY",
"genType": 1,
"level": "GEOID_ZIP"
}
},
{
"uniqueIdentifier": "336f48209c8d490b9a8ff557d9a88891",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "d84b0990b55146258b2ab1bee5980a6e",
"nodeName": "VolTranDB",
"nodeColName": "ACTIVITY_VOLTRANDB_GEOID_ZIP",
"modelType": 1,
"impactPercent": 0.01270662913945808,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "f3c97c099e0443b1aefbb125ccf8a7d9",
"parentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"childColumnId": [],
"childNodeId": [],
"parentNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"baseMetricInfo": {
"baseMetric": "ACTIVITY_ACTIVITY_HCP_EMAILS_CUSTID_HCP",
"baseMetricId": "289b049e6bb64abd830fa3e4a0ef83ac",
"alias": "ACTIVITY_HCP_EMAILS",
"genType": 1,
"level": "CUSTID_HCP"
}
},
{
"uniqueIdentifier": "2d64fb84210b43f38eb159ab8c8c0170",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "d8292cfc97d4470bacc0f7b47933bc8a",
"nodeName": "ApportionDB",
"nodeColName": "ACTIVITY_APPORTIONDB_GEOID_ZIP",
"modelType": 1,
"impactPercent": 0.0,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "c2ef6c8088594d09a4033a68df0b5655",
"parentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"childColumnId": [],
"childNodeId": [],
"parentNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"baseMetricInfo": {
"baseMetric": "ACTIVITY_ACTIVITY_DMA_NEWSPAPERADS_CUSTID_DMA",
"baseMetricId": "23022f3f30954d2ca3c87c2b985e86ab",
"alias": "Activity_DMA_NEWSPAPERADS",
"genType": 1,
"level": "CUSTID_DMA"
}
},
{
"uniqueIdentifier": "28fcc3ef7c3c43dba4537a629bc73161",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "9b856d892b614863917512f19ce5f483",
"nodeName": "TimeAverageDB",
"nodeColName": "SALES_TIMEAVERAGEDB_GEOID_ZIP",
"modelType": 1,
"impactPercent": -0.013956618610814334,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "9a78b7865a8c42348abf0df7ec5a4723",
"parentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"childColumnId": [],
"childNodeId": [],
"parentNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"baseMetricInfo": {
"baseMetric": "ACTIVITY_ACTIVITY_HCP_SAMPLES_CUSTID_HCP",
"baseMetricId": "2801e92ba19348988a63b7641f01fa43",
"alias": "ACTIVITY_HCP_SAMPLES",
"genType": 1,
"level": "CUSTID_HCP"
}
},
{
"uniqueIdentifier": "8dc6c1946a6e4e4bb4575fc4c764064c",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "2168c122ab6845c49bc375da2c3a45e4",
"nodeName": "RawFeature",
"nodeColName": "ACTIVITY_RAWFEATURE_GEOID_ZIP",
"modelType": 1,
"impactPercent": -0.002183372371077788,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "6d25c6184397470290717506fcbf0e59",
"parentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"childColumnId": [],
"childNodeId": [],
"parentNodeId": "d5bedd0e6118459495e636a938f1a0d6",
"baseMetricInfo": {
"baseMetric": "ACTIVITY_ACTIVITY_HCP_EMAILS_CUSTID_HCP",
"baseMetricId": "289b049e6bb64abd830fa3e4a0ef83ac",
"alias": "ACTIVITY_HCP_EMAILS",
"genType": 1,
"level": "CUSTID_HCP"
}
},
{
"uniqueIdentifier": "ba4db3f528f6407c943a247e87208ee8",
"modelId": "38f020b30d994609be1397cab90a2c5c",
"modelName": "m1",
"nodeId": "d5bedd0e6118459495e636a938f1a0d6",
"nodeName": "SALES_ZIP_SALESY",
"nodeColName": "SALES_SALES_ZIP_SALESY_GEOID_ZIP",
"modelType": 1,
"impactPercent": 0,
"basePercent": null,
"coRate": null,
"summaryInfo": {
"rSquared": 0.9804032824138899,
"adjSquared": 0.9803640104347594,
"rmse": 14.403235140203423,
"aic_bic": 0.9983636131771831,
"aic": 49048.68450879089,
"bic": 49129.07868576941,
"total_impact_percent": 0,
"base_impact_percent": 0,
"carryover_impact": 0,
"intercept_impact": 0
},
"currentColumnId": "91aa97744d904660a0ce9aa3036aaf4d",
"parentColumnId": null,
"childColumnId": [
"e2c393ee64e34cd184f4078a6e4136b2",
"839d818bfcda4409a6857958b4d02d43",
"90a33400d3134234a929e222c8541fb5",
"c64b4d73933e47b8ba73865e40b64c1d",
"5be8bff79a054becbbf9fa46ab8151f7",
"377a08f69183448bb90e3728e03aae10",
"42092003b2e44f1d85af9b7ec442f5c3",
"5f2a1eb3010c47799a260862846ba8f4",
"337da3ec333d46d2bcdd07f5ce5edd71",
"f3c97c099e0443b1aefbb125ccf8a7d9",
"c2ef6c8088594d09a4033a68df0b5655",
"9a78b7865a8c42348abf0df7ec5a4723",
"6d25c6184397470290717506fcbf0e59"
],
"childNodeId": [
"5546888c85c94072a29f6b9605ddb71f",
"4270df5abf7e4e6f8fd347beb5ed962f",
"4c272123bb044f22acf9d75682243dc5",
"5c96c068963143f39919a298c9a0b5b2",
"24aa7a3c70e94c45bca8cffe9ad21d66",
"feac8f0cb7354ff6aba39ad883d625ef",
"7c149115ace7422fb480bf82c7b4aaca",
"9d433c42db464d7a81b995fd27babf5f",
"36be28abe2d241118a0862a3287c2411",
"d84b0990b55146258b2ab1bee5980a6e",
"d8292cfc97d4470bacc0f7b47933bc8a",
"9b856d892b614863917512f19ce5f483",
"2168c122ab6845c49bc375da2c3a45e4"
],
"parentNodeId": null,
"baseMetricInfo": {
"baseMetric": "SALES_SALES_ZIP_SALESY_GEOID_ZIP",
"baseMetricId": "b4cc0da2dead4d30971e741b346e7c59",
"alias": "SALES_ZIP_SALESY",
"genType": 1,
"level": "GEOID_ZIP"
}
}
],
"isMultiplicative": true,
"normalizedBaseMapping": [
{
"alias": "TestNormCol",
"biz_dtype": 2,
"db_id": "2dd891b2fa8648ab8106a052ef77ef24",
"gen_type": 2,
"id": "53a166dacb854a59a4d00891e6039244",
"level": "GEOID_ZIP",
"name": "ACTIVITY_TESTNORMCOL_GEOID_ZIP",
"typeOfCol": "Normalized Activity",
"baseMetric": "23ebad03648a414ab8717402171ee429"
}
]
},
"status": {
"code": 200,
"message": "Network Created Successfully"
}
}Editor is loading...