[Feature] explore optimizing `get_url_tag_query` macro for redshift

[fivetran-jamie]

Is there an existing feature request for this?

• [X] I have searched the existing issues

Describe the Feature

In this macro, we have warehouse-specific logic for parsing out jsons. For redshift, we cross join with a generated number-series, but there are now more performant methods that we've used in Hubspot and Iterable

let's update facebook ads as well!

Describe alternatives you've considered

leave it as is

Are you interested in contributing this feature?

• [X] Yes.
• [ ] Yes, but I will need assistance and will schedule time during your office hours for guidance.
• [ ] No.

Anything else?

No response