Introduction

Datasources and destinations

Fields listing for Adtraction Advertising

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

14 metrics51 dimensions

65 fields

All fields
FieldDetails
Ad ID
Numerical ID of an ad
Field IDclick/adId
DimensionNUMBER
Ad Name
Name of banner or link
Field IDclick/adName
DimensionTEXT
Ad Type
Type of banner or link
Field IDclick/adType
DimensionTEXT
Average Order Value
Average order value, obtained by dividing order value by number of sale transactions
Field IDaov
MetricNUMBER
Channel Affiliate ID
Numerical ID of a partner account.
Field IDchannel/affiliateId
DimensionNUMBER
Channel Affiliate Name
Name of the partner. Individual or company.
Field IDchannel/affiliateName
DimensionTEXT
Channel Application Date
The date when the channel first applied to join your program.
Field IDchannel/applicationDate
DimensionYEAR_MONTH_DAY
Channel Approval Status
Approval status of a channel for a partner program: 0 = rejected, 1 = approved, 2 = pending review
Field IDchannel/approvalStatus
DimensionNUMBER
Channel Channel Type
The type of a channel, such as Blog, Content, Facebook, Cashback, etc.
Field IDchannel/channelType
DimensionTEXT
Channel Description
A description of a channel.
Field IDchannel/channelDescription
DimensionTEXT
Channel ID
Numerical ID of a channel.
Field IDchannel/channelId
DimensionNUMBER
Channel Name
Name of a channel.
Field IDchannel/channelName
DimensionTEXT
Channel Reject Reason
Available when approvalStatus is set to: 0. The reason for the program application being rejected, where: 0 = Not enough content/posts, 1 = Not relevant content, 2 = A closed site/group/account, 3 = 404 on site, 4 = Site does not exist, 5 = Wrong contact details / shady details, 6 = Unethical content, 7 = Incorrect site owner, 8 = Missing info about the channel. No URL/link, 9 = To few followers/visitors, 10 = Poor design, 11 = Traffic is not relevant. 12 = Outdated content
Field IDchannel/rejectReason
DimensionNUMBER
Channel Reject Reason Text
Available when approvalStatus is set to: 0. The reason for the program application being rejected.
Field IDchannel/reasonText
DimensionTEXT
Channel URL
The URL of a channel, if applicable.
Field IDchannel/channelUrl
DimensionTEXT
Click Date
UTC timestamp of the click that generated the transaction
Field IDclick/clickDate
DimensionYEAR_MONTH_DAY
Click Status
Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration.
Field IDclick/status
DimensionTEXT
Clicks
Number of clicks
Field IDclicks
MetricNUMBER
Commission
Amount of partner commission
Field IDcommission
MetricNUMBER
Conversion Ratio
Conversion Ratio, obtained by dividing sales by clicksUnique
Field IDconversionRatio
MetricNUMBER
Cost
The total cost of the transaction, including partner commission and platform fee
Field IDcost
MetricNUMBER
CTR
Click Through Ratio, obtained by dividing clicks by impressions
Field IDctr
MetricNUMBER
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
DimensionYEAR_MONTH_DAY
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
DimensionDAY
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
DimensionDAY_OF_WEEK
EPC
Earnings Per Click obtained by dividing the commission by clicksUnique
Field IDepc
MetricNUMBER
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
Impressions
Number of banner / links impressions
Field IDimpressions
MetricNUMBER
Lead Ratio
Lead Ratio, obtained by dividing leads by clicksUnique
Field IDleadRatio
MetricNUMBER
Leads
Number of lead transactions
Field IDleads
MetricNUMBER
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
DimensionMONTH_DAY
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
DimensionMONTH
Order Value
Order value of the sale transactions
Field IDorderValue
MetricNUMBER
Program Currency
Currency of the program
Field IDprogram/currency
DimensionTEXT
Program ID
Unique identifier of the program
Field IDprogram/programId
DimensionNUMBER
Program Market
Market of the program
Field IDprogram/market
DimensionTEXT
Program Name
Name of the program
Field IDprogram/programName
DimensionTEXT
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
Sales
Number of sale transactions
Field IDsales
MetricNUMBER
Segment ID
Numerical Adtraction ID of the segment
Field IDsegment/segmentId
DimensionNUMBER
Segment Name
The name of the segment
Field IDsegment/segmentName
DimensionTEXT
Transaction Auto Approval Date
Date when a pending transaction (transactionStatus = 2) will be automatically approved unless already approved or rejected.
Field IDtransaction/autoApprovalDate
DimensionYEAR_MONTH_DAY
Transaction Cost
The cost of the transaction, including partner commission and Adtraction platform fee.
Field IDtransaction/cost
DimensionNUMBER
Transaction Currency
Currency in ISO 4217 format
Field IDtransaction/currency
DimensionTEXT
Transaction Device
The type of device that was used to complete the transaction
Field IDtransaction/device
DimensionTEXT
Transaction Geo Location
The geographic market where the transaction was completed, defined by an ISO 3166-1 Alpha-2 country code
Field IDtransaction/geoLocation
DimensionTEXT
Transaction ID
Unique ID for the transaction
Field IDtransaction/uniqueId
DimensionTEXT
Transaction Last Updated
UTC timestamp of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated.
Field IDtransaction/lastUpdated
DimensionYEAR_MONTH_DAY
Transaction Name
Name of the transaction
Field IDtransaction/transactionName
DimensionTEXT
Transaction Operating System
The operating system used on the device that was used to complete the transaction
Field IDtransaction/operatingSystem
DimensionTEXT
Transaction Order ID
Advertiser order ID
Field IDtransaction/orderId
DimensionTEXT
Transaction Order Value
Order value of the transaction
Field IDtransaction/orderValue
DimensionNUMBER
Transaction Payment Status
Specifies what payment status of transaction should be included in the dataset. 1 = not invoiced, 2 = invoiced to advertiser, 3 = ready for payment, 4 = paid to partner
Field IDtransaction/paymentStatus
DimensionNUMBER
Transaction Reason Text
For rejected transactions (transactionStatus = 5) you may choose to provide the reason for the transaction being rejected.
Field IDtransaction/reasonText
DimensionTEXT
Transaction Status
The status of the transactions to be included in the dataset. Impressions and clicks are not affected by this input. 1 = approved, 2 = pending, 3 = approved + pending, 4 = open claims, 5 = rejected
Field IDtransaction/transactionStatus
DimensionNUMBER
Transaction Transaction Date
UTC timestamp of when the transaction was reported by the advertiser.
Field IDtransaction/transactionDate
DimensionYEAR_MONTH_DAY
Unique Clicks
Number of unique clicks
Field IDclicksUnique
MetricNUMBER
Unique Impressions
Number of unique banner / links impressions
Field IDimpressionsUnique
MetricNUMBER
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
DimensionWEEK
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
DimensionWEEK
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
DimensionYEAR
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
DimensionYEAR_MONTH
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
DimensionYEAR_MONTH_DAY_HOUR
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
DimensionYEAR_QUARTER
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
DimensionYEAR_WEEK

Explore destinations for your data

AI

Claude

Ask Claude about your Marketing data.
AI

ChatGPT

Ask ChatGPT about your Marketing data.
Spreadsheet

Excel

Easily track, report, and analyze your marketing KPIs in Excel.‍
Data lake

Azure Blob Storage

Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
Data lake

Google Cloud Storage

Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
Data lake

Amazon S3

Unlock effortless data storage and management for your marketing team with seamless transfers to Amazon S3, simplifying workflows and accelerating insights.
Data warehousing

Snowflake

Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
Data warehousing

Amazon Redshift

Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
Data warehousing

Azure SQL

Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
Data warehousing

PostgreSQL

Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
Data warehousing

MySQL

Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
Visualization

Tableau

Empower your marketing teams with seamless data transfer to Tableau.
Visualization

Power BI

Whether it's social media analytics, email marketing results, or PPC campaign data, Catchr bridges the gap. Export your data to Power BI.
Data warehousing

Big Query

Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
Visualization

Data Studio (formerly Looker Studio)

Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
Spreadsheet

Google Sheets

Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.