Ad Data
The ad data type: spend, impressions and clicks that ad platforms report for each day, campaign and ad. Its fields and how it relates to events and conversions.
Last reviewed September 15, 2026
Ad data is advertising performance that an ad platform reports: spend, impressions, clicks and conversions for each day, campaign, ad group and ad. One row is one ad object on one day. It is not one action of one person.
Fields
Only v_date is required. Field names that Vendo reserves start with v_.
| Field group | Fields |
|---|---|
| Date | v_date (the reporting date) |
| Platform | v_ad_platform, v_account_id, v_account_name, v_publisher_platform, v_platform_position |
| Campaign | v_campaign_id, v_campaign_name, v_campaign_type |
| Ad group | v_ad_group_id, v_ad_group_name |
| Ad | v_ad_id, v_ad_name, v_destination_url, v_destination_url_suffix, v_product_id |
| Metrics | v_spend, v_spend_local, v_impressions, v_clicks, v_interactions, v_conversions, v_revenue |
| Currency | v_currency_reporting, v_currency_source, v_currency_rate |
| Location | v_country, v_country_code, v_region, v_dma |
| Device | v_device_category |
| Keywords | v_keyword_* fields |
| UTM | utm_source, utm_medium, utm_campaign, utm_content, utm_term, utm_id, utm_source_platform, utm_campaign_id, utm_creative_format, utm_marketing_tactic |
| Other | insert_id |
v_spend is in the reporting currency. v_spend_local is in the currency of the ad account. See Currency Conversion.
How Ad Data Relates to Other Data
Ad platforms do not send the clicks of each person to your warehouse. Ad data has no user IDs, so it does not join people or profiles.
| Related to | How |
|---|---|
| Events | Reports relate events to ad data through the reporting date and the UTM values, for example utm_campaign. |
| Conversions | Attribution does not use ad data rows. It gives credit from click IDs (gclid, fbclid, msclkid and others) and utm_source on sessions. |
To relate ad data to your events, make sure your ad links carry UTM parameters and that your sessions keep the click IDs.
Typical Sources
In the App
- Connect ad platforms in Data → Integrations → Apps.
- Find campaign tables in the Data Catalog.
- Use ad data in Reports and Metrics.