Conversions
Lists conversion events that represent valuable actions taken by users, such as form submissions or purchases, linked to your ads.
Table Specific Information
Select
The Conversions view returns a list of the insights into post-click and view-through conversions of your LinkedIn ads campaigns, giving you the ability to measure the impact and ROI of your ads.
The add-in uses the LinkedIn Marketing Solutions API to process search criteria that refer to the Status column. The add-in processes other filters client-side within the add-in. For example, the following queries are processed server side.
SELECT * FROM Conversions WHERE Account = '123456'
Insert
To create a new conversion tracking rule there are some fields that are required in initial creation which are: Account, Name, Type.
While the following parameters are optional: Amount, CurrencyCode, Enabled, PostClickAttributionWindowSize, ViewThroughAttributionWindowSize, AutoAssociationType.
INSERT INTO Conversions ( Account, Name, Amount, CurrencyCode, Type, Enabled, PostClickAttributionWindowSize, ViewThroughAttributionWindowSize, AutoAssociationType ) VALUES ( 'urn:li:sponsoredAccount:12345', 'Lead Generation Form Submission', '50.00', 'USD', 'SUBMIT_APPLICATION', TRUE, 7, 7, 'OBJECTIVE_BASED' )
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique numerical identifier assigned to the conversion. | |
| Account | String | False |
Uniform Resource Name (URN) that identifies the advertising account associated with the conversion. | |
| Name | String | False |
Short, descriptive name for the conversion rule, displayed in the user interface and in reports. | |
| Created | Datetime | True |
Date and time when the conversion rule was originally created. | |
| LastModified | Datetime | True |
Date and time when the conversion rule was most recently updated. | |
| LastCallbackAt | Datetime | True |
Date and time when the most recent conversion callback event was received. | |
| Amount | String | False |
Specifies the monetary value associated with the conversion as a real number string. | |
| CurrencyCode | String | False |
Currency code representing the currency type used for the conversion value. | |
| Type | String | False |
Defines the type of conversion rule. The allowed values are ADD_TO_CART, DOWNLOAD, INSTALL, KEY_PAGE_VIEW, LEAD, PURCHASE, SIGN_UP, OTHER, SAVE, START_CHECKOUT, SCHEDULE, VIEW_CONTENT, VIEW_VIDEO, ADD_BILLING_INFO, BOOK_APPOINTMENT, REQUEST_QUOTE, SEARCH, SUBSCRIBE, AD_CLICK, AD_VIEW, COMPLETE_SIGNUP, SUBMIT_APPLICATION, PHONE_CALL, INVITE, LOGIN, SHARE, DONATE, ADD_TO_LIST, START_TRIAL, OUTBOUND_CLICK, CONTACT, QUALIFIED_LEAD. | |
| Enabled | Boolean | False |
If the value is 'true', the conversion rule is active and tracks conversions on the advertiser's website. If 'false', it is disabled. | |
| ImagePixelTag | String | True |
HTML code snippet representing the image pixel used to track conversion activity on the advertiser's website. | |
| PostClickAttributionWindowSize | Integer | False |
Specifies the time window, in days, during which a conversion is attributed to a user who clicked the ad. | |
| ViewThroughAttributionWindowSize | Integer | False |
Specifies the time window, in days, during which a conversion is attributed to a user who viewed (but did not click) the ad. | |
| AutoAssociationType | String | False |
Defines how campaigns are automatically associated with the conversion rule based on configuration settings. The allowed values are ALL_CAMPAIGNS, OBJECTIVE_BASED. |