Account ID | id of the ad account | String | 23204565132 |
Account Name | name of the ad account, as displayed via API | String | bluechp_fb_ads |
Actions | FB actions List of objects | List of Objects | N/A |
Ad Group ID | ID of the ad group set by the advertising platform | String | 6132376364909 |
Ad Group Name | The name of the ad group as it appears in the advertising platform. Always shows the latest value at the time of sync. | String | 2022 - Search - AF7 & FCA |
Ad Id | ID of the ad set by the advertising platform. | String | 6.13238E+12 |
Ad Name | ID of the ad set by the advertising platform. Some campaign types like Performance Max / Google does not have ad id level data | String | 6132376364909 |
Ad Platform | The name of the advertising platform. | String | Google Ads, Meta Ads |
Adset ID | ID of the ad group set by the advertising platform | String | 6132376364909 |
Adset Name | ID of the ad group set by the advertising platform | String | 6132376364909 |
Advertising Channel Type | The type of advertising channel for the campaign. | String | Search |
Campaign Budget Amount Micros | Budget for the campaign in micro units. | Numeric | 50000000 |
Campaign ID | ID of the campaign set by the advertising platform. | String | 1234567890 |
Campaign Name | The name of the campaign as it appears in the advertising platform. Always shows the latest value at the time of sync. | String | 2022 - Search - AF7 & FCA, Summer Sale Campaign |
City | The city of the user parsed from the IP property or the Latitude and Longitude properties. | String | N/A |
Clicks | The Numeric of clicks created through ad platforms. A click is counted even if the person doesn't reach your website, perhaps because it's temporarily unavailable. | Numeric | 200 |
Conversion Value | The conversion value reported by the advertising platform. | Numeric | N/A |
Conversions | The number of conversions reported by the ad platform. The data in Mixpanel and Ad platforms may differ in some instances where historical conversions are updated based on attribution methodologies | Numeric | 10 |
Cost | The value of conversions reported by the ad platform. The data in Mixpanel and Ad platforms may differ in some instances where historical conversions are updated based on attribution methodologies | Numeric | 1000 |
Cost Micros | Cost in micro units. | Numeric | 1000000 |
Cost Source | the ad spend amount as reported in the ad platform | Numeric | 200.00 |
Country | The country of the user parsed from the IP property or the Latitude and Longitude properties. The value is stored as a 2-letter country code in the raw data and parsed into the country name in the UI. | String | N/A |
Criteria ID | search term used in ads (Google) | String | 328537904396 |
Currency Reporting | the currency of the report | String | USD |
Currency Source | the currency from the ad platform account. Uses standard currency format. This is used for currency conversions | String | AUD |
Current URL | the destination URL cleaned from UTMs | String | https://guidemehome.com |
Date | Date of the add spend. All date data is converted to UTC so that Mixpanel can correctly attribute to the right timezone of the Mixpanel project | Date | 2021-10-08 |
Device | The type of device that's showing | String | desktop, ipad, ophone, androud_smartphone, androuid_table |
Device Category | the type of device that the users are on | String | m, c, t |
Device Platform | mobile_app | String | N/A |
Final Url Suffix | The suffix added to the final URL. This happens on Google Ads ATM. | String | N/A |
Import | To determine if this a server side event or not | Boolean | true |
Impressions | Numeric of impressions created through ad platforms. An impression is counted each time your ad is shown on an ad network. | Numeric | 100 |
Insert ID | A unique identifier for the event, used for deduplication. | String | 49b71cd2-295b-476a-a345-0eb50bd13b57 |
Region | The region (state or province) of the user parsed from the IP property or the Latitude and Longitude properties. | String | N/A |
Source | Name of the source where the data syncs. This will be Vendo data. | String | Vendo Data |
UTM Campaign | The calculated field. The value of the UTM parameter that is expected to be associated with first party user data. | String | campaign x |
UTM Content | The calculated field. The value of the UTM parameter that is expected to be associated with first party user data. | String | october_promo |
UTM Medium | The calculated field. The value of the UTM parameter that is expected to be associated with first party user data. | String | cpc |
UTM Source | The calculated field. The value of the UTM parameter that is expected to be associated with first party user data. | String | facebook |
UTM Term | The calculated field. The value of the UTM parameter that is expected to be associated with first party user data. | String | nike_air, red_shoes |