How do I load TikTok Ads data into my warehouse?
The TikTok Ads source exposes custom reports built from dimensions like campaign_id and stat_time_day with metrics such as clicks and cpc. ingestr lands them in your warehouse with one command.
Command
ingestr ingestDefined in
CLI
Works with
TikTok Ads to any ingestr destination
What you get
TikTok Business API sourcecustom dimension and metric reportsmulti-advertiser ingestion
How it works in code
$ ingestr ingest \
--source-uri 'tiktok://?access_token=token_123&advertiser_ids=0594720014,0594720015' \
--source-table 'custom:campaign_id,stat_time_day:clicks,cpc' \
--dest-uri $SNOWFLAKE_URI --dest-table 'tiktok_ads.campaign_metrics'Run ingestr ingest and ingestr loads the TikTok Ads data into your warehouse.
Related use cases
Load a specific source
Replicate a Postgres database into Snowflake
How do I replicate a Postgres database into Snowflake?
Load a specific sourceReplicate a database incrementally
How do I keep a database table in sync without full reloads (CDC-style)?
Load a specific sourceLoad Google Sheets into your warehouse
How do I load a Google Sheet into my warehouse?
Move data with one command
Open source. Source URI in, destination URI out, incremental by default.