LinkedIn Revenue Attribution Report: Most-used fields

The table below gives information about most-used fields that you can import from LinkedIn Revenue Attribution Report. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Description	Use in Adverity
adSpend.amount	adSpend.amount	The total cost of ad spend in the account’s local currency based on the selected pivot and time granularity.	metric
adSpend.currencyCode	adSpend.currencyCode	The currency code (e.g., USD, EUR) used for reporting ad spending. This aligns with the ‘costInLocalCurrency’ metric available in the API response, which represents costs in the account’s local currency.	dimension
averageDaysToClose	averageDaysToClose	The average number of days it took to close a won deal attributed to LinkedIn marketing. This is calculated as the total opportunity length in days divided by the number of closed-won opportunities.	metric
averageDealSize.amount	averageDealSize.amount	Of closed-won opportunities, this represents the average size of deals influenced by LinkedIn marketing, reported in USD.	metric
averageDealSize.currencyCode	averageDealSize.currencyCode	The currency code for the average deal size amount, which is USD.	dimension
closedWonOpportunities	closedWonOpportunities	The total number of opportunities that have been successfully closed and won, attributed to LinkedIn marketing efforts.	metric
endDate	endDate	The inclusive end date for the reporting period, specified in UTC. If unset, it defaults to today’s date.	dimension
groupByValues	groupByValues	The collection of dimensions used to group the report data, such as by sponsored account, campaign, or campaign group.	dimension
groupByValues.businessManagerAccount	groupByValues.businessManagerAccount	A grouping dimension representing the Business Manager account, which owns ad accounts, by which the report data is aggregated.	metric
groupByValues.sponsoredAccount	groupByValues.sponsoredAccount	A grouping dimension representing the sponsored ad account by which the report data is aggregated.	metric
groupByValues.sponsoredCampaign	groupByValues.sponsoredCampaign	A grouping dimension representing the sponsored campaign by which the report data is aggregated.	metric
groupByValues.sponsoredCampaignGroup	groupByValues.sponsoredCampaignGroup	A grouping dimension representing the sponsored campaign group by which the report data is aggregated.	metric
leadConversionRate	leadConversionRate	The percentage of influenced leads that have converted into opportunities or customers, calculated by dividing the number of converted leads by the total number of influenced leads.	metric
leads	leads	The total count of leads that have been influenced by LinkedIn marketing activities.	metric
openOpportunities	openOpportunities	The number of active CRM deals in progress that are attributed to LinkedIn marketing efforts. This metric is available when the date range includes the current day.	metric
opportunityAmount.amount	opportunityAmount.amount	The total revenue in USD of open opportunities (CRM deals in progress) attributed to LinkedIn marketing. This metric is available when the date range includes the current day.	metric
opportunityAmount.currencyCode	opportunityAmount.currencyCode	The currency code for the opportunity amount, which is USD.	dimension
opportunityWinRate	opportunityWinRate	The rate at which opportunities are won out of all closed opportunities, calculated as closed-won opportunities divided by the total number of closed opportunities.	metric
returnOnAdSpend	returnOnAdSpend	The ratio of total revenue won attributed to LinkedIn marketing divided by the LinkedIn ad spend. This metric shows the efficiency of advertising investment.	metric
revenueAttributionMetricErrors	revenueAttributionMetricErrors		dimension
revenueAttributionMetricWarnings	revenueAttributionMetricWarnings		dimension
revenueWon.amount	revenueWon.amount	The total sales revenue in USD from closed-won opportunities that can be attributed to LinkedIn ads.	metric
revenueWon.currencyCode	revenueWon.currencyCode	The currency code for the revenue won amount, which is USD.	dimension
startDate	startDate	The inclusive start date for the reporting period, specified in UTC. This field is required.	dimension