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:
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:
-
Obtain credentials and SYSADMIN privileges to connect to your cloud data warehouse. The cloud data warehouse must contain the data you would like ThoughtSpot to use to create Answers, Liveboards, and Worksheets. Refer to the connection reference for your cloud data warehouse for information about required credentials:
-
The connection name for each new SpotApp must be unique.
-
Administrator access to LinkedIn Ads
-
Access to the following LinkedIn Ads tables and Worksheets in your cloud data warehouse. Refer to LinkedIn Ads SpotApp schema for more details.
-
AD_ANALYTICS_BY_CAMPAIGN
-
CAMPAIGN_HISTORY
-
CAMPAIGN_GROUP_HISTORY
-
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 |
