It's a tactic called "farming" and it's really the only way that you're going to progress at a half-decent pace at this stage of the game. It's how I play, and my only goal when attacking is to steal ALL of your resources. I don't care about the trophies, because right now I just need to upgrade.
What you need to realize is that if you are more of a defensive player, and constantly sitting on 500k resources and just waiting until you have enough to upgrade, you will constantly get raided and you will be plagued by frustration. To quickly get that gold or food, you need to go on the offensive.
Quick tip/strategy for maximum profit:
1) Stop using expensive and slow to build troops like Knights and Ballistas etc. when attacking.
2) Upgrade your Archers (Or whatever you have) and your Pikemen fully, and only build those. It's a super cheap army to build, and it only takes me 19 minutes to build an entire army (Medieval, 80 troop space). I personally prefer to make 40 Pikemen and 40 Archers, but you can play around with that.
3) Search until you have found someone worth attacking (I only attack people with a MINIMUM of 100k of each resource, otherwise I just keep pressing "next".
4) Take a minute to find out WHERE their resources are held. Do their storage's look full or empty? Empty storage's but high resources means that their farms and caravans are BURSTING, and you have found your perfect target.
5) Wait until there are a decent amount of caravans in roughly the same place. This will make it easier to get the most amount of gold (Closer to farms would be best, but not everyone is that easy)
6) Send out a wave of at least 20 Pikemen (spread out, not all in one spot, to avoid catapult damage) near where your target farms or caravans are. Very quickly send another wave of archers. These will take care of enemy troops, and provide cover-fire.
7) If their resources are roughly split on each half of their base, use your remaining troops to target the other side, OR target more defensive buildings. If not, you can send them right behind the first wave.
8) $$$$$
***Remember, Pikemen do a tonne of damage to buildings, but not a lot to enemy troops. Archers are the exact opposite, so they complement each other greatly***
Bonus tips: If you can quickly take out their stables, DO IT. Mass amounts of horses are a pain in my butt. Actually, if you can quickly take out any defenses, do that too. Remember, if you destroy all defensive buildings, you will get to keep your troops. If you have troops left over, that means you can attack sooner next time, which in turn means more hourly profit. If you only get to play here and there throughout the day, this will allow you to quickly make two armies in a half hour lunch break versus only being able to attack once.
I can very easily make 500k-700k in an hour, and that's only Medieval at around 650 trophies. No need to wait overnight and let someone like me pillage ya!