Untitled

mail@pastecode.io avatar
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"
  }
}