Open navigation

Rakuten Advertising connection guide

To connect your Rakuten Advertising data to Supermetrics, you first need to create a report in Rakuten Advertising itself that includes all the data you want to add to your reports. It'll give you the credentials you need to import that data with Supermetrics.


If you need to connect this data source to one of our data warehouse or cloud storage destinations, explore our prerequisite and filling guides.


Before you begin

First, create a report in Rakuten Advertising that includes all of the data you want to fetch with Supermetrics.


You can also use an existing report — if you'd rather do this, you can skip these steps and follow the instructions to get your report key and API token.


Create a report

  1. Log in to Rakuten Advertising.
  2. Navigate to Reports, and click Reporting.
  3. Select an existing report, or build a new one. We recommend selecting every column you want to use in Supermetrics (but bear in mind that reports with more columns will load more slowly).
  4. Adjust your report's settings — you can make further changes in Supermetrics once it's connected, too.
  5. Click Save.


Get your report key and API token

  1. Log in to Rakuten Advertising.
  2. Open the report you want to use with Supermetrics.
  3. Open the dropdown next to "View report".
  4. Click Get API.
  5. You'll see your report's API URL. This contains your report key and API token.
  6. Copy the text between /reprots/ and /filters in the URL. This is your report key. Save it in a safe place.
  7. Copy the text after &token=. This is your API key. Store it securely.

Example report token and API key

ran-reporting.rakutenmarketing.com/en/reports/[report-key]/filters?date_range=this-month&include_summary=Y&tz=GMT&date_type=transaction&token=[APITOKEN]


Instructions

For Excel users

If your team uses Supermetrics for Excel, you'll see different options for managing and sharing data source connections in that destination. Learn more.


Google Sheets Data StudioExcel

Make sure you've installed the Supermetrics add-on before you connect.

  1. Open a new Google Sheets file.
  2. Navigate to ExtensionsSupermetricsLaunch to open the Supermetrics sidebar.
  3. Click Create query.
  4. Under Data source, select Rakuten Advertising.
  5. Enter your report key and API token.
  6. Give this account a name — this can be anything that helps you distinguish this account from the others you use in Supermetrics.
  7. Click Start.

Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Google Sheets.


More resources

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.