# Tiktok Api User Popular Posts (`monumental_world/tiktok-api-user-popular-posts`) Actor

Instantly turn TikTok popular posts into an Excel or CSV report. No coding required—perfect for content creators analyzing viral trends and optimizing social media strategy.

- **URL**: https://apify.com/monumental\_world/tiktok-api-user-popular-posts.md
- **Developed by:** [Raised Pro](https://apify.com/monumental_world) (community)
- **Categories:** Social media, Automation, Other
- **Stats:** 2 total users, 0 monthly users, 100.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

from $1.50 / 1,000 results

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.
Since this Actor supports Apify Store discounts, the price gets lower the higher subscription plan you have.

Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event

## What's an Apify Actor?

Actors are web data automations that power AI and operations. They run on the Apify platform to scrape websites, process data, connect APIs, and automate workflows.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.
Actors are written with capital "A".

## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.
The best way to integrate Actors is as follows.

- **AI agents and MCP clients** — the [Apify MCP server](https://docs.apify.com/integrations/mcp.md) at `https://mcp.apify.com` (remote, streamable HTTP, OAuth on first use).
- **Agentic workflows and local Actor development** — [Agent Skills](https://apify.com/.well-known/agent-skills/index.json) with the [Apify CLI](https://docs.apify.com/cli/docs.md): `npm install -g apify-cli`, then `apify login`.
- **JavaScript/TypeScript projects** — the official [JS/TS client](https://docs.apify.com/api/client/js/docs.md): `npm install apify-client`.
- **Python projects** — the official [Python client](https://docs.apify.com/api/client/python/docs.md): `pip install apify-client`.
- **Any other language** — the [REST API](https://docs.apify.com/api/v2.md).

For usage examples, see the [API](#api) section below.

For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt).

# README

"# Tiktok User Popular Posts Export to Excel (Cookieless)

### Need to download TikTok data to Excel? This tool helps you extract popular posts without any login!

Whether you're a social media content creator, marketing agency, or business owner looking to analyze viral content trends, this tool makes it easy to export TikTok user data directly to Excel or CSV. No technical skills required, no cookies, and no TikTok account needed!

### Step-by-Step Guide

**Step 1:** Find the TikTok user's secure ID (secUid) from their profile URL. Don't worry—we'll explain how to find this below!

**Step 2:** Paste the secUid into the input field and click ""Start."" The tool will begin collecting the user's popular posts automatically.

**Step 3:** Download your data as Excel, CSV, or XML format. Open it in Excel, Google Sheets, or any spreadsheet program you prefer.

That's it! Your TikTok data is ready to analyze in just a few clicks.

### What columns will I get?

Your download will include the following columns:

- **Post URL** - Direct link to each TikTok post
- **Post Title** - The caption or title of the post
- **Author Username** - The TikTok creator's username
- **Post View Count** - Total number of views on the post
- **Social Shares Total** - How many times the post was shared
- **Engagement Rate** - Percentage showing how engaged viewers are
- **Time on Page (Seconds)** - Average time viewers spent watching
- **Bounce Rate Percentage** - How many viewers left quickly
- **Publish Date** - When the post was originally published
- **Comment Count** - Total number of comments
- **Conversion Rate** - Percentage of viewers who took action
- **Referral Source** - Where the traffic came from

### How to use this data

Here are three simple ways to put your exported TikTok data to work:

**1. Identify viral content patterns:** Sort your spreadsheet by view count and engagement rate to discover what types of posts perform best. Look for common themes, posting times, or content styles that consistently go viral.

**2. Optimize your content strategy:** Compare engagement rates across different post types to understand what resonates with audiences. Use this insight to create similar content that's more likely to succeed.

**3. Track competitor performance:** Export popular posts from competitors or influencers in your niche. Analyze their most successful content to stay ahead of trends and find content gaps you can fill.

### Input Settings

**TikTok Secure User ID (secUid):** This is a unique identifier for each TikTok user. You can find it in the user's profile URL or by inspecting their profile page. It looks like a long string of letters and numbers, for example: `MS4wLjABAAAAweT5e1AnkULNYxRo1gfcLrlbvOkIPd9fw9Yy9kEesgOaZxSSOYWagMFA4-pW1M-6`

Simply copy and paste this ID into the tool to get started. The tool will automatically fetch the user's most popular posts.

### Frequently Asked Questions

**Q: Do I need a TikTok account to use this tool?**

A: No! This tool works without any login or TikTok account. It's completely cookieless, so you can extract data anonymously.

**Q: Can I open this in Google Sheets?**

A: Yes! Just download the CSV file and upload it to Google Sheets. You can also open Excel files directly in Google Sheets by uploading them to Google Drive.

**Q: How many posts can I export?**

A: You can customize how many posts to export based on your needs. The tool will fetch the most popular posts from the user's profile.

**Q: Is this data updated in real-time?**

A: The tool fetches the most current data available at the time you run the export. For the latest metrics, simply run a new export whenever you need updated information.

***

*Related tools: instagram scraper, export instagram posts, instagram post extractor, popular posts scraper, social media data extractor, lead generation from social media, twitter post scraper, facebook post scraper*"

# Actor input Schema

## `secUid` (type: `string`):

TikTok secure user ID

## `maxItems` (type: `integer`):

Maximum number of items to fetch per page

## `maxPages` (type: `integer`):

Maximum number of pages to fetch (pagination handled automatically)

## Actor input object example

```json
{
  "secUid": "MS4wLjABAAAAqB08cUbXaDWqbD6MCga2RbGTuhfO2EsHayBYx08NDrN7IE3jQuRDNNN6YwyfH6_6",
  "maxItems": 35,
  "maxPages": 1
}
```

# API

You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.

## JavaScript example

```javascript
import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with your Apify API token
// Replace the '<YOUR_API_TOKEN>' with your token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {};

// Run the Actor and wait for it to finish
const run = await client.actor("monumental_world/tiktok-api-user-popular-posts").call(input);

// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
    console.dir(item);
});

// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

```

## Python example

```python
from apify_client import ApifyClient

# Initialize the ApifyClient with your Apify API token
# Replace '<YOUR_API_TOKEN>' with your token.
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = {}

# Run the Actor and wait for it to finish
run = client.actor("monumental_world/tiktok-api-user-popular-posts").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"])
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item)

# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

```

## CLI example

```bash
echo '{}' |
apify call monumental_world/tiktok-api-user-popular-posts --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "command": "npx",
            "args": [
                "mcp-remote",
                "https://mcp.apify.com/?tools=monumental_world/tiktok-api-user-popular-posts",
                "--header",
                "Authorization: Bearer <YOUR_API_TOKEN>"
            ]
        }
    }
}

```

## OpenAPI specification

Download the OpenAPI definition: https://api.apify.com/v2/actors/cYvMEAI6w9CVAdrXo/builds/YfaXuspoOXoe8cDNz/openapi.json
