Connect Rakuten Advertising to AI, Sheets, Databases & BI Tools

Windsor.ai's Rakuten Advertising connector extracts your Rakuten Advertising 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 Rakuten Advertising to Windsor.ai

  1. Create your free Windsor.ai account or log in.
  2. Select Rakuten Advertising and grant Windsor.ai access to your Rakuten Advertising data.
  3. Pick the fields and date range you need and preview the data.
  4. Choose a destination and start syncing your Rakuten Advertising data.

Rakuten Advertising fields

Windsor.ai's Rakuten Advertising connector offers 137 fields, organized in 1 tables such as Advertiser. Here are 30 of them:

  • Unique Transaction ID (transaction_id): A unique ID assigned to a transaction.
  • Sales (sales): Total sales in the selected period.
  • Date (date): Alias for Transaction Date.
  • Clicks (clicks): The total number of clicks in the selected date range.
  • Impressions (impressions): The number of times an ad was served to customers from a publisher’s site.
  • Device (device): The device a consumer used when clicking your link. For example, PC, Tablet, Phone.
  • Adjusted Commission (adjusted_commission): For tiered commission structures, this is the commission that is added to the baseline commission when a publisher reaches a certain level of sales. For example, an advertiser will set an offer that...
  • 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...
  • Advertiser Name (advertisername): Select this column when running a report for more than one advertiser to see which row of data pertains to which advertiser.
  • Data Source (datasource): The name of the Windsor connector returning the row
  • Average Item Value (average_item_value): The sum of your sales divided by the total number of items sold.
  • Day of month (day_of_month): Day of the month
  • Average Order Value (average_order_value): Total sales divided by the number of orders.
  • Month (month): Number of the month
  • Baseline Commission (baseline_commission): The commission amount that is calculated before adjustments are made at the end of the month for tiered offers.
  • Now (now): Current timestamp
  • Booking Consumed Date (booking_consumed_date): Often associated with the Travel vertical, this date is provided by the advertiser indicating when a reservation was fulfilled.
  • Source (source): The name of the Windsor connector returning the row
  • Browser (browser): The browser a consumer used when clicking your link.
  • Today (today): Today's date
  • Browser Major Version (browser_major_version): The major version of the browser a consumer used when clicking one of your links. For instance, if the browser is Firefox 20.0.1, this column will show 20.
  • Week (week): Week (Sun-Sat).
  • Browser Name (browser_name): The name of the browser a consumer used when clicking your link. For instance, if the browser is Firefox 20.0.1, this column will show Firefox.
  • Day of week and day number (week_day): Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
  • Browser Version (browserversion): The version of the browser a consumer used when clicking your link. For instance, if the browser is Firefox 20.0.1, this column will show 20.0.1.
  • Day of week and day number, ISO (week_day_iso): Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
  • Canceled Items (canceled_items): The number of items canceled or returned in the selected date range.
  • Week ISO (week_iso): Week, ISO format (Mon-Sun).
  • Category ID (category_id): The ID value of a particular category or service.
  • Year (year): Year

Use Rakuten Advertising data in ChatGPT and Claude

Windsor.ai is available as a plugin in ChatGPT and as a connector in Claude. Once Rakuten Advertising is connected to Windsor.ai, you can ask questions about your Rakuten Advertising data in plain language. Other MCP clients can add the Windsor MCP server at https://mcp.windsor.ai/.

Available destinations for your Rakuten Advertising 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

Popular connectors

Browse all 350+ connectors