Portal
1
Ads
2
Ads
3
Ads
4
Ads
5
Ads
6
Ads
7
Ads
8
Ads
9
Ads
10
Ads
11
Ads
12
Ads
13
Ads
14
Ads
15
Ads
16
Ads
17
Ads
18
Ads
19
Ads
20
Ads
21
Ads
22
Ads
23
Ads
24
Ads
25
Ads
26
Ads
27
Ads
28
Ads
29
Ads
30
Ads
31
Ads
32
Ads
33
Ads
34
Ads
35
Ads
36
Ads
37
Ads
38
Ads
39
Ads
40
Ads
41
Ads
42
Ads
43
Ads
44
Ads
45
Ads
46
Ads
47
Ads
48
Ads
49
Ads
50
Ads
Drag to adjust the number of frozen columns
Table
Columns In the Table
Data Type
Description
ads_sponsored_products_campaign_placement
_created_on
timestamp with time zone
Date the record was created
ads_sponsored_products_campaign_placement
_last_updated_on
timestamp with time zone
Date the record was last updated
ads_sponsored_products_campaign_placement
_partneruuid
character varying
Partner Unique Identifier
ads_sponsored_products_campaign_placement
_revision
integer
Number of times the record has changed
ads_sponsored_products_campaign_placement
_row_index
Integer
Row index
ads_sponsored_products_campaign_placement
1_day_advertised_sku_orders
Integer
Total number of skus that were purchased through the ad over a 1 day period
ads_sponsored_products_campaign_placement
1_day_advertised_sku_sales
Double Precision
Total value of sales occurring within 1 day of an ad click where the purchased SKU was the same as the SKU advertised.
ads_sponsored_products_campaign_placement
1_day_advertised_sku_units
Integer
Total number of advertised SKU units that were purchased through the ad over a 1 day period
ads_sponsored_products_campaign_placement
1_day_total_orders
Integer
Total number of orders that were purchased through the ad over a 1 day period
ads_sponsored_products_campaign_placement
1_day_total_sales
Double Precision
Total value of sales occurring within the past 1 day
ads_sponsored_products_campaign_placement
1_day_total_units
Integer
Total number of units that were purchased through the ad over a 1 day period
ads_sponsored_products_campaign_placement
7_day_advertised_sku_orders
Integer
Total number of skus that were purchased through the ad over a 7 day period
ads_sponsored_products_campaign_placement
7_day_advertised_sku_sales
Double Precision
Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised.
ads_sponsored_products_campaign_placement
7_day_advertised_sku_units
Integer
Total number of advertised SKU units that were purchased through the ad over a 7 day period
ads_sponsored_products_campaign_placement
7_day_total_orders
Integer
Total number of orders that were purchased through the ad over a 7 day period
ads_sponsored_products_campaign_placement
7_day_total_sales
Double Precision
Total value of sales occurring within the past 7 days
ads_sponsored_products_campaign_placement
7_day_total_units
Integer
Total number of units that were purchased through the ad over a 7 day period
ads_sponsored_products_campaign_placement
14_day_advertised_sku_orders
Integer
Total number of skus that were purchased through the ad over a 14 day period
ads_sponsored_products_campaign_placement
14_day_advertised_sku_sales
Double Precision
Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.
ads_sponsored_products_campaign_placement
14_day_advertised_sku_units
Integer
Total number of advertised SKU units that were purchased through the ad over a 14 day period
ads_sponsored_products_campaign_placement
14_day_total_orders
Integer
Total number of orders that were purchased through the ad over a 14 day period
ads_sponsored_products_campaign_placement
14_day_total_sales
Double Precision
Total value of sales occurring within the past 14 days
ads_sponsored_products_campaign_placement
14_day_total_units
Integer
Total number of units that were purchased through the ad over a 14 day period
ads_sponsored_products_campaign_placement
30_day_advertised_sku_orders
Integer
Total number of skus that were purchased through the ad over a 30 day period
ads_sponsored_products_campaign_placement
30_day_advertised_sku_sales
Double Precision
Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.
ads_sponsored_products_campaign_placement
30_day_advertised_sku_units
Integer
Total number of advertised SKU units that were purchased through the ad over a 30 day period
ads_sponsored_products_campaign_placement
30_day_total_orders
Integer
Total number of orders that were purchased through the ad over a 30 day period
ads_sponsored_products_campaign_placement
30_day_total_sales
Double Precision
Total value of sales occurring within the past 30 days
ads_sponsored_products_campaign_placement
30_day_total_units
Integer
Total number of units that were purchased through the ad over a 30 day period
ads_sponsored_products_campaign_placement
budget
Double Precision
Total budget allocated to the campaign.
ads_sponsored_products_campaign_placement
campaign_applicable_budget_rule_id
Character Varying
The ID associated to the active budget rule for a campaign.
ads_sponsored_products_campaign_placement
campaign_applicable_budget_rule_name
Character Varying
The name associated to the active budget rule for a campaign.
ads_sponsored_products_campaign_placement
campaign_bidding_strategy
Character Varying
The bidding strategy associated with a campaign.
ads_sponsored_products_campaign_placement
campaign_budget_type
Character Varying
One of daily or lifetime.
ads_sponsored_products_campaign_placement
campaign_id
Character Varying
The id of the advertising campaign
ads_sponsored_products_campaign_placement
campaign_name
Character Varying
Name of the advertising campaign
ads_sponsored_products_campaign_placement
campaign_rule_based_budget_amount
Double Precision
Total budget allocated to the campaign.
ads_sponsored_products_campaign_placement
click_thru_rate_ctr
Integer
Equals to clicks / impressions, number of people who click on your ad / number of people who have seen the ad
ads_sponsored_products_campaign_placement
clicks
Integer
Total number of clicks on an ad.
ads_sponsored_products_campaign_placement
cost_per_click_cpc
Double Precision
Total cost divided by total number of clicks.
ads_sponsored_products_campaign_placement
currency
Character Varying
The currency code associated with the campaign.
ads_sponsored_products_campaign_placement
date
timestamp with time zone
Date the ad is running
ads_sponsored_products_campaign_placement
id
Integer
Unique number assigned to every line in the table
ads_sponsored_products_campaign_placement
impressions
Integer
Total number of ad impressions.
ads_sponsored_products_campaign_placement
kindle_edition_normalized_pages_read_14d
Integer
Number of attributed Kindle edition normalized pages read within 14 days of ad click.
ads_sponsored_products_campaign_placement
kindle_edition_normalized_pages_royalties_14d
Double Precision
The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click.
ads_sponsored_products_campaign_placement
placement_type
Character Varying
The page location where an ad appeared.
ads_sponsored_products_campaign_placement
spend
Double Precision
Cost spent on the advertising campaign
ads_sponsored_products_campaign_placement
spend
Double Precision
Cost spent on the advertising campaign
ads_sponsored_products_campaign_placement
status
Character Varying
The status of your campaign
50 records
Summary
Summary
Summary
Summary
Summary
Alert
Lorem ipsum
Okay
View larger version
Download CSV