ak--47

#!/bin/bash
# move data from Amplitude to Mixpanel
# by AK (ak@mixpanel.com)

# 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

ak--47

const express = require('express');
const app = express();
const Mixpanel = require('mixpanel')
const mixpanel = mixpanel.init('your token')


var BLOCKED_UA_STRS = [
    'googlebot',
    'googleweblight',

ak--47

-- MIXPANEL → AZURE → SNOWFLAKE pipeline
-- the second half...
-- by ak@mixpanel.com
-- docs: https://docs.snowflake.com/en/user-guide/data-load-azure-create-stage

-- create storage integration
CREATE OR REPLACE STORAGE INTEGRATION azure_intergration
TYPE = EXTERNAL_STAGE
STORAGE_PROVIDER = AZURE
ENABLED = TRUE

ak--47

#!/bin/bash

# Set the necessary variables
MIXPANEL_API_URL="https://data.mixpanel.com/api/2.0/export"
AZURE_ACCOUNT_NAME="mystorageaccount"
AZURE_CONTAINER_NAME="mycontainer"
AUTHORIZATION_HEADER="Authorization: Basic {{ base64(mixpanel_secret) }}"

# Function to download data from Mixpanel and upload to Azure
download_and_upload() {

ak--47

# fill a mixpanel project with fake data

# set env vars (customize these)
export MP_SECRET=your-project-secret 

# generate 100k events and send them
npx --yes carvis --mixpanel --rows 100000 | xargs npx --yes mixpanel-import --secret $MP_SECRET

ak--47

# reload all EVENTS from one project to another

# environment variables
# CUSTOMIZE THESE 👇
export START=2023-01-01
export END=2023-05-31
export SOURCE_SECRET=my-source-project-secret
export TARGET_SECRET=my-target-project-secret

# export → import 

ak--47

  #!/usr/bin/env node

/*

THE WONDERFUL EVENT/PROP DROPDOWN RESURFACER
--------------------------------------------

purpose:
    mixpanel's dropdowns for events and props are great; but they only cache data that is from the last 30 days
    this sucks if you are importing data that's older than 30 days

ak--47

GOAL: leverage existing GTM data in Mixpanel

essentially: bind mixpanel.track() calls to existing Universal Analytics + GA4 implementations without adding new triggers for each event

note: this is experimental... every product's GTM implementation is different... please test this in a sandbox before using in production

Step 1: Install the Mixpanel GTM Template to your GTM container

this module binds all of mixpanel's javascript SDK methods to an object that is native to the GTM container.

ak--47

BigQuery → Mixpanel

rETL from scratch with

• BigQuery
• Cloud Functions
• Pub/Sub
• Cloud Scheduler
• DWH Mixpanel

you will need the following roles in GCP:

ak--47

$merge in 5 mins

Assume 4 unique events (1 → 4) , each with a different distinct_id (A → D)

[{
     "event": 1,
     "properties": {"distinct_id": "A"} 
 },
 {
     "event": 2,