Keywords

column name:

• cpc: equals maxCpc (is null when inherits settings from group)
• createDate: create date
• deleteDate: delete date
• deleted: is keyword deleted ?
• disabled: is keyword disabled ?
• id: keyword id
• matchTypeId: keyword's match type
• matchType: keyword's match type id
• name: keyword itself
• status: status
• statusId: status id
• url: keyword url
• 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
• campaign.id: Campaign's id
• campaign.totalBudgetFrom: Date from which total money budget is counting.
• campaign.exhaustedTotalBudget: Exhausted total budget
• campaign.totalBudget: Campaign total budget (if set; in halers)
• campaign.name: Campaign name
• campaign.totalClicks: Total allowed clicks for campaign
• campaign.actualClicks: Actual clicks
• campaign.totalClicksFrom: Date from which the total click budget is counted
• campaign.context: is it context campaign?
• campaign.contextNetwork: Name of targeted context networks
• campaign.fulltext: is it fulltext campaign?
• campaign.deleted: is campaign deleted ?
• campaign.deleteDate: Deletion date
• campaign.adSelection: Ad selection method
• campaign.adSelectionId: Ad selection method id
• campaign.paymentMethod: Payment method
• campaign.paymentMethodId: Payment method id
• campaign.startDate: Campaign start date
• campaign.endDate: Campaign end date
• campaign.createDate: create date
• campaign.automaticLocation: Is automatic location enabled.
• campaign.budgetId: Actual budget id
• campaign.defaultBudgetId: Default budget id.
• campaign.devicesPriceRatio: Specific ratio of max CPC/CPT for target device
• campaign.status: campaign status
• campaign.statusId: campaign status id
• avgCpc: Cost per click - average cost for one click
• avgPos: Average position in display format
• clickMoney: money paid for clicks
• clicks: Number of clicks
• conversions: Number of conversions
• conversionValue: Value of conversions
• impressionMoney: money paid for impressions
• impressions: Number of impressions
• totalMoney: total money paid(for clicks and impressions)
• transactions: Number of transactions
• missImpressions: missed impressions
• underLowerThreshold: missed impressions because of low cpc
• exhaustedBudget: missed impressions because of exhausted budget
• stoppedBySchedule: missed impressions because of campaign schedule
• underForestThreshold: missed impressions because of low relevancy
• exhaustedBudgetShare: missed impressions because of exhausted shared budget
• ctr: Click Through Rate
• pno: Cost Of Sale(COS)
• ish: not missed impressions percentage in fulltext network
• ishContext: not missed impressions percentage on context network
• ishSum: not missed impressions percentage in both networks
• isRegisteredBrand: keyword is registered brand
• isUnsuitable: keyword is unsuitable word
• isTooGeneric: keyword is too generic
• isGloballyDisabled: keyword is globally disabled word
• isTrademark: keyword is trademark
• isSuspicious: keyword is suspicious word