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 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 |
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. |