Skip to main content
Documentation
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: [Twitter Ads] Add join column on Media Library table

Answered
Kevin Offemaria User

Hello - Please add a join column on the Media_Library table to be able to join with other main tables on the Twitter Ads ERD, particularly on the ad level. Our use case is using the line_item_history for dimension data, but it's missing the ad_name or creative_name. 

Excerpt from the Twitter Ads ERD, Media_library is unable to join with anything else.

 

Thanks,

Kevin

 

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Drew Fivetranner

    Hi Kevin Offemaria, have you tried joining "tweet_media.media_id" -> "media_library.media_id"?

    That connection should provide the linkage you are looking for.

  • Kevin Offemaria User

    Hey Drew, just saw this. Yes I'm able to join media_library to tweet_media table using media_id. Thanks for pointing that out. It's a bit confusing as there was no arrow or indication on the Twitter ERD that shows its connection.