---
title: "Data Source - ValueCommerce"
slug: "data-source-valuecommerce"
updated: 2024-08-15T09:38:35Z
published: 2024-08-15T09:38:35Z
canonical: "documents.trocco.io/data-source-valuecommerce"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documents.trocco.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Source - ValueCommerce

## summary

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

## Obtainable data

Retrieve the following items from the **ValueCommerce API**

- **Affiliate Site**:. [List of detail (order detail information) fields](https://pub-docs.valuecommerce.ne.jp/docs/as-78-order-report-api/#detail%EF%BC%88%E6%B3%A8%E6%96%87%E8%A9%B3%E7%B4%B0%E6%83%85%E5%A0%B1%EF%BC%89%E3%83%95%E3%82%A3%E3%83%BC%E3%83%AB%E3%83%89%E4%B8%80%E8%A6%A7)
- **Advertisers**:. [response body](https://pub-docs.valuecommerce.ne.jp/docs/ec-75-order-report-api/#%E3%83%AC%E3%82%B9%E3%83%9D%E3%83%B3%E3%82%B9%E3%83%9C%E3%83%87%E3%82%A3%E3%83%BC)

Please note that the selection of the **affiliate site** or **advertiser** is done on the [Connection Configuration](/docs/connection-configuration-valuecommerce) side of [ValueCommerce](/docs/connection-configuration-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](/docs/connection-configuration-valuecommerce) 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) Dateclick dayOrdering DateOrder 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 ProgramEmail ProgramMobile ProgramIf 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 sitee-mail magazinemobileIf 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. |