Adobe Analytics value limits (max number of rows) | Community
Skip to main content
A
Anonymous
May 31, 2017
Solved

Adobe Analytics value limits (max number of rows)

  • May 31, 2017
  • 11 replies
  • 13285 views

Hello everybody,

I am currently working at a company where we're in the phase of choosing our new analytics tool. In this process we're (obviously) also comparing tools with each other and we're currently looking into "out-of-the-box" data availability.

This means that we're looking at how many rows are directly (not through an API) available in:

  • a normal report (as far as I know this is 50k, but I would like to know whether this is the right amount).
  • a data export/extract (scheduled or directly requested) (afaik: 50k)
  • a data warehouse export (The adobe help pages state this is unlimited and as I can recall this is correct but I would really like to know how many rows DWH can export from the interface).
  • a workspace report (afaik: 200 rows per breakdown).
  • Unique values (cardinality) (afaik: 500k, but could this be extended?)

Can someone check these numbers on short notice?

Thank you very much in advance.

Best regards,

Stefan Leever

    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 TanmayMathur

    Hi Stefan,

    Welcome to the Analytics Community.

    • a normal report - 200 rows on a single page
    • a data export/extract - 50k
    • a data warehouse export - unlimited
    • a workspace report - 200 per breakdown
    • Unique values (cardinality) - 500k, but can be customized.

    You can get more detailed comparisons here - https://marketing.adobe.com/resources/help/en_US/reference/analytics-product-comparison.html

    11 replies

    TanmayMathur
    Adobe Employee
    TanmayMathurAdobe EmployeeAccepted solution
    Adobe Employee
    May 31, 2017

    Hi Stefan,

    Welcome to the Analytics Community.

    • a normal report - 200 rows on a single page
    • a data export/extract - 50k
    • a data warehouse export - unlimited
    • a workspace report - 200 per breakdown
    • Unique values (cardinality) - 500k, but can be customized.

    You can get more detailed comparisons here - https://marketing.adobe.com/resources/help/en_US/reference/analytics-product-comparison.html

      A
      Anonymous
      May 31, 2017

      Hello Tanmay,

      Thank you for your quick response.

      Regarding data warehouse. How many rows can be in a single file send to an FTP environment?

      Thanks in advance and thanks for the page reference.

      Best regards,

      Stefan

      TanmayMathur
      Adobe Employee
      TanmayMathurAdobe Employee
      Adobe Employee
      June 1, 2017

      Hi Stefan,

      I don't think there is a FTP related row limit. Adobe FTP would have a size limit of 2GB so as long as the file does not reach that size it should be good.

      AliMaleki
      AliMaleki
      Level 4
      August 7, 2017

      Hi can you please explain this:

      • Unique values (cardinality) - 500k, but can be customized.

      How can this be changed? I've looked in the ReportSuite configuration but I don't see it.

      Ali

      I
      Adobe Employee
      isinhaAdobe Employee
      Adobe Employee
      August 7, 2017

      Hi Ali alim92960278​

      This can be changed by contacting Client Care at clientcare@adobe.com. It is done using one of the back end tools.

      However, please be advised that the limit of 500,000 is designed to optimize the reporting performance. Increasing the limit can impact reporting performance especially when using breakdowns, where the report can take time to fetch.

      Thanks!

        AliMaleki
        AliMaleki
        Level 4
        August 7, 2017

        Thanks for the quick reply!

          S
          sujitb1706693
          November 2, 2017

          what is the row limit if i want to extract data from API? am using logic app to extract data from Adobe API.

          Currently fetching only 10 rows by default,thats too less! Is that the limit?

          svedoe
          svedoe
          Level 2
          January 4, 2018

          I am currently experiencing the same problem. Regardless of what I do the max number of rows returned by an API report is 10. Quite hindering imho.

          I remember not having the problem the last time I was using the API from a python script so I'm currently a little bit lost. Hope to find an answer non the less. Will keep you updated.

          Hyder_Ziaee
          Adobe Employee
          Hyder_ZiaeeAdobe Employee
          Adobe Employee
          January 4, 2018

          Can you share the API request you are using? There shouldn't be a cap, especially at 10, unless specified in the API request.

          svedoe
          svedoe
          Level 2
          January 5, 2018

          I am using a python module for querying the Adobe Analytics API. This resulted in the following JSON object being constructed as a request for the API:

          INFO:omniture.account:Request: Report.Queue Parameters: {'reportDescription': {'reportSuiteID': 'XXXXXXXXXXXXXX', 'elements': [{'id': 'evar31'}], 'metrics': [{'id': 'event297'}], 'dateFrom': '2017-01-01', 'dateTo': '2017-12-31', 'sortBy': 'eventXXX', 'dateGranularity': 'month'}}

          But after digging deeper into the (pdf) API documentation I found an additional  parameter for the element of a report to describe the number of rows returned for an element. This parameter is called top:

          reportDefinitionElement --> top


          Using this I am able to bump up the number of returned rows:

          INFO:omniture.account:Request: Report.Queue Parameters: {'reportDescription': {'reportSuiteID': 'bmweretail.eretail.uk.prod', 'elements': [{'id': 'evar31', 'top': 5000}], 'metrics': [{'id': 'event297'}], 'dateFrom': '2017-01-01', 'dateTo': '2017-12-31', 'sortBy': 'eventXXX', 'dateGranularity': 'month'}}

          Having dug into the python libraries code I found that there is no setting of this value at all. This leads me to the believe, that the API has a default value set for top if it is not set in the report definition.

          Show more replies
          Terms & ConditionsAccessibility statement

          Loading footer...