Windsor brings all your LinkedIn Ads data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
LinkedIn Ads Field Reference
Sample
https://connectors.windsor.ai/linkedin?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | Advertisement account ID | Account |
| account_name | TEXT | Account Name | A label for the account. | Account |
| account_type | TEXT | Account type | Account type | Account |
| accountid | TEXT | Account ID (Duplicate) | Advertisement account ID (Duplicate) | Account |
| ad_form_description | TEXT | Form Description | Description of the form, visible to both the owner and the viewer. | Form |
| ad_form_headline | TEXT | Form Headline | Headline of the form, visible to both the owner and the viewer. | Form |
| ad_form_legal_disclaimer | TEXT | Form Legal Disclaimer | Owner's legal disclaimer to accompany this form. Optional since the owner may alternatively use other fields (e.g. legalDisclaimer, consents) to surface the privacy policy. | Form |
| ad_form_legal_info_id | TEXT | Form Legal Info ID | Unique identifier of the LeadGenFormLegalInfo. | Form |
| ad_form_name | TEXT | Form Name | Name of the Lead Form provided by the owner.. | Form |
| ad_form_post_review_last_updated | DATE | Form Review Last Updated | The date indicating when the review status is initiated/last updated. | Form |
| ad_form_post_review_rejection_reasons | TEXT | Form Review Reject Reason | An array of rejection reasons for the Lead Form. It's Non-empty if the review status is REJECTED in the latest review. | Form |
| ad_form_post_review_status | TEXT | Form Review Status | Indicate the state of review for the Lead Form. PENDING - The form is pending review and not serving. APPROVED - The form is approved for serving. REJECTED - The form is rejected. PREAPPROVED - form has been pre-approved, it's ready for serving but still need further review. AUTO_APPROVED - The form has been auto approved by content model. NEEDS_REVIEW - The form has been rejected by content model or policy checker or returned by fallback case that auto approval didn't make any decision. AUTO_REJECTED - The form has been auto rejected by content model. | Form |
| ad_form_post_submission_info_cta_label | TEXT | Form Post Submission Call To Action Label | Label for the call to action shown to the viewer. Default is VISIT_COMPANY_WEBSITE | Form |
| ad_form_post_submission_info_cta_target | TEXT | Form Post Submission Call To Action Target | Target where the user is taken after clicking on the CTA. E.g. a LandingPageUrl which is a url redirect to a web page. It can be empty for CTA's which don't require additional information. | Form |
| ad_form_post_submission_info_message | TEXT | Form Post Submission Message | The message displayed to a member after the Lead Form is submitted. | Form |
| ad_form_privacy_policy_url | TEXT | Form Privacy Policy URL | The URL of the privacy policy that covers any data passed to the owner of the form. Optional since it is not required to be present for all the use cases. | Form |
| ad_form_status | TEXT | Form Status | DRAFT, PUBLISHED, ARCHIVED. Draft - The form is still being edited. Published - The form is published, i.e. it has gone through processing (e.g. manual review) and is ready to be used. Archived - The form is archived. | Form |
| ad_form_thank_you_message | TEXT | Form Post Submission Message (Duplicate) | The message displayed to a member after the Lead Form is submitted. | Form |
| ad_form_thank_you_page_call_to_action | TEXT | Form Post Submission Call To Action Label (Duplicate) | Label for the call to action shown to the viewer. Default is VISIT_COMPANY_WEBSITE | Form |
| ad_name | TEXT | (Deprecated) Ad Name | Deprecated field. Alias for sponsored_creative_content_title. Probably you are looking for 'Creative Ad Context DSC Name' (creative_content_data_share_ad_context_dsc_name) | Creative |
| adnetwork_conversions | NUMERIC | Ad Network Conversions | The Ad Network Reported Conversions | Ad Network |
| adnetwork_revenue | NUMERIC | Ad Network Revenue | The Ad Network Reported Revenue | Ad Network |
| answers | TEXT | Form Response Answers | All answers on form response | Form Response |
| approximate_unique_impressions | NUMERIC | Approximate Unique Impressions | The approximate reach of the campaign. The number of unique member accounts with at least one impression. Can be requested for date ranges with a maximum range of 92 days. The expected delay for current UTC day will be 24-48 hours. Requests which include today in the date range will only return reach for days where data exists. | Performance |
| audience_penetration | PERCENT | Audience Penetration | The approximate number of unique members reached by the advertiser divided by the approximate total target audience size. The field will be null if the date range has more than 92 days. This metric only supports the CAMPAIGN pivot. | Performance |
| average_dwell_time | NUMERIC | Average Dwell Time | This measures the average time (in seconds) that users spend viewing the ad when at least 50% of the pixels are present on the screen. | Performance |
| average_frequency | PERCENT | Average frequency | Average number of impressions seen by each member account exposed to at least one impression | Performance |
| campaign | TEXT | Campaign | The campaign name | Campaign |
| campaign_account | TEXT | Campaign Account | Account where campaign is running | Campaign |
| campaign_cost_type | TEXT | Campaign Cost Type | Campaign cost type | Campaign |
| campaign_daily_budget_amount | TEXT | Campaign daily budget amount | Daily Budget Amount | Campaign |
| campaign_end_date | DATE | Campaign end date | Campaign End Date | Campaign |
| campaign_group_backfilled | BOOLEAN | Campaign Group Backfilled | Flag that denotes whether the campaign group was created organically or to backfill existing campaigns. This is a read-only field set by the system. | Campaign Group |
| campaign_group_id | TEXT | Campaign Group ID | Tumerical identifier for the campaign group. This is a read-only field set by the system. | Campaign Group |
| campaign_group_name | TEXT | Campaign Group Name | The name of the campaign group used to make it easier to reference a campaign group and recall its purpose. The value of this field cannot exceed 100 characters. | Campaign Group |
| campaign_group_run_scedule_end_time | TIMESTAMP | Campaign Group Run Scedule End Time | Represents the exclusive (strictly less than) date when to stop running the associated campaigns under this campaign group. If this field is unset, it indicates an open range with no end date. This field is required if totalBudget is set. | Campaign Group |
| campaign_group_run_scedule_start_time | TIMESTAMP | Campaign Group Run Scedule Start Time | Represents the inclusive (greater than or equal to) date when to start running the associated campaigns under this campaign group. This field is required. | Campaign Group |
| campaign_group_status | TEXT | Campaign Group Status | Status of campaign group. | Campaign Group |
| campaign_group_total_budget | NUMERIC | Campaign Group Total Budget | Maximum amount to spend across all associated campaigns and creatives for duration of the campaign group. | Campaign Group |
| campaign_id | TEXT | Campaign ID | The campaign ID | Campaign |
| campaign_start_date | DATE | Campaign Start Date | Campaign Start Date | Campaign |
| campaign_status | TEXT | Campaign Group Status | Status of campaign group. | Campaign |
| campaign_total_budget_amount | TEXT | Campaign total budget amount | Total Budget Amount | Campaign |
| campaign_type | TEXT | Campaign Type | Campaign type | Campaign |
| card_clicks | NUMERIC | Card Clicks | The number of clicks for each card of a carousel ad. | Carousel Ad |
| card_clicks_viral | NUMERIC | Card Clicks (Viral) | The number of viralClicks for each card of a carousel ad. | Carousel Ad |
| card_impressions | NUMERIC | Card Impressions | The number of impressions for each card of a carousel ad. | Carousel Ad |
| card_impressions_viral | NUMERIC | Card Impressions (Viral) | The number of viralImpressions for each card of a carousel ad. | Carousel Ad |
| card_index | TEXT | Card Index | Group results by conversion. | Carousel Ad |
| clicks | NUMERIC | Clicks | The count of clicks. | Performance |
| comments | NUMERIC | Comments | Number of Comments | Performance |
| completions | NUMERIC | Completions | The count of video ads that played 97-100% of the video. | Video |
| conversion_attribution_type | TEXT | Conversion Attribution Type | The model that describes how conversion actions are to be counted. Acceptable values are: LAST_TOUCH_BY_CAMPAIGN and LAST_TOUCH_BY_CONVERSION | Conversion |
| conversion_created | DATE | Conversion Created Date | Conversion Created Date | Conversion |
| conversion_enabled | BOOLEAN | Conversion Enabled | Set to true or false to enable or disable this rule from matching on the advertiser’s website. The initial state can be either, but only rules that are enabled will trigger conversion events. | Conversion |
| conversion_id | TEXT | Conversion ID | Conversion ID | Conversion |
| conversion_last_callback_at | DATE | Conversion Last Callback At Date | The last time one or more of the URL match rules fired and called back to the server. | Conversion |
| conversion_last_modified | DATE | Conversion Last Modified Date | A date corresponding to the last modification of this resource. | Conversion |
| conversion_name | TEXT | Conversion Name | A short name for this conversion. | Conversion |
| conversion_pivot | TEXT | Conversion Pivot | Group results by conversion. | Conversion |
| conversion_post_click_attribution_window_size | TEXT | Conversion Post Click Attribution Window Size | Specifies a user's settings on the post click attribution window in days. | Conversion |
| conversion_type | TEXT | Conversion Type | The type of the conversion. | Conversion |
| conversion_view_through_attribution_window_size | TEXT | Conversion View Through Attribution Window Size | Specifies a user's settings on the view through (post view) attribution window in days. | Conversion |
| conversions | NUMERIC | Share conversions | Number of External Website Conversions after Post View | Campaign |
| conversionvalueinlocalcurrency | NUMERIC | Conversion Value (Local Currency) | Value of the conversions in the account's local currency based on rules defined by the advertiser. Conversion value is set by the advertiser at a per conversion level, and aggregated across the query time range. | Performance |
| cost_in_usd | NUMERIC | Share cost in USD | Campaign Cost in USD | Campaign |
| cost_per_externalwebsiteconversions | NUMERIC | Cost Per External Website Conversions | Cost in the account's local currency divided by the count of conversions indicated by pixel loads on an external advertiser website. | Social Actions |
| cost_per_externalwebsitepostclickconversions | NUMERIC | Cost Per External Website Post Click Conversions | Cost in the account's local currency divided by the count of post-click conversions indicated by pixel loads.on an external advertiser website. | Social Actions |
| cost_per_externalwebsitepostviewconversions | NUMERIC | Cost Per External Website Post View Conversions | Cost in the account's local currency divided by the count of post-view conversions indicated by pixel loads on an external advertiser website. | Social Actions |
| cost_per_job_application | NUMERIC | Cost Per Job Application | Cost in the account's local currency divided by the number of times a member completed a job application | Job |
| country_code | COUNTRY | Country Code | List of country codes of target locations | Country |
| cpc | NUMERIC | CPC | Cost-per-click (CPC) | Performance |
| cpm | NUMERIC | CPM | Cost per mille (CPM).It is the cost an advertiser pays for one thousand views or impressions of an advertisement (1000 * cost / impressions) | Performance |
| creative_content_data_share_ad_context_ad_type | TEXT | Creative Ad Context DSC Ad Type | The type of DSC (e.g. VIDEO, STANDARD, CAROUSEL, etc.) | Creative |
| creative_content_data_share_ad_context_dsc_name | TEXT | Creative Ad Context DSC Name | Plain text name of the DSC post. | Creative |
| creative_content_data_share_ad_context_dsc_status | TEXT | Creative Ad Context DSC Status | The status of the advertising company content. Representing whether the content is usable from the advertiser's perspective as a DSC | Creative |
| creative_creation_datetime | TIMESTAMP | Creative Creation Datetime | Creative Creation Date and Time | Creative |
| creative_id | TEXT | Creative ID | Creative ID | Creative |
| creative_last_modified_datetime | TIMESTAMP | Creative Last Modified Datetime | Creative Last Modified Date and Time | Creative |
| creative_status | TEXT | Creative Status | Creative Status | Creative |
| creative_thumbnail | IMAGE_URL | Creative thumbnail | Creative thumbnail | Creative |
| ctr | PERCENT | CTR | Click-through rate (CTR) | Performance |
| currency | TEXT | Currency | Account currency (default="USD") | Account |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Dates covered by the report data point. Date is specified in UTC. | Time |
| day_of_month | TEXT | Day of month | Day of the month | |
| engagement_rate | PERCENT | Engagement Rate | Number of times members interacted with your ad (paid and free clicks divided by total impressions) | Performance |
| engagements | NUMERIC | Engagements | The total number of actions that people took on your Linkedin Ads. | Performance |
| externalwebsiteconversions | NUMERIC | External Website Conversions | The count of conversions indicated by pixel loads on an external advertiser website. | Social Actions |
| externalwebsitepostclickconversions | NUMERIC | External Website Post Click Conversions | The count of post-click conversions indicated by pixel loads on an external advertiser website. | Social Actions |
| externalwebsitepostviewconversions | NUMERIC | External Website Post View Conversions | The count of post-view conversions indicated by pixel loads on an external advertiser website. | Social Actions |
| follows | NUMERIC | Follows | The count of follows. Sponsored Updates only. | Social Actions |
| form_campaign_id | TEXT | Form Response Campaign ID | Campaign id that this form response is connected | Form Response |
| form_campaign_name | TEXT | Form Response Campaign Name | Campaign name that this form response is connected | Form Response |
| form_campaign_type | TEXT | Form Response Campaign Type | Campaign type that this form response is connected | Form Response |
| form_created_datetime | DATE | Form Created Date | Date and time corresponding to the creation of the form. | Form |
| form_creation_locale_country | COUNTRY | Form Creation Locale Country | A lowercase two-letter language code as defined by ISO-639-1 | Form |
| form_creation_locale_language | TEXT | Form Creation Locale Language | An uppercase two-letter country code as defined by ISO-3166 | Form |
| form_creative_id | TEXT | Form Response Creative ID | Form creative id | Form Response |
| form_id | TEXT | Form ID | Numerical identifier for the form. | Form |
| form_last_modified_datetime | DATE | Form Last Modified Date | Date and time corresponding to the last modified date of the form. | Form |
| form_owner_account_name | TEXT | Form Response Owner Account Info Name | Name of the owner of the Lead Form Response. | Form Response |
| form_owner_id | TEXT | Form Owner ID | ID that identifies the owner of the Lead Form. | Form |
| form_response_associated_creative_status | TEXT | Form Response Associated Creative Status | Status of creative, associated with this Form Response | Form Response |
| form_response_consent_responses | TEXT | Form Response Consent Responses | All Consent Response answers on this Form Response | Form Response |
| form_response_id | TEXT | Form Response id | ID of a Form response | Form Response |
| form_response_owner_id | TEXT | Form Response Owner ID | ID that identifies the owner of the Lead Form Response. | Form Response |
| form_submitter | TEXT | (Deprecated) Form Response Submitter | (Deprecated) ID that identifies the person who submitted the Lead Form Response. | Form Response |
| form_version_id | TEXT | Form Version ID | The version ID of the form. This is a derived field and is generated on the server side. | Form |
| form_version_tag | TEXT | Form Version Tag | The number of times the form has been modified. | Form |
| full_screen_plays | NUMERIC | Share full screen plays | Number of Full Screen Plays | Social Actions |
| OBJECT | Form Hidden Fields | Hidden fields used by the owner to track key attributes of the form that generated the lead. The field is empty if the owner chooses to not append any tracking attributes to the Lead Form. | Form | |
| impression_device_type | TEXT | Impression device type | Group results by the device type the ad made an impression on. Reach metrics and conversion metrics will not be available when this pivot is used. | Impression Device Type |
| impressions | NUMERIC | Impressions | This is the count of "impressions" for Direct Ads and Sponsored Updates and "sends" for InMails. | Performance |
| job_applications | NUMERIC | Job Applications | The number of times a member completed a job applicationafter viewing or clicking on an ad. Currently, this metric is broken down into postViewJobApplications (if the member applied after viewing the ad) and postClickJobApplications (if the member applied after clicking the ad). | Job |
| job_apply_clicks | NUMERIC | Job Apply Clicks | The number of times a member clicked on the job’s apply button on an LinkedIn jobs page after viewing or clicking on an ad which has a LinkedIn job landing page. Currently, this metric is broken down into postViewJobApplyClicks (if the member performed the action after viewing the ad) and postClickJobApplyClicks (if the member performed the action after clicking the ad). | Job |
| landing_page | TEXT | Landing Page | Landing Page | Creative |
| landing_page_clicks | NUMERIC | Share landing page clicks | Number of Clicks to the Landing Page | Campaign |
| landingpageclicks | NUMERIC | Landing Page Clicks | The count of clicks which take the user to the creative landing page. | Performance |
| lead_type | TEXT | Form Response Lead type | Type of the lead representing the origination of the lead. | Form Response |
| leadgenerationmailcontactinfoshares | NUMERIC | Lead Generation Mail Contact Info Shares | The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only. | Performance |
| likes | NUMERIC | Likes | The count of likes. Sponsored Updates only. | Performance |
| member_company_name | TEXT | Member company name | Company names of LinkedIn members engaged with campaigns. Groups metrics by audience companies, cannot be combined with any other aggregation fields. | Member Company Name |
| member_company_size | TEXT | Member company size | Approximate company size of LinkedIn members engaged with campaigns. Groups metrics by audience company sizes, cannot be combined with any other aggregation fields. | Member Company Size |
| member_country | COUNTRY | Member country | Countries of LinkedIn members engaged with campaigns. Groups metrics by audience countries, cannot be combined with any other aggregation fields. | Country |
| member_industry | TEXT | Member industry | Industry of LinkedIn members engaged with campaigns. Groups metrics by audience industries, cannot be combined with any other aggregation fields. | Member Industry |
| member_job_function | TEXT | Member job function | Job functions of LinkedIn members engaged with campaigns. Groups metrics by audience job functions, cannot be combined with any other aggregation fields. | Member Function |
| member_job_title | TEXT | Member job title | Job titles of LinkedIn members engaged with campaigns. Groups metrics by audience job titles, cannot be combined with any other aggregation fields. | Demographics |
| member_region | REGION | Member region | Geographic regions of LinkedIn members engaged with campaigns. Groups metrics by audience regions, cannot be combined with any other aggregation fields. | Region |
| member_seniority | TEXT | Member seniority | Seniority of LinkedIn members engaged with campaigns. Groups metrics by audience seniorities, cannot be combined with any other aggregation fields. | Member Seniority |
| month | TEXT | Month | Number of the month | |
| objective_type | TEXT | Objective Type | Campaign Objective type values. | Campaign |
| oneclickleadformopens | NUMERIC | One Click Lead Form Opens | The count of times users opened the lead form for a One Click Lead Gen campaign. | Performance |
| oneclickleads | NUMERIC | One Click Leads | The count of leads generated through One Click Lead Gen. | Performance |
| opens | NUMERIC | Opens | The count of opens of Sponsored InMail and Sponsored Messaging ads.only. | Performance |
| optimization_target_type | TEXT | Optimization Target Type | Determines how this campaign is optimized for spending. If this is not set, there is no optimization. | Campaign |
| other_engagements | NUMERIC | Share other engagements | Number of Other Engagements | Campaign |
| placement_name | TEXT | Placement Name | Group results by placement. | Placement |
| quartile_1 | NUMERIC | Video watches at 25% | The count of video ads that played through the first quartile of the video. | Video |
| quartile_2 | NUMERIC | Video watches at 50% | The count of video ads that played through the midpoint of the video. | Video |
| quartile_3 | NUMERIC | Video watches at 75% | The count of video ads that played through the third quartile of the video. | Video |
| reactions | NUMERIC | Share reactions | Number of Reactions by Campaign | Campaign |
| sends | NUMERIC | Sends | The count of sends of Sponsored Messaging ads. | Performance |
| serving_location | TEXT | Service Location | Group results by serving location, onsite or offsite. | Serving Location |
| share_creation_datetime | TIMESTAMP | Share creation datetime | Post Creation Date and Time | Creative |
| share_id | TEXT | Share ID | Share (Post) ID | Creative |
| share_landing_page | TEXT | Share landing page | Post landing page | Creative |
| share_last_modified_datetime | TIMESTAMP | Share last modified datetime | Post Last Modification Date and Time | Creative |
| share_text | TEXT | Share text | Post Text | Creative |
| share_title | TEXT | Share title | Post Title | Creative |
| share_type | TEXT | Share Type | Share/post media category | Creative |
| shares | NUMERIC | Shares | This is the count of "shares" for sponsored Shares. | Performance |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| spend | NUMERIC | Spend | Cost in the account's local currency | Performance |
| sponsored_creative_content_description | TEXT | Creative Description | Sponsored creative (ad) description | Sponsored Creative |
| sponsored_creative_content_title | TEXT | Creative Title | creative (ad) title | Sponsored Creative |
| submitted_at | DATE | Form Response submitted at time | Form response submitted time f: YYYY-MM-DD | Form Response |
| targeting_exclude_ageranges | OBJECT | Targeting Exclude Age Range | A segment of members who will be excluded from the advertising campaign's targeting by organization. | Campaign |
| targeting_exclude_employers | OBJECT | Targeting Exclude Employers | A segment of members who will be excluded from the advertising campaign's targeting by age rate. | Campaign |
| targeting_exclude_groups | OBJECT | Targeting Exclude Groups | A segment of members who will be excluded from the advertising campaign's targeting by groups. | Campaign |
| targeting_exclude_industries | OBJECT | Targeting Exclude Industries | A segment of members who will be excluded from the advertising campaign's targeting by standardized industries. | Campaign |
| targeting_exclude_interfacelocales | OBJECT | Targeting Exclude Interface Locales | A segment of members who will be excluded from the advertising campaign's targeting by interface locales. | Campaign |
| targeting_exclude_jobfunctions | OBJECT | Targeting Exclude Job Functions | A segment of members who will be excluded from the advertising campaign's targeting by standardized job functions. | Campaign |
| targeting_exclude_locations | OBJECT | Targeting Exclude Locations | A segment of members who will be excluded from the advertising campaign's targeting by locations. | Campaign |
| targeting_exclude_seniorities | OBJECT | Targeting Exclude Seniorities | A segment of members who will be excluded from the advertising campaign's targeting by standardized seniorities. | Campaign |
| targeting_exclude_titles | OBJECT | Targeting Exclude Titles | A segment of members who will be excluded from the advertising campaign's targeting by standardized titles. | Campaign |
| targeting_include_ageranges | OBJECT | Targeting Include Age Range | A segment of members who will be included in the advertising campaign's targeting by organization. | Campaign |
| targeting_include_employers | OBJECT | Targeting Include Employers | A segment of members who will be included in the advertising campaign's targeting by age rate. | Campaign |
| targeting_include_groups | OBJECT | Targeting Include Groups | A segment of members who will be included in the advertising campaign's targeting by groups. | Campaign |
| targeting_include_industries | OBJECT | Targeting Include Industries | A segment of members who will be included in the advertising campaign's targeting by standardized industries. | Campaign |
| targeting_include_interfacelocales | OBJECT | Targeting Include Interface Locales | A segment of members who will be included in the advertising campaign's targeting by interface locales. | Campaign |
| targeting_include_jobfunctions | OBJECT | Targeting Include Job Functions | A segment of members who will be included in the advertising campaign's targeting by standardized job functions. | Campaign |
| targeting_include_locations | OBJECT | Targeting Include Locations | A segment of members who will be included in the advertising campaign's targeting by locations. | Campaign |
| targeting_include_seniorities | OBJECT | Targeting Include Seniorities | A segment of members who will be included in the advertising campaign's targeting by standardized seniorities. | Campaign |
| targeting_include_titles | OBJECT | Targeting Include Titles | A segment of members who will be included in the advertising campaign's targeting by standardized titles. | Campaign |
| test_lead | BOOLEAN | Form Response Is Test Lead | True/False is this test lead form response | Form Response |
| today | DATE | Today | Today's date | |
| total_engagements | NUMERIC | Share total engagements | Number of total Engagements | Campaign |
| totalcost | NUMERIC | Total Cost | Cost in the account's local currency (Duplicate of Spend) | Performance |
| transactionrevenue | NUMERIC | Transaction Revenue (Local Currency) | Conversion Value (Duplicate of Conversion Value (Local Currency)) | Performance |
| transactions | NUMERIC | Transactions | The number of transactions (Duplicate of External Website Conversions) | Social Actions |
| video_completions | NUMERIC | Video Completions | The count of video ads that played 97-100% of the video. | Video |
| video_start | NUMERIC | Video plays | The number of times a video starts to play | Video |
| video_starts | NUMERIC | Video plays (duplicate) | The number of times a video starts to play | Video |
| video_viewed_25pcnt | NUMERIC | Video watches at 25% (Duplicate) | The count of video ads that played through the first quartile of the video. (Duplicate) | Video |
| video_viewed_50pcnt | NUMERIC | Video watches at 50% (Duplicate) | The count of video ads that played through the midpoint of the video. (Duplicate) | Video |
| video_viewed_75pcnt | NUMERIC | Video watches at 75% (Duplicate) | The count of video ads that played through the third quartile of the video. (Duplicate) | Video |
| video_views | NUMERIC | Video views | 2 or more continuous seconds of playback while the video is at least 50% on screen, or a click on the CTA, whichever comes first. | Video |
| viral_clicks | NUMERIC | Share viral clicks | Number of Viral Clicks Aggregated by Campaign | Viral |
| viral_comments | NUMERIC | Share viral comments | Number of Viral Comments by Campaign | Viral |
| viral_conversions | NUMERIC | Viral External Website Conversions | The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event. | Campaign |
| viral_follows | NUMERIC | Share viral follows | Number of Viral Follows by Campaign | Viral |
| viral_full_screen_plays | NUMERIC | Share viral full screen plays | Number of Viral Full Screen Plays | Viral |
| viral_impressions | NUMERIC | Share viral impressoins | Number of Viral Impressions Aggregated by Campaign | Viral |
| viral_landing_page_clicks | NUMERIC | Share viral landing page clicks | Number of Viral Clicks to the Landing Page | Campaign |
| viral_likes | NUMERIC | Share viral likes | Number of Viral Likes by Campaign | Viral |
| viral_reactions | NUMERIC | Share viral reactions | Number of Viral Reactoins by Campaign | Viral |
| viral_shares | NUMERIC | Share viral shares | Number of Viral Shares by Share | Viral |
| viral_total_engagements | NUMERIC | Share viral total engagements | Viral Total Engagements | Viral |
| viral_video_completions | NUMERIC | Share viral video completions | Number of Viral Video Views to 100% | Viral |
| viral_video_starts | NUMERIC | Share viral video starts | Number of Viral Video Starts | Viral |
| viral_video_viewed_25pcnt | NUMERIC | Share viral video viewed 25pcnt | Number of Viral Video Views to 25% | Viral |
| viral_video_viewed_50pcnt | NUMERIC | Share viral video viewed 50pcnt | Number of Viral Video Views to 50% | Viral |
| viral_video_viewed_75pcnt | NUMERIC | Share viral video viewed 75pcnt | Number of Viral Video Views to 75% | Viral |
| viral_video_views | NUMERIC | Share viral video views | Number of Viral Video Views | Viral |
| viralexternalwebsiteconversions | NUMERIC | Viral External Website Conversions (Duplicate) | The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event. | Viral |
| viralexternalwebsitepostclickconversions | NUMERIC | Viral External Website Post Click Conversions | The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click. | Viral |
| viralexternalwebsitepostviewconversions | NUMERIC | Viral External Website Post View Conversions | The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression. | Viral |
| viraloneclickleads | NUMERIC | Viral One Click Leads | The count of leads generated through One Click Lead Gen from viral impressions for this activity. | Viral |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |