Level 2

Solved

Numeric success event limits in Adobe Analytics

7 replies
163 views
Translate All

What is the maximum value(integer) that can be passed in a numeric success event per hit? Is there a cap on the accumulated sum of a numeric event over time?

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

S

santoshkrAccepted solution

Level 3

Hi @ManuS_

Great question! There are actually two different limits to keep in mind: the value per hit and the total accumulated value in reports.

1. Per-Hit Limit (The Input)
The maximum value you can pass in a single numeric success event (e.g., event1=12345) is 2,147,483,647.

Why: Adobe Analytics uses a 32-bit signed integer for the individual event value on a single hit.
Decimals: If you use a Currency event instead of a Numeric event, you can include up to 2 decimal places, but the integer limit remains the same.

2. Accumulated Limit (The Reporting)
In your reports (Workspace/Reports & Analytics), the maximum accumulated sum for a metric is much higher: approx. 9 quintillion (9,223,372,036,854,775,807).

Why: Adobe uses a 64-bit float/integer for the total aggregated sums in the reporting database. You are very unlikely to ever hit this cap!

Important Caveats:

Scientific Notation: If you pass a number larger than 2.1 billion in a single hit, the value will typically be capped or rejected, or it might show up as a negative number due to 'integer overflow.'
Data Warehouse: If you export data via Data Warehouse, the limits are similarly high (64-bit), so your extracts will handle large sums correctly.

Thanks,

Santosh Kumar

Santosh Kumar | AEP & CJA Developer

MandyGeorge

Adobe Champion, Community Advisor, UG Leader

As far as I know, there isn’t a technical limit to how the data can be collected in terms of events. But in terms of how the data is displayed, Adobe does have some limits. I’ve experimented with calculated metrics that result in very large numbers, and somewhere around 1e+21 it starts converting to scientific notation (1e+21 is around one sextillion). Eventually numbers bigger than that just start to say “infinity” (although I’m not sure the threshold between scientific notation and infinity).

That said, I’m not sure how these very large numbers translate into the output from data warehouse, data feeds, or report builder.

Translate

Jennifer_Dungan

Adobe Champion and Community Advisor

Hi @ManuS_

Are you referring to the Event Serialization for success events? The value that is used to determine a “unique success”, and if the serialization is used again, subsequent success events will be ignored?

If so, the Event Serialization only supports 20 bytes of data, if you send more than 20 bytes, the value will be truncated, and only the first 20 will be used.

https://experienceleague.adobe.com/en/docs/analytics/implementation/vars/page-vars/events/event-serialization

I have advocated that 20 is not enough, given many systems are now using 32 or 36 bit guids…. but I imagine the infrastructure to support a change would be pretty large…

Translate

M

ManuS_Author

Level 2

Thank you for your response! I was specifically referring to numeric events and their limits. Since the values of a numeric event are aggregated based on hits, I just wanted to clarify whether there is any restriction on the number of digits that can be stored in a numeric event.

Translate

Jennifer_Dungan

Adobe Champion and Community Advisor

OK, I assume there is some logical max… but probably nothing you would realistically hit?

Can I ask what you are trying to do in your implementation that is causing this concern? I mean, if you look at any custom counter event, you know that these will show counts in the millions….

Numeric Events are really just a a way to increment an event by more than just “1”… so things like “I have 10 ads on the page” so you would pass “10”…. or ”there are 25 search results on the page” so you will pass “25”.

Translate

S

santoshkrAccepted solution

Level 3

Hi @ManuS_

Great question! There are actually two different limits to keep in mind: the value per hit and the total accumulated value in reports.

1. Per-Hit Limit (The Input)
The maximum value you can pass in a single numeric success event (e.g., event1=12345) is 2,147,483,647.

Why: Adobe Analytics uses a 32-bit signed integer for the individual event value on a single hit.
Decimals: If you use a Currency event instead of a Numeric event, you can include up to 2 decimal places, but the integer limit remains the same.

2. Accumulated Limit (The Reporting)
In your reports (Workspace/Reports & Analytics), the maximum accumulated sum for a metric is much higher: approx. 9 quintillion (9,223,372,036,854,775,807).

Why: Adobe uses a 64-bit float/integer for the total aggregated sums in the reporting database. You are very unlikely to ever hit this cap!

Important Caveats:

Scientific Notation: If you pass a number larger than 2.1 billion in a single hit, the value will typically be capped or rejected, or it might show up as a negative number due to 'integer overflow.'
Data Warehouse: If you export data via Data Warehouse, the limits are similarly high (64-bit), so your extracts will handle large sums correctly.

Thanks,

Santosh Kumar

Translate

Santosh Kumar | AEP & CJA Developer

M

ManuS_Author

Level 2

@santoshkr Thank you!

Translate

S

santoshkr

Level 3

You're very welcome, @ManuS_ ! Happy to help.

If that answered your question, could you please mark the reply as the 'Accepted Solution'? It helps other community members with the same question find the answer quickly and keeps the forum organized.

Thanks,

Santosh Kumar

Translate

Santosh Kumar | AEP & CJA Developer

Sign up

Login with SSO

Login to the community

Login with SSO