Modify or delete historical data

Generally speaking, the Amplitude architecture is based on pre-aggregated sets by the hour, day, week and month for users and events. While this allows the platform to scale well, one tradeoff is immutable data.

This article covers some frequently asked questions about how to modify or delete historical data.

How do I modify events that have already been ingested by Amplitude?

It is not possible to modify events that have already been ingested. However, there is a potential workaround:

  1. Export all project data using the Export API
  2. Clean the data (i.e make the required changes to the data)
  3. Upload the cleaned data into a new project using the Batch API

I updated user properties using the Identify API. Why are there still 'none' values in my charts?

Using the Identify API only updates user property values for future events. Data that Amplitude has already ingested cannot be changed. The user will have to fire another event in order for Amplitude to apply the updated property value. More details on how user properties are updated can be found here

I accidentally sent an event for a user. How do I delete this specific event for this specific user?

You can't. Ingested data is immutable. However, you can try the following process for similar results:

  1. Delete or block the event:
    • This will prevent the event from coming into Amplitude for all users
    • The event will still appear in the users event stream, but will not be available for querying
  2. If that doesn't work, try the workaround described in the first FAQ above.

How do I backfill historical data into Amplitude?

Was this page helpful?

Thanks for your feedback!

July 12th, 2024

Need help? Contact Support

Visit Amplitude.com

Have a look at the Amplitude Blog

Learn more at Amplitude Academy

© 2024 Amplitude, Inc. All rights reserved. Amplitude is a registered trademark of Amplitude, Inc.