jq-example.sh

jq -r '
    [
        (.userId // ""),
        (.userAttributes.email // ""),
        (.userAttributes.install_dt // ""),
        (.userAttributes.platform // ""),
        (.userAttributes.added_date // ""),
        (.deviceId // ""),
        (.deviceModel // ""),
        (.systemVersion // ""),
        (.systemName // ""),
        (.priorTimeSpentInApp // ""),
        (.duration // ""),
        (.appVersion // ""),
        (.locale // ""),
        (.timezone // ""),
        (.country // ""),
        (.city // ""),
        (.region // ""),
        (.sessionId // ""),
        (.sdkVersion // ""),
        (.client // ""),
        (.userBucket // ""),
        (
            [
                (.states[]? | .events[]? // []) | (
                    [
                        ( .name | split(" ") | .[0] ),
                        ( .name | split(" ") | .[1]? ),
                        ((.parameters.url // "")
                            | (match("campaign(%26|&)id(%3D|=)(.[^%]+)(%26|$)", .)  // {{}})
                            | (.captures[2].string // "")),
                        (.parameters.url // "")
                    ]
                )
            ]
        ),
        "{game_id}",
        "{ds}"
    ] as $in
    | $in[21][] as $h
    | $in | del(.[21]) as $in2
    | $h + $in2
    | @csv
' export-* > {output_filename}