Untitled
unknown
plain_text
a year ago
55 kB
1
Indexable
{
"result": {
"result": {
"formLayout": [
{
"label": "Feature Details",
"question_details": [
{
"name": "colName",
"id": 163,
"type": 1,
"answer": "",
"props": {
"label": "Feature Name",
"maxLength": 63,
"initialValue": "",
"isVisible": true,
"span": 1,
"positionX": 1,
"positionY": 1
}
},
{
"name": "metricAggregation",
"id": 164,
"type": 2,
"answer": "",
"props": {
"label": "Source Metric Aggregator",
"initialValue": "",
"isVisible": true,
"span": 1,
"positionX": 1,
"positionY": 2
}
},
{
"name": "sourceLevel",
"id": 165,
"type": 2,
"answer": "",
"props": {
"label": "Source Metric Level",
"initialValue": "",
"isVisible": true,
"span": 1,
"positionX": 1,
"positionY": 3
}
},
{
"name": "metric",
"id": 166,
"type": 2,
"answer": "",
"props": {
"label": "Source Metric",
"initialValue": "",
"isVisible": true,
"span": 1,
"positionX": 1,
"positionY": 4
}
},
{
"name": "segmentDimension",
"id": 167,
"type": 2,
"answer": "",
"props": {
"label": "Segment Dimension",
"initialValue": "",
"isVisible": true,
"span": 1,
"positionX": 2,
"positionY": 1
}
},
{
"name": "description",
"id": 168,
"type": 3,
"answer": "",
"props": {
"label": "Description",
"maxLength": 255,
"initialValue": "",
"isVisible": true,
"span": 2,
"positionX": 3,
"positionY": 1
}
},
{
"name": "volTranslationFeature",
"id": 169,
"type": 24,
"answer": "",
"props": {
"label": "Volume Translation",
"initialValue": "",
"isVisible": true,
"span": 0,
"positionX": 0,
"positionY": 0,
"payloadInfo": "{\"order\":0}",
"renderInfo": "To be provided from Moyeen"
}
},
{
"name": "timeAggrFeature",
"id": 170,
"type": 24,
"answer": "",
"props": {
"label": "Time Aggregation",
"initialValue": "",
"isVisible": true,
"span": 0,
"positionX": 0,
"positionY": 0,
"payloadInfo": "{\"order\":0}",
"renderInfo": "To be provided from Moyeen"
}
},
{
"name": "transformationFeature",
"id": 172,
"type": 24,
"answer": "",
"props": {
"label": "Transformation",
"initialValue": "",
"isVisible": true,
"span": 0,
"positionX": 0,
"positionY": 0,
"payloadInfo": "{\"functionalForm\":0, \"parameterA\":\"\", \"parameterB\":\"\", \"parameterC\":\"\", \"parameterD\":\"\", \"expression\":\"\", \"order\":0}",
"renderInfo": [
{
"answer": "",
"id": 0,
"name": "functionalForm",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Functional Form",
"positionX": 1,
"positionY": 1,
"span": 1
},
"type": 2
},
{
"answer": "",
"id": 0,
"name": "parameterA",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Parameter a",
"positionX": 2,
"positionY": 1,
"span": 1
},
"type": 1
},
{
"answer": "",
"id": 0,
"name": "parameterB",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Parameter b",
"positionX": 3,
"positionY": 1,
"span": 1
},
"type": 1
},
{
"answer": "",
"id": 0,
"name": "parameterC",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Parameter c",
"positionX": 4,
"positionY": 1,
"span": 1
},
"type": 1
},
{
"answer": "",
"id": 0,
"name": "expression",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Expression",
"positionX": 5,
"positionY": 1,
"span": 1
},
"type": 11
}
]
}
},
{
"name": "normalizationFeature",
"id": 171,
"type": 24,
"answer": "",
"props": {
"label": "Normalization",
"initialValue": "",
"isVisible": true,
"span": 0,
"positionX": 0,
"positionY": 0,
"payloadInfo": "{\"normalizationType\":0, \"value\":\"\", \"order\":0}",
"renderInfo": [
{
"answer": "",
"id": 0,
"name": "normalizationType",
"props": {
"initialValue": "",
"isVisible": true,
"label": "NormalizationType",
"positionX": 1,
"positionY": 1,
"span": 1
},
"type": 2
},
{
"answer": "",
"id": 0,
"name": "value",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Input",
"positionX": 2,
"positionY": 1,
"span": 1
},
"type": 1
}
]
}
},
{
"name": "timeCreditingFeature",
"id": 173,
"type": 24,
"answer": "",
"props": {
"label": "Time Crediting",
"initialValue": "",
"isVisible": true,
"span": 0,
"positionX": 0,
"positionY": 0,
"payloadInfo": "{\"horizon\":\"\", \"order\":0, \"adstockValue\":\"\", \"lagValue\":\"\"}",
"renderInfo": [
{
"answer": "",
"id": 0,
"name": "horizon",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Horizon (=-1)",
"inpMin": -1,
"positionX": 1,
"positionY": 1,
"span": 1
},
"type": 1
},
{
"answer": "",
"id": 0,
"name": "adstockValue",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Adstock Value",
"positionX": 2,
"positionY": 1,
"span": 1
},
"type": 1
},
{
"answer": "",
"id": 0,
"name": "lagValue",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Lag Value",
"positionX": 3,
"positionY": 1,
"span": 1
},
"type": 1
}
]
}
}
]
}
],
"customParams": {
"transformationOn": "db",
"type": "Feature",
"dbId": "2dd891b2fa8648ab8106a052ef77ef24",
"dbName": "ZIPDB",
"dbLevel": "GEOID_ZIP",
"aggregation": "[{'name': 'Raw Level', 'value': 'raw'},{'name': 'DB Level', 'value': 'db'}]",
"normalization": "[{'name': 'Constant', 'value': 1},{'name': 'Sales', 'value': 2},{'name': 'Activity', 'value': 3},{'name': 'Miscellaneous', 'value': 4}]",
"functionalForm": "[{'name': 'Power', 'value': 1},{'name': 'Log', 'value': 2},{'name': 'Binary', 'value': 3},{'name': 'Neg ex', 'value': 4},{'name': 'Generic', 'value': 5},{'name': 'Neg ex + Cannibalization', 'value': 6}]",
"data": "{'column': ['aggregation', 'level', 'id', 'name', 'alias', 'biz_dtype', 'levelHierarchy', 'subSectionId', 'key'], 'data': [['db', 'GEOID_ZIP', 'adfc51a02ef944f3a8614ef0d990305f', 'ACTIVITY_TEST_GEOID_ZIP', 'Test', 2, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|adfc51a02ef944f3a8614ef0d990305f|2|ACTIVITY_TEST_GEOID_ZIP'], ['db', 'GEOID_ZIP', '6a286576f33b4b47904a2c3f58b600cd', 'ACTIVITY_NORM_TEST_GEOID_ZIP', 'Norm_Test', 2, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|6a286576f33b4b47904a2c3f58b600cd|2|ACTIVITY_NORM_TEST_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'e4362286c7874da1af1a223bb3109d22', 'INTERCEPT', 'INTERCEPT', 15, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|e4362286c7874da1af1a223bb3109d22|15|INTERCEPT'], ['db', 'GEOID_ZIP', '2a411bf0047b40708eb4b645d938ff46', 'ID_GEOID_ZIP_GEOID_ZIP', 'GEOID_ZIP', 5, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|2a411bf0047b40708eb4b645d938ff46|5|ID_GEOID_ZIP_GEOID_ZIP'], ['db', 'GEOID_ZIP', '6a91c7f55f4d4d72bd4d8f005ff78e57', 'DATERANGE_TIME_PERIOD_GEOID_ZIP', 'TIME_PERIOD', 4, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|6a91c7f55f4d4d72bd4d8f005ff78e57|4|DATERANGE_TIME_PERIOD_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'a33fd7a996ff487b937f2ea02035efa7', 'ACTIVITY_ACTIVITY_ZIP_VOUCHERS_GEOID_ZIP', 'ACTIVITY_ZIP_VOUCHERS', 2, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|a33fd7a996ff487b937f2ea02035efa7|2|ACTIVITY_ACTIVITY_ZIP_VOUCHERS_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'e8422b7f9af54770ad22f67605c0f68a', 'ACTIVITY_ACTIVITY_ZIP_DIGITALDISPLAY_GEOID_ZIP', 'ACTIVITY_ZIP_DIGITALDISPLAY', 2, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|e8422b7f9af54770ad22f67605c0f68a|2|ACTIVITY_ACTIVITY_ZIP_DIGITALDISPLAY_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'a21c96aa8eb04dd9946ca51a37542ef8', 'ACTIVITY_ACTIVITY_ZIP_PRINTMEDIA_GEOID_ZIP', 'ACTIVITY_ZIP_PRINTMEDIA', 2, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|a21c96aa8eb04dd9946ca51a37542ef8|2|ACTIVITY_ACTIVITY_ZIP_PRINTMEDIA_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'bf7ebdc301fe456fa00b632120281766', 'ACTIVITY_ACTIVITY_ZIP_SOCIALMEDIA_GEOID_ZIP', 'ACTIVITY_ZIP_SOCIALMEDIA', 2, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|bf7ebdc301fe456fa00b632120281766|2|ACTIVITY_ACTIVITY_ZIP_SOCIALMEDIA_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'a4de7822561c4a1bab2a9d61da542bf8', 'SALES_SALES_ZIP_SALESX_GEOID_ZIP_previous', 'SALES_ZIP_SALESX_previous', 14, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|a4de7822561c4a1bab2a9d61da542bf8|14|SALES_SALES_ZIP_SALESX_GEOID_ZIP_previous'], ['db', 'GEOID_ZIP', '2e445ea3dd6e486a8c8a408eb47c2ab5', 'SALES_SALES_ZIP_SALESX_GEOID_ZIP', 'SALES_ZIP_SALESX', 1, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|2e445ea3dd6e486a8c8a408eb47c2ab5|1|SALES_SALES_ZIP_SALESX_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'e2c393ee64e34cd184f4078a6e4136b2', 'SALES_SALES_ZIP_SALESY_GEOID_ZIP_previous', 'SALES_ZIP_SALESY_previous', 14, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|e2c393ee64e34cd184f4078a6e4136b2|14|SALES_SALES_ZIP_SALESY_GEOID_ZIP_previous'], ['db', 'GEOID_ZIP', '91aa97744d904660a0ce9aa3036aaf4d', 'SALES_SALES_ZIP_SALESY_GEOID_ZIP', 'SALES_ZIP_SALESY', 1, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|91aa97744d904660a0ce9aa3036aaf4d|1|SALES_SALES_ZIP_SALESY_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'b1ab80ddd7d944fd87ef2b61a9d48f0d', 'SALES_SALES_ZIP_SALES_Z_GEOID_ZIP_previous', 'SALES_ZIP_SALES_Z_previous', 14, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|b1ab80ddd7d944fd87ef2b61a9d48f0d|14|SALES_SALES_ZIP_SALES_Z_GEOID_ZIP_previous'], ['db', 'GEOID_ZIP', '748aa8414ca246a0b3315ca4380cd0e1', 'SALES_SALES_ZIP_SALES_Z_GEOID_ZIP', 'SALES_ZIP_SALES_Z', 1, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|748aa8414ca246a0b3315ca4380cd0e1|1|SALES_SALES_ZIP_SALES_Z_GEOID_ZIP'], ['db', 'GEOID_ZIP', '34d08269c62640fdae313b32980332a6', 'SALES_SALES_ZIP_SALESW_GEOID_ZIP_previous', 'SALES_ZIP_SALESW_previous', 14, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|34d08269c62640fdae313b32980332a6|14|SALES_SALES_ZIP_SALESW_GEOID_ZIP_previous'], ['db', 'GEOID_ZIP', '65070c66044a4c709a488097a078e572', 'SALES_SALES_ZIP_SALESW_GEOID_ZIP', 'SALES_ZIP_SALESW', 1, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|65070c66044a4c709a488097a078e572|1|SALES_SALES_ZIP_SALESW_GEOID_ZIP'], ['db', 'GEOID_ZIP', '0c574a19f56c47d2975ff2abf6da5b77', 'SALES_SALES_SALES_HCP_NRX_CUSTID_HCP_GEOID_ZIP_previous', 'SALES_HCP_NRX_Mapped_GEOID_ZIP_previous', 14, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|0c574a19f56c47d2975ff2abf6da5b77|14|SALES_SALES_SALES_HCP_NRX_CUSTID_HCP_GEOID_ZIP_previous'], ['db', 'GEOID_ZIP', 'de41507cd98041029bd197ef5beae5a2', 'SALES_SALES_SALES_HCP_NRX_CUSTID_HCP_GEOID_ZIP', 'SALES_HCP_NRX_Mapped_GEOID_ZIP', 1, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|de41507cd98041029bd197ef5beae5a2|1|SALES_SALES_SALES_HCP_NRX_CUSTID_HCP_GEOID_ZIP'], ['db', 'GEOID_ZIP', '133b8bd1469643cb928bece5f13ba554', 'SALES_SALES_SALES_HCP_TRX_CUSTID_HCP_GEOID_ZIP_previous', 'SALES_HCP_TRX_Mapped_GEOID_ZIP_previous', 14, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|133b8bd1469643cb928bece5f13ba554|14|SALES_SALES_SALES_HCP_TRX_CUSTID_HCP_GEOID_ZIP_previous'], ['db', 'GEOID_ZIP', '592b4534eecd4e3997dc1c98363f5b8c', 'SALES_SALES_SALES_HCP_TRX_CUSTID_HCP_GEOID_ZIP', 'SALES_HCP_TRX_Mapped_GEOID_ZIP', 1, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|592b4534eecd4e3997dc1c98363f5b8c|1|SALES_SALES_SALES_HCP_TRX_CUSTID_HCP_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'febfbff47dfa40eeb065ac85af1591a8', 'SALES_SALES_SALES_HCP_MARKETRX_CUSTID_HCP_GEOID_ZIP_previous', 'SALES_HCP_MARKETRX_Mapped_GEOID_ZIP_previous', 14, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|febfbff47dfa40eeb065ac85af1591a8|14|SALES_SALES_SALES_HCP_MARKETRX_CUSTID_HCP_GEOID_ZIP_previous'], ['db', 'GEOID_ZIP', '6b6c4493edd44cf0b2d6ff09784c27f8', 'SALES_SALES_SALES_HCP_MARKETRX_CUSTID_HCP_GEOID_ZIP', 'SALES_HCP_MARKETRX_Mapped_GEOID_ZIP', 1, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|6b6c4493edd44cf0b2d6ff09784c27f8|1|SALES_SALES_SALES_HCP_MARKETRX_CUSTID_HCP_GEOID_ZIP'], ['db', 'GEOID_ZIP', '23d1ce1f546f4155be52f84efb1daac2', 'SALES_SALES_SALES_HCP_MARKETNRX_CUSTID_HCP_GEOID_ZIP_previous', 'SALES_HCP_MARKETNRX_Mapped_GEOID_ZIP_previous', 14, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|23d1ce1f546f4155be52f84efb1daac2|14|SALES_SALES_SALES_HCP_MARKETNRX_CUSTID_HCP_GEOID_ZIP_previous'], ['db', 'GEOID_ZIP', '687b68e365a94794af6bc5e1696e113c', 'SALES_SALES_SALES_HCP_MARKETNRX_CUSTID_HCP_GEOID_ZIP', 'SALES_HCP_MARKETNRX_Mapped_GEOID_ZIP', 1, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|687b68e365a94794af6bc5e1696e113c|1|SALES_SALES_SALES_HCP_MARKETNRX_CUSTID_HCP_GEOID_ZIP'], ['db', 'GEOID_ZIP', '339b70453c9f4ea9abef256d23e6c7bd', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_CALLS_CUSTID_HCP_GEOID_ZIP', 'ACTIVITY_HCP_CALLS_Mapped_GEOID_ZIP', 2, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|339b70453c9f4ea9abef256d23e6c7bd|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_CALLS_CUSTID_HCP_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'f687e2ab71b341fea33a752f74cd98a2', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_SAMPLES_CUSTID_HCP_GEOID_ZIP', 'ACTIVITY_HCP_SAMPLES_Mapped_GEOID_ZIP', 2, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|f687e2ab71b341fea33a752f74cd98a2|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_SAMPLES_CUSTID_HCP_GEOID_ZIP'], ['db', 'GEOID_ZIP', '69b4747dd028470dad69807738e468c0', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_EMAILS_CUSTID_HCP_GEOID_ZIP', 'ACTIVITY_HCP_EMAILS_Mapped_GEOID_ZIP', 2, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|69b4747dd028470dad69807738e468c0|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_EMAILS_CUSTID_HCP_GEOID_ZIP'], ['db', 'GEOID_ZIP', '815ef9915c394db49bb5246da27a742e', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_EVENTS_CUSTID_HCP_GEOID_ZIP', 'ACTIVITY_HCP_EVENTS_Mapped_GEOID_ZIP', 2, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|815ef9915c394db49bb5246da27a742e|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_EVENTS_CUSTID_HCP_GEOID_ZIP'], ['db', 'GEOID_ZIP', '839d818bfcda4409a6857958b4d02d43', 'ACTIVITY_TIMEAGGREGATESAMELVOUCHERS_GEOID_ZIP', 'TimeAggregateSameLVouchers', 2, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|839d818bfcda4409a6857958b4d02d43|2|ACTIVITY_TIMEAGGREGATESAMELVOUCHERS_GEOID_ZIP'], ['db', 'GEOID_ZIP', '90a33400d3134234a929e222c8541fb5', 'ACTIVITY_TIMEAGGREGATELOWERLEMAILS_GEOID_ZIP', 'TimeAggregateLowerLEmails', 2, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|90a33400d3134234a929e222c8541fb5|2|ACTIVITY_TIMEAGGREGATELOWERLEMAILS_GEOID_ZIP'], ['db', 'GEOID_ZIP', '5d06cf3f39b9411ca93e06c1cface9d0', 'SEGMENT_FLAGRAW_GEOID_ZIP', 'FlagRaw', 3, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|5d06cf3f39b9411ca93e06c1cface9d0|3|SEGMENT_FLAGRAW_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'c64b4d73933e47b8ba73865e40b64c1d', 'ACTIVITY_COUNTRAW_GEOID_ZIP', 'CountRaw', 2, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|c64b4d73933e47b8ba73865e40b64c1d|2|ACTIVITY_COUNTRAW_GEOID_ZIP'], ['db', 'GEOID_ZIP', '5be8bff79a054becbbf9fa46ab8151f7', 'ACTIVITY_VOLTRANS_GEOID_ZIP', 'VolTrans', 2, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|5be8bff79a054becbbf9fa46ab8151f7|2|ACTIVITY_VOLTRANS_GEOID_ZIP'], ['db', 'GEOID_ZIP', '377a08f69183448bb90e3728e03aae10', 'ACTIVITY_MISCRAW_GEOID_ZIP', 'MiscRaw', 2, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|377a08f69183448bb90e3728e03aae10|2|ACTIVITY_MISCRAW_GEOID_ZIP'], ['db', 'GEOID_ZIP', '3ca13599ff8249c0b10f1ad189756886', 'SEGMENT_FLAGDB_GEOID_ZIP', 'FlagDB', 3, 'parent', 15, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|3ca13599ff8249c0b10f1ad189756886|3|SEGMENT_FLAGDB_GEOID_ZIP'], ['db', 'GEOID_ZIP', '42092003b2e44f1d85af9b7ec442f5c3', 'ACTIVITY_COUNTDB_GEOID_ZIP', 'CountDB', 2, 'parent', 16, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|42092003b2e44f1d85af9b7ec442f5c3|2|ACTIVITY_COUNTDB_GEOID_ZIP'], ['db', 'GEOID_ZIP', '5f2a1eb3010c47799a260862846ba8f4', 'ACTIVITY_TIMEAGGREGATEDB_GEOID_ZIP', 'TImeAggregateDB', 2, 'parent', 18, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|5f2a1eb3010c47799a260862846ba8f4|2|ACTIVITY_TIMEAGGREGATEDB_GEOID_ZIP'], ['db', 'GEOID_ZIP', '337da3ec333d46d2bcdd07f5ce5edd71', 'ACTIVITY_MISCDB_GEOID_ZIP', 'MiscDB', 2, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|337da3ec333d46d2bcdd07f5ce5edd71|2|ACTIVITY_MISCDB_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'f3c97c099e0443b1aefbb125ccf8a7d9', 'ACTIVITY_VOLTRANDB_GEOID_ZIP', 'VolTranDB', 2, 'parent', 20, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|f3c97c099e0443b1aefbb125ccf8a7d9|2|ACTIVITY_VOLTRANDB_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'c2ef6c8088594d09a4033a68df0b5655', 'ACTIVITY_APPORTIONDB_GEOID_ZIP', 'ApportionDB', 2, 'parent', 30, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|c2ef6c8088594d09a4033a68df0b5655|2|ACTIVITY_APPORTIONDB_GEOID_ZIP'], ['db', 'GEOID_ZIP', '9a78b7865a8c42348abf0df7ec5a4723', 'SALES_TIMEAVERAGEDB_GEOID_ZIP', 'TimeAverageDB', 2, 'parent', 17, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|9a78b7865a8c42348abf0df7ec5a4723|2|SALES_TIMEAVERAGEDB_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'ed4eb4b109a44db0800ed8f9d5f87ee9', 'ACTIVITY_DBFEATURE_GEOID_ZIP', 'DBFeature', 2, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|ed4eb4b109a44db0800ed8f9d5f87ee9|2|ACTIVITY_DBFEATURE_GEOID_ZIP'], ['db', 'GEOID_ZIP', '6d25c6184397470290717506fcbf0e59', 'ACTIVITY_RAWFEATURE_GEOID_ZIP', 'RawFeature', 2, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|6d25c6184397470290717506fcbf0e59|2|ACTIVITY_RAWFEATURE_GEOID_ZIP'], ['db', 'GEOID_ZIP', '538f3975a7764ac3be96e761797f741e', 'ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_2', 'RawFeatureDirect_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_2', 13, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|538f3975a7764ac3be96e761797f741e|13|ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_2'], ['db', 'GEOID_ZIP', '04beec532ce5448d9ce6dc68e4eb62e0', 'ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_3', 'RawFeatureDirect_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_3', 13, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|04beec532ce5448d9ce6dc68e4eb62e0|13|ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_3'], ['db', 'GEOID_ZIP', '2c1bce2c1f7f43fd88d43c050d30f686', 'ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_4', 'RawFeatureDirect_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_4', 13, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|2c1bce2c1f7f43fd88d43c050d30f686|13|ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_4'], ['db', 'GEOID_ZIP', '69b5e72bdeed432e81dab4d24125b30f', 'ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_5', 'RawFeatureDirect_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_5', 13, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|69b5e72bdeed432e81dab4d24125b30f|13|ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_5'], ['db', 'GEOID_ZIP', '3f6f29c5462942c197c52a37e2a4ad0f', 'ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_1', 'RawFeatureDirect_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_1', 13, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|3f6f29c5462942c197c52a37e2a4ad0f|13|ACTIVITY_RAWFEATUREDIRECT_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_1'], ['db', 'GEOID_ZIP', '6199a4993315457fa791c72a95a83227', 'ACTIVITY_APPORTIONEDADS_GEOID_ZIP', 'ApportionedAds', 2, 'parent', 30, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|6199a4993315457fa791c72a95a83227|2|ACTIVITY_APPORTIONEDADS_GEOID_ZIP'], ['db', 'GEOID_ZIP', '1fa1ef58ed954d649f4c29e92bc04840', 'ACTIVITY_DBFEATUREAPP_GEOID_ZIP', 'DBFeatureApp', 2, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|1fa1ef58ed954d649f4c29e92bc04840|2|ACTIVITY_DBFEATUREAPP_GEOID_ZIP'], ['db', 'GEOID_ZIP', '8ede25835b0f4127b42ef18d6e4f6651', 'ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_1', 'RawMiscFeatureOHe_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_1', 13, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|8ede25835b0f4127b42ef18d6e4f6651|13|ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_1'], ['db', 'GEOID_ZIP', '66c32869c1754f9e9990d0d0dc13e640', 'ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_2', 'RawMiscFeatureOHe_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_2', 13, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|66c32869c1754f9e9990d0d0dc13e640|13|ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_2'], ['db', 'GEOID_ZIP', 'f288c62b486f455aa776a5dcf1b23e69', 'ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_3', 'RawMiscFeatureOHe_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_3', 13, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|f288c62b486f455aa776a5dcf1b23e69|13|ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_3'], ['db', 'GEOID_ZIP', '7047c3f078de455ea9a2426876b605eb', 'ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_4', 'RawMiscFeatureOHe_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_4', 13, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|7047c3f078de455ea9a2426876b605eb|13|ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_4'], ['db', 'GEOID_ZIP', '3e750608e11e4db79855fceb4891c37a', 'ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_5', 'RawMiscFeatureOHe_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_5', 13, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|3e750608e11e4db79855fceb4891c37a|13|ACTIVITY_RAWMISCFEATUREOHE_GEOID_ZIP_SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP_5'], ['db', 'GEOID_ZIP', '329634010e25441a9f32e047da357c37', 'ACTIVITY_RAWFEATURENOOHE_GEOID_ZIP', 'RawFeatureNoOHE', 2, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|329634010e25441a9f32e047da357c37|2|ACTIVITY_RAWFEATURENOOHE_GEOID_ZIP'], ['db', 'GEOID_ZIP', '3393c531a47147199bb7fdb99237b1df', 'SEGMENT_BUCKETSEG_GEOID_ZIP', 'bucketSeg', 3, 'parent', 22, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|3393c531a47147199bb7fdb99237b1df|3|SEGMENT_BUCKETSEG_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'f3983202056e443a8902a6b38790db52', 'SEGMENT_BSEG2_GEOID_ZIP', 'bSeg2', 3, 'parent', 22, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|f3983202056e443a8902a6b38790db52|3|SEGMENT_BSEG2_GEOID_ZIP'], ['db', 'GEOID_ZIP', '13ce734dcfed4d5fbb587b9d755b1ab4', 'SEGMENT_GRPSEG1_GEOID_ZIP', 'grpSeg1', 3, 'parent', 23, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|13ce734dcfed4d5fbb587b9d755b1ab4|3|SEGMENT_GRPSEG1_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'dcf7ec689af547a7bafac94a1ff87a88', 'ACTIVITY_ACTIVITY_MISCDB_GEOID_ZIP_GEOID_ZIP', 'clonemisc', 2, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|dcf7ec689af547a7bafac94a1ff87a88|2|ACTIVITY_ACTIVITY_MISCDB_GEOID_ZIP_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'b9051cce2d5144f6b72259933442e5e4', 'ACTIVITY_TEST_MISCDB_GEOID_ZIP', 'test_MiscDB', 2, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|b9051cce2d5144f6b72259933442e5e4|2|ACTIVITY_TEST_MISCDB_GEOID_ZIP'], ['db', 'GEOID_ZIP', '9634782a201a4105b0afc240a3ab469b', 'ACTIVITY_LOWERLEVELRAWTA_NO_VT_TC_TF_GEOID_ZIP', 'LowerLevelRawTA_NO_VT_TC_TF', 2, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|9634782a201a4105b0afc240a3ab469b|2|ACTIVITY_LOWERLEVELRAWTA_NO_VT_TC_TF_GEOID_ZIP'], ['db', 'GEOID_ZIP', '699fe3a4b3484a5ca007c539b27d32b9', 'ACTIVITY_LOWERLEVELVT_TF_NO_TC_TA_GEOID_ZIP', 'LowerLevelVT_TF_NO_TC_TA', 2, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|699fe3a4b3484a5ca007c539b27d32b9|2|ACTIVITY_LOWERLEVELVT_TF_NO_TC_TA_GEOID_ZIP'], ['db', 'GEOID_ZIP', '4dc2bbb276b44b7da754f04078202bd5', 'ACTIVITY_TEST01_GEOID_ZIP', 'test01', 2, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|4dc2bbb276b44b7da754f04078202bd5|2|ACTIVITY_TEST01_GEOID_ZIP'], ['db', 'GEOID_ZIP', '07a26b680e3e4423b8e23c7240e9300f', 'ACTIVITY_NORM_ACTIVITY_TEST_GEOID_ZIP', 'norm_activity_test', 2, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|07a26b680e3e4423b8e23c7240e9300f|2|ACTIVITY_NORM_ACTIVITY_TEST_GEOID_ZIP'], ['db', 'GEOID_ZIP', '566c7df131714b0abfeedc05e52af3dc', 'ACTIVITY_TEST_ABC_GEOID_ZIP', 'test_abc', 2, 'parent', 29, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|566c7df131714b0abfeedc05e52af3dc|2|ACTIVITY_TEST_ABC_GEOID_ZIP'], ['db', 'GEOID_ZIP', '53a166dacb854a59a4d00891e6039244', 'ACTIVITY_TESTNORMCOL_GEOID_ZIP', 'TestNormCol', 2, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|53a166dacb854a59a4d00891e6039244|2|ACTIVITY_TESTNORMCOL_GEOID_ZIP'], ['db', 'GEOID_ZIP', '5640354722f7472eb92362380d59b615', 'ACTIVITY_MICS_NORM_1_GEOID_ZIP', 'MICS_NORM_1', 2, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|5640354722f7472eb92362380d59b615|2|ACTIVITY_MICS_NORM_1_GEOID_ZIP'], ['db', 'GEOID_ZIP', '82f4fcf0560f49558d8bdded6c4da410', 'ACTIVITY_ACTIVITY_VOLTRANDB_GEOID_ZIP_GEOID_ZIP', 'CloneMiscDB', 2, 'parent', 20, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|82f4fcf0560f49558d8bdded6c4da410|2|ACTIVITY_ACTIVITY_VOLTRANDB_GEOID_ZIP_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'd9cf1b0d30814637865bca965bd3b697', 'ACTIVITY_ACTIVITY_APPORTIONEDADS_GEOID_ZIP_GEOID_ZIP', 'CloneApportionAds', 2, 'parent', 30, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|d9cf1b0d30814637865bca965bd3b697|2|ACTIVITY_ACTIVITY_APPORTIONEDADS_GEOID_ZIP_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'bc632ed7ae674bd9beef19c4ea50cb04', 'SALES_NEW_TEST_NORM_SALES_GEOID_ZIP', 'new_test_norm_sales', 1, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|bc632ed7ae674bd9beef19c4ea50cb04|1|SALES_NEW_TEST_NORM_SALES_GEOID_ZIP'], ['db', 'GEOID_ZIP', '76427726b6ab4bbc8af6fe000ef788c3', 'SALES_NEW_TEST_NORM_SALES_GEOID_ZIP_previous', 'new_test_norm_sales_previous', 14, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|76427726b6ab4bbc8af6fe000ef788c3|14|SALES_NEW_TEST_NORM_SALES_GEOID_ZIP_previous'], ['db', 'GEOID_ZIP', '793254a5624a4490bae156ad52e0a5e7', 'SALES_TEST123TEST_GEOID_ZIP_previous', 'test123Test_previous', 14, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|793254a5624a4490bae156ad52e0a5e7|14|SALES_TEST123TEST_GEOID_ZIP_previous'], ['db', 'GEOID_ZIP', 'bd977a7d163d4344890cb4136375e541', 'SALES_TEST123TEST_GEOID_ZIP', 'test123Test', 1, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|bd977a7d163d4344890cb4136375e541|1|SALES_TEST123TEST_GEOID_ZIP'], ['db', 'GEOID_ZIP', '8491287d28ca4d0f8ac5fc6eb6efdf4f', 'SALES_NEW_VALID_TEST_GEOID_ZIP', 'new_valid_test', 1, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|8491287d28ca4d0f8ac5fc6eb6efdf4f|1|SALES_NEW_VALID_TEST_GEOID_ZIP'], ['db', 'GEOID_ZIP', '404264f630714286900d76d6a0f98249', 'SALES_NEW_VALID_TEST_GEOID_ZIP_previous', 'new_valid_test_previous', 14, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|404264f630714286900d76d6a0f98249|14|SALES_NEW_VALID_TEST_GEOID_ZIP_previous'], ['db', 'GEOID_ZIP', 'aefed005dd76423ca1a8c7fc7535b111', 'ACTIVITY_TEST_NEW33_GEOID_ZIP', 'test_new33', 2, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|aefed005dd76423ca1a8c7fc7535b111|2|ACTIVITY_TEST_NEW33_GEOID_ZIP'], ['db', 'GEOID_ZIP', '8e660d4afb8c4115be88a72b2a21c42b', 'SALES_TTTTTTT_GEOID_ZIP', 'ttttttt', 1, 'parent', 19, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|8e660d4afb8c4115be88a72b2a21c42b|1|SALES_TTTTTTT_GEOID_ZIP'], ['db', 'GEOID_ZIP', 'ed0c643bc346400e8f7f52857963afd4', 'SALES_TTTTTTT_GEOID_ZIP_previous', 'ttttttt_previous', 14, 'parent', 0, '1058c193ddea4eea8ca9b4016b9caaf7|84f19eefa39b4cc3a63a11a483307c18|GEOID_ZIP|ed0c643bc346400e8f7f52857963afd4|14|SALES_TTTTTTT_GEOID_ZIP_previous'], ['raw', 'CUSTID_DMA', '4c698fe3c562492ca2d8ddb27cb2cee7', 'ID_CUSTID_DMA_CUSTID_DMA', 'CUSTID_DMA', 5, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|4c698fe3c562492ca2d8ddb27cb2cee7|5|ID_CUSTID_DMA_CUSTID_DMA'], ['raw', 'CUSTID_DMA', 'ce964c340b5045e0aa3c27b82d3fc032', 'DATERANGE_TIME_PERIOD_CUSTID_DMA', 'TIME_PERIOD', 4, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|ce964c340b5045e0aa3c27b82d3fc032|4|DATERANGE_TIME_PERIOD_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '9dcd902af87e4946866cf918ed055cdd', 'ACTIVITY_ACTIVITY_DMA_COPAY_CUSTID_DMA', 'Activity_DMA_COPAY', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|9dcd902af87e4946866cf918ed055cdd|2|ACTIVITY_ACTIVITY_DMA_COPAY_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '552c05def4824e94b8b1d5d26044f511', 'ACTIVITY_ACTIVITY_DMA_TVADVERTISEMENTS_CUSTID_DMA', 'Activity_DMA_TVADVERTISEMENTS', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|552c05def4824e94b8b1d5d26044f511|2|ACTIVITY_ACTIVITY_DMA_TVADVERTISEMENTS_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '23022f3f30954d2ca3c87c2b985e86ab', 'ACTIVITY_ACTIVITY_DMA_NEWSPAPERADS_CUSTID_DMA', 'Activity_DMA_NEWSPAPERADS', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|23022f3f30954d2ca3c87c2b985e86ab|2|ACTIVITY_ACTIVITY_DMA_NEWSPAPERADS_CUSTID_DMA'], ['raw', 'CUSTID_DMA', 'f4c92e34276645ddb16c1475e1e78efe', 'ACTIVITY_ACTIVITY_DMA_CLICKS_CUSTID_DMA', 'Activity_DMA_CLICKS', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|f4c92e34276645ddb16c1475e1e78efe|2|ACTIVITY_ACTIVITY_DMA_CLICKS_CUSTID_DMA'], ['raw', 'CUSTID_DMA', 'ecc3ae6967b74c31952bb70fe302ffea', 'SALES_SALES_DMA_RX_CUSTID_DMA', 'Sales_DMA_RX', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|ecc3ae6967b74c31952bb70fe302ffea|1|SALES_SALES_DMA_RX_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '74ac0d4cf57847d3be83b81b3e8757ae', 'SALES_SALES_DMA_NBRX_CUSTID_DMA', 'Sales_DMA_NBRX', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|74ac0d4cf57847d3be83b81b3e8757ae|1|SALES_SALES_DMA_NBRX_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '854572d4825d48758d5e5ff2b8626ae5', 'SALES_SALES_DMA_MARKETRX_CUSTID_DMA', 'Sales_DMA_MARKETRX', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|854572d4825d48758d5e5ff2b8626ae5|1|SALES_SALES_DMA_MARKETRX_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '3b05290411cb4ac6909f474239730aa1', 'SALES_SALES_DMA_MARKETNBRX_CUSTID_DMA', 'Sales_DMA_MARKETNBRX', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|3b05290411cb4ac6909f474239730aa1|1|SALES_SALES_DMA_MARKETNBRX_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '08fd03ba58c84c25a1b36e57d6dfd405', 'SALES_SALES_SALES_HCP_NRX_CUSTID_HCP_CUSTID_DMA', 'SALES_HCP_NRX_Mapped_CUSTID_DMA', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|08fd03ba58c84c25a1b36e57d6dfd405|1|SALES_SALES_SALES_HCP_NRX_CUSTID_HCP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '6fbc575cb5a944d6becec116db89ea3a', 'SALES_SALES_SALES_HCP_TRX_CUSTID_HCP_CUSTID_DMA', 'SALES_HCP_TRX_Mapped_CUSTID_DMA', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|6fbc575cb5a944d6becec116db89ea3a|1|SALES_SALES_SALES_HCP_TRX_CUSTID_HCP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', 'cbc77aa67e184cbd8bcea28b1bb11ec4', 'SALES_SALES_SALES_HCP_MARKETRX_CUSTID_HCP_CUSTID_DMA', 'SALES_HCP_MARKETRX_Mapped_CUSTID_DMA', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|cbc77aa67e184cbd8bcea28b1bb11ec4|1|SALES_SALES_SALES_HCP_MARKETRX_CUSTID_HCP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '7d70ac92d5b54e8bba0fd53d2183ae88', 'SALES_SALES_SALES_HCP_MARKETNRX_CUSTID_HCP_CUSTID_DMA', 'SALES_HCP_MARKETNRX_Mapped_CUSTID_DMA', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|7d70ac92d5b54e8bba0fd53d2183ae88|1|SALES_SALES_SALES_HCP_MARKETNRX_CUSTID_HCP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '679c498845864ca6af81e984c87e7722', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_CALLS_CUSTID_HCP_CUSTID_DMA', 'ACTIVITY_HCP_CALLS_Mapped_CUSTID_DMA', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|679c498845864ca6af81e984c87e7722|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_CALLS_CUSTID_HCP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', 'a94ec01a49874326bb62ecb26c12f9de', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_SAMPLES_CUSTID_HCP_CUSTID_DMA', 'ACTIVITY_HCP_SAMPLES_Mapped_CUSTID_DMA', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|a94ec01a49874326bb62ecb26c12f9de|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_SAMPLES_CUSTID_HCP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', 'ffa53c2045314df08bf7ca03eaf9fca1', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_EMAILS_CUSTID_HCP_CUSTID_DMA', 'ACTIVITY_HCP_EMAILS_Mapped_CUSTID_DMA', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|ffa53c2045314df08bf7ca03eaf9fca1|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_EMAILS_CUSTID_HCP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '3959b65ca4164cb8ba6a66cbe4b5d523', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_EVENTS_CUSTID_HCP_CUSTID_DMA', 'ACTIVITY_HCP_EVENTS_Mapped_CUSTID_DMA', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|3959b65ca4164cb8ba6a66cbe4b5d523|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_EVENTS_CUSTID_HCP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '6f449c9aaf9d40ccb78845496e4dd5f4', 'SALES_SALES_SALES_ZIP_SALESX_GEOID_ZIP_CUSTID_DMA', 'SALES_ZIP_SALESX_Mapped_CUSTID_DMA', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|6f449c9aaf9d40ccb78845496e4dd5f4|1|SALES_SALES_SALES_ZIP_SALESX_GEOID_ZIP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '80dadc9d18eb4fa99778fa5bf0cce1fe', 'SALES_SALES_SALES_ZIP_SALESY_GEOID_ZIP_CUSTID_DMA', 'SALES_ZIP_SALESY_Mapped_CUSTID_DMA', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|80dadc9d18eb4fa99778fa5bf0cce1fe|1|SALES_SALES_SALES_ZIP_SALESY_GEOID_ZIP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', 'c2ddf3965ac244cb9bc33d3c8063197c', 'SALES_SALES_SALES_ZIP_SALES_Z_GEOID_ZIP_CUSTID_DMA', 'SALES_ZIP_SALES_Z_Mapped_CUSTID_DMA', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|c2ddf3965ac244cb9bc33d3c8063197c|1|SALES_SALES_SALES_ZIP_SALES_Z_GEOID_ZIP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '4311bf6c670145aea3c53b78eb29b586', 'SALES_SALES_SALES_ZIP_SALESW_GEOID_ZIP_CUSTID_DMA', 'SALES_ZIP_SALESW_Mapped_CUSTID_DMA', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|4311bf6c670145aea3c53b78eb29b586|1|SALES_SALES_SALES_ZIP_SALESW_GEOID_ZIP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', 'b1a8c8c0718e49f6acf30ed238523fa8', 'ACTIVITY_ACTIVITY_ACTIVITY_ZIP_VOUCHERS_GEOID_ZIP_CUSTID_DMA', 'ACTIVITY_ZIP_VOUCHERS_Mapped_CUSTID_DMA', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|b1a8c8c0718e49f6acf30ed238523fa8|2|ACTIVITY_ACTIVITY_ACTIVITY_ZIP_VOUCHERS_GEOID_ZIP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '92ee68372367425a850836acbd84ac6b', 'ACTIVITY_ACTIVITY_ACTIVITY_ZIP_DIGITALDISPLAY_GEOID_ZIP_CUSTID_DMA', 'ACTIVITY_ZIP_DIGITALDISPLAY_Mapped_CUSTID_DMA', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|92ee68372367425a850836acbd84ac6b|2|ACTIVITY_ACTIVITY_ACTIVITY_ZIP_DIGITALDISPLAY_GEOID_ZIP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '914f70e2492941d39a2a08b4dbdc119e', 'ACTIVITY_ACTIVITY_ACTIVITY_ZIP_PRINTMEDIA_GEOID_ZIP_CUSTID_DMA', 'ACTIVITY_ZIP_PRINTMEDIA_Mapped_CUSTID_DMA', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|914f70e2492941d39a2a08b4dbdc119e|2|ACTIVITY_ACTIVITY_ACTIVITY_ZIP_PRINTMEDIA_GEOID_ZIP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '003a58fd559342a0bb277a863b931a70', 'ACTIVITY_ACTIVITY_ACTIVITY_ZIP_SOCIALMEDIA_GEOID_ZIP_CUSTID_DMA', 'ACTIVITY_ZIP_SOCIALMEDIA_Mapped_CUSTID_DMA', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|003a58fd559342a0bb277a863b931a70|2|ACTIVITY_ACTIVITY_ACTIVITY_ZIP_SOCIALMEDIA_GEOID_ZIP_CUSTID_DMA'], ['raw', 'CUSTID_DMA', '6a448d057a6043c5beb2b75646a38f4c', 'ACTIVITY_MISCRAWDMA_CUSTID_DMA', 'MiscRawDMA', 2, 'lower', 5, '1058c193ddea4eea8ca9b4016b9caaf7|6c0ee38c05934feab5c49c77536a5b30|CUSTID_DMA|6a448d057a6043c5beb2b75646a38f4c|2|ACTIVITY_MISCRAWDMA_CUSTID_DMA'], ['raw', 'CUSTID_HCP', '4bec9c205379498b891d991879c7e331', 'SALES_SALES_HCP_TRX_CUSTID_HCP', 'SALES_HCP_TRX', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|4bec9c205379498b891d991879c7e331|1|SALES_SALES_HCP_TRX_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '6c537dfc49274ed8ace5f647d2ca4a40', 'SALES_SALES_HCP_MARKETRX_CUSTID_HCP', 'SALES_HCP_MARKETRX', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|6c537dfc49274ed8ace5f647d2ca4a40|1|SALES_SALES_HCP_MARKETRX_CUSTID_HCP'], ['raw', 'CUSTID_HCP', 'cc5cbbae85b94498b81f547e18d48aca', 'SALES_SALES_HCP_MARKETNRX_CUSTID_HCP', 'SALES_HCP_MARKETNRX', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|cc5cbbae85b94498b81f547e18d48aca|1|SALES_SALES_HCP_MARKETNRX_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '199d8a505e564a42a5609060cf61c624', 'ACTIVITY_ACTIVITY_HCP_CALLS_CUSTID_HCP', 'ACTIVITY_HCP_CALLS', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|199d8a505e564a42a5609060cf61c624|2|ACTIVITY_ACTIVITY_HCP_CALLS_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '2801e92ba19348988a63b7641f01fa43', 'ACTIVITY_ACTIVITY_HCP_SAMPLES_CUSTID_HCP', 'ACTIVITY_HCP_SAMPLES', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|2801e92ba19348988a63b7641f01fa43|2|ACTIVITY_ACTIVITY_HCP_SAMPLES_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '289b049e6bb64abd830fa3e4a0ef83ac', 'ACTIVITY_ACTIVITY_HCP_EMAILS_CUSTID_HCP', 'ACTIVITY_HCP_EMAILS', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|289b049e6bb64abd830fa3e4a0ef83ac|2|ACTIVITY_ACTIVITY_HCP_EMAILS_CUSTID_HCP'], ['raw', 'CUSTID_HCP', 'de4d4c56b97d45d5a3644057541bd524', 'ACTIVITY_ACTIVITY_HCP_EVENTS_CUSTID_HCP', 'ACTIVITY_HCP_EVENTS', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|de4d4c56b97d45d5a3644057541bd524|2|ACTIVITY_ACTIVITY_HCP_EVENTS_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '15bd51edf86540deb9803d704017d719', 'SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP', 'SEGMENT_HCP_QUINTILE', 3, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|15bd51edf86540deb9803d704017d719|3|SEGMENT_SEGMENT_HCP_QUINTILE_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '799c9fd34a174b78b1b3cfae8dae02e5', 'SEGMENT_SEGMENT_HCP_POTENTIAL_CUSTID_HCP', 'SEGMENT_HCP_POTENTIAL', 3, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|799c9fd34a174b78b1b3cfae8dae02e5|3|SEGMENT_SEGMENT_HCP_POTENTIAL_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '437095780d1f4ac0966a2cd446a7dc88', 'ACTIVITY_MISCHCP_CUSTID_HCP', 'MiscHCP', 2, 'lower', 5, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|437095780d1f4ac0966a2cd446a7dc88|2|ACTIVITY_MISCHCP_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '48cf2c5e70c742daa40cb6b0843a1c5e', 'ACTIVITY_ACTIVITY_MISCHCP_CUSTID_HCP_CUSTID_HCP', 'CloneMiscHCP', 2, 'lower', 5, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|48cf2c5e70c742daa40cb6b0843a1c5e|2|ACTIVITY_ACTIVITY_MISCHCP_CUSTID_HCP_CUSTID_HCP'], ['raw', 'CUSTID_HCP', 'b5700d1d9fff44cdbff54baab6f26c8f', 'ID_CUSTID_HCP_CUSTID_HCP', 'CUSTID_HCP', 5, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|b5700d1d9fff44cdbff54baab6f26c8f|5|ID_CUSTID_HCP_CUSTID_HCP'], ['raw', 'CUSTID_HCP', 'fe1687ed01ae4cfead42180419394901', 'DATERANGE_TIME_PERIOD_CUSTID_HCP', 'TIME_PERIOD', 4, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|fe1687ed01ae4cfead42180419394901|4|DATERANGE_TIME_PERIOD_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '9f8e9edd4a3e469ea5eae7573814d669', 'SALES_SALES_HCP_NRX_CUSTID_HCP', 'SALES_HCP_NRX', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|2cd6ada1e03b4899bbb39423b2072ab9|CUSTID_HCP|9f8e9edd4a3e469ea5eae7573814d669|1|SALES_SALES_HCP_NRX_CUSTID_HCP'], ['raw', 'GEOID_ZIP', 'd9b30760ac8b452193d3a00bf0b6cd9e', 'ACTIVITY_TIMEAGGREGATELOWERLEMAILS_GEOID_ZIP', 'TimeAggregateLowerLEmails', 2, 'lower', 4, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|d9b30760ac8b452193d3a00bf0b6cd9e|2|ACTIVITY_TIMEAGGREGATELOWERLEMAILS_GEOID_ZIP'], ['raw', 'GEOID_ZIP', 'cc82dd800efc4d02b0e81ffca7bb1d30', 'SEGMENT_FLAGRAW_GEOID_ZIP', 'FlagRaw', 3, 'lower', 1, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|cc82dd800efc4d02b0e81ffca7bb1d30|3|SEGMENT_FLAGRAW_GEOID_ZIP'], ['raw', 'GEOID_ZIP', 'dcb2911d2e424e388eb577061bca3cff', 'ACTIVITY_COUNTRAW_GEOID_ZIP', 'CountRaw', 2, 'lower', 2, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|dcb2911d2e424e388eb577061bca3cff|2|ACTIVITY_COUNTRAW_GEOID_ZIP'], ['raw', 'GEOID_ZIP', '42af40aeea41418e83edfb8fdee411c8', 'ACTIVITY_VOLTRANS_GEOID_ZIP', 'VolTrans', 2, 'lower', 6, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|42af40aeea41418e83edfb8fdee411c8|2|ACTIVITY_VOLTRANS_GEOID_ZIP'], ['raw', 'GEOID_ZIP', '2ae685ef23144a63a17f3ccdb7b9e661', 'ACTIVITY_MISCRAW_GEOID_ZIP', 'MiscRaw', 2, 'lower', 5, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|2ae685ef23144a63a17f3ccdb7b9e661|2|ACTIVITY_MISCRAW_GEOID_ZIP'], ['raw', 'GEOID_ZIP', '3efa01fec6c249b999bdcc5a50effaaa', 'ID_GEOID_ZIP_GEOID_ZIP', 'GEOID_ZIP', 5, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|3efa01fec6c249b999bdcc5a50effaaa|5|ID_GEOID_ZIP_GEOID_ZIP'], ['raw', 'GEOID_ZIP', '8943a5382d094ac984dc2e40af235755', 'DATERANGE_TIME_PERIOD_GEOID_ZIP', 'TIME_PERIOD', 4, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|8943a5382d094ac984dc2e40af235755|4|DATERANGE_TIME_PERIOD_GEOID_ZIP'], ['raw', 'GEOID_ZIP', '23ebad03648a414ab8717402171ee429', 'ACTIVITY_ACTIVITY_ZIP_VOUCHERS_GEOID_ZIP', 'ACTIVITY_ZIP_VOUCHERS', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|23ebad03648a414ab8717402171ee429|2|ACTIVITY_ACTIVITY_ZIP_VOUCHERS_GEOID_ZIP'], ['raw', 'GEOID_ZIP', '6dd3bfd3f0bb4bbfa3a412aec65a27e4', 'ACTIVITY_ACTIVITY_ZIP_DIGITALDISPLAY_GEOID_ZIP', 'ACTIVITY_ZIP_DIGITALDISPLAY', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|6dd3bfd3f0bb4bbfa3a412aec65a27e4|2|ACTIVITY_ACTIVITY_ZIP_DIGITALDISPLAY_GEOID_ZIP'], ['raw', 'GEOID_ZIP', 'ad775bed70074417b3dfe126397bf823', 'ACTIVITY_ACTIVITY_ZIP_SOCIALMEDIA_GEOID_ZIP', 'ACTIVITY_ZIP_SOCIALMEDIA', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|ad775bed70074417b3dfe126397bf823|2|ACTIVITY_ACTIVITY_ZIP_SOCIALMEDIA_GEOID_ZIP'], ['raw', 'GEOID_ZIP', '3234cadbf4404a0581b1f10c579473d2', 'ACTIVITY_ACTIVITY_ZIP_PRINTMEDIA_GEOID_ZIP', 'ACTIVITY_ZIP_PRINTMEDIA', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|3234cadbf4404a0581b1f10c579473d2|2|ACTIVITY_ACTIVITY_ZIP_PRINTMEDIA_GEOID_ZIP'], ['raw', 'GEOID_ZIP', 'fa80e84f6f8c412091e6e74dbbaeafa5', 'SALES_SALES_ZIP_SALESX_GEOID_ZIP', 'SALES_ZIP_SALESX', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|fa80e84f6f8c412091e6e74dbbaeafa5|1|SALES_SALES_ZIP_SALESX_GEOID_ZIP'], ['raw', 'GEOID_ZIP', 'b4cc0da2dead4d30971e741b346e7c59', 'SALES_SALES_ZIP_SALESY_GEOID_ZIP', 'SALES_ZIP_SALESY', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|b4cc0da2dead4d30971e741b346e7c59|1|SALES_SALES_ZIP_SALESY_GEOID_ZIP'], ['raw', 'GEOID_ZIP', '2c3f46f48da84811bd6e15c1c6345341', 'SALES_SALES_ZIP_SALES_Z_GEOID_ZIP', 'SALES_ZIP_SALES_Z', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|2c3f46f48da84811bd6e15c1c6345341|1|SALES_SALES_ZIP_SALES_Z_GEOID_ZIP'], ['raw', 'GEOID_ZIP', '8a488b00c6164eb9a49c568bf69994ad', 'SALES_SALES_ZIP_SALESW_GEOID_ZIP', 'SALES_ZIP_SALESW', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|8a488b00c6164eb9a49c568bf69994ad|1|SALES_SALES_ZIP_SALESW_GEOID_ZIP'], ['raw', 'GEOID_ZIP', '8caacb6d840a44108848000ff13d549a', 'SALES_SALES_SALES_HCP_NRX_CUSTID_HCP_GEOID_ZIP', 'SALES_HCP_NRX_Mapped_GEOID_ZIP', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|8caacb6d840a44108848000ff13d549a|1|SALES_SALES_SALES_HCP_NRX_CUSTID_HCP_GEOID_ZIP'], ['raw', 'GEOID_ZIP', 'ff6c9757558243359b733343f8464c9d', 'SALES_SALES_SALES_HCP_TRX_CUSTID_HCP_GEOID_ZIP', 'SALES_HCP_TRX_Mapped_GEOID_ZIP', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|ff6c9757558243359b733343f8464c9d|1|SALES_SALES_SALES_HCP_TRX_CUSTID_HCP_GEOID_ZIP'], ['raw', 'GEOID_ZIP', '20322ce7a0284a27b3e07ac6f7a26e39', 'SALES_SALES_SALES_HCP_MARKETRX_CUSTID_HCP_GEOID_ZIP', 'SALES_HCP_MARKETRX_Mapped_GEOID_ZIP', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|20322ce7a0284a27b3e07ac6f7a26e39|1|SALES_SALES_SALES_HCP_MARKETRX_CUSTID_HCP_GEOID_ZIP'], ['raw', 'GEOID_ZIP', 'd8d21b44a4c64db0aaf0f28beca77e30', 'SALES_SALES_SALES_HCP_MARKETNRX_CUSTID_HCP_GEOID_ZIP', 'SALES_HCP_MARKETNRX_Mapped_GEOID_ZIP', 1, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|d8d21b44a4c64db0aaf0f28beca77e30|1|SALES_SALES_SALES_HCP_MARKETNRX_CUSTID_HCP_GEOID_ZIP'], ['raw', 'GEOID_ZIP', 'b3bcd6e4f266465b9d99a0856f37a721', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_CALLS_CUSTID_HCP_GEOID_ZIP', 'ACTIVITY_HCP_CALLS_Mapped_GEOID_ZIP', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|b3bcd6e4f266465b9d99a0856f37a721|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_CALLS_CUSTID_HCP_GEOID_ZIP'], ['raw', 'GEOID_ZIP', 'cae61a6c2d544414a545501570f0369a', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_SAMPLES_CUSTID_HCP_GEOID_ZIP', 'ACTIVITY_HCP_SAMPLES_Mapped_GEOID_ZIP', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|cae61a6c2d544414a545501570f0369a|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_SAMPLES_CUSTID_HCP_GEOID_ZIP'], ['raw', 'GEOID_ZIP', '76693187cd7f414a87b398fc24dcb818', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_EMAILS_CUSTID_HCP_GEOID_ZIP', 'ACTIVITY_HCP_EMAILS_Mapped_GEOID_ZIP', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|76693187cd7f414a87b398fc24dcb818|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_EMAILS_CUSTID_HCP_GEOID_ZIP'], ['raw', 'GEOID_ZIP', 'b30fc6e4c74248868025e51c1d7b2306', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_EVENTS_CUSTID_HCP_GEOID_ZIP', 'ACTIVITY_HCP_EVENTS_Mapped_GEOID_ZIP', 2, 'lower', 0, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|b30fc6e4c74248868025e51c1d7b2306|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_EVENTS_CUSTID_HCP_GEOID_ZIP'], ['raw', 'GEOID_ZIP', '03ee9fd3279e42fabcc3ba70d27819db', 'ACTIVITY_TIMEAGGREGATESAMELVOUCHERS_GEOID_ZIP', 'TimeAggregateSameLVouchers', 2, 'lower', 4, '1058c193ddea4eea8ca9b4016b9caaf7|b6e8858a835b422f9c51257b4f00e702|GEOID_ZIP|03ee9fd3279e42fabcc3ba70d27819db|2|ACTIVITY_TIMEAGGREGATESAMELVOUCHERS_GEOID_ZIP']]}"
},
"isMultiplicative": true
}
},
"status": {
"code": 200,
"message": "Questions fetched successfully"
}
}