Profile Set Creation from ASCII file
· Each ASC file is a profile set. Each record in the file is a profile.
· Values are expressed in 000s. (must divide all values by 1000 for final output)
· The file is space delimited.
· Any string values are in quotes.
· Use the Solocast License Builder to change the ASC into a SCD/SCI set.
|
Field # |
Description |
CA Use of this field |
|
0 |
Put in "MR" (stands for MRI – US survey data) |
Ignored |
|
1 |
Demographic of who was surveyed. N.B. - this matches the five demographic types in Solocast. Your demographic must be one of these. |
1=Households
2=Population 18+
3=Population
4=Male 18+
5=Female 18+ |
|
2 |
Unknown, usually 1. |
Ignored |
|
3 |
Unknown, usually 1. |
Ignored |
|
4 |
Minimum Stable # of responses per cluster. Usually 30. |
Ignored |
|
5 |
Profile Name in Quotes |
Imported as Name |
|
All of your clusters with an additional field for "uncoded" records |
The # of people who were surveyed – expanded out to entire country. Therefore, if there are 62 clusters in the segmentation system, create 63 fields with a value of 0 in the 63rd field (the uncoded cluster). |
This is imported as the base users.
Volumetric - This should be imported as the # of users. |
|
All of your clusters with an additional field for "uncoded" records |
The number of “yes” respondents for this survey question - expanded out to entire country. Volumetric – the average number for the cluster (in case of questions like: "how many credit cards do you have") |
Imports as the # of "Users.
Volumetric - the average quantitative value for each cluster. |
|
All of your clusters with an additional field for "uncoded" records |
Only populated with values when you have Volumetric data. If volumetric, make the value -1 otherwise, put 0s for all clusters. |
Volumetric -1 flags this as a volumetric profile. Otherwise it is ignored. |
Example Raw file for Profile Set Creation (US Clusters)
"MR" 2 1 1 30 "Bought any men's apparel in last 12 months" 170.8 579.3 428.8 522.1 1084.3 1180.6 815.6 923.8 419.3 89.4 1051.7 324.1 581.7 211.1 557.1 691.8 234.7 188.6 199.4 276.2 176.6 360.4 339.6 251 1161.1 550.6 253.1 455.2 1432.7 543.5 1007 93.8 324.9 554.1 788.2 279.5 80.7 113.6 254.7 282.3 0 0 0 97.3 320.2 254.4 327.5 647.8 745.2 462 583.7 222.7 46.5 583.5 171.6 322.9 130.2 296.7 378.1 136.4 110.6 95.6 142.9 95.1 192.6 148.3 113.4 656.4 255.3 119.1 211 828 330.7 520 46.8 173.2 303.4 449.5 130 37.7 45.5 110.4 109.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
"MR" 2 1 1 30 "Bought men's casual slacks in last 12 months" 170.8 579.3 428.8 522.1 1084.3 1180.6 815.6 923.8 419.3 89.4 1051.7 324.1 581.7 211.1 557.1 691.8 234.7 188.6 199.4 276.2 176.6 360.4 339.6 251 1161.1 550.6 253.1 455.2 1432.7 543.5 1007 93.8 324.9 554.1 788.2 279.5 80.7 113.6 254.7 282.3 0 0 0 41 137.9 116.1 152.1 274 288.2 180.3 186.4 67.5 11.4 216.5 59.4 110.9 45.7 105.7 147.2 55.7 28.5 31.1 53.8 37.1 46.1 47.2 30.4 191.8 58.3 31.5 45 244.4 97.6 132.6 8.7 48.8 90.7 122.8 45.6 13.6 15.7 34.7 38.3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Example Raw file for Profile Set Creation (Canadian Mosaic Clusters)
"MR" 1 1 1 30 "Convenience Stores ; Personally Shopped At In Past 6 Months : Yes" 102.825 66.806 17.565 47.049 135.768 60.788 31.534 80.402 47.088 40.165 94.481 134.128 195.55 113.138 85.84 54.215 79.188 68.854 125.721 51.201 183.081 80.099 62.412 71.027 70.86 121.447 161.033 96.439 47.206 46.098 85.232 29.914 34.159 68.611 125.213 50.271 57.009 6.242 6.77 61.435 56.711 70.387 16.322 34.216 63.166 73.108 70.425 92.083 214.574 130.241 114.077 21.367 98.239 118.375 222.103 91.527 30.298 92.09 135.015 18.51 82.631 56.219 30.294 95.862 131.609 13.92 32.809 115.388 15.558 98.025 49.263 153.913 33.561 99.922 88.811 103.269 66.132 35.74 35.501 65.536 121.553 44.77 0.788 37.509 12.608 52.783 381.958 115.8 70.139 66.865 121.793 72.875 65.371 168.954 203.635 48.959 29.149 21.086 148.527 122.062 220.428 73.999 10.642 153.294 88.955 116.84 75.39 91.914 22.919 39.033 65.927 247.877 48.858 101.952 40.313 122.053 53.235 123.05 30.333 34.827 34.343 81.784 13.632 1.934 15.28 38.957 138.593 78.07 49.926 67.653 76.329 10.499 22.456 88.078 199.308 8.126 55.417 27.095 47.161 109.199 105.505 14.472 53.461 28.642 155.069 126.935 129.018 11.982 116.702 0.18 83.087 52.949 12.714 38.495 108.932 50.216 25.065 66.213 41.548 29.843 72.612 114.847 166.441 98.552 74.556 47.438 68.066 57.179 100.857 43 156.419 71.755 52.66 55.12 59.342 104.097 140.545 77.716 38.876 34.574 74.28 25.344 25.408 57.728 105.179 42.963 49.679 5.585 6.206 52.359 40.684 62.912 13.058 27.156 53.117 60.413 53.568 81.222 191.291 118.916 92.523 16.722 81.266 107.168 191.089 79.552 25.88 72.108 104.578 14.303 70.348 44.551 26.559 82.167 103.238 12.849 27.629 92.999 12.258 83.941 44.398 115.068 31.293 81.418 72.952 90.252 48.786 31.51 33.371 58.368 107.895 36.376 0 30.154 6.304 44.27 306.135 95.4 60.629 50.337 99.649 62.034 56.655 129.999 133.371 43.751 22.75 18.178 125.564 111.691 185.731 63.17 8.868 108.65 75.374 102.029 58.952 78.297 18.675 28.665 54.939 175.993 37.726 90.074 32.848 104.84 44.195 105.235 21.965 27.165 32.001 62.834 12.117 0.967 12.006 31.802 122.67 61.918 43.874 49.202 69.299 9.332 19.462 69.395 165.969 8.126 46.55 24.084 44.387 95.017 91.177 11.256 45.514 25.778 132.916 108.093 113.357 11.126 94.01 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
"MR" 1 1 1 30 "Convenience Stores ; Number Of Times Shopped At In Past 30 Days : 6+" 102.825 66.806 17.565 47.049 135.768 60.788 31.534 80.402 47.088 40.165 94.481 134.128 195.55 113.138 85.84 54.215 79.188 68.854 125.721 51.201 183.081 80.099 62.412 71.027 70.86 121.447 161.033 96.439 47.206 46.098 85.232 29.914 34.159 68.611 125.213 50.271 57.009 6.242 6.77 61.435 56.711 70.387 16.322 34.216 63.166 73.108 70.425 92.083 214.574 130.241 114.077 21.367 98.239 118.375 222.103 91.527 30.298 92.09 135.015 18.51 82.631 56.219 30.294 95.862 131.609 13.92 32.809 115.388 15.558 98.025 49.263 153.913 33.561 99.922 88.811 103.269 66.132 35.74 35.501 65.536 121.553 44.77 0.788 37.509 12.608 52.783 381.958 115.8 70.139 66.865 121.793 72.875 65.371 168.954 203.635 48.959 29.149 21.086 148.527 122.062 220.428 73.999 10.642 153.294 88.955 116.84 75.39 91.914 22.919 39.033 65.927 247.877 48.858 101.952 40.313 122.053 53.235 123.05 30.333 34.827 34.343 81.784 13.632 1.934 15.28 38.957 138.593 78.07 49.926 67.653 76.329 10.499 22.456 88.078 199.308 8.126 55.417 27.095 47.161 109.199 105.505 14.472 53.461 28.642 155.069 126.935 129.018 11.982 116.702 0.18 42.742 32.362 6.702 22.054 61.857 29.726 12.824 34.231 24.264 15.224 39.289 64.368 81.552 56.794 39.713 29.528 43.096 32.335 58.238 21.357 85.094 46.724 31.206 28.608 31.04 59.935 83.912 46.815 22.712 18.577 40.343 15.456 17.285 35.2 65.485 24.802 29.954 4.406 0.752 22.723 21.229 33.341 5.713 14.133 34.29 25.702 31.181 40.252 109.809 63.689 61.532 10.055 44.038 53.881 126.916 37.755 17.735 39.3 63.666 9.255 43.023 28.448 14.658 53.462 69.041 5.8 15.875 58.825 5.186 49.013 26.743 79.036 19.178 56.965 42.34 59.011 26.614 22.813 20.394 36.137 83.168 24.872 0 24.044 0 31.049 206.841 50.381 38.576 26.066 81.515 42.072 35.354 67.198 87.574 33.033 8.745 11.422 75.817 71.277 135.648 35.343 4.73 73.385 52.326 72.379 36.091 49.439 14.188 15.613 37.038 105.684 24.858 57.496 26.008 68.901 28.475 65.144 19.716 18.825 18.889 42.255 5.112 0 8.335 17.428 85.763 46.842 28.406 42.283 41.858 8.999 14.115 56.708 102.839 5.417 32.084 11.612 21.072 69.333 58.434 4.135 35.056 11.794 91.171 67.276 78.692 4.357 58.351 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Example Raw file for Volumetric Profile Set Creation (US Mosaic Clusters)
"MR" 2 1 1 30 "Gasoline: Volume (dvol): Gallons/Last 7 Days" 521.9 1369.2 3600.7 2972.7 1884.4 2635.5 2035.9 3283.4 1313.4 2390.9 1721 5400.6 3330.5 3154 4438.6 5044.2 1568.1 3307.1 4150.9 2405.8 1159.3 3706.3 3287.6 5095.1 790.2 2783.6 3940 182.1 3288.9 3995.1 1102.4 595.7 2109.3 4885.6 2866.9 4589.2 4961.9 4441.4 2059.5 1853.7 4272.1 4076.3 2008.6 402.1 1618.9 2097.4 2632 2553.1 2090 1736.5 2190.1 2261 600.5 1915.6 1540.1 649.9 973.6 1543.6 1332.3 450.4 67.3 349.6 0 13.8534202 14.96625767 16.75935235 14.04726343 14.66302271 16.61331816 17.52119456 14.39876348 4.151971981 14.64544732 10.93968623 14.73456653 13.74655457 15.70776791 15.64995719 16.31108996 16.02429692 13.80832149 16.80717435 17.34250561 15.61847667 17.84895988 14.84499331 15.66167494 15.40749177 12.48757005 15.43055838 18.30422845 13.20462769 16.19571475 11.28111393 10.69481283 7.829232447 13.79717947 13.77473927 18.93197071 18.55867712 14.8584005 15.18436514 10.84085882 14.1968821 15.90513456 20.81828139 15.14946531 21.60633764 20.06336417 16.31451368 15.67596256 11.69516746 12.38784912 10.79060317 14.64772225 14.67310575 10.35440593 6.916239205 4.105400831 10.50647083 1.607735165 8.326803273 10.02553286 8.707280832 13.51115561 0 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1