Playing more with Realflow. Finally getting somewhere. The biggest challenge is creating the liquid you want. Just give yourself a day and go bonkers with all the settings. Lit and textured in Cinema 4d Tweaked in AE.
The 3d render caused a bit of problem. I don't often do GI renders and so had forgotten about the flickering you can get in animations. there is still a little in the shadows on this but is quite a turbulent mesh so this will affect the shadows. My initial render took about an hour but when i took it into AE noticed the BG flickering quite lot. Use IR+QMC(full animation) in cinema 4D. Does take longer to render but worth it. The 12 pre-passes took about 2hours then it actually renders out relatively quickly.