# Linkedin Ads: Campaign Report ## Description * Each record in this table represents the daily performance of ads at the campaign level. ## Supported Data Sources * LinkedIn Ad Analytics ## Columns | Type | Name | Description | | -------- | -------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | STRING | source\_relation | The source of the record if the unioning functionality is being used. If not this field will be empty. | | DATETIME | date\_day | The day of the activity. | | INTEGER | campaign\_id | Unique internal ID representing the campaign. | | STRING | campaign\_name | A label for the campaign. | | INTEGER | version\_tag | An integer representation of the version of the campaign. | | INTEGER | campaign\_group\_id | Unique internal ID representing the campaign group. | | STRING | campaign\_group\_name | A label for the campaign group. | | INTEGER | account\_id | Unique internal ID representing the account. | | STRING | account\_name | A label for the account. | | STRING | campaign\_status | ACTIVE - Denotes that the campaign is fully servable.PAUSED - Denotes that the campaign meets all requirements to be served, but temporarily should not be.ARCHIVED - Denotes that the campaign is presently inactive, and should mostly be hidden in the UI until un-archived.COMPLETED - Denotes that the campaign has reached a specified budgetary or chronological limit.CANCELED - Denotes that the campaign has been permanently canceled, such as when an advertising account is permanently closed.DRAFT - Denotes that the campaign is still being edited and not eligible for serving. Some validation will be postponed until the campaign is activated.PENDING\_DELETION - Denotes that the campaign has been requested to be deleted that is currently pending.REMOVED - Denotes that the campaign was deleted, but must remain fetchable due to the existence of performance data. | | STRING | campaign\_group\_status | Status of campaign's campaign group. Possible values are: ACTIVE - Denotes that the campaign group is capable of serving ads, subject to run date and budget limitations (as well as any other limitations at the account or campaign level). ARCHIVED - Denotes that the campaign group is presently inactive, and should mostly be hidden in the UI until un-archived. CANCELLED - Denotes that the campaign group has been permanently canceled and cannot be reactivated. Not a settable status. DRAFT - Denotes that the campaign group is in a preliminary state and should temporarily not be served. PAUSED - Denotes that the campaign group meets all requirements to be served, but temporarily should not be. PENDING\_DELETION - Denotes that the campaign group has been requested to be deleted that is currently pending. REMOVED - Denoted that the campaign group was deleted, but must remain fetchable due to the existence of performance data. | | STRING | type | TEXT\_AD - Text-based ads that show up in the right column or top of the page on LinkedIn.SPONSORED\_UPDATES - Native ads that promote a company's content updates in the LinkedIn feed.SPONSORED\_INMAILS - Personalized messages with a call-to-action button delivered to a LinkedIn's member inbox.DYNAMIC - Ads that are dynamically personalized. | | STRING | cost\_type | CPM - Cost per thousand advertising impressions. If type=SPONSORED\_INMAILS; cost per send(CPS) is measured as CPM x 1000.CPC- Cost per individual click on the associated link.CPV- Cost per view for video ads. | | STRING | creative\_selection | ROUND\_ROBIN - Rotate through available creatives to serve them as evenly as possible.OPTIMIZED (default) - Bias selection taking into account such as expected performance. Not available for Message and Conversation Ads (type=SPONSORED\_INMAILS). | | DECIMAL | daily\_budget\_amount | Maximum amount to spend per day UTC. The amount of money as a real number string. | | STRING | daily\_budget\_currency\_code | ISO currency code. The currency must match that of the parent account. | | DECIMAL | unit\_cost\_amount | This value is used as one of the following: amount to bid (for manual bidding), amount which is the target cost (for target cost bidding) per click, impression, or other event depending on the pricing model, or cost cap (for cost cap bidding). The amount of money as a real number string. The amount should be non-negative if the bidding strategy is manual, target cost, or cost cap bidding. The default is 0 with the currency code set to match that of the associated account. | | STRING | unit\_cost\_currency\_code | Amount to bid per click, impression, or other event depending on the pricing model. The default is 0 with the currency code set to match that of the associated account. ISO currency code. | | STRING | currency | The ISO 4217 currency code of the account, such as 'USD' for United States Dollar (default). | | STRING | format | The ad format on the campaign level. See | | STRING | locale\_country | Locale of the campaign. An uppercase two-letter country code as defined by ISO-3166. | | STRING | locale\_language | Locale of the campaign. A lowercase two-letter language code as defined by ISO-639. | | STRING | objective\_type | Campaign Objective type values. Click [here](https://docs.microsoft.com/en-us/linkedin/marketing/integrations/ads-reporting/ad-budget-pricing-type-combinations?view=li-lms-2022-07) for Campaign Objective descriptions. One of: - BRAND\_AWARENESS - ENGAGEMENT - JOB\_APPLICANTS - LEAD\_GENERATION - WEBSITE\_CONVERSIONS - WEBSITE\_VISITS - VIDEO\_VIEWS | | STRING | optimization\_target\_type | Determines how this campaign is optimized for spending. If this is not set, there is no optimization. Refer to the documentation here. Default = 'NONE'. | | BOOLEAN | is\_audience\_expansion\_enabled | Boolean (default=false) representing whether Audience Expansion is enabled for the campaign provides query expansion for certain targeting criteria. | | BOOLEAN | is\_offsite\_delivery\_enabled | Boolean indicating if this campaign to allowed to be served on the LinkedIn Audience Network to extend the reach of your campaign by delivering ads beyond the LinkedIn feed to members on third-party apps and sites. (default will be "True" from June 30, 2022) | | DATETIME | run\_schedule\_start\_at | Scheduled date range to run associated creatives. The start date must be non-null. Represents the inclusive (greater than or equal to) value in which to start the range. | | DATETIME | run\_schedule\_end\_at | Scheduled date range to run associated creatives. The start date must be non-null. Represents the exclusive (strictly less than) value in which to end the range, if provided. | | DATETIME | last\_modified\_at | The timestamp of when the version was updated. | | DATETIME | created\_at | The timestamp of when the campaign was created. | | INTEGER | clicks | The count of chargeable clicks. | | INTEGER | impressions | This is the count of "impressions" for Direct Ads and Sponsored Updates and "sends" for InMails. | | INTEGER | cost | The cost of the ads in the local currency or USD. | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/linkedin-ads-campaign-report.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.