Jump to content

How statistics works


Mr.SerikuS

Recommended Posts

Hello! I`m trying to get pages, where customers get from google.

 

I have made SQL:

select * from ps_page, ps_connections, ps_page_type WHERE ps_page.id_page = ps_connections.id_page AND ps_page.id_page_type = ps_page_type.id_page_type AND http_referer='https://www.google.lv/' GROUP BY date_add

but i got stucked by id_object.

 

I don`t know what is id_object, i couldn`t find in google information. How can i get page`s link/name, where person got from google.

 

Thank you.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...