Hi all!
We use participation metrics to evaluate a page, or groups/types of pages, and whether they are contributing to conversions, like 'request pricing', 'document downloads', etc.
When we run reports in the GUI, you will always get, at the bottom of the report, tons of other page with zero visits and zero page views, but will have values for one or more of the participate metrics..I assume....the eVar holding the page name is set to expire on the visit, so I am not sure what is happening, but that is easy to filter out.
BUT, when we run page reports in Data Warehouse, we have two issues:
- If we have more than 2-3 participate metrics, the number of lines in the report MASSIVELY balloons...so a site with approx. 50,000 total pages including parts calalogs etc. winds up exporting files that have over 10 million lines...which is kinda difficult to handle :-[ And, it will only sort ascending, so I can't limit the # of lines in the report...
We've tried various segments with logic like 'pageviews exist' etc., all to no avail. Any ideas?
- Also, in Data Warehouse, the Participation metrics column headings don't pick up the name of the metric, but only "Custom Event 10 Participation" which also makes things a pain. This might be a bug that I will just enter a ticket for.
Any ideas or suggestions or good wishes are appreciated!
Eugene