TikTok Ads

Data Replication

Default Pipeline Frequency	Minimum Pipeline Frequency	Maximum Pipeline Frequency	Custom Frequency Range (Hrs)
3 Hrs	1 Hr	24 Hrs	1-48

Note: The custom frequency must be set in hours, as an integer value. For example, 1, 2, 3 but not 1.5 or 1.75.

• Historical Data: In the first run of the Pipeline, Hevo ingests historical data for all the objects on the basis of the historical sync duration selected at the time of creating the Pipeline and loads it to the Destination. Default duration: 1 Year.

• Incremental Data: Once the historical load is complete, all new and updated records for the reports are synchronized with your Destination as per the ingestion frequency. For core entities (objects), Hevo performs a full load to capture any data changes.

• Refresher Data: Hevo performs a full load for the core entities (objects) every time your Pipeline runs, which means that the entire data in the object is refreshed/replicated on each ingestion. In case of reports, Hevo refreshes the data once every 24 hours. Data refresh is required to capture any attribution data and updates made to the data since the last incremental load.

Handling of updates

The status of all fields that are updated in the Destination during replication is changed to STATUS_UPDATE.

Handling of deletes

All fields deleted in the Source are ingested with the status, STATUS_DELETE. When the Events are loaded to the Destination tables, the status of the respective fields is accordingly updated.

Note: For both deletes and updates, the MODIFY_TIME field is updated to the time of the most recent change.

---

Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination database:

---

Data Model

You can replicate object and report data from your TikTok Ads account.

Objects

Objects are the core entities of TikTok Ads. The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

Object	Description
Advertisers	Contains information about the advertiser account.
Campaign	Contains information about campaigns.
Ad Group	Contains information about ad groups existing in the campaigns.
Ad	Contains information about ads running as part of each ad group.

Reports

Reports are objects that contain data related to the metrics and statistics of the core entities. These can be generated at two levels of time granularity: Daily and Hourly. Reports are generated for the following objects:

• Ads

• Ad Groups

• Campaigns

You can also generate reports based on the parameters, Country, Language, Age Gender, and Platform, as described in the table below.

REPORT NAME	DESCRIPTION
Ad_Age_Gender_Report	The report on the Ad object, grouped by Age Gender.
Ad_Country_Report	The report on the Ad object, grouped by Country.
Ad_Daily_Report	The report on the Ad object, grouped daily.
Ad_Hourly_Report	The report on the Ad object, grouped hourly.
Ad_Language_Report	The report on the Ad object, grouped by Language.
Ad_Platform_Report.	The report on the Ad object, grouped by Platform.
Ad_Reservation_Daily_Report	The report on the Ad object, grouped daily. Captures reserved ads information.
Ad_Reservation_Hourly_Report	The report on the Ad object, grouped hourly. Captures reserved ads information.
AdGroup_Daily_Report	The report on the Ad Group object, grouped daily.
AdGroup_Hourly_Report	The report on the Ad Group object, grouped hourly.
AdGroup_Reservation_Daily_Report	The report on the Ad Group object, grouped daily. Captures reserved ad groups information.
AdGroup_Reservation_Hourly_Report	The report on the Ad Group object, grouped hourly Captures reserved ad groups information.
Campaign_Age_Gender_Report	The report on the Campaign object, grouped by Age Gender.
Campaign_Country_Report	The report on the Campaign object, grouped by Country.
Campaign_Daily_Report	The report on the Campaign object, grouped daily.
Campaign_Hourly_Report	The report on the Campaign object, grouped hourly.
Campaign_Language_Report	The report on the Campaign object, grouped by Language.
Campaign_Platform_Report	The report on the Campaign object, grouped by Platform.
Campaign_Reservation_Daily_Report	The report on the Campaign object, grouped daily.Captures reserved ads information.
Campaign_Reservation_Hourly_Report	The report on the Campaign object, grouped hourly. Captures reserved ads information.

Refer to the Schema and Primary Keys section for more details.

Note: Reservation Ads reporting is currently in Beta. Read Reservation ads reports for more information.

---