How to find out hits per second from adobe analytics | Community
Skip to main content
deependras48844
deependras48844
April 3, 2019
Solved

How to find out hits per second from adobe analytics

  • April 3, 2019
  • 4 replies
  • 3334 views

How do i find hits per second on a particular URL from adobe analytics?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by David_Jerome

    Hi Sanmeet / Deepa,

    Yes - as Sanmeet say, if you have the I.T. resources available, then exporting a data feed from Adobes UI (if you are an Admin) into a data lake / AWS / AZURE environment is the smartest move, but if this this not already setup in your organisation it would be a large amount of work. If you were to request a datafeed straight from Adobe Analytics there is a field in the data feed called "hit_time_gmt" which Adobe derive from Unix time themselves. However what you need to remember is that because this approach would require all columns to show all hits, you will end up with a file that is over 600 columns in width, so again not a problem if your company has this already setup but not advisable if this is a one off question.

    Unix time only has one time zone and would not cause the issue Sanmeet suggests as your tag manager would be doing the calculation, not a calculation based on the users local time. However what his point does raise is that if you have one site that is used all throughout the world you may find it hard to track patterns by country unless you overlay Countries in your export - which again will make your data warehouse / API call very large.

    Dave

    4 replies

    PratheepArunRaj
    Community Advisor and Adobe Champion
    PratheepArunRajCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    April 5, 2019

    Dear Deepa,

    Are you want to understand the Server Calls for a particular page?

    Thank You!

    Arun

    Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
    David_Jerome
    David_Jerome
    Level 6
    April 5, 2019

    Hi Deepa,

    If I needed to do this I would add an EVAR that is populated with Unix time from DTM/GTM/Tealium etc on every hit.

    I would then let this run for around 2 weeks to build up some data, then run a data warehouse export of evarXX (unix time stamp) and evarXX instances against it. Ideally I would then use SQL to analyse this if you are trying to see if it changes by time of day, however if you are limited to excel tools you can only really analyse 1 day at a time.

    Dave

    sanmeetw1519854
    sanmeetw1519854
    Level 3
    April 5, 2019

    Hi Deependra,

    Best would be to request for a data feed from the client care.

    you can do all kind of implementations but bear in mind that these would be client side values and would send 'time' data based on the time value of the visitor. If the site spans across multiple time zones that this data can become difficult to analyze.

    As far as i can understand the business objective, i would the data feed approach instead of opting for any new session based tracking

    We can discuss this if you want

    Best,

    Sanmeet Singh Walia

    David_Jerome
    David_JeromeAccepted solution
    Level 6
    April 5, 2019

    Hi Sanmeet / Deepa,

    Yes - as Sanmeet say, if you have the I.T. resources available, then exporting a data feed from Adobes UI (if you are an Admin) into a data lake / AWS / AZURE environment is the smartest move, but if this this not already setup in your organisation it would be a large amount of work. If you were to request a datafeed straight from Adobe Analytics there is a field in the data feed called "hit_time_gmt" which Adobe derive from Unix time themselves. However what you need to remember is that because this approach would require all columns to show all hits, you will end up with a file that is over 600 columns in width, so again not a problem if your company has this already setup but not advisable if this is a one off question.

    Unix time only has one time zone and would not cause the issue Sanmeet suggests as your tag manager would be doing the calculation, not a calculation based on the users local time. However what his point does raise is that if you have one site that is used all throughout the world you may find it hard to track patterns by country unless you overlay Countries in your export - which again will make your data warehouse / API call very large.

    Dave

      Terms & ConditionsAccessibility statement

      Loading footer...