Most often sits at the very bottom of the page, right above the footer — one last ask after everyone has already scrolled through. Keep the headline short and the CTA count to one (two at most).
Swapping in a contrasting background (an accent color, or something dark) against the surrounding sections gives the page a visual full stop: this is where it ends. The button should have strong contrast against that background — the loudest color on the page is fair game here, since it's the last stop.
Two CTAs of similar visual weight makes visitors hesitate and often leave without clicking either (choice overload). Repeating the same CTA multiple times through the page — hero, mid-page, and here — is fine and often better: it lets people act whenever they're ready.
When to use
Anywhere a visitor might exit, but especially the very bottom. Even if they've already seen the same CTA higher up, repeating it once more here still helps.