Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qvsource google analytics visitors flow

Hi,

Is there any way to extract the visitors flow of a website using Qvsource?

I want to see all the movement between the different steps, the main problem is that I can't identify the direction of the flow (if a user goes back to a previous page or goes forward).

I enter in Google Analytics Query Explorer 2 in order to build the query and I see some page tracking dimensions that seems to be interesting but don't work as I want, for example:

ga:landingPagePath: is the first page that the user visited

ga:previousPagePath: its value is always '(entrance)'

ga:nextPagePath: returns also the first page that the user visited

ga:secondPagePath: returns the second page the user visited

I expected to extract all the flow using the first three dimensions but it doesn't work, the max step I get is the second page,

Anyone knows what I'm doing wrong or has another solution??

Thanks!

David

8 Replies
IAMDV
Master II
Master II

David - I did something similar in my previous company. Are you talking about the Page Flow in GA right? I had used the Funnel chart which mimics the Page Flow chart in GA. Please let me know if this is what you need...

Thanks,

DV

www.QlikShare.com

Not applicable
Author

Hi Deepak,

Is that chart what I need but I want the raw data,

I need to export this data in order to build other reports...

IAMDV
Master II
Master II

Okay sure. I'll get back to you with the field names we have used. Hopefully tonight/ tomorrow.

Thanks,

DV

www.QlikShare.com

Not applicable
Author

Perfect!

Thanks a lot!

IAMDV
Master II
Master II

Hi Again,

Like I said earlier this may not be 100% accurate solution but what we did is we used ga:exitPagePath to track the last page. And we knew the website page life cycle, so we had a mapping table defining the page path and the hierchary. Then I had used the mapping load to define where the user dropped and tagged the user's last visited page as {1,2,3,4,5...}. Finally then we used the Funnel Chart to show how users dropped off from the website. These numbers are almost matching with the GA Chart but they had something else included as well.

I hope this helps!

Cheers,

DV

www.QlikShare.com

Not applicable
Author

Hi,

Thanks Deepak but as I understand with this process you don't know if a user goes back from a page to a previous one, am I right?

Cheers,

David

Not applicable
Author

David,

Do you have an example of this?  I'd like to do this for my company.

Thanks!

Kim

Anonymous
Not applicable
Author

Hello,

I've found a way, if you want, you can see here:

http://bit.ly/1PQZ0Wj

Best Regards,