Comment 5 for bug 813940

It appears that /etc/X11/Xsession.d/65compiz_profile-on-session has no effect because it sets the profile to "ubuntu" but the actual profile is called "unity" in CCSM and in GConf.

There's /usr/share/gconf/defaults/10_compiz-gnome file which sets the list of enabled profiles. It doesn't set the default profile though, I wonder if it can be done in GConf at all. Editing that file is not needed, we can set all we need in session, i.e. /usr/share/gconf/pantheon/default/20_pantheon-gconf-default.

For profiles themselves I've found only /apps/compizconfig-1/profiles/ folder in GConf.