Conversions
Retrieves a list of Conversions. Conversions are actions a member makes that are valuable to your business.
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 server uses the LinkedIn Marketing Solutions API to process search criteria that refer to the Status column. The server processes other filters client-side within the server. 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 |
Numerical identifier for the Conversion. | |
| Account | String | False |
URN identifying the advertising account associated with the Conversion. | |
| Name | String | False |
A short name for this rule, which will be shown in the UI and in reports. | |
| Created | Datetime | True |
The timestamp when the Conversion was created. | |
| LastModified | Datetime | True |
The timestamp when the Conversion was last modified. | |
| LastCallbackAt | Datetime | True |
The timestamp of the last callback from the Conversion. | |
| Amount | String | False |
The amount of money as a real number string. | |
| CurrencyCode | String | False |
Identifying code for currency type. See currency codes for the valid codes. | |
| Type | String | False |
The type of the 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 |
Set to true or false to enable or disable this rule from matching on the advertiser's website. | |
| ImagePixelTag | String | True |
The HTML representation of the image pixel. | |
| PostClickAttributionWindowSize | Integer | False |
The HTML representation of the image pixel. | |
| ViewThroughAttributionWindowSize | Integer | False |
The HTML representation of the image pixel. | |
| AutoAssociationType | String | False |
A type enum that defines how campaigns should be associated with the conversion rule. The allowed values are ALL_CAMPAIGNS, OBJECTIVE_BASED. |