A per-tab list of every column SyncRange can export, with a short description of what each one contains. Use this page when picking columns in the export builder, or when you need to know exactly what a value represents in BigQuery or Google Sheets.
Each tab below notes whether it uses the export date range or always exports a full current snapshot when that applies.
For configuration steps see Configuring TikTok Ads exports.
One row per campaign (entity metadata). Use Insights tabs for performance over a date range.
| Column | Description |
|---|---|
| Campaign ID | Campaign ID from the source platform. |
| Campaign Name | Campaign Name. |
| Campaign Status | Campaign Status. |
| Objective Type | Objective Type. |
| Budget Mode | Budget Mode in the row currency unless noted otherwise. |
| Budget | Budget in the row currency unless noted otherwise. |
| Start Time | Start Time. |
| End Time | End Time. |
| Created Time | Created Time. |
| Updated Time | Updated Time. |
| ROAS Bid | ROAS Bid. |
| Deep Bid Type | Deep Bid Type. |
| Secondary Status | Secondary Status. |
| Operation Status | Operation Status. |
| Campaign Type | Campaign Type. |
| Objective | Objective. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
One row per ad (entity metadata and creative fields).
| Column | Description |
|---|---|
| Ad ID | Ad ID from the source platform. |
| Ad Name | Ad Name. |
| Ad Status | Ad Status. |
| Campaign ID | Campaign ID from the source platform. |
| Creative ID | Creative ID from the source platform. |
| Creative Type | Creative Type. |
| Created Time | Created Time. |
| Updated Time | Updated Time. |
| Ad Identity ID | Ad Identity ID from the source platform. |
| Ad Identity Type | Ad Identity Type. |
| Call to Action | Call to Action. |
| Landing Page URL | Landing Page URL. |
| Display Name | Display Name. |
| Profile Image URL | Profile Image URL. |
| Operation Status | Operation Status. |
| Secondary Status | Secondary Status. |
| Is Automated Ad | Boolean: Is Automated Ad. |
| Ad Format | Ad Format. |
| Ad Text | Ad Text. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
One row per campaign per time bucket. Date range: uses the selected export date range and time granularity.
| Column | Description |
|---|---|
| Campaign ID | Campaign ID from the source platform. |
| Campaign Name | Campaign Name. |
| Date | Date. |
| Date Start | Date Start. |
| Date Stop | Date Stop. |
| Impressions | Number of times the ad or listing was shown. |
| Clicks | Number of clicks. |
| Spend | Spend for the row period. |
| CTR | Click-through rate. |
| CPC | Cost per click. |
| CPM | Cost per thousand impressions. |
| Reach | Estimated unique people reached. |
| Frequency | Average impressions per person reached. |
| Video Play Actions | Video Play Actions. |
| Likes | Likes. |
| Comments | Comments. |
| Shares | Shares. |
| Follows | Follows. |
| Profile Visits | Profile Visits. |
| Average Video Play | Average Video Play. |
| Average Video Play per User | Average Video Play per User. |
| Conversion Rate | Conversion Rate. |
| Cost per Conversion | Cost per Conversion in the row currency unless noted otherwise. |
| Cost per Result | Cost per Result in the row currency unless noted otherwise. |
| Billed Cost | Billed Cost in the row currency unless noted otherwise. |
| Cost per 1,000 People Reached | Cost per 1,000 People Reached in the row currency unless noted otherwise. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
One row per ad per time bucket. Date range: uses the selected export date range and time granularity.
| Column | Description |
|---|---|
| Campaign ID | Campaign ID from the source platform. |
| Campaign Name | Campaign Name. |
| Ad ID | Ad ID from the source platform. |
| Date | Date. |
| Date Start | Date Start. |
| Date Stop | Date Stop. |
| Impressions | Number of times the ad or listing was shown. |
| Clicks | Number of clicks. |
| Spend | Spend for the row period. |
| CTR | Click-through rate. |
| CPC | Cost per click. |
| CPM | Cost per thousand impressions. |
| Reach | Estimated unique people reached. |
| Frequency | Average impressions per person reached. |
| Video Play Actions | Video Play Actions. |
| Likes | Likes. |
| Comments | Comments. |
| Shares | Shares. |
| Follows | Follows. |
| Profile Visits | Profile Visits. |
| Average Video Play | Average Video Play. |
| Average Video Play per User | Average Video Play per User. |
| Conversion Rate | Conversion Rate. |
| Cost per Conversion | Cost per Conversion in the row currency unless noted otherwise. |
| Cost per Result | Cost per Result in the row currency unless noted otherwise. |
| Billed Cost | Billed Cost in the row currency unless noted otherwise. |
| Cost per 1,000 People Reached | Cost per 1,000 People Reached in the row currency unless noted otherwise. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Something missing on this page? Email [email protected]
Install on Shopify