Connect Rakuten Advertising to Google Data Studio with Windsor.ai

Directly connect Rakuten Advertising to Google Data Studio, in minutes, and in an easy-to-use format.

Connect Rakuten Advertising to Google Data Studio

All your marketing data in one place, just in a few clicks.

In just a few clicks, Windsor.ai integrates all of your marketing data. Simply select and authenticate the connectors you want to use. You don’t even need to write a single line of code to connect your data. You can blend and visualize your marketing data in your preferred reporting platform after a few minutes of setup.

Automate and save time.

No more using CSV dumps and spreadsheets to bring together data from different platforms. Windsor.ai automates collecting all marketing data and minimizes time spent on preparing and formatting, saving you a lot of time and boosting the quality of your reports.

Spend less time on manual data loading and spreadsheets. Focus on what matters: Growing your business!

Use all your data where and when you need it.

We make sure that all the data we integrate is fresh and accessible to marketers, whenever they want. You can push your data from Windsor.ai to a variety of data destinations, including cloud storage services (Google BigQuery, Amazon S3, Azure, Snowflake), data visualization tools (Google Data Studio, Power BI, Tableau), and spreadsheets (Excel, Google Sheets).

About Rakuten Advertising

Rakuten Advertising, formerly known as Rakuten Marketing, is an online advertising platform that offers a range of digital customer acquisition solutions to businesses that helps reach today’s consumers in personalized, powerful ways. Rakuten Advertising provides a variety of advertising services including affiliate marketing and performance marketing, delivering premium ad inventory, and consumer insights that enable businesses to connect with their target audience and drive sales. As a part of Rakuten Group, the company provides access to reach unique audiences of Rakuten Viber, Rakuten TV, and Rakuten Viki.

Learn more about Rakuten Advertising

About Google Data Studio

Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.

Learn more about Google Data Studio

About the Rakuten Advertising Google Data Studio Connector

The Rakuten Advertising Google Data Studio connector pulls metrics and dimensions from Rakuten Advertising. The insights are retrieved at the at an advertiser, publisher, product, and order level.

Once the user successfully logs into the connector it’s possible to choose the metrics and dimensions to create a report.

Prerequisites

To set up the connector, the user should have:

Access to a Rakuten Advertising account.
Google account for Rakuten Advertising to Google Data Studio integration.
A Windsor account. Start your free trial now.

(Visit our privacy policy and terms of use)

Why integrate Rakuten Advertising to Google Data Studio?

By integrating Rakuten Advertising with Google Data Studio, you can automate data collection and reporting, reducing the risk of errors that might be caused by manually pulling data and freeing up time for your marketing team to focus on other tasks.

Google Data Studio allows you to create customized dashboards and reports that help you monitor your key performance metrics such as Orders, Commissions, or Sales.

You can create customized dashboards and reports that can easily spot trends and patterns in your Rakuten Advertising data and optimize your campaigns for better performance and ROI.

Using Google Data Studio, you can compare the performance of different segments in your target audience and gain insights into your audience’s behavior and preference that can be used to refine your targeting strategies.

How to connect Rakuten Advertising to Google Data Studio?

Step 1: Select Rakuten Advertising as a Data Source and grant access to Windsor.ai.

You need to select Rakuten Advertising as a Data Source and grant access to Windsor.ai. You need to have a Report ID and API Token in order to have access to the report you wish to pull data for.

Windsor.ai Rakuten Advertising Onboarding Screen

Step 2: Select the fields on the right.

Select the fields on the right to later use in your data source. For example, you can include metrics such as Commission Status, Consumer Region, or Customer Score.

select fields on the right

Step 3: Select Google Data Studio as your destination.

Go to “Select Destination” and choose Google Data Studio.

Step 4: Connect and authorize access to your data source.

Once done, select “connect” and authorize access to your data source.

Connect Rakuten Advertising to Google Data Studio

Windsor.ai: All your marketing data in one place

Power up your marketing performance with result-driven marketing solutions

Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
The setup is done in minutes. No coding is required.
Currently, we support more than 3000 dimensions and metrics.
See the value and return on every marketing touchpoint.
Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.

Optimize marketing with attribution modelling

Google Data Studio Tutorials for Rakuten Advertising

Would you like to take your Google Data Studio Rakuten Advertising dashboards to the next level?

Here are some of our favorite tutorials to help you:

Available Rakuten Advertising Metrics and Dimensions

Name	Type	Description
Adjusted Commission	NUMERIC	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 is 3% from $0-$100 in sales but will be 6% for any sales over $100. Cumulative sales are calculated on a per-month basis and the additional commission is added (the difference between 3% and 6%) in the Adjusted Commission field. This value is populated only at the end of the month when the Publisher Invoices are generated.
Advertiser Name	TEXT	Select this column when running a report for more than one advertiser to see which row of data pertains to which advertiser.
Average Item Value	TEXT	The sum of your sales divided by the total number of items sold.
Average Order Value	NUMERIC	Total sales divided by the number of orders.
Baseline Commission	TEXT	The commission amount that is calculated before adjustments are made at the end of the month for tiered offers.
Booking Consumed Date	DATE	Often associated with the Travel vertical, this date is provided by the advertiser indicating when a reservation was fulfilled.
Browser	TEXT	The browser a consumer used when clicking your link.
Browser Major Version	TEXT	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.
Browser Name	TEXT	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.
Browser Version	TEXT	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.
Canceled Items	TEXT	The number of items canceled or returned in the selected date range.
Category ID	TEXT	The ID value of a particular category or service.
Click Date	DATE	This is the date that the first click or last click was recorded.
Click IP Address	TEXT	The IP address of the customer who clicked your link.
Click Position	TEXT	This reflects the point in the timeline that is credited with the commission.
Click-Through Rate (CTR)	TEXT	The number of clicks divided by the number of impressions.
Clicks	NUMERIC	The total number of clicks in the selected date range.
Commission Status	TEXT	The status indicates whether the commission for an order is approved, pending, or canceled. (Note: This is currently only used by the Brazil network.)
Commission Type	TEXT	This correlates with the advertiser's selection on the Create Offer form. The options are: % of Sale, $ per Action or Item, $ per Click, $ per 1,000 Impressions.
Commissioning List ID	TEXT	This is the alphanumeric ID associated with a Dynamic Commissioning list. The Commissioning List ID is created by our system. This field will be blank for advertisers not using Dynamic Commissioning.
Commissioning List Name	TEXT	This is the Dynamic Commissioning List applied to a transaction as part of the commissioning rules. Using the Commissioning List Name column allows for greater transparency into the status of Dynamic Commissioning offers. This field will be blank for advertisers not using Dynamic Commissioning.
Consumer City	TEXT	The city that the consumer was in when they clicked your link.
Consumer Connection Speed	TEXT	The consumer’s connection speed when they clicked your link.
Consumer Country	TEXT	The country the consumer was in when they clicked your link.
Consumer Region	TEXT	The region or state the consumer was in when they clicked your link.
Converting Site Name	TEXT	Advertisers may have one or more websites. This value is the site name identified by the advertiser as the site where the conversion took place.
Currency	TEXT	The currency that the reported transaction was in.
Customer Score	TEXT	The value, provided by the advertiser, that represents their rank of the customer.
Customer Status	TEXT	The status assigned by the advertiser to the consumer for a specific order. This is based on the customer's order history with the advertiser.
Date	DATE	Alias for Transaction Date.
Device	TEXT	The device a consumer used when clicking your link. For example, PC, Tablet, Phone.
Earnings Per Click (EPC)	TEXT	The total commissions generated divided by the number of clicks. Values multiplied by 100 for display purposes.
Gross Commissions	TEXT	This column gives you a total of all commissions (not including CPC commissions) without taking cancellations into account. It is calculated by adding the sum of all commissions with values greater than 0.
Gross Sales	NUMERIC	This column gives you a total of all sales without taking cancellations into account. It is calculated by adding the sum of all sales with values greater than 0, plus any sales marked as "Discounts." Note that Discounts have a value that is less than 0 but is considered to be part of Gross Sales because they are taken into account as part of the total sale price at checkout.
Gross Total Commissions	TEXT	This column gives you a total of all commissions (including CPC commissions) without taking cancellations into account. It is calculated by adding the sum of all commissions with values greater than 0.
Group Offer ID	TEXT	The Group Offer ID is a single number assigned by our system that connects the base commission, SKU lists, and commissioning rules for more complex offers.
Impressions	NUMERIC	The number of times an ad was served to customers from a publisher’s site.
In-Store Address	TEXT	An address provided by the advertiser for the in-store location of the purchase.
In-Store City	TEXT	The city, provided by the advertiser, for the in-store location of the purchase.
In-Store Country	TEXT	The country, provided by the advertiser, for the in-store location of the purchase.
In-Store ID	TEXT	An identifier assigned by the advertiser to the in-store location of the purchase.
In-Store Name	TEXT	The name assigned by the advertiser to the in-store location of the purchase.
In-Store State	TEXT	The state, or province provided by the advertiser, for the in-store location of the purchase.
In-Store Zip Code	TEXT	The zip code, provided by the advertiser, for the in-store location of the purchase.
Item Coupon Code	TEXT	The coupon code applied to an item, as defined by the advertiser. Multiple codes are separated by commas.
Item Coupon Code(s)	TEXT	The coupon code applied to an item, as defined by the advertiser. Multiple codes are separated by commas.
Item Discount Amount	TEXT	The amount discounted by the advertiser for an item in an order.
Quantity	NUMERIC	Similar to the # of Items column, Quantity is the number of items sold, excluding canceled items.
Items	TEXT	The number of items sold, including canceled items, in the selected date range.
Landing URL	TEXT	This is the URL of the page on the advertiser's site where the consumer lands after clicking the affiliate link on the publisher's site.
Link ID	TEXT	The unique ID number for a link.
Link Name	TEXT	The name assigned to a link by the advertiser.
Link Size	TEXT	The size of a banner, DRM, Flex Link, or other creative types. This does not apply to text links.
Link Type	TEXT	The creative type: Banner, Text, Flex Link, and more.
Member ID (u1)	TEXT	A field the publisher appends to the Rakuten Advertising affiliate link codes. For instance, a rewards or loyalty publisher can use this field to capture member information.
MID	TEXT	The identification number associated with an advertiser's account. Select this column when running a report for more than one advertiser to see which row of data pertains to which MID.
Mobile Operating System	TEXT	The operating system of the device a consumer used when clicking your link. For instance, iOS or Android.
Net Items	TEXT	The number of items you sold after canceled items are subtracted from the gross number of items.
Net Items Per Order	TEXT	The number of items you sold divided by the number of orders that were placed.
Network	TEXT	The Rakuten Advertising network the advertiser/transaction is part of.
Network ID	TEXT	The identification number of the advertiser network the advertiser/transaction is part of.
Non-Commissionable Items	NUMERIC	The number of items referred by a publisher that was deemed as non-commissionable based on the terms of the offer.
Non-Commissionable Order ID	TEXT	The Order ID for a non-commissionable transaction.
Non-Commissionable Reason	TEXT	The reason a transaction was non-commissionable. It may be that the product was not part of an offer, the return days were exceeded, or some other circumstance.
Non-Commissionable Sales	TEXT	The sale amount referred by a publisher that was deemed as non-commissionable based on the terms of the offer.
Offer Name	TEXT	The name given to an offer by an advertiser.
Offer Number	TEXT	The Offer Number is a sequential number assigned by our system to each base commission, SKU list, and commissioning rule.
Order Coupon Code(s)	TEXT	The coupon code applied to an order, as defined by the advertiser. Multiple codes are separated by commas.
Order Discount Amount	TEXT	The amount discounted by an advertiser for an order.
Order ID	TEXT	The ID of the order as reported by the advertiser.
Order Ship Date	DATE	Advertiser-defined value that would hold a date. Represents when the item is shipped (or expected to ship).
Order Status	TEXT	The status of the order, as defined by the advertiser.
Order Coupon Code	TEXT	The coupon code applied to an order by the advertiser. Multiple codes are separated by commas.
Orders	NUMERIC	The number of orders reported to Rakuten Advertising in the selected date range.
Orders/Click	TEXT	The number of orders divided by the number of clicks.
Orders/Clicks	NUMERIC	The number of orders divided by the number of clicks.
Process Date	DATE	The date the advertiser reported a transaction to us.
Process Day of Week	TEXT	The day of the week the advertiser reported a transaction to us.
Process Month	TEXT	The month the advertiser reported a transaction to us.
Process Month and Year	TEXT	The month and year the advertiser reported a transaction to us.
Process Month-Day	TEXT	The month and date the advertiser reported a transaction to us.
Process Time	TEXT	The time the advertiser reported a transaction to us.
Process Week Begin Date	DATE	The date for the beginning of the week, always a Sunday, that the advertiser reported a transaction to us.
Process Week End Date	DATE	The date for the end of the week, always a Saturday, that the advertiser reported a transaction to us.
Process Year	TEXT	The year the advertiser reported a transaction to us.
Product Brand	TEXT	The brand associated with the product or service, as defined by the advertiser.
Product Category 2	TEXT	The second category of the product or service, as defined by the advertiser.
Product Category 3	TEXT	The third category of the product or service, as defined by the advertiser.
Product Category 4	TEXT	The fourth category of the product or service, as defined by the advertiser.
Product Category 5	TEXT	The fifth category of the product or service, as defined by the advertiser.
Product Category ID	TEXT	The category ID of the product or service, as defined by the advertiser.
Product Category ID 2	TEXT	The second category level ID of the product or service, as defined by the advertiser.
Product Category ID 3	TEXT	The third category level ID of the product or service, as defined by the advertiser.
Product Category ID 4	TEXT	The fourth category level ID of the product or service, as defined by the advertiser.
Product Category ID 5	TEXT	The fifth category level ID of the product or service, as defined by the advertiser.
Product Name	TEXT	The name of the product sold.
Product Category	TEXT	The category of the product or service, as defined by the advertiser.
Publisher Name	TEXT	Publisher Name.
Referrer URL	TEXT	The URL of the publisher's site that referred a customer to the advertiser's site. This field is useful for investigating the source of traffic.
Sales	NUMERIC	Total sales in the selected period.
Ship-To Country	TEXT	The country, provided by the advertiser, for where the order will be shipped.
Signature Match Date	DATE	The date that our system matched the referring Signature information to a transaction.
Signature Match Time	TEXT	The time our system matched the referring Signature information to a transaction.
SKU	TEXT	The stock-keeping unit (SKU) number of the product sold.
Tax Exempt	TEXT	Some advertisers include tax within the Sales value. The Item Tax Exempt flag will be set to 'Y' by the advertiser to identify if the item is tax-exempt. The flag will be set to 'N' by the advertiser if the item is not tax-exempt.
Total Commission	TEXT	The sum of the baseline commission and adjusted commission.
Transaction Created On Date	DATE	The date of the referring clickthrough for a transaction. This date is reported by the advertiser.
Transaction Created On Time	TEXT	The time of the referring clickthrough for a transaction. This timestamp is reported by the advertiser.
Transaction Date	DATE	The date that a consumer completed a transaction.
Transaction Day of Week	TEXT	The day of the week a consumer completed a transaction.
Transaction ID	TEXT	A unique ID assigned to a transaction.
Transaction Month	TEXT	The month that a consumer created a transaction.
Transaction Month and Year	TEXT	The month and year when a consumer created a transaction.
Transaction Month-Day	TEXT	The month and date when a consumer created a transaction.
Transaction Time	TEXT	The time of day that a consumer completed a transaction.
Transaction Week Begin Date	DATE	The date of the beginning of the week, always a Sunday, that a consumer completed a transaction.
Transaction Week End Date	DATE	The date for the end of the week, always a Saturday, that a consumer completed a transaction.
Transaction Year	TEXT	The year that a consumer completed a transaction.