Changes for page Utilities - DExTr
Last modified by rayaan@one-count_com on 2023/11/09 10:38
Summary
-
Page properties (3 modified, 0 added, 0 removed)
-
Objects (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Title
-
... ... @@ -1,1 +1,1 @@ 1 -Utilities - DExTr1 +Utilities - Mapper (v12.x) - Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. Admin1 +XWiki.melanie@one-count_com - Content
-
... ... @@ -4,186 +4,204 @@ 4 4 5 5 6 6 {{id name="Start ScreenSteps Content"/}} 7 + The Mapper is used to create mappings for generating automated feed reports for export and for data import. This tool allows you to map your, or third party, data to ONEcount questions/data fields. 7 7 8 -DExTr is ONEcount’s data exchange and transformation engine. This tool enables data exchanges between any data source or third-party vendor. Establish a data map once and, going forward, easily import and export data in and out of ONEcount’s Customer Data Platform. 9 - 10 -This tool the capabilities to map and sync first- or third-party data to ONEcount questions/data fields. 11 - 12 -If there are multiple databases with similar fields, DExTr can consolidate the similar datapoints into a single ONEcount question or keep the fields separate. //(Example: if the field for ‘Customer ID’ in a legacy database is “CUST_ID” and the field name in a CRM is “CID”, there is an option to have the data consolidated in to the single ONEcount question that may be named “CustomerID”.// 13 - 14 14 **If you will be using the Dashboard Feed Report function to generate an automated feed report or will be performing a data import that requires mapping external file questions/data to ONEcount questions/data, you must complete the report mapping here first.** 15 15 16 16 There are three types of mapping in the Mapper: Demographic Mapping and Transaction Mapping. 17 17 18 -* ((( 19 -**Demographic Mapping:** Demographic mapping maps external demographic questions/data fields and responses to ONEcount demographic questions and responses. 20 -))) 21 -* ((( 22 -**Transaction Mapping:** Transaction mapping maps external transaction data, e.g. product purchase activity, status, and date formats. 23 -))) 24 -* ((( 25 -**Engagement Mapping:** Activity mapping maps external activity headers, e.g. time on page, URL, impressions, etc. This mapping is used primarily for feed reports for export, or importing activity from another system like an e-mail system. 26 -))) 13 +* **Demographic Mapping:** Demographic mapping maps external demographic questions/data fields and responses to ONEcount demographic questions and responses. 14 +* **Transaction Mapping:** Transaction mapping maps external transaction data, e.g. product activity, status, and date formats. 15 +* **Activity Mapping:** Activity mapping maps external activity headers, e.g. time on page, URL, impressions, etc. This mapping is used primarily for feed reports for export. 27 27 28 28 One or all of these types of mapping may be required, depending on the type of automated feed report you want to generate or the data import you'll be performing. 29 29 30 -You can either import a layout file (.csv format) withall of thenecessarydemographic,transacactional and engagement fields,and map demographics and transactions directly from that file,oryou canmanually enter the demographics, transactions, and activities you wish to map to ONEcount questions/data fields, or do a combination of both.19 +You can either import a layout file (.csv format) and map demographics and transactions directly from that file or manually enter the demographics, transactions, and activities you wish to map to ONEcount questions/data fields, or do a combination of both. 31 31 32 32 **Please Note:** 33 33 34 -**ONEcount questions ,response valuess,products and packagesmust be created prior to performing mapping.**23 +**ONEcount questions and response values must be created prior to performing mapping.** 35 35 36 36 **Third-party activity headers currently can't be mapped via an uploaded layout file. They must be mapped manually in the Activity Mapping Area.** 37 37 38 -**OPEN THE MAPPING WINDOW** 27 +== **OPEN THE MAPPING WINDOW** == 39 39 40 -Select UTIL ITIES from the main menuand the DExTr from the sub-menu.29 +=== Select UTILTIES from the main menu. === 41 41 42 -[[image:attach: DExTr Nav.png||width="707"]]31 +[[image:attach:media_1468251499518.png||align="center"]] 43 43 44 - Thiswill opentheMainDExTrListing Page,asshownbelow.33 +=== Select Mapper from the sub-menu. === 45 45 46 - **CREATE A NEW DExTrMAPPING**35 +[[image:attach:media_1468251557794.png||align="center"]] 47 47 48 - [[image:attach:DExTrListing Page.png||height="250"]]37 +This will open the Manage Mapping Listing Page, as shown below. 49 49 50 - \\39 +== **CREATE A NEW DATA MAPPING** == 51 51 41 +[[image:attach:media_1467388147151.png||align="center"]] 42 + 52 52 Select "Create Mapping" to create a new mapping. This will open the Mapping Builder, as shown below. 53 53 54 54 To edit an existing mapping, select the Edit icon. 55 -To copy an existing mapping, select the Copy icon. 56 -To delete an existing mapping, select the Delete icon. 57 -\\ 46 + To delete an existing mapping, select the Delete icon. 58 58 59 - \\48 +=== **1 – INFORMATION AND DEMOGRAPHIC MAPPING** === 60 60 50 +[[image:attach:media_1468252151743.png||align="center"]] 51 + 52 +Information and Demo Mapping consists of three main parts: 53 + 54 +**1 – Information** 55 + **2 – Mapping Area** 56 + **3 – ONEcount Questions** 57 + 58 +See below for detail on each part. 59 + 60 +==== __Information__ ==== 61 + 61 61 (% style="margin-left: 30.0px;" %) 62 - \\63 +**Name:** Give the mapping a name (required) 63 63 64 -Creating a Data Mapping 65 +(% style="margin-left: 30.0px;" %) 66 +**Description:** Provide a description of the mapping (optional) 65 65 66 -**[[image:attach:New-DExTr-Mapping.png||height="250"]]** 68 +(% style="margin-left: 30.0px;" %) 69 +**Select whether you want to map transactions and/or activity:** You can create a mapping for demographic questions only, or map any combination of demographics, transactions, and actions. 67 67 68 -\\ 71 +(% style="margin-left: 30.0px;" %) 72 +**Upload Layout:** Uploading a layout document is optional. You may opt to manually enter demographic and transactional questions and values to be mapped to ONEcount questions and values. Or, you may use a combination of both uploading a layout and manual entry. 69 69 70 -As you can see, a DExTr mapping consists of the following parts. You may use any or all of these components. The only required component to save the mapping is the mapping Title. All other components are optional. 74 +(% style="margin-left: 30.0px;" %) 75 +(% style="text-decoration: underline;" %)//**To Upload a Layout File**//(%%) 76 + Click on the "Browse" button, locate the file on your computer, then click on "Upload File". 71 71 72 -Navigate across the six tabs at the top of the interface to configure how the customer data platform will interpret and exchange data. 78 +(% style="margin-left: 30.0px;" %) 79 +When you upload an external layout, the Demographic and Transacton Mapping Areas will be automatically pre-populated with each question/data field and values for that field. (See screenshotbelow) 73 73 74 -1. ((( 75 -((( 76 -Exchange Map** - **Define Exchange Map 77 -))) 81 +(% style="margin-left: 30.0px;" %) 82 +See screenshots of pre-population and layout formatting rules below. 78 78 79 -((( 80 -1. ((( 81 -Enter a name and description for this data exchange, then proceed to the next tab (Demographic Fields). 82 -))) 83 -))) 84 -))) 84 +(% style="margin-left: 60.0px;text-align: center;" %) 85 +** 86 +** 85 85 86 - \\88 +[[image:attach:media_1468252886176.png||align="center"]] 87 87 88 -[[image:attach:DExTr Demo Tab.png||width="800"]] 90 +(% style="margin-left: 60.0px;" %) 91 +_(% style="text-decoration: underline;" %)**Layout File Format**(%%) _ 92 + The layout file must be in .csv format and include markers for demographic questions (~#~##demographics), products (~#~##products~#~##), subscription type(~#~##subscriptionType~#~##), and product status (optional) (~#~##productStatus~#~##). 89 89 90 -\\ 94 +(% style="margin-left: 60.0px;" %) 95 +(% style="text-decoration: underline;" %)//Demographic Mapping// 91 91 92 -1. ((( 93 -Demographic Fields** - ** Map external demographic questions/data fields and responses to ONEcount demographic questions and responses. 94 -))) 97 +* 98 +** 99 +*** For Demographic Questions: Question text must be in Column A, response values for multiple response-type questions* in Column B, and response text values in Column C. 100 + *Note that text-response type questions, e.g. last name, don't require values in Column B or C. 95 95 96 -Define field names (the column headers from the import file) on the left and match them to the ONEcount field on the right. 102 +(% style="margin-left: 60.0px;" %) 103 +(% style="text-decoration: underline;" %)//Transaction Mapping// 97 97 98 -If the ONEcount field does not yet exist, you'll need to create it using the Question Builder (see “Getting Started” section above).Map Values & Field Response Labels (non-text fields only) 105 +* 106 +** 107 +*** For Products: Product ID must be in Column A and Product name in Column B. 108 +*** For Subscription Type: Sub Type ID/value is in Column A and subscription type name in Column B. 109 +*** For Product Status: Status ID must be in Column A and Status name in Column B. 99 99 100 - If theresponseisnot a text field and iseither a drop down, radio buttonorcheck box selection, click the [ MapValues] button in the row under the “Map Responses” column. The Map Values button will open a pop-up window.Listedon the left are ONEcount Response Labels (and values). These are the responses defined for the ONEcountQuestionpaired to the field from the database. On the right, enter the valuesthatwill appear in the import file. It is very important to map all values, because if a value in the input file is not foundin ONEcount, the responseforthat field will be dropped. ONEcount will notallow external imports to add values to its response table. Also, if the values in your import file exactly match the values that ONEcount has (ie., for the State question, both the import/export file andONEcount use the two-letterabbreviations) thenyoudo notneed to create a mapping.111 +//**Screenshot: Pre-Populated Demographic Questions/Data Fields - Uploaded Layout**// 101 101 102 - \\113 +[[image:attach:media_1467396172019.png||align="center"]] 103 103 104 - [[image:attach:DExTrValue Mapping Pop-Up.png||height="250"]]115 + 105 105 106 - \\117 +**//Screenshot: Pre-populated Question Responses - Uploaded Layout//** 107 107 108 - \\119 +[[image:attach:media_1467391080266.png||align="center"]] 109 109 110 - Definehow ONEcount should translate each response using the fields in the right column, ‘Field Response’. DExTr can use the same responses, or you may choose to translate or ‘transform’ data to another format.121 + 111 111 112 -// (Example: statesmay be abbreviatedwith 4 letters inPOS database [Conn.,Mass.], whiletheecommerce databasehas twoletter abbreviations.)//123 +**//Screenshot: Pre-Populated Transaction Mapping - Uploaded Layout//** 113 113 114 - \\125 +[[image:attach:media_1467391409099.png||align="center"]] 115 115 116 - Optional:addvalidations for the field to either check for duplicates, require an entry, or verify the format entered to the field.Click “Add”to enter additional demographic fields.127 +==== MAPPING AREA ==== 117 117 118 -1. ((( 119 -Transactional Fields** - **Map external transaction data, e.g. product activity, status, and date formats. 120 -))) 129 +[[image:attach:media_1467397686498.png||align="center"]] 121 121 122 -* ((( 123 -1. ((( 124 -Define transactional fields by entering the field name from the import file, the field type and then match the value of the field to the value in ONEcount by clicking the [Map] button. 125 -))) 126 -1. ((( 127 -i.e. if the source/import file has a product field called “PUB_TITLE” and the value for current subscribers is “YES” on the import file, but the ONEcount product is “Active Subscriber”, the Package Status Value from the import file should be matched with the Package Status in ONEcount.) 128 -))) 129 -1. ((( 130 -Within the “Map Values” pop up window, click “Add” to define all possible transactional statuses. 131 -))) 131 +Prior to uploading a layout file, or if you opt to create the mapping on the fly (without uploading a layout file), the Mapping Area will be empty. 132 132 133 - 1.133 +The mapping area consists of three columns: **Third Party Questions, ONEcount Questions, and Validations.** 134 134 135 -Engagement Fields** - **Map external engagement (activity) headers, e.g. time on page, URL, impressions, email opens, registrations, link clicks, etc. Engagement field mapping is used primarily for exporting feed reports. 136 -))) 135 +* **Third Party Questions** shows questions/data fields your, or a third party's, data file. 136 +* **ONEcount Questions** shows the corresponding ONEcount question to be mapped to the Third Party Question. 137 +* **Validations** allows you to select validations for the mapped question, i.e., Required, Email, Number and Text, Text Only. 137 137 138 -* ((( 139 -1. ((( 140 -To map engagement values of fields, define the engagement field name (the column header from the import file) and match it to the engagement type in ONEcount. 141 -))) 142 -1. ((( 143 -If the Engagement Field Value is a metric that is not a count, click the [] icon to map the metric field value to the ONEcount metric 139 +===== Manually Add Third-Party Questions ===== 144 144 145 -//(i.e. if the source/import file has an ‘Engagement Field Name’ that is “NEWSLETTER_ACTIVITY_TYPE” the ‘ONEcount Engagement’ would be “Metric >> Activity Metric Name” and then map the values of metric type [“OPEN”, “CLICK”] to the ONEcount metric [“Email opens”/”Email clicks”]). // 146 -))) 147 -))) 141 +[[image:attach:media_1467398286154.png||align="center"]] 148 148 149 - 5.StaticFields143 +When you click on the "Add Questions" button, you'll be presented with a pop-up to create a new question/data field to be mapped to an existing ONEcount question. 150 150 151 -1. ((( 152 -*Optional Step: If a column and values needs to be added for identification, record keeping, sourcing, etc. purposes, DExTr can append data to each row. 153 -))) 154 -1. ((( 155 -Define the “Static Field Name” which will be the column heading on the export file (i.e. “DATA_SYNC_NAME”), and then the value of the static field (i.e. “CRM_SYNC”). 156 -))) 157 -1. ((( 158 -Click “Add” to create additional static field appends. 159 -))) 145 +Be sure to select "Yes" if it is a question with selectable responses, i.e. radio button/select/checkbox-type. Click Save. 160 160 161 - 6.Re-orderFields147 +===== Map Third-Party and ONEcount Questions ===== 162 162 163 -1. ((( 164 -*Optional Step: If the order of the columns needs to be re-arranged for the order in which they appear on the export from a data feed: simply drag and drop the order of fields by clicking and holding the field labels. 165 -))) 149 +[[image:attach:media_1467398257338.png||align="center"]] 166 166 167 - \\151 +If the question is a radio button/select/checkbox-type question, a button will be presented which will allow you to map responses and values. (See "Upgrade Checkbox" question above.) 168 168 169 -\\ 170 170 171 - TransactionMapping isdonethesame wayas Demographic Mappingbysingthedrag anddrop functionalitytomatchThird-Party transactionvalueswith ONEcount transactionvalues.154 +If it's a text-type response, you won't need to map responses and values. 172 172 156 +(% style="margin-left: 30.0px;" %) 157 +//YOU MUST FIRST MAP THE THIRD-PARTY QUESTION TO THE CORRESPONDING ONEcount QUESTION BY DRAGGING AND DROPPING THE CORRESPONDING ONEcount QUESTION FROM THE ONEcount Questions SECTION INTO THE ONEcount Questions Column BEFORE YOU CAN MAP RESPONSES.// 158 + 159 +(% style="margin-left: 30.0px;" %) 160 +//THIS APPLIES TO BOTH MANUALLY ADDED QUESTIONS AND QUESTIONS PRE-POPULATED BY UPLOAD OF AN IMPORT.// 161 + 162 +(% style="margin-left: 30.0px;" %) 163 +//ONEcount QUESTIONS AND RESPONSE VALUES MUST BE CREATED PRIOR TO PERFORMING MAPPING.// 164 + 165 +[[image:attach:media_1467398730892.png||align="center"]] 166 + 167 +Simply drag and drop ONEcount questions from the question pool into the appropriate cell in the mapping table. 168 + 169 +Note the Search function at the top of the list of ONEcount questions. Just begin typing in the question name, and the list will be filtered for you. (See screenshot below.) 170 + 171 +[[image:attach:media_1467398948360.png||align="center"]] 172 + 173 +Once Questions are mapped, you can add validations and/or map responses for radio/select/checkbox-type questions. 174 + 175 +To add validations, click in the empty "Validations" box for the corresponding question and select from the drop-down list the validation(s) you want to apply to the question, i.e. Required, Email, Number and Text, Text Only. (See screenshot below. 176 + 177 +//**Screenshot – Mapped Questions with Validations**// 178 + 179 +[[image:attach:media_1467399198566.png||align="center"]] 180 + 181 +===== Map Question Responses ===== 182 + 183 +[[image:attach:media_1467391237758.png||align="center"]] 184 + 185 +To map question responses, click on the "Response Map" button. Doing so will present a pop-up window where you can map third-party to ONEcount responses. Just drag and drop ONEcount responses from the list of ONEcount Responses into the appropriate cell. 186 + 187 +When done mapping responses, click the "Save" button. 188 + 189 +You'll be returned to Information and Demo Mapping where you can then continue mapping remaining questions or click "Next" to continue. 190 + 191 +Depending on the mapping selections you made under "Information", clicking "Next" will direct you either to save the Demographic Mapping or to the Transaction Mapping and/or Activity Mapping sections. 192 + 193 +=== 2 – TRANSACTION MAPPING === 194 + 195 +[[image:attach:media_1467651841763.png||align="center"]] 196 + 197 +Transaction Maping is done the same way as Demographic Mapping by using the drag and drop functionality to match Third-Party transaction values with ONEcount transaction values. 198 + 173 173 There are four Mapping Areas for Transaction Mapping: 174 174 175 -* ((( 176 -Product Mapping Area 177 -))) 178 -* ((( 179 -Product Status Mapping Area (optional) 180 -))) 181 -* ((( 182 -Subscription Mapping Area 183 -))) 184 -* ((( 185 -Date Mapping Area 186 -))) 201 +* Product Mapping Area 202 +* Product Status Mapping Area (optional) 203 +* Subscription Mapping Area 204 +* Date Mapping Area 187 187 188 188 **NOTE THAT MAPPING IS ID TO ID IN TRANSACTION MAPPING. THE ID IS FOUND IN PARENTHESIS AFTER THE TEXT IN THE "THIRDPARTY..." COLUMN OF MAPPING AREAS.** 189 189 ... ... @@ -192,66 +192,63 @@ 192 192 **THIRD-PARTY TRANSACTION VALUES CAN BE PRE-POPULATED BY UPLOADING A LAYOUT FILE OR MANUALLY ENTERED (AS DESCRIBED IN "INFORMATION" SECTION ABOVE).** 193 193 194 194 *(% style="text-decoration: underline;" %)Product Mapping Area(%%) * 195 -**For automated data feed reports**, the Third Party Product column shows what the ONEcount product name will be displayed as on output. 213 + **For automated data feed reports**, the Third Party Product column shows what the ONEcount product name will be displayed as on output. 196 196 197 -* ((( 198 - Forexample, a useris subscribedto/registeredfor ABCXY Pharma Aug. Webinar(207)inONEcount.Thethirdparty requiresthatonthe reportoutputshowavalue of AugustWebinar ratherthan ABCXY Pharma Aug. Webinar.Mapping ONEcount's ABCXY PharmaAug. Webinar(207)producttoAugustWebinar(400)will displaytheThirdPartyProduct valueof August Webinar onthe output.215 +* For example, a user is subscribed to/registered for ABCXY Pharma Aug. Webinar(207) in ONEcount. The third party requires that on the report output show a value of August Webinar rather than ABCXY Pharma Aug. Webinar. Mapping ONEcount's ABCXY Pharma Aug. Webinar(207) product to August Webinar(400) will display the Third Party Product value of August Webinar on the output. 216 + **Product Column Field:** This identifies what to output as the header for the product field. Enter the heading that's required for the report output. 199 199 200 -**Product Column Field:** This identifies what to output as the header for the product field. Enter the heading that's required for the report output. 201 -))) 202 - 203 203 **For imports,** the Third Party Product column identifies the names/values from the import file that will be mapped to the ONEcount product. 204 204 205 -* (((206 - Forexample, there's "product"column in theimport file that identifieswhat product a particular record issubscribedto or registered for. Inheimportfile, AugustWebinar inthatcolumindicatestherecordis subscribed to/registeredfor theAugust Webinar. In ONEcount, theproductname is ABCXY Pharma Aug. Webinar.Any recordin the import file thathasAugust Webinar in theproductcolumn will be subscribed to theABCYXY PharmaAug. Webinarproductin ONEcount.220 +* For example, there's "product" column in the import file that identifies what product a particular record is subscribed to or registered for. In the import file, August Webinar in that colum indicates the record is subscribed to/registered for the August Webinar. In ONEcount, the product name is ABCXY Pharma Aug. Webinar. Any record in the import file that has August Webinar in the product column will be subscribed to the ABCYXY Pharma Aug. Webinar product in ONEcount. 221 + **Product Column Field:** This identifies the column header for the product column in the import file. In the above example, you would enter "product". 207 207 208 -**Product Column Field:** This identifies the column header for the product column in the import file. In the above example, you would enter "product". 209 -))) 210 - 211 211 (% style="text-decoration: underline;" %)**Product Status Mapping Area (Optional)**(%%) 212 -**For automated data feed reports,** the Third Party Product Status column shows what the ONEcount product status will be displayed as on output. 224 + **For automated data feed reports,** the Third Party Product Status column shows what the ONEcount product status will be displayed as on output. 213 213 214 -* ((( 215 - Forexample, a userhas a productstatus of"Not Active(405)"in ONEcount.Thethirdparty requiresthat the reportoutput showa value of Inactive,ratherthan NotActive.Mapping ONEcont's "Not Active(405)"statusto "Inactive(203)" willdisplaytheThirdPartyProductStatusof Inactive onthe output.226 +* For example, a user has a product status of "Not Active(405)" in ONEcount. The third party requires that the report output show a value of Inactive, rather than Not Active. Mapping ONEcont's "Not Active(405)" status to "Inactive(203)" will display the Third Party Product Status of Inactive on the output. 227 + **Product Status Column Field:** This identifies what to output as the header for the product status field. Enter the heading that's required for the report output. 216 216 217 -**Product Status Column Field:** This identifies what to output as the header for the product status field. Enter the heading that's required for the report output. 218 -))) 219 - 220 220 **For Imports**, the Third Party Product Status column identifies what name/value from the import file will be mapped to the ONEcount product. 221 221 222 -* (( (223 - Forexample, there's a "productstatus"column in theimport filethatidentifies theproduct status a particular record has for a particular product. Intheimport file, "Inactive(203)"in that column indicates therecordhas a product status ofinactive. In ONEcount,the product statusis "Not Active(405)". Anyrecordin the import file thathas a product status of "Inactive"in theroductstatus columnwillhavehe product statusof"Not Active" applied to the record in ONEcount.231 +* For example, there's a "product status" column in the import file that identifies the product status a particular record has for a particular product. In the import file, "Inactive(203)"in that column indicates the record has a product status of inactive. In ONEcount, the product status is "Not Active(405)". Any record in the import file that has a product status of "Inactive" in the product status column will have the product status of "Not Active" applied to the record in ONEcount. 232 + **Product Status Column Field:** This identifies the column header for the product status column in the import file. In the above example, you would enter "product status". 224 224 225 -**Product Status Column Field:** This identifies the column header for the product status column in the import file. In the above example, you would enter "product status". 226 -))) 227 - 228 228 (% style="text-decoration: underline;" %)**Subscription Mapping Area**(%%) 229 -**For automated data feed reports,** the Third Party Subscription column shows what the ONEcount subscription type will be displayed as on output. 235 + **For automated data feed reports,** the Third Party Subscription column shows what the ONEcount subscription type will be displayed as on output. 230 230 231 -* ( ((232 - Forexample, auser has a subscriptiontypeof "n"inONEcount.Thethirdparty requiresthat the reportoutput showavalueofnew,ratherthan "n". Mapping ONEcont's"n" status"new(new)"willdisplaytheThirdPartyProductStatusof newonthe output.237 +* For example, a user has a subscription type of "n" in ONEcount. The third party requires that the report output show a value of new, rather than "n". Mapping ONEcont's "n" status to "new(new)" will display the Third Party Product Status of new on the output. 238 + **Subscription Column Field:** This identifies what to output as the header for the subscription type field. Enter the heading that's required for the report output. 233 233 234 -**Subscription Column Field:** This identifies what to output as the header for the subscription type field. Enter the heading that's required for the report output. 235 -))) 236 - 237 237 **For Imports**, the Third Party Subscription column identifies what name/value from the import file will be mapped to the ONEcount product. 238 238 239 -* (((240 - Forexample, there's a "SubcriptionType" column in theimport filethatidentifies thesubscription type a particular record has for a particular product. In the import file, "New" inthat column indicates therecordhas a subscription type ofnew. In ONEcount,the subscription typeis "n". Any recordin the import file thathasaroductstatusof "New" inhesubscriptiontypecolumn will have the product status of"n" applied to the record in ONEcount.242 +* For example, there's a "Subcription Type" column in the import file that identifies the subscription type a particular record has for a particular product. In the import file, "New" in that column indicates the record has a subscription type of new. In ONEcount, the subscription type is "n". Any record in the import file that has a product status of "New" in the subscription type column will have the product status of "n" applied to the record in ONEcount. 243 + **Subscription Column Field:** This identifies the column header for the subscription type column in the import file. In the above example, you would enter "Subscription Type". 241 241 242 -**Subscription Column Field:** This identifies the column header for the subscription type column in the import file. In the above example, you would enter "Subscription Type". 243 -))) 244 - 245 245 (% style="text-decoration: underline;" %)**Date Mapping Area**(%%) 246 -**For automated data feed reports,** enter the format you would like dates to be exported as. For example mm/dd/yyyy will export as 07/05/2016 and yy/mm/dd will export as 16/07/05. 247 -**Date Column Field:** This identifies what to output as the header for the date field. Enter the heading that's required for the report output. 246 + **For automated data feed reports,** enter the format you would like dates to be exported as. For example mm/dd/yyyy will export as 07/05/2016 and yy/mm/dd will export as 16/07/05. 247 + **Date Column Field:** This identifies what to output as the header for the date field. Enter the heading that's required for the report output. 248 248 249 249 **For Imports,** enter the format of dates in the import file. For example, if a date is 07/05/2016, enter the format mm/dd/yyyy. 250 -**Date Column Field:** This identifies the column header for the date column in the import file. 250 + **Date Column Field:** This identifies the column header for the date column in the import file. 251 251 252 252 When done with mapping, click "Next". 253 -You will then be brought either to Activity Mapping or Save, depending on selection made in 1 – Information. **SAVE MAPPING**253 +You will then be brought either to Activity Mapping or Save, depending on selection made in 1 – Information. 254 254 255 +=== 3 – ACTIVITY MAPPING === 256 + 257 +[[image:attach:media_1468256607407.png||align="center"]] 258 + 259 +Activity Maping is done the same way as Demographic and Transaction Mapping by using the drag and drop functionality to match Third Party Activity Header with ONEcount Activity Header. The Third Party Activity Headers will display as column headings for Web, Ad, and Newlsetter data in the export file. 260 + 261 +**Third-party activity headers currently can't be mapped via an uploaded layout file. They must be mapped manually in the Activity Mapping Area by clicking on the "Add Activity Header" button.** 262 + When you click on the "Add Activity Header" button, you'll be presented with a pop-up where you can add the Activity Header Name. 263 + 264 +The ONEcount Activity Header section is divided into the following categories: Web, Ad, Newsletter, Generic (includes general headers, such as ONEcount unique identifier, Channel Code, etc.) Note the scroll bar to move through the categories. 265 + 266 +When finished mapping, click the "Next" button. 267 + 268 +== **SAVE MAPPING** == 269 + 255 255 When done with mapping(s), click "Next". 256 256 257 257 You then have the option to save the mapping (Save) or return to mapping (Previous). ... ... @@ -266,39 +266,50 @@ 266 266 {{/layout-cell}} 267 267 268 268 {{layout-cell}} 269 - {{panel borderStyle="solid" title="Search all Documentation:"}}284 +**Search all Documentation:** 270 270 271 271 287 + 272 272 {{livesearch/}} 273 -{{/panel}} 274 274 275 - {{panelborderStyle="solid" title="Search System UTILITIES:"}}290 + 276 276 292 +**Search System UTILITIES:** 277 277 294 + 295 + 278 278 {{pagetreesearch rootPage="System Utilities"/}} 279 -{{/panel}} 280 280 281 -{{panel title="More System UTILITIES"}} 282 -{{expand title="Expand"}} 283 283 284 284 300 +**On this page:** 301 + 302 + 303 + 304 +{{toc maxLevel="3"/}} 305 + 306 + 307 + 308 +{{expand title="More System UTILITIES"}} 309 + [[QR Codes>>doc:Utilities - QR Codes (v12\.x)]] 310 + 285 285 (% style="margin-left: 30.0px;" %) 286 -[[Job List>>doc:Utilities - Job List]] 312 +[[Job List>>doc:Utilities - Job List (v12\.x)]] 287 287 288 288 (% style="margin-left: 30.0px;" %) 289 -[[Backend User Permissions>>doc:Utilities - Backend Users and Permissions]] 290 290 316 + 291 291 (% style="margin-left: 30.0px;" %) 292 -[[Email Engine Sender Score>>doc: ONEmailand SenderScore]]318 +[[Email Engine Sender Score>>doc:Utilities - Email Engine (v12\.x)]] 293 293 294 294 (% style="margin-left: 30.0px;" %) 295 -[[doc: ONEmail]]321 +[[Email Engine>>doc:Utilities - Email Engine (v12\.x)]] 296 296 297 297 (% style="margin-left: 30.0px;" %) 298 298 Action Manager 299 299 300 300 (% style="margin-left: 30.0px;" %) 301 -[[Configuration Manager>>doc:Utilities - Configuration Manager]] 327 +[[Configuration Manager>>doc:Utilities - Configuration Manager (v12\.x)]] 302 302 303 303 (% style="margin-left: 30.0px;" %) 304 304 Backend Activity Log ... ... @@ -307,8 +307,8 @@ 307 307 IVT Mitigator 308 308 309 309 (% style="margin-left: 30.0px;" %) 310 -[[Widget Builder>>doc:Utilities - Widget Builder]] 311 311 337 + 312 312 (% style="margin-left: 30.0px;" %) 313 313 314 314 ... ... @@ -315,11 +315,6 @@ 315 315 (% style="margin-left: 30.0px;" %) 316 316 Import/Export Tool 317 317 {{/expand}} 318 -{{/panel}} 319 - 320 -\\ 321 - 322 -\\ 323 323 {{/layout-cell}} 324 324 {{/layout-section}} 325 325 {{/layout}}
- Confluence.Code.ConfluencePageClass[0]
-
- id
-
... ... @@ -1,1 +1,1 @@ 1 - 233318721 +67343 - url
-
... ... @@ -1,1 +1,1 @@ 1 -https://info.onecount.net//wiki/spaces/OD/pages/ 23331872/Utilities -DExTr1 +https://info.onecount.net//wiki/spaces/OD/pages/67343/Utilities - Mapper (v12.x)