Google Ad Analysis 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 Google Ad Analysis SpotApp mimics the Google Ads data model. When you deploy it, ThoughtSpot creates several worksheets, answers, and Liveboards, based on your Google Ads data in your cloud data warehouse.

This is a sample Liveboard, created after you deploy the Google Ad Analysis SpotApp:

Google Ad Analysis SpotApp Liveboard

Use the Google Ad Analysis SpotApp to get invaluable insight into your Google Ads performance, from high-level usage to identifying popular campaigns.

Prerequisites

Before you can deploy the Google Ad Analysis SpotApp, you must complete the following prerequisites:

Deploy the Google Ad Analysis SpotApp

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

To deploy the Google Ad Analysis SpotApp, refer to Deploying SpotApps.

Google Ad Analysis SpotApp schema

The following table describes the schema for the Google Ad Analysis SpotApp.

Table Column Column type Required column

GOOGLEADS_AD

AD_TYPE

VARCHAR

N

GOOGLEADS_AD

IMAGE_AD_NAME

VARCHAR

N

GOOGLEADS_AD

NETWORK

VARCHAR

N

GOOGLEADS_AD

CLICKS

INT64

Y

GOOGLEADS_AD

CONVERSIONS

FLOAT

N

GOOGLEADS_AD

COST_USD

FLOAT

Y

GOOGLEADS_AD

ENGAGEMENTS

INT64

N

GOOGLEADS_AD

IMPRESSIONS

INT64

Y

GOOGLEADS_AD

INTERACTIONS

INT64

N

GOOGLEADS_AD

DATE

DATE

Y

GOOGLEADS_AD

CAMPAIGN_NAME

VARCHAR

N

GOOGLEADS_AD

DEVICE

VARCHAR

N

GOOGLEADS_AD

VIDEO_IMPRESSIONS

VARCHAR

N

GOOGLEADS_CAMPAIGN

CAMPAIGN_NAME

VARCHAR

Y

GOOGLEADS_CAMPAIGN

CAMPAIGN_STATUS

VARCHAR

N

GOOGLEADS_CAMPAIGN

DATE

DATE

Y

GOOGLEADS_CAMPAIGN

CLICKS

INT64

Y

GOOGLEADS_CAMPAIGN

CONVERSIONS

FLOAT

Y

GOOGLEADS_CAMPAIGN

COST_USD

FLOAT

Y

GOOGLEADS_CAMPAIGN

ENGAGEMENTS

INT64

N

GOOGLEADS_CAMPAIGN

IMPRESSIONS

INT64

Y

GOOGLEADS_CAMPAIGN

INTERACTIONS

INT64

N

GOOGLEADS_CAMPAIGN

BIDDING_STRATEGY_TYPE

VARCHAR

N

GOOGLEADS_CAMPAIGN

DAILY_BUDGET

FLOAT

N

GOOGLEADS_CAMPAIGN

CAMPAIGN_ID

VARCHAR

Y

GOOGLEADS_KEYWORD

KEYWORD

VARCHAR

N

GOOGLEADS_KEYWORD

NETWORK

VARCHAR

N

GOOGLEADS_KEYWORD

COST_USD

FLOAT

Y

GOOGLEADS_KEYWORD

IMPRESSIONS

INT64

Y

GOOGLEADS_KEYWORD

CONVERSIONS

FLOAT

N

GOOGLEADS_KEYWORD

DATE

DATE

Y

GOOGLEADS_KEYWORD

CLICKS

INT64

Y

GOOGLEADS_GEO

REGION

VARCHAR

N

GOOGLEADS_GEO

CONVERSIONS

FLOAT

N

GOOGLEADS_GEO

COST_USD

FLOAT

Y

GOOGLEADS_GEO

IMPRESSIONS

INT64

Y

GOOGLEADS_GEO

METRO_AREA

VARCHAR

Y

GOOGLEADS_GEO

COUNTRY_NAME

VARCHAR

Y

GOOGLEADS_GEO

CLICKS

INT64

Y

GOOGLEADS_GEO

DATE

DATE

Y