Introduction
Datasources and destinations
- Find all the data sources available at www.catchr.io/connectors
- Find all the destinations available at www.catchr.io/destinations
EXPLORE YOUR DATA
Metrics & dimensions
Find the fields you need for your next report.
23 metrics52 dimensions
75 fields
| Field | Details |
|---|---|
2-second ad video view rate Two-second video views divided by total video views; replays excluded; available from 2024-09-27. | Field IDad_video_view_rate_2s |
6-second ad video view rate Six-second video views divided by total video views; replays excluded; available from 2024-09-27. | Field IDad_video_view_rate_6s |
10s LIVE Views Views of at least 10 seconds. Available from Sept 27, 2024. | Field ID10_second_live_views |
25% ad video view rate Views reaching at least 25% of runtime divided by total video views (paid); replays excluded; available from 2024-09-27. | Field IDad_video_view_rate_p25 |
50% ad video view rate Views reaching at least 50% of runtime divided by total video views (paid); replays excluded; available from 2024-09-27. | Field IDad_video_view_rate_p50 |
75% ad video view rate Views reaching at least 75% of runtime divided by total video views (paid); replays excluded; available from 2024-09-27. | Field IDad_video_view_rate_p75 |
100% ad video view rate Views reaching 100% of runtime divided by total video views (paid); replays excluded; available from 2024-09-27. | Field IDad_video_view_rate_p100 |
Ad click rate Click-through rate of paid views (ad clicks divided by ad views) for the selected product; excludes paid LIVE; available from 2024-09-27. | Field IDad_click_rate |
Ad conversion rate Conversions divided by paid clicks for the selected product; excludes paid LIVE; available from 2024-09-27. | Field IDad_conversion_rate |
Advertiser ID Get the Advertiser ID. | Field IDadvertiser/id |
Bid Type Optimization mode. CUSTOM: Target ROI. NO_BID: Maximum delivery. | Field IDcampaign/bid_type |
Bit Rate (bps) Video bit rate in bits per second (bps). | Field IDcreative/bit_rate |
Campaign ID Campaign ID | Field IDcampaign/campaign_id |
Campaign Name Campaign name | Field IDcampaign/campaign_name |
Cost The estimated total amount you've spent on your ads during its schedule, in the currency of the ad account. | Field IDcost |
Cost per 10s LIVE View Ad cost per 10-second LIVE view. Available from Sept 27, 2024. | Field IDcost_per_10_second_live_view |
Cost per LIVE View Ad cost per LIVE view. Available from Sept 27, 2024. | Field IDcost_per_live_view |
Cost per Order The average cost incurred for each order placed, in the currency of the ad account. It's calculated by dividing the total ad cost by the number of orders generated within the ad schedule. | Field IDcost_per_order |
Creative Campaign ID Campaign ID | Field IDcreative/campaign_id |
Creative ID Creative identification string. | Field IDcreative/item_id |
Creative Product SPU ID TikTok Shop product SPU identifier linked to the creative. | Field IDcreative/item_group_id |
Creative Report ID Unique campaign, product and post combination in a GMV Max creative report. | Field IDcreative/creative_report_id |
Date Year, month, and day. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY |
Day of the month Day of the year | Field ID_NORMALIZED_DATE_FIELD_DAY |
Day of the week Week of the year | Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK |
Definition Video definition/quality. | Field IDcreative/definition |
Duration (s) Video duration in seconds. | Field IDcreative/duration |
Format Video container format (e.g., mp4). | Field IDcreative/format |
Frames Per Second Frames per second (FPS) of the video. | Field IDcreative/fps |
Gross Revenue The total gross revenue of TikTok Shop orders attributed to your campaign, in the currency of the ad account. It's the amount the user pays, plus all TikTok Shop platform subsidies provided to the user. | Field IDgross_revenue |
Height (px) Video height in pixels. | Field IDcreative/height |
Hour of the day Hour of the day | Field ID_NORMALIZED_DATE_FIELD_HOUR |
LIVE Duration Livestream duration | Field IDlivestream/live_duration |
LIVE Follows Users who followed during LIVE. Available from Sept 27, 2024. | Field IDlive_follows |
LIVE Launched Time Livestream launched time | Field IDlivestream/live_launched_time |
LIVE name LIVE name | Field IDlivestream/live_name |
LIVE Status Livestream status. Enum values: ONGOING, END | Field IDlivestream/live_status |
LIVE Views Number of LIVE views. Available from Sept 27, 2024. | Field IDlive_views |
Max Delivery Budget Maximum delivery budget | Field IDcampaign/max_delivery_budget |
Month and day Month and day | Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY |
Month of the year Month of the year | Field ID_NORMALIZED_DATE_FIELD_MONTH |
Net Cost The amount spent, excluding ad credit or coupons used, in the currency of the ad account. | Field IDnet_cost |
Operation Status Campaign on/off status. ENABLE: on. DISABLE: off. | Field IDcampaign/operation_status |
Optimization Mode Optimization mode. Example values: CUSTOM for target ROI, NO_BID for maximum delivery. | Field IDproduct/bid_type |
Orders (SKU) The number of individual SKU orders completed during the GMV Max Campaign. | Field IDorders |
Product ad click rate Paid product clicks divided by total product views for the selected product; excludes LIVE; available from 2024-09-27. | Field IDproduct_click_rate |
Product ad clicks Total paid product clicks during the campaign for the selected product, excluding LIVE; available from 2024-09-27. | Field IDproduct_clicks |
Product ad impressions Total paid product views during the campaign for the selected product, excluding LIVE; available from 2024-09-27. | Field IDproduct_impressions |
Product Image URL Product image URL returned by the TikTok GMV Max product-level report. | Field IDproduct/product_image_url |
Product Name Product name returned by the TikTok GMV Max product-level report. | Field IDproduct/product_name |
Product SPU ID TikTok Shop product SPU identifier. | Field IDproduct/item_group_id |
Product Status Product status. Example values: available, unavailable. | Field IDproduct/product_status |
Quarter of the year Quarter of the year | Field ID_NORMALIZED_DATE_FIELD_QUARTER |
ROI The total return on investment (ROI) from all TikTok Shop orders attributed to your campaign. | Field IDroi |
Schedule End Time Schedule end time. Time zone: UTC+0. | Field IDcampaign/schedule_end_time |
Schedule Start Time Schedule start time. Time zone: UTC+0. | Field IDcampaign/schedule_start_time |
Schedule Type Schedule type. Continuously: To run the campaign continuously after the scheduled start time. | Field IDcampaign/schedule_type |
Shop ID Get the Shop ID. | Field IDadvertiser/shop_id |
Shop Name Get the Advertiser Name. | Field IDadvertiser/shop_name |
Signature (MD5) MD5 fingerprint of the video file. | Field IDcreative/signature |
Size (bytes) Video file size in bytes. | Field IDcreative/size |
Target ROI Target return on ad spend | Field IDroas_bid |
Target ROI Budget Target ROI budget | Field IDcampaign/target_roi_budget |
TikTok Post ID TikTok post identifier from the creative report; -1 denotes a product card. | Field IDitem_id |
Video Cover URL Temporary URL for the video cover. Valid for ~24 hours. The expiration is provided in the 'x-expires' query parameter (Unix timestamp in seconds). Once expired, call /campaign/gmv_max/info/ to obtain a new URL. | Field IDcreative/video_cover_url |
Video ID Video asset identifier when metadata is available; otherwise the TikTok post identifier. Empty for product cards. | Field IDcreative/video_id |
Video Preview URL Temporary preview URL for the video. Valid for ~6 hours. Once expired, call /campaign/gmv_max/info/ to obtain a new URL. | Field IDcreative/preview_url |
Week of the year Week of the year | Field ID_NORMALIZED_DATE_FIELD_WEEK |
Week of the year (start Sunday) Week of the year | Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY |
Width (px) Video width in pixels. | Field IDcreative/width |
Year Year such as 2017. | Field ID_NORMALIZED_DATE_FIELD_YEAR |
Year month Year and month. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH |
Year month day hour Year, month, day, and hour. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR |
Year Quarter Year and quarter. | Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER |
Year week Year and week. | Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK |
No matching fields
Try another search or reset your filters.
Explore destinations for your data
AI
Claude
Ask Claude about your Marketing data.
View connector
AI
ChatGPT
Ask ChatGPT about your Marketing data.
View connector
Spreadsheet
Excel
Easily track, report, and analyze your marketing KPIs in Excel.
View connector
Data lake
Azure Blob Storage
Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
View connector
Data lake
Google Cloud Storage
Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
View connector
Data lake
Amazon S3
Unlock effortless data storage and management for your marketing team with seamless transfers to Amazon S3, simplifying workflows and accelerating insights.
View connector
Data warehousing
Snowflake
Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
View connector
Data warehousing
Amazon Redshift
Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
View connector
Data warehousing
Azure SQL
Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
View connector
Data warehousing
PostgreSQL
Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
View connector
Data warehousing
MySQL
Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
View connector
Visualization
Tableau
Empower your marketing teams with seamless data transfer to Tableau.
View connector
Visualization
Power BI
Whether it's social media analytics, email marketing results, or PPC campaign data, Catchr bridges the gap. Export your data to Power BI.
View connector
Data warehousing
Big Query
Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
View connector
Visualization
Data Studio (formerly Looker Studio)
Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
View connector
Spreadsheet
Google Sheets
Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.
View connector