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:
Can someone check these numbers on short notice?
Thank you very much in advance.
Best regards,
Stefan Leever
TanmayMathur
Employee
TanmayMathur
Employee
31-05-2017
Hi Stefan,
Welcome to the Analytics Community.
You can get more detailed comparisons here - https://marketing.adobe.com/resources/help/en_US/reference/analytics-product-comparison.html
hyderziaee
Employee
hyderziaee
Employee
08-01-2018
That's great troubleshooting!
I believed that if the top was not specified, it would give them all. However, looks like it defaults to 10 as you have mentioned, unless otherwise specified.
-Hyder
alim92960278
alim92960278
07-08-2017
Thanks for the quick reply!
ishans52004352
Employee
ishans52004352
Employee
07-08-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!
svedoe
svedoe
05-01-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.
hyderziaee
Employee
hyderziaee
Employee
04-01-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
04-01-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.
sujitb1706693
sujitb1706693
02-11-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?
alim92960278
alim92960278
07-08-2017
Hi can you please explain this:
How can this be changed? I've looked in the ReportSuite configuration but I don't see it.
Ali
TanmayMathur
Employee
TanmayMathur
Employee
01-06-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.
stefanleever
stefanleever
31-05-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