[Feature] Support additional click uri ad types

[fivetran-joemarkiewicz]

Is there an existing feature request for this?

• 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 #49) 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 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!