[Feature] Support additional click uri ad types

### Is there an existing feature request for this?

- [X] I have searched the existing issues

### Describe the Feature

We have seen a number of similar issues that highlight the need for this same request (such as Issue fivetran/dbt_linkedin#53) where it's clear that the LinkedIn Ads dbt package does not support all click uri ad types in the `click_uri` field.

When addressing Issue dbt_linkedin issue [#35](https://github.com/fivetran/dbt_linkedin/issues/35) our team was able to confirm the combination of `click_uri` and `click_uri_type` fields in the `stg_linkedin_ads__creative_history` model provide support over the following click uri ad types:
- Text Ad
- Spotlight Ad

While we do support these two ad types, there are a number of other ad types which are not currently supported. The known ad types which are not supported at the moment include:
- Follower Ad
- Jobs Ad
- Message Ad
- Conversation Ad
- Single Image
- Carousel
- Event Ad
- Single Job Ad
- Document Ad
- Video

These are a few of the known ad types we do not support at the moment. Please comment in this FR if you are aware of other ad types which are not supported and we can explore how to add support.

### How would you implement this feature?

LinkedIn Ads has a complex relationship between creatives and the corresponding ad urls. This is fairly straightforward for Text and Spotlight Ads, but not so much for the above mentioned ad types which are not supported by the dbt package at the moment. In order to support these ad types we will need to most likely bring in additional staging models and perform additional joins on the end models to bring in all the relevant ad types.

Additionally, some of these ad types may only be available in the LinkedIn Company Pages connector data which adds some additional complexity to supporting all ad types.

### Describe alternatives you've considered

Only supporting Spotlight and Text Ad or requiring using to perform custom joins post transformation which is not ideal.

### Are you interested in contributing this feature?

- [ ] Yes.
- [ ] Yes, but I will need assistance.
- [ ] No.

### Anything else?

Please react to this message or comment in the thread if you would be interested in seeing more ad types supported by the dbt_linkedin and downstream packages. Additionally, if there are some ad types we have missed in this feature request please let us know in the comments. Thanks!

Start with the stg_linkedin_ads__creative_history model and the click_uri and click_uri_type fields described in the issue, then review the related dbt_linkedin issue #35. Determine which unsupported LinkedIn ad types and connector data are available and which additional staging models and joins are required. Done means the relevant ad types expose their click URLs in the downstream package models.

Written by the indexing model from the issue text.