ERD for Pinterest Ads

10 tables

Loading diagram…

ad_group_report

AD_GROUP_ID

string

index

int

AD_ACCOUNT_ID

string

DATE

date

AD_ID

string

CAMPAIGN_DAILY_SPEND_CAP

long

CAMPAIGN_ENTITY_STATUS

string

CAMPAIGN_ID

string

CAMPAIGN_LIFETIME_SPEND_CAP

long

CAMPAIGN_NAME

string

CPC_IN_MICRO_DOLLAR

double

CPM_IN_MICRO_DOLLAR

double

ECPC_IN_MICRO_DOLLAR

double

ECPM_IN_MICRO_DOLLAR

double

ENGAGEMENT_RATE

double

INAPP_CHECKOUT_COST_PER_ACTION

long

PAGE_VISIT_COST_PER_ACTION

float

PAGE_VISIT_ROAS

float

PAID_IMPRESSION

long

IMPRESSION_1

long

IMPRESSION_1_GROSS

long

IMPRESSION_2

long

TOTAL_IMPRESSION_FREQUENCY

double

PIN_ID

string

REPIN_RATE

float

SPEND_IN_MICRO_DOLLAR

long

TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_CLICKTHROUGH

long

TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_CONVERSIONS

long

TOTAL_ENGAGEMENT

long

TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_ENGAGEMENT_LEAD

long

TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_SIGNUP

int

TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND

float

TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_VIEW_SIGNUP

int

TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

WEB_CHECKOUT_ROAS

float

WEB_CHECKOUT_COST_PER_ACTION

double

string

board_id

string

created_at

string

link

string

title

string

description

string

dominant_color

string

alt_text

string

board_owner

string

ad_account

string

name

string

owner_username

string

country

string

currency

string

permissions

string

ad_group_id

string

ad_account_id

string

campaign_id

string

pin_id

string

collection_items_destination_url_template

string

creative_type

string

destination_url

string

is_pin_deleted

boolean

name

string

status

string

created_time

date

review_status

string

summary_status

string

type

string

updated_time

date

campaign

string

ad_account_id

string

campaign_budget_optimization_enabled

boolean

daily_spend_cap

long

end_time

date

lifetime_spend_cap

long

name

string

start_time

date

status

string

created_time

date

objective_type

string

summary_status

string

type

string

updated_time

date

campaign_report

CAMPAIGN_ID

string

index

int

AD_ACCOUNT_ID

string

AD_GROUP_ENTITY_STATUS

string

AD_GROUP_ID

string

AD_ID

string

CAMPAIGN_DAILY_SPEND_CAP

long

CAMPAIGN_ENTITY_STATUS

string

CAMPAIGN_LIFETIME_SPEND_CAP

long

CAMPAIGN_NAME

string

CPC_IN_MICRO_DOLLAR

double

CPM_IN_MICRO_DOLLAR

double

ECPC_IN_MICRO_DOLLAR

double

ECPM_IN_MICRO_DOLLAR

double

ENGAGEMENT_RATE

double

INAPP_CHECKOUT_COST_PER_ACTION

float

PAGE_VISIT_COST_PER_ACTION

float

PAGE_VISIT_ROAS

float

PAID_IMPRESSION

float

IMPRESSION_1

long

IMPRESSION_1_GROSS

long

IMPRESSION_2

long

TOTAL_IMPRESSION_FREQUENCY

double

PIN_ID

string

REPIN_RATE

float

SPEND_IN_MICRO_DOLLAR

long

TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_CLICKTHROUGH

float

TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_CONVERSIONS

float

TOTAL_ENGAGEMENT

float

TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_ENGAGEMENT_LEAD

float

TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_SIGNUP

float

TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND

float

TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_VIEW_SIGNUP

float

TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_CHECKOUT

float

TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_CLICK_CHECKOUT

float

TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_ENGAGEMENT_CHECKOUT

float

TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_VIEW_CHECKOUT

float

TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

WEB_CHECKOUT_ROAS

float

WEB_CHECKOUT_COST_PER_ACTION

float

ad_account_report

AD_ACCOUNT_ID

string

index

int

AD_GROUP_ENTITY_STATUS

string

AD_GROUP_ID

string

AD_ID

string

CAMPAIGN_DAILY_SPEND_CAP

long

CAMPAIGN_ENTITY_STATUS

string

CAMPAIGN_ID

string

CAMPAIGN_LIFETIME_SPEND_CAP

long

CAMPAIGN_NAME

string

CPC_IN_MICRO_DOLLAR

double

CPM_IN_MICRO_DOLLAR

double

ECPC_IN_MICRO_DOLLAR

double

ECPM_IN_MICRO_DOLLAR

double

ENGAGEMENT_RATE

double

INAPP_CHECKOUT_COST_PER_ACTION

float

PAGE_VISIT_COST_PER_ACTION

float

PAGE_VISIT_ROAS

float

PAID_IMPRESSION

float

IMPRESSION_1

long

IMPRESSION_1_GROSS

long

IMPRESSION_2

long

TOTAL_IMPRESSION_FREQUENCY

double

PIN_ID

string

REPIN_RATE

float

SPEND_IN_MICRO_DOLLAR

long

TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_CLICKTHROUGH

float

TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_CONVERSIONS

float

TOTAL_ENGAGEMENT

float

TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_ENGAGEMENT_LEAD

float

TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_SIGNUP

float

TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND

float

TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_VIEW_SIGNUP

float

TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_CHECKOUT

float

TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_CLICK_CHECKOUT

float

TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_ENGAGEMENT_CHECKOUT

float

TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_VIEW_CHECKOUT

float

TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

WEB_CHECKOUT_ROAS

float

WEB_CHECKOUT_COST_PER_ACTION

double

ad_report

AD_ID

string

index

int

AD_ACCOUNT_ID

string

AD_GROUP_ENTITY_STATUS

string

AD_GROUP_ID

string

CAMPAIGN_DAILY_SPEND_CAP

long

CAMPAIGN_ENTITY_STATUS

string

CAMPAIGN_ID

string

CAMPAIGN_LIFETIME_SPEND_CAP

long

CAMPAIGN_NAME

string

CPC_IN_MICRO_DOLLAR

double

CPM_IN_MICRO_DOLLAR

double

ECPC_IN_MICRO_DOLLAR

double

ECPM_IN_MICRO_DOLLAR

double

ENGAGEMENT_RATE

double

INAPP_CHECKOUT_COST_PER_ACTION

float

PAGE_VISIT_COST_PER_ACTION

float

PAGE_VISIT_ROAS

float

PAID_IMPRESSION

float

IMPRESSION_1

long

IMPRESSION_1_GROSS

long

IMPRESSION_2

long

TOTAL_IMPRESSION_FREQUENCY

double

PIN_ID

string

REPIN_RATE

float

SPEND_IN_MICRO_DOLLAR

long

TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_CLICKTHROUGH

float

TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_CONVERSIONS

float

TOTAL_ENGAGEMENT

float

TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_ENGAGEMENT_LEAD

float

TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_SIGNUP

float

TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND

float

TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_VIEW_SIGNUP

float

TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR

long

WEB_CHECKOUT_ROAS

float

WEB_CHECKOUT_COST_PER_ACTION

float

board

string

name

string

description

string

owner

string

owner_username

string

ad_group

ad_account_id

string

campaign_id

string

auto_targeting_enabled

boolean

bid_in_micro_currency

int

bid_strategy_type

string

budget_in_micro_currency

int

budget_type

string

end_time

date

lifetime_frequency_cap

int

name

string

pacing_delivery_type

string

placement_group

string

start_time

date

status

string

targeting_spec

string

billable_event

string

conversion_learning_mode_type

string

created_time

date

summary_status

string

type

string

updated_time

date

Table

Sub table