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!
Is there an existing feature request for this?
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_urifield.When addressing Issue dbt_linkedin issue #35 our team was able to confirm the combination of
click_uriandclick_uri_typefields in thestg_linkedin_ads__creative_historymodel provide support over the following click uri ad types: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:
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?
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!