Table of contents
Overview
In this article, you’ll be able to find information and answers to the data structure. After setting up our platform, you’ll have access to the data through a dashboard or through the API. Below, you’ll find all the tables, their columns and metrics we make available in our dashboards or through the API.
For more information on the API please refer to our API documentation.
Attributions and costs
The attribution and costs table is, as the name implies a table which contains all the information about the conversions joined with the costs from the respective channels. The name of the attributions and costs table is [yourcustomername]_attributions_and_costs
The attributions and costs table contains the following fields:
Column Name | Verbose Name (in Dashboard) | Type | Description | Applicable for |
ad_product_group | Group | TEXT | Product Group Google Shopping) | Google Shopping |
countbiddingstrategytype | NUMERIC | Count of Bidding Strategy Type | ||
placement | TEXT | Placement Name | Google Analytics 360 or Google Campaign Manager/ DCM | |
creative | TEXT | Creative Name | Google Analytics 360 or Google Campaign Manager/ DCM | |
productgroup | TEXT | Product Group | ||
landingpageexp | DOUBLE PRECISION | Landing Page Experience Score | Google Ads
Bing |
|
searchtopis | REAL | Search Top Impression Share | Google Ads
Bing |
|
searchabstopis | REAL | Search Absolute Top Impression Share | Google Ads
Bing |
|
imprtop | REAL | Impressions Top | Google Ads
Bing |
|
imprabstop | REAL | Impressions Absolute Top | Google Ads
Bing |
|
adgroup | TEXT | Ad Group | Google Ads
Bing |
|
matchtype | TEXT | Matchtype | Google Ads
Bing |
|
status | TEXT | Status of ad (can be enabled or disabled) | Google Ads
Bing |
|
displayurl | TEXT | Display URL | Google Ads
Bing |
|
destinationurl | TEXT | Destination URL | Google Ads
Bing |
|
channelgrouping | TEXT | Custom Channel Grouping | Google Ads
Bing |
|
maxcpc | REAL | Max CPC bid | Google Ads
Bing |
|
avgcpc | REAL | Average CPC | Google Ads
Bing |
|
firstpagecpc | REAL | First Page CPC bid | Google Ads
Bing |
|
firstpositioncpc | REAL | First Position CPC bid | Google Ads
Bing |
|
clickstoconversion | REAL | Clicks which contributed to conversions | ||
impressionstoconversion | REAL | Impressions which contributed to conversions | ||
headline2 | TEXT | Headline 2 | Google Ads
Bing |
|
totalcost | Cost | REAL | Spend | |
type | Conversion type / Country | TEXT | Conversion type name (eCommerce Transaction or Goal Name) | |
keyword | TEXT | Keyword | Google Ads
Bing Facebook (used for ad name) |
|
date | Date | TIMESTAMP WITH TIME ZONE | Date | |
source | Source | TEXT | Source or Site | |
medium | Medium | TEXT | Medium | |
campaign | Campaign | TEXT | Campaign | |
markov | Attributed conversions | REAL | Data-Driven Attributed Conversions | |
first_touch | First touch | REAL | First Touch Conversions | |
reportedgoalcompletions | Reported goal completions | REAL | Platform Reported Goal Completions | |
last_touch_value | Last touch attributed revenue | REAL | Last Touch Conversion Value | |
markov_value | Attributed revenue | REAL | Data-Driven Attributed Conversion Value | |
last_touch | Last touch | REAL | Last Touch Conversions | |
first_touch_value | First touch attributed revenue | REAL | First Touch Conversion Value | |
clicks | REAL | Clicks | ||
impressions | REAL | Impressions | ||
viewableimpressions | REAL | Viewable Impressions | Google Ads
Bing |
|
exactmatchis | REAL | Exact Match Impression Share | Google Ads
Bing |
|
searchis | REAL | Search Impression Share | Google Ads
Bing |
|
searchlostisrank | REAL | Search Lost Impression Share because of Rank | Google Ads
Bing |
|
optimisation_message | TEXT | Optimisation suggestion | ||
bouncerate | REAL | Bounce Rate | Google Ads
Bing |
|
avgposition | REAL | Average Position | Google Ads
Bing |
|
adrelevance | DOUBLE PRECISION | Ad Relevance | ||
contentlostisbudget | REAL | Content Impression Share Lost because of budget | Google Ads
Bing |
|
searchlostisbudget | REAL | Search Impression Share lost because of budget | Google Ads
Bing |
|
contentis | REAL | Content Impression Share | Google Ads
Bing |
|
contentlostisrank | REAL | Content Impression Share lost because of rank | Google Ads
Bing |
|
qualityscore | Quality Score (1-10) | DOUBLE PRECISION | Quality Score | Google Ads
Bing |
channelgroup | Channel group | Custom Channel Group | ||
adcontent | Content | TEXT | Ad Content | Google Ads
Bing |
adgroupid | TEXT | Ad Group ID | Google Ads | |
keywordid | TEXT | Keyword ID | Google Ads | |
accountid | TEXT | Account ID | Google Ads | |
countaccountid | NUMERIC | Count of Account ID’s | ||
expectedctr | DOUBLE PRECISION | Expected Click-through rate | Google Ads
Bing |
|
topofpagecpc | REAL | Top of page CPC | Google Ads | |
adwordsnetwork | TEXT | Adwords Network | Google Ads | |
countadwordsnetwork | NUMERIC | Count of Adwords Network | Google Ads | |
device | TEXT | Device Type | Google Ads
Bing |
|
countdevice | NUMERIC | Device Count | Google Ads | |
adwordskeyword | TEXT | Keyword | Google Ads | |
countadgroup | NUMERIC | Count of Ad Groups | Google Ads | |
label | TEXT | Google Ads Label | Google Ads
Bing |
|
countlabel | NUMERIC | Count of Google Ads Label | Google Ads | |
countmatchtype | NUMERIC | Count of matchtype | Google Ads | |
countstatus | NUMERIC | Count of status | Google Ads | |
countheadline2 | NUMERIC | Count of headline 2 | Google Ads
Bing |
|
countdisplayurl | NUMERIC | Count of display URL’s | Google Ads
Bing |
|
countdestinationurl | NUMERIC | Count of destination URL’s | Google Ads
Bing |
|
countproductgroup | REAL | Count of ad product group | Google Ads
Bing |
|
adid | TEXT | Google Ads Ad Id | Google Ads | |
countadid | NUMERIC | Count of Google Ads Ad ID | Google Ads | |
countadgroupid | NUMERIC | Count of Adgroup ID | Google Ads | |
countkeywordid | NUMERIC | Count of Keyword ID | Google Ads | |
campaignid | TEXT | Campaign ID | Google Ads | |
countcampaignid | NUMERIC | Count of Campaign ID | Google Ads | |
reportedgoalallcompletions | REAL | Platform reported Goal Completions | ||
productgroupl2 | Product Group L2 | TEXT | Google Ads Product Group L2 | Google Ads |
biddingstrategytype | BiddingStrategyType | TEXT | Bidding Strategy Type | Google Ads
Bing |
Conversions
The conversions table contains the conversion journeys before they are modelled. This table provides the opportunity to gain customer journey information on a goal completion or transaction level.
The attributions and costs table contains the following fields:
Column | Type | Description | Applicable for |
date | TIMESTAMP WITH TIME ZONE | Date | |
type | TEXT | Conversion type name (eCommerce Transaction or Goal Name) | |
sourcepath | TEXT | Source or site path to conversion | Google Analytics or Google Campaign Manager/ DCM |
mediumpath | TEXT | Medium path to conversion | Google Analytics or Google Campaign Manager/ DCM |
campaignpath | TEXT | Campaign path to conversion | Google Analytics or Google Campaign Manager/ DCM |
keywordpath | TEXT | Keyword path to conversion | Google Analytics or Google Campaign Manager/ DCM |
adwordsadcontentpath | TEXT | Adwords ad content path to conversion | Google Analytics or Google Campaign Manager/ DCM |
placementpath | TEXT | Placement path to conversion | Google Analytics 360 or Google Campaign Manager/ DCM |
creativepath | TEXT | Creative path to conversion | Google Analytics 360 or Google Campaign Manager/ DCM |
dayslag | REAL | Count of days from first interaction to conversion | |
totalconversions | REAL | Count of conversions | |
totalnotconversions | REAL | Count of non-conversions | |
totalconversionvalue | REAL | Sum of conversion value | |
totalnotconversionvalue | REAL | Sum of non-conversion value | |
adwordsadgrouppath | TEXT | Google Ads ad group path | |
channelgroupingpath | TEXT | Custom channel-group path | |
adwordscreativeidpath | TEXT | Google Ads creative ID path | |
transactionid | REAL | eCommerce Transaction ID | Google Analytics eCommerce Transactions |