# Sponsored Ads

## **Data Source**

To enable the TikTok Sponsored Ads Reports, the datasource: **TikTok** has to be enabled on the Intentwise Platform

### Campaigns

​Table Name: tiktok\_source\_data.campaigns

<table><thead><tr><th width="227.53125">Column Name</th><th width="185">Data type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>bigint</td><td>Account Id</td></tr><tr><td>account_name</td><td>varchar</td><td>Account Name</td></tr><tr><td>currency_code</td><td>varchar</td><td>Currency Code</td></tr><tr><td>country_code</td><td>varchar</td><td>Country Code</td></tr><tr><td>advertiser_id</td><td>varchar</td><td>Advertiser Id</td></tr><tr><td>campaign_id</td><td>varchar</td><td>Campaign Id</td></tr><tr><td>campaign_system_origin</td><td>varchar</td><td>Campaign Origin. Enum: Promote</td></tr><tr><td>create_time</td><td>timestamp(0)</td><td>Create Time</td></tr><tr><td>modify_time</td><td>timestamp(0)</td><td>Modify Time</td></tr><tr><td>campaign_name</td><td>varchar</td><td>Campaign Name</td></tr><tr><td>operation_status</td><td>varchar</td><td>Operation Status. Enum: Enable, Disable</td></tr><tr><td>secondary_status</td><td>varchar</td><td>Campaign Secondary Status. See Enumeration - Campaign Status.</td></tr><tr><td>objective_type</td><td>varchar</td><td><p></p><ul><li><code>REACH</code> -> Maximize ad impressions in your target audience.</li><li><code>TRAFFIC</code> -> Drive users to a URL such as a website or app.</li><li><code>VIDEO_VIEWS</code> -> Increase views from users likely to watch your video.</li><li><code>LEAD_GENERATION</code> -> Collect leads using in-app customizable forms.</li><li><code>ENGAGEMENT</code> -> Boost followers and profile visits.</li><li><code>APP_PROMOTION</code> -> Promote app installs, re-engagement, or pre-registration.</li><li><code>WEB_CONVERSIONS</code> -> Drive actions on your website or TikTok Instant Page.</li><li><code>PRODUCT_SALES</code> -> Sell products via TikTok Shop, website, or app using shopping ads.</li></ul></td></tr><tr><td>app_promotion_type</td><td>varchar</td><td>App Promotion Type. Enum: App Install, App Retargeting, App Preregistration, App Posts Promotion</td></tr><tr><td>is_search_campaign</td><td>boolean</td><td>Search Campaign Flag. Enum: True, False</td></tr><tr><td>is_smart_performance_campaign</td><td>boolean</td><td>Smart Or Smart Performance Web Campaign Flag. Enum: True, False</td></tr><tr><td>campaign_type</td><td>varchar</td><td>Campaign Type</td></tr><tr><td>app_id</td><td>varchar</td><td>App Id Of Promoted App.</td></tr><tr><td>is_advanced_dedicated_campaign</td><td>boolean</td><td>Whether The Campaign Is An Advanced Dedicated Campaign. Enum: True, False</td></tr><tr><td>disable_skan_campaign</td><td>boolean</td><td>Disable Skan Attribution. Enum: True, False</td></tr><tr><td>bid_align_type</td><td>varchar</td><td>Attribution Type. Enum: San, Skan</td></tr><tr><td>campaign_app_profile_page_state</td><td>varchar</td><td>App Profile Page Status. Enum: Invalid, Unset, On, Off</td></tr><tr><td>rf_campaign_type</td><td>varchar</td><td>Reservation Campaign Type. Enum: Standard, Pulse, Topview</td></tr><tr><td>campaign_product_source</td><td>varchar</td><td>Product Source Of The Campaign. Enum: Catalog, Store</td></tr><tr><td>catalog_enabled</td><td>boolean</td><td>Catalog Usage Flag (Automotive Ads). Enum: True, False</td></tr><tr><td>special_industries</td><td>varchar</td><td>Special Ad Categories. Enum: Housing, Employment, Credit</td></tr><tr><td>budget_optimize_on</td><td>boolean</td><td>Campaign Budget Optimization Enabled. Enum: True</td></tr><tr><td>bid_type</td><td>varchar</td><td>Bidding Strategy.</td></tr><tr><td>deep_bid_type</td><td>varchar</td><td>In-App Event Bidding Strategy.</td></tr><tr><td>roas_bid</td><td>numeric</td><td>Roas Goal For Value Optimization.</td></tr><tr><td>optimization_goal</td><td>varchar</td><td>Optimization Goal. See Enumeration - Optimization Goals.</td></tr><tr><td>budget_mode</td><td>varchar</td><td>Budget Mode. Enum: Budget Mode Infinite, Budget Mode Total, Budget Mode Day, Budget Mode Dynamic Daily Budget</td></tr><tr><td>budget</td><td>numeric</td><td>Campaign Budget.</td></tr><tr><td>rta_id</td><td>varchar</td><td>Real-Time Api Strategy Identifier.</td></tr><tr><td>rta_product_selection_enabled</td><td>boolean</td><td>Enable Rta Product Selection. Enum: True, False</td></tr><tr><td>postback_window_mode</td><td>varchar</td><td>Skan 4.0 Postback Mode. Enum: Postback Window Mode1, Postback Window Mode2, Postback Window Mode3</td></tr><tr><td>is_new_structure</td><td>boolean</td><td>New Structure Flag.</td></tr><tr><td>objective</td><td>varchar</td><td>Campaign Objective Type. Enum: App, Landing Page</td></tr><tr><td>intentwise_account_id</td><td>bigint</td><td>Intentwise Account Id</td></tr><tr><td>created_at</td><td>timestamp(0)</td><td>Created At</td></tr><tr><td>updated_at</td><td>timestamp(0)</td><td>Updated At</td></tr><tr><td>system_updated_time</td><td>timestamp(0)</td><td>System Updated Time</td></tr></tbody></table>

### Adgroup

​Table Name: tiktok\_source\_data.adgroup

| Column Name                        | Data type | Description                                                                                                                               |
| ---------------------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| account\_id                        | Integer   | Intentwise Account Id                                                                                                                     |
| account\_name                      | String    | Account Display Name                                                                                                                      |
| currency\_code                     | String    | Currency Code                                                                                                                             |
| country\_code                      | String    | Country Code                                                                                                                              |
| advertiser\_id                     | Integer   | Advertiser Id.                                                                                                                            |
| campaign\_id                       | Integer   | Campaign Id                                                                                                                               |
| adgroup\_id                        | Integer   | Ad Group Id.                                                                                                                              |
| adgroup\_name                      | String    | Ad Group Name.                                                                                                                            |
| budget\_mode                       | String    | Budget Mode.                                                                                                                              |
| budget                             | Numeric   | Ad Group Budget.                                                                                                                          |
| bid\_type                          | String    | Bid Type                                                                                                                                  |
| bid\_price                         | Numeric   | Bid Price                                                                                                                                 |
| optimization\_goal                 | String    | Optimization Goal. Enum: Conversions, Reach, Video Views, Clicks, Landing Page Views, Lead Generation, Value, App Installs, Product Sales |
| deep\_bid\_type                    | String    | Deep Bid Type                                                                                                                             |
| deep\_cpa\_bid                     | Numeric   | Cost Per Action Bid.                                                                                                                      |
| conversion\_bid\_price             | Numeric   | Conversion bid price.                                                                                                                     |
| billing\_event                     | String    | Billing Event. Enum: Cpc, Cpm, Ocpm, Cpv                                                                                                  |
| schedule\_type                     | String    | Schedule Type. Enum: Schedule Start End, Schedule From Now                                                                                |
| schedule\_start\_time              | DateTime  | Schedule Start Time                                                                                                                       |
| schedule\_end\_time                | DateTime  | Schedule End Time                                                                                                                         |
| dayparting                         | String    | Dayparting                                                                                                                                |
| pacing                             | String    | Pacing                                                                                                                                    |
| operation\_status                  | String    | Operation Status. Enum: Enable, Disable, Frozen                                                                                           |
| secondary\_status                  | String    | Secondary Status                                                                                                                          |
| placement\_type                    | String    | Placement Type. Enum: Placement Type Automatic, Placement Type Normal                                                                     |
| creative\_material\_mode           | String    | Creative Material Strategy. Enum: Custom, Dynamic, Smart Creative                                                                         |
| promotion\_type                    | String    | Type Of Promoted Content. Enum: Download Url, External Url, App Android, App Ios                                                          |
| gender                             | String    | Target Gender. Enum: Gender Female, Gender Male, Gender Unlimited                                                                         |
| brand\_safety\_type                | String    | Brand Safety Type. Enum: No Brand Safety, Expanded Inventory, Standard Inventory, Limited Inventory, Third Party                          |
| ios14\_quota\_type                 | String    | Ios Quota Type. Enum: Occupied, Unoccupied                                                                                                |
| bid\_display\_mode                 | String    | Bid Display Mode                                                                                                                          |
| is\_new\_structure                 | Boolean   | Is New Structure                                                                                                                          |
| auto\_targeting\_enabled           | Boolean   | Auto Targeting Enabled                                                                                                                    |
| share\_disabled                    | Boolean   | Share Disabled                                                                                                                            |
| video\_download\_disabled          | Boolean   | Video Download Disabled                                                                                                                   |
| is\_hfss                           | Boolean   | Is Hfss                                                                                                                                   |
| search\_result\_enabled            | Boolean   | Search Result Enabled                                                                                                                     |
| inventory\_filter\_enabled         | Boolean   | Inventory Filter Enabled                                                                                                                  |
| comment\_disabled                  | Boolean   | Comment Disabled                                                                                                                          |
| skip\_learning\_phase              | Boolean   | Skip Learning Phase                                                                                                                       |
| create\_time                       | DateTime  | Create Time                                                                                                                               |
| modify\_time                       | DateTime  | Modify Time                                                                                                                               |
| placements                         | String    | Placements                                                                                                                                |
| network\_types                     | String    | Network Types                                                                                                                             |
| actions                            | String    | Actions                                                                                                                                   |
| location\_ids                      | String    | Geographic Targeting By Location Id.                                                                                                      |
| audience\_ids                      | String    | Audience Ids                                                                                                                              |
| excluded\_audience\_ids            | String    | Excluded Audience Ids                                                                                                                     |
| languages                          | String    | Languages                                                                                                                                 |
| operating\_systems                 | String    | Operating Systems                                                                                                                         |
| interest\_category\_ids            | String    | Interest Category Ids                                                                                                                     |
| interest\_keyword\_ids             | String    | Interest Keyword Ids                                                                                                                      |
| included\_custom\_actions          | String    | Included Custom Actions                                                                                                                   |
| excluded\_custom\_actions          | String    | Excluded Custom Actions                                                                                                                   |
| delivery\_mode                     | String    | Delivery Mode                                                                                                                             |
| pixel\_id                          | String    | Pixel Id                                                                                                                                  |
| conversion\_window                 | String    | Conversion Window                                                                                                                         |
| schedule\_infos                    | String    | Schedule Infos                                                                                                                            |
| app\_type                          | String    | App Type. Enum: App Android, App Ios                                                                                                      |
| frequency                          | String    | Frequency                                                                                                                                 |
| next\_day\_retention               | String    | Next Day Retention                                                                                                                        |
| device\_price\_ranges              | String    | Device Price Ranges                                                                                                                       |
| optimization\_event                | String    | Optimization Event                                                                                                                        |
| secondary\_optimization\_event     | String    | Secondary Optimization Event                                                                                                              |
| rf\_estimated\_cpr                 | Numeric   | Rf Estimated Cpr                                                                                                                          |
| rf\_purchased\_type                | String    | Rf Purchased Type                                                                                                                         |
| adgroup\_app\_profile\_page\_state | String    | App Profile Page State. Enum: Invalid, Unset, On, Off                                                                                     |
| rf\_estimated\_frequency           | Integer   | Rf Estimated Frequency                                                                                                                    |
| statistic\_type                    | String    | Statistic Type                                                                                                                            |
| purchased\_reach                   | Integer   | Purchased Reach                                                                                                                           |
| keywords                           | String    | Keywords                                                                                                                                  |
| frequency\_schedule                | String    | Frequency Schedule                                                                                                                        |
| purchased\_impression              | Integer   | Purchased Impression                                                                                                                      |
| created\_at                        | DateTime  | Created At                                                                                                                                |
| updated\_at                        | DateTime  | Updated At                                                                                                                                |
| system\_updated\_time              | DateTime  | System Updated Time                                                                                                                       |

### Ads

​Table Name: tiktok\_source\_data.ads

| Column Name                       | Data type | Description                                                                                                                |
| --------------------------------- | --------- | -------------------------------------------------------------------------------------------------------------------------- |
| account\_id                       | Integer   | Account Id                                                                                                                 |
| account\_name                     | String    | Account Name                                                                                                               |
| currency\_code                    | String    | Currency Code                                                                                                              |
| country\_code                     | String    | Country Code                                                                                                               |
| advertiser\_id                    | Integer   | Advertiser Id                                                                                                              |
| campaign\_id                      | Integer   | Campaign Id                                                                                                                |
| adgroup\_id                       | Integer   | Adgroup Id                                                                                                                 |
| ad\_id                            | Integer   | Ad Id                                                                                                                      |
| ad\_name                          | String    | Ad Name                                                                                                                    |
| create\_time                      | DateTime  | Time Ad Was Created.                                                                                                       |
| modify\_time                      | DateTime  | Time Ad Was Modified.                                                                                                      |
| operation\_status                 | String    | Operation Status                                                                                                           |
| secondary\_status                 | String    | Secondary Ad Status.                                                                                                       |
| identity\_id                      | String    | Identity Id                                                                                                                |
| identity\_type                    | String    | Identity Type. Enum Values: Customized User, Auth Code, Tt User, Bc Auth Tt                                                |
| identity\_authorized\_bc\_id      | String    | Business Center Id For Bc Auth Tt.                                                                                         |
| catalog\_id                       | String    | Catalog Id                                                                                                                 |
| product\_specific\_type           | String    | Product Selection Type. Enum: All, Product Set, Customized Products                                                        |
| product\_set\_id                  | String    | Product Set Id                                                                                                             |
| ad\_format                        | String    | Ad Format. Enum: Single Image, Single Video, Live Content, Carousel Ads, Catalog Carousel                                  |
| vertical\_video\_strategy         | String    | Video Strategy. Enum: Unset, Single Video, Catalog Videos, Catalog Uploaded Videos, Live Stream                            |
| dynamic\_format                   | String    | Dynamic Creative Format. Enum: Unset, Dynamic Creative                                                                     |
| video\_id                         | String    | Video Id                                                                                                                   |
| carousel\_image\_index            | Integer   | Index For Carousel Image.                                                                                                  |
| end\_card\_cta                    | String    | End Card Cta. Enum: Search Inventory, Learn More, Shop Now, Sign Up, Contact Us, Book Now, Read More, View More, Order Now |
| music\_id                         | String    | Music Id                                                                                                                   |
| tiktok\_item\_id                  | String    | Spark Ad Post Id.                                                                                                          |
| promotional\_music\_disabled      | Boolean   | Promotional Music Disabled                                                                                                 |
| item\_duet\_status                | String    | Duet Status. Enum: Enable, Disable                                                                                         |
| item\_stitch\_status              | String    | Stitch Status. Enum: Enable, Disable                                                                                       |
| dark\_post\_status                | String    | Dark Post Status. Enum: On, Off                                                                                            |
| branded\_content\_disabled        | Boolean   | Branded Content Disabled                                                                                                   |
| shopping\_ads\_video\_package\_id | String    | Catalog Video Template Id.                                                                                                 |
| ad\_text                          | String    | Ad Text                                                                                                                    |
| call\_to\_action                  | String    | Call To Action.                                                                                                            |
| call\_to\_action\_id              | String    | Cta Portfolio Id.                                                                                                          |
| card\_id                          | String    | Creative Portfolio Id.                                                                                                     |
| landing\_page\_url                | String    | Landing Page Url                                                                                                           |
| page\_id                          | Integer   | Page Id                                                                                                                    |
| cpp\_url                          | String    | Custom Product Page Url.                                                                                                   |
| tiktok\_page\_category            | String    | Tiktok Page Category                                                                                                       |
| phone\_region\_code               | String    | Phone Region Code                                                                                                          |
| phone\_region\_calling\_code      | String    | Phone Region Calling Code                                                                                                  |
| phone\_number                     | String    | Phone Number                                                                                                               |
| deeplink                          | String    | App Deeplink.                                                                                                              |
| deeplink\_type                    | String    | Deeplink Type. Enum: Normal, Deferred Deeplink                                                                             |
| deeplink\_format\_type            | String    | Deeplink Format. Enum: Universal Or App Link, Scheme Link, None                                                            |
| shopping\_ads\_deeplink\_type     | String    | Shopping Ads Deeplink Source. Enum: None, Custom, Shopping Ads                                                             |
| item\_group\_ids                  | String    | Product Spu Ids.                                                                                                           |
| sku\_ids                          | String    | Sku Ids                                                                                                                    |
| vehicle\_ids                      | String    | Vehicle Ids                                                                                                                |
| image\_ids                        | String    | List Of Image Ids.                                                                                                         |
| ad\_texts                         | String    | List Of Ad Texts.                                                                                                          |
| product\_display\_field\_list     | String    | Product Display Fields. Enum Includes: Dealer Name, Make, Model, Etc.                                                      |
| showcase\_products                | String    | Showcase Product Details.                                                                                                  |
| utm\_params                       | String    | Utm Parameters List.                                                                                                       |
| intentwise\_account\_id           | Integer   | Intentwise Account Id                                                                                                      |
| created\_at                       | DateTime  | Created At                                                                                                                 |
| updated\_at                       | DateTime  | Updated At                                                                                                                 |
| system\_updated\_time             | DateTime  | System Updated Time                                                                                                        |

### Campaign Report

​Table Name: tiktok\_source\_data.campaign\_report

| Column Name                                                 | Data type | Description                                                                            |
| ----------------------------------------------------------- | --------- | -------------------------------------------------------------------------------------- |
| account\_id                                                 | Integer   | Account Id                                                                             |
| account\_name                                               | String    | Account Name                                                                           |
| currency\_code                                              | String    | Currency Code                                                                          |
| country\_code                                               | String    | Country Code                                                                           |
| intentwise\_account\_id                                     | Integer   | Intentwise Account Id                                                                  |
| advertiser\_id                                              | Integer   | Advertiser Id                                                                          |
| campaign\_id                                                | Integer   | Campaign Id                                                                            |
| stat\_time\_day                                             | Date      | Stat Time Day                                                                          |
| spend                                                       | Numeric   | Spend                                                                                  |
| cpc                                                         | Numeric   | Average cost of each click to a specified destination.                                 |
| cpm                                                         | Numeric   | Average amount you spent per 1,000 impressions.                                        |
| impressions                                                 | Integer   | Impressions                                                                            |
| gross\_impressions                                          | Integer   | Gross Impressions (Includes Invalid Impressions)                                       |
| clicks                                                      | Integer   | Number of clicks from your ads to a specified destination.                             |
| ctr                                                         | Numeric   | Percentage of impressions that resulted in a destination click out of all impressions. |
| reach                                                       | Integer   | Number of unique users who saw your ads at least once.                                 |
| cost\_per\_1000\_reached                                    | Numeric   | Cost Per 1000 Reached                                                                  |
| frequency                                                   | Numeric   | The average number of times each user saw your ad over a given time period.            |
| conversion                                                  | Integer   | Number of times your ad resulted in the optimization event you selected.               |
| cost\_per\_conversion                                       | Numeric   | Cost Per Conversion                                                                    |
| conversion\_rate                                            | Numeric   | Conversion Rate                                                                        |
| conversion\_rate\_v2                                        | Numeric   | Conversion Rate V2                                                                     |
| real\_time\_conversion                                      | Integer   | Real Time Conversion                                                                   |
| real\_time\_cost\_per\_conversion                           | Numeric   | Real Time Cost Per Conversion                                                          |
| video\_play\_actions                                        | Integer   | Video Play Actions                                                                     |
| video\_watched\_2s                                          | Integer   | 2-Second Video Views                                                                   |
| video\_watched\_6s                                          | Integer   | 6-Second Video Views                                                                   |
| engaged\_view                                               | Integer   | 6-Second Views (Focused View)                                                          |
| paid\_engaged\_view                                         | Integer   | Paid Engaged View                                                                      |
| paid\_engagement\_engaged\_view                             | Integer   | Paid Engagement Engaged View                                                           |
| engaged\_view\_15s                                          | Integer   | 15-Second Views (Focused View)                                                         |
| paid\_engaged\_view\_15s                                    | Integer   | Paid Engaged View 15S                                                                  |
| paid\_engagement\_engaged\_view\_15s                        | Integer   | Paid Engagement Engaged View 15S                                                       |
| video\_views\_p25                                           | Integer   | Video Views At 25%                                                                     |
| video\_views\_p50                                           | Integer   | Video Views At 50%                                                                     |
| video\_views\_p75                                           | Integer   | Video Views At 75%                                                                     |
| video\_views\_p100                                          | Integer   | Video Views At 100%                                                                    |
| average\_video\_play                                        | Numeric   | Average Video Play                                                                     |
| average\_video\_play\_per\_user                             | Numeric   | Average Video Play Per User                                                            |
| engagements                                                 | Integer   | Engagements                                                                            |
| engagement\_rate                                            | Numeric   | Engagement Rate                                                                        |
| follows                                                     | Integer   | Follows                                                                                |
| likes                                                       | Integer   | Likes                                                                                  |
| comments                                                    | Integer   | Comments                                                                               |
| shares                                                      | Integer   | Number of shares of your ad during the ad impression.                                  |
| profile\_visits                                             | Integer   | Profile Visits                                                                         |
| profile\_visits\_rate                                       | Numeric   | Profile Visits Rate                                                                    |
| complete\_payment                                           | integer   | Number of website purchase actions attributed to your ads.                             |
| cost\_per\_complete\_payment                                | numeric   | Average cost per website purchase action attributed to your ads.                       |
| complete\_payment\_rate                                     | numeric   | Percentage of website purchase actions from all clicks attributed to your ads.         |
| total\_complete\_payment\_rate                              | numeric   | Total value of website purchase actions attributed to your ads.                        |
| onsite\_total\_purchase                                     | integer   | The number of TikTok purchase actions attributed to your ads.                          |
| onsite\_cost\_per\_purchase                                 | numeric   | The average cost per TikTok purchase action attributed to your ads.                    |
| onsite\_purchase\_rate                                      | numeric   | The percentage of TikTok purchase actions from all clicks attributed to your ads.      |
| onsite\_value\_per\_purchase                                | numeric   | The average value per TikTok purchase action attributed to your ads.                   |
| onsite\_total\_purchase\_value                              | numeric   | The total value of TikTok purchase actions attributed to your ads.                     |
| system\_updated\_time                                       | DateTime  | System Updated Time                                                                    |
| shop\_metrics\_onsite\_shopping                             | Integer   |                                                                                        |
| shop\_metrics\_cost\_per\_onsite\_shopping                  | Numeric   |                                                                                        |
| shop\_metrics\_onsite\_shopping\_rate                       | Numeric   |                                                                                        |
| shop\_metrics\_value\_per\_onsite\_shopping                 | Numeric   |                                                                                        |
| shop\_metrics\_total\_onsite\_shopping\_value               | Numeric   |                                                                                        |
| shop\_metrics\_shop\_total\_purchase\_by\_order\_submission | Integer   |                                                                                        |
| shop\_metrics\_shop\_gross\_revenue\_by\_order\_submission  | Numeric   |                                                                                        |
| shop\_metrics\_shop\_total\_items\_purchased                | Integer   |                                                                                        |

### Campaign Gender Report

​Table Name: tiktok\_source\_data.campaign\_gender\_report

| Column Name                                                 | Data type | Description                                                                            |
| ----------------------------------------------------------- | --------- | -------------------------------------------------------------------------------------- |
| account\_id                                                 | Integer   | Account Id                                                                             |
| account\_name                                               | String    | Account Name                                                                           |
| currency\_code                                              | String    | Currency Code                                                                          |
| country\_code                                               | String    | Country Code                                                                           |
| advertiser\_id                                              | Integer   | Advertiser Id                                                                          |
| intentwise\_account\_id                                     | Integer   | Intentwise Account Id                                                                  |
| campaign\_id                                                | Integer   | Campaign Id                                                                            |
| stat\_time\_day                                             | Date      | Stat Time Day                                                                          |
| gender                                                      | String    | Gender                                                                                 |
| spend                                                       | Numeric   | Spend                                                                                  |
| ctr                                                         | Numeric   | Percentage of impressions that resulted in a destination click out of all impressions. |
| cpc                                                         | Numeric   | Average cost of each click to a specified destination.                                 |
| cpm                                                         | Numeric   | Average amount you spent per 1,000 impressions.                                        |
| impressions                                                 | Integer   | Impressions                                                                            |
| gross\_impressions                                          | Integer   | Gross Impressions (Includes Invalid Impressions)                                       |
| clicks                                                      | Integer   | Clicks                                                                                 |
| reach                                                       | Integer   | Number of unique users who saw your ads at least once.                                 |
| frequency                                                   | Numeric   | The average number of times each user saw your ad over a given time period.            |
| conversions                                                 | Integer   | Number of times your ad resulted in the optimization event you selected.               |
| conversion\_rate                                            | Numeric   | Conversion Rate                                                                        |
| conversion\_rate\_v2                                        | Numeric   | Conversion Rate V2                                                                     |
| cost\_per\_conversion                                       | Numeric   | Cost Per Conversion                                                                    |
| real\_time\_conversion                                      | Integer   | Real Time Conversion                                                                   |
| real\_time\_cost\_per\_conversion                           | Numeric   | Real Time Cost Per Conversion                                                          |
| video\_play\_actions                                        | Integer   | Video Play Actions                                                                     |
| video\_watched\_2s                                          | Integer   | 2-Second Video Views                                                                   |
| video\_watched\_6s                                          | Integer   | 6-Second Video Views                                                                   |
| engaged\_view                                               | Integer   | 6-Second Views (Focused View)                                                          |
| engaged\_view\_15s                                          | Integer   | 15-Second Views (Focused View)                                                         |
| video\_views\_p25                                           | Integer   | Video Views At 25%                                                                     |
| video\_views\_p50                                           | Integer   | Video Views At 50%                                                                     |
| video\_views\_p75                                           | Integer   | Video Views At 75%                                                                     |
| video\_views\_p100                                          | Integer   | Video Views At 100%                                                                    |
| average\_video\_play                                        | Numeric   | Average Video Play                                                                     |
| average\_video\_play\_per\_user                             | Numeric   | Average Video Play Per User                                                            |
| follows                                                     | Integer   | Follows                                                                                |
| likes                                                       | Integer   | Likes                                                                                  |
| comments                                                    | Integer   | Comments                                                                               |
| shares                                                      | Integer   | Shares                                                                                 |
| profile\_visits                                             | Integer   | Profile Visits                                                                         |
| profile\_visits\_rate                                       | Numeric   | Profile Visits Rate                                                                    |
| cost\_per\_1000\_reached                                    | Numeric   | Cost Per 1000 Reached                                                                  |
| system\_updated\_time                                       | Date Time | System Updated Time                                                                    |
| shop\_metrics\_onsite\_shopping                             | Integer   |                                                                                        |
| shop\_metrics\_cost\_per\_onsite\_shopping                  | Numeric   |                                                                                        |
| shop\_metrics\_onsite\_shopping\_rate                       | Numeric   |                                                                                        |
| shop\_metrics\_value\_per\_onsite\_shopping                 | Numeric   |                                                                                        |
| shop\_metrics\_total\_onsite\_shopping\_value               | Numeric   |                                                                                        |
| shop\_metrics\_shop\_total\_purchase\_by\_order\_submission | Integer   |                                                                                        |
| shop\_metrics\_shop\_gross\_revenue\_by\_order\_submission  | Numeric   |                                                                                        |
| shop\_metrics\_shop\_total\_items\_purchased                | Integer   |                                                                                        |

### Adgroup Report

​Table Name: tiktok\_source\_data.adgroup\_report

| Column Name                                                 | Data type | Description                                                                            |
| ----------------------------------------------------------- | --------- | -------------------------------------------------------------------------------------- |
| account\_id                                                 | Integer   | Account Id                                                                             |
| account\_name                                               | String    | Account Name                                                                           |
| currency\_code                                              | String    | Currency Code                                                                          |
| country\_code                                               | String    | Country Code                                                                           |
| intentwise\_account\_id                                     | Integer   | Intentwise Account Id                                                                  |
| advertiser\_id                                              | Integer   | Advertiser Id                                                                          |
| campaign\_id                                                | Integer   | Campaign Id                                                                            |
| adgroup\_id                                                 | Integer   | Adgroup Id                                                                             |
| stat\_time\_day                                             | Date      | Report date                                                                            |
| spend                                                       | Numeric   | Total Cost                                                                             |
| cpc                                                         | Numeric   | Average cost of each click to a specified destination.                                 |
| cpm                                                         | Numeric   | Average amount you spent per 1,000 impressions.                                        |
| impressions                                                 | Integer   | Impressions                                                                            |
| gross\_impressions                                          | Integer   | Gross Impressions (Includes Invalid Impressions)                                       |
| clicks                                                      | Integer   | Clicks                                                                                 |
| ctr                                                         | Numeric   | Percentage of impressions that resulted in a destination click out of all impressions. |
| reach                                                       | Integer   | Number of unique users who saw your ads at least once.                                 |
| cost\_per\_1000\_reached                                    | Numeric   | Cost Per 1000 Reached                                                                  |
| frequency                                                   | Numeric   | The average number of times each user saw your ad over a given time period.            |
| conversion                                                  | Integer   | Number of times your ad resulted in the optimization event you selected.               |
| cost\_per\_conversion                                       | Numeric   | Cost Per Conversion                                                                    |
| conversion\_rate                                            | Numeric   | Conversion Rate                                                                        |
| conversion\_rate\_v2                                        | Numeric   | Conversion Rate V2                                                                     |
| real\_time\_conversion                                      | Integer   | Real Time Conversion                                                                   |
| real\_time\_cost\_per\_conversion                           | Numeric   | Real Time Cost Per Conversion                                                          |
| video\_play\_actions                                        | Integer   | Video Views                                                                            |
| video\_watched\_2s                                          | Integer   | 2-Second Video Views                                                                   |
| video\_watched\_6s                                          | Integer   | 6-Second Video Views                                                                   |
| engaged\_view                                               | Integer   | Engaged View                                                                           |
| paid\_engaged\_view                                         | Integer   | Paid Engaged View                                                                      |
| paid\_engagement\_engaged\_view                             | Integer   | Paid Engagement Engaged View                                                           |
| engaged\_view\_15s                                          | Integer   | Engaged View 15S                                                                       |
| paid\_engaged\_view\_15s                                    | Integer   | Paid Engaged View 15S                                                                  |
| paid\_engagement\_engaged\_view\_15s                        | Integer   | Paid Engagement Engaged View 15S                                                       |
| video\_views\_p25                                           | Integer   | Video Views At 25%                                                                     |
| video\_views\_p50                                           | Integer   | Video Views At 50%                                                                     |
| video\_views\_p75                                           | Integer   | Video Views At 75%                                                                     |
| video\_views\_p100                                          | Integer   | Video Views At 100%                                                                    |
| average\_video\_play                                        | Numeric   | Average Watch Time Per Video View                                                      |
| average\_video\_play\_per\_user                             | Numeric   | Average Watch Time Per Video View Per User                                             |
| engagements                                                 | Integer   | Engagements                                                                            |
| engagement\_rate                                            | Numeric   | Engagement Rate                                                                        |
| follows                                                     | Integer   | Follows                                                                                |
| likes                                                       | Integer   | Likes                                                                                  |
| comments                                                    | Integer   | Comments                                                                               |
| shares                                                      | Integer   | Shares                                                                                 |
| profile\_visits                                             | Integer   | Paid Profile Visits                                                                    |
| profile\_visits\_rate                                       | Numeric   | Paid Profile Visit Rate                                                                |
| system\_updated\_time                                       | DateTime  | System Updated Time                                                                    |
| complete\_payment                                           | Integer   | Number of website purchase actions attributed to your ads.                             |
| cost\_per\_complete\_payment                                | Numeric   | Average cost per website purchase action attributed to your ads.                       |
| complete\_payment\_rate                                     | Numeric   | Percentage of website purchase actions from all clicks attributed to your ads.         |
| value\_per\_complete\_payment                               | Numeric   | Average value per website purchase action attributed to your ads.                      |
| total\_complete\_payment\_rate                              | Numeric   | Total value of website purchase actions attributed to your ads.                        |
| onsite\_total\_purchase                                     | Integer   | The number of TikTok purchase actions attributed to your ads.                          |
| onsite\_cost\_per\_purchase                                 | Numeric   | The average cost per TikTok purchase action attributed to your ads.                    |
| onsite\_purchase\_rate                                      | Numeric   | The percentage of TikTok purchase actions from all clicks attributed to your ads.      |
| onsite\_value\_per\_purchase                                | Numeric   | The average value per TikTok purchase action attributed to your ads.                   |
| onsite\_total\_purchase\_value                              | Numeric   | The total value of TikTok purchase actions attributed to your ads.                     |
| shop\_metrics\_onsite\_shopping                             | Integer   |                                                                                        |
| shop\_metrics\_cost\_per\_onsite\_shopping                  | Numeric   |                                                                                        |
| shop\_metrics\_onsite\_shopping\_rate                       | Numeric   |                                                                                        |
| shop\_metrics\_value\_per\_onsite\_shopping                 | Numeric   |                                                                                        |
| shop\_metrics\_total\_onsite\_shopping\_value               | Numeric   |                                                                                        |
| shop\_metrics\_shop\_total\_purchase\_by\_order\_submission | Integer   |                                                                                        |
| shop\_metrics\_shop\_gross\_revenue\_by\_order\_submission  | Numeric   |                                                                                        |
| shop\_metrics\_shop\_total\_items\_purchased                | Integer   |                                                                                        |

### Ads Report

​Table Name: tiktok\_source\_data.ads\_report

| Column Name                                                 | Data type | Description                                                                            |
| ----------------------------------------------------------- | --------- | -------------------------------------------------------------------------------------- |
| account\_id                                                 | Integer   | Account Id                                                                             |
| account\_name                                               | String    | Account Name                                                                           |
| currency\_code                                              | String    | Currency Code                                                                          |
| country\_code                                               | String    | Country Code                                                                           |
| intentwise\_account\_id                                     | Integer   | Intentwise Account Id                                                                  |
| advertiser\_id                                              | Integer   | Advertiser Id                                                                          |
| campaign\_id                                                | Integer   | Campaign Id                                                                            |
| adgroup\_id                                                 | Integer   | Adgroup Id                                                                             |
| ad\_id                                                      | Integer   | Ad Id                                                                                  |
| stat\_time\_day                                             | Date      | Stat Time Day                                                                          |
| spend                                                       | Numeric   | Total Cost                                                                             |
| cpc                                                         | Numeric   | Average cost of each click to a specified destination.                                 |
| cpm                                                         | Numeric   | Average amount you spent per 1,000 impressions.                                        |
| impressions                                                 | Integer   | Impressions                                                                            |
| gross\_impressions                                          | Integer   | Gross Impressions (Includes Invalid Impressions)                                       |
| clicks                                                      | Integer   | Clicks                                                                                 |
| ctr                                                         | Numeric   | Percentage of impressions that resulted in a destination click out of all impressions. |
| reach                                                       | Integer   | Number of unique users who saw your ads at least once.                                 |
| cost\_per\_1000\_reached                                    | Numeric   | Cost Per 1000 Reached                                                                  |
| frequency                                                   | Numeric   | The average number of times each user saw your ad over a given time period.            |
| conversion                                                  | Integer   | Number of times your ad resulted in the optimization event you selected.               |
| cost\_per\_conversion                                       | Numeric   | Cost Per Conversion                                                                    |
| conversion\_rate                                            | Numeric   | Conversion Rate                                                                        |
| conversion\_rate\_v2                                        | Numeric   | Conversion Rate V2                                                                     |
| real\_time\_conversion                                      | Integer   | Real Time Conversion                                                                   |
| real\_time\_cost\_per\_conversion                           | Numeric   | Real Time Cost Per Conversion                                                          |
| video\_play\_actions                                        | Integer   | Video Play Actions                                                                     |
| video\_watched\_2s                                          | Integer   | 2-Second Video Views                                                                   |
| video\_watched\_6s                                          | Integer   | 6-Second Video Views                                                                   |
| engaged\_view                                               | Integer   | 6-second views (Focused view)                                                          |
| paid\_engaged\_view                                         | Integer   | Paid Engaged View                                                                      |
| paid\_engagement\_engaged\_view                             | Integer   | Paid Engagement Engaged View                                                           |
| engaged\_view\_15s                                          | Integer   | 15-second views (Focused view)                                                         |
| paid\_engaged\_view\_15s                                    | Integer   | Paid Engaged View 15S                                                                  |
| paid\_engagement\_engaged\_view\_15s                        | Integer   | Paid Engagement Engaged View 15S                                                       |
| video\_views\_p25                                           | Integer   | Video Views at 25%                                                                     |
| video\_views\_p50                                           | Integer   | Video Views at 50%                                                                     |
| video\_views\_p75                                           | Integer   | Video Views at 75%                                                                     |
| video\_views\_p100                                          | Integer   | Video Views at 100%                                                                    |
| average\_video\_play                                        | Numeric   | Average Video Play                                                                     |
| average\_video\_play\_per\_user                             | Numeric   | Average Video Play Per User                                                            |
| engagements                                                 | Integer   | Engagements                                                                            |
| engagement\_rate                                            | Numeric   | Engagement Rate                                                                        |
| follows                                                     | Integer   | Follows                                                                                |
| likes                                                       | Integer   | Likes                                                                                  |
| comments                                                    | Integer   | Comments                                                                               |
| shares                                                      | Integer   | Shares                                                                                 |
| profile\_visits                                             | Integer   | Profile Visits                                                                         |
| profile\_visits\_rate                                       | Numeric   | Profile Visits Rate                                                                    |
| system\_updated\_time                                       | DateTime  | System Updated Time                                                                    |
| complete\_payment                                           | Integer   | Number of website purchase actions attributed to your ads.                             |
| cost\_per\_complete\_payment                                | Numeric   | Average cost per website purchase action attributed to your ads.                       |
| complete\_payment\_rate                                     | Numeric   | Percentage of website purchase actions from all clicks attributed to your ads.         |
| value\_per\_complete\_payment                               | Numeric   | Average value per website purchase action attributed to your ads.                      |
| total\_complete\_payment\_rate                              | Numeric   | Total value of website purchase actions attributed to your ads.                        |
| onsite\_total\_purchase                                     | Integer   | The number of TikTok purchase actions attributed to your ads.                          |
| onsite\_cost\_per\_purchase                                 | Numeric   | The average cost per TikTok purchase action attributed to your ads.                    |
| onsite\_purchase\_rate                                      | Numeric   | The percentage of TikTok purchase actions from all clicks attributed to your ads.      |
| onsite\_value\_per\_purchase                                | Numeric   | The average value per TikTok purchase action attributed to your ads.                   |
| onsite\_total\_purchase\_value                              | Numeric   | The total value of TikTok purchase actions attributed to your ads.                     |
| shop\_metrics\_onsite\_shopping                             | Integer   |                                                                                        |
| shop\_metrics\_cost\_per\_onsite\_shopping                  | Numeric   |                                                                                        |
| shop\_metrics\_onsite\_shopping\_rate                       | Numeric   |                                                                                        |
| shop\_metrics\_value\_per\_onsite\_shopping                 | Numeric   |                                                                                        |
| shop\_metrics\_total\_onsite\_shopping\_value               | Numeric   |                                                                                        |
| shop\_metrics\_shop\_total\_purchase\_by\_order\_submission | Integer   |                                                                                        |
| shop\_metrics\_shop\_gross\_revenue\_by\_order\_submission  | Numeric   |                                                                                        |
| shop\_metrics\_shop\_total\_items\_purchased                | Integer   |                                                                                        |

### GMV Max Campaign

​Table Name: tiktok\_source\_data.gmv\_max\_campaign

| Column Name                         | Data type | Description                                                                                                                                                                                                                                                                                                                                                                                                         |
| ----------------------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| account\_id                         | Integer   | Account ID                                                                                                                                                                                                                                                                                                                                                                                                          |
| account\_name                       | Boolean   | Account Name                                                                                                                                                                                                                                                                                                                                                                                                        |
| currency\_code                      | String    | Currency Code                                                                                                                                                                                                                                                                                                                                                                                                       |
| country\_code                       | String    | Country Code                                                                                                                                                                                                                                                                                                                                                                                                        |
| campaign\_id                        | Integer   | The ID of the GMV Max Campaign.                                                                                                                                                                                                                                                                                                                                                                                     |
| advertiser\_id                      | Integer   | Advertiser ID.                                                                                                                                                                                                                                                                                                                                                                                                      |
| operation\_status                   | String    | "The status of the GMV Max Campaign. Enum values:DISABLE: Disabled. ENABLE: Enabled."                                                                                                                                                                                                                                                                                                                               |
| campaign\_name                      | String    | The name of the GMV Max Campaign.                                                                                                                                                                                                                                                                                                                                                                                   |
| secondary\_status                   | String    | secondary status                                                                                                                                                                                                                                                                                                                                                                                                    |
| store\_id                           | String    | The ID of the TikTok Shop.                                                                                                                                                                                                                                                                                                                                                                                          |
| store\_authorized\_bc\_id           | String    | ID of the Business Center that is authorized to access the TikTok Shop (store\_id).                                                                                                                                                                                                                                                                                                                                 |
| shopping\_ads\_type                 | String    | "The type of the GMV Max Campaign. Enum values:PRODUCT: Product GMV Max Campaign. LIVE: Live GMV Max Campaign."                                                                                                                                                                                                                                                                                                     |
| product\_specific\_type             | String    | "Different dimensions to choose products. Enum values:ALL: Allow TikTok to dynamically choose from all products within the TikTok Shop. CUSTOMIZED\_PRODUCTS: Specify a customized number of products within the TikTok Shop. UNSET: Unset."                                                                                                                                                                        |
| item\_group\_ids                    | String    | "Returned only when shopping\_ads\_type is PRODUCT and product\_specific\_type is CUSTOMIZED\_PRODUCTS. Product SPU (standard product unit) IDs."                                                                                                                                                                                                                                                                   |
| optimization\_goal                  | String    | "Optimization goal. Enum value:VALUE: Gross revenue."                                                                                                                                                                                                                                                                                                                                                               |
| deep\_bid\_type                     | String    | "Bid strategy. Enum value:VO\_MIN\_ROAS: Minimum ROAS. Bid with an ROI target."                                                                                                                                                                                                                                                                                                                                     |
| roas\_bid                           | Numeric   | "Returned only when deep\_bid\_type is VO\_MIN\_ROAS. ROI target."                                                                                                                                                                                                                                                                                                                                                  |
| budget                              | Numeric   | Daily budget.                                                                                                                                                                                                                                                                                                                                                                                                       |
| schedule\_type                      | String    | "Schedule type. Enum values:SCHEDULE\_FROM\_NOW: To run the campaign continuously after the scheduled start time. SCHEDULE\_START\_END: To run the campaign between the scheduled start time and end time."                                                                                                                                                                                                         |
| schedule\_start\_time               | DateTime  | Campaign delivery start time, in the format of YYYY-MM-DD HH:MM:SS (UTC+0).                                                                                                                                                                                                                                                                                                                                         |
| schedule\_end\_time                 | DateTime  | Campaign delivery end time, in the format of YYYY-MM-DD HH:MM:SS (UTC+0).                                                                                                                                                                                                                                                                                                                                           |
| placements                          | String    | "Placements. The apps where you want to deliver your campaign. Enum values:PLACEMENT\_TIKTOK: TikTok. PLACEMENT\_PANGLE: Pangle. Note: Product GMV Max Campaigns automatically explore and choose from the most extensive audience scope across TikTok and Pangle. Learn more about Pangle. If you want to opt out of the Pangle placement for your Product GMV Max Campaigns, contact your TikTok representative." |
| product\_video\_specific\_type      | String    | "The video selection mode. Enum values:AUTO\_SELECTION: To autoselect videos. CUSTOM\_SELECTION: To manually select videos. UNSET: Unset."                                                                                                                                                                                                                                                                          |
| affiliate\_posts\_enabled           | Boolean   | affiliate\_posts\_enabled                                                                                                                                                                                                                                                                                                                                                                                           |
| campaign\_custom\_anchor\_video\_id | String    | campaign\_custom\_anchor\_video\_id                                                                                                                                                                                                                                                                                                                                                                                 |
| system\_updated\_time               | DateTime  | system\_updated\_time                                                                                                                                                                                                                                                                                                                                                                                               |
| objective\_type                     | String    | objective\_type                                                                                                                                                                                                                                                                                                                                                                                                     |

### GMV Max Campaign Report

​Table Name: tiktok\_source\_data.gmv\_max\_campaign\_report<br>

<table><thead><tr><th width="247.5999755859375">Column Name</th><th width="172.7999267578125">Data type</th><th width="405.4000244140625">Description</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td>Account ID</td></tr><tr><td>account_name</td><td>String</td><td>Account Name</td></tr><tr><td>currency_code</td><td>String</td><td>Currency Code</td></tr><tr><td>country_code</td><td>String</td><td>Country Code</td></tr><tr><td>advertiser_id</td><td>Integer</td><td>Advertiser ID.</td></tr><tr><td>campaign_id</td><td>Integer</td><td>The ID of the GMV Max Campaign.</td></tr><tr><td>stat_time_day</td><td>Date</td><td>Start Time</td></tr><tr><td>gmv_max_type</td><td>String</td><td>GMV Max Type</td></tr><tr><td>cost</td><td>Numeric</td><td>The estimated total amount you've spent on your ads during its schedule, in the currency of the ad account.</td></tr><tr><td>net_cost</td><td>Numeric</td><td>"The amount spent, excluding ad credit or coupons used, in the currency of the ad account.<br>Note that the data latency for this metric can be up to 11 hours. Campaign data for is metric is available starting September 1, 2023."</td></tr><tr><td>orders</td><td>Integer</td><td>"The number of individual paid and organic SKU orders completed during the GMV Max Campaign, excluding SKU orders created from LIVE orders.<br>Campaign data for this metric is available starting September 27, 2024."</td></tr><tr><td>cost_per_order</td><td>Numeric</td><td>"The average ad cost for each order placed during this GMV Max Campaign in the currency of the ad account, excluding LIVE orders, calculated by dividing the total ad cost by the number of orders generated within the ad schedule.<br>Campaign data for this metric is available starting September 27, 2024."</td></tr><tr><td>gross_revenue</td><td>Numeric</td><td>"The total gross revenue of paid and organic TikTok Shop orders placed during your GMV Max Campaign in the currency of the ad account, excluding LIVE orders. It's the amount paid by users, plus all TikTok Shop platform product subsidies provided to those users.<br>Campaign data for this metric is available starting September 27, 2024."</td></tr><tr><td>roi</td><td>Numeric</td><td>"Product ROI, calculated with all paid and organic sales attributed to an active GMV Max Campaign, excluding LIVE orders, divided by total ad cost.<br>Campaign data for this metric is available starting September 27, 2024."</td></tr><tr><td>live_views</td><td>Integer</td><td>live_views</td></tr><tr><td>cost_per_live_view</td><td>Numeric</td><td>cost_per_live_view</td></tr><tr><td>live_follows</td><td>Integer</td><td>live_follows</td></tr><tr><td>system_updated_time</td><td>DateTime</td><td>System Updated Timestamp</td></tr></tbody></table>