Untitled
unknown
plain_text
2 years ago
28 kB
5
Indexable
{
"result": {
"columnAliasMapping": [
{
"id": "7a69a80749b64feeb9f80c3d9e4f72a7",
"name": "ACTIVITY_SEG_GEOID_ZIP",
"alias": "SEG"
},
{
"id": "adfc51a02ef944f3a8614ef0d990305f",
"name": "ACTIVITY_TEST_GEOID_ZIP",
"alias": "Test"
},
{
"id": "6a286576f33b4b47904a2c3f58b600cd",
"name": "ACTIVITY_NORM_TEST_GEOID_ZIP",
"alias": "Norm_Test"
},
{
"id": "e4362286c7874da1af1a223bb3109d22",
"name": "INTERCEPT",
"alias": "INTERCEPT"
},
{
"id": "2a411bf0047b40708eb4b645d938ff46",
"name": "ID_GEOID_ZIP_GEOID_ZIP",
"alias": "GEOID_ZIP"
},
{
"id": "6a91c7f55f4d4d72bd4d8f005ff78e57",
"name": "DATERANGE_TIME_PERIOD_GEOID_ZIP",
"alias": "TIME_PERIOD"
},
{
"id": "a33fd7a996ff487b937f2ea02035efa7",
"name": "ACTIVITY_ACTIVITY_ZIP_VOUCHERS_GEOID_ZIP",
"alias": "ACTIVITY_ZIP_VOUCHERS"
},
{
"id": "e8422b7f9af54770ad22f67605c0f68a",
"name": "ACTIVITY_ACTIVITY_ZIP_DIGITALDISPLAY_GEOID_ZIP",
"alias": "ACTIVITY_ZIP_DIGITALDISPLAY"
},
{
"id": "a21c96aa8eb04dd9946ca51a37542ef8",
"name": "ACTIVITY_ACTIVITY_ZIP_PRINTMEDIA_GEOID_ZIP",
"alias": "ACTIVITY_ZIP_PRINTMEDIA"
},
{
"id": "bf7ebdc301fe456fa00b632120281766",
"name": "ACTIVITY_ACTIVITY_ZIP_SOCIALMEDIA_GEOID_ZIP",
"alias": "ACTIVITY_ZIP_SOCIALMEDIA"
},
{
"id": "a4de7822561c4a1bab2a9d61da542bf8",
"name": "SALES_SALES_ZIP_SALESX_GEOID_ZIP_previous",
"alias": "SALES_ZIP_SALESX_previous"
},
{
"id": "2e445ea3dd6e486a8c8a408eb47c2ab5",
"name": "SALES_SALES_ZIP_SALESX_GEOID_ZIP",
"alias": "SALES_ZIP_SALESX"
},
{
"id": "e2c393ee64e34cd184f4078a6e4136b2",
"name": "SALES_SALES_ZIP_SALESY_GEOID_ZIP_previous",
"alias": "SALES_ZIP_SALESY_previous"
},
{
"id": "91aa97744d904660a0ce9aa3036aaf4d",
"name": "SALES_SALES_ZIP_SALESY_GEOID_ZIP",
"alias": "SALES_ZIP_SALESY"
},
{
"id": "b1ab80ddd7d944fd87ef2b61a9d48f0d",
"name": "SALES_SALES_ZIP_SALES_Z_GEOID_ZIP_previous",
"alias": "SALES_ZIP_SALES_Z_previous"
},
{
"id": "748aa8414ca246a0b3315ca4380cd0e1",
"name": "SALES_SALES_ZIP_SALES_Z_GEOID_ZIP",
"alias": "SALES_ZIP_SALES_Z"
},
{
"id": "34d08269c62640fdae313b32980332a6",
"name": "SALES_SALES_ZIP_SALESW_GEOID_ZIP_previous",
"alias": "SALES_ZIP_SALESW_previous"
},
{
"id": "65070c66044a4c709a488097a078e572",
"name": "SALES_SALES_ZIP_SALESW_GEOID_ZIP",
"alias": "SALES_ZIP_SALESW"
},
{
"id": "0c574a19f56c47d2975ff2abf6da5b77",
"name": "SALES_SALES_SALES_HCP_NRX_CUSTID_HCP_GEOID_ZIP_previous",
"alias": "SALES_HCP_NRX_Mapped_GEOID_ZIP_previous"
},
{
"id": "de41507cd98041029bd197ef5beae5a2",
"name": "SALES_SALES_SALES_HCP_NRX_CUSTID_HCP_GEOID_ZIP",
"alias": "SALES_HCP_NRX_Mapped_GEOID_ZIP"
},
{
"id": "133b8bd1469643cb928bece5f13ba554",
"name": "SALES_SALES_SALES_HCP_TRX_CUSTID_HCP_GEOID_ZIP_previous",
"alias": "SALES_HCP_TRX_Mapped_GEOID_ZIP_previous"
},
{
"id": "592b4534eecd4e3997dc1c98363f5b8c",
"name": "SALES_SALES_SALES_HCP_TRX_CUSTID_HCP_GEOID_ZIP",
"alias": "SALES_HCP_TRX_Mapped_GEOID_ZIP"
},
{
"id": "febfbff47dfa40eeb065ac85af1591a8",
"name": "SALES_SALES_SALES_HCP_MARKETRX_CUSTID_HCP_GEOID_ZIP_previous",
"alias": "SALES_HCP_MARKETRX_Mapped_GEOID_ZIP_previous"
},
{
"id": "6b6c4493edd44cf0b2d6ff09784c27f8",
"name": "SALES_SALES_SALES_HCP_MARKETRX_CUSTID_HCP_GEOID_ZIP",
"alias": "SALES_HCP_MARKETRX_Mapped_GEOID_ZIP"
},
{
"id": "23d1ce1f546f4155be52f84efb1daac2",
"name": "SALES_SALES_SALES_HCP_MARKETNRX_CUSTID_HCP_GEOID_ZIP_previous",
"alias": "SALES_HCP_MARKETNRX_Mapped_GEOID_ZIP_previous"
},
{
"id": "687b68e365a94794af6bc5e1696e113c",
"name": "SALES_SALES_SALES_HCP_MARKETNRX_CUSTID_HCP_GEOID_ZIP",
"alias": "SALES_HCP_MARKETNRX_Mapped_GEOID_ZIP"
},
{
"id": "339b70453c9f4ea9abef256d23e6c7bd",
"name": "ACTIVITY_ACTIVITY_ACTIVITY_HCP_CALLS_CUSTID_HCP_GEOID_ZIP",
"alias": "ACTIVITY_HCP_CALLS_Mapped_GEOID_ZIP"
},
{
"id": "f687e2ab71b341fea33a752f74cd98a2",
"name": "ACTIVITY_ACTIVITY_ACTIVITY_HCP_SAMPLES_CUSTID_HCP_GEOID_ZIP",
"alias": "ACTIVITY_HCP_SAMPLES_Mapped_GEOID_ZIP"
},
{
"id": "69b4747dd028470dad69807738e468c0",
"name": "ACTIVITY_ACTIVITY_ACTIVITY_HCP_EMAILS_CUSTID_HCP_GEOID_ZIP",
"alias": "ACTIVITY_HCP_EMAILS_Mapped_GEOID_ZIP"
},
{
"id": "815ef9915c394db49bb5246da27a742e",
"name": "ACTIVITY_ACTIVITY_ACTIVITY_HCP_EVENTS_CUSTID_HCP_GEOID_ZIP",
"alias": "ACTIVITY_HCP_EVENTS_Mapped_GEOID_ZIP"
},
{
"id": "839d818bfcda4409a6857958b4d02d43",
"name": "ACTIVITY_TIMEAGGREGATESAMELVOUCHERS_GEOID_ZIP",
"alias": "TimeAggregateSameLVouchers"
},
{
"id": "90a33400d3134234a929e222c8541fb5",
"name": "ACTIVITY_TIMEAGGREGATELOWERLEMAILS_GEOID_ZIP",
"alias": "TimeAggregateLowerLEmails"
},
{
"id": "5d06cf3f39b9411ca93e06c1cface9d0",
"name": "SEGMENT_FLAGRAW_GEOID_ZIP",
"alias": "FlagRaw"
},
{
"id": "c64b4d73933e47b8ba73865e40b64c1d",
"name": "ACTIVITY_COUNTRAW_GEOID_ZIP",
"alias": "CountRaw"
},
{
"id": "5be8bff79a054becbbf9fa46ab8151f7",
"name": "ACTIVITY_VOLTRANS_GEOID_ZIP",
"alias": "VolTrans"
},
{
"id": "377a08f69183448bb90e3728e03aae10",
"name": "ACTIVITY_MISCRAW_GEOID_ZIP",
"alias": "MiscRaw"
},
{
"id": "3ca13599ff8249c0b10f1ad189756886",
"name": "SEGMENT_FLAGDB_GEOID_ZIP",
"alias": "FlagDB"
},
{
"id": "42092003b2e44f1d85af9b7ec442f5c3",
"name": "ACTIVITY_COUNTDB_GEOID_ZIP",
"alias": "CountDB"
},
{
"id": "5f2a1eb3010c47799a260862846ba8f4",
"name": "ACTIVITY_TIMEAGGREGATEDB_GEOID_ZIP",
"alias": "TImeAggregateDB"
},
{
"id": "337da3ec333d46d2bcdd07f5ce5edd71",
"name": "ACTIVITY_MISCDB_GEOID_ZIP",
"alias": "MiscDB"
},
{
"id": "f3c97c099e0443b1aefbb125ccf8a7d9",
"name": "ACTIVITY_VOLTRANDB_GEOID_ZIP",
"alias": "VolTranDB"
},
{
"id": "c2ef6c8088594d09a4033a68df0b5655",
"name": "ACTIVITY_APPORTIONDB_GEOID_ZIP",
"alias": "ApportionDB"
},
{
"id": "9c6b44be79324807bf09e3d301653174",
"name": "SALES_TIMEAVERAGEDB_GEOID_ZIP_previous",
"alias": "TimeAverageDB_previous"
},
{
"id": "9a78b7865a8c42348abf0df7ec5a4723",
"name": "SALES_TIMEAVERAGEDB_GEOID_ZIP",
"alias": "TimeAverageDB"
},
{
"id": "ed4eb4b109a44db0800ed8f9d5f87ee9",
"name": "ACTIVITY_DBFEATURE_GEOID_ZIP",
"alias": "DBFeature"
},
{
"id": "6d25c6184397470290717506fcbf0e59",
"name": "ACTIVITY_RAWFEATURE_GEOID_ZIP",
"alias": "RawFeature"
},
{
"id": "c5e096ae740344dcb8655caaa92e6dff",
"name": "ACTIVITY_FEAT_GEOID_ZIP",
"alias": "Feat"
},
{
"id": "c0e7fae110c446a6b091d40548c9f321",
"name": "SALES_TTT_GEOID_ZIP_previous",
"alias": "ttt_previous"
},
{
"id": "538f3975a7764ac3be96e761797f741e",
"name": "ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_2",
"alias": "RawFeatureDirect_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_2"
},
{
"id": "04beec532ce5448d9ce6dc68e4eb62e0",
"name": "ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_3",
"alias": "RawFeatureDirect_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_3"
},
{
"id": "2c1bce2c1f7f43fd88d43c050d30f686",
"name": "ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_4",
"alias": "RawFeatureDirect_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_4"
},
{
"id": "69b5e72bdeed432e81dab4d24125b30f",
"name": "ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_5",
"alias": "RawFeatureDirect_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_5"
},
{
"id": "3f6f29c5462942c197c52a37e2a4ad0f",
"name": "ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_1",
"alias": "RawFeatureDirect_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_1"
},
{
"id": "0271549b48884cf0b4def0f0d8338081",
"name": "ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP",
"alias": "RawFeatureDirect"
},
{
"id": "6199a4993315457fa791c72a95a83227",
"name": "ACTIVITY_APPORTIONEDADS_GEOID_ZIP",
"alias": "ApportionedAds"
},
{
"id": "1fa1ef58ed954d649f4c29e92bc04840",
"name": "ACTIVITY_DBFEATUREAPP_GEOID_ZIP",
"alias": "DBFeatureApp"
},
{
"id": "8ede25835b0f4127b42ef18d6e4f6651",
"name": "ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_1",
"alias": "RawMiscFeatureOHe_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_1"
},
{
"id": "66c32869c1754f9e9990d0d0dc13e640",
"name": "ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_2",
"alias": "RawMiscFeatureOHe_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_2"
},
{
"id": "f288c62b486f455aa776a5dcf1b23e69",
"name": "ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_3",
"alias": "RawMiscFeatureOHe_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_3"
},
{
"id": "7047c3f078de455ea9a2426876b605eb",
"name": "ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_4",
"alias": "RawMiscFeatureOHe_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_4"
},
{
"id": "3e750608e11e4db79855fceb4891c37a",
"name": "ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_5",
"alias": "RawMiscFeatureOHe_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_5"
},
{
"id": "a0b8b598762449dc9842f18abeb560d2",
"name": "ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP",
"alias": "RawMiscFeatureOHe"
},
{
"id": "329634010e25441a9f32e047da357c37",
"name": "ACTIVITY_RAWFEATURENOOHE_GEOID_ZIP",
"alias": "RawFeatureNoOHE"
},
{
"id": "3393c531a47147199bb7fdb99237b1df",
"name": "SEGMENT_BUCKETSEG_GEOID_ZIP",
"alias": "bucketSeg"
},
{
"id": "f3983202056e443a8902a6b38790db52",
"name": "SEGMENT_BSEG2_GEOID_ZIP",
"alias": "bSeg2"
},
{
"id": "13ce734dcfed4d5fbb587b9d755b1ab4",
"name": "SEGMENT_GRPSEG1_GEOID_ZIP",
"alias": "grpSeg1"
},
{
"id": "dcf7ec689af547a7bafac94a1ff87a88",
"name": "ACTIVITY_ACTIVITY_MISCDB_GEOID_ZIP_GEOID_ZIP",
"alias": "clonemisc"
},
{
"id": "b9051cce2d5144f6b72259933442e5e4",
"name": "ACTIVITY_TEST_MISCDB_GEOID_ZIP",
"alias": "test_MiscDB"
},
{
"id": "9634782a201a4105b0afc240a3ab469b",
"name": "ACTIVITY_LOWERLEVELRAWTA_NO_VT_TC_TF_GEOID_ZIP",
"alias": "LowerLevelRawTA_NO_VT_TC_TF"
},
{
"id": "699fe3a4b3484a5ca007c539b27d32b9",
"name": "ACTIVITY_LOWERLEVELVT_TF_NO_TC_TA_GEOID_ZIP",
"alias": "LowerLevelVT_TF_NO_TC_TA"
},
{
"id": "dd7024f306064c71b2ab3fa748daf732",
"name": "ACTIVITY_TEST_GEOID_ZIP",
"alias": "test"
},
{
"id": "f082ff7d739c4afda6f10663a368388e",
"name": "ACTIVITY_TEST_GEOID_ZIP",
"alias": "test"
},
{
"id": "4dc2bbb276b44b7da754f04078202bd5",
"name": "ACTIVITY_TEST01_GEOID_ZIP",
"alias": "test01"
},
{
"id": "07a26b680e3e4423b8e23c7240e9300f",
"name": "ACTIVITY_NORM_ACTIVITY_TEST_GEOID_ZIP",
"alias": "norm_activity_test"
},
{
"id": "566c7df131714b0abfeedc05e52af3dc",
"name": "ACTIVITY_TEST_ABC_GEOID_ZIP",
"alias": "test_abc"
},
{
"id": "e0c01fe71ad1427da921262e15324922",
"name": "ACTIVITY_TEST_ABFC_GEOID_ZIP",
"alias": "test_abfc"
},
{
"id": "4b65e90d06c149a6acd88f7ad151c26d",
"name": "ACTIVITY_TEST_ABFC_GEOID_ZIP",
"alias": "test_abfc"
},
{
"id": "d66d8a77ed9c47fba0442d11eeecd41f",
"name": "ACTIVITY_TESTING_MISC_COL_GEOID_ZIP",
"alias": "testing_misc_col"
},
{
"id": "caaa82c9e27548d49a8c21a3386e50c7",
"name": "SALES_TEST_GEOID_ZIP",
"alias": "test"
},
{
"id": "37a6cbd3c4d24241b7f01e290fdbb3aa",
"name": "SALES_TEST_GEOID_ZIP_previous",
"alias": "test_previous"
},
{
"id": "0c9ef5aa959a4e668a969c484efbc5c0",
"name": "ACTIVITY_TESTING_MISC_COL_GEOID_ZIP",
"alias": "testing_misc_col"
},
{
"id": "3f7b2133d0b04788ad0a3052086e4f9f",
"name": "ACTIVITY_TESRIN_GEOID_ZIP",
"alias": "tesrin"
},
{
"id": "19b80551376344bf888cc8f165173e39",
"name": "ACTIVITY_TESTING_MISC_COL_GEOID_ZIP",
"alias": "testing_misc_col"
},
{
"id": "6242b8e80fe94bed8f4a54a91be50c83",
"name": "ACTIVITY_FEATURETEST_GEOID_ZIP",
"alias": "featureTest"
},
{
"id": "f7ad44aa83af4e3e9912b7623bdda49f",
"name": "ACTIVITY_ACTIVITY_TEST_GEOID_ZIP",
"alias": "activity_test"
},
{
"id": "18e5b600a9454b9997d2faa551a35fee",
"name": "ACTIVITY_TESTING02_GEOID_ZIP",
"alias": "testing02"
},
{
"id": "53a166dacb854a59a4d00891e6039244",
"name": "ACTIVITY_TESTNORMCOL_GEOID_ZIP",
"alias": "TestNormCol"
},
{
"id": "7126030180f24057ab3779fd36b7fb02",
"name": "ACTIVITY_OH_TEST_GEOID_ZIP",
"alias": "OH_test"
},
{
"id": "991b55550e03403fab1878ca06b4a31d",
"name": "ACTIVITY_YTYR_GEOID_ZIP",
"alias": "ytyr"
},
{
"id": "f3f321f2eacd40e3860daffb4b313802",
"name": "ACTIVITY_TEST_FEATURE01_GEOID_ZIP",
"alias": "test_feature01"
},
{
"id": "a7a3b37764584798bcf287080daafdcd",
"name": "ACTIVITY_FEATURE_TEST03_GEOID_ZIP",
"alias": "feature_test03"
},
{
"id": "cfb20bbbf4be4ab7b9b30be2de7bf6c0",
"name": "ACTIVITY_FEATURE_TEST03_GEOID_ZIP",
"alias": "feature_test03"
},
{
"id": "b9f6128906e445ac932db71f3802d4b8",
"name": "ACTIVITY_FEATURE_TEST02_GEOID_ZIP",
"alias": "feature_test02"
},
{
"id": "9c358f1f30c2474aaa9835e5856bd38f",
"name": "ACTIVITY_FEATURE_TEST02_GEOID_ZIP",
"alias": "feature_test02"
},
{
"id": "5640354722f7472eb92362380d59b615",
"name": "ACTIVITY_MICS_NORM_1_GEOID_ZIP",
"alias": "MICS_NORM_1"
},
{
"id": "82f4fcf0560f49558d8bdded6c4da410",
"name": "ACTIVITY_ACTIVITY_VOLTRANDB_GEOID_ZIP_GEOID_ZIP",
"alias": "CloneMiscDB"
},
{
"id": "d9cf1b0d30814637865bca965bd3b697",
"name": "ACTIVITY_ACTIVITY_APPORTIONEDADS_GEOID_ZIP_GEOID_ZIP",
"alias": "CloneApportionAds"
},
{
"id": "bc632ed7ae674bd9beef19c4ea50cb04",
"name": "SALES_NEW_TEST_NORM_SALES_GEOID_ZIP",
"alias": "new_test_norm_sales"
},
{
"id": "76427726b6ab4bbc8af6fe000ef788c3",
"name": "SALES_NEW_TEST_NORM_SALES_GEOID_ZIP_previous",
"alias": "new_test_norm_sales_previous"
},
{
"id": "91d13fe3db854f8fb3c8bcb26b7b081e",
"name": "SALES_TTT_GEOID_ZIP",
"alias": "ttt"
},
{
"id": "b6d83fb871444952bfb1ff9fd773dcd0",
"name": "ACTIVITY__GEOID_ZIP",
"alias": ""
},
{
"id": "793254a5624a4490bae156ad52e0a5e7",
"name": "SALES_TEST123TEST_GEOID_ZIP_previous",
"alias": "test123Test_previous"
},
{
"id": "bd977a7d163d4344890cb4136375e541",
"name": "SALES_TEST123TEST_GEOID_ZIP",
"alias": "test123Test"
},
{
"id": "8491287d28ca4d0f8ac5fc6eb6efdf4f",
"name": "SALES_NEW_VALID_TEST_GEOID_ZIP",
"alias": "new_valid_test"
},
{
"id": "404264f630714286900d76d6a0f98249",
"name": "SALES_NEW_VALID_TEST_GEOID_ZIP_previous",
"alias": "new_valid_test_previous"
},
{
"id": "aefed005dd76423ca1a8c7fc7535b111",
"name": "ACTIVITY_TEST_NEW33_GEOID_ZIP",
"alias": "test_new33"
},
{
"id": "8e660d4afb8c4115be88a72b2a21c42b",
"name": "SALES_TTTTTTT_GEOID_ZIP",
"alias": "ttttttt"
},
{
"id": "ed0c643bc346400e8f7f52857963afd4",
"name": "SALES_TTTTTTT_GEOID_ZIP_previous",
"alias": "ttttttt_previous"
},
{
"id": "6e5fdd2972464c7ca30f30b2fe5b8473",
"name": "ACTIVITY_LOWERLEVELVT_TF_NO_TC_TA_GEOID_ZIP",
"alias": "LowerLevelVT_TF_NO_TC_TA"
},
{
"id": "7caf61271b604091990f0f60b15989bc",
"name": "ACTIVITY_A_GEOID_ZIP",
"alias": "a"
},
{
"id": "38e20d2701b342bca282c18ddbcbbfc0",
"name": "ACTIVITY_TEST_GEOID_ZIP",
"alias": "test"
}
],
"statisticalRoiModelSummary": [
{
"model_id": "38f020b30d994609be1397cab90a2c5c",
"channel": "CARRYOVER",
"segment": "National",
"sub_segment": "CARRYOVER",
"coefficient": 0.9613437434910246,
"p_value": 0.0,
"ci_lower": 0.948309105232879,
"ci_upper": 0.9743783817491701,
"relative_response": 1.0
},
{
"model_id": "38f020b30d994609be1397cab90a2c5c",
"channel": "ACTIVITY_TIMEAGGREGATESAMELVOUCHERS_GEOID_ZIP",
"segment": "National",
"sub_segment": "ACTIVITY_TIMEAGGREGATESAMELVOUCHERS_GEOID_ZIP",
"coefficient": 0.0004778551330438252,
"p_value": 0.6752598958573022,
"ci_lower": -0.001758078319492708,
"ci_upper": 0.0027137885855803585,
"relative_response": 1.0
},
{
"model_id": "38f020b30d994609be1397cab90a2c5c",
"channel": "ACTIVITY_TIMEAGGREGATELOWERLEMAILS_GEOID_ZIP",
"segment": "National",
"sub_segment": "ACTIVITY_TIMEAGGREGATELOWERLEMAILS_GEOID_ZIP",
"coefficient": 0.00045942223670322833,
"p_value": 0.6038098281121936,
"ci_lower": -0.0012760450380329144,
"ci_upper": 0.002194889511439371,
"relative_response": 1.0
},
{
"model_id": "38f020b30d994609be1397cab90a2c5c",
"channel": "ACTIVITY_COUNTRAW_GEOID_ZIP",
"segment": "National",
"sub_segment": "ACTIVITY_COUNTRAW_GEOID_ZIP",
"coefficient": 0.0034028228989179676,
"p_value": 0.9441099685338845,
"ci_lower": -0.09174680488622779,
"ci_upper": 0.09855245068406372,
"relative_response": 1.0
},
{
"model_id": "38f020b30d994609be1397cab90a2c5c",
"channel": "ACTIVITY_VOLTRANS_GEOID_ZIP",
"segment": "National",
"sub_segment": "ACTIVITY_VOLTRANS_GEOID_ZIP",
"coefficient": 0.0055196659212739824,
"p_value": 0.6272786534138354,
"ci_lower": -0.01676379918452476,
"ci_upper": 0.027803131027072728,
"relative_response": 1.0
},
{
"model_id": "38f020b30d994609be1397cab90a2c5c",
"channel": "ACTIVITY_MISCRAW_GEOID_ZIP",
"segment": "National",
"sub_segment": "ACTIVITY_MISCRAW_GEOID_ZIP",
"coefficient": -0.008506899695164265,
"p_value": 0.34163403210741583,
"ci_lower": -0.02604242695077833,
"ci_upper": 0.009028627560449802,
"relative_response": 1.0
},
{
"model_id": "38f020b30d994609be1397cab90a2c5c",
"channel": "ACTIVITY_COUNTDB_GEOID_ZIP",
"segment": "National",
"sub_segment": "ACTIVITY_COUNTDB_GEOID_ZIP",
"coefficient": -0.074750320555931,
"p_value": 0.8782918925156837,
"ci_lower": -1.0316275087063433,
"ci_upper": 0.8821268675944813,
"relative_response": 1.0
},
{
"model_id": "38f020b30d994609be1397cab90a2c5c",
"channel": "ACTIVITY_TIMEAGGREGATEDB_GEOID_ZIP",
"segment": "National",
"sub_segment": "ACTIVITY_TIMEAGGREGATEDB_GEOID_ZIP",
"coefficient": -1.8532333167711225e-05,
"p_value": 0.9683756575870837,
"ci_lower": -0.0009348638494757598,
"ci_upper": 0.0008977991831403373,
"relative_response": 1.0
},
{
"model_id": "38f020b30d994609be1397cab90a2c5c",
"channel": "ACTIVITY_MISCDB_GEOID_ZIP",
"segment": "National",
"sub_segment": "ACTIVITY_DBFEATURE_GEOID_ZIP",
"coefficient": 0.7248448697887614,
"p_value": 0.010304464340263893,
"ci_lower": 0.1711361290815906,
"ci_upper": 1.278553610495932,
"relative_response": 1.0
},
{
"model_id": "38f020b30d994609be1397cab90a2c5c",
"channel": "ACTIVITY_VOLTRANDB_GEOID_ZIP",
"segment": "National",
"sub_segment": "ACTIVITY_VOLTRANDB_GEOID_ZIP",
"coefficient": 0.011115098932565584,
"p_value": 0.24130111394802048,
"ci_lower": -0.007478977615481271,
"ci_upper": 0.02970917548061244,
"relative_response": 1.0
},
{
"model_id": "38f020b30d994609be1397cab90a2c5c",
"channel": "ACTIVITY_APPORTIONDB_GEOID_ZIP",
"segment": "National",
"sub_segment": "ACTIVITY_APPORTIONDB_GEOID_ZIP",
"coefficient": -6.880858393348755e-17,
"p_value": 0.8719804583276991,
"ci_lower": -9.058508307995848e-16,
"ci_upper": 7.682336629326096e-16,
"relative_response": 1.0
},
{
"model_id": "38f020b30d994609be1397cab90a2c5c",
"channel": "SALES_TIMEAVERAGEDB_GEOID_ZIP",
"segment": "National",
"sub_segment": "SALES_TIMEAVERAGEDB_GEOID_ZIP",
"coefficient": -0.07327065048626033,
"p_value": 0.6516974208200614,
"ci_lower": -0.39145395864743004,
"ci_upper": 0.2449126576749094,
"relative_response": 1.0
},
{
"model_id": "38f020b30d994609be1397cab90a2c5c",
"channel": "ACTIVITY_RAWFEATURE_GEOID_ZIP",
"segment": "National",
"sub_segment": "ACTIVITY_RAWFEATURE_GEOID_ZIP",
"coefficient": -0.09715599944615882,
"p_value": 0.9063567638074618,
"ci_lower": -1.716167995677603,
"ci_upper": 1.5218559967852854,
"relative_response": 1.0
}
],
"exclusionSummary": [],
"featureSummary": [
{
"id": "ed4eb4b109a44db0800ed8f9d5f87ee9",
"db_id": "2dd891b2fa8648ab8106a052ef77ef24",
"name": "ACTIVITY_DBFEATURE_GEOID_ZIP",
"alias": "DBFeature",
"description": "",
"level": "GEOID_ZIP",
"biz_dtype": 2,
"gen_type": 2,
"status": 1,
"is_selected": true,
"created_by": "da38789",
"created_on": "2023-08-29T14:27:28",
"last_updated_by": null,
"last_updated_on": "2023-08-29T14:27:35",
"props": {
"original_name": "DBFeature",
"section_id": 4,
"sub_section_id": 29
},
"metricType": "Activity",
"columnType": "Transformed",
"adstock": "",
"horizon": "",
"lag": "",
"segment": "",
"metric": "ACTIVITY_MISCDB_GEOID_ZIP",
"aggregation": "db",
"operations": "|normalizationFeature|timeCreditingFeature|timeAggrFeature|volTranslationFeature|transformationFeature",
"sectionType": 4,
"subSectionType": 29
}
],
"annovaDetails": [
[
{
"degree_of_freedom": 1.0,
"sum_sq": 62108371.86870676,
"mean_sq": 62108371.86870676,
"f_value": 299385.0039755934,
"p_value": 0.0
},
{
"degree_of_freedom": 1.0,
"sum_sq": 23557.6513478663,
"mean_sq": 23557.6513478663,
"f_value": 113.5564712169,
"p_value": 2.799468616e-26
},
{
"degree_of_freedom": 1.0,
"sum_sq": 7868.2247633689,
"mean_sq": 7868.2247633689,
"f_value": 37.9277129827,
"p_value": 8e-10
},
{
"degree_of_freedom": 1.0,
"sum_sq": 55.1295336115,
"mean_sq": 55.1295336115,
"f_value": 0.2657444583,
"p_value": 0.6062198489
},
{
"degree_of_freedom": 1.0,
"sum_sq": 0.1418532704,
"mean_sq": 0.1418532704,
"f_value": 0.0006837845,
"p_value": 0.9791391474
},
{
"degree_of_freedom": 1.0,
"sum_sq": 40.0236447283,
"mean_sq": 40.0236447283,
"f_value": 0.1929285646,
"p_value": 0.6605061434
},
{
"degree_of_freedom": 1.0,
"sum_sq": 503.5176069052,
"mean_sq": 503.5176069052,
"f_value": 2.4271385034,
"p_value": 0.1193032512
},
{
"degree_of_freedom": 1.0,
"sum_sq": 221.9143046121,
"mean_sq": 221.9143046121,
"f_value": 1.0697078827,
"p_value": 0.3010532049
},
{
"degree_of_freedom": 1.0,
"sum_sq": 6534.7053989194,
"mean_sq": 6534.7053989194,
"f_value": 31.4996632977,
"p_value": 2.08e-08
},
{
"degree_of_freedom": 1.0,
"sum_sq": 249.9521140605,
"mean_sq": 249.9521140605,
"f_value": 1.2048603499,
"p_value": 0.2723965469
},
{
"degree_of_freedom": 1.0,
"sum_sq": 7.9198412731,
"mean_sq": 7.9198412731,
"f_value": 0.0381765234,
"p_value": 0.8450957336
},
{
"degree_of_freedom": 1.0,
"sum_sq": 44.4404583102,
"mean_sq": 44.4404583102,
"f_value": 0.214219217,
"p_value": 0.6434971529
},
{
"degree_of_freedom": 1.0,
"sum_sq": 2.8443448632,
"mean_sq": 2.8443448632,
"f_value": 0.0137107796,
"p_value": 0.9067902534
},
{
"degree_of_freedom": 5988.0,
"sum_sq": 1242229.6568338964,
"mean_sq": 207.453182504,
"f_value": null,
"p_value": null
}
]
],
"favorite": true
},
"status": {
"code": 200,
"message": "Model Evaluated Successfully"
}
}Editor is loading...