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

Community

Connector Improvement: Support history mode of the custom_conversion_history table for Facebook Ads data.

Answered
Suman Agarwal User

Hi,

I am preparing a conversion data report for the business team and observed that the data in the Custom_Conversion_History table is being overwritten during each sync rather than appended on a daily basis. I had opened a support ticket earlier for this issue - #303528.

As suggested by Christian Souza, I would like to request feature enhancement to support history mode of the Custom_Conversion_History table. 

Details:

Connectors: Lionsgate_Meta_3, NFL_Meta

Table: Custom_Conversion_History

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Shivaprasad Mogili Fivetranner

    Hi Suman,

    Thank you for reporting this issue. This behavior with the Custom_Conversion_History table actually might be a bug that requires investigation. I have flagged this to our team to review and confirm if this is a bug.

    Thanks,
    Shiva

  • Christian Fivetranner

    Hi Team, 

    To add, custom conversions can be edited after creation (i.e name) and we only update the record row in the table. We do not append the change of the conversion. 

    Best way to tackle this is to add a hash pk of the columns (minus timestamp column) so if a change occurs then we will append the record. 

    Thanks!