Some people in my alliance have had luck with this ratio:

93k archers
2k transporters
2.5k swords
2.5k workers
120+ Attk hero, lvl 10s in all techs that dont require Scripts

What was the reason you didnt bring any melee types?