Business iQ (Analytics)

cancel
Showing results for 
Search instead for 
Did you mean: 

Change the name of return values of an ADQL query

Highlighted

Change the name of return values of an ADQL query

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?

Tags (2)
Change the name of return values of an ADQL query