Load browser action metric as "per the geo location"

[amitbsht321]

Hi Team,

we are trying to fetch the data of Action duration- load action (by Brower) [web] using data explore. The requirement is to get the data as per the geo location.

We are not seeing any metric to set the bifurcation on basis of geo location apart from synthetic metrics.

Is their way to achieve the same?

Regards,

Amit Singh Bisht

[Yosi_Neuman · Accepted solution]

Hi @amitbsht321 

IMO you can use User sessions query for this with select like: "select usersession.country,AVG(visuallyCompleteTime) FROM useraction where type="Load" GROUP BY usersession.country"

And then pin it to dashboard

HTH

Yos 

[amitbsht321]

Hello @Yosi_Neuman 

Thanks a lot for you quick response. Yes we are getting data, as expected.

Just need one assistance from you. How to fetch the same data for a one specific application and a specific country i.e USA/UK ??

Regards,

Amit Singh Bisht 

[techean]

Use Management zones for specific application.

[Yosi_Neuman · Accepted solution]

Hi @amitbsht321 ,

Add to the where of the select your application and the desired country, something like: select usersession.country,AVG(visuallyCompleteTime) FROM useraction where application = "www.easytravel.com" and usersession.country = "United States" and type="Load" GROUP BY usersession.country

More information about  custom queries can be found in documentation 

HTH

Yos