The Sponsored Ads data source provides access to all Sponsored Ads data (Campaigns, Search Terms, Keywords) and daily performance for the past 2 years. The data includes all campaign types like Sponsored Products, Sponsored Brands, and Sponsored Display campaigns. The data provided includes performance metrics at various levels like:

Account Overview

Account Id

ID of the Account

Account Name

Name of the account

Market Place ID

ID of the Geography

Currency

Currency of the Country

Account Type

Is it a Vendor account or Seller?

Ad Budget Current Month

Monthly Ad Budget for the account

Report Date

The reported date range

Spend

Ad spend for the entire account

Ad Revenue

Ad revenue for the entire account

Impressions

No. of impressions for the entire account

Clicks

No. of clicks for the entire account

Campaign Overview

Account Name

ID of the Account

Account Id

Name of the account

Market Place ID

ID of the Geography

Campaign Id

ID of the campaign

Campaign Name

Name of the campaign

Portfolio ID

ID of the portfolio

Portfolio Name

Name of the portfolio

Target ACOS

Target ACOS of the campaign

Campaign Type

Campaign Type(Sponsored Products, Sponsored Brands or Sponsored Display)

Campaign Status

Enable, paused, or archived status of the campaign

Bid Strategy

Bidding up, bidding down, or bidding up and down strategy

Budget

Budget for the campaign

Start Date

Start date for the campaign

End Date

End date for the campaign

Report Date

The reported date range

Impressions

No. of impressions for the campaign

Clicks

No. of clicks for the campaign

Spend

Ad spend for the campaign

Revenue

Ad revenue for the campaign

Orders

No. of the transaction by the customer

NTB Orders

New to brand/first-time orders

NTB Revenue

Revenue from new to brand/first-time orders

NTB Units Ordered

Units of New to brand/first time orders


Product Overview

Account Id

ID of the Account

Account Name

Name of the account

Market Place ID

ID of the Geography

Product

ASIN

SKU

SKU for the ASIN

Is Brand Type

Whether the product belongs to your own brand or to a competitor i.e. Non-Brand

Product Title

Title length for the product

Best Seller Rank

The Best Seller Rank for the ASIN

Title Length

Length of the ASIN Title on Amazon

Description Length

Length of the product description on Amazon

Features

No. of feature bullet points

A+ Pages

Pages with A+ Ratings

Images

No. of product images on the Amazon listing

Star Ratings

No. of customer ratings for the product

Available Quantity

The available quantity on Amazon

Rating counts

No. of customer reviews

Report Date

The reported date range

Spend

Ad spend for the product

Revenue

Ad revenue for the product

Impressions

No. of impressions for the product

Clicks

No. of clicks for the product

Orders

No. of the transaction by the customer

Ad Groups

Account Name

ID of the Account

Account Id

Name of the account

Market Place ID

ID of the Geography

Ad Group ID

ID of the ad group

Ad Group Name

Name of the ad group

Ad Group Status

Paused or Enable status of Ad group

Default Bid

Default bid at the ad group level

Campaign Id

ID of the campaign the ad group belongs to

Campaign Name

Name of the campaign the ad group belongs to

Campaign Status

Paused or Enable status of the campaign the ad group belongs to

Portfolio ID

ID of the portfolio the ad group belongs to

Portfolio Name

Name of the portfolio the ad group belongs to

Campaign Type

The campaign type for the campaign ad group belongs to

Report Date

The reported date range

Impressions

No. of impressions at the ad group level

Clicks

No. of clicks for the ad group

Spend

Ad spend for the ad group

Revenue

Ad revenue for the ad group

Orders

No. of the transaction by the customer at the ad group level

Search Terms

Account Name

ID of the Account

Account Id

Name of the account

Market Place ID

ID of the Geography

Search Term

The Search term generated from a target

Target

The target from which the search term was generated

Match Type

Whether it is an exact, phrase or broad match type

Is Brand Type (Yes/No)

Whether the search term belongs to your own brand or to a competitor i.e. Non-Brand

Product Title

Title length for the product

Ad Group ID

ID of the ad group the search term belongs to

Ad Group Name

Name of the ad group the search term belongs to

Ad Group Status

Paused or Enable status of Ad group the search term belongs to

Campaign Id

ID of the campaign the search term belongs to

Campaign Name

Name of the campaign, the search term belongs to

Portfolio ID

ID of the portfolio the search term belongs to

Portfolio Name

Name of the portfolio the search term belongs to

Campaign Type

Campaign Type(Sponsored Products, Sponsored Brands or Sponsored Display)

Campaign Status

Paused or Enable status of the campaign the search term belongs to

Impressions

No. of impressions for the search term

Clicks

No. of clicks for the search term

Spend

Ad spend for the search term

Revenue

Ad revenue for the search term

Orders

No. of the transaction by the customer related to the search term

Targets

Account Name

ID of the Account

Account Id

Name of the account

Market Place ID

ID of the Geography

Target ID

ID of the target

Target Type

Whether it is Keyword or Product Target)

Match Type

Whether it is an exact, phrase or broad match type

Product brand

Brand name of the target

Product price less than

Product price greater than

Is Brand Type (Yes/No)

Whether it is an exact, phrase or broad match type

Status

Paused or Enables status pf the target

Product Title

Title of the product target

Ad Group ID

ID of the ad group the search term belongs to

Ad Group Name

Name of the ad group the search term belongs to

Ad Group Status

Paused or Enable status of Ad group the search term belongs to

Campaign Id

ID of the campaign the search term belongs to

Campaign Name

Name of the campaign, the search term belongs to

Portfolio ID

ID of the portfolio the search term belongs to

Portfolio Name

Name of the portfolio the search term belongs to

Campaign Type

Paused or Enable status of the campaign the search term

Campaign Status

Paused or Enable status of the campaign the search term belongs to

Report Date

The reported date range

Impressions

No. of impressions for the target

Clicks

No. of clicks for the target

Spend

Ad spend for the target

Revenue

Ad revenue for the target

Orders

No. of the transaction by the customer related to the target

Label Structure

Campaign ID

ID of the campaign

Ad Group ID

ID of the ad group

Target ID

ID of the target

Product Ad ID

ID of the product

Label Performance

Account Name

Name of the account

Account Id

ID of the account

Market Place ID

ID of the geography

Label Name

Name of the Label

Label Type

Type of the Label

Campaign Type

Campaign Type(Sponsored Products, Sponsored Brands or Sponsored Display)

Report Date

The reported date range

Impressions

No. of impressions of the label

Clicks

No. of clicks of the label

Spend

Ad spend of the label

Revenue

Ad revenue of the label

Orders

No. of the transaction by the customer related to the label

Did this answer your question?