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
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive