Question

Export user aliases

  • 12 January 2023
  • 2 replies
  • 34 views

Badge +1

We’d like to get purchase information about all the users we have in our database. For that, we need to join on the app_user_id. In some cases, it appears as an Alias on RevenueCat.

 

Is there a way to export those aliases, either in the ETL or in the csv exports?


2 replies

Userlevel 1
Badge +3

Hi @Eliot ,

I believe that ETL Exports would fit the bill: https://www.revenuecat.com/docs/etl-exports

The 2 relevant fields would be `rc_original_app_user_id` and `rc_last_seen_app_user_id_alias`, you can read more about these fields in the documentation I linked above.

Does this seem like it would work for your use case?

Badge +1

I would need all of the aliases of a user, not just the last_seen one. How can I access the full list?

Reply