Determining Time on Page using ' Advanced Adobe' Connector
Help DOMO Community!
My Team and I used Average Time Spent on Page (averagetimespentonpage) and Average TIme Spent on Site (averagetimespentonsite) as metrics for an 'Intermediate' report type that used 'Page' as the Report Element.
Average TIme Spent on Page yielded a nonnumeric value that we could not convert in ETL (error occured on that step when preview was run). Average Time on Site yielded a numerica value but it was at the server level. We need to see the time spent on a page level from our Adobe data dump. What are we missing??
Thanks for all those who willing to help!
Comments
-
Hello,
If the ETL will not convert the text field to a number then it suggests someplace in that field there are non-numeric values. Work with your dataset and by filtering you should be able to find the values in there ate are causing you this issue. You then have two methods you can use to resolve this.
1. Return to your data source and correct the data there.
2. Replace or remove those values in your ETL prior to the conversion.
I hope this helps you.
Jarvis
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有