Facebook 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 Facebook Ads SpotApp mimics the Facebook data model. When you deploy it, ThoughtSpot creates several Worksheets, Answers, and Liveboards, based on your Facebook data in your cloud data warehouse.

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

Facebook SpotApp Liveboard

Use the Facebook Ads SpotApp to measure ad performance across platforms to grow reach, engagement, & sales.

Prerequisites

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

Deploy the Facebook Ads SpotApp

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

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

Facebook Ads SpotApp schema

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

Table Column Column type Required column

FBADS_CAMPAIGN

CAMPAIGN_NAME

VARCHAR

Y

FBADS_CAMPAIGN

COST_USD

FLOAT

Y

FBADS_CAMPAIGN

DATE

DATE

Y

FBADS_CAMPAIGN

CAMPAIGN_END_DATE

DATE

Y

FBADS_CAMPAIGN

CAMPAIGN_START_DATE

DATE

Y

FBADS_CAMPAIGN

CAMPAIGN_STATUS

VARCHAR

Y

FBADS_CAMPAIGN

CAMPAIGN_ID

VARCHAR

Y

FBADS_CAMPAIGN

CAMPAIGN_DAILY_BUDGET

FLOAT

Y

FBADS_CAMPAIGN

CAMPAIGN_BUYING_TYPE

VARCHAR

Y

FBADS_CAMPAIGN

CAMPAIGN_OBJECTIVE

VARCHAR

Y

FBADS_CAMPAIGN

PLATFORM_POSITION

VARCHAR

Y

FBADS_CAMPAIGN

PUBLISHER_PLATFORM

VARCHAR

Y

FBADS_AD

DATE

DATE

Y

FBADS_AD

CLICKS

NUMBER

Y

FBADS_AD

IMPRESSIONS

NUMBER

Y

FBADS_AD

OFFSITE_CONVERSIONS

NUMBER

Y

FBADS_AD

CAMPAIGN_NAME

VARCHAR

Y

FBADS_AD

COST_USD

FLOAT

Y

FBADS_AD

PUBLISHER_PLATFORM

VARCHAR

Y

FBADS_AD

ESTIMATED_AD_RECALLERS

NUMBER

N

FBADS_AD

REACH

NUMBER

Y

FBADS_AD

ACCOUNT_ID

VARCHAR

N

FBADS_AD

ACCOUNT_NAME

VARCHAR

N

FBADS_AD

AD_ID

VARCHAR

N

FBADS_AD

AD_NAME

VARCHAR

Y

FBADS_AD

AD_GROUP_ID

VARCHAR

N

FBADS_AD

AD_GROUP_NAME

VARCHAR

N

FBADS_AD

ACTIONS

NUMBER

Y

FBADS_AD

SPEND_CAP

FLOAT

Y

FBADS_AD

IMPRESSION_DEVICE

VARCHAR

Y

FBADS_AD

ACTION_PAGE_ENGAGEMENT

NUMBER

Y

FBADS_AD

ACTION_COMMENT

NUMBER

Y

FBADS_GEO

CLICKS

NUMBER

Y

FBADS_GEO

REGION

VARCHAR

N

FBADS_GEO

COUNTRY_NAME

VARCHAR

Y

FBADS_GEO

IMPRESSIONS

NUMBER

Y

FBADS_GEO

ONSITE_CONVERSION_LEAD_GROUPED

NUMBER

Y

FBADS_GEO

CAMPAIGN_ID

VARCHAR

N

FBADS_GEO

AD_ID

VARCHAR

N

FBADS_GEO

AD_NAME

VARCHAR

N

FBADS_GEO

CAMPAIGN_NAME

VARCHAR

N

FBADS_GEO

COUNTRY_CODE

VARCHAR

N

FBADS_GEO

DATE

DATE

N

FBADS_VIDEO

VIDEO_AVERAGE_WATCH_TIME

FLOAT

Y

FBADS_VIDEO

CAMPAIGN_NAME

VARCHAR

Y

FBADS_VIDEO

PUBLISHER_PLATFORM

VARCHAR

Y

FBADS_AGE_GENDER

CLICKS

NUMBER

Y

FBADS_AGE_GENDER

IMPRESSIONS

NUMBER

Y

FBADS_AGE_GENDER

AGE

VARCHAR

Y

FBADS_AGE_GENDER

GENDER

VARCHAR

Y

FBADS_AGE_GENDER

ONSITE_CONVERSION_LEAD_GROUPED

NUMBER

Y

FBADS_CONVERSION

CAMPAIGN_NAME

VARCHAR

Y

FBADS_CONVERSION

DATE

DATE

Y

FBADS_CONVERSION

ACTION_TYPE

VARCHAR

Y

FBADS_CONVERSION

ACTION_DEVICE

VARCHAR

Y

FBADS_CONVERSION

PUBLISHER_PLATFORM

VARCHAR

N

FBADS_CONVERSION

ACTIONS

NUMBER

N

FBADS_CONVERSION

CAMPAIGN_ID

VARCHAR

N