Data Source - ValueCommerce

Prev Next

summary

This is the help page for ETL Configuration of ValueCommerce Data Settings.

Obtainable data

Retrieve the following items from the ValueCommerce API

Please note that the selection of the affiliate site or advertiser is done on the Connection Configuration side of ValueCommerce.

Setting items

STEP1 Basic settings

item name indispensable default value Contents
subject (of taxation, etc.) Yes affiliate site Select either the affiliate site or the advertiser.
Based on the results of this entry selection, the available Connection Configuration will be narrowed down.
ValueCommerce Connection Configuration Yes - Select the preregistered ValueCommerce Connection Configuration that has the necessary permissions for this ETL Configuration.
Data acquisition period Yes - Enter the start and end dates and specify the period for which data will be retrieved.
Also, select the base date for the acquisition period from the acquisition criteria.
  • Processing (Approval/Rejection) Date
  • click day
  • Ordering Date
  • Order data insertion date
    		•
    Restriction on data acquisition period
    • The data acquisition period ranges up to 6 months.
      • The difference between the end date and the start date should not be more than 6 months.
    • Data up to 25 months in the past can be obtained.
      • The start date must be a date within the last 25 months based on when the job was executed.

    If you select an affiliate site

    item name indispensable default value Contents
    Advertiser ID No - You can enter your advertiser ID.
    The retrieved data will be filtered based on the input.
    Advertiser Name No - You can enter the name of the advertiser.
    The retrieved data will be filtered based on the input.
    program ID No - You can enter your program ID.
    The retrieved data will be filtered based on the input.
    program-name No - You can enter a program name.
    The retrieved data will be filtered based on the input.
    Order ID No - You can enter your order ID.
    The retrieved data will be filtered based on the input.
    Point Parameters No - Point parameters can be entered.
    The retrieved data will be filtered based on the input.
    referrer No - You can enter referrers.
    The retrieved data will be filtered based on the input.
    Orders placed via published ads Yes include Select whether or not to include orders placed through the listed ads.
    Order via Value Point Club Yes include Select whether to include orders via the ValuePoint Club.
    Order via Dynamic LP Yes Exclusion. Select whether to encompass orders via dynamic LP via orders.
    Exclude is selected by default.

    Please select "Include" for either orders placed through****the listed ads or orders placed through the Value Point Club.

    STEP1 Detailed settings

    Click on Advanced Settings to display the configuration items.

    If you select an advertiser

    item name indispensable default value Contents
    program type No - You can enter the program type.
    The retrieved data will be filtered based on the input.
    The following inputs are supported.
  • Web Program
  • Email Program
  • Mobile Program
    • If you wish to specify multiple program types, please enter them separated by commas.
    program-name No - You can enter a program name.
    The retrieved data will be filtered based on the input.
    Affiliate Site Type No - You can enter the affiliate site type.
    The retrieved data will be filtered based on the input.
    The following inputs are supported.
  • Web site
  • e-mail magazine
  • mobile
    • If you wish to specify multiple affiliate site types, please enter them separated by commas.
    Affiliate Site Name No - You can enter the name of the affiliate site.
    The retrieved data will be filtered based on the input.