Connector Improvement: Linkedin Ads - Add text_ad field as part of ad_type=SPONSORED_STATUS_UPDATE
AnsweredSimilar to this feature request, we would like the addition of a text or text_ad field for particular ad_type=SPONSORED_STATUS_UPDATE. This field can be retrieved by using the Linkedin Share API endpoint.
Sample endpoint:
https://api.linkedin.com/v2/shares?ids%5B8%5D=6893944647186464768
Sample response:
{"results":{"6915327217245810688":{"owner":"urn:li:organizationBrand:123","activity":"urn:li:activity:123","edited":false,"subject":"L11482A_H_BED_205_D_BED_197_ImageE8SQ_ST","created":{"actor":"urn:li:person:123","time":1648742489250},"clientApp":"urn:li:developerApplication:123","id":"691532721981236891263","lastModified":{"actor":"urn:li:csUser:0","time":1648742490359},"text":{"text":"Learn to empower, transform, and lead your organization. Join a community of changemakers. Enroll in Baylor’s EdD Online program. Master’s req’d."},"content":{"title":"Develop Skills to Drive Change","contentEntities":[{"entityLocation":"https://requestinfo.onlinegrad.baylor.edu/edd.html?lsrc=linkedinsp&l=L11482A_NF_BED_PST_Tier12_A_A_-_TRT_OpenEd_-_-_oCPM&c=H_BED_205_D_BED_197_ImageE8SQ_ST&utm_source=linkedinsp&utm_campaign=L11482A_NF_BED_PST_Tier12_A_A_-_TRT_OpenEd_-_-_oCPM&utm_content=H_BED_205_D_BED_197_ImageE8SQ_ST&utm_medium=banner","thumbnails":[{"imageSpecificContent":{},"resolvedUrl":"https://drive.google.com/uc?id=1cmAZI89U3WJ_5wBqDV8QtWKtBcJKG3jh"}],"title":"Develop Skills to Drive Change","entity":"urn:li:article:1234"}],"shareMediaCategory":"ARTICLE"}}},"statuses":{},"errors":{"urn:li:share:6915327217245810688":{"status":404}}}
-
Official comment
Hi Kevin Offemaria, Drew from the product team here!
Taking a look at our ERD, in our CREATIVE_HISTORY table we have the text_ad_text and text_ad_title fields. Are these sufficient for you?
Also, just to make sure, you are receiving ads with ad_type=SPONSORED_STATUS_UPDATE in your warehouse?
-
Hi Drew - Thanks for the response. Yes I can confirm we receive data in our warehouse withad_type=SPONSORED_STATUS_UPDATE via a legacy custom application.
Via FiveTran, unfortunately we are not receiving this in any of the fields on the CREATIVE_HISTORY or any other table currently on the ERD. I've confirmed this by examining each potential field/table, and a FiveTran support rep has confirmed this as well (request# 84086). The workaround recommendation is a custom function connector.
Please sign in to leave a comment.
Comments
2 comments