QUANTI:
QUANTI:
  • DATA WAREHOUSES
    • Manage rights on GCP
  • CONNECTORS
    • Marketing connectors
      • Affilae
      • Awin
      • CJ
      • Criteo
      • Effinity
      • Email
      • Google Ads
      • Google Search Console
      • Google Sheets
      • Linkedin Ads
      • Meta Ads
      • Mailchimp
      • Microsoft Advertising
      • Rakuten Advertising
      • RTB House
      • Stylight
      • Tiktok
      • TimeOne
      • Wonderpush
    • Sales analytics connectors
      • Hubspot
    • Analytics connectors
      • Google Analytics 4
      • Piano Analytics
      • Piwik Pro
    • Reverse connectors
      • Adobe Analytics
      • Google Ads
  • TAG TRACKER
    • Tag setup
    • Tag data model
      • raw_hits
      • raw_sessions
      • advanced_attribution
    • Rules for calculated attribution
  • TRANSFORMATIONS
    • The principle of reconciliation
    • Pre-built tables
      • ads_import
      • ads_import_conv
      • quanti_ids
    • Tracking templates
Powered by GitBook
On this page
  • Prerequisites
  • Setup instructions
  • Create a Rakuten Report and find the generated link
  • Importante information
  • Finish Quanti: configuration
  • Pre-built Tables

Was this helpful?

Edit on GitHub
  1. CONNECTORS
  2. Marketing connectors

Rakuten Advertising

Follow our setup guide to connect Rakuten to QUANTI:

Last updated 26 days ago

Was this helpful?


Prerequisites

To connect Rakuten to QUANTI, you need an Rakuten Advertising account. In the last version of this connector, you cannot retrieve datas from any reports. You have to follow steps below including respect fields requested on the rakuten report.


Setup instructions

Create a Rakuten Report and find the generated link

  1. Log in to your Rakuten account.

  2. Click on tab Reporting < Statistics

    Access path to custom report tool

  3. Click on the button "+ Build a new report"

    Build a new report

  4. Click on button "Add and Remove columns" and add the only and entire list below :

    • Transaction Date

    • # of impressions

    • # of Clicks

    • # of orders

    • Gross Commissions

    • Total Commissions

    • Sales

    • Order ID

    • Sub-Publihser ID

    • Sub-Publisher Name

    • Sub-Publisher URL

    • Publisher Group ID

    • Publisher Group Name

    • Publisher ID

    • Publisher Name

    • Publisher URL

    • Offer ID

    • Offer Name

    • Link Id

    • Link Name

    "Add and Remove Columns" pop-in

  5. Near the blue button "View Report", click on the arrow and "Get API" and copy the url generated.

    Access path to the generated link

Importante information

If you have several Rakuten accounts and want to fill a unique table, you have to create several Rakuten connectors of course and especially respect the list's order and metrics's names. You can change the list order by moving column headings.

Finish Quanti: configuration

//ran-reporting.rakutenmarketing.com/en/reports/[<REPORT-KEY>]/filters?
date_range=this-month&include_summary=Y&tz=GMT&date_type=transaction&token=[<API-TOKEN>]
  1. In the connector setup form, enter the name of your choice.

  2. Paste the Report key from the URL generated.

  3. Paste the API token from the URL generated.

  4. Settings : In most cases, you will need use

    1. Date type : transaction

    2. Timezone : UTC

  5. Click Save & Test. Quanti: will take it from here and sync your Rakuten data.


Pre-built Tables

  • Affiliate report : Ad performance tracking with campaign metrics and attribution details


Pre-built tables and definition

Source :
🔗
Access path to custom report tool
Build a new report
"Add and Remove Columns" pop-in
Access path to the generated link
https://dbdiagram.io/e/68371607c07db17e778a23a0/68371711c07db17e778a5f0a
https://dbdiagram.io/e/65c0ca08ac844320ae7740d3/67a5e256263d6cf9a06049b8