Connect Shopee Ads to AI, Sheets, Databases & BI Tools
Windsor.ai's Shopee Ads connector extracts your Shopee Ads data and syncs it to AI assistants like ChatGPT, Claude and Gemini, spreadsheets like Google Sheets and Excel, data warehouses like BigQuery, Snowflake and PostgreSQL, and BI tools like Looker Studio, Power BI and Tableau. Setup takes a few minutes in the browser, no coding required, and you can start for free, no credit card required.
How to connect Shopee Ads to Windsor.ai
- Create your free Windsor.ai account or log in.
- Select Shopee Ads and grant Windsor.ai access to your Shopee Ads data.
- Pick the fields and date range you need and preview the data.
- Choose a destination and start syncing your Shopee Ads data.
Shopee Ads fields
Windsor.ai's Shopee Ads connector offers 46 fields, organized in 5 tables such as total_balance, cpc_ads_daily, product_campaigns, cpc_ads_hourly, recommended_items. Here are 30 of them:
-
Date (
date): The date of the record. -
Account Name (
account_name): The Shopee shop name. -
Clicks (
clicks): The total number of clicks on the ads. -
Impressions (
impressions): The number of times buyers saw the ads. -
CTR (
ctr): Click-through rate, calculated as clicks divided by impressions. -
Account ID (
account_id): The Shopee shop ID. -
Balance Timestamp (
balance_timestamp): The time of the balance snapshot. ISO 8601 datetime (UTC). -
Broad Conversion Rate (
broad_conversions): Broad orders divided by clicks. -
Campaign Ad Type (
campaign_ad_type): The campaign ad type, auto or manual. -
Hour (
hour): The hour of the day (0-23) of the hourly record. -
Item ID (
item_id): The recommended SKU item ID. -
Data fetched at (
data_fetched_at): UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that... -
Total Balance (
total_balance): The ads credit balance, including paid and free credits. -
Broad GMV (
broad_gmv): Sales from any shop item over the attribution window. -
Campaign ID (
campaign_id): The product campaign ID. -
Item Status List (
item_status_list): The item ads-eligibility statuses, comma-separated. -
Data Source (
datasource): The name of the Windsor connector returning the row -
Broad Items Sold (
broad_item_sold): Any shop items sold within 7 days of an ad click. -
Region (
region): The two-letter region code of the shop, for example ID. -
Ongoing Ad Type List (
ongoing_ad_type_list): The ongoing ad types on the item, comma-separated. -
Day of month (
day_of_month): Day of the month -
Broad Orders (
broad_order): Orders of any shop item within 7 days of an ad click. -
SKU Tag List (
sku_tag_list): The item tags such as best selling or best ROI, comma-separated. -
Month (
month): Number of the month -
Broad ROAS (
broad_roas): Broad GMV divided by expense. -
Now (
now): Current timestamp -
Cost Per Conversion (
cost_per_conversion): The average ad cost per sales conversion. -
Source (
source): The name of the Windsor connector returning the row -
Direct Conversion Rate (
direct_conversions): Direct orders divided by clicks. -
Today (
today): Today's date
Use Shopee Ads data in ChatGPT and Claude
Windsor.ai is available as a plugin in ChatGPT and as a connector in Claude. Once Shopee Ads is connected to Windsor.ai, you can ask questions about your Shopee Ads data in plain language. Other MCP clients can add the Windsor MCP server at https://mcp.windsor.ai/.
- How to connect your data to ChatGPT
- How to connect your data to Claude
- How to connect Windsor MCP to any MCP client
Available destinations for your Shopee Ads data
AI assistants
ChatGPT, Claude, Copilot, Manus, Gemini, Gemini Enterprise, Perplexity, Cursor, Grok, Google Antigravity, Lovable, n8n, Base44, Mistral, Kimi, DeepSeek, AI Insights (any MCP client)
Spreadsheets
Google Sheets, Excel, Airtable
Databases & warehouses
BigQuery, Snowflake, MySQL, PostgreSQL, Supabase, Azure SQL, Redshift, Databricks, Microsoft Fabric, Windsor.ai Cloud Database, Cache Data Store
BI & dashboards
Data Studio, Power BI Desktop: Native, Power BI Desktop: Web, Tableau
File storage
Amazon S3 Storage, Azure Blob Storage
Code
Python/R Code