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 connector uses the LinkedIn Marketing Solutions API to process search criteria that refer to the Status column. The connector processes other filters client-side within the connector. 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. |