The Relational database model structure

The Cervinodata datamodel consists of data from Google Analytics (on multiple dimensions) as well as Advertising data. The relationship between the tables is shown on the following page. This data model is subject to change, as new Ad platforms become available in the market and more dimension become relevant for our customers. This support article will stay up-to-date when the datamodel is changed.

Download the latest version of the relational datamodel at the bottom of this article.

The data is stored in the following tables

account
account_report
ad
ad_group
ad_group_report
ad_platform
ad_report
adform_campaign_report
analytics_campaign
analytics_campaign_goal_report
analytics_campaign_report
analytics_campaign_source_medium_goal_report
analytics_campaign_source_medium_report
analytics_channel_group_goal_report
analytics_channel_group_report
analytics_device_type_channel_group_goal_report
analytics_device_type_channel_group_report
analytics_device_type_goal_report
analytics_device_type_report
analytics_goal
analytics_goal_report
analytics_report
analytics_source_medium_goal_report
analytics_source_medium_report
application_version
bing_ads_campaign_report
campaign
campaign_group
campaign_group_link_analytics_campaign
campaign_group_link_campaign
campaign_group_link_customer
campaign_report
channel_group
customer
customer_link_campaign
device_sub_type
device_type
double_click_bid_manager_campaign_report
facebook_ad_ad_group_report
facebook_ad_ad_group_report_custom_conversion
facebook_ad_ad_report
facebook_ad_ad_report_custom_conversion
facebook_ad_campaign_report
facebook_ad_campaign_report_custom_conversion
facebook_ad_custom_conversion
google_ads_ad_group_report
google_ads_campaign_report
insertion_order
insertion_order_report
linked_in_ads_campaign_report
network_type
period_type
pinterest_ads_campaign_report
report
snapchat_ads_campaign_report
sub_ad_platform
twitter_ads_campaign_report
view