TikTok Ads Agent
This guide explains what the Tiktok + GSheet agent does, when to use it, what you need, and the exact steps to get value without jargon. It also covers how to use a Google Sheet as your source of truth, guardrails, and current limitations.
What this agent is
One workspace that puts your TikTok Ads account and source of truth data in a single place. It helps you monitor performance, find opportunities, and act on clear recommendations across account, campaign, ad group, and ad levels. You can also feed it a Google Sheet to join in margins, inventory, or any custom labels.
When to use it
- You need a single view of performance and budget pacing across campaigns and ad groups.
- You want to understand which videos and creatives are winning, and why.
- You want clean breakdowns by audience, placement, device, and time.
- You need fast, shareable charts and reports.
- You want to combine TikTok data with a Sheet that holds profit, stock, or funnel outcomes.
What you need before you start
- Access to the correct TikTok ad account.
- Optional Google Sheet for any extra data the agent should read. Share the Sheet by link with Viewer, Commenter, or Editor.
- Consistent naming for campaigns, ad groups, and ads. This reduces misclassification.
How to get started
-
Pick your TikTok ad account.
-
Choose the agent: “TikTok Ads Agent.”
-
Warm up the context.
- For account questions, run "Get details of {adaccountID}."
-
If you will use a Sheet, paste the link and name the tab and timeframe.
-
Ask your question in plain language. Examples are included under each capability.
Using a Google Sheet as source of truth
You can attach a Sheet to help the agent make better decisions.
What can you put in the Sheet
- Source of truth data points if any
- Lead quality or revenue realized by campaign or ad group
- Any unique labels when naming is inconsistent
- Any other structure data, that can help prism provide more nuanced analysis
If you want the agent to use external or offline data:
- Paste the Sheet link in chat with open sharing.
- Specify the timeframe and the tab to use.
- Ask questions about that data, or ask the agent to blend in with Tiktok Ads insights.
Tip: Keep column names clean and consistent. The fewer ambiguities, the faster the agent answers. You can follow this template (opens in a new tab) for reference.
Capabilities
Campaign performance and optimization
- Account overview for quick health checks, budget use, spend distribution, and ROI across campaigns.
- Campaign analysis with video engagement metrics and objective filters such as Traffic, Conversions, and Video Views.
- Budget efficiency and pacing across campaign types.
- Ad group deep dives with granular performance, audience segments, and bidding strategy effectiveness.
Example prompts
- “Show performance last 7 days vs prior 7 days by campaign, with ROAS, CPA, and spend.”
- “List ad groups that spent budget but delivered low video completion rates. Suggest fixes.”
- “Which campaigns are underpaced month to date versus plan. Propose daily budget moves.”
Creative performance intelligence
- Ad level analytics with video completion rates, engagement, and conversions.
- Creative fatigue monitoring to catch declines early.
- Guidance for A/B tests on hooks, length, captions, and CTAs.
- Works across image, video, and catalog or dynamic formats.
Example prompts
- “Rank the top 20 ads by ROAS in the last 30 days. Describe common patterns across winners.”
- “Flag ads with falling CTR week over week and recommend variants to test.”
Audience insights and targeting
- Audience performance by age, gender, location, interests, and behavior.
- Placement and platform split with efficiency scoring.
- Targeting configuration readouts for each ad group, including attribution settings and optimization goals.
- Keyword targeting read checks for search placements.
Example prompts
- “Break down ROAS and CPA by placement and recommend cuts or reallocations.”
- “Show which interest clusters have rising CPC and falling conversion rate.”
Search marketing optimization
- Keyword performance with search terms, match types, and CPC.
- Quality signals and bid efficiency indicators to focus spending.
- Shortlists of terms to scale or pause.
Example prompts
- “List keywords with spend over ₹25,000 and ROAS under 1 in the last 14 days. Propose actions.”
- “Find search terms with a strong completion rate and improve CPA week over week.”
Visual data analysis and reporting
- Line, bar, pie, and mixed charts from your data.
- Report builder that publishes to a shareable web URL.
- Custom dashboards that combine multiple metrics and timeframes.
Example prompts
- “Create a dashboard for ROAS, spend, and conversions by campaign for the last 30 days with week over week deltas.”
- “Create a report link that compares this month to last month by placement.”
Guardrails and tips
- Always state a timeframe and currency.
- Warm up account context before complex asks.
- When you paste a GSheet, name the tab and the key columns.
- Keep naming consistent. If you care about precise Prospecting vs Retargeting filters, give the agent a Sheet mapping.
- Prefer concrete asks. Example: “Flag ad groups over ₹X spend and ROAS under Y in the last Z days” is better than “Give me CPC for the account.”
Limitations and assumptions
- If creative files lack clear names or tags, the agent can still analyze performance and describe patterns, but recommendations will be broader.
- Reporting generator links reflect the current scope. If you change the audience or timeframe, regenerate the link.