I'm trying to use Analytics to get how many access each page on my website is receiving and I want to see that information divided by customer. I managed to collect all the data I need and show it in a graph using the following query:
SELECT segments.userData.CodPagina AS 'Page name', segments.userData.RazaoSocial AS 'Customer', count(*) AS 'Number of visits' FROM transactions WHERE application = "frotas.localiza.com/MyFleet" and segments.userData.RazaoSocial is not null and segments.userData.CodPagina IN (29, 50, 5, 8, 11, 14, 4, 18, 3, 40) and segments.userData.CodPagina != 273
My problem is: "codPagina" is the ID of each page in the application code, but I need to replace the number with the actual name of the page. Is there any way I can do that correlation in the query?
