Supermetrics for SFTP
Connect TikTok Ads to SFTP — Universal File Delivery
Land your TikTok Ads data in any SFTP server as structured files. Archive video performance metrics, feed custom pipelines, and build cross-platform analytics.
Why Connect TikTok Ads to SFTP?
Store your raw TikTok Ads data in SFTP for custom pipelines and full data ownership.
- Store video view rates, watch times, and engagement data on your SFTP server for long-term creative analysis and benchmarking.
- SFTP files integrate with Spark, cron job, cron, or any tool your data team uses.
- Combine TikTok with YouTube, Instagram, and Snapchat data on your SFTP server for unified short-form video analytics.
How to Connect TikTok Ads to SFTP
Three steps. Under two minutes. Zero code.
- 1
Create a data transfer
Log into Supermetrics, select TikTok Ads as your source and SFTP as your destination.
- 2
Configure your SFTP server
Enter your SFTP hostname, port, username, and password or SSH key. Choose the remote directory and file format for your data deliveries.
- 3
Set schedule and start transfer
Choose your delivery frequency (hourly, daily, or weekly) and click Start. Your TikTok Ads data begins arriving as structured files on your SFTP server.
TikTok Ads Data Format in SFTP
Supermetrics delivers your TikTok Ads data in clean, structured files ready for downstream processing.
Comma-separated values — universally compatible and easy to inspect.
Structured key-value format — ideal for programmatic consumption and API integration.
What to Build with TikTok Ads Data in SFTP
Once your TikTok Ads data lands in SFTP, here's what becomes possible.
Creative performance warehouse
Load TikTok creative data from your SFTP server into your database for historical creative performance analysis.
file-triggered alerting pipeline
Trigger automated scripts on new SFTP files to alert when CPA spikes or ROAS drops below target.
What TikTok Ads Data Can You Pull into SFTP?
Supermetrics gives SFTP access to your full TikTok Ads reporting data — metrics and dimensions you already know from the TikTok Ads interface.
Key Metrics
- Impressions
- Clicks
- Spend
- CTR
- CPC
- CPM
- Conversions
- CPA
- Cost per result
- Video views
- Result rate
- 2-second video views
- 6-second video views
- Average watch time
- Profile visits
Key Dimensions
- Campaign name
- Ad group name
- Ad name
- Placement
- Gender
- Country
- Operating system
- Ad format
- Objective type
- Optimization goal
- Creative type
Resources & Guides
TikTok ad campaigns: setup & optimization
PPC reporting: extract insights from paid campaigns
Why Supermetrics for SFTP?
Purpose-built for marketing data since 2009. 200,000+ companies trust Supermetrics to move 15% of global ad spend into reporting and analytics destinations.
No Vendor Lock-In
Your data lands in SFTP — infrastructure you own and control. Use any BI tool, any transformation layer, any ML platform. If you ever switch providers, your data and dashboards stay with you.
170+ Marketing Data Sources
Purpose-built for marketing data — not a generic ETL tool. Supermetrics covers 99% of metrics and dimensions from each source, with pre-structured tables ready for analysis. No transformation layer required.
Flexible File Formats
Export your TikTok Ads data as CSV, JSON, or Parquet. Choose the format that fits your downstream tools — whether that's a query engine, ML pipeline, or custom ETL.
Your Data, Your Infrastructure
Supermetrics moves data directly to your destination — nothing is stored on our servers. SOC 2 Type II certified, GDPR and CCPA compliant. Your data stays in infrastructure you control, simplifying privacy and compliance reviews.
Flat-Rate, Predictable Pricing
Fixed annual pricing regardless of data volume — no per-row charges, no surprise bills during peak campaign seasons. Transfer as much TikTok Ads data as you need without worrying about cost spikes.
No Data Limits
Query any date range, any number of campaigns, any level of granularity. No row limits, no sampling, no restrictions on the data you can pull.
Frequently Asked Questions
- Log into the Supermetrics Hub, create a new data transfer, select TikTok Ads as the source and SFTP as the destination. Enter your SFTP host, port, username, and password (or SSH key). Choose the remote directory, file format, and naming convention. Select your metrics and dimensions, set a schedule, and start the transfer. Supermetrics uploads structured files directly to your SFTP server on each scheduled run. Because SFTP is a standard protocol supported on every operating system — Linux, Windows, macOS, and any cloud VM — you can receive data on any server you already manage, with no proprietary agent or vendor SDK to install.
- SFTP (SSH File Transfer Protocol) encrypts both the authentication handshake and the entire data payload over an SSH tunnel, meaning your TikTok Ads data is never exposed in plain text during transit. Combined with Supermetrics' SOC 2 Type II certification and GDPR compliance, your data is protected end-to-end. For hardened security, use SSH key authentication instead of passwords, restrict the SFTP user to a chroot jail directory, disable password login entirely, and configure your firewall to allow connections only from Supermetrics' published IP ranges. Unlike cloud-proprietary transfer methods, SSH encryption is an open standard with decades of security auditing behind it.
- Yes. You can set up multiple Supermetrics transfers delivering TikTok Ads, Google Ads, LinkedIn Ads, and any other source to the same SFTP directory or organized into separate subdirectories on the same server. Because SFTP delivers plain files, your downstream workflow is entirely up to you: cron-scheduled shell scripts, Python or R pipelines, database LOAD DATA commands, or enterprise ETL tools can all pick up the files for unified processing. This file-based approach means zero vendor lock-in — if you ever change analytics platforms, your data is already in an open format. Supermetrics supports 170+ data sources, all deliverable to SFTP.
- All standard TikTok Ads reporting metrics and dimensions are available, including Impressions, Clicks, Spend, CTR, CPC, CPM, and more. You select exactly which fields to include during setup. Data arrives as structured files (CSV or JSON) in the directory you specify, ready for processing by any tool that reads files — no API client libraries or cloud SDKs needed. This makes SFTP the most universal delivery method: whether your downstream system is a MySQL LOAD DATA INFILE, an on-premise SAS installation, a legacy ERP file import, or a custom Python script, the data just works.
- Transfers can run hourly, daily, weekly, or monthly. Daily delivery is the most common setup. Each run uploads fresh files to your SFTP server, and you can match the delivery cadence with a cron job on your side: for example, schedule Supermetrics to deliver at 6 AM and your import script to run at 6:30 AM, so fresh TikTok Ads data is in your database before the team's morning standup. Because SFTP works with any server and any OS, you can run this workflow on a $5/month VPS or an enterprise data center — Supermetrics handles all the API complexity, and your server just receives clean, ready-to-process files.
- Yes. Supermetrics pulls all video metrics including 2-second views, 6-second views, average watch time, and completion rates — all delivered as structured files.
- Transfers run hourly, daily, weekly, or monthly. Daily is most common — yesterday's data arrives as clean files each morning.
Also Connect to SFTP
Ready to Connect TikTok Ads to SFTP?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.