Best Practices

Recommended setup

Start with the right report type

Choose your report type based on your analysis level (campaign, ad group, ad, or account). If you're unsure, start with "Basic campaign report" to understand overall performance, then dive into ad-level reports once you've identified underperformers.

Select multiple ad accounts in one data flow

If you manage multiple TikTok ad accounts, select all of them in a single data flow instead of creating separate flows. Include the "advertiser name" dimension to distinguish accounts in your export. Use Coupler.io's Aggregate transformation to roll up metrics across accounts.

Add only the metrics you need

TikTok's API is fastest when you request fewer metrics. Start with core metrics (impressions, clicks, spend, conversions, conversion rate). Add specialty metrics like video play rate or engagement only if you plan to analyze them.

Use date macros for automated date ranges

Instead of manually updating dates each month, use Coupler.io's date macros (like `{{previousMonth}}` or `{{30daysago}}`) to automatically pull rolling date ranges. This eliminates manual configuration and prevents gaps in your data.

Data refresh and scheduling

Schedule daily refreshes for early morning

TikTok's API completes data updates within 24 hours. Schedule your data flow to run at 6–8 AM in your time zone so you're pulling yesterday's complete data. Avoid running multiple flows simultaneously on the same account; space them 15 minutes apart.

Use append mode for historical data

If your spreadsheet already has old data, set the destination to "Append" mode (not "Replace"). Use the date picker to pull non-overlapping date ranges. Alternatively, use Coupler.io's Deduplicate feature to remove duplicates if you accidentally pull the same dates twice.

Monitor data flow runs in Coupler.io

Check your data flow logs weekly for failed runs. TikTok API errors are usually temporary; most resolve after 1–2 retries. If you see persistent failures, reconnect your TikTok account or reach out to Coupler.io support.

Performance optimization

Limit dimensions when possible

Each dimension you add increases the API query size. If you only need campaign-level data, don't add audience or asset dimensions. Conversely, if you need audience breakdown, use the "Audience" report type rather than adding country and interest dimensions to a basic report.

Split large datasets by time period

If you're pulling data for a full year or more, use the "Split data by period" option (daily or weekly) to break the export into smaller chunks. This reduces API query complexity and makes the spreadsheet easier to analyze.

Use filters for focused analysis

Apply advanced filters to exclude low-performing campaigns or specific ad accounts before export. This reduces file size and makes your destination spreadsheet less cluttered. For example, filter to campaigns with spend > $10/day.

Common pitfalls

Do

• Test with a manual run before scheduling

• Use date macros for rolling date ranges

• Include advertiser name when pulling multiple accounts

• Wait 24 hours before exporting to ensure data completeness

• Space multiple data flows 15 minutes apart to avoid rate limits

Don't

• Don't export today's data — it's incomplete until tomorrow

• Don't create separate data flows for each ad account; use one flow with multiple accounts selected

• Don't add unnecessary dimensions that inflate your spreadsheet

• Don't run multiple flows at the exact same time on the same TikTok account

• Don't panic if you see an API error; most resolve after a 15–30 minute wait

Avoid pulling data ranges that overlap. If you exported January 1–31 and then re-export January 15–31 in Append mode, you'll have duplicates. Use Coupler.io's Deduplicate transformation or delete the overlapping rows manually.