Conversion
Conversion Schema
| Name | Type | Description | Sample Data |
|---|---|---|---|
| ConversionId | string | Unique identifier for the conversion record, generated as MD5 hash of concatenated fields | "90e19b84e78f436286aa4195140c2998" |
| Id | string | Original conversion identifier. A unique ID is generated for each conversion fired. | "a1b2c3d4e5f6g7h8i9j0" |
| EventCreatedOn | timestamp | Unix timestamp in milliseconds when the event, in this case conversion, was created | 1735689600000 |
| AdId | bigint | Identifier for the ad | 123456789 |
| AdTypeId | bigint | Type identifier for the ad | 1 |
| AttributableItems | json | JSON array of items that can be attributed to the conversion | MatchType: string ProductId: string BrandId: string MainCategoryId: string MerchantId: string Promoted: boolean [{"MatchType": "SameProduct", "ProductId": "prod123", "Promoted": true}] |
| AttributedPurchaseMetadata | json | ||
| AttributionClickLookbackWindow | integer | Window period for click attribution | 30 |
| AttributionClickMatchType | string | Type of click attribution matching | "exact" |
| AttributionViewLookbackWindow | integer | Window period for view attribution | 30 |
| AttributionViewMatchType | string | Type of view attribution matching | "exact" |
| AdvertiserId | bigint | Identifier for the advertiser | 2325487 |
| CampaignId | bigint | Identifier for the campaign | 123456789 |
| ChannelId | bigint | Identifier for the channel | 123456789 |
| CreativeId | bigint | Identifier for the creative | 123456789 |
| CustomEventCount | bigint | Count of the event that has been incremented by the Event Multiplier in either the Request placement or in the query parameter of the event. | 1 |
| Datacenter | boolean | Flag indicating if the conversion was served from a datacenter | false |
| DecisionId | string | Identifier for the decision. A distinct value is created for each placement object in an ADR. |
"90e19b84e78f436286aa4195140c2998" |
| DeviceBrandName | string | Brand name of the device | "Apple" |
| DeviceBrowser | string | Browser name of the device | "Chrome" |
| DeviceBrowserMajorVersion | string | Major version of the browser | "120" |
| DeviceBrowserMinorVersion | string | Minor version of the browser | "0" |
| DeviceBrowserRawVersion | string | Raw version string of the browser | "120.0.6099.130" |
| DeviceFormFactor | string | Form factor of the device | "mobile" |
| DeviceModelName | string | Model name of the device | "iPhone 13" |
| DeviceOsMajorVersion | string | Major version of the operating system | "15" |
| DeviceOsMinorVersion | string | Minor version of the operating system | "4" |
| DeviceOsRawVersion | string | Raw version string of the operating system | "15.4.1" |
| dt | string | Date partition | "2024/1/1" |
| Ecpm | float | Calculated ECPM (Effective cost per thousand impressions) of the conversion | 2.50 |
| EventId | bigint | ID of the custom event, in the case of conversion is 1, 2, or 3 | 3 |
| FlightId | bigint | Identifier for the flight | 123456789 |
| GdprComputed | boolean | If true, the request has GDPR consent either from the request itself, from a UserDB record etc | true |
| GdprSource | string | Source of GDPR consent information. '+' separated string of values: 'blk', 'req', 'udb', 'req'. example: 'req+udb'. | "req" or "udb" |
| Gmv | bigint | Gross Merchandise Value. Sourced from the event URL if appended as a query parameter. Calculated by taking the gmv parameter on the event URL and multiplying by 1,000,000. | 1000000 |
| ImpressionCreatedOn | timestamp | Unix timestamp in milliseconds when the request was created | 1735689600000 |
| IsValidUa | boolean | Flag indicating if the user agent is valid | true |
| Keywords | json | JSON array of keywords | ["shoes", "sports"] |
| LocationCity | string | City name | "San Francisco" |
| LocationCountryCode | string | Country code. Can be referenced here. | "US" |
| LocationCountryName | string | Country name | "United States" |
| LocationDmaCode | string | DMA code | "807" |
| LocationLatitude | float | Latitude coordinate | 37.7749 |
| LocationLongitude | float | Longitude coordinate | -122.4194 |
| LocationMetroCode | string | Metro code | "SF" |
| LocationPostalCode | string | Postal code | "94105" |
| LocationRegion | string | Region name | "California" |
| LocationSubregion | string | Subregion name | "Bay Area" |
| MatchingKeywords | json | JSON array of matching keywords | ["shoes", "sports"] |
| ModifiedPrice | float | Modified price value, for when Bid Modifiers are used | 0.75 |
| NetworkId | string | Identifier for the network | "12345" |
| OptimizedPrice | float | Optimized price value, after factoring in auto-bidding, second pricing and bid modifiers | 0.80 |
| PlacementName | string | Name of the placement, as specified by 'divName' in the Ad Decision Request | "homepage_leaderboard" |
| PurchasedItem | json | ||
| Price | float | Price of the Flight that is associated with the conversion e.g. $20.70. | 20.70 |
| PriorityId | bigint | PriorityId of the Flight that is associated with the conversion | 123456 |
| RateType | integer | Rate type of the Flight that is associated with the conversion | 1 |
| RelevancyScore | float | Score indicating relevancy, requires passing in a relevancy score in the Ad Decision Request | 500.00 |
| Revenue | bigint | Revenue generated from the conversion multiplied by 1,000,000 (in order to support very small prices, such as $0.01 CPC).May be altered by revenue modifying parameters . | 50000 |
| SiteId | bigint | Identifier for the Site that the conversion served in | 1234567 |
| Url | string | URL of where the ad served, requires passing in the url field in the Ad Decision Request |
"https://example.com/page123" |
| UserKey | string | Key identifying the user | "ue_e8be4e08dc0345e1b94157f104a5b2ef" |
| ZoneId | bigint | Identifier for the Zone that the conversion served in | 1234567 |