Power BI Connector for LinkedIn Marketing Solutions

Build 24.0.9060

Creatives

The Ad Creatives search finder allows you to search for creatives by id, campaign URN, status, or reference URN.

Table Specific Information

Select

The Creatives view returns a list of the creatives that belong to the authenticated user so they can be used as dimensions in analytic requests.

The connector uses the LinkedIn Marketing Solutions API to process search criteria that refer to the Id, Account, Campaign, and IntendedStatus columns. The connector processes other filters client-side within the connector. For example, the following queries are processed server side.

SELECT * FROM Creatives WHERE Id = '179345687'

SELECT * FROM Creatives WHERE Account = '510013292'

SELECT * FROM Creatives WHERE Account IN ('510013292', '510013293')

SELECT * FROM Creatives WHERE Campaign = '198952936'

SELECT * FROM Creatives WHERE IntendedStatus = 'ACTIVE'

Columns

Name Type Description
Id String Numerical identifier for the creative.
Account String URN identifying the advertising account associated with the creative.
Campaign String URN identifying the campaign associated with the creative.
Content String Content sponsored in the creative.
CreatedAt Datetime Datetime when the creative was first created
CreatedBy String Entity that developed the creative.
IntendedStatus String Creative user intended status.
IsServing Boolean This indicates whether the creative is currently being served or not.
ServingHoldReasons String Array that contains all the reasons why the creative is not serving.
LastModifiedAt Datetime Datetime when the creative was last modified.
LastModifiedBy String Entity that modified the creative.
ReviewStatus String The current review status of the creative.
IsTest Boolean Flag showing whether this creative is a test creative, i.e., belongs to a test campaign.
AdAccountId String Id of the account
CallToActionLabel String Label for the CallToAction button. Present only if the campaign objective is LEAD_GENERATION.
CallToActionFormId String The Id of the corresponding form which the call to action redirects to. Present only if the campaign objective is LEAD_GENERATION.
RejectionReasons String A comma-seperated list of values with reasons explaining why the creative has been rejected.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060