LinkedIn Ads SpotApp

SpotApps are ThoughtSpot’s out-of-the-box solution templates built for specific use cases and data sources. They are built on ThoughtSpot Modeling Language (TML) Blocks, which are pre-built pieces of code that are easy to download and implement directly from the product.

The LinkedIn Ads SpotApp mimics the LinkedIn Ads data model. When you deploy it, ThoughtSpot creates several Worksheets, Answers, and Liveboards, based on your LinkedIn Ads data in your cloud data warehouse.

This is a sample Liveboard, created after you deploy the LinkedIn Ads SpotApp:

Linkedin Ads Analysis SpotApp Liveboard

Use the LinkedIn Ads SpotApp to get invaluable insight into your LinkedIn Ads performance, from high-level usage to identifying popular projects.

Prerequisites

Before you can deploy the LinkedIn Ads SpotApp, you must complete the following prerequisites:

Deploy the LinkedIn Ads SpotApp

After you complete the prerequisites, you are ready to deploy the LinkedIn Ads SpotApp and begin leveraging its pre-built content.

To deploy the LinkedIn Ads SpotApp, refer to Deploying SpotApps.

LinkedIn Ads SpotApp schema

The following table describes the schema for the LinkedIn Ads SpotApp.

Table Column Column type Required column

AD_ANALYTICS_BY_CAMPAIGN

COST_IN_USD

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

CLICKS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

IMPRESSIONS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

EXTERNAL_WEBSITE_CONVERSIONS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

ONE_CLICK_LEADS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

CONVERSION_VALUE_IN_LOCAL_CURRENCY

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

CAMPAIGN_ID

NUMBER

N

AD_ANALYTICS_BY_CAMPAIGN

CARD_CLICKS

NUMBER

N

AD_ANALYTICS_BY_CAMPAIGN

CARD_IMPRESSIONS

NUMBER

N

AD_ANALYTICS_BY_CAMPAIGN

COMMENT_LIKES

NUMBER

N

AD_ANALYTICS_BY_CAMPAIGN

COMMENTS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

COMPANY_PAGE_CLICKS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

COST_IN_LOCAL_CURRENCY

NUMBER

N

AD_ANALYTICS_BY_CAMPAIGN

FOLLOWS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

LANDING_PAGE_CLICKS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

LIKES

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

SHARES

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

TOTAL_ENGAGEMENTS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

VIDEO_COMPLETIONS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

VIDEO_FIRST_QUARTILE_COMPLETIONS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

VIDEO_MIDPOINT_COMPLETIONS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

VIDEO_THIRD_QUARTILE_COMPLETIONS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

VIDEO_VIEWS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

VIRAL_CLICKS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

VIRAL_IMPRESSIONS

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

VIRAL_LIKES

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

VIRAL_SHARES

NUMBER

Y

AD_ANALYTICS_BY_CAMPAIGN

VIRAL_VIDEO_COMPLETIONS

NUMBER

N

AD_ANALYTICS_BY_CAMPAIGN

VIRAL_VIDEO_FIRST_QUARTILE_COMPLETIONS

NUMBER

N

AD_ANALYTICS_BY_CAMPAIGN

VIRAL_VIDEO_THIRD_QUARTILE_COMPLETIONS

NUMBER

N

AD_ANALYTICS_BY_CAMPAIGN

VIRAL_VIDEO_VIEWS

NUMBER

N

AD_ANALYTICS_BY_CAMPAIGN

VIRAL_VIDEO_MIDPOINT_COMPLETIONS

NUMBER

N

AD_ANALYTICS_BY_CAMPAIGN

ONE_CLICK_LEAD_FORM_OPENS

NUMBER

N

AD_ANALYTICS_BY_CAMPAIGN

DAY

TIMESTAMP_TZ

Y

CAMPAIGN_HISTORY

RUN_SCHEDULE_END

TIMESTAMP_TZ

Y

CAMPAIGN_HISTORY

RUN_SCHEDULE_START

TIMESTAMP_TZ

Y

CAMPAIGN_HISTORY

ID

NUMBER

Y

CAMPAIGN_HISTORY

CREATED_TIME

TIMESTAMP_TZ

Y

CAMPAIGN_HISTORY

TYPE

VARCHAR

Y

CAMPAIGN_HISTORY

OBJECTIVE_TYPE

VARCHAR

Y

CAMPAIGN_HISTORY

OPTIMIZATION_TARGET_TYPE

VARCHAR

Y

CAMPAIGN_HISTORY

COST_TYPE

VARCHAR

N

CAMPAIGN_HISTORY

NAME

VARCHAR

Y

CAMPAIGN_HISTORY

STATUS

VARCHAR

Y

CAMPAIGN_HISTORY

FORMAT

VARCHAR

N

CAMPAIGN_HISTORY

LOCALE_COUNTRY

VARCHAR

N

CAMPAIGN_HISTORY

DAILY_BUDGET_AMOUNT

FLOAT

Y

CAMPAIGN_HISTORY

DAILY_BUDGET_CURRENCY_CODE

VARCHAR

N

CAMPAIGN_HISTORY

UNIT_COST_AMOUNT

FLOAT

Y

CAMPAIGN_HISTORY

UNIT_COST_CURRENCY_CODE

VARCHAR

N

CAMPAIGN_HISTORY

ACCOUNT_ID

NUMBER

N

CAMPAIGN_HISTORY

CAMPAIGN_GROUP_ID

NUMBER

N

CAMPAIGN_GROUP_HISTORY

ID

NUMBER

Y

CAMPAIGN_GROUP_HISTORY

NAME

VARCHAR

N

CAMPAIGN_GROUP_HISTORY

STATUS

VARCHAR

N