Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

Want to create a funnel, but I don't know where to start

nrql

#1

Is there a query that I can use to determine what users go after a homepage start? The assumption is that the homepage is the first place a person visits, is there a method to correlate where users visit first by bookmark or some other method? Where do you get started with picking apart the data?


#2

I viewed this tutorial, but it wasn’t really helpful. https://newrelic.wistia.com/medias/ynqgdeg2eo

When I try to copy the format, the NRQL has errors so perhaps it was updated since the video was released.


#3

Hi, @reopelle.scott: I don’t think a funnel is what you want. A funnel answers the question, “What percentage of users who perform action X also perform action Y?” You have to decide in advance which actions Y you want to check for. It sounds like you want to answer the question, “After users perform action X, what do they do next?” In other words, you don’t know what actions Y they are performing.

The following query may provide what you are looking for:

SELECT count(*) FROM 
Transaction WHERE appName = 'My Application' 
  AND `request.headers.referer` = 'https://www.homepage.com/' 
FACET `Dynamo Request URI`

(`Dynamo Request URI` is a custom attribute in your application that appears to record which URL the user requested.)


#4

As always, thanks Phil. Do I interpret the results to indicate, from the home page, these are the number of actions that are taken? If this is so, it demonstrates what is most likely to be the next step after a user visits our homepage.


#5

Yes. “This is the number of requests for URL X in which the referring URL was the home page.”


#6

WOW! That is incredibly powerful. You never disappoint @philweber