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.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive