Amplitude → Mixpanel

amp-to-mp.sh

#!/bin/bash
# move data from Amplitude to Mixpanel
# by AK ([email protected])

# set env vars (customize these!)
export START_DATE=2023-04-20
export END_DATE=2023-04-20
export AMPLITUDE_KEY=my_key
export AMPLITUDE_SECRET=my_secret
export MIXPANEL_TOKEN=my_key

# export data from Amplitude
echo "Exporting data from Amplitude...\n\n"
npx amp-ext --key $AMPLITUDE_KEY --secret $AMPLITUDE_SECRET --start $START_DATE --end $END_DATE --unit day

# import EVENT data into Mixpanel
echo "Importing EVENT to Mixpanel...\n\n"
npx mixpanel-import ./exports/ --token $MIXPANEL_TOKEN --vendor amplitude 

# import USER data into Mixpanel
echo "Importing USER to Mixpanel...\n\n"
npx mixpanel-import ./exports/ --token $MIXPANEL_TOKEN --vendor amplitude --type user --dedupe --fix

# clean up
echo "deleting local Amplitude dat..\n\n"
rm -rf ./exports
echo "all done!"

usage:

sh amp-to-mp.sh

should look like this: