Productsets

column name:

• avgCpc: Cost per click - average cost for one click
• avgPos: Average position in display format
• campaign.id: Campaign's id
• campaign.name: Campaign's name
• campaign.totalClicks: Total clicks for campaign
• campaign.actualClicks: Actual clicks for campaign
• campaign.startDate: Campaign's start date
• campaign.endDate: Campaign's end date
• campaign.totalBudgetFrom: Date from which total money budget is counting.
• campaign.totalClicksFrom: Date from which total click budget is counting.
• campaign.createDate: Campaign's create date
• campaign.deleteDate: Campaign's Deletion date
• campaign.deleted: Is campaign deleted?
• clickMoney: money paid for clicks
• clicks: Number of clicks
• conversions: Number of conversions
• conversionValue: Value of conversions
• createDate: create date
• deleted: is product set deleted?
• deleteDate: ad's delete date
• group.id: Group's id
• group.name: Group's name
• group.deleted: Is group deleted?
• group.createDate: Group's create date
• group.deleteDate: Group's delete date
• group.maxCpc: maximum cpc for group's targeting
• group.maxCpt: maximum cpt(Cost per Thousand) for group's targeting
• id: product set id
• impressionMoney: money paid for impressions
• impressions: Number of impressions
• plaType: type name of PLA
• status: status of the ad(set by user)
• totalMoney: total money paid(for clicks and impressions)
• transactions: Number of transactions
• avgCpt: average Cost per thousand - cost per thousand impressions