Connect Rakuten to Snowflake

Rakuten Advertising Field Reference
+
snowflake

Stream your marketing data from Rakuten to Snowflake

Connect Rakuten to Snowflake in 2023

It is very simple to connect Rakuten to Snowflake, it can be done in a fast and easy manner with Windsor.ai.

 

First Step

Follow the Tutorial Below:

  1. Add all the columns that are returned by your connector’s URL. 
  2. Create the WINDSOR_UPLOAD role (name has no importance) 
  3. Create a user and add the previously created role to that user 
  4. Grant rights to the DATABASE to the created user 
  5. Grand the rights to the destination table 
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
  • Get the username 
  • Get the password 
  • Get the account 
  • Get the warehouse 
  • Get the database 
  • Get the schema 
  • Get the table name 

 

Second step

1. You need to select Rakuten as a Data Source and Grant Access to Windsor.ai.

Windsor.ai Rakuten Advertising Onboarding

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3. Enter all the credentials required and click Save

 

4. Your data will now be streamed from Rakuten to Snowflake. In case there is an error you will be notified.

Rakuten metrics and dimensions available for streaming into Snowflake

Connect your data

nametypedescription
Adjusted CommissionNUMERICFor 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 NameTEXTSelect this column when running a report for more than one advertiser to see which row of data pertains to which advertiser.
Average Item ValueTEXTThe sum of your sales divided by the total number of items sold.
Average Order ValueNUMERICTotal sales divided by the number of orders.
Baseline CommissionTEXTThe commission amount that is calculated before adjustments are made at the end of the month for tiered offers.
Booking Consumed DateDATEOften associated with the Travel vertical, this date is provided by the advertiser indicating when a reservation was fulfilled.
BrowserTEXTThe browser a consumer used when clicking your link.
Browser Major VersionTEXTThe 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 NameTEXTThe 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 VersionTEXTThe 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 ItemsTEXTThe number of items canceled or returned in the selected date range.
Category IDTEXTThe ID value of a particular category or service.
Click DateDATEThis is the date that the first click or last click was recorded.
Click IP AddressTEXTThe IP address of the customer who clicked your link.
Click PositionTEXTThis reflects the point in the timeline that is credited with the commission.
Click-Through Rate (CTR)TEXTThe number of clicks divided by the number of impressions.
ClicksNUMERICThe total number of clicks in the selected date range.
Commission StatusTEXTThe status indicates whether the commission for an order is approved, pending, or canceled. (Note: This is currently only used by the Brazil network.)
Commission TypeTEXTThis 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 IDTEXTThis 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 NameTEXTThis 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 CityCITYThe city that the consumer was in when they clicked your link.
Consumer Connection SpeedTEXTThe consumer’s connection speed when they clicked your link.
Consumer CountryCOUNTRYThe country the consumer was in when they clicked your link.
Consumer RegionREGIONThe region or state the consumer was in when they clicked your link.
Converting Site NameTEXTAdvertisers may have one or more websites. This value is the site name identified by the advertiser as the site where the conversion took place.
CurrencyTEXTThe currency that the reported transaction was in.
Customer ScoreTEXTThe value, provided by the advertiser, that represents their rank of the customer.
Customer StatusTEXTThe status assigned by the advertiser to the consumer for a specific order. This is based on the customer's order history with the advertiser.
DateDATEAlias for Transaction Date.
DeviceTEXTThe device a consumer used when clicking your link. For example, PC, Tablet, Phone.
Earnings Per Click (EPC)TEXTThe total commissions generated divided by the number of clicks. Values multiplied by 100 for display purposes.
Gross CommissionsTEXTThis 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 SalesNUMERICThis 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 CommissionsTEXTThis 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 IDTEXTThe 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.
ImpressionsNUMERICThe number of times an ad was served to customers from a publisher’s site.
In-Store AddressTEXTAn address provided by the advertiser for the in-store location of the purchase.
In-Store CityCITYThe city, provided by the advertiser, for the in-store location of the purchase.
In-Store CountryCOUNTRYThe country, provided by the advertiser, for the in-store location of the purchase.
In-Store IDTEXTAn identifier assigned by the advertiser to the in-store location of the purchase.
In-Store NameTEXTThe name assigned by the advertiser to the in-store location of the purchase.
In-Store StateTEXTThe state, or province provided by the advertiser, for the in-store location of the purchase.
In-Store Zip CodeTEXTThe zip code, provided by the advertiser, for the in-store location of the purchase.
Item Coupon CodeTEXTThe coupon code applied to an item, as defined by the advertiser. Multiple codes are separated by commas.
Item Coupon Code(s)TEXTThe coupon code applied to an item, as defined by the advertiser. Multiple codes are separated by commas.
Item Discount AmountNUMERICThe amount discounted by the advertiser for an item in an order.
QuantityNUMERICSimilar to the # of Items column, Quantity is the number of items sold, excluding canceled items.
ItemsTEXTThe number of items sold, including canceled items, in the selected date range.
Landing URLTEXTThis 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.
TEXTThe unique ID number for a link.
TEXTThe name assigned to a link by the advertiser.
TEXTThe size of a banner, DRM, Flex Link, or other creative types. This does not apply to text links.
TEXTThe creative type: Banner, Text, Flex Link, and more.
Member ID (u1)TEXTA 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.
MIDTEXTThe 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 SystemTEXTThe operating system of the device a consumer used when clicking your link. For instance, iOS or Android.
Net ItemsTEXTThe number of items you sold after canceled items are subtracted from the gross number of items.
Net Items Per OrderTEXTThe number of items you sold divided by the number of orders that were placed.
NetworkTEXTThe Rakuten Advertising network the advertiser/transaction is part of.
Network IDTEXTThe identification number of the advertiser network the advertiser/transaction is part of.
Non-Commissionable ItemsNUMERICThe number of items referred by a publisher that was deemed as non-commissionable based on the terms of the offer.
Non-Commissionable Order IDTEXTThe Order ID for a non-commissionable transaction.
Non-Commissionable ReasonTEXTThe 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 SalesTEXTThe sale amount referred by a publisher that was deemed as non-commissionable based on the terms of the offer.
Offer NameTEXTThe name given to an offer by an advertiser.
Offer NumberTEXTThe Offer Number is a sequential number assigned by our system to each base commission, SKU list, and commissioning rule.
Order Coupon Code(s)TEXTThe coupon code applied to an order, as defined by the advertiser. Multiple codes are separated by commas.
Order Discount AmountTEXTThe amount discounted by an advertiser for an order.
Order IDTEXTThe ID of the order as reported by the advertiser.
Order Ship DateDATEAdvertiser-defined value that would hold a date. Represents when the item is shipped (or expected to ship).
Order StatusTEXTThe status of the order, as defined by the advertiser.
Order Coupon CodeTEXTThe coupon code applied to an order by the advertiser. Multiple codes are separated by commas.
OrdersNUMERICThe number of orders reported to Rakuten Advertising in the selected date range.
Orders/ClickTEXTThe number of orders divided by the number of clicks.
Orders/ClicksNUMERICThe number of orders divided by the number of clicks.
Process DateDATEThe date the advertiser reported a transaction to us.
Process Day of WeekTEXTThe day of the week the advertiser reported a transaction to us.
Process MonthTEXTThe month the advertiser reported a transaction to us.
Process Month and YearTEXTThe month and year the advertiser reported a transaction to us.
Process Month-DayTEXTThe month and date the advertiser reported a transaction to us.
Process TimeTIMESTAMPThe time the advertiser reported a transaction to us.
Process Week Begin DateDATEThe date for the beginning of the week, always a Sunday, that the advertiser reported a transaction to us.
Process Week End DateDATEThe date for the end of the week, always a Saturday, that the advertiser reported a transaction to us.
Process YearTEXTThe year the advertiser reported a transaction to us.
Product BrandTEXTThe brand associated with the product or service, as defined by the advertiser.
Product Category 2TEXTThe second category of the product or service, as defined by the advertiser.
Product Category 3TEXTThe third category of the product or service, as defined by the advertiser.
Product Category 4TEXTThe fourth category of the product or service, as defined by the advertiser.
Product Category 5TEXTThe fifth category of the product or service, as defined by the advertiser.
Product Category IDTEXTThe category ID of the product or service, as defined by the advertiser.
Product Category ID 2TEXTThe second category level ID of the product or service, as defined by the advertiser.
Product Category ID 3TEXTThe third category level ID of the product or service, as defined by the advertiser.
Product Category ID 4TEXTThe fourth category level ID of the product or service, as defined by the advertiser.
Product Category ID 5TEXTThe fifth category level ID of the product or service, as defined by the advertiser.
Product NameTEXTThe name of the product sold.
Product CategoryTEXTThe category of the product or service, as defined by the advertiser.
Publisher NameTEXTPublisher Name.
Referrer URLTEXTThe 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.
SalesNUMERICTotal sales in the selected period.
Ship-To CountryCOUNTRYThe country, provided by the advertiser, for where the order will be shipped.
Signature Match DateDATEThe date that our system matched the referring Signature information to a transaction.
Signature Match TimeTIMESTAMPThe time our system matched the referring Signature information to a transaction.
SKUTEXTThe stock-keeping unit (SKU) number of the product sold.
Tax ExemptTEXTSome 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 CommissionTEXTThe sum of the baseline commission and adjusted commission.
Transaction Created On DateDATEThe date of the referring clickthrough for a transaction. This date is reported by the advertiser.
Transaction Created On TimeTIMESTAMPThe time of the referring clickthrough for a transaction. This timestamp is reported by the advertiser.
Transaction DateDATEThe date that a consumer completed a transaction.
Transaction Day of WeekTEXTThe day of the week a consumer completed a transaction.
Unique Transaction IDTEXTA unique ID assigned to a transaction.
Transaction MonthTEXTThe month that a consumer created a transaction.
Transaction Month and YearTEXTThe month and year when a consumer created a transaction.
Transaction Month-DayTEXTThe month and date when a consumer created a transaction.
Transaction TimeTIMESTAMPThe time of day that a consumer completed a transaction.
Transaction Week Begin DateDATEThe date of the beginning of the week, always a Sunday, that a consumer completed a transaction.
Transaction Week End DateDATEThe date for the end of the week, always a Saturday, that a consumer completed a transaction.
Transaction YearTEXTThe year that a consumer completed a transaction.
TodayDATEToday's date

Easily connect Rakuten to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Rakuten and Snowflake Integrations