Advertiser data export file

Creating the URL

The URL required for creating an advertiser data export file is build up as following:

1 https://export.net.[domain]/[your_api_key]/adm-merchantexport_[user_ID].[file_extension]?[filters]

Once you have filled in your domain, your API key, your user ID and the relevant file extension and you have applied your filters, your URL should look more or less like this:

1 https://export-demonet.ingenioustech.biz/d1902f1e-b611-5fac-ac77-361d08461f98/adm-merchantexport_288.csv?products=true

By default your system-generated default API key is used in the export links.

Applying filters

For the advertiser data export file, following filters can be applied:

Filter description

Filter name

Compulsory

Format

Filter description

Filter name

Compulsory

Format

Allows you to import all data related to the product categories for the advertisers.

product_cat_data

Yes

Either use true to export the information, or use false to block.

These filters are to be added to the URL as parameters. Use the the question mark (?) for the first parameter and the ampersand (&) for all further parameters. Add the word filter, the filter name, the equals sign (=) and the relevant values according to the format mentioned in the table.

Output

The file you export via the URL you’ve created will contain the following data:

Name

Explanation

Example

Name

Explanation

Example

advertiser_ID

The ID of the advertiser you are exporting, corresponding with the MID (merchant ID) in the UI.

123

url

The main website of the advertiser.

http://www.shopping.com

name_native

The name of the advertiser in the language used on its website.

Shopping COM

regeln_landessprache

The URL where the terms and conditions in the native language of the advertiser are stored.

http://img.shopping.com/uploaded/dat…dessprache.pdf

status

The status of the advertiser. 1 means the advertiser is active; 2 means the advertiser is deactivated; 3 means the advertiser is deleted.

1

logo_url

The URL where the logo of the advertiser is stored.

http://img.shopping.com/uploaded/data/M13_logo.png

entity_ID

The ID of the so called entity, the legal body responsible for the payout of the partners, to which the advertiser is assigned.

 

name_english

The name of the advertiser in English.

16

cross_selling

Internal advertiser setting, the value should always be 1.

1

billing_mode

The billing mode of the advertiser.

no_billing

language

The ISO-3 language code representing the language used on the advertiser’s website.

ENG

email

The email address of the user responsible for the advertiser.

mmey@shopping.com

date_created

The time and date on which the basic settings for the advertiser were defined and the advertiser was created.

2013-05-10 13:25:04.567756+00

date_started

The time and date on which the status of the advertiser was set to active.

2013-05-10 13:25:04.567756+00

hidden

This value informs you whether the advertiser is visible for partners or not. 0 means the advertiser is visible for the partners, the values 1, 2 and 3 defines various hidden statuses. For more information, please read the article on the advertiser’s basic settings.

0

currency_iso3

The ISO 3 of the currency in which transactions for the advertiser are recorded.

EUR

country

The ISO 3166-1 codes code of the countries in which the advertiser is operating. Please note both the alpha 2 and the alpha 3 code will be included.

{LVA_LA}

key_account_manager

The ID of the platform user responsible for the program.

12

domain_list

The list of domains to which the advertiser is directing traffic coming from ad media items.

.shopping.

alias

The alias is the name used to identify your advertiser in tracking applications.

shopping

deposit_amount

The amount of money the advertiser has to pay to the network as a deposit. Please note this value is only relevant if prepayment is selected as a billing mode. In all other cases, the value will be 0.

10000

deposit_treshold

The treshold of the deposit the advertiser needs to pay. Please note this value is only relevant if prepayment is selected as a billing mode. In all other cases, the value will be 0.

2000

product_feed

This value informs you whether a product feed has been uploaded for the advertiser. 0 means it has not been activated, 1 means it has.

1

seo_tracking_mode

This value informs you whether SEO optimized tracking has been activated for the advertiser. 0 means it has not been activated, 1 means it has.

1

deeplink_enable

This value informs you whether or not a deeplink generator has been activated. 0 means it has not been activated, 1 means it has.

1

deeplink_admedia

If a deeplink generator has been activated, you will find the ID used to identify it in the ad media management and the reporting here.

1122

fallback_behavior

This value defines what will be done with traffic generated after the advertiser has been deactivated or deleted. The numbers represent the three options as discussed in the article on tracking settings.

2

fallback_image

If option 3 is selected as fallback behavior, you will find the image of the error message replacing the advertiser’s ad media.

http://marketing.net.shopping.com/images/onepixel.gif

fallback_url

If option 2 or 3 is selected as fallback behavior, you will find the URL where the traffic will be redirected here.

http://net.shopping.com/error_disabled.htmlf

trackdomain

The URL of the domain on which transactions generated for this advertiser are tracked.

http://marketing.net.shopping.com

category_label

The label of the advertiser’s category. Please note the value will be empty when the advertiser wasn’t categorized.

Fashion

category_type

The type of the advertiser’s category. Please note the value will be empty when the advertiser wasn’t categorized.

Purchase

category_id

The ID of the advertiser’s category. Please note the value will be empty when the advertiser wasn’t categorized.

21

subcategory_label

The label of the advertiser’s subcategory. Please note the value will be empty when the advertiser wasn’t categorized.

Men’s clothing

subcategory_type

The type of the advertiser’s subcategory. Please note the value will be empty when the advertiser wasn’t categorized.

Fashion

subcategory_id

The ID of the advertiser’s subcategory. Please note the value will be empty when the advertiser wasn’t categorized.

42

text_description_english

The description of the advertiser in English, aimed at partners.

Generate sales for Shopping.com and profit from the best commissions.

text_description_native

The description of the advertiser in the language used on the advertiser’s website, aimed at partners.

Générer des ventes pour Shopping.com et profiter des meilleures commissions.

labels

The labels given to the advertiser.

Fashion, men’s clothing, exclusive

entity_tax_office

The tax office of the entity to which the advertiser is allocated.

Tax office for cooperate organizations, Berlin.

entity_title

The name of the entity to which the advertiser is allocated.

Shopping.com Ltd.

If you apply the product category filter, you will be able to import all data related to the product categories for the advertisers. You will receive the same output as mentioned above, however ‘name_native’ and ‘name_english’ will display the names of your categories, in the language used on the website of the advertiser and English respectively.

Name

Explanation

Name

Explanation

productcategory_ID

The ID of the product category

productcategory_URL

The URL related to the product category. This can be a separate page, but it might also be the homepage of the advertiser.

end_date

The date on which the product category will no longer be valid. If the field is empty, this means there is not end date.

postclick_mode

This value defines the attribution model applied to the customer journey of conversions. LCW stands for “last click wins”; FCW stands for “first cookie wins”.

postclick_cookie_time

This value defines how many days a cookie placed after a click on an ad media will be taken into consideration when a conversion is assigned to partners.

postview_cookie_time

This value defines how many days a cookie placed after an ad media view will be taken into consideration when a conversion is assigned to partners.

postview_mode

This value defines whether post view tracking is activated or not. 0 means it is not activated, 1 means it is.

sem_permitted

This value defines whether search engine marketing is permitted to the partners who participate in the advertiser program.

product_url

This URL leads to a website with information on the product category, created by the advertiser.

hidden_mode

This value defines whether the product category is visible for partners. 0 means it is visible, 1 means is has been hidden.