Account ID | | Field ID | account.accountId | | Type | NUMBER | | Data Type | dimension |
|
Account Name | | Field ID | account.accountName | | Type | TEXT | | Data Type | dimension |
|
Account Type | | Field ID | account.accountType | | Type | TEXT | | Data Type | dimension |
|
Account User Role | | Field ID | account.userRole | | Type | TEXT | | Data Type | dimension |
|
Advertiser ID | | Field ID | advertiser.advertiserId | | Type | NUMBER | | Data Type | dimension |
|
Advertiser Name | | Field ID | advertiser.advertiserName | | Type | TEXT | | Data Type | dimension |
|
Publisher ID | | Field ID | advertiser.publisherId | | Type | NUMBER | | Data Type | dimension |
|
Publisher Name | | Field ID | advertiser.publisherName | | Type | TEXT | | Data Type | dimension |
|
Transaction Campaign | | Field ID | transaction.campaign | | Type | TEXT | | Data Type | dimension |
|
Transaction ID | | Field ID | transaction.id | | Type | NUMBER | | Data Type | dimension |
|
Transaction Query ID | | Field ID | transaction.transactionQueryId | | Type | NUMBER | | Data Type | dimension |
|
Transaction Type | | Field ID | transaction.type | | Type | TEXT | | Data Type | dimension |
|
Transaction URL | | Field ID | transaction.url | | Type | TEXT | | Data Type | dimension |
|
Transaction Date And Time | | Field ID | transaction.transactionDateTime | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Transaction Date | | Field ID | transaction.transactionDate | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Transaction Decline Reason | | Field ID | transaction.declineReason | | Type | TEXT | | Data Type | dimension |
|
Transaction Voucher Code Used | | Field ID | transaction.voucherCodeUsed | | Type | BOOLEAN | | Data Type | dimension |
|
Transaction Voucher Code | | Field ID | transaction.voucherCode | | Type | TEXT | | Data Type | dimension |
|
Transaction Amended | | Field ID | transaction.amended | | Type | BOOLEAN | | Data Type | dimension |
|
Transaction Amend Reason | | Field ID | transaction.amendReason | | Type | TEXT | | Data Type | dimension |
|
Payment ID | | Field ID | transaction.paymentId | | Type | NUMBER | | Data Type | dimension |
|
Click Ref | | Field ID | transaction.clickRef | | Type | TEXT | | Data Type | dimension |
|
Click Date | | Field ID | transaction.clickDate | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Click Date And Time | | Field ID | transaction.clickDateTime | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Commission Status | | Field ID | transaction.commissionStatus | | Type | TEXT | | Data Type | dimension |
|
Order Ref | | Field ID | transaction.orderRef | | Type | TEXT | | Data Type | dimension |
|
Paid To Publisher | | Field ID | transaction.paidToPublisher | | Type | TEXT | | Data Type | dimension |
|
Transaction Lapse Time | | Field ID | lapseTime | | Type | NUMBER | | Data Type | metric |
|
Transaction Original Sale Amount | | Field ID | originalSaleAmount | | Type | NUMBER | | Data Type | metric |
|
Transaction Original Sale Currency | | Field ID | originalSaleAmount.currency | | Type | TEXT | | Data Type | dimension |
|
Transaction Old Commission Amount | | Field ID | oldCommissionAmount | | Type | NUMBER | | Data Type | metric |
|
Transaction Old Commission Currency | | Field ID | oldCommissionAmount.currency | | Type | TEXT | | Data Type | dimension |
|
Transaction Old Sale Amount | | Field ID | oldSaleAmount | | Type | NUMBER | | Data Type | metric |
|
Transaction Old Sale Currency | | Field ID | oldSaleAmount.currency | | Type | TEXT | | Data Type | dimension |
|
Transaction Sale Amount | | Field ID | saleAmount | | Type | NUMBER | | Data Type | metric |
|
Transaction Sale Currency | | Field ID | saleAmount.currency | | Type | TEXT | | Data Type | dimension |
|
Transaction Commission Amount | | Field ID | commissionAmount | | Type | NUMBER | | Data Type | metric |
|
Transaction Commission Currency | | Field ID | commissionAmount.currency | | Type | TEXT | | Data Type | dimension |
|
Creative ID | | Field ID | creative.creativeId | | Type | NUMBER | | Data Type | dimension |
|
Creative Name | | Field ID | creative.creativeName | | Type | TEXT | | Data Type | dimension |
|
Creative Tag Name | | Field ID | creative.tagName | | Type | TEXT | | Data Type | dimension |
|
Impressions | | Field ID | impressions | | Type | NUMBER | | Data Type | metric |
|
Clicks | | Field ID | clicks | | Type | NUMBER | | Data Type | metric |
|
Pending Transactions | | Field ID | pendingNo | | Type | NUMBER | | Data Type | metric |
|
Pending Value | | Field ID | pendingValue | | Type | NUMBER | | Data Type | metric |
|
Pending Commission | | Field ID | pendingComm | | Type | NUMBER | | Data Type | metric |
|
Confirmed Transactions | | Field ID | confirmedNo | | Type | NUMBER | | Data Type | metric |
|
Confirmed Value | | Field ID | confirmedValue | | Type | NUMBER | | Data Type | metric |
|
Confirmed Commission | | Field ID | confirmedComm | | Type | NUMBER | | Data Type | metric |
|
Bonus Transactions | | Field ID | bonusNo | | Type | NUMBER | | Data Type | metric |
|
Bonus Value | | Field ID | bonusValue | | Type | NUMBER | | Data Type | metric |
|
Bonus Commission | | Field ID | bonusComm | | Type | NUMBER | | Data Type | metric |
|
Total Transactions | | Field ID | totalNo | | Type | NUMBER | | Data Type | metric |
|
Total Value | | Field ID | totalValue | | Type | NUMBER | | Data Type | metric |
|
Total Commission | | Field ID | totalComm | | Type | NUMBER | | Data Type | metric |
|
Declined Transactions | | Field ID | declinedNo | | Type | NUMBER | | Data Type | metric |
|
Declined Value | | Field ID | declinedValue | | Type | NUMBER | | Data Type | metric |
|
Declined Commission | | Field ID | declinedComm | | Type | NUMBER | | Data Type | metric |
|
Region | | Field ID | region | | Type | TEXT | | Data Type | dimension |
|
Currency | | Field ID | currency | | Type | TEXT | | Data Type | dimension |
|
Campaign Campaign | | Field ID | campaign.campaign | | Type | TEXT | | Data Type | dimension |
|
Campaign Publisher Name Campaign Publisher Name | | Field ID | campaign.publisherName | | Type | TEXT | | Data Type | dimension |
|
Campaign Publisher Id Campaign Publisher Id | | Field ID | campaign.publisherId | | Type | TEXT | | Data Type | dimension |
|
Commission Amount Approved Commission Amount Approved | | Field ID | campaign.commissionAmount.approved | | Type | NUMBER | | Data Type | metric |
|
Commission Amount Bonus Commission Amount Bonus | | Field ID | campaign.commissionAmount.bonus | | Type | NUMBER | | Data Type | metric |
|
Commission Amount Declined Commission Amount Declined | | Field ID | campaign.commissionAmount.declined | | Type | NUMBER | | Data Type | metric |
|
Commission Amount Pending Commission Amount Pending | | Field ID | campaign.commissionAmount.pending | | Type | NUMBER | | Data Type | metric |
|
Commission Amount Commission Amount | | Field ID | campaign.commissionAmount.total | | Type | NUMBER | | Data Type | metric |
|
Transaction Approved Total Approved | | Field ID | campaign.quantity.approved | | Type | NUMBER | | Data Type | metric |
|
Transaction Bonus Total Bonus | | Field ID | campaign.quantity.bonus | | Type | NUMBER | | Data Type | metric |
|
Transaction Click Total Click | | Field ID | campaign.quantity.click | | Type | NUMBER | | Data Type | metric |
|
Transaction declined Total declined | | Field ID | campaign.quantity.declined | | Type | NUMBER | | Data Type | metric |
|
Transaction pending Total pending | | Field ID | campaign.quantity.pending | | Type | NUMBER | | Data Type | metric |
|
Total Transaction Total | | Field ID | campaign.quantity.total | | Type | NUMBER | | Data Type | metric |
|
Sale Amount Approved Total | | Field ID | campaign.saleAmount.approved | | Type | NUMBER | | Data Type | metric |
|
Sale Amount Bonus Total | | Field ID | campaign.saleAmount.bonus | | Type | NUMBER | | Data Type | metric |
|
Sale Amount Declined Total | | Field ID | campaign.saleAmount.declined | | Type | NUMBER | | Data Type | metric |
|
Sale Amount Pending Total | | Field ID | campaign.saleAmount.pending | | Type | NUMBER | | Data Type | metric |
|
Sale Amount Total | | Field ID | campaign.saleAmount.total | | Type | NUMBER | | Data Type | metric |
|
Year Year such as 2017. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR | | Type | YEAR | | Data Type | dimension |
|
Year Quarter Year and quarter. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_QUARTER | | Type | YEAR_QUARTER | | Data Type | dimension |
|
Year month Year and month. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH | | Type | YEAR_MONTH | | Data Type | dimension |
|
Year week Year and week. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_WEEK | | Type | YEAR_WEEK | | Data Type | dimension |
|
Date Year, month, and day. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Quarter of the year Quarter of the year | | Field ID | _NORMALIZED_DATE_FIELD_QUARTER | | Type | QUARTER | | Data Type | dimension |
|
Month of the year Month of the year | | Field ID | _NORMALIZED_DATE_FIELD_MONTH | | Type | MONTH | | Data Type | dimension |
|
Week of the year Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_WEEK | | Type | WEEK | | Data Type | dimension |
|
Month and day Month and day | | Field ID | _NORMALIZED_DATE_FIELD_MONTH_DAY | | Type | MONTH_DAY | | Data Type | dimension |
|
Day of the week Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_DAY_OF_WEEK | | Type | DAY_OF_WEEK | | Data Type | dimension |
|
Day of the month Day of the year | | Field ID | _NORMALIZED_DATE_FIELD_DAY | | Type | DAY | | Data Type | dimension |
|
Extracted Date The date where the extraction take times. | | Field ID | _catchr_date_extract | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Platform Name Return the platform name | | Field ID | _catchr_platform_name | | Type | TEXT | | Data Type | dimension |
|
.svg){kind=logo}