# Amazon DSP

## Data Availability & Refresh Schedule

### Historical Availability

Historical availability of data refers to the pulling in of past data from Amazon in Intentwise Analytics. This refers to your data for the time period before you added a particular account as a data source under My Connections.

|   Report Type  | Historical Availability |
| :------------: | :---------------------: |
| All DSP Tables |         90 days         |

{% hint style="info" %}
For historical data going further back, please write to us at <help@intentwise.com>
{% endhint %}

### Data Refresh Schedule

Data for all Amazon DSP tables is updated daily between 7:30 AM PST to 10:30 AM PST daily.

Intentwise Analytics pulls in multiple days of data daily to account for variations in past data due to various factors like Amazon’s click attribution logic, cancellations/returns, adjustments by Amazon, etc.

The following table highlights the refresh window for each data source—the number of days for which we pull in data from Amazon in every data load cycle.

|   Report Type  | Refresh Window |
| :------------: | :------------: |
| All DSP Tables |     14 days    |

## **Data Source**

To enable the DSP Reports, the datasource: **Amazon DSP** has to be enabled on the Intentwise Platform

## Order

Table name: *dsp\_order*

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name                 | Data type | Description |
| --------------------------- | --------- | ----------- |
| advertiserid                | Integer   |             |
| account\_id                 | Integer   |             |
| account\_name               | String    |             |
| orderid                     | String    |             |
| startdatetime               | Date Time |             |
| enddatetime                 | Date Time |             |
| totalbudgetamount           | Numeric   |             |
| currencycode                | String    |             |
| ordername                   | String    |             |
| agencyfeepercentage         | Numeric   |             |
| deliverystatus              | String    |             |
| deliveryactivationstatus    | String    |             |
| productlocation             | String    |             |
| goal                        | String    |             |
| goalkpi                     | String    |             |
| createddate                 | Date Time |             |
| autooptimizations           | String    |             |
| optimizationbiddingstrategy | String    |             |
| frequencycaptype            | String    |             |
| frequencycapmaximpressions  | Integer   |             |
| frequencycaptimeunitcount   | Integer   |             |
| frequencycaptimeunit        | String    |             |

## Order Budget Cap

Table name: *dsp\_order\_budgetcap*

| Column Name          | Data type | Description |
| -------------------- | --------- | ----------- |
| advertiserid         | Integer   |             |
| account\_id          | Integer   |             |
| account\_name        | String    |             |
| orderid              | String    |             |
| recurrencetimeperiod | String    |             |
| amount               | Numeric   |             |

### Order Budget Flight

Table name: *dsp\_order\_budgetflight*

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name   |   | Data type | Description |
| ------------- | - | --------- | ----------- |
| advertiserid  |   | Integer   |             |
| account\_id   |   | Integer   |             |
| account\_name |   | String    |             |
| orderid       |   | String    |             |
| flightid      |   | Integer   |             |
| startdatetime |   | Date Time |             |
| enddatetime   |   | Date Time |             |
| amount        |   | Numeric   |             |
| spentamount   |   | Numeric   |             |

### Order Report

Table name: *dsp\_order\_report*

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name                                | Data type |   |
| ------------------------------------------ | --------- | - |
| advertiserid                               | Integer   |   |
| account\_id                                | Integer   |   |
| account\_name                              | String    |   |
| reportDate                                 | Date      |   |
| orderid                                    | String    |   |
| 3pfees                                     | Numeric   |   |
| 3pfeeautomotiveabsorbed                    | Numeric   |   |
| 3pfeeautomotive                            | Numeric   |   |
| 3pfeecpm1absorbed                          | Numeric   |   |
| 3pfeecpm1                                  | Numeric   |   |
| 3pfeecpm2absorbed                          | Numeric   |   |
| 3pfeecpm2                                  | Numeric   |   |
| 3pfeecpm3absorbed                          | Numeric   |   |
| 3pfeecpm3                                  | Numeric   |   |
| 3pfeecomscoreabsorbed                      | Numeric   |   |
| 3pfeecomscore                              | Numeric   |   |
| 3pfeedoubleverifyabsorbed                  | Numeric   |   |
| 3pfeedoubleverify                          | Numeric   |   |
| 3pfeedoubleclickcampaignmanagerabsorbed    | Numeric   |   |
| 3pfeedoubleclickcampaignmanager            | Numeric   |   |
| 3pfeeintegraladscienceabsorbed             | Numeric   |   |
| 3pfeeintegraladscience                     | Numeric   |   |
| ctr                                        | Numeric   |   |
| roas14d                                    | Numeric   |   |
| accept14d                                  | Numeric   |   |
| acceptcpa14d                               | Numeric   |   |
| acceptcvr14d                               | Integer   |   |
| acceptclicks14d                            | Numeric   |   |
| acceptviews14d                             | Numeric   |   |
| addtowatchlist14d                          | Numeric   |   |
| addtowatchlistcpa14d                       | Numeric   |   |
| addtowatchlistcvr14d                       | Numeric   |   |
| addtowatchlistclicks14d                    | Integer   |   |
| addtowatchlistviews14d                     | Numeric   |   |
| addedtoshoppingcart14d                     | Numeric   |   |
| addedtoshoppingcartcpa14d                  | Numeric   |   |
| addedtoshoppingcartcvr14d                  | Numeric   |   |
| addedtoshoppingcartclicks14d               | Integer   |   |
| addedtoshoppingcartviews14d                | Numeric   |   |
| advertisercountry                          | String    |   |
| advertisertimezone                         | String    |   |
| agencyfee                                  | Numeric   |   |
| amazonaudiencefee                          | Numeric   |   |
| amazonplatformfee                          | Numeric   |   |
| application14d                             | Numeric   |   |
| applicationcpa14d                          | Numeric   |   |
| applicationcvr14d                          | Numeric   |   |
| applicationclicks14d                       | Integer   |   |
| applicationviews14d                        | Numeric   |   |
| atc14d                                     | Numeric   |   |
| atcclicks14d                               | Integer   |   |
| atcviews14d                                | Numeric   |   |
| atcr14d                                    | Numeric   |   |
| atl14d                                     | Numeric   |   |
| atlclicks14d                               | Integer   |   |
| atlviews14d                                | Numeric   |   |
| atlr14d                                    | Numeric   |   |
| bannerinteraction14d                       | Numeric   |   |
| bannerinteractioncpa14d                    | Numeric   |   |
| bannerinteractioncvr14d                    | Numeric   |   |
| bannerinteractionclicks14d                 | Integer   |   |
| bannerinteractionviews14d                  | Numeric   |   |
| brandstoreengagement1cpa                   | Numeric   |   |
| brandstoreengagement1cvr                   | Numeric   |   |
| brandstoreengagement1clicks                | Integer   |   |
| brandstoreengagement1views                 | Numeric   |   |
| brandstoreengagement1                      | Numeric   |   |
| brandstoreengagement2cpa                   | Numeric   |   |
| brandstoreengagement2cvr                   | Numeric   |   |
| brandstoreengagement2clicks                | Integer   |   |
| brandstoreengagement2views                 | Numeric   |   |
| brandstoreengagement2                      | Numeric   |   |
| brandstoreengagement3cpa                   | Numeric   |   |
| brandstoreengagement3cvr                   | Numeric   |   |
| brandstoreengagement3clicks                | Integer   |   |
| brandstoreengagement3views                 | Numeric   |   |
| brandstoreengagement3                      | Numeric   |   |
| brandstoreengagement4cpa                   | Numeric   |   |
| brandstoreengagement4cvr                   | Numeric   |   |
| brandstoreengagement4clicks                | Integer   |   |
| brandstoreengagement4views                 | Numeric   |   |
| brandstoreengagement4                      | Numeric   |   |
| brandstoreengagement5cpa                   | Numeric   |   |
| brandstoreengagement5cvr                   | Numeric   |   |
| brandstoreengagement5clicks                | Integer   |   |
| brandstoreengagement5views                 | Numeric   |   |
| brandstoreengagement5                      | Numeric   |   |
| brandstoreengagement6cpa                   | Numeric   |   |
| brandstoreengagement6cvr                   | Numeric   |   |
| brandstoreengagement6clicks                | Integer   |   |
| brandstoreengagement6views                 | Numeric   |   |
| brandstoreengagement6                      | Numeric   |   |
| brandstoreengagement7cpa                   | Numeric   |   |
| brandstoreengagement7cvr                   | Numeric   |   |
| brandstoreengagement7clicks                | Integer   |   |
| brandstoreengagement7views                 | Numeric   |   |
| brandstoreengagement7                      | Numeric   |   |
| clickonredirect14d                         | Integer   |   |
| clickonredirectcpa14d                      | Integer   |   |
| clickonredirectcvr14d                      | Integer   |   |
| clickonredirectclicks14d                   | Integer   |   |
| clickonredirectviews14d                    | Integer   |   |
| clickthroughs                              | Integer   |   |
| decline14d                                 | Numeric   |   |
| declinecpa14d                              | Numeric   |   |
| declinecvr14d                              | Numeric   |   |
| declineclicks14d                           | Integer   |   |
| declineviews14d                            | Numeric   |   |
| downloadedvideoplayrate14d                 | Numeric   |   |
| downloadedvideoplays14d                    | Numeric   |   |
| downloadedvideoplaysclicks14d              | Integer   |   |
| downloadedvideoplaysviews14d               | Numeric   |   |
| dpv14d                                     | Numeric   |   |
| dpvclicks14d                               | Integer   |   |
| dpvviews14d                                | Integer   |   |
| dpvr14d                                    | Numeric   |   |
| dropdownselection14d                       | Numeric   |   |
| dropdownselectioncpa14d                    | Numeric   |   |
| dropdownselectioncvr14d                    | Numeric   |   |
| dropdownselectionclicks14d                 | Integer   |   |
| dropdownselectionviews14d                  | Integer   |   |
| ecpatc14d                                  | Numeric   |   |
| ecpatl14d                                  | Numeric   |   |
| ecpc                                       | Numeric   |   |
| ecpdpv14d                                  | Numeric   |   |
| ecpdvp14d                                  | Numeric   |   |
| ecpm                                       | Numeric   |   |
| ecpp14d                                    | Numeric   |   |
| ecpprpv14d                                 | Numeric   |   |
| ecppt14d                                   | Numeric   |   |
| ecpvs14d                                   | Numeric   |   |
| ecpnewsubscribeandsave14d                  | Numeric   |   |
| erpm14d                                    | Numeric   |   |
| ecpr14d                                    | Numeric   |   |
| ecpvc                                      | Numeric   |   |
| ecpvd14d                                   | Numeric   |   |
| emailinteraction14d                        | Numeric   |   |
| emailinteractioncpa14d                     | Numeric   |   |
| emailinteractioncvr14d                     | Numeric   |   |
| emailinteractionclicks14d                  | Integer   |   |
| emailinteractionviews14d                   | Integer   |   |
| emailload14d                               | Numeric   |   |
| emailloadcpa14d                            | Numeric   |   |
| emailloadcvr14d                            | Numeric   |   |
| emailloadclicks14d                         | Integer   |   |
| emailloadviews14d                          | Integer   |   |
| entityid                                   | String    |   |
| gameinteraction14d                         | Numeric   |   |
| gameinteractioncpa14d                      | Numeric   |   |
| gameinteractioncvr14d                      | Numeric   |   |
| gameinteractionclicks14d                   | Integer   |   |
| gameinteractionviews14d                    | Numeric   |   |
| gameload14d                                | Numeric   |   |
| gameloadcpa14d                             | Numeric   |   |
| gameloadcvr14d                             | Numeric   |   |
| gameloadclicks14d                          | Integer   |   |
| gameloadviews14d                           | Integer   |   |
| homepagevisit14d                           | Numeric   |   |
| homepagevisitcpa14d                        | Numeric   |   |
| homepagevisitcvr14d                        | Numeric   |   |
| homepagevisitclicks14d                     | Integer   |   |
| homepagevisitviews14d                      | Integer   |   |
| impressions                                | Numeric   |   |
| intervalend                                | Numeric   |   |
| intervalstart                              | Numeric   |   |
| marketinglandingpage14d                    | Numeric   |   |
| marketinglandingpagecpa14d                 | Numeric   |   |
| marketinglandingpagecvr14d                 | Numeric   |   |
| marketinglandingpageclicks14d              | Integer   |   |
| marketinglandingpageviews14d               | Numeric   |   |
| mashupaddtocart14d                         | Numeric   |   |
| mashupaddtocartcpa14d                      | Numeric   |   |
| mashupaddtocartclickcvr14d                 | Numeric   |   |
| mashupaddtocartclicks14d                   | Integer   |   |
| mashupaddtocartviews14d                    | Integer   |   |
| mashupaddtowishlist14d                     | Numeric   |   |
| mashupaddtowishlistcpa14d                  | Numeric   |   |
| mashupaddtowishlistcvr14d                  | Numeric   |   |
| mashupaddtowishlistclicks14d               | Integer   |   |
| mashupaddtowishlistviews14d                | Integer   |   |
| mashupbackupimagecpa                       | Numeric   |   |
| mashupbackupimagecvr                       | Numeric   |   |
| mashupbackupimageclicks                    | Integer   |   |
| mashupbackupimageviews                     | Integer   |   |
| mashupbackupimage                          | Numeric   |   |
| mashupclicktopagecpa                       | Numeric   |   |
| mashupclicktopagecvr                       | Numeric   |   |
| mashupclicktopageclicks                    | Integer   |   |
| mashupclicktopageviews                     | Integer   |   |
| mashupclicktopage                          | Numeric   |   |
| mashupclipcouponclick14d                   | Integer   |   |
| mashupclipcouponclickcpa14d                | Integer   |   |
| mashupclipcouponclickcvr14d                | Integer   |   |
| mashupclipcouponclickclicks14d             | Integer   |   |
| mashupclipcouponclickviews14d              | Integer   |   |
| mashupshopnowclick14d                      | Integer   |   |
| mashupshopnowclickcpa14d                   | Integer   |   |
| mashupshopnowclickcvr14d                   | Integer   |   |
| mashupshopnowclickclicks14d                | Integer   |   |
| mashupshopnowclickviews14d                 | Integer   |   |
| mashupsubscribeandsave14d                  | Numeric   |   |
| mashupsubscribeandsavecpa14d               | Numeric   |   |
| mashupsubscribeandsavecvr14d               | Numeric   |   |
| mashupsubscribeandsaveclick14d             | Integer   |   |
| mashupsubscribeandsaveclickviews14d        | Integer   |   |
| measurableimpressions                      | Numeric   |   |
| measurablerate                             | Numeric   |   |
| messagesent14d                             | Numeric   |   |
| messagesentcpa14d                          | Numeric   |   |
| messagesentcvr14d                          | Numeric   |   |
| messagesentclicks14d                       | Integer   |   |
| messagesentviews14d                        | Integer   |   |
| mobileappfirststartcvr14d                  | Numeric   |   |
| mobileappfirststartclicks14d               | Integer   |   |
| mobileappfirststartviews14d                | Integer   |   |
| mobileappfirststarts14d                    | Numeric   |   |
| mobileappfirststartscpa14d                 | Numeric   |   |
| newsubscribeandsave14d                     | Numeric   |   |
| newsubscribeandsaveclicks14d               | Integer   |   |
| newsubscribeandsaverate14d                 | Numeric   |   |
| newsubscribeandsaveviews14d                | Integer   |   |
| newtobrandecpp14d                          | Numeric   |   |
| newtobranderpm14d                          | Numeric   |   |
| newtobrandproductsales14d                  | Numeric   |   |
| newtobrandpurchaserate14d                  | Numeric   |   |
| newtobrandpurchases14d                     | Numeric   |   |
| newtobrandpurchasesclicks14d               | Integer   |   |
| newtobrandpurchasesviews14d                | Numeric   |   |
| newtobrandroas14d                          | Numeric   |   |
| newtobrandunitssold14d                     | Numeric   |   |
| prpv14d                                    | Numeric   |   |
| prpvclicks14d                              | Integer   |   |
| prpvviews14d                               | Integer   |   |
| prpvr14d                                   | Numeric   |   |
| percentofpurchasesnewtobrand14d            | Numeric   |   |
| playtrailerrate14d                         | Numeric   |   |
| playtrailers14d                            | Numeric   |   |
| playtrailersviews14d                       | Numeric   |   |
| playertrailersclicks14d                    | Integer   |   |
| productpurchasedcpa                        | Numeric   |   |
| productpurchasedcvr                        | Numeric   |   |
| productpurchasedclicks                     | Integer   |   |
| productpurchasedviews                      | Integer   |   |
| productpurchased                           | Numeric   |   |
| purchasebutton14d                          | Numeric   |   |
| purchasebuttoncpa14d                       | Numeric   |   |
| purchasebuttoncvr14d                       | Numeric   |   |
| purchasebuttonclicks14d                    | Integer   |   |
| purchasebuttonviews14d                     | Numeric   |   |
| purchaserate14d                            | Numeric   |   |
| purchases14d                               | Numeric   |   |
| purchasesclicks14d                         | Integer   |   |
| purchasesviews14d                          | Integer   |   |
| reporttype                                 | String    |   |
| referral14d                                | Numeric   |   |
| referralcpa14d                             | Numeric   |   |
| referralcvr14d                             | Numeric   |   |
| referralclicks14d                          | Integer   |   |
| referralviews14d                           | Numeric   |   |
| registrationconfirmpage14d                 | Numeric   |   |
| registrationconfirmpagecpa14d              | Numeric   |   |
| registrationconfirmpagecvr14d              | Numeric   |   |
| registrationconfirmpageclicks14d           | Integer   |   |
| registrationconfirmpageviews14d            | Numeric   |   |
| registrationform14d                        | Numeric   |   |
| registrationformcpa14d                     | Numeric   |   |
| registrationformcvr14d                     | Numeric   |   |
| registrationformclicks14d                  | Integer   |   |
| registrationformviews14d                   | Integer   |   |
| rentalrate14d                              | Numeric   |   |
| rentals14d                                 | Numeric   |   |
| rentalsclicks14d                           | Integer   |   |
| rentalsviews14d                            | Integer   |   |
| sales14d                                   | Numeric   |   |
| signupbutton14d                            | Numeric   |   |
| signupbuttoncpa14d                         | Numeric   |   |
| signupbuttoncvr14d                         | Numeric   |   |
| signupbuttonclicks14d                      | Numeric   |   |
| signupbuttonviews14d                       | Numeric   |   |
| signuppage14d                              | Numeric   |   |
| signuppagecpa14d                           | Numeric   |   |
| signuppagecvr14d                           | Numeric   |   |
| signuppageclicks14d                        | Numeric   |   |
| signuppageviews14d                         | Numeric   |   |
| storelocatorpage14d                        | Numeric   |   |
| storelocatorpagecpa14d                     | Numeric   |   |
| storelocatorpagecvr14d                     | Numeric   |   |
| storelocatorpageclicks14d                  | Numeric   |   |
| storelocatorpageviews14d                   | Numeric   |   |
| submitbutton14d                            | Numeric   |   |
| submitbuttoncpa14d                         | Numeric   |   |
| submitbuttoncvr14d                         | Numeric   |   |
| submitbuttonclicks14d                      | Numeric   |   |
| submitbuttonviews14d                       | Numeric   |   |
| subscriptionbutton14d                      | Numeric   |   |
| subscriptionbuttoncpa14d                   | Numeric   |   |
| subscriptionbuttoncvr14d                   | Numeric   |   |
| subscriptionbuttonclicks14d                | Numeric   |   |
| subscriptionbuttonviews14d                 | Numeric   |   |
| subscriptionpage14d                        | Numeric   |   |
| subscriptionpagecpa14d                     | Numeric   |   |
| subscriptionpagecvr14d                     | Numeric   |   |
| subscriptionpageclicks14d                  | Numeric   |   |
| subscriptionpageviews14d                   | Numeric   |   |
| successpage14d                             | Numeric   |   |
| successpagecpa14d                          | Numeric   |   |
| successpagecvr14d                          | Numeric   |   |
| successpageclicks14d                       | Numeric   |   |
| successpageviews14d                        | Numeric   |   |
| supplycost                                 | Numeric   |   |
| surveyfinish14d                            | Numeric   |   |
| surveyfinishcpa14d                         | Numeric   |   |
| surveyfinishcvr14d                         | Numeric   |   |
| surveyfinishclicks14d                      | Numeric   |   |
| surveyfinishviews14d                       | Numeric   |   |
| surveystart14d                             | Numeric   |   |
| surveystartcpa14d                          | Numeric   |   |
| surveystartcvr14d                          | Numeric   |   |
| surveystartclicks14d                       | Numeric   |   |
| surveystartviews14d                        | Numeric   |   |
| thankyoupage14d                            | Numeric   |   |
| thankyoupagecpa14d                         | Numeric   |   |
| thankyoupagecvr14d                         | Numeric   |   |
| thankyoupageclicks14d                      | Numeric   |   |
| thankyoupageviews14d                       | Numeric   |   |
| totaladdtocart14d                          | Numeric   |   |
| totaladdtocartcpa14d                       | Numeric   |   |
| totaladdtocartcvr14d                       | Numeric   |   |
| totaladdtocartclicks14d                    | Numeric   |   |
| totaladdtocartviews14d                     | Numeric   |   |
| totaladdtolist14d                          | Numeric   |   |
| totaladdtolistcpa14d                       | Numeric   |   |
| totaladdtolistcvr14d                       | Numeric   |   |
| totaladdtolistclicks14d                    | Numeric   |   |
| totaladdtolistviews14d                     | Numeric   |   |
| totalcost                                  | Numeric   |   |
| totaldetaipageviewcpa14d                   | Numeric   |   |
| totaldetailpageclicks14d                   | Numeric   |   |
| totaldetailpageviewviews14d                | Numeric   |   |
| totaldetailpageviews14d                    | Numeric   |   |
| totaldetailpageviewscvr14d                 | Numeric   |   |
| totalecpp14d                               | Numeric   |   |
| totalecpprpv14d                            | Numeric   |   |
| totalerpm14d                               | Numeric   |   |
| totalfee                                   | Numeric   |   |
| totalnewtobrandecpp14d                     | Numeric   |   |
| totalnewtobranderpm14d                     | Numeric   |   |
| totalnewtobrandproductsales14d             | Numeric   |   |
| totalnewtobrandpurchaserate14d             | Numeric   |   |
| totalnewtobrandpurchases14d                | Numeric   |   |
| totalnewtobrandpurchasesclicks14d          | Numeric   |   |
| totalnewtobrandpurchasesviews14d           | Numeric   |   |
| totalnewtobrandroass14d                    | Numeric   |   |
| totalnewtobrandunitssold14d                | Numeric   |   |
| totalprpv14d                               | Numeric   |   |
| totalprpvclicks14d                         | Numeric   |   |
| totalprpvviews14d                          | Numeric   |   |
| totalprpvr14d                              | Numeric   |   |
| totalpercentofpurchasesnewtobrand14d       | Numeric   |   |
| totalpixel14d                              | Numeric   |   |
| totalpixelcpa14d                           | Numeric   |   |
| totalpixelcvr14d                           | Numeric   |   |
| totalpixelclicks14d                        | Numeric   |   |
| totalpixelviews14d                         | Numeric   |   |
| totalpurchaserate14d                       | Numeric   |   |
| totalpurchases14d                          | Numeric   |   |
| totalpurchasesclicks14d                    | Numeric   |   |
| totalpurchasesviews14d                     | Numeric   |   |
| totalroas14d                               | Numeric   |   |
| totalsales14d                              | Numeric   |   |
| totalsubscribeandsavesubscriptioncpa14d    | Numeric   |   |
| totalsubscribeandsavesubscriptioncvr14d    | Numeric   |   |
| totalsubscribeandsavesubscriptionclicks14d | Numeric   |   |
| totalsubscribeandsavesubscriptionviews14d  | Numeric   |   |
| totalsubscribeandsavesubscriptions14d      | Numeric   |   |
| totalunitssold14d                          | Numeric   |   |
| unitssold14d                               | Numeric   |   |
| videocomplete                              | Numeric   |   |
| videocompletedcpa                          | Numeric   |   |
| videocompletedcvr                          | Numeric   |   |
| videocompletedviews                        | Numeric   |   |
| videocompleted                             | Numeric   |   |
| videocompletionrate                        | Numeric   |   |
| videodownloadrate14d                       | Numeric   |   |
| videodownloads14d                          | Numeric   |   |
| videodownloadsclicks14d                    | Numeric   |   |
| videodownloadsviews14d                     | Numeric   |   |
| videoendclicks                             | Numeric   |   |
| videofirstquartile                         | Numeric   |   |
| videomidpoint                              | Numeric   |   |
| videomute                                  | Numeric   |   |
| videopause                                 | Numeric   |   |
| videoresume                                | Numeric   |   |
| videostart                                 | Numeric   |   |
| videostartedcpa                            | Numeric   |   |
| videostartedcvr                            | Numeric   |   |
| videostartedclicks                         | Numeric   |   |
| videostartedviews                          | Numeric   |   |
| videostarted                               | Numeric   |   |
| videostreams14d                            | Numeric   |   |
| videostreamsclicks14d                      | Numeric   |   |
| videostreamsrate14d                        | Numeric   |   |
| registrationconfirmpageeostreamsviews14d   | Numeric   |   |
| videothirdquartile                         | Numeric   |   |
| videounmute                                | Numeric   |   |
| viewabilityrate                            | Numeric   |   |
| viewableimpressions                        | Numeric   |   |
| widgetinteraction14d                       | Numeric   |   |
| widgetinteractioncpa14d                    | Numeric   |   |
| widgetinteractioncvr14d                    | Numeric   |   |
| widgetinteractionclicks14d                 | Numeric   |   |
| widgetinteractionviews14d                  | Numeric   |   |
| widgetload14d                              | Numeric   |   |
| widgetloadcpa14d                           | Numeric   |   |
| widgetloadcvr14d                           | Numeric   |   |
| widgetloadclicks14d                        | Numeric   |   |
| widgetloadviews14d                         | Numeric   |   |
| eventid                                    | Integer   |   |
| off\_amazon\_clicks                        | Numeric   |   |
| off\_amazon\_conversions                   | Numeric   |   |
| off\_amazon\_cpa                           | Numeric   |   |
| off\_amazon\_cvr                           | Numeric   |   |
| off\_amazon\_ecpp                          | Numeric   |   |
| off\_amazon\_erpm                          | Numeric   |   |
| off\_amazon\_product\_sales                | Numeric   |   |
| off\_amazon\_purchase\_rate                | Numeric   |   |
| off\_amazon\_purchases                     | Numeric   |   |
| off\_amazon\_purchases\_clicks             | Numeric   |   |
| off\_amazon\_purchases\_views              | Numeric   |   |
| off\_amazon\_roas                          | Numeric   |   |
| off\_amazon\_units\_sold                   | Numeric   |   |
| off\_amazon\_views                         | Numeric   |   |

### Line Item&#x20;

Table name: *dsp\_lineitem*

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name              | Data type | Description |
| ------------------------ | --------- | ----------- |
| advertiserid             | Integer   |             |
| account\_id              | Integer   |             |
| account\_name            | String    |             |
| orderid                  | String    |             |
| lineitemtid              | String    |             |
| name                     | String    |             |
| lineitemtype             | String    |             |
| startdatetime            | Date Time |             |
| enddatetime              | Date Time |             |
| totalbudgetamount        | Numeric   |             |
| deliverystatus           | String    |             |
| deliveryactivationstatus | String    |             |
| maxsupplybid             | Numeric   |             |
| basesupplybid            | Numeric   |             |

### Line Item Report

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name                                | Data type | Description |
| ------------------------------------------ | --------- | ----------- |
| advertiserid                               | Integer   |             |
| account\_id                                | Integer   |             |
| account\_name                              | String    |             |
| reportDate                                 | Date      |             |
| orderid                                    | String    |             |
| lineitemid                                 | Integer   |             |
| 3pfees                                     | Numeric   |             |
| 3pfeeautomotiveabsorbed                    | Numeric   |             |
| 3pfeeautomotive                            | Numeric   |             |
| 3pfeecpm1absorbed                          | Numeric   |             |
| 3pfeecpm1                                  | Numeric   |             |
| 3pfeecpm2absorbed                          | Numeric   |             |
| 3pfeecpm2                                  | Numeric   |             |
| 3pfeecpm3absorbed                          | Numeric   |             |
| 3pfeecpm3                                  | Numeric   |             |
| 3pfeecomscoreabsorbed                      | Numeric   |             |
| 3pfeecomscore                              | Numeric   |             |
| 3pfeedoubleverifyabsorbed                  | Numeric   |             |
| 3pfeedoubleverify                          | Numeric   |             |
| 3pfeedoubleclickcampaignmanagerabsorbed    | Numeric   |             |
| 3pfeedoubleclickcampaignmanager            | Numeric   |             |
| 3pfeeintegraladscienceabsorbed             | Numeric   |             |
| 3pfeeintegraladscience                     | Numeric   |             |
| ctr                                        | Numeric   |             |
| roas14d                                    | Numeric   |             |
| accept14d                                  | Numeric   |             |
| acceptcpa14d                               | Numeric   |             |
| acceptcvr14d                               | Integer   |             |
| acceptclicks14d                            | Numeric   |             |
| acceptviews14d                             | Numeric   |             |
| addtowatchlist14d                          | Numeric   |             |
| addtowatchlistcpa14d                       | Numeric   |             |
| addtowatchlistcvr14d                       | Numeric   |             |
| addtowatchlistclicks14d                    | Integer   |             |
| addtowatchlistviews14d                     | Numeric   |             |
| addedtoshoppingcart14d                     | Numeric   |             |
| addedtoshoppingcartcpa14d                  | Numeric   |             |
| addedtoshoppingcartcvr14d                  | Numeric   |             |
| addedtoshoppingcartclicks14d               | Integer   |             |
| addedtoshoppingcartviews14d                | Numeric   |             |
| advertisercountry                          | String    |             |
| advertisertimezone                         | String    |             |
| agencyfee                                  | Numeric   |             |
| amazonaudiencefee                          | Numeric   |             |
| amazonplatformfee                          | Numeric   |             |
| application14d                             | Numeric   |             |
| applicationcpa14d                          | Numeric   |             |
| applicationcvr14d                          | Numeric   |             |
| applicationclicks14d                       | Integer   |             |
| applicationviews14d                        | Numeric   |             |
| atc14d                                     | Numeric   |             |
| atcclicks14d                               | Integer   |             |
| atcviews14d                                | Numeric   |             |
| atcr14d                                    | Numeric   |             |
| atl14d                                     | Numeric   |             |
| atlclicks14d                               | Integer   |             |
| atlviews14d                                | Numeric   |             |
| atlr14d                                    | Numeric   |             |
| bannerinteraction14d                       | Numeric   |             |
| bannerinteractioncpa14d                    | Numeric   |             |
| bannerinteractioncvr14d                    | Numeric   |             |
| bannerinteractionclicks14d                 | Integer   |             |
| bannerinteractionviews14d                  | Numeric   |             |
| brandstoreengagement1cpa                   | Numeric   |             |
| brandstoreengagement1cvr                   | Numeric   |             |
| brandstoreengagement1clicks                | Integer   |             |
| brandstoreengagement1views                 | Numeric   |             |
| brandstoreengagement1                      | Numeric   |             |
| brandstoreengagement2cpa                   | Numeric   |             |
| brandstoreengagement2cvr                   | Numeric   |             |
| brandstoreengagement2clicks                | Integer   |             |
| brandstoreengagement2views                 | Numeric   |             |
| brandstoreengagement2                      | Numeric   |             |
| brandstoreengagement3cpa                   | Numeric   |             |
| brandstoreengagement3cvr                   | Numeric   |             |
| brandstoreengagement3clicks                | Integer   |             |
| brandstoreengagement3views                 | Numeric   |             |
| brandstoreengagement3                      | Numeric   |             |
| brandstoreengagement4cpa                   | Numeric   |             |
| brandstoreengagement4cvr                   | Numeric   |             |
| brandstoreengagement4clicks                | Integer   |             |
| brandstoreengagement4views                 | Numeric   |             |
| brandstoreengagement4                      | Numeric   |             |
| brandstoreengagement5cpa                   | Numeric   |             |
| brandstoreengagement5cvr                   | Numeric   |             |
| brandstoreengagement5clicks                | Integer   |             |
| brandstoreengagement5views                 | Numeric   |             |
| brandstoreengagement5                      | Numeric   |             |
| brandstoreengagement6cpa                   | Numeric   |             |
| brandstoreengagement6cvr                   | Numeric   |             |
| brandstoreengagement6clicks                | Integer   |             |
| brandstoreengagement6views                 | Numeric   |             |
| brandstoreengagement6                      | Numeric   |             |
| brandstoreengagement7cpa                   | Numeric   |             |
| brandstoreengagement7cvr                   | Numeric   |             |
| brandstoreengagement7clicks                | Integer   |             |
| brandstoreengagement7views                 | Numeric   |             |
| brandstoreengagement7                      | Numeric   |             |
| clickonredirect14d                         | Integer   |             |
| clickonredirectcpa14d                      | Integer   |             |
| clickonredirectcvr14d                      | Integer   |             |
| clickonredirectclicks14d                   | Integer   |             |
| clickonredirectviews14d                    | Integer   |             |
| clickthroughs                              | Integer   |             |
| decline14d                                 | Numeric   |             |
| declinecpa14d                              | Numeric   |             |
| declinecvr14d                              | Numeric   |             |
| declineclicks14d                           | Integer   |             |
| declineviews14d                            | Numeric   |             |
| downloadedvideoplayrate14d                 | Numeric   |             |
| downloadedvideoplays14d                    | Numeric   |             |
| downloadedvideoplaysclicks14d              | Integer   |             |
| downloadedvideoplaysviews14d               | Numeric   |             |
| dpv14d                                     | Numeric   |             |
| dpvclicks14d                               | Integer   |             |
| dpvviews14d                                | Integer   |             |
| dpvr14d                                    | Numeric   |             |
| dropdownselection14d                       | Numeric   |             |
| dropdownselectioncpa14d                    | Numeric   |             |
| dropdownselectioncvr14d                    | Numeric   |             |
| dropdownselectionclicks14d                 | Integer   |             |
| dropdownselectionviews14d                  | Integer   |             |
| ecpatc14d                                  | Numeric   |             |
| ecpatl14d                                  | Numeric   |             |
| ecpc                                       | Numeric   |             |
| ecpdpv14d                                  | Numeric   |             |
| ecpdvp14d                                  | Numeric   |             |
| ecpm                                       | Numeric   |             |
| ecpp14d                                    | Numeric   |             |
| ecpprpv14d                                 | Numeric   |             |
| ecppt14d                                   | Numeric   |             |
| ecpvs14d                                   | Numeric   |             |
| ecpnewsubscribeandsave14d                  | Numeric   |             |
| erpm14d                                    | Numeric   |             |
| ecpr14d                                    | Numeric   |             |
| ecpvc                                      | Numeric   |             |
| ecpvd14d                                   | Numeric   |             |
| emailinteraction14d                        | Numeric   |             |
| emailinteractioncpa14d                     | Numeric   |             |
| emailinteractioncvr14d                     | Numeric   |             |
| emailinteractionclicks14d                  | Integer   |             |
| emailinteractionviews14d                   | Integer   |             |
| emailload14d                               | Numeric   |             |
| emailloadcpa14d                            | Numeric   |             |
| emailloadcvr14d                            | Numeric   |             |
| emailloadclicks14d                         | Integer   |             |
| emailloadviews14d                          | Integer   |             |
| entityid                                   | String    |             |
| gameinteraction14d                         | Numeric   |             |
| gameinteractioncpa14d                      | Numeric   |             |
| gameinteractioncvr14d                      | Numeric   |             |
| gameinteractionclicks14d                   | Integer   |             |
| gameinteractionviews14d                    | Numeric   |             |
| gameload14d                                | Numeric   |             |
| gameloadcpa14d                             | Numeric   |             |
| gameloadcvr14d                             | Numeric   |             |
| gameloadclicks14d                          | Integer   |             |
| gameloadviews14d                           | Integer   |             |
| homepagevisit14d                           | Numeric   |             |
| homepagevisitcpa14d                        | Numeric   |             |
| homepagevisitcvr14d                        | Numeric   |             |
| homepagevisitclicks14d                     | Integer   |             |
| homepagevisitviews14d                      | Integer   |             |
| impressions                                | Numeric   |             |
| intervalend                                | Numeric   |             |
| intervalstart                              | Numeric   |             |
| marketinglandingpage14d                    | Numeric   |             |
| marketinglandingpagecpa14d                 | Numeric   |             |
| marketinglandingpagecvr14d                 | Numeric   |             |
| marketinglandingpageclicks14d              | Integer   |             |
| marketinglandingpageviews14d               | Numeric   |             |
| mashupaddtocart14d                         | Numeric   |             |
| mashupaddtocartcpa14d                      | Numeric   |             |
| mashupaddtocartclickcvr14d                 | Numeric   |             |
| mashupaddtocartclicks14d                   | Integer   |             |
| mashupaddtocartviews14d                    | Integer   |             |
| mashupaddtowishlist14d                     | Numeric   |             |
| mashupaddtowishlistcpa14d                  | Numeric   |             |
| mashupaddtowishlistcvr14d                  | Numeric   |             |
| mashupaddtowishlistclicks14d               | Integer   |             |
| mashupaddtowishlistviews14d                | Integer   |             |
| mashupbackupimagecpa                       | Numeric   |             |
| mashupbackupimagecvr                       | Numeric   |             |
| mashupbackupimageclicks                    | Integer   |             |
| mashupbackupimageviews                     | Integer   |             |
| mashupbackupimage                          | Numeric   |             |
| mashupclicktopagecpa                       | Numeric   |             |
| mashupclicktopagecvr                       | Numeric   |             |
| mashupclicktopageclicks                    | Integer   |             |
| mashupclicktopageviews                     | Integer   |             |
| mashupclicktopage                          | Numeric   |             |
| mashupclipcouponclick14d                   | Integer   |             |
| mashupclipcouponclickcpa14d                | Integer   |             |
| mashupclipcouponclickcvr14d                | Integer   |             |
| mashupclipcouponclickclicks14d             | Integer   |             |
| mashupclipcouponclickviews14d              | Integer   |             |
| mashupshopnowclick14d                      | Integer   |             |
| mashupshopnowclickcpa14d                   | Integer   |             |
| mashupshopnowclickcvr14d                   | Integer   |             |
| mashupshopnowclickclicks14d                | Integer   |             |
| mashupshopnowclickviews14d                 | Integer   |             |
| mashupsubscribeandsave14d                  | Numeric   |             |
| mashupsubscribeandsavecpa14d               | Numeric   |             |
| mashupsubscribeandsavecvr14d               | Numeric   |             |
| mashupsubscribeandsaveclick14d             | Integer   |             |
| mashupsubscribeandsaveclickviews14d        | Integer   |             |
| measurableimpressions                      | Numeric   |             |
| measurablerate                             | Numeric   |             |
| messagesent14d                             | Numeric   |             |
| messagesentcpa14d                          | Numeric   |             |
| messagesentcvr14d                          | Numeric   |             |
| messagesentclicks14d                       | Integer   |             |
| messagesentviews14d                        | Integer   |             |
| mobileappfirststartcvr14d                  | Numeric   |             |
| mobileappfirststartclicks14d               | Integer   |             |
| mobileappfirststartviews14d                | Integer   |             |
| mobileappfirststarts14d                    | Numeric   |             |
| mobileappfirststartscpa14d                 | Numeric   |             |
| newsubscribeandsave14d                     | Numeric   |             |
| newsubscribeandsaveclicks14d               | Integer   |             |
| newsubscribeandsaverate14d                 | Numeric   |             |
| newsubscribeandsaveviews14d                | Integer   |             |
| newtobrandecpp14d                          | Numeric   |             |
| newtobranderpm14d                          | Numeric   |             |
| newtobrandproductsales14d                  | Numeric   |             |
| newtobrandpurchaserate14d                  | Numeric   |             |
| newtobrandpurchases14d                     | Numeric   |             |
| newtobrandpurchasesclicks14d               | Integer   |             |
| newtobrandpurchasesviews14d                | Numeric   |             |
| newtobrandroas14d                          | Numeric   |             |
| newtobrandunitssold14d                     | Numeric   |             |
| prpv14d                                    | Numeric   |             |
| prpvclicks14d                              | Integer   |             |
| prpvviews14d                               | Integer   |             |
| prpvr14d                                   | Numeric   |             |
| percentofpurchasesnewtobrand14d            | Numeric   |             |
| playtrailerrate14d                         | Numeric   |             |
| playtrailers14d                            | Numeric   |             |
| playtrailersviews14d                       | Numeric   |             |
| playertrailersclicks14d                    | Integer   |             |
| productpurchasedcpa                        | Numeric   |             |
| productpurchasedcvr                        | Numeric   |             |
| productpurchasedclicks                     | Integer   |             |
| productpurchasedviews                      | Integer   |             |
| productpurchased                           | Numeric   |             |
| purchasebutton14d                          | Numeric   |             |
| purchasebuttoncpa14d                       | Numeric   |             |
| purchasebuttoncvr14d                       | Numeric   |             |
| purchasebuttonclicks14d                    | Integer   |             |
| purchasebuttonviews14d                     | Numeric   |             |
| purchaserate14d                            | Numeric   |             |
| purchases14d                               | Numeric   |             |
| purchasesclicks14d                         | Integer   |             |
| purchasesviews14d                          | Integer   |             |
| reporttype                                 | String    |             |
| referral14d                                | Numeric   |             |
| referralcpa14d                             | Numeric   |             |
| referralcvr14d                             | Numeric   |             |
| referralclicks14d                          | Integer   |             |
| referralviews14d                           | Numeric   |             |
| registrationconfirmpage14d                 | Numeric   |             |
| registrationconfirmpagecpa14d              | Numeric   |             |
| registrationconfirmpagecvr14d              | Numeric   |             |
| registrationconfirmpageclicks14d           | Integer   |             |
| registrationconfirmpageviews14d            | Numeric   |             |
| registrationform14d                        | Numeric   |             |
| registrationformcpa14d                     | Numeric   |             |
| registrationformcvr14d                     | Numeric   |             |
| registrationformclicks14d                  | Integer   |             |
| registrationformviews14d                   | Integer   |             |
| rentalrate14d                              | Numeric   |             |
| rentals14d                                 | Numeric   |             |
| rentalsclicks14d                           | Integer   |             |
| rentalsviews14d                            | Integer   |             |
| sales14d                                   | Numeric   |             |
| signupbutton14d                            | Numeric   |             |
| signupbuttoncpa14d                         | Numeric   |             |
| signupbuttoncvr14d                         | Numeric   |             |
| signupbuttonclicks14d                      | Numeric   |             |
| signupbuttonviews14d                       | Numeric   |             |
| signuppage14d                              | Numeric   |             |
| signuppagecpa14d                           | Numeric   |             |
| signuppagecvr14d                           | Numeric   |             |
| signuppageclicks14d                        | Numeric   |             |
| signuppageviews14d                         | Numeric   |             |
| storelocatorpage14d                        | Numeric   |             |
| storelocatorpagecpa14d                     | Numeric   |             |
| storelocatorpagecvr14d                     | Numeric   |             |
| storelocatorpageclicks14d                  | Numeric   |             |
| storelocatorpageviews14d                   | Numeric   |             |
| submitbutton14d                            | Numeric   |             |
| submitbuttoncpa14d                         | Numeric   |             |
| submitbuttoncvr14d                         | Numeric   |             |
| submitbuttonclicks14d                      | Numeric   |             |
| submitbuttonviews14d                       | Numeric   |             |
| subscriptionbutton14d                      | Numeric   |             |
| subscriptionbuttoncpa14d                   | Numeric   |             |
| subscriptionbuttoncvr14d                   | Numeric   |             |
| subscriptionbuttonclicks14d                | Numeric   |             |
| subscriptionbuttonviews14d                 | Numeric   |             |
| subscriptionpage14d                        | Numeric   |             |
| subscriptionpagecpa14d                     | Numeric   |             |
| subscriptionpagecvr14d                     | Numeric   |             |
| subscriptionpageclicks14d                  | Numeric   |             |
| subscriptionpageviews14d                   | Numeric   |             |
| successpage14d                             | Numeric   |             |
| successpagecpa14d                          | Numeric   |             |
| successpagecvr14d                          | Numeric   |             |
| successpageclicks14d                       | Numeric   |             |
| successpageviews14d                        | Numeric   |             |
| supplycost                                 | Numeric   |             |
| surveyfinish14d                            | Numeric   |             |
| surveyfinishcpa14d                         | Numeric   |             |
| surveyfinishcvr14d                         | Numeric   |             |
| surveyfinishclicks14d                      | Numeric   |             |
| surveyfinishviews14d                       | Numeric   |             |
| surveystart14d                             | Numeric   |             |
| surveystartcpa14d                          | Numeric   |             |
| surveystartcvr14d                          | Numeric   |             |
| surveystartclicks14d                       | Numeric   |             |
| surveystartviews14d                        | Numeric   |             |
| thankyoupage14d                            | Numeric   |             |
| thankyoupagecpa14d                         | Numeric   |             |
| thankyoupagecvr14d                         | Numeric   |             |
| thankyoupageclicks14d                      | Numeric   |             |
| thankyoupageviews14d                       | Numeric   |             |
| totaladdtocart14d                          | Numeric   |             |
| totaladdtocartcpa14d                       | Numeric   |             |
| totaladdtocartcvr14d                       | Numeric   |             |
| totaladdtocartclicks14d                    | Numeric   |             |
| totaladdtocartviews14d                     | Numeric   |             |
| totaladdtolist14d                          | Numeric   |             |
| totaladdtolistcpa14d                       | Numeric   |             |
| totaladdtolistcvr14d                       | Numeric   |             |
| totaladdtolistclicks14d                    | Numeric   |             |
| totaladdtolistviews14d                     | Numeric   |             |
| totalcost                                  | Numeric   |             |
| totaldetaipageviewcpa14d                   | Numeric   |             |
| totaldetailpageclicks14d                   | Numeric   |             |
| totaldetailpageviewviews14d                | Numeric   |             |
| totaldetailpageviews14d                    | Numeric   |             |
| totaldetailpageviewscvr14d                 | Numeric   |             |
| totalecpp14d                               | Numeric   |             |
| totalecpprpv14d                            | Numeric   |             |
| totalerpm14d                               | Numeric   |             |
| totalfee                                   | Numeric   |             |
| totalnewtobrandecpp14d                     | Numeric   |             |
| totalnewtobranderpm14d                     | Numeric   |             |
| totalnewtobrandproductsales14d             | Numeric   |             |
| totalnewtobrandpurchaserate14d             | Numeric   |             |
| totalnewtobrandpurchases14d                | Numeric   |             |
| totalnewtobrandpurchasesclicks14d          | Numeric   |             |
| totalnewtobrandpurchasesviews14d           | Numeric   |             |
| totalnewtobrandroass14d                    | Numeric   |             |
| totalnewtobrandunitssold14d                | Numeric   |             |
| totalprpv14d                               | Numeric   |             |
| totalprpvclicks14d                         | Numeric   |             |
| totalprpvviews14d                          | Numeric   |             |
| totalprpvr14d                              | Numeric   |             |
| totalpercentofpurchasesnewtobrand14d       | Numeric   |             |
| totalpixel14d                              | Numeric   |             |
| totalpixelcpa14d                           | Numeric   |             |
| totalpixelcvr14d                           | Numeric   |             |
| totalpixelclicks14d                        | Numeric   |             |
| totalpixelviews14d                         | Numeric   |             |
| totalpurchaserate14d                       | Numeric   |             |
| totalpurchases14d                          | Numeric   |             |
| totalpurchasesclicks14d                    | Numeric   |             |
| totalpurchasesviews14d                     | Numeric   |             |
| totalroas14d                               | Numeric   |             |
| totalsales14d                              | Numeric   |             |
| totalsubscribeandsavesubscriptioncpa14d    | Numeric   |             |
| totalsubscribeandsavesubscriptioncvr14d    | Numeric   |             |
| totalsubscribeandsavesubscriptionclicks14d | Numeric   |             |
| totalsubscribeandsavesubscriptionviews14d  | Numeric   |             |
| totalsubscribeandsavesubscriptions14d      | Numeric   |             |
| totalunitssold14d                          | Numeric   |             |
| unitssold14d                               | Numeric   |             |
| videocomplete                              | Numeric   |             |
| videocompletedcpa                          | Numeric   |             |
| videocompletedcvr                          | Numeric   |             |
| videocompletedviews                        | Numeric   |             |
| videocompleted                             | Numeric   |             |
| videocompletionrate                        | Numeric   |             |
| videodownloadrate14d                       | Numeric   |             |
| videodownloads14d                          | Numeric   |             |
| videodownloadsclicks14d                    | Numeric   |             |
| videodownloadsviews14d                     | Numeric   |             |
| videoendclicks                             | Numeric   |             |
| videofirstquartile                         | Numeric   |             |
| videomidpoint                              | Numeric   |             |
| videomute                                  | Numeric   |             |
| videopause                                 | Numeric   |             |
| videoresume                                | Numeric   |             |
| videostart                                 | Numeric   |             |
| videostartedcpa                            | Numeric   |             |
| videostartedcvr                            | Numeric   |             |
| videostartedclicks                         | Numeric   |             |
| videostartedviews                          | Numeric   |             |
| videostarted                               | Numeric   |             |
| videostreams14d                            | Numeric   |             |
| videostreamsclicks14d                      | Numeric   |             |
| videostreamsrate14d                        | Numeric   |             |
| registrationconfirmpageeostreamsviews14d   | Numeric   |             |
| videothirdquartile                         | Numeric   |             |
| videounmute                                | Numeric   |             |
| viewabilityrate                            | Numeric   |             |
| viewableimpressions                        | Numeric   |             |
| widgetinteraction14d                       | Numeric   |             |
| widgetinteractioncpa14d                    | Numeric   |             |
| widgetinteractioncvr14d                    | Numeric   |             |
| widgetinteractionclicks14d                 | Numeric   |             |
| widgetinteractionviews14d                  | Numeric   |             |
| widgetload14d                              | Numeric   |             |
| widgetloadcpa14d                           | Numeric   |             |
| widgetloadcvr14d                           | Numeric   |             |
| widgetloadclicks14d                        | Numeric   |             |
| widgetloadviews14d                         | Numeric   |             |
| eventid                                    | Integer   |             |

### Creative

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name   | Data type | Description |
| ------------- | --------- | ----------- |
| advertiserid  | Integer   |             |
| account\_id   | Integer   |             |
| account\_name | String    |             |
| creativeid    | String    |             |
| name          | String    |             |
| type          | String    |             |
| size          | String    |             |

### Creative Report

| Column Name                                | Data type | Description |
| ------------------------------------------ | --------- | ----------- |
| advertiserid                               | Integer   |             |
| account\_id                                | Integer   |             |
| account\_name                              | String    |             |
| reportdate                                 | Date      |             |
| orderid                                    | String    |             |
| lineitemid                                 | String    |             |
| creativeid                                 | String    |             |
| 3pfees                                     | Numeric   |             |
| 3pfeeautomotiveabsorbed                    | Numeric   |             |
| 3pfeeautomotive                            | Numeric   |             |
| 3pfeecpm1absorbed                          | Numeric   |             |
| 3pfeecpm1                                  | Numeric   |             |
| 3pfeecpm2absorbed                          | Numeric   |             |
| 3pfeecpm2                                  | Numeric   |             |
| 3pfeecpm3absorbed                          | Numeric   |             |
| 3pfeecpm3                                  | Numeric   |             |
| 3pfeecomscoreabsorbed                      | Numeric   |             |
| 3pfeecomscore                              | Numeric   |             |
| 3pfeedoubleverifyabsorbed                  | Numeric   |             |
| 3pfeedoubleverify                          | Numeric   |             |
| 3pfeedoubleclickcampaignmanagerabsorbed    | Numeric   |             |
| 3pfeedoubleclickcampaignmanager            | Numeric   |             |
| 3pfeeintegraladscienceabsorbed             | Numeric   |             |
| 3pfeeintegraladscience                     | Numeric   |             |
| ctr                                        | Numeric   |             |
| roas14d                                    | Numeric   |             |
| accept14d                                  | Numeric   |             |
| acceptcpa14d                               | Numeric   |             |
| acceptcvr14d                               | Integer   |             |
| acceptclicks14d                            | Numeric   |             |
| acceptviews14d                             | Numeric   |             |
| addtowatchlist14d                          | Numeric   |             |
| addtowatchlistcpa14d                       | Numeric   |             |
| addtowatchlistcvr14d                       | Numeric   |             |
| addtowatchlistclicks14d                    | Integer   |             |
| addtowatchlistviews14d                     | Numeric   |             |
| addedtoshoppingcart14d                     | Numeric   |             |
| addedtoshoppingcartcpa14d                  | Numeric   |             |
| addedtoshoppingcartcvr14d                  | Numeric   |             |
| addedtoshoppingcartclicks14d               | Integer   |             |
| addedtoshoppingcartviews14d                | Numeric   |             |
| advertisercountry                          | String    |             |
| advertisertimezone                         | String    |             |
| agencyfee                                  | Numeric   |             |
| amazonaudiencefee                          | Numeric   |             |
| amazonplatformfee                          | Numeric   |             |
| application14d                             | Numeric   |             |
| applicationcpa14d                          | Numeric   |             |
| applicationcvr14d                          | Numeric   |             |
| applicationclicks14d                       | Integer   |             |
| applicationviews14d                        | Numeric   |             |
| atc14d                                     | Numeric   |             |
| atcclicks14d                               | Integer   |             |
| atcviews14d                                | Numeric   |             |
| atcr14d                                    | Numeric   |             |
| atl14d                                     | Numeric   |             |
| atlclicks14d                               | Integer   |             |
| atlviews14d                                | Numeric   |             |
| atlr14d                                    | Numeric   |             |
| bannerinteraction14d                       | Numeric   |             |
| bannerinteractioncpa14d                    | Numeric   |             |
| bannerinteractioncvr14d                    | Numeric   |             |
| bannerinteractionclicks14d                 | Integer   |             |
| bannerinteractionviews14d                  | Numeric   |             |
| brandstoreengagement1cpa                   | Numeric   |             |
| brandstoreengagement1cvr                   | Numeric   |             |
| brandstoreengagement1clicks                | Integer   |             |
| brandstoreengagement1views                 | Numeric   |             |
| brandstoreengagement1                      | Numeric   |             |
| brandstoreengagement2cpa                   | Numeric   |             |
| brandstoreengagement2cvr                   | Numeric   |             |
| brandstoreengagement2clicks                | Integer   |             |
| brandstoreengagement2views                 | Numeric   |             |
| brandstoreengagement2                      | Numeric   |             |
| brandstoreengagement3cpa                   | Numeric   |             |
| brandstoreengagement3cvr                   | Numeric   |             |
| brandstoreengagement3clicks                | Integer   |             |
| brandstoreengagement3views                 | Numeric   |             |
| brandstoreengagement3                      | Numeric   |             |
| brandstoreengagement4cpa                   | Numeric   |             |
| brandstoreengagement4cvr                   | Numeric   |             |
| brandstoreengagement4clicks                | Integer   |             |
| brandstoreengagement4views                 | Numeric   |             |
| brandstoreengagement4                      | Numeric   |             |
| brandstoreengagement5cpa                   | Numeric   |             |
| brandstoreengagement5cvr                   | Numeric   |             |
| brandstoreengagement5clicks                | Integer   |             |
| brandstoreengagement5views                 | Numeric   |             |
| brandstoreengagement5                      | Numeric   |             |
| brandstoreengagement6cpa                   | Numeric   |             |
| brandstoreengagement6cvr                   | Numeric   |             |
| brandstoreengagement6clicks                | Integer   |             |
| brandstoreengagement6views                 | Numeric   |             |
| brandstoreengagement6                      | Numeric   |             |
| brandstoreengagement7cpa                   | Numeric   |             |
| brandstoreengagement7cvr                   | Numeric   |             |
| brandstoreengagement7clicks                | Integer   |             |
| brandstoreengagement7views                 | Numeric   |             |
| brandstoreengagement7                      | Numeric   |             |
| clickonredirect14d                         | Integer   |             |
| clickonredirectcpa14d                      | Integer   |             |
| clickonredirectcvr14d                      | Integer   |             |
| clickonredirectclicks14d                   | Integer   |             |
| clickonredirectviews14d                    | Integer   |             |
| clickthroughs                              | Integer   |             |
| decline14d                                 | Numeric   |             |
| declinecpa14d                              | Numeric   |             |
| declinecvr14d                              | Numeric   |             |
| declineclicks14d                           | Integer   |             |
| declineviews14d                            | Numeric   |             |
| downloadedvideoplayrate14d                 | Numeric   |             |
| downloadedvideoplays14d                    | Numeric   |             |
| downloadedvideoplaysclicks14d              | Integer   |             |
| downloadedvideoplaysviews14d               | Numeric   |             |
| dpv14d                                     | Numeric   |             |
| dpvclicks14d                               | Integer   |             |
| dpvviews14d                                | Integer   |             |
| dpvr14d                                    | Numeric   |             |
| dropdownselection14d                       | Numeric   |             |
| dropdownselectioncpa14d                    | Numeric   |             |
| dropdownselectioncvr14d                    | Numeric   |             |
| dropdownselectionclicks14d                 | Integer   |             |
| dropdownselectionviews14d                  | Integer   |             |
| ecpatc14d                                  | Numeric   |             |
| ecpatl14d                                  | Numeric   |             |
| ecpc                                       | Numeric   |             |
| ecpdpv14d                                  | Numeric   |             |
| ecpdvp14d                                  | Numeric   |             |
| ecpm                                       | Numeric   |             |
| ecpp14d                                    | Numeric   |             |
| ecpprpv14d                                 | Numeric   |             |
| ecppt14d                                   | Numeric   |             |
| ecpvs14d                                   | Numeric   |             |
| ecpnewsubscribeandsave14d                  | Numeric   |             |
| erpm14d                                    | Numeric   |             |
| ecpr14d                                    | Numeric   |             |
| ecpvc                                      | Numeric   |             |
| ecpvd14d                                   | Numeric   |             |
| emailinteraction14d                        | Numeric   |             |
| emailinteractioncpa14d                     | Numeric   |             |
| emailinteractioncvr14d                     | Numeric   |             |
| emailinteractionclicks14d                  | Integer   |             |
| emailinteractionviews14d                   | Integer   |             |
| emailload14d                               | Numeric   |             |
| emailloadcpa14d                            | Numeric   |             |
| emailloadcvr14d                            | Numeric   |             |
| emailloadclicks14d                         | Integer   |             |
| emailloadviews14d                          | Integer   |             |
| entityid                                   | String    |             |
| gameinteraction14d                         | Numeric   |             |
| gameinteractioncpa14d                      | Numeric   |             |
| gameinteractioncvr14d                      | Numeric   |             |
| gameinteractionclicks14d                   | Integer   |             |
| gameinteractionviews14d                    | Numeric   |             |
| gameload14d                                | Numeric   |             |
| gameloadcpa14d                             | Numeric   |             |
| gameloadcvr14d                             | Numeric   |             |
| gameloadclicks14d                          | Integer   |             |
| gameloadviews14d                           | Integer   |             |
| homepagevisit14d                           | Numeric   |             |
| homepagevisitcpa14d                        | Numeric   |             |
| homepagevisitcvr14d                        | Numeric   |             |
| homepagevisitclicks14d                     | Integer   |             |
| homepagevisitviews14d                      | Integer   |             |
| impressions                                | Numeric   |             |
| intervalend                                | Numeric   |             |
| intervalstart                              | Numeric   |             |
| marketinglandingpage14d                    | Numeric   |             |
| marketinglandingpagecpa14d                 | Numeric   |             |
| marketinglandingpagecvr14d                 | Numeric   |             |
| marketinglandingpageclicks14d              | Integer   |             |
| marketinglandingpageviews14d               | Numeric   |             |
| mashupaddtocart14d                         | Numeric   |             |
| mashupaddtocartcpa14d                      | Numeric   |             |
| mashupaddtocartclickcvr14d                 | Numeric   |             |
| mashupaddtocartclicks14d                   | Integer   |             |
| mashupaddtocartviews14d                    | Integer   |             |
| mashupaddtowishlist14d                     | Numeric   |             |
| mashupaddtowishlistcpa14d                  | Numeric   |             |
| mashupaddtowishlistcvr14d                  | Numeric   |             |
| mashupaddtowishlistclicks14d               | Integer   |             |
| mashupaddtowishlistviews14d                | Integer   |             |
| mashupbackupimagecpa                       | Numeric   |             |
| mashupbackupimagecvr                       | Numeric   |             |
| mashupbackupimageclicks                    | Integer   |             |
| mashupbackupimageviews                     | Integer   |             |
| mashupbackupimage                          | Numeric   |             |
| mashupclicktopagecpa                       | Numeric   |             |
| mashupclicktopagecvr                       | Numeric   |             |
| mashupclicktopageclicks                    | Integer   |             |
| mashupclicktopageviews                     | Integer   |             |
| mashupclicktopage                          | Numeric   |             |
| mashupclipcouponclick14d                   | Integer   |             |
| mashupclipcouponclickcpa14d                | Integer   |             |
| mashupclipcouponclickcvr14d                | Integer   |             |
| mashupclipcouponclickclicks14d             | Integer   |             |
| mashupclipcouponclickviews14d              | Integer   |             |
| mashupshopnowclick14d                      | Integer   |             |
| mashupshopnowclickcpa14d                   | Integer   |             |
| mashupshopnowclickcvr14d                   | Integer   |             |
| mashupshopnowclickclicks14d                | Integer   |             |
| mashupshopnowclickviews14d                 | Integer   |             |
| mashupsubscribeandsave14d                  | Numeric   |             |
| mashupsubscribeandsavecpa14d               | Numeric   |             |
| mashupsubscribeandsavecvr14d               | Numeric   |             |
| mashupsubscribeandsaveclick14d             | Integer   |             |
| mashupsubscribeandsaveclickviews14d        | Integer   |             |
| measurableimpressions                      | Numeric   |             |
| measurablerate                             | Numeric   |             |
| messagesent14d                             | Numeric   |             |
| messagesentcpa14d                          | Numeric   |             |
| messagesentcvr14d                          | Numeric   |             |
| messagesentclicks14d                       | Integer   |             |
| messagesentviews14d                        | Integer   |             |
| mobileappfirststartcvr14d                  | Numeric   |             |
| mobileappfirststartclicks14d               | Integer   |             |
| mobileappfirststartviews14d                | Integer   |             |
| mobileappfirststarts14d                    | Numeric   |             |
| mobileappfirststartscpa14d                 | Numeric   |             |
| newsubscribeandsave14d                     | Numeric   |             |
| newsubscribeandsaveclicks14d               | Integer   |             |
| newsubscribeandsaverate14d                 | Numeric   |             |
| newsubscribeandsaveviews14d                | Integer   |             |
| newtobrandecpp14d                          | Numeric   |             |
| newtobranderpm14d                          | Numeric   |             |
| newtobrandproductsales14d                  | Numeric   |             |
| newtobrandpurchaserate14d                  | Numeric   |             |
| newtobrandpurchases14d                     | Numeric   |             |
| newtobrandpurchasesclicks14d               | Integer   |             |
| newtobrandpurchasesviews14d                | Numeric   |             |
| newtobrandroas14d                          | Numeric   |             |
| newtobrandunitssold14d                     | Numeric   |             |
| prpv14d                                    | Numeric   |             |
| prpvclicks14d                              | Integer   |             |
| prpvviews14d                               | Integer   |             |
| prpvr14d                                   | Numeric   |             |
| percentofpurchasesnewtobrand14d            | Numeric   |             |
| playtrailerrate14d                         | Numeric   |             |
| playtrailers14d                            | Numeric   |             |
| playtrailersviews14d                       | Numeric   |             |
| playertrailersclicks14d                    | Integer   |             |
| productpurchasedcpa                        | Numeric   |             |
| productpurchasedcvr                        | Numeric   |             |
| productpurchasedclicks                     | Integer   |             |
| productpurchasedviews                      | Integer   |             |
| productpurchased                           | Numeric   |             |
| purchasebutton14d                          | Numeric   |             |
| purchasebuttoncpa14d                       | Numeric   |             |
| purchasebuttoncvr14d                       | Numeric   |             |
| purchasebuttonclicks14d                    | Integer   |             |
| purchasebuttonviews14d                     | Numeric   |             |
| purchaserate14d                            | Numeric   |             |
| purchases14d                               | Numeric   |             |
| purchasesclicks14d                         | Integer   |             |
| purchasesviews14d                          | Integer   |             |
| reporttype                                 | String    |             |
| referral14d                                | Numeric   |             |
| referralcpa14d                             | Numeric   |             |
| referralcvr14d                             | Numeric   |             |
| referralclicks14d                          | Integer   |             |
| referralviews14d                           | Numeric   |             |
| registrationconfirmpage14d                 | Numeric   |             |
| registrationconfirmpagecpa14d              | Numeric   |             |
| registrationconfirmpagecvr14d              | Numeric   |             |
| registrationconfirmpageclicks14d           | Integer   |             |
| registrationconfirmpageviews14d            | Numeric   |             |
| registrationform14d                        | Numeric   |             |
| registrationformcpa14d                     | Numeric   |             |
| registrationformcvr14d                     | Numeric   |             |
| registrationformclicks14d                  | Integer   |             |
| registrationformviews14d                   | Integer   |             |
| rentalrate14d                              | Numeric   |             |
| rentals14d                                 | Numeric   |             |
| rentalsclicks14d                           | Integer   |             |
| rentalsviews14d                            | Integer   |             |
| sales14d                                   | Numeric   |             |
| signupbutton14d                            | Numeric   |             |
| signupbuttoncpa14d                         | Numeric   |             |
| signupbuttoncvr14d                         | Numeric   |             |
| signupbuttonclicks14d                      | Numeric   |             |
| signupbuttonviews14d                       | Numeric   |             |
| signuppage14d                              | Numeric   |             |
| signuppagecpa14d                           | Numeric   |             |
| signuppagecvr14d                           | Numeric   |             |
| signuppageclicks14d                        | Numeric   |             |
| signuppageviews14d                         | Numeric   |             |
| storelocatorpage14d                        | Numeric   |             |
| storelocatorpagecpa14d                     | Numeric   |             |
| storelocatorpagecvr14d                     | Numeric   |             |
| storelocatorpageclicks14d                  | Numeric   |             |
| storelocatorpageviews14d                   | Numeric   |             |
| submitbutton14d                            | Numeric   |             |
| submitbuttoncpa14d                         | Numeric   |             |
| submitbuttoncvr14d                         | Numeric   |             |
| submitbuttonclicks14d                      | Numeric   |             |
| submitbuttonviews14d                       | Numeric   |             |
| subscriptionbutton14d                      | Numeric   |             |
| subscriptionbuttoncpa14d                   | Numeric   |             |
| subscriptionbuttoncvr14d                   | Numeric   |             |
| subscriptionbuttonclicks14d                | Numeric   |             |
| subscriptionbuttonviews14d                 | Numeric   |             |
| subscriptionpage14d                        | Numeric   |             |
| subscriptionpagecpa14d                     | Numeric   |             |
| subscriptionpagecvr14d                     | Numeric   |             |
| subscriptionpageclicks14d                  | Numeric   |             |
| subscriptionpageviews14d                   | Numeric   |             |
| successpage14d                             | Numeric   |             |
| successpagecpa14d                          | Numeric   |             |
| successpagecvr14d                          | Numeric   |             |
| successpageclicks14d                       | Numeric   |             |
| successpageviews14d                        | Numeric   |             |
| supplycost                                 | Numeric   |             |
| surveyfinish14d                            | Numeric   |             |
| surveyfinishcpa14d                         | Numeric   |             |
| surveyfinishcvr14d                         | Numeric   |             |
| surveyfinishclicks14d                      | Numeric   |             |
| surveyfinishviews14d                       | Numeric   |             |
| surveystart14d                             | Numeric   |             |
| surveystartcpa14d                          | Numeric   |             |
| surveystartcvr14d                          | Numeric   |             |
| surveystartclicks14d                       | Numeric   |             |
| surveystartviews14d                        | Numeric   |             |
| thankyoupage14d                            | Numeric   |             |
| thankyoupagecpa14d                         | Numeric   |             |
| thankyoupagecvr14d                         | Numeric   |             |
| thankyoupageclicks14d                      | Numeric   |             |
| thankyoupageviews14d                       | Numeric   |             |
| totaladdtocart14d                          | Numeric   |             |
| totaladdtocartcpa14d                       | Numeric   |             |
| totaladdtocartcvr14d                       | Numeric   |             |
| totaladdtocartclicks14d                    | Numeric   |             |
| totaladdtocartviews14d                     | Numeric   |             |
| totaladdtolist14d                          | Numeric   |             |
| totaladdtolistcpa14d                       | Numeric   |             |
| totaladdtolistcvr14d                       | Numeric   |             |
| totaladdtolistclicks14d                    | Numeric   |             |
| totaladdtolistviews14d                     | Numeric   |             |
| totalcost                                  | Numeric   |             |
| totaldetaipageviewcpa14d                   | Numeric   |             |
| totaldetailpageclicks14d                   | Numeric   |             |
| totaldetailpageviewviews14d                | Numeric   |             |
| totaldetailpageviews14d                    | Numeric   |             |
| totaldetailpageviewscvr14d                 | Numeric   |             |
| totalecpp14d                               | Numeric   |             |
| totalecpprpv14d                            | Numeric   |             |
| totalerpm14d                               | Numeric   |             |
| totalfee                                   | Numeric   |             |
| totalnewtobrandecpp14d                     | Numeric   |             |
| totalnewtobranderpm14d                     | Numeric   |             |
| totalnewtobrandproductsales14d             | Numeric   |             |
| totalnewtobrandpurchaserate14d             | Numeric   |             |
| totalnewtobrandpurchases14d                | Numeric   |             |
| totalnewtobrandpurchasesclicks14d          | Numeric   |             |
| totalnewtobrandpurchasesviews14d           | Numeric   |             |
| totalnewtobrandroass14d                    | Numeric   |             |
| totalnewtobrandunitssold14d                | Numeric   |             |
| totalprpv14d                               | Numeric   |             |
| totalprpvclicks14d                         | Numeric   |             |
| totalprpvviews14d                          | Numeric   |             |
| totalprpvr14d                              | Numeric   |             |
| totalpercentofpurchasesnewtobrand14d       | Numeric   |             |
| totalpixel14d                              | Numeric   |             |
| totalpixelcpa14d                           | Numeric   |             |
| totalpixelcvr14d                           | Numeric   |             |
| totalpixelclicks14d                        | Numeric   |             |
| totalpixelviews14d                         | Numeric   |             |
| totalpurchaserate14d                       | Numeric   |             |
| totalpurchases14d                          | Numeric   |             |
| totalpurchasesclicks14d                    | Numeric   |             |
| totalpurchasesviews14d                     | Numeric   |             |
| totalroas14d                               | Numeric   |             |
| totalsales14d                              | Numeric   |             |
| totalsubscribeandsavesubscriptioncpa14d    | Numeric   |             |
| totalsubscribeandsavesubscriptioncvr14d    | Numeric   |             |
| totalsubscribeandsavesubscriptionclicks14d | Numeric   |             |
| totalsubscribeandsavesubscriptionviews14d  | Numeric   |             |
| totalsubscribeandsavesubscriptions14d      | Numeric   |             |
| totalunitssold14d                          | Numeric   |             |
| unitssold14d                               | Numeric   |             |
| videocomplete                              | Numeric   |             |
| videocompletedcpa                          | Numeric   |             |
| videocompletedcvr                          | Numeric   |             |
| videocompletedviews                        | Numeric   |             |
| videocompleted                             | Numeric   |             |
| videocompletionrate                        | Numeric   |             |
| videodownloadrate14d                       | Numeric   |             |
| videodownloads14d                          | Numeric   |             |
| videodownloadsclicks14d                    | Numeric   |             |
| videodownloadsviews14d                     | Numeric   |             |
| videoendclicks                             | Numeric   |             |
| videofirstquartile                         | Numeric   |             |
| videomidpoint                              | Numeric   |             |
| videomute                                  | Numeric   |             |
| videopause                                 | Numeric   |             |
| videoresume                                | Numeric   |             |
| videostart                                 | Numeric   |             |
| videostartedcpa                            | Numeric   |             |
| videostartedcvr                            | Numeric   |             |
| videostartedclicks                         | Numeric   |             |
| videostartedviews                          | Numeric   |             |
| videostarted                               | Numeric   |             |
| videostreams14d                            | Numeric   |             |
| videostreamsclicks14d                      | Numeric   |             |
| videostreamsrate14d                        | Numeric   |             |
| registrationconfirmpageeostreamsviews14d   | Numeric   |             |
| videothirdquartile                         | Numeric   |             |
| videounmute                                | Numeric   |             |
| viewabilityrate                            | Numeric   |             |
| viewableimpressions                        | Numeric   |             |
| widgetinteraction14d                       | Numeric   |             |
| widgetinteractioncpa14d                    | Numeric   |             |
| widgetinteractioncvr14d                    | Numeric   |             |
| widgetinteractionclicks14d                 | Numeric   |             |
| widgetinteractionviews14d                  | Numeric   |             |
| widgetload14d                              | Numeric   |             |
| widgetloadcpa14d                           | Numeric   |             |
| widgetloadcvr14d                           | Numeric   |             |
| widgetloadclicks14d                        | Numeric   |             |
| widgetloadviews14d                         | Numeric   |             |
| eventid                                    | Integer   |             |
| combined\_product\_sales                   | Numeric   |             |
| brandsearch14d                             | Numeric   |             |
| brandsearchclicks14d                       | Numeric   |             |
| brandsearchviews14d                        | Numeric   |             |
| brandsearchrate14d                         | Numeric   |             |
| brandsearchcpa14d                          | Numeric   |             |
| download\_date                             | Date      |             |

### Product Report

Table name: *dsp\_product\_report*

*For details on the description, please click* [*here*](https://advertising.amazon.com/API/docs/en-us/guides/reporting/dsp/metrics)*.*

<table><thead><tr><th width="312">Column Name</th><th width="100">Data type</th><th width="252">Description (Refer help link above)</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td></td></tr><tr><td>account_name</td><td>String</td><td></td></tr><tr><td>advertiserid</td><td>Integer</td><td></td></tr><tr><td>amazonstandardid</td><td>String</td><td></td></tr><tr><td>asinconversiontype</td><td>String</td><td></td></tr><tr><td>atc14d</td><td>Integer</td><td></td></tr><tr><td>atcclicks14d</td><td>Integer</td><td></td></tr><tr><td>atcviews14d</td><td>Integer</td><td></td></tr><tr><td>atl14d</td><td>Integer</td><td></td></tr><tr><td>atlclicks14d</td><td>Integer</td><td></td></tr><tr><td>atlviews14d</td><td>Integer</td><td></td></tr><tr><td>brandhaloaddtocart14d</td><td>Integer</td><td></td></tr><tr><td>brandhaloaddtocartclicks14d</td><td>Integer</td><td></td></tr><tr><td>brandhaloaddtocartviews14d</td><td>Integer</td><td></td></tr><tr><td>brandhaloaddtolist14d</td><td>Integer</td><td></td></tr><tr><td>brandhaloaddtolistclicks14d</td><td>Integer</td><td></td></tr><tr><td>brandhaloaddtolistviews14d</td><td>Integer</td><td></td></tr><tr><td>brandhalodetailpage14d</td><td>Integer</td><td></td></tr><tr><td>brandhalodetailpageclicks14d</td><td>Integer</td><td></td></tr><tr><td>brandhalodetailpageviews14d</td><td>Integer</td><td></td></tr><tr><td>brandhalonewsubscribeandsave14d</td><td>Integer</td><td></td></tr><tr><td>brandhalonewsubscribeandsaveclicks14d</td><td>Integer</td><td></td></tr><tr><td>brandhalonewsubscribeandsaveviews14d</td><td>Integer</td><td></td></tr><tr><td>brandhalonewtobrandpurchases14d</td><td>Integer</td><td></td></tr><tr><td>brandhalonewtobrandpurchasesclicks14d</td><td>Integer</td><td></td></tr><tr><td>brandhalonewtobrandpurchasesviews14d</td><td>Integer</td><td></td></tr><tr><td>brandhalopercentofpurchasesnewtobrand14d</td><td>Numeric</td><td></td></tr><tr><td>brandhaloproductreviewpage14d</td><td>Integer</td><td></td></tr><tr><td>brandhaloproductreviewpageclicks14d</td><td>Integer</td><td></td></tr><tr><td>brandhaloproductreviewpageviews14d</td><td>Integer</td><td></td></tr><tr><td>brandhalopurchases14d</td><td>Integer</td><td></td></tr><tr><td>brandhalopurchasesclicks14d</td><td>Integer</td><td></td></tr><tr><td>brandhalopurchasesviews14d</td><td>Integer</td><td></td></tr><tr><td>brandhalototalnewtobrandsales14d</td><td>Numeric</td><td></td></tr><tr><td>brandhalototalnewtobrandunitssold14d</td><td>Integer</td><td></td></tr><tr><td>brandhalototalsales14d</td><td>Numeric</td><td></td></tr><tr><td>brandhalototalunitssold14d</td><td>Integer</td><td></td></tr><tr><td>brandname</td><td>String</td><td></td></tr><tr><td>download_date</td><td>Date Time</td><td></td></tr><tr><td>dpv14d</td><td>Integer</td><td></td></tr><tr><td>dpvclicks14d</td><td>Integer</td><td></td></tr><tr><td>dpvviews14d</td><td>Integer</td><td></td></tr><tr><td>featuredasin</td><td>String</td><td></td></tr><tr><td>lineitemid</td><td>String</td><td></td></tr><tr><td>marketplace</td><td>String</td><td></td></tr><tr><td>newsubscribeandsave14d</td><td>Integer</td><td></td></tr><tr><td>newsubscribeandsaveclicks14d</td><td>Integer</td><td></td></tr><tr><td>newsubscribeandsaveviews14d</td><td>Integer</td><td></td></tr><tr><td>newtobrandproductsales14d</td><td>Numeric</td><td></td></tr><tr><td>newtobrandpurchases14d</td><td>Integer</td><td></td></tr><tr><td>newtobrandpurchasesclicks14d</td><td>Integer</td><td></td></tr><tr><td>newtobrandpurchasesviews14d</td><td>Integer</td><td></td></tr><tr><td>newtobrandunitssold14d</td><td>Integer</td><td></td></tr><tr><td>orderid</td><td>String</td><td></td></tr><tr><td>parentasin</td><td>String</td><td></td></tr><tr><td>percentofpurchasesnewtobrand14d</td><td>Numeric</td><td></td></tr><tr><td>productcategory</td><td>String</td><td></td></tr><tr><td>productgroup</td><td>String</td><td></td></tr><tr><td>productid</td><td>String</td><td></td></tr><tr><td>productname</td><td>String</td><td></td></tr><tr><td>productsubcategory</td><td>String</td><td></td></tr><tr><td>prpv14d</td><td>Integer</td><td></td></tr><tr><td>prpvclicks14d</td><td>Integer</td><td></td></tr><tr><td>prpvviews14d</td><td>Integer</td><td></td></tr><tr><td>purchases14d</td><td>Integer</td><td></td></tr><tr><td>purchasesclicks14d</td><td>Integer</td><td></td></tr><tr><td>purchasesviews14d</td><td>Integer</td><td></td></tr><tr><td>reportdate</td><td>Date Time</td><td></td></tr><tr><td>reportgranularity</td><td>String</td><td></td></tr><tr><td>sales14d</td><td>Numeric</td><td></td></tr><tr><td>totaladdtocart14d</td><td>Integer</td><td></td></tr><tr><td>totaladdtocartclicks14d</td><td>Integer</td><td></td></tr><tr><td>totaladdtocartviews14d</td><td>Integer</td><td></td></tr><tr><td>totaladdtolist14d</td><td>Integer</td><td></td></tr><tr><td>totaladdtolistclicks14d</td><td>Integer</td><td></td></tr><tr><td>totaladdtolistviews14d</td><td>Integer</td><td></td></tr><tr><td>totaldetailpageclicks14d</td><td>Integer</td><td></td></tr><tr><td>totaldetailpageviews14d</td><td>Integer</td><td></td></tr><tr><td>totaldetailpageviewviews14d</td><td>Integer</td><td></td></tr><tr><td>totalnewtobrandpurchases14d</td><td>Integer</td><td></td></tr><tr><td>totalnewtobrandpurchasesclicks14d</td><td>Integer</td><td></td></tr><tr><td>totalnewtobrandpurchasesviews14d</td><td>Integer</td><td></td></tr><tr><td>totalpercentofpurchasesnewtobrand14d</td><td>Numeric</td><td></td></tr><tr><td>totalprpv14d</td><td>Integer</td><td></td></tr><tr><td>totalprpvclicks14d</td><td>Integer</td><td></td></tr><tr><td>totalprpvviews14d</td><td>Integer</td><td></td></tr><tr><td>totalpurchases14d</td><td>Integer</td><td></td></tr><tr><td>totalpurchasesclicks14d</td><td>Integer</td><td></td></tr><tr><td>totalpurchasesviews14d</td><td>Integer</td><td></td></tr><tr><td>totalsales14d</td><td>Numeric</td><td></td></tr><tr><td>totalsubscribeandsavesubscriptionclicks14d</td><td>Integer</td><td></td></tr><tr><td>totalsubscribeandsavesubscriptions14d</td><td>Integer</td><td></td></tr><tr><td>totalsubscribeandsavesubscriptionviews14d</td><td>Integer</td><td></td></tr><tr><td>totalunitssold14d</td><td>Integer</td><td></td></tr><tr><td>unitssold14d</td><td>Integer</td><td></td></tr></tbody></table>

### Inventory Report&#x20;

Table name: amazon\_source\_data.*dsp\_inventory\_report*

*For details on the description, please click* [*here*](https://advertising.amazon.com/API/docs/en-us/guides/reporting/dsp/metrics)*.*

| Column Name                                            | Data Type | Description |
| ------------------------------------------------------ | --------- | ----------- |
| advertiserid                                           | Integer   |             |
| account\_id                                            | Integer   |             |
| account\_name                                          | String    |             |
| report\_date                                           | Date Time |             |
| entity\_id                                             | String    |             |
| order\_name                                            | String    |             |
| order\_id                                              | String    |             |
| order\_start\_date                                     | Date Time |             |
| order\_end\_date                                       | Date Time |             |
| order\_budget                                          | Numeric   |             |
| order\_external\_id                                    | String    |             |
| order\_currency                                        | String    |             |
| line\_item\_name                                       | String    |             |
| line\_item\_id                                         | String    |             |
| line\_item\_start\_date                                | Date Time |             |
| line\_item\_end\_date                                  | Date Time |             |
| line\_item\_budget                                     | Numeric   |             |
| line\_item\_external\_id                               | String    |             |
| site\_name                                             | String    |             |
| placement\_size                                        | String    |             |
| placement\_name                                        | String    |             |
| supply\_source\_name                                   | String    |             |
| brand\_store\_engagement\_1\_cpa                       | Integer   |             |
| mashup\_subscribe\_and\_save\_click\_views\_14d        | Integer   |             |
| email\_interaction\_clicks\_14d                        | Integer   |             |
| total\_cost                                            | Numeric   |             |
| click\_on\_redirect\_clicks\_14d                       | Integer   |             |
| brand\_store\_engagement\_2\_clicks                    | Integer   |             |
| add\_to\_watchlist\_views\_14d                         | Integer   |             |
| widget\_interaction\_clicks\_14d                       | Integer   |             |
| referral\_cvr\_14d                                     | Numeric   |             |
| purchase\_button\_14d                                  | Integer   |             |
| brand\_store\_engagement\_5\_clicks                    | Integer   |             |
| application\_cvr\_14d                                  | Numeric   |             |
| amazon\_platform\_fee                                  | Numeric   |             |
| marketing\_landing\_page\_14d                          | Integer   |             |
| application\_views\_14d                                | Integer   |             |
| survey\_finish\_cpa\_14d                               | Integer   |             |
| rentals\_views\_14d                                    | Integer   |             |
| ctr                                                    | Numeric   |             |
| referral\_cpa\_14d                                     | Integer   |             |
| mobile\_app\_first\_starts\_cpa\_14d                   | Integer   |             |
| message\_sent\_views\_14d                              | Integer   |             |
| video\_streams\_views\_14d                             | Integer   |             |
| purchases\_views\_14d                                  | Integer   |             |
| submit\_button\_14d                                    | Integer   |             |
| registration\_confirm\_page\_14d                       | Integer   |             |
| email\_load\_views\_14d                                | Integer   |             |
| email\_interaction\_cvr\_14d                           | Numeric   |             |
| survey\_finish\_cvr\_14d                               | Numeric   |             |
| search\_cpa\_14d                                       | Numeric   |             |
| brand\_store\_engagement\_3\_views                     | Integer   |             |
| search\_cvr\_14d                                       | Numeric   |             |
| referral\_views\_14d                                   | Integer   |             |
| video\_started\_clicks                                 | Integer   |             |
| added\_to\_shopping\_cart\_clicks\_14d                 | Integer   |             |
| mashup\_click\_to\_page\_clicks                        | Integer   |             |
| mobile\_app\_first\_start\_cvr\_14d                    | Numeric   |             |
| email\_interaction\_views\_14d                         | Integer   |             |
| brand\_store\_engagement\_4\_views                     | Integer   |             |
| other\_14d                                             | Integer   |             |
| mashup\_shop\_now\_click\_views\_14d                   | Integer   |             |
| email\_interaction\_14d                                | Integer   |             |
| registration\_form\_14d                                | Integer   |             |
| play\_trailers\_14d                                    | Integer   |             |
| rental\_rate\_14d                                      | Numeric   |             |
| game\_load\_clicks\_14d                                | Integer   |             |
| mashup\_clip\_coupon\_click\_views\_14d                | Integer   |             |
| video\_midpoint                                        | Integer   |             |
| registration\_form\_cvr\_14d                           | Numeric   |             |
| click\_on\_redirect\_14d                               | Integer   |             |
| mashup\_add\_to\_cart\_cpa\_14d                        | Integer   |             |
| lead\_cvr\_14d                                         | Numeric   |             |
| brand\_store\_engagement\_4\_cvr                       | Numeric   |             |
| mashup\_subscribe\_and\_save\_cvr\_14d                 | Numeric   |             |
| dpvr\_14d                                              | Numeric   |             |
| video\_completed\_cpa                                  | Integer   |             |
| new\_to\_brand\_purchase\_rate\_14d                    | Numeric   |             |
| video\_completed\_views                                | Integer   |             |
| other\_views\_14d                                      | Integer   |             |
| game\_interaction\_cvr\_14d                            | Numeric   |             |
| drop\_down\_selection\_cpa\_14d                        | Integer   |             |
| brand\_store\_engagement\_1\_cvr                       | Numeric   |             |
| survey\_start\_views\_14d                              | Integer   |             |
| checkout\_14d                                          | Integer   |             |
| new\_subscribe\_and\_save\_rate\_14d                   | Numeric   |             |
| registration\_confirm\_page\_cpa\_14d                  | Integer   |             |
| subscription\_button\_clicks\_14d                      | Integer   |             |
| mobile\_app\_first\_start\_clicks\_14d                 | Integer   |             |
| ecpvc                                                  | Numeric   |             |
| brand\_store\_engagement\_6\_cpa                       | Integer   |             |
| prpvr\_14d                                             | Numeric   |             |
| survey\_start\_clicks\_14d                             | Integer   |             |
| homepage\_visit\_cvr\_14d                              | Numeric   |             |
| click\_on\_redirect\_cpa\_14d                          | Integer   |             |
| subscription\_button\_cvr\_14d                         | Numeric   |             |
| registration\_form\_clicks\_14d                        | Integer   |             |
| store\_locator\_page\_cvr\_14d                         | Numeric   |             |
| mashup\_click\_to\_page                                | Integer   |             |
| brand\_store\_engagement\_3\_cpa                       | Integer   |             |
| rentals\_clicks\_14d                                   | Integer   |             |
| mashup\_clip\_coupon\_click\_cvr\_14d                  | Numeric   |             |
| game\_load\_cpa\_14d                                   | Integer   |             |
| video\_started\_views                                  | Integer   |             |
| new\_to\_brand\_purchases\_views\_14d                  | Integer   |             |
| mobile\_app\_first\_starts\_14d                        | Integer   |             |
| mashup\_backup\_image                                  | Integer   |             |
| widget\_load\_cvr\_14d                                 | Numeric   |             |
| brand\_store\_engagement\_3\_cvr                       | Numeric   |             |
| game\_interaction\_views\_14d                          | Integer   |             |
| video\_end\_clicks                                     | Integer   |             |
| brand\_store\_engagement\_2\_views                     | Integer   |             |
| application\_14d                                       | Integer   |             |
| mashup\_backup\_image\_cpa                             | Integer   |             |
| new\_to\_brand\_purchases\_14d                         | Integer   |             |
| video\_mute                                            | Integer   |             |
| game\_load\_views\_14d                                 | Integer   |             |
| banner\_interaction\_clicks\_14d                       | Integer   |             |
| accept\_views\_14d                                     | Integer   |             |
| email\_load\_clicks\_14d                               | Integer   |             |
| ecpatl\_14d                                            | Numeric   |             |
| widget\_interaction\_14d                               | Integer   |             |
| brand\_store\_engagement\_3                            | Integer   |             |
| message\_sent\_14d                                     | Integer   |             |
| add\_to\_watchlist\_14d                                | Integer   |             |
| ecpatc\_14d                                            | Numeric   |             |
| atc\_views\_14d                                        | Integer   |             |
| success\_page\_views\_14d                              | Integer   |             |
| mashup\_add\_to\_cart\_14d                             | Integer   |             |
| downloaded\_video\_plays\_14d                          | Integer   |             |
| widget\_load\_views\_14d                               | Integer   |             |
| purchase\_button\_clicks\_14d                          | Integer   |             |
| contact\_14d                                           | Integer   |             |
| video\_complete                                        | Integer   |             |
| purchase\_button\_cvr\_14d                             | Numeric   |             |
| other\_cvr\_14d                                        | Numeric   |             |
| marketing\_landing\_page\_cvr\_14d                     | Numeric   |             |
| video\_streams\_14d                                    | Integer   |             |
| mashup\_click\_to\_page\_views                         | Integer   |             |
| dpv\_clicks\_14d                                       | Integer   |             |
| success\_page\_cpa\_14d                                | Integer   |             |
| drop\_down\_selection\_14d                             | Integer   |             |
| atcr\_14d                                              | Numeric   |             |
| video\_downloads\_views\_14d                           | Integer   |             |
| game\_interaction\_cpa\_14d                            | Integer   |             |
| mashup\_subscribe\_and\_save\_click\_14d               | Integer   |             |
| mashup\_click\_to\_page\_cpa                           | Numeric   |             |
| brand\_store\_engagement\_4                            | Numeric   |             |
| add\_to\_watchlist\_clicks\_14d                        | Integer   |             |
| accept\_cvr\_14d                                       | Numeric   |             |
| video\_resume                                          | Numeric   |             |
| brand\_store\_engagement\_6\_cvr                       | Numeric   |             |
| banner\_interaction\_14d                               | Numeric   |             |
| brand\_store\_engagement\_6\_views                     | Integer   |             |
| brand\_store\_engagement\_3\_clicks                    | Integer   |             |
| mashup\_add\_to\_cart\_click\_cvr\_14d                 | Numeric   |             |
| subscription\_button\_views\_14d                       | Numeric   |             |
| percent\_of\_purchases\_new\_to\_brand\_14d            | Numeric   |             |
| mashup\_backup\_image\_clicks                          | Integer   |             |
| lead\_cpa\_14d                                         | Integer   |             |
| purchase\_button\_views\_14d                           | Integer   |             |
| brand\_store\_engagement\_6\_clicks                    | Integer   |             |
| referral\_14d                                          | Integer   |             |
| banner\_interaction\_cvr\_14d                          | Numeric   |             |
| video\_first\_quartile                                 | Integer   |             |
| added\_to\_shopping\_cart\_14d                         | Integer   |             |
| new\_subscribe\_and\_save\_clicks\_14d                 | Integer   |             |
| referral\_clicks\_14d                                  | Integer   |             |
| video\_completed\_cvr                                  | Numeric   |             |
| mashup\_subscribe\_and\_save\_cpa\_14d                 | Numeric   |             |
| mashup\_backup\_image\_views                           | Integer   |             |
| atc\_14d                                               | Integer   |             |
| thank\_you\_page\_views\_14d                           | Integer   |             |
| downloaded\_video\_plays\_clicks\_14d                  | Integer   |             |
| survey\_finish\_views\_14d                             | Integer   |             |
| submit\_button\_cpa\_14d                               | Integer   |             |
| prpv\_clicks\_14d                                      | Integer   |             |
| dpv\_14d                                               | Integer   |             |
| search\_clicks\_14d                                    | Integer   |             |
| mobile\_app\_first\_start\_views\_14d                  | Integer   |             |
| click\_throughs                                        | Numeric   |             |
| advertiser\_country                                    | String    |             |
| lead\_clicks\_14d                                      | Integer   |             |
| ecpnew\_subscribe\_and\_save\_14d                      | Numeric   |             |
| application\_clicks\_14d                               | Integer   |             |
| marketing\_landing\_page\_clicks\_14d                  | Integer   |             |
| video\_pause                                           | Integer   |             |
| banner\_interaction\_views\_14d                        | Integer   |             |
| mashup\_add\_to\_cart\_clicks\_14d                     | Integer   |             |
| atc\_clicks\_14d                                       | Integer   |             |
| email\_load\_cpa\_14d                                  | Numeric   |             |
| video\_started                                         | Integer   |             |
| video\_downloads\_14d                                  | Integer   |             |
| mashup\_add\_to\_wishlist\_cpa\_14d                    | Numeric   |             |
| mashup\_clip\_coupon\_click\_clicks\_14d               | Integer   |             |
| brand\_store\_engagement5\_cvr                         | Numeric   |             |
| video\_started\_cpa                                    | Integer   |             |
| thank\_you\_page\_cpa\_14d                             | Numeric   |             |
| thank\_you\_page\_clicks\_14d                          | Integer   |             |
| survey\_finish\_14d                                    | Integer   |             |
| email\_load\_cvr\_14d                                  | Numeric   |             |
| checkout\_cpa\_14d                                     | Numeric   |             |
| brand\_store\_engagement6                              | Integer   |             |
| contact\_clicks\_14d                                   | Integer   |             |
| thank\_you\_page\_cvr\_14d                             | Numeric   |             |
| mashup\_add\_to\_wishlist\_cvr\_14d                    | Numeric   |             |
| other\_clicks\_14d                                     | Numeric   |             |
| video\_third\_quartile                                 | Numeric   |             |
| prpv\_14d                                              | Numeric   |             |
| ecppt\_14d                                             | Numeric   |             |
| ecpdvp\_14d                                            | Numeric   |             |
| lead\_views\_14d                                       | Numeric   |             |
| store\_locator\_page\_clicks\_14d                      | Numeric   |             |
| brand\_store\_engagement7                              | Integer   |             |
| checkout\_cvr\_14d                                     | Numeric   |             |
| mashup\_clip\_coupon\_click\_14d                       | Numeric   |             |
| video\_started\_cvr                                    | Numeric   |             |
| rentals\_14d                                           | Numeric   |             |
| mashup\_shop\_now\_click\_clicks\_14d                  | Numeric   |             |
| survey\_start\_14d                                     | Numeric   |             |
| brand\_store\_engagement5\_cpa                         | Numeric   |             |
| ecpvs\_14d                                             | Numeric   |             |
| decline\_clicks\_14d                                   | Numeric   |             |
| checkout\_views\_14d                                   | Numeric   |             |
| mashup\_shop\_now\_click\_14d                          | Numeric   |             |
| atlr\_14d                                              | Numeric   |             |
| search\_views\_14d                                     | Numeric   |             |
| downloaded\_video\_play\_rate\_14d                     | Numeric   |             |
| purchase\_rate\_14d                                    | Numeric   |             |
| homepage\_visit\_14d                                   | Numeric   |             |
| atl\_14d                                               | Numeric   |             |
| purchase\_button\_cpa\_14d                             | Numeric   |             |
| new\_to\_brand\_purchases\_clicks\_14d                 | Numeric   |             |
| homepage\_visit\_views\_14d                            | Numeric   |             |
| contact\_views\_14d                                    | Numeric   |             |
| brand\_store\_engagement2\_cpa                         | Numeric   |             |
| play\_trailer\_rate\_14d                               | Numeric   |             |
| mashup\_shop\_now\_click\_cvr\_14d                     | Numeric   |             |
| advertiser\_timezone                                   | String    |             |
| video\_completed                                       | Integer   |             |
| purchases\_14d                                         | Numeric   |             |
| decline\_views\_14d                                    | Numeric   |             |
| new\_subscribe\_and\_save\_14d                         | Numeric   |             |
| mashup\_add\_to\_wishlist\_14d                         | Numeric   |             |
| widget\_load\_cpa\_14d                                 | Numeric   |             |
| video\_start                                           | Integer   |             |
| registration\_form\_views\_14d                         | Numeric   |             |
| prpv\_views\_14d                                       | Numeric   |             |
| banner\_interaction\_cpa\_14d                          | Numeric   |             |
| store\_locator\_page\_views\_14d                       | Numeric   |             |
| mashup\_click\_to\_page\_cvr                           | Numeric   |             |
| brand\_store\_engagement1\_clicks                      | Numeric   |             |
| success\_page\_cvr\_14d                                | Numeric   |             |
| store\_locator\_page\_cpa\_14d                         | Numeric   |             |
| message\_sent\_clicks\_14d                             | Numeric   |             |
| game\_load\_14d                                        | Numeric   |             |
| brand\_store\_engagement5                              | Integer   |             |
| brand\_store\_engagement7\_views                       | Numeric   |             |
| added\_to\_shopping\_cart\_views\_14d                  | Numeric   |             |
| brand\_store\_engagement4\_clicks                      | Numeric   |             |
| survey\_start\_cvr\_14d                                | Numeric   |             |
| click\_on\_redirect\_views\_14d                        | Numeric   |             |
| atl\_clicks\_14d                                       | Numeric   |             |
| page\_view\_cpa\_14d                                   | Numeric   |             |
| impressions                                            | Numeric   |             |
| contact\_cvr\_14d                                      | Numeric   |             |
| homepage\_visit\_clicks\_14d                           | Numeric   |             |
| purchases\_clicks\_14d                                 | Numeric   |             |
| submit\_button\_cvr\_14d                               | Numeric   |             |
| marketing\_landing\_page\_views\_14d                   | Numeric   |             |
| add\_to\_watchlist\_cpa\_14d                           | Numeric   |             |
| ecpvd\_14d                                             | Numeric   |             |
| added\_to\_shopping\_cart\_cpa\_14d                    | Numeric   |             |
| brand\_store\_engagement7\_clicks                      | Numeric   |             |
| accept\_cpa\_14d                                       | Numeric   |             |
| accept\_14d                                            | Numeric   |             |
| widget\_interaction\_cpa\_14d                          | Numeric   |             |
| drop\_down\_selection\_clicks\_14d                     | Numeric   |             |
| game\_interaction\_14d                                 | Numeric   |             |
| video\_completion\_rate                                | Numeric   |             |
| success\_page\_14d                                     | Numeric   |             |
| new\_to\_brand\_ecpp\_14d                              | Numeric   |             |
| brand\_store\_engagement2                              | Integer   |             |
| ecpdpv\_14d                                            | Numeric   |             |
| brand\_store\_engagement5\_views                       | Numeric   |             |
| checkout\_clicks\_14d                                  | Numeric   |             |
| submit\_button\_views\_14d                             | Numeric   |             |
| video\_unmute                                          | Integer   |             |
| amazon\_omnichannel\_metrics\_fee                      | Numeric   |             |
| contact\_cpa\_14d                                      | Numeric   |             |
| success\_page\_clicks\_14d                             | Numeric   |             |
| thank\_you\_page\_14d                                  | Numeric   |             |
| mashup\_backup\_image\_cvr                             | Numeric   |             |
| registration\_confirm\_page\_cvr\_14d                  | Numeric   |             |
| ecpc                                                   | Numeric   |             |
| search\_14d                                            | Numeric   |             |
| new\_subscribe\_and\_save\_views\_14d                  | Numeric   |             |
| message\_sent\_cpa\_14d                                | Numeric   |             |
| mashup\_add\_to\_cart\_views\_14d                      | Numeric   |             |
| subscription\_button\_14d                              | Numeric   |             |
| accept\_clicks\_14d                                    | Numeric   |             |
| widget\_load\_clicks\_14d                              | Numeric   |             |
| ecpm                                                   | Numeric   |             |
| page\_view\_clicks\_14d                                | Numeric   |             |
| widget\_interaction\_cvr\_14d                          | Numeric   |             |
| message\_sent\_cvr\_14d                                | Numeric   |             |
| decline\_14d                                           | Numeric   |             |
| marketing\_landing\_page\_cpa\_14d                     | Numeric   |             |
| page\_view\_views\_14d                                 | Numeric   |             |
| mashup\_clip\_coupon\_click\_cpa\_14d                  | Numeric   |             |
| ecpr\_14d                                              | Numeric   |             |
| ecpp\_14d                                              | Numeric   |             |
| registration\_confirm\_page\_views\_14d                | Numeric   |             |
| video\_streams\_rate\_14d                              | Numeric   |             |
| email\_interaction\_cpa\_14d                           | Numeric   |             |
| brand\_store\_engagement\_7\_cvr                       | Numeric   |             |
| store\_locator\_page\_14d                              | Numeric   |             |
| decline\_cvr\_14d                                      | Numeric   |             |
| other\_cpa\_14d                                        | Numeric   |             |
| drop\_down\_selection\_views\_14d                      | Numeric   |             |
| brand\_store\_engagement\_7\_cpa                       | Numeric   |             |
| mashup\_add\_to\_wishlist\_clicks\_14d                 | Numeric   |             |
| decline\_cpa\_14d                                      | Numeric   |             |
| drop\_down\_selection\_cvr\_14d                        | Numeric   |             |
| video\_streams\_clicks\_14d                            | Numeric   |             |
| registration\_confirm\_page\_clicks\_14d               | Numeric   |             |
| widget\_load\_14d                                      | Numeric   |             |
| widget\_interaction\_views\_14d                        | Numeric   |             |
| survey\_start\_cpa\_14d                                | Numeric   |             |
| amazon\_audience\_fee                                  | Numeric   |             |
| play\_trailers\_views\_14d                             | Numeric   |             |
| brand\_store\_engagement\_4\_cpa                       | Numeric   |             |
| mashup\_add\_to\_wishlist\_views\_14d                  | Numeric   |             |
| game\_interaction\_clicks\_14d                         | Numeric   |             |
| homepage\_visit\_cpa\_14d                              | Numeric   |             |
| brand\_store\_engagement\_1\_views                     | Numeric   |             |
| registration\_form\_cpa\_14d                           | Numeric   |             |
| game\_load\_cvr\_14d                                   | Numeric   |             |
| video\_downloads\_clicks\_14d                          | Numeric   |             |
| application\_cpa\_14d                                  | Numeric   |             |
| lead\_14d                                              | Numeric   |             |
| brand\_store\_engagement\_1                            | Numeric   |             |
| supply\_cost                                           | Numeric   |             |
| atl\_views\_14d                                        | Numeric   |             |
| downloaded\_video\_plays\_views\_14d                   | Numeric   |             |
| brand\_store\_engagement\_2\_cvr                       | Numeric   |             |
| survey\_finish\_clicks\_14d                            | Numeric   |             |
| submit\_button\_clicks\_14d                            | Numeric   |             |
| page\_view\_14d                                        | Numeric   |             |
| subscription\_button\_cpa\_14d                         | Numeric   |             |
| dpv\_views\_14d                                        | Numeric   |             |
| mashup\_shop\_now\_click\_cpa\_14d                     | Numeric   |             |
| video\_download\_rate\_14d                             | Numeric   |             |
| add\_to\_watchlist\_cvr\_14d                           | Numeric   |             |
| player\_trailers\_clicks\_14d                          | Numeric   |             |
| mashup\_subscribe\_and\_save\_14d                      | Numeric   |             |
| click\_on\_redirect\_cvr\_14d                          | Numeric   |             |
| page\_view\_cvr\_14d                                   | Numeric   |             |
| added\_to\_shopping\_cart\_cvr\_14d                    | Numeric   |             |
| ecpprpv\_14d                                           | Numeric   |             |
| email\_load\_14d                                       | Numeric   |             |
| brand\_search\_cpa\_14d                                | Numeric   |             |
| brand\_search\_views\_14d                              | Numeric   |             |
| brand\_search\_rate\_14d                               | Numeric   |             |
| brand\_search\_clicks\_14d                             | Numeric   |             |
| brand\_search\_14d                                     | Numeric   |             |
| invalid\_impression\_rate                              | Numeric   |             |
| gross\_click\_throughs                                 | Numeric   |             |
| invalid\_click\_throughs\_rate                         | Numeric   |             |
| invalid\_impressions                                   | Numeric   |             |
| invalid\_click\_throughs                               | Numeric   |             |
| gross\_impressions                                     | Numeric   |             |
| erpm\_14d                                              | Numeric   |             |
| total\_purchases\_14d                                  | Numeric   |             |
| total\_add\_to\_list\_views\_14d                       | Numeric   |             |
| viewability\_rate                                      | Numeric   |             |
| total\_add\_to\_cart\_cvr\_14d                         | Numeric   |             |
| new\_to\_brand\_units\_sold\_14d                       | Numeric   |             |
| fee\_cpm1                                              | Numeric   |             |
| new\_to\_brand\_roas\_14d                              | Numeric   |             |
| total\_erpm\_14d                                       | Numeric   |             |
| fee\_double\_verify                                    | Numeric   |             |
| total\_subscribe\_and\_save\_subscription\_cpa\_14d    | Numeric   |             |
| total\_new\_to\_brand\_erpm\_14d                       | Numeric   |             |
| total\_add\_to\_list\_cpa\_14d                         | Numeric   |             |
| total\_fee                                             | Numeric   |             |
| total\_add\_to\_cart\_clicks\_14d                      | Numeric   |             |
| fees                                                   | Numeric   |             |
| viewable\_impressions                                  | Numeric   |             |
| fee\_com\_score\_absorbed                              | Numeric   |             |
| total\_ecpp\_14d                                       | Numeric   |             |
| total\_purchase\_rate\_14d                             | Numeric   |             |
| fee\_integral\_ad\_science\_absorbed                   | Numeric   |             |
| total\_new\_to\_brand\_purchases\_views\_14d           | Numeric   |             |
| new\_to\_brand\_product\_sales\_14d                    | Numeric   |             |
| total\_add\_to\_list\_14d                              | Numeric   |             |
| total\_purchases\_views\_14d                           | Numeric   |             |
| total\_prpv\_clicks\_14d                               | Numeric   |             |
| total\_new\_to\_brand\_roas\_14d                       | Numeric   |             |
| total\_add\_to\_cart\_cpa\_14d                         | Numeric   |             |
| total\_detai\_page\_view\_cpa\_14d                     | Numeric   |             |
| agency\_fee                                            | Numeric   |             |
| fee\_com\_score                                        | Numeric   |             |
| total\_prpvr\_14d                                      | Numeric   |             |
| total\_purchases\_clicks\_14d                          | Numeric   |             |
| roas\_14d                                              | Numeric   |             |
| total\_subscribe\_and\_save\_subscription\_cvr\_14d    | Numeric   |             |
| total\_ecpprpv\_14d                                    | Numeric   |             |
| total\_detail\_page\_view\_views\_14d                  | Numeric   |             |
| fee\_automotive                                        | Numeric   |             |
| fee\_cpm1\_absorbed                                    | Numeric   |             |
| total\_detail\_page\_clicks\_14d                       | Numeric   |             |
| total\_new\_to\_brand\_ecpp\_14d                       | Numeric   |             |
| total\_new\_to\_brand\_purchases\_14d                  | Numeric   |             |
| sales\_14d                                             | Numeric   |             |
| units\_sold\_14d                                       | Numeric   |             |
| total\_units\_sold\_14d                                | Numeric   |             |
| total\_detail\_page\_views\_14d                        | Numeric   |             |
| total\_roas\_14d                                       | Numeric   |             |
| fee\_double\_verify\_absorbed                          | Numeric   |             |
| total\_new\_to\_brand\_purchase\_rate\_14d             | Numeric   |             |
| measurable\_rate                                       | Numeric   |             |
| measurable\_impressions                                | Numeric   |             |
| fee\_cpm3                                              | Numeric   |             |
| total\_percent\_of\_purchases\_new\_to\_brand\_14d     | Numeric   |             |
| fee\_doubleclick\_campaign\_manager                    | Numeric   |             |
| total\_subscribe\_and\_save\_subscription\_clicks\_14d | Numeric   |             |
| total\_add\_to\_cart\_views\_14d                       | Numeric   |             |
| total\_subscribe\_and\_save\_subscription\_views\_14d  | Numeric   |             |
| total\_new\_to\_brand\_purchases\_clicks\_14d          | Numeric   |             |
| total\_add\_to\_list\_cvr\_14d                         | Numeric   |             |
| total\_prpv\_views\_14d                                | Numeric   |             |
| fee\_cpm2\_absorbed                                    | Numeric   |             |
| total\_detail\_page\_views\_cvr\_14d                   | Numeric   |             |
| fee\_automotive\_absorbed                              | Numeric   |             |
| total\_add\_to\_list\_clicks\_14d                      | Numeric   |             |
| total\_add\_to\_cart\_14d                              | Numeric   |             |
| fee\_doubleclick\_campaign\_manager\_absorbed          | Numeric   |             |
| total\_sales\_14d                                      | Numeric   |             |
| total\_prpv\_14d                                       | Numeric   |             |
| fee\_cpm2                                              | Numeric   |             |
| total\_new\_to\_brand\_units\_sold\_14d                | Numeric   |             |
| total\_subscribe\_and\_save\_subscriptions\_14d        | Numeric   |             |
| fee\_integral\_ad\_science                             | Numeric   |             |
| new\_to\_brand\_erpm\_14d                              | Numeric   |             |
| total\_new\_to\_brand\_product\_sales\_14d             | Numeric   |             |
| fee\_cpm3\_absorbed                                    | Numeric   |             |
| download\_date                                         | Date Time |             |

### Audience Report&#x20;

Table name: amazon\_source\_data.*dsp\_audience\_report*

*For details on the description, please click* [*here*](https://advertising.amazon.com/API/docs/en-us/guides/reporting/dsp/metrics)*.*

| Column Name                                     | Data type | Description |
| ----------------------------------------------- | --------- | ----------- |
| advertiserid                                    | Integer   |             |
| account\_id                                     | Integer   |             |
| account\_name                                   | String    |             |
| interval\_start                                 | Date Time |             |
| interval\_end                                   | Date Time |             |
| entity\_id                                      | String    |             |
| order\_id                                       | String    |             |
| line\_item\_id                                  | String    |             |
| segment                                         | String    |             |
| targeting\_method                               | String    |             |
| accept\_14d                                     | Numeric   |             |
| accept\_clicks\_14d                             | Numeric   |             |
| accept\_cpa\_14d                                | Numeric   |             |
| accept\_cvr\_14d                                | Numeric   |             |
| accept\_views\_14d                              | Numeric   |             |
| added\_to\_shopping\_cart\_14d                  | Numeric   |             |
| added\_to\_shopping\_cart\_clicks\_14d          | Integer   |             |
| added\_to\_shopping\_cart\_cpa\_14d             | Numeric   |             |
| added\_to\_shopping\_cart\_cvr\_14d             | Numeric   |             |
| added\_to\_shopping\_cart\_views\_14d           | Numeric   |             |
| add\_to\_watch\_list\_14d                       | Numeric   |             |
| add\_to\_watch\_list\_clicks\_14d               | Integer   |             |
| add\_to\_watch\_list\_cpa\_14d                  | Numeric   |             |
| add\_to\_watch\_list\_cvr\_14d                  | Numeric   |             |
| add\_to\_watch\_list\_views\_14d                | Numeric   |             |
| advertiser\_country                             | String    |             |
| advertiser\_timezone                            | String    |             |
| amazon\_audience\_fee                           | Numeric   |             |
| amazon\_omnichannel\_metrics\_fee               | Numeric   |             |
| amazon\_platform\_fee                           | Numeric   |             |
| application\_14d                                | Numeric   |             |
| application\_clicks\_14d                        | Integer   |             |
| application\_cpa\_14d                           | Numeric   |             |
| application\_cvr\_14d                           | Numeric   |             |
| application\_views\_14d                         | Numeric   |             |
| atc\_14d                                        | Numeric   |             |
| atc\_clicks\_14d                                | Integer   |             |
| atcr\_14d                                       | Numeric   |             |
| atc\_views\_14d                                 | Numeric   |             |
| atl\_14d                                        | Numeric   |             |
| atl\_clicks\_14d                                | Integer   |             |
| atlr\_14d                                       | Numeric   |             |
| atl\_views\_14d                                 | Numeric   |             |
| banner\_interaction\_14d                        | Numeric   |             |
| banner\_interaction\_clicks\_14d                | Integer   |             |
| banner\_interaction\_cpa\_14d                   | Numeric   |             |
| banner\_interaction\_cvr\_14d                   | Numeric   |             |
| banner\_interaction\_views\_14d                 | Numeric   |             |
| brand\_search\_14d                              | Numeric   |             |
| brand\_search\_clicks\_14d                      | Numeric   |             |
| brand\_search\_cpa\_14d                         | Numeric   |             |
| brand\_search\_rate\_14d                        | Numeric   |             |
| brand\_search\_views\_14d                       | Numeric   |             |
| brand\_store\_engagement1                       | Numeric   |             |
| brand\_store\_engagement1\_clicks               | Integer   |             |
| brand\_store\_engagement1\_cpa                  | Numeric   |             |
| brand\_store\_engagement1\_cvr                  | Numeric   |             |
| brand\_store\_engagement1\_views                | Numeric   |             |
| brand\_store\_engagement2                       | Numeric   |             |
| brand\_store\_engagement2\_clicks               | Integer   |             |
| brand\_store\_engagement2\_cpa                  | Numeric   |             |
| brand\_store\_engagement2\_cvr                  | Numeric   |             |
| brand\_store\_engagement2\_views                | Numeric   |             |
| brand\_store\_engagement3                       | Numeric   |             |
| brand\_store\_engagement3\_clicks               | Integer   |             |
| brand\_store\_engagement3\_cpa                  | Numeric   |             |
| brand\_store\_engagement3\_cvr                  | Numeric   |             |
| brand\_store\_engagement3\_views                | Numeric   |             |
| brand\_store\_engagement4                       | Numeric   |             |
| brand\_store\_engagement4\_clicks               | Integer   |             |
| brand\_store\_engagement4\_cpa                  | Numeric   |             |
| brand\_store\_engagement4\_cvr                  | Numeric   |             |
| brand\_store\_engagement4\_views                | Numeric   |             |
| brand\_store\_engagement5                       | Numeric   |             |
| brand\_store\_engagement5\_clicks               | Integer   |             |
| brand\_store\_engagement5\_cpa                  | Numeric   |             |
| brand\_store\_engagement5\_cvr                  | Numeric   |             |
| brand\_store\_engagement5\_views                | Numeric   |             |
| brand\_store\_engagement6                       | Numeric   |             |
| brand\_store\_engagement6\_clicks               | Integer   |             |
| brand\_store\_engagement6\_cpa                  | Numeric   |             |
| brand\_store\_engagement6\_cvr                  | Numeric   |             |
| brand\_store\_engagement6\_views                | Numeric   |             |
| brand\_store\_engagement7                       | Numeric   |             |
| brand\_store\_engagement7\_clicks               | Integer   |             |
| brand\_store\_engagement7\_cpa                  | Numeric   |             |
| brand\_store\_engagement7\_cvr                  | Numeric   |             |
| brand\_store\_engagement7\_views                | Numeric   |             |
| checkout\_14d                                   | Numeric   |             |
| checkout\_clicks\_14d                           | Numeric   |             |
| checkout\_cpa\_14d                              | Numeric   |             |
| checkout\_cvr\_14d                              | Numeric   |             |
| checkout\_views\_14d                            | Numeric   |             |
| click\_on\_redirect\_14d                        | Numeric   |             |
| click\_on\_redirect\_clicks\_14d                | Numeric   |             |
| click\_on\_redirect\_cpa\_14d                   | Numeric   |             |
| click\_on\_redirect\_cvr\_14d                   | Numeric   |             |
| click\_on\_redirect\_views\_14d                 | Numeric   |             |
| click\_throughs                                 | Integer   |             |
| contact\_14d                                    | Numeric   |             |
| contact\_clicks\_14d                            | Numeric   |             |
| contact\_cpa\_14d                               | Numeric   |             |
| contact\_cvr\_14d                               | Numeric   |             |
| contact\_views\_14d                             | Numeric   |             |
| ctr                                             | Numeric   |             |
| decline\_14d                                    | Numeric   |             |
| decline\_clicks\_14d                            | Integer   |             |
| decline\_cpa\_14d                               | Numeric   |             |
| decline\_cvr\_14d                               | Numeric   |             |
| decline\_views\_14d                             | Numeric   |             |
| downloaded\_video\_play\_rate\_14d              | Numeric   |             |
| downloaded\_video\_plays\_14d                   | Numeric   |             |
| downloaded\_video\_plays\_clicks\_14d           | Integer   |             |
| downloaded\_video\_plays\_views\_14d            | Numeric   |             |
| dpv\_14d                                        | Numeric   |             |
| dpv\_clicks\_14d                                | Integer   |             |
| dpvr\_14d                                       | Numeric   |             |
| dpv\_views\_14d                                 | Integer   |             |
| drop\_down\_selection\_14d                      | Numeric   |             |
| drop\_down\_selection\_clicks\_14d              | Integer   |             |
| drop\_down\_selection\_cpa\_14d                 | Numeric   |             |
| drop\_down\_selection\_cvr\_14d                 | Numeric   |             |
| drop\_down\_selection\_views\_14d               | Integer   |             |
| e\_cpa\_tc\_14d                                 | Numeric   |             |
| e\_cpa\_tl\_14d                                 | Numeric   |             |
| ecpc                                            | Numeric   |             |
| ecpdpv\_14d                                     | Numeric   |             |
| ecpdvp\_14d                                     | Numeric   |             |
| e\_cpm                                          | Numeric   |             |
| ecpnewsubscribe\_and\_save\_14d                 | Numeric   |             |
| ecpp\_14d                                       | Numeric   |             |
| ecpprpv\_14d                                    | Numeric   |             |
| ecppt\_14d                                      | Numeric   |             |
| ecpr\_14d                                       | Numeric   |             |
| ecpvc                                           | Numeric   |             |
| ecpvd\_14d                                      | Numeric   |             |
| ecpv\_s\_14d                                    | Numeric   |             |
| email\_interaction\_14d                         | Numeric   |             |
| email\_interaction\_clicks\_14d                 | Integer   |             |
| email\_interaction\_cpa\_14d                    | Numeric   |             |
| email\_interaction\_cvr\_14d                    | Numeric   |             |
| email\_interaction\_views\_14d                  | Integer   |             |
| email\_load\_14d                                | Numeric   |             |
| email\_load\_clicks\_14d                        | Integer   |             |
| email\_load\_cpa\_14d                           | Numeric   |             |
| email\_load\_cvr\_14d                           | Numeric   |             |
| email\_load\_views\_14d                         | Integer   |             |
| game\_interaction\_14d                          | Numeric   |             |
| game\_interaction\_clicks\_14d                  | Integer   |             |
| game\_interaction\_cpa\_14d                     | Numeric   |             |
| game\_interaction\_cvr\_14d                     | Numeric   |             |
| game\_interaction\_views\_14d                   | Numeric   |             |
| game\_load\_14d                                 | Numeric   |             |
| game\_load\_clicks\_14d                         | Integer   |             |
| game\_load\_cpa\_14d                            | Numeric   |             |
| game\_load\_cvr\_14d                            | Numeric   |             |
| game\_load\_views\_14d                          | Integer   |             |
| gross\_click\_throughs                          | Integer   |             |
| gross\_impressions                              | Numeric   |             |
| homepage\_visit\_14d                            | Numeric   |             |
| homepage\_visit\_clicks\_14d                    | Integer   |             |
| homepage\_visit\_cpa\_14d                       | Numeric   |             |
| homepage\_visit\_cvr\_14d                       | Numeric   |             |
| homepage\_visit\_views\_14d                     | Integer   |             |
| impressions                                     | Numeric   |             |
| invalid\_click\_throughs                        | Integer   |             |
| invalid\_click\_throughs\_rate                  | Numeric   |             |
| invalid\_impression\_rate                       | Numeric   |             |
| invalid\_impressions                            | Numeric   |             |
| lead\_14d                                       | Numeric   |             |
| lead\_clicks\_14d                               | Numeric   |             |
| lead\_cpa\_14d                                  | Numeric   |             |
| lead\_cvr\_14d                                  | Numeric   |             |
| lead\_views\_14d                                | Numeric   |             |
| marketing\_landing\_page\_14d                   | Numeric   |             |
| marketing\_landing\_page\_clicks\_14d           | Integer   |             |
| marketing\_landing\_page\_cpa\_14d              | Numeric   |             |
| marketing\_landing\_page\_cvr\_14d              | Numeric   |             |
| marketing\_landing\_page\_views\_14d            | Numeric   |             |
| mashup\_add\_to\_cart\_14d                      | Numeric   |             |
| mashup\_add\_to\_cart\_clicks\_14d              | Numeric   |             |
| mashup\_add\_to\_cart\_cpa\_14d                 | Numeric   |             |
| mashup\_add\_to\_cart\_click\_cvr\_14d          | Numeric   |             |
| mashup\_add\_to\_cart\_views\_14d               | Integer   |             |
| mashup\_add\_to\_wish\_list\_14d                | Numeric   |             |
| mashup\_add\_to\_wish\_list\_clicks\_14d        | Integer   |             |
| mashup\_add\_to\_wish\_list\_cpa\_14d           | Numeric   |             |
| mashup\_add\_to\_wish\_list\_cvr\_14d           | Numeric   |             |
| mashup\_add\_to\_wish\_list\_views\_14d         | Integer   |             |
| mashup\_backup\_image                           | Numeric   |             |
| mashup\_backup\_image\_clicks                   | Integer   |             |
| mashup\_backup\_image\_cpa                      | Numeric   |             |
| mashup\_backup\_image\_cvr                      | Numeric   |             |
| mashup\_backup\_image\_views                    | Integer   |             |
| mashup\_click\_to\_page                         | Numeric   |             |
| mashup\_click\_to\_page\_clicks                 | Integer   |             |
| mashup\_click\_to\_page\_cpa                    | Numeric   |             |
| mashup\_click\_to\_page\_cvr                    | Numeric   |             |
| mashup\_click\_to\_page\_views                  | Integer   |             |
| mashup\_clip\_coupon\_click\_14d                | Integer   |             |
| mashup\_clip\_coupon\_click\_clicks\_14d        | Integer   |             |
| mashup\_clip\_coupon\_click\_cpa\_14d           | Numeric   |             |
| mashup\_clip\_coupon\_click\_cvr\_14d           | Numeric   |             |
| mashup\_clip\_coupon\_click\_views\_14d         | Integer   |             |
| mashup\_shop\_now\_click\_14d                   | Integer   |             |
| mashup\_shop\_now\_click\_clicks\_14d           | Integer   |             |
| mashup\_shop\_now\_click\_cpa\_14d              | Numeric   |             |
| mashup\_shop\_now\_click\_cvr\_14d              | Numeric   |             |
| mashup\_shop\_now\_click\_views\_14d            | Integer   |             |
| mashup\_subscribe\_and\_save\_14d               | Numeric   |             |
| mashup\_subscribe\_and\_save\_click\_14d        | Integer   |             |
| mashup\_subscribe\_and\_save\_cpa\_14d          | Numeric   |             |
| mashup\_subscribe\_and\_save\_cvr\_14d          | Numeric   |             |
| mashup\_subscribe\_and\_save\_click\_views\_14d | Integer   |             |
| message\_sent\_14d                              | Numeric   |             |
| message\_sent\_clicks\_14d                      | Integer   |             |
| message\_sent\_cpa\_14d                         | Numeric   |             |
| message\_sent\_cvr\_14d                         | Numeric   |             |
| message\_sent\_views\_14d                       | Integer   |             |
| mobile\_app\_first\_starts\_14d                 | Numeric   |             |
| mobile\_app\_first\_start\_clicks\_14d          | Integer   |             |
| mobile\_app\_first\_starts\_cpa\_14d            | Numeric   |             |
| mobile\_app\_first\_start\_cvr\_14d             | Numeric   |             |
| mobile\_app\_first\_start\_views\_14d           | Integer   |             |
| newsubscribe\_and\_save\_14d                    | Numeric   |             |
| newsubscribe\_and\_save\_clicks\_14d            | Integer   |             |
| newsubscribe\_and\_save\_rate\_14d              | Numeric   |             |
| newsubscribe\_and\_save\_views\_14d             | Integer   |             |
| new\_to\_brand\_ecpp\_14d                       | Numeric   |             |
| new\_to\_brand\_purchase\_rate\_14d             | Numeric   |             |
| new\_to\_brand\_purchases\_14d                  | Numeric   |             |
| new\_to\_brand\_purchases\_clicks\_14d          | Integer   |             |
| new\_to\_brand\_purchases\_views\_14d           | Numeric   |             |
| other\_14d                                      | Numeric   |             |
| other\_clicks\_14d                              | Numeric   |             |
| other\_cpa\_14d                                 | Numeric   |             |
| other\_cvr\_14d                                 | Numeric   |             |
| other\_views\_14d                               | Numeric   |             |
| page\_view\_14d                                 | Numeric   |             |
| page\_view\_clicks\_14d                         | Numeric   |             |
| page\_view\_cpa\_14d                            | Numeric   |             |
| page\_view\_cvr\_14d                            | Numeric   |             |
| page\_view\_views\_14d                          | Numeric   |             |
| percent\_of\_purchases\_new\_to\_brand\_14d     | Numeric   |             |
| player\_trailers\_clicks\_14d                   | Integer   |             |
| play\_trailer\_rate\_14d                        | Numeric   |             |
| play\_trailers\_14d                             | Numeric   |             |
| play\_trailers\_views\_14d                      | Numeric   |             |
| prpv\_14d                                       | Numeric   |             |
| prpv\_clicks\_14d                               | Integer   |             |
| prpvr\_14d                                      | Numeric   |             |
| prpv\_views\_14d                                | Integer   |             |
| purchase\_button\_14d                           | Numeric   |             |
| purchase\_button\_clicks\_14d                   | Integer   |             |
| purchase\_button\_cpa\_14d                      | Numeric   |             |
| purchase\_button\_cvr\_14d                      | Numeric   |             |
| purchase\_button\_views\_14d                    | Numeric   |             |
| purchase\_rate\_14d                             | Numeric   |             |
| purchases\_14d                                  | Numeric   |             |
| purchases\_clicks\_14d                          | Integer   |             |
| purchases\_views\_14d                           | Integer   |             |
| referral\_14d                                   | Numeric   |             |
| referral\_clicks\_14d                           | Integer   |             |
| referral\_cpa\_14d                              | Numeric   |             |
| referral\_cvr\_14d                              | Numeric   |             |
| referral\_views\_14d                            | Numeric   |             |
| registration\_confirm\_page\_14d                | Numeric   |             |
| registration\_confirm\_page\_clicks\_14d        | Integer   |             |
| registration\_confirm\_page\_cpa\_14d           | Numeric   |             |
| registration\_confirm\_page\_cvr\_14d           | Numeric   |             |
| registration\_confirm\_page\_views\_14d         | Numeric   |             |
| registration\_form\_14d                         | Numeric   |             |
| registration\_form\_clicks\_14d                 | Integer   |             |
| registration\_form\_cpa\_14d                    | Numeric   |             |
| registration\_form\_cvr\_14d                    | Numeric   |             |
| registration\_form\_views\_14d                  | Integer   |             |
| rental\_rate\_14d                               | Numeric   |             |
| rentals\_14d                                    | Numeric   |             |
| rentals\_clicks\_14d                            | Integer   |             |
| rentals\_views\_14d                             | Integer   |             |
| search\_14d                                     | Numeric   |             |
| search\_clicks\_14d                             | Numeric   |             |
| search\_cpa\_14d                                | Numeric   |             |
| search\_cvr\_14d                                | Numeric   |             |
| search\_views\_14d                              | Numeric   |             |
| sign\_up\_page\_14d                             | Numeric   |             |
| sign\_up\_page\_clicks\_14d                     | Numeric   |             |
| sign\_up\_page\_cpa\_14d                        | Numeric   |             |
| sign\_up\_page\_cvr\_14d                        | Numeric   |             |
| sign\_up\_page\_views\_14d                      | Numeric   |             |
| store\_locator\_page\_14d                       | Numeric   |             |
| store\_locator\_page\_clicks\_14d               | Numeric   |             |
| store\_locator\_page\_cpa\_14d                  | Numeric   |             |
| store\_locator\_page\_cvr\_14d                  | Numeric   |             |
| store\_locator\_page\_views\_14d                | Numeric   |             |
| submit\_button\_14d                             | Numeric   |             |
| submit\_button\_clicks\_14d                     | Numeric   |             |
| submit\_button\_cpa\_14d                        | Numeric   |             |
| submit\_button\_cvr\_14d                        | Numeric   |             |
| submit\_button\_views\_14d                      | Numeric   |             |
| subscription\_button\_14d                       | Numeric   |             |
| subscription\_button\_clicks\_14d               | Numeric   |             |
| subscription\_button\_cpa\_14d                  | Numeric   |             |
| subscription\_button\_cvr\_14d                  | Numeric   |             |
| subscription\_button\_views\_14d                | Numeric   |             |
| success\_page\_14d                              | Numeric   |             |
| success\_page\_clicks\_14d                      | Numeric   |             |
| success\_page\_cpa\_14d                         | Numeric   |             |
| success\_page\_cvr\_14d                         | Numeric   |             |
| success\_page\_views\_14d                       | Numeric   |             |
| supply\_cost                                    | Numeric   |             |
| survey\_finish\_14d                             | Numeric   |             |
| survey\_finish\_clicks\_14d                     | Numeric   |             |
| survey\_finish\_cpa\_14d                        | Numeric   |             |
| survey\_finish\_cvr\_14d                        | Numeric   |             |
| survey\_finish\_views\_14d                      | Numeric   |             |
| survey\_start\_14d                              | Numeric   |             |
| survey\_start\_clicks\_14d                      | Numeric   |             |
| survey\_start\_cpa\_14d                         | Numeric   |             |
| survey\_start\_cvr\_14d                         | Numeric   |             |
| survey\_start\_views\_14d                       | Numeric   |             |
| thank\_you\_page\_14d                           | Numeric   |             |
| thank\_you\_page\_clicks\_14d                   | Numeric   |             |
| thank\_you\_page\_cpa\_14d                      | Numeric   |             |
| thank\_you\_page\_cvr\_14d                      | Numeric   |             |
| thank\_you\_page\_views\_14d                    | Numeric   |             |
| total\_cost                                     | Numeric   |             |
| video\_complete                                 | Numeric   |             |
| video\_completed                                | Numeric   |             |
| video\_completed\_cpa                           | Numeric   |             |
| video\_completed\_cvr                           | Numeric   |             |
| video\_completed\_views                         | Numeric   |             |
| video\_completion\_rate                         | Numeric   |             |
| video\_download\_rate\_14d                      | Numeric   |             |
| video\_downloads\_14d                           | Numeric   |             |
| video\_downloads\_clicks\_14d                   | Numeric   |             |
| video\_downloads\_views\_14d                    | Numeric   |             |
| video\_end\_clicks                              | Numeric   |             |
| video\_first\_quartile                          | Numeric   |             |
| video\_midpoint                                 | Numeric   |             |
| video\_mute                                     | Numeric   |             |
| video\_pause                                    | Numeric   |             |
| video\_resume                                   | Numeric   |             |
| video\_start                                    | Numeric   |             |
| video\_started                                  | Numeric   |             |
| video\_started\_clicks                          | Numeric   |             |
| video\_started\_cpa                             | Numeric   |             |
| video\_started\_cvr                             | Numeric   |             |
| video\_started\_views                           | Numeric   |             |
| video\_streams\_14d                             | Numeric   |             |
| video\_streams\_clicks\_14d                     | Numeric   |             |
| video\_streams\_rate\_14d                       | Numeric   |             |
| video\_streams\_views\_14d                      | Numeric   |             |
| video\_third\_quartile                          | Numeric   |             |
| video\_unmute                                   | Numeric   |             |
| widget\_interaction\_14d                        | Numeric   |             |
| widget\_interaction\_clicks\_14d                | Numeric   |             |
| widget\_interaction\_cpa\_14d                   | Numeric   |             |
| widget\_interaction\_cvr\_14d                   | Numeric   |             |
| widget\_interaction\_views\_14d                 | Numeric   |             |
| widget\_load\_14d                               | Numeric   |             |
| widget\_load\_clicks\_14d                       | Numeric   |             |
| widget\_load\_cpa\_14d                          | Numeric   |             |
| widget\_load\_cvr\_14d                          | Numeric   |             |
| widget\_load\_views\_14d                        | Numeric   |             |
| download\_date                                  | Date Time |             |
| line\_item\_name                                | String    |             |
| order\_name                                     | String    |             |