Import your existing tracking plan

4 minute read

Import your existing tracking plan into Avo to get started quickly. The Importer supports multiple data formats and allows you to review and choose which events and properties you'd like to import.

Screenshot of the Avo Importer

Importing from Amplitude

  1. Export your Tracking Plan from Amplitude. Open up Govern (at the bottom of the left sidebar) and then click the download arrow:
Screenshot of Amplitude Govern
  1. In the popup, select "Schema of all events and their properties" and click download:
Screenshot of the download modal on Amplitude Govern
  1. Finally open the Importer from your Avo workspace and drag the downloaded .csv file to the drop zone or click it and select the file:
Screenshot of the Avo Importer selecting files
  1. Review your events and finish the import 🎉

Importing from Mixpanel

  1. Open up Mixpanel Lexicon (in the top right corner of your Mixpanel workspace click Data Management > Lexicon) and then click the export button:
Screenshot of Mixpanel Lexicon
  1. In the popup, select "Events & Properties" and Send CSV:
Screenshot of the download modal on Amplitude Govern
  1. Within few minutes you should receive an email from Mixpanel with a CSV export. Open the Importer from your Avo workspace and drag the downloaded .csv file to the drop zone or click it and select the file:
Screenshot of the Avo Importer selecting files
  1. Review your events and finish the import 🎉

Importing from a Google Sheet

Supported Formats

Following are the spreadsheet formats the Avo Importer currently supports.

We know that tracking plan spreadsheets come in all shapes and sizes. If you don't see your format below you can try converting your existing spreadsheet to one of these formats, by renaming columns etc, or you can reach out to us and we'll get the importing done for you.

Few things to note:

  • The order of the columns in your sheet does not matter
  • There must be a header row in your sheet with the exact column names as described for one of the format below
  • Any additional columns are ignored

You can learn more about common Tracking Plan spreadsheet formats on our blog.

Avo's Ultimate Tracking Plan Template

Screenshot of the Avo ultimate tracking plan spreadsheet template

View example sheet

Required columns
Column NameDescriptionExample value
Event NameThe name of your eventApp Opened
Event DescriptionThe description of your eventSent when the user opens the app
Event CategoryThe category your event belongs to, if anyApp Lifecycle
PlatformsThe name of the platforms this event should be sent fromiOS, Android, Web
Event Property NameThe name of a property that should be sent with your eventDevice Type
Property DescriptionThe description of the propertyThe type of client user is currently using
Property Value TypeThe type of the propertystring
Is Property Required?True if the property should always be sent with your eventtrue
Is Property Array?True if property should be array of valuesfalse
Property Enumeration optionsFinite list of all values allowed for the property, if applicableiOS, Android, Web, Desktop, Fire

Amplitude Taxonomy Template

Screenshot of the Amplitude taxonomy spreadsheet template

View example sheet

Required columns
Column NameDescriptionExample value
Event NameThe name of your eventApp Opened
Trigger + Event DescriptionThe description of your event and when it should be sentSent when the user opens the app
Event CategoryThe category your event belongs to, if anyApp Lifecycle
PlatformThe name of the platforms this event should be sent fromiOS, Android, Web
Property NameThe name of a property that should be sent with your eventDevice Type
Property DescriptionThe description of the propertyThe type of client user is currently using
Property TypeControl whether the event should be sent as Event property or User propertyEvent
Sample ValuesList of all values allowed for the property, if applicableiOS, Android, Web, Desktop, Fire

Mixpanel Tracking Plan Template

Screenshot of the Mixpanel tracking plan spreadsheet template

View example sheet

Required columns
Column NameDescriptionExample value
Event NameThe name of your eventApp Opened
Event DefinitionThe definition of your event and when it should be sentSent when the user opens the app
PlatformThe name of the platforms this event should be sent fromiOS, Android, Web
Property NameThe name of a property that should be sent with your eventDevice Type
Property DefinitionThe description of the propertyThe client type
Data TypeThe type of the propertystring
Sample ValuesList of all values allowed for the property, if applicableiOS, Android, Web, Desktop, Fire

How to import from a Google Sheet

  1. First open the sheet containing your Events and Event Properties. Then click File > Download > Comma-separated values (.csv)

    Screenshot of the Download CSV button in Google Sheets
  2. Open the Importer from your Avo workspace and drag the downloaded .csv file to the drop zone or click it and select the file:

Screenshot of the Avo Importer selecting files
  1. Review your events and finish the import 🎉

What's next?

Now you have a tracking plan in Avo and it's time to learn how to manage it.