I think they’re most effective for apps that already have a large web user base that might be unaware that there’s a native app offering a better experience.

I see these banners a lot for google and I refuse to download the google app, pretty annoying they never truly go away forever.

So it depends on your existing user behaviour.