[Feature] Support for Dynamic URL/UTM Parameters

[fivetran-joemarkiewicz]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

At the moment, the Facebook Ads dbt package requires url/utm parameters to be included in the page_link or template_page_link fields (see code here for reference). However, there are instances where url/utm parameters are not set within these fields and are instead dynamically set within Meta. Meta has documented these as URL dynamic parameters.

We have provided support for similar dynamic ads in other ad packages (eg. Google Ads auto tagging). Therefore, it is not far off that we should provide similar support for Facebook Ads.

Describe alternatives you've considered

At the moment there are not real alternatives. Ads which leverage the url dynamic parameters are not being captured by the models in this package.

Are you interested in contributing this feature?

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

Anything else?

For those that come across this feature request, please upvote this feature if you would like our team at Fivetran to prioritize support for this functionality. This will help us with planning enhancements and understand what our users need support for most. Thanks!