Family horror film Goosebumps scared audiences up a treat at the North American box office at the weekend.