Ad Hoc Analysis Metrics Add Request | Community
Skip to main content
Level 2
October 16, 2015
Solved

Ad Hoc Analysis Metrics Add Request

  • October 16, 2015
  • 3 replies
  • 1660 views

Is it possible to have "instances" available in Ad Hoc? Currently, if I want to know how many times a dimension is executed, I have only a couple of choices such as "occurrences" and this brings in too much noise. From my understanding, it brings in all clicks, downloads, etc. for the time period. However, if I breakdown the dimension by page or keyword search, it shows me the "occurrences" of those dimensions, but it adds the others as well. So, if I have 5 pages visited by a user, it will show a total of 150 occurrences instead of only 5. For reporting purposes, this total number is confusing and it's very manual for me to go through and try to clean that up after exporting to excel. If we want to make our companies move to a data-culture, we need to have the right data that reports easily to them.

Thanks for your consideration and hope to hear back from someone on whether this is possible or not? Or if someone has a suggestion for me?

Tina

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by warrensander

if it's a prop then pageviews should work. traffic is all based on pageviews and it's the base metric. this assumes that the customer does something (internal search on a page or externally comes in with a search term you pickup from a url parameter) but either way you record the search term in a prop. the prop is recorded in a server s.t() server call.

If it's an s.tl() custom link call it's a bit harder and you have to use occurrences because occurrences  counts both page views and custom links. If you only want when this prop is populated via a custom link call then a calculated metric or (occurrences - page views) might help.

Or create a segment for hit when propx is populated and some other variable in the custom link call is populated differently from the page call and add that to your segment.

3 replies

khurshid
Adobe Employee
Adobe Employee
October 16, 2015

Thank you for reaching out to the community.

You may use "instances of evars" as metric to have the "instances" in Ad Hoc for evar reports. For Campaign, you may use Campaign Click-throughs and Page Views for props (provided they are not being set in a custom link call). Hope that helps.

 

best

Khurshid

tinas841Author
Level 2
October 16, 2015

Thanks for your reply. It's a custom traffic that shows us the keyword searches. What do you suggest to use in that case?

warrensander
warrensanderAccepted solution
Level 6
October 16, 2015

if it's a prop then pageviews should work. traffic is all based on pageviews and it's the base metric. this assumes that the customer does something (internal search on a page or externally comes in with a search term you pickup from a url parameter) but either way you record the search term in a prop. the prop is recorded in a server s.t() server call.

If it's an s.tl() custom link call it's a bit harder and you have to use occurrences because occurrences  counts both page views and custom links. If you only want when this prop is populated via a custom link call then a calculated metric or (occurrences - page views) might help.

Or create a segment for hit when propx is populated and some other variable in the custom link call is populated differently from the page call and add that to your segment.