Introduction
Datasources and destinations
- Find all the data sources available at www.catchr.io/connectors
- Find all the destinations available at www.catchr.io/destinations
EXPLORE YOUR DATA
Metrics & dimensions
Find the fields you need for your next report.
39 metrics54 dimensions
Reports: Default : AdvertiserCampaignCreativeTransaction
93 fields
| Field | Details | Available in reports |
|---|---|---|
Account ID | Field IDaccount.accountId | Default : Advertiser Campaign Creative Transaction |
Account Name | Field IDaccount.accountName | Default : Advertiser Campaign Creative Transaction |
Account Type | Field IDaccount.accountType | Default : Advertiser Campaign Creative Transaction |
Account User Role | Field IDaccount.userRole | Default : Advertiser Campaign Creative Transaction |
Advertiser ID | Field IDadvertiser.advertiserId | Default : Advertiser Campaign Creative Transaction |
Advertiser Name | Field IDadvertiser.advertiserName | Default : Advertiser Campaign Creative Transaction |
Bonus Commission | Field IDbonusComm | Default : Advertiser Creative |
Bonus Transactions | Field IDbonusNo | Default : Advertiser Creative |
Bonus Value | Field IDbonusValue | Default : Advertiser Creative |
Campaign Campaign | Field IDcampaign.campaign | Campaign |
Campaign Publisher Id Campaign Publisher Id | Field IDcampaign.publisherId | Campaign |
Campaign Publisher Name Campaign Publisher Name | Field IDcampaign.publisherName | Campaign |
Click Date | Field IDtransaction.clickDate | Transaction |
Click Date And Time | Field IDtransaction.clickDateTime | Transaction |
Click Ref | Field IDtransaction.clickRef | Transaction |
Clicks | Field IDclicks | Default : Advertiser Creative |
Commission Amount Commission Amount | Field IDcampaign.commissionAmount.total | Campaign |
Commission Amount Approved Commission Amount Approved | Field IDcampaign.commissionAmount.approved | Campaign |
Commission Amount Bonus Commission Amount Bonus | Field IDcampaign.commissionAmount.bonus | Campaign |
Commission Amount Declined Commission Amount Declined | Field IDcampaign.commissionAmount.declined | Campaign |
Commission Amount Pending Commission Amount Pending | Field IDcampaign.commissionAmount.pending | Campaign |
Commission Status | Field IDtransaction.commissionStatus | Transaction |
Confirmed Commission | Field IDconfirmedComm | Default : Advertiser Creative |
Confirmed Transactions | Field IDconfirmedNo | Default : Advertiser Creative |
Confirmed Value | Field IDconfirmedValue | Default : Advertiser Creative |
Creative ID | Field IDcreative.creativeId | Default : Advertiser Campaign Creative Transaction |
Creative Name | Field IDcreative.creativeName | Default : Advertiser Campaign Creative Transaction |
Creative Tag Name | Field IDcreative.tagName | Default : Advertiser Campaign Creative Transaction |
Currency | Field IDcurrency | Default : Advertiser Campaign Creative Transaction |
Date Year, month, and day. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY | Default : Advertiser Campaign Creative Transaction |
Day of the month Day of the year | Field ID_NORMALIZED_DATE_FIELD_DAY | Default : Advertiser Campaign Creative Transaction |
Day of the week Week of the year | Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK | Default : Advertiser Campaign Creative Transaction |
Declined Commission | Field IDdeclinedComm | Default : Advertiser Creative |
Declined Transactions | Field IDdeclinedNo | Default : Advertiser Creative |
Declined Value | Field IDdeclinedValue | Default : Advertiser Creative |
Hour of the day Hour of the day | Field ID_NORMALIZED_DATE_FIELD_HOUR | No listed report |
Impressions | Field IDimpressions | Default : Advertiser Creative |
Month and day Month and day | Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY | Default : Advertiser Campaign Creative Transaction |
Month of the year Month of the year | Field ID_NORMALIZED_DATE_FIELD_MONTH | Default : Advertiser Campaign Creative Transaction |
Order Ref | Field IDtransaction.orderRef | Transaction |
Paid To Publisher | Field IDtransaction.paidToPublisher | Transaction |
Payment ID | Field IDtransaction.paymentId | Transaction |
Pending Commission | Field IDpendingComm | Default : Advertiser Creative |
Pending Transactions | Field IDpendingNo | Default : Advertiser Creative |
Pending Value | Field IDpendingValue | Default : Advertiser Creative |
Publisher ID | Field IDadvertiser.publisherId | Default : Advertiser Campaign Creative Transaction |
Publisher Name | Field IDadvertiser.publisherName | Default : Advertiser Campaign Creative Transaction |
Quarter of the year Quarter of the year | Field ID_NORMALIZED_DATE_FIELD_QUARTER | Default : Advertiser Campaign Creative Transaction |
Region | Field IDregion | Default : Advertiser Campaign Creative Transaction |
Sale Amount Total | Field IDcampaign.saleAmount.total | Campaign |
Sale Amount Approved Total | Field IDcampaign.saleAmount.approved | Campaign |
Sale Amount Bonus Total | Field IDcampaign.saleAmount.bonus | Campaign |
Sale Amount Declined Total | Field IDcampaign.saleAmount.declined | Campaign |
Sale Amount Pending Total | Field IDcampaign.saleAmount.pending | Campaign |
Total Commission | Field IDtotalComm | Default : Advertiser Creative |
Total Transaction Total | Field IDcampaign.quantity.total | Campaign |
Total Transactions | Field IDtotalNo | Default : Advertiser Creative |
Total Value | Field IDtotalValue | Default : Advertiser Creative |
Transaction Amend Reason | Field IDtransaction.amendReason | Transaction |
Transaction Amended | Field IDtransaction.amended | Transaction |
Transaction Approved Total Approved | Field IDcampaign.quantity.approved | Campaign |
Transaction Bonus Total Bonus | Field IDcampaign.quantity.bonus | Campaign |
Transaction Campaign | Field IDtransaction.campaign | Transaction |
Transaction Click Total Click | Field IDcampaign.quantity.click | Campaign |
Transaction Commission Amount | Field IDcommissionAmount | Transaction |
Transaction Commission Currency | Field IDcommissionAmount.currency | Transaction |
Transaction Date | Field IDtransaction.transactionDate | Transaction |
Transaction Date And Time | Field IDtransaction.transactionDateTime | Transaction |
Transaction Decline Reason | Field IDtransaction.declineReason | Transaction |
Transaction declined Total declined | Field IDcampaign.quantity.declined | Campaign |
Transaction ID | Field IDtransaction.id | Transaction |
Transaction Lapse Time | Field IDlapseTime | Transaction |
Transaction Old Commission Amount | Field IDoldCommissionAmount | Transaction |
Transaction Old Commission Currency | Field IDoldCommissionAmount.currency | Transaction |
Transaction Old Sale Amount | Field IDoldSaleAmount | Transaction |
Transaction Old Sale Currency | Field IDoldSaleAmount.currency | Transaction |
Transaction Original Sale Amount | Field IDoriginalSaleAmount | Transaction |
Transaction Original Sale Currency | Field IDoriginalSaleAmount.currency | Transaction |
Transaction pending Total pending | Field IDcampaign.quantity.pending | Campaign |
Transaction Query ID | Field IDtransaction.transactionQueryId | Transaction |
Transaction Sale Amount | Field IDsaleAmount | Transaction |
Transaction Sale Currency | Field IDsaleAmount.currency | Transaction |
Transaction Type | Field IDtransaction.type | Transaction |
Transaction URL | Field IDtransaction.url | Transaction |
Transaction Voucher Code | Field IDtransaction.voucherCode | Transaction |
Transaction Voucher Code Used | Field IDtransaction.voucherCodeUsed | Transaction |
Week of the year Week of the year | Field ID_NORMALIZED_DATE_FIELD_WEEK | Default : Advertiser Campaign Creative Transaction |
Week of the year (start Sunday) Week of the year | Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY | No listed report |
Year Year such as 2017. | Field ID_NORMALIZED_DATE_FIELD_YEAR | Default : Advertiser Campaign Creative Transaction |
Year month Year and month. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH | Default : Advertiser Campaign Creative Transaction |
Year month day hour Year, month, day, and hour. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR | No listed report |
Year Quarter Year and quarter. | Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER | Default : Advertiser Campaign Creative Transaction |
Year week Year and week. | Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK | Default : Advertiser Campaign Creative Transaction |
No matching fields
Try another search or reset your filters.
Explore destinations for your data
AI
Claude
Ask Claude about your Marketing data.
View connector
AI
ChatGPT
Ask ChatGPT about your Marketing data.
View connector
Spreadsheet
Excel
Easily track, report, and analyze your marketing KPIs in Excel.
View connector
Data lake
Azure Blob Storage
Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
View connector
Data lake
Google Cloud Storage
Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
View connector
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.
View connector
Data warehousing
Snowflake
Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
View connector
Data warehousing
Amazon Redshift
Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
View connector
Data warehousing
Azure SQL
Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
View connector
Data warehousing
PostgreSQL
Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
View connector
Data warehousing
MySQL
Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
View connector
Visualization
Tableau
Empower your marketing teams with seamless data transfer to Tableau.
View connector
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.
View connector
Data warehousing
Big Query
Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
View connector
Visualization
Data Studio (formerly Looker Studio)
Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
View connector
Spreadsheet
Google Sheets
Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.
View connector