What’s the differences between ticking and not ticking “Replace Lexicon entries” checkbox when importing lexicon schema through csv? Use some examples for detailed explanation.
Hi Sharon L., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
When importing a Lexicon schema into Mixpanel via CSV, the “Replace Lexicon entries” checkbox determines whether your import will overwrite the entire existing data dictionary or just update/add the specific entries present in your CSV.
If you tick “Replace Lexicon entries” (overwrite entire data dictionary):
- All existing Lexicon entries (events, event properties, user profile properties) will be deleted and replaced with only the entries in your imported CSV. - Any events or properties not included in your CSV will be removed from Lexicon. - This is useful if you want your Lexicon to exactly match the contents of your CSV, such as when you are doing a full refresh or migration.Example: Suppose your current Lexicon has events A, B, and C. Your CSV only contains events A and D. - After import with “Replace Lexicon entries” checked, your Lexicon will only have events A and D. Events B and C will be deleted.
If you do not tick “Replace Lexicon entries” (partial update):
- Only the entries in your CSV will be updated or added. - Existing entries in Lexicon that are not in your CSV will remain unchanged. - This is useful for incremental updates, such as adding new events or updating descriptions without affecting the rest of your data dictionary.Example: Suppose your current Lexicon has events A, B, and C. Your CSV only contains events A and D. - After import with “Replace Lexicon entries” unchecked, your Lexicon will have events A (updated), B, C (unchanged), and D (added).
Summary Table
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.