Connector Improvement: TikTok: Creative / File History (Video is priority)

Hello,

There is a lot of valuable data in the /file/video/ad/search endpoints which would be great to be able to incorporate into our reporting. Here are the docs: https://ads.tiktok.com/gateway/docs/index?identify_key=2b9b4278e47b275f36e7c39a4af4ba067d088e031d5f5fe45d381559ac89ba48&language=ENGLISH&doc_id=1709477013957634

Similar to other channels like Facebook, maintaining history of this data would be very useful. We need the video `file_names` for our reporting, and currently we need to hit this endpoint separately to get the data. Ideally, this could all come from Fivetran.

The table I envision is a row for each video_id with a new row whenever modify_time is changed.

Here's an example response from a sandbox account:

"data": {

        "list": [

            {

                "duration": 16.105,

                "video_cover_url": "http://p16-sign-sg.tiktokcdn.com/",

                "format": "mp4",

                "signature": "3494e8d",

                "width": 478,

                "preview_url_expire_time": "2023-05-31 08:05:47",

                "video_id": "v10033",

                "displayable": true,

                "create_time": "2023-05-31T00:48:41Z",

                "size": 2250608,

                "height": 852,

                "allow_download": true,

                "modify_time": "2023-05-31T00:48:41Z",

                "file_name": "cr_video_test1",

                "preview_url": "http://v16m-default.akamaized.net/1",

                "allowed_placements": [

                    "PLACEMENT_TOPBUZZ",

                    "PLACEMENT_TIKTOK",

                    "PLACEMENT_HELO",

                    "PLACEMENT_PANGLE",

                    "PLACEMENT_GLOBAL_APP_BUNDLE"

                ],

                "bit_rate": 1117967,

                "material_id": "7239142"

            }

        ],

        "page_info": {

            "page": 1,

            "total_page": 1,

            "page_size": 20,

            "total_number": 1

        }

    }

Thank you!

Community

Connector Improvement: TikTok: Creative / File History (Video is priority)

Comments