How to use 'Transaction Date' in survey | XM Community
Skip to main content

How to use 'Transaction Date' in survey


ManfredBM
Level 5 ●●●●●
Forum|alt.badge.img+35

Hi,
I've set up an XM Directory Automation for importing contacts (= calls to our hotline) and distributing a transactional feedback survey.
The date / time of the customer interaction (call to the hotline) gets imported into the XM Directory as "Transaction Date".
I now would like to use the date of the transaction in the survey flow / survey text. For example: "Thanks for calling our service hotline on 23-07-2022!"
Is there a way to access the 'Transaction Date' in the survey? I guess I have to set it up as Embedded Data?
And if so, is there a way to only use the day (and not the entire time stamp including the time)?

Thanks!
Manfred

10 replies

Deepak
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+44
  • 1549 replies
  • November 14, 2022

ManfredBM
To access the transactional data you do need to create that as embedded data. But in order to access the timestamp I am wondering are you sending the timestamp via the Import automation. As that's the data we are pulling in the survey.


ManfredBM
Level 5 ●●●●●
Forum|alt.badge.img+35
  • Author
  • Level 5 ●●●●●
  • 114 replies
  • November 14, 2022

Deepak
What do you mean by "sending the timestamp via the Import automation"?
I'm importing the time stamp in the following way:
image.pngI can access the other three fields in my survey flow (e.g. Call_ID). But how would I access the "Transaction Date"?


Deepak
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+44
  • 1549 replies
  • November 14, 2022

ManfredBM
The same way you set up others you can include this field in the survey flow as embedded data if you are generating links for that particular transaction via linked distribution. Also, to change it from ISO to yyyy-mm-dd format you can use javascript.
Something like this on load and add the actual date in a different embedded data as below used is Date.
var strDate = "2013-03-10T02:00:00Z";
strDate.substring(0, 10);
Qualtrics.SurveyEngine.setEmbeddedData( 'Date', strDate );
Hope it helps!


ManfredBM
Level 5 ●●●●●
Forum|alt.badge.img+35
  • Author
  • Level 5 ●●●●●
  • 114 replies
  • November 14, 2022

Deepak
Is the field name then 'Transaction Date'?


Deepak
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+44
  • 1549 replies
  • November 14, 2022

ManfredBM
Yes, include that in survey flow. If that is not filled try this "transactionDate".
Hope it helps!


JoycaV
QPN Level 4 ●●●●
Forum|alt.badge.img+27
  • QPN Level 4 ●●●●
  • 236 replies
  • July 26, 2024
Deepak wrote:

ManfredBM
Yes, include that in survey flow. If that is not filled try this "transactionDate".
Hope it helps!

Hi, I tried both Transaction Date and transactionDate, but neither of those seems to provide me with the transaction date value… (other transaction-related fields work fine, so my survey response is correctly linked to the transaction)


Forum|alt.badge.img+3
JoycaV wrote:
Deepak wrote:

ManfredBM
Yes, include that in survey flow. If that is not filled try this "transactionDate".
Hope it helps!

Hi, I tried both Transaction Date and transactionDate, but neither of those seems to provide me with the transaction date value… (other transaction-related fields work fine, so my survey response is correctly linked to the transaction)

I have the same issue where all transactional data fields embed except transaction date. I have tried every spelling under the sun; has anyone found a fix for this?


vgayraud
QPN Level 5 ●●●●●
Forum|alt.badge.img+48
  • QPN Level 5 ●●●●●
  • 361 replies
  • January 31, 2025

Hello,

 

Any luck on this? Facing the same issue...


vgayraud
QPN Level 5 ●●●●●
Forum|alt.badge.img+48
  • QPN Level 5 ●●●●●
  • 361 replies
  • January 31, 2025

I did came up with a kind of work-around method, but I can’t believe it’s impossible to retrieve the transaction date in the survey by easier means. I tried many spellings as well with no luck.

 

Here’s how I managed to retrieve it :

 


Forum|alt.badge.img+1

Hi, I had this problem too and asked help to the support. The solution is to add this default variable in the survey flow of the questionnaire : Q_TransactionDateTime.


Leave a Reply