mapping of URL parameters to embedded data using lookup table + business rules

AndreasGenz
AndreasGenz Munich, GermanyCommunity Member, Qualtrics Brand Admin Qubie ✭

Hi everyone,

I've got a question about data mapping possibilities in Qualtrics.

We have a survey where we recieve different information via URL parameters. Those URL parameters need to be mapped to embedded data fields.
Currently we use some JS script to map some URL parameters:

Qualtrics.SurveyEngine.addOnload(function() { var dict = { "StoreA": "1", "StoreB": "2", "StoreC": "3" }; Qualtrics.SurveyEngine.setEmbeddedData("DirectRetail", dict["${e://Field/U_DR}"]); });

This approach has 2 major drawbacks:

  • When we have many different values the dictionary/lookup table becomes very large and confusing
  • The lookup table can't be maintained by the client by uploading a table to Qualtrics

We would now need to apply some mapping from 6 URL parameters to 2 embedded data fields. This mapping would need to work using a lookup table (which needs to be uploaded and updated in Qualtrics) and also some sort of business rules (logic sets). This could look something like this:

Source parameters: A, B, C, D, E, F
Target parameters: Y, Z

Lookup table for parameter A:

key1 --> value1
key2 --> value2
...

Lookup table for parameter C:

key1 --> value1
key2 --> value2
...

Lookup table for parameter E:

key1 --> value1
key2 --> value2
...

Business rules:

If (lookupTable(A) == example1) {
Y = B
}

If ((lookupTable(A) == example2) OR (lookupTable(C) == example3) {
Y = D
}

....

>

if (lookupTable(E) == example4) {
Z = F
}

>

....

Has anyone experienced similar needs and maybe already found some workaround?
Is any feature like this data mapping currently planned for Qualtrics?

Thank you in advance!

Best regards
Andreas

Tagged:

Best Answer

  • TomG
    TomG Raleigh, NCCommunity Member, Qualtrics Brand Admin Wizard ✭✭✭✭✭
    Accepted Answer

    This is best handled with web service call to an external database. You just need a web host/server to host the script and database.

Answers

  • AndreasGenz
    AndreasGenz Munich, GermanyCommunity Member, Qualtrics Brand Admin Qubie ✭

    Hi Tom,

    thanks for your reply!

    The issue is that the mapping table contains sensitive information which mustn't leave the Qualtrics server. Therefore this needs to happen in Qualtrics.

    Best
    Andreas