1. Please complete a table below so the support team can insert or update the entries in the database.
Take a screenshot or take note of the following:
U Variable number |
U Variable Name (exact) |
Campaign Manager Type (String/Dimension or Number/Metric) |
u1 |
|
|
u2 |
|
|
For example:
U Variable number |
U Variable Name (exact) |
Campaign Manager Type (String/Dimension or Number/Metric) |
U20 |
CallID |
Dimension |
u21 |
CallDuration |
Metric |
a. Campaign Manager Type is not required in the DCM U variables configuration as it is using the general value and DCM will determine this automatically.
b. Any additional requirements on the specific u variable can be added by using a custom Javascript function. For example, the category for Call Duration when it is less or more than 5 minutes.
Javascript code is:
“var v = (PLA_duration<300) ? 'less than 5 min' : 'more than 5 min'; v”
OR "var v; if (PLA_duration > 60) v ='large'; else v='small'; v"
2. Go to Database and find the dcm_auth and dcm_convmap
Dcm_auth table is a master level configuration table to enable DCM for specific Master ID.
Pkey: auto fill primary key of the current table.
M_id: custom variable setup in Master level.
Dcm_at: the access token of dmc authorized account. If it is blank, it will take the AT from Master 6.
Dcm_rt: the refresh token of dmc authorized account. If it is blank, it will take the RT from Master 6.
Expiryat: the expire time of token. If it is blank, it will take the expire time from Master 6.
Dcmconvref: a foreign key for dcm_convmap table. It must match the pkey of dcm_convmap.
Pkey: auto fill primary key of the current table.
dcmauthref: a foreign key for dcm_auth table. It must match the pkey of dcm_ auth.
Dcmvar: the name of custom variable. It must be matched the U variable number on the step 1.
Delacol: the value of custom variable. The default value of U variable if there is not any custom function added. For example: pkey (#4) is without any custom function so the value is the same as PLA_duration.
Custom_func: the rules in Javascript as step 1.b and return a value. It could input multiple PLA variable but only return one value.
3. Complete the configuration according to the step 1. The DCM sync processor will pick it up automatically and no restart required.
Comments
0 comments
Please sign in to leave a comment.