Data Warehouse and Workspace reports help

jesperb18079817

17-11-2017

Hello!

In the Data Warehouse I have built a report based on these dimensions: Day - Visitor ID - Media ID - Media Name - Embedded URL. And these metrics: Video Initiates - Content time spent.

All these are in one row.

I want to do something similar in the new Workspace tool, I can't find a way to use multiple dimensions and multiple metrics in one freeform table or any other template.

I can't find Visitor ID though in the new workspace, any tips?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

PratheepArunRaj

Moderator

17-11-2017

Hello Jes,

To use Analytics or Marketing Cloud Visitor ID in Work space, you need to capture the same and store it in a traffic or conversion variable (s.prop or s.eVar). Else, you need to use Data warehouse to extract.

Thank You!

Arun

Answers (8)

Answers (8)

hyderziaee

Employee

20-11-2017

If you are looking at the same report suite in Data Warehouse, you should be able to see Content Time Spent.

1352864_pastedImage_1.png

Also note, that the Content Time Spent and Total Seconds Spent are separate metrics.

Time Spent : Total Time Spent metrics is calculated for the page

Video Parameters : Content Time spent is calculated for the video on the page.

jesperb18079817

21-11-2017

Thanks!

Is there anyway I can check the implementation? or the data capture?

Any pointer or tips on where to start?

Unfortunately, currently there is no one else than me to ask.

hyderziaee

Employee

21-11-2017

You may need to check the implementation. Could be something wrong with the data capture.

You can reach out to the person who manages the implementation within the company, OR ask a supported user to open a ticket with Customer Care. (The first option would be the best, since the person who implemented would know more)

jesperb18079817

20-11-2017

Thanks allot!

Any idea why the data in Data Warehouse and Workspace are different?

In workspace I have a metric called "Content Time Spent" reporting 50h for a certain video over a period of 10 day.

In Data Warehouse the metric "Total seconds Spent" reports 20h for the same time period.

Why is this? and more importantly, is there a way to use the "Content Time Spent" metric from Workspace in the Data Warehouse requests? (This would be so helpful if that was possible)

Thanks allot again!

hyderziaee

Employee

19-11-2017

The default Visitor ID dimension is only accessible to the Data Warehouse and Data Feed tool. You will need to implement the visitor Id to be set in a custom variable, if you would like to use this in any other tool (such as Workspace).

If you want to do automation, I would recommend sticking with Data Warehouse. It is able to handle greater breakdowns and has better scheduling capabilities. (I am assuming by automation, you mean inserting the data in a different location)

jesperb18079817

19-11-2017

Thanks!

Could you please clarify what that means, As I understand, I need to somehow create a new dimension for the Visitor ID data?

Also, would you recommend Data Warehouse or Workspace?

Which one would be better for an automated report?

Thanks so much for your info