Standard Fields | Mobile Phones

aw_deep_link (nvarchar) - non-nullAWIN Generated Field

This is the 'tracked' version of the [merchant_deep_link] field. You should use this to ensure you receive commission for your clicks. Where a basket/deep link is unavailable, the product page link will automatically be substituted here.

product_name (nvarchar) - null

Describes the primary features of the deal being sold. If the price is a special affiliate-only or publisher exclusive price, this will also be described here.

aw_product_id (int) - non-nullAWIN Generated Field

Affiliate Window's unique product ID

merchant_product_id (int) - non-null

A unique ID linked to this deal. The unique ID persists from one feed to the next, including in most cases, when monthly or upfront prices change.

merchant_image_url (nvarchar) - non-null

A large (400x400 pixels) image of the primary product being sold.

Note: This image will have a white background. Should you want a large image with a transparent background, consider using the [large_image] field instead.

A note about images.

description (nvarchar) - non-null

The primary product's product description. Usually a paragraph or two long, and designed to act as an introduction to the product's main features and benefits for anyone browsing your product page.

Note: Where the [network] does not contain "No Network", this field should be consistently populated. Developers should not make assumptions about the availability or completeness of product descriptions under other circumstances.

merchant_category (nvarchar) - non-null

The primary product's product type appended with the contract type: e.g. "Mobile Phone - PAYM" or "Mobile Phone - PAYG". See the list of valid product types here.

search_price (nvarchar) - null

The deal's upfront price. This is a one-off price. See [store_price]. This field will always exclude any top-up amount that is associated with the deal. Please remember to check base_price_amount.

merchant_name (nvarchar) - non-nullAWIN Generated Field

The trading name of the merchant whose products are represented in this datafeed.

merchant_id (int) - non-nullAWIN Generated Field

A unique ID for the merchant mentioned above.

category_name (nvarchar) - non-nullAWIN Generated Field

Affiliate Window's product category for the primary product represented on any given row of the feed.

category_id (int) - non-nullAWIN Generated Field

Affiliate Window's product category id for the primary product represented on any given row of the feed.

aw_image_url (nvarchar) - non-nullAWIN Generated Field

A medium (200x200 pixels) image of the primary product being sold (served from Affiliate Window's servers).

Note: This image will have a white background. Should you want a large image (though larger, at 400x400 pixels) with a transparent background, consider using the [large_image] field instead.

A note about images.

currency (nvarchar) - non-null

The only currency currently supported is "GBP"

store_price (nvarchar) - null

This is the deal's upfront cost. The upfront cost usually relates to the purchase of a device with a contract (contracts on their own, for instance SIM-only will rarely if ever attract an upfront cost). This field will always exclude any top-up amount that is associated with the deal. Please remember to check base_price_amount.

Note: in some cases, the device and the linked contract can have separate monthly costs. Where this is the case, details can be found in the [deal_cost_json] field.

merchant_deep_link (nvarchar) - non-null

The merchant's untracked basket URL (or the 'deepest' URL available for this merchant). You should only use this URL if you plan on adding your own tracking links.

language (nvarchar) - non-null

Currently the only supported language is 'English'.

last_updated (nvarchar) - null

This is the date/time the deal described in this row was last imported by our systems. 

display_price (nvarchar) - null

This joins the [currency] and [store_price] fields together.

data_feed_id (int) - non-nullAWIN Generated Field

Affiliate Window's unique ID for the specific datafeed that any given row belongs to.

brand_name (nvarchar) - non-null

The primary product's branding. Note that this could be different from the manufacturer, so for instance a "Google Nexus 6" is branded "Google" but is manufactured by Motorola. Wherever possible we will specify the branding rather than the manufacturer. Similarly the "EE Kestrel" is manufactured by Huawei, but will be branded "EE" in our data.

brand_id (int) - non-nullAWIN Generated Field

Affiliate Window's unique ID for this brand

colour (nvarchar) - non-null

This is the device's "Colour Group". We use this for grouping or filtering, and as such the list of acceptable values here has been reduced to a sensible minimum. You won't find any "ruby red" or "sunset orange" style values here, just "red" and orange".

This data is repeated in the [device_features_json] field, along with a list of valid values.

The colour won't always be available (for SIM Cards, for instance). See Specifications and Features availability for more information.

product_short_description (nvarchar) - null

Finance plan description if deal is a finance deal.

specifications (nvarchar) - non-null

The primary product's specifications, represented as a name:value pair, with each specification separated by an asterisk. You can feel free to interpret this field programmatically as it will always remain structured in this way.

Note: Not all product types support the below fields. See Specifications and Features availability for more information.

Note: The below represents the total number of available fields. These will only be displayed where the relevant entry exists for the device being described, so if there's no GPS specification (for instance), you won't see a GPS entry.

condition (nvarchar) - null

Whether the primary device (i.e. not including free gifts) is "new" or "refurbished" (these are the only two valid values and will always appear lowercase). Note that some merchants or brands may prefer to have their products described differently (for instance EE prefer to use "Good as new" to describe refurbished products whereas Apple prefer "Refreshed". Where this is the case, you can find the appropriate brand-friendly representation in the [device_features_json] - condition_friendly field.

model_number (nvarchar) - null

This is the primary product's full name, excluding the manufacturer/branding. You can prefix the [brand_name] field to this field to construct a full product name.

dimensions (nvarchar) - non-null

The primary product's dimensions - always in the format "H x W x D mm". Dimensions are not always available for all product types (SIM Cards being one example). See Specifications and Features Availability for more information.

keywords (nvarchar) - null

This field will be populated with the word 'exclusive' in the case of affiliate channel or publisher exclusives.

promotional_text (nvarchar) - null

Any promotional text that relates to the deal (should any exist). It is expected that this text would be passed through as is and displayed on site. Often this text describes some important aspect of the deal and so it is important that it is displayed to consumers in order for them to be fully informed and improve both chances of click-through and ultimately conversion.

product_type (nvarchar) - non-null

Describes the type of deal (Consumer, Upgrade, Business, etc) to allow appropriate filtering.

saving (int) - null

Monthly saving in £ compared to the ‘regular’ price. When the regular price kicks in will depend on the detailed information found in [deal_discount_json].

savings_percent (int) - null

As per the saving field, but represented as a percentage reduction.

base_price (decimal) - null

Monthly price with discount applied.

NOTE: The discount may not persist for the duration of the contract. Please check the discount fields for further information on the nature of the discount. Expressed as a decimal.

base_price_amount (smallmoney) - null

If the deal is a pay-as-you-go deal, it will often require a mandatory top-up, which will be defined here as a decimal value.

NOTE: that increasingly, merchants like VOXI and giffgaff are selling what appear to be monthly contracts, but are in fact pay as you go tariffs with a recurring monthly payment set up by default. Care should therefore be taken to ensure that the contract_type is considered when deciding how to present pricing information for any given deal.

terms_of_contract (decimal) - null

If this device is sold on finance, and the APR is a fixed rate, it will be presented in this field as a decimal value.

in_stock (bit) - non-null

Contains 1 if in stock, otherwise 0.

is_for_sale (int) - non-null

This field will always be set to 1 (you can assume that if it appears in the feed, it's available for sale).

web_offer (nvarchar) - null

Note: The info that was usually available here has now moved to the [deal_promo_offer] field.

pre_order (bit) - non-null

Contains 1 if the the device is available for pre-order only, or 0 if the device has some other stock status (could be in stock or out of stock).

merchant_thumb_url (nvarchar) - non-null

A small (150x150 pixels) thumbnail image of the primary product being sold.

Note: This image will have a white background. Should you want an image with a transparent background, consider using the [alternate_image] field instead.

large_image (nvarchar) - non-null

The primary device's large image, 400x400 pixels with transparent background.

alternate_image (nvarchar) - non-null

The primary device's thumbnail image, 200x200 pixels with transparent background.

aw_thumb_url (nvarchar) - non-nullAWIN Generated Field

A very small (70x70 pixels) thumbnail image of the primary product being sold.

Note: This image will have a white background. Should you want a (slightly larger 150x150 pixels) thumbnail image with a transparent background, consider using the [alternate_image] field instead.

custom_1 (nvarchar) - null

Contains the retailer logo URL, to be used for linking out to their site or in comparison lists.

custom_2 (nvarchar) - null

Contains the URL for the Retailer's general terms and conditions page.

Note: that this differs from the Network's terms and conditions page found in [network_details_json].

custom_3 (nvarchar) - non-null

This contains the type of contract being sold to the customer. These values can be used to reliably filter/group tariffs. See Tariff Type for a list of valid values.

custom_4 (nvarchar) - non-null

Contains the URL for the primary device's product page on the merchant's website, where available. In most cases, the deeplink URL is better for conversion.

custom_5 (nvarchar) - non-null

Contains an asterisk-delimited list of cash discounts. These are broken down below:

• "Discount: " - Refers to a discount offered by the retailer (as opposed to a mobile network).

  Examples include Half Price Line Rental or Free Line Rental for a certain number of months.

• "Network Discount: " - Refers to a discount offered by the Mobile Network themselves. These discounts are usually automatically taken off the customer's monthly bill.

  Note: that a retailer discount and network discount could co-exist in the same deal (this hasn't happened recently, but was the case for a while with Orange deals sold via retailers like mobiles.co.uk).

• "Cashback: " - Really just another type of retailer discount, but generally expressed as a total £ value.

  "£100 cashback by redemption" or "£325 automatic cashback".

Notes

• Greater detail on these discounts is available in a structured format in the fields [deal_discounts_json] and [deal_cashback_json].
• This field should be ignored if the [network] field contains "No Network"
• The asterisk-delimited structure will exist even when there are no discounts or cashbacks available in the deal. In this case, output would look like this:

  Discount: None * Cashback: None * Network Discount: None

custom_6 (nvarchar) - non-null

Contains the Brand-friendly description for the Data Allowance. In all cases, this field will repeat what you see in [inc_data] while overriding any content that isn't On-Brand. You can therefore rely on this field for display purposes without having to check both fields, but always use the [inc_data] field for comparison/sorting/filtering.

Note: This is often a legal/compliance issue and it is thus important that this value is used in your presentation layer when engaging with customers. The underlying data allowance is still contained in the [inc_data] field and should still be used for comparison/sorting/filtering purposes.

custom_7 (nvarchar) - non-null

This field will contain the total monthly cost the customer can be expected to pay in month 1. In the case of Pay As You Go, this means the cost of the device finance payments (if any) plus the cost of the top-up. For Pay Monthly, this will be the total of any device finance and airtime payments, less any monthly cost discounts.

custom_8 (nvarchar) - null

This field will contain the merchant's internal SKU where this has been supplied by them. This can be useful in certain scenarios such as responding to on-page Javascript events that use the same SKU codes.

custom_9 (nvarchar) - null

The primary product's product type. See the list of valid product types here.

ean (int) - null

This field will contain the merchant-supplied GTIN/EAN where the merchant is able to supply one. Note that this field is entirely optional as not all merchants have access to this information. Products should instead be grouped using the parent_product_id field and other fields, as EAN/GTIN is rarely reliable for this purpose (even if all merchants were to supply it).

upc (int) - null

Unique Tariff ID which can be used to link the same tariff across multiple handsets or even retailers.

NOTE: An O2 Big Bundle sold by O2 will have the same ID as an O2 Big Bundle sold by mobiles.co.uk.

mpn (nvarchar) - null

Manufacturer Part Number, if known. This might be useful for display on-site as part of SEO or to provide additional information to customers.

parent_product_id (nvarchar) - non-null

This is a unique Product Edition ID. The "product edition" is the lowest level of the product hierarchy and describes a specific product being sold.

NOTE: in practice, the capacity and colour will act as the defining features of this edition (separating it from other editions under the same [product_version]), but in future other defining features could emerge.

(Apple iPhone 11) "256GB Black" or (Samsung Galaxy S10 Plus) "128GB Prism Green"

product_GTIN (int) - null

This field is identical to the EAN field and is provided for compatibility reasons.

basket_link (nvarchar) - null

This will contain only basket links. Unlike the [aw_deep_link] field described earlier, product page links won't be substituted in where basket links are unavailable.