Skip to main content

Community

Connector Improvement: Outbrain - Promoted content

Answered

Please sign in to leave a comment.

Comments

4 comments

  • Official comment

    Hi Abhisheka,

    Thanks for submitting this request. 

    That endpoint seems to correspond to this section of the API docs: https://amplifyv01.docs.apiary.io/#reference/performance-reporting/publishers/retrieve-promoted-content-links-performance-statistics-for-a-marketer. We already sync data from this endpoint to the PROMOTED_LINK_REPORT table in our connector. The nuance is that this endpoint returns metadata and report (metric) data in the response. We store the metadata in the PROMOTED_LINK_HISTORY table. The image_metadata field is an object that we break out into a separate table, IMAGE_METADATA. 

    This should give you the breakdown you need (PROMOTED_LINK_REPORT is broken down by promoted_link_id). And the details you need should exist in PROMOTED_LINK_HISTORY. You can use PROMOTED_LINK_REPORT.promoted_link_id = PROMOTED_LINK_HISTORY.id to join.

    Are there specific fields you need from those tables that we're missing, or did I misunderstand the request?

    Thanks,
    Luke

    These are the fields I found in the API docs that are missing from these three tables. I added a task to our backlog to include them. 

    I can't provide a timeline for delivery. It will be based on the demand for these fields relative to the other feature improvements in our backlog. Any additional upvotes on this feature request from other Fivetran customers who need this will help increase the priority.

    Fields we plan to add from this endpoint:

    • metrics.cpm
    • metrics.viewConversions
    • metrics.totalRoas
    • metrics.roas
    • metrics.videoReachedFirstQ
    • metrics.videoReachedSecondQ
    • metrics.videoReachedThirdQ
    • metrics.videoReachedCompletion
    • metrics.videoViewDuration
    • metrics.videoAvgViewDuration
    • metrics.videoPlays
    • metrics.clicksOnVideo
    • metrics.videoActiveCompletions
    • metrics.videoActiveCompletionsPercentage
    • metadata.creativeFormat
    • metadata.title
    • metadata.qualityRating
    • metadata.delivery
    • metadata.onAirStatus
    • metadata.createdTime
    • metadata.imageMetadata.cropSettings

    Hi Lucas,

    Thank you for your reply!

    We are looking for a field called metadata which contains adname information as highlighted below.

    It's available as part of the API but fivetran table doesnt contain this info:

    Thanks,

    Abhishek

    Hi Lucas,

    below data which I have posted belong to 

    https://api.outbrain.com/amplify/v0.1/campaigns/{camp_id}/promotedLinks which we are already syncing as part of promotedLinks_history table but only metadata field which contains adname details is missing in the table which we are requesting you to include.
     
    Thanks,
    Abhishek