No, that's for consumption by population of the sanctioning country. The people in the know know very well that that never works.
The point is for every other country in the world to see how much it hurts if you don't follow the wishes of USA. Classic mafia strategy.
The exception were the sanctions on Russia at the start of the Ukraine war. Those were unprecedented (including the freezing of the national bank assets and blocking of Swift) and it looks like the western powers really believed that those sanctions will cause economic collapse and regime change in Russia.