Partner Field Schema Mapping
When pairing fields from external partners to their respective Scope3 fields, you may have questions about which fields align correctly.
Below is information compiled by Scope3 regarding the fields that best match.
Scope3 | The Trade Desk | DV360 | Xandr | Amazon | Yahoo! | Meta | Snap | GAM | Google Ads | CM360 | |
---|---|---|---|---|---|---|---|---|---|---|---|
utc_datetime | Date | Date | Day | Date | Day | Day | Date | Date | Domain | Day | Date |
inventory_id | Site | App / URL | Site Domain / Mobile Application | Supply Source Name | Domain | Platform | snapchat.com | pinterest.com | Region | Network | Site |
region | Region | Region | - | Region | - | - | - | - | Total clicks | - | - |
clicks | Clicks | Clicks | Clicks | - | Clicks | Clicks (all) | Swipes | Paid Pin Clicks | Country | Clicks | Clicks |
country | Country | Country Name | Country | Country | Country | - | Country | - | - | - | Country |
campaign_name | Campaign | Campaign | Insertion Order | Order | Campaign Name | Campaign Name | Campaign Name | Campaign name | - | Campaign ID | Campaign |
campaign_id | Campaign ID | Campaign ID | Insertion Order ID | Order ID | Campaign ID | Campaign ID | Campaign ID | - | - | Campaign | Campaign ID |
advertiser_name | Advertiser | Advertiser | Advertiser | Advertiser Name | Advertiser | Account Name | Ad Account | - | - | Account | - |
advertiser_id | Advertiser ID | Advertiser ID | Advertiser ID | Advertiser ID | Advertiser ID | Account ID | Ad Account ID | - | - | Customer ID | - |
image_size_pixels | Ad Format | Creative Size | Size | Creative Size | Ad Size | - | Image Asset Size | - | - | - | - |
ad_format | Media Type | Creative Type | Media Type | Creative Type | Line Type | Placement | Ad Type | - | - | - | - |
device_type | Device Type | Device Type | Device Type (if available) | Device | Device Type | Impression device | - | Device Type | Device Category | Device | Platform Type |
impressions | Impressions | Impressions | Imps | Impressions | Impressions | Impr | Paid Impressions | Paid Impressions | - | Impr | Impressions |
seller_name | Supply Vendor | Exchange | Seller | - | Exchange | - | - | - | - | - | - |
channel | Ad Environment | Environment | - | - | Inventory Type | SET AS SOCIAL | SOCIAL | SET AS SOCIAL | - | - | - |
completed_views | Player Completed Views | Complete Views Video | Video Completions | Video Complete | Complete | Video Plays at 100% | Video Completions | - | - | - | Video Completions |
network | Internet Connection Type | ISP or Carrier | Carrier (if available) | - | Connection Type | - | - | - | - | - | - |
video_size_bytes | Creative Player Size Bytes | - | - | - | Bid Request Ad Size | - | - | - | - | - | - |
views | Sampled Viewed Impressions | Active View Viewable Impressions | Viewable Impressions | - | Yahoo Viewable Impressions | - | Viewable Impressions | - | - | Views | Video Completions |
spend | Advertiser Cost Adv Currency | Media Cost Adv Currency | Media Cost | - | Advertiser Spending | Amount Spent | Amount Spent | Spend in account currency | - | Cost | - |
video_duration_seconds | Creative Duration in Seconds | Max Video Duration | Creative Duration (if available) | - | Video Creative Duration | - | - | - | Creative media duration | - | Video Length |
conversions | Total Click and View Conversions | Total Conversions | Total Conversions | - | Conversions | Conv | - | Paid engagements | - | All Conv | - |
line_item_name | Ad Group Name | Line Item | Line Item | Line Item ID | - | Ad Set Name | Ad Name | Ad group name | - | - | - |
line_item_id | Ad Group ID | Line Item ID | Line Item ID | Line Item Name | - | Ad Set ID | Ad ID | Ad group ID | - | - | - |
transaction_method | - | - | - | - | Deal Type | - | Buy Model | - | - | - | - |
insertion_order_id | - | Insertion Order ID | - | - | - | - | Ad Squad ID | - | - | - | - |
insertion_order | - | Insertion Order | - | - | - | - | Ad Squad Name | - | - | - | - |
brand | - | - | Brand | - | - | - | - | - | - | - | - |
revenue | - | - | - | - | - | - | - | - | - | - | - |
plays | - | Starts (Video) | Starts | Video Starts | - | Video_Plays | Video Views | - | - | - | - |
rendered_width_pixels | - | Video Player Size | - | - | - | - | - | - | - | - | Creative Pixel Size |
rendered_height_pixels | - | Video Player Size | - | - | - | - | - | - | - | - | Creative Pixel Size |
frequency | - | - | - | - | - | Frequency | - | - | - | - | - |
reach | - | - | - | - | - | Reach | - | - | - | - | - |
first_quartile_completions | - | - | - | - | - | Video Plays at 25% | - | - | - | - | - |
midpoints | - | - | - | - | - | Video Plays at 50% | - | - | - | - | - |
time_in_view | - | - | - | - | - | - | - | - | - | - | - |
Updated 11 days ago