Untitled
unknown
plain_text
a month ago
28 kB
1
Indexable
Never
{ "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" } }