| Label | Description | Name | Type | Data Type | Tables |
|---|---|---|---|---|---|
| Account Name | The name of the account. | configName | DIMENSION | STRING |
|
| Amount Spent | The total amount you've spent during the dates you've selected, inclusive of third-party costs | spend | METRIC | NUMBER |
|
| Average Value | The average amount of money reported for conversions from clicks. | averageValue | METRIC | NUMBER |
|
| Avg. CPC | The average you paid for each action associated with your objective | ecpc | METRIC | NUMBER |
|
| Budget | The budget amount, budget type, and real time spend of your campaigns | budget | DIMENSION | NUMBER |
|
| Budget Type | budget_type | DIMENSION | STRING |
| |
| CPA | The average CPA (Cost Per Acquisition) calculated for conversions from clicks. | cpa | METRIC | NUMBER |
|
| CPC | The cost per click that is currently set for your campaign | cpc | DIMENSION | NUMBER |
|
| CTR | The average CTR (Click Through Rate). Click-through rate is a ratio showing how often people who see your content end up clicking it | ctr | METRIC | NUMBER |
|
| Campaign ID | campaign_id | DIMENSION | STRING |
| |
| Campaign Name | Name of the campaign | campaign_name | DIMENSION | STRING |
|
| Clicks | The total number of clicks on your content. When video, indicates the number of views as counted for CPV. | clicks | METRIC | NUMBER |
|
| Conversion Rate | The average rate of conversions from clicks per click. | conversionRate | METRIC | NUMBER |
|
| Conversions - Click | The number of customer actions on your website as a result of clicking on your content | conversions | METRIC | NUMBER |
|
| Conversions - View | The number of customer actions on your website as a result of viewing your content | viewConversions | METRIC | NUMBER |
|
| Conversions Value - Click | The sum of your click-through conversions values that you've chosen to include | sumValue | METRIC | NUMBER |
|
| Conversions Value - View | The sum of your view-through conversions values that you've chosen to include | viewSumValue | METRIC | NUMBER |
|
| Country Code | country_code | DIMENSION | STRING |
| |
| Country Name | country_name | DIMENSION | STRING |
| |
| Created At | created_at | DIMENSION | STRING |
| |
| Currency | currency | DIMENSION | STRING |
| |
| Data Freshness | dataFreshness | DIMENSION | STRING |
| |
| Data Source | Data source title | dataSource | DIMENSION | STRING |
|
| Data Source Logo | Data source logo | dataSourceLogo | DIMENSION | STRING |
|
| Date | The dimension that determines how date-based data in a chart is handled. | date_actual | DIMENSION | STRING |
|
| Date And Time | date | DIMENSION | STRING |
| |
| Day Of Month | The dimension that determines how date-based data in a chart is handled. | day_of_month | DIMENSION | STRING |
|
| Day Of Week | The dimension that determines how date-based data in a chart is handled. | day_of_week | DIMENSION | STRING |
|
| Destination URL | destination_url | DIMENSION | STRING |
| |
| End Date | The budget end date | endDate | DIMENSION | STRING |
|
| Hour | The dimension that determines how date-based data in a chart is handled. | hour | DIMENSION | STRING |
|
| Impressions | Number of times your content was recommended | impressions | METRIC | NUMBER |
|
| Marketer ID | marketer_id | DIMENSION | STRING |
| |
| Month | The dimension that determines how date-based data in a chart is handled. | month_only | DIMENSION | STRING |
|
| Month Day | The dimension that determines how date-based data in a chart is handled. | month_day | DIMENSION | STRING |
|
| Objective | objective | DIMENSION | STRING |
| |
| PMA Is Interpolated? | Used by Power My Analytics to indicate whether lifetime data might be interpolated | isInterpolated | BOOLEAN |
| |
| PMA Maximum Cached Data Date | Used by Power My Analytics to indicate maximum cached data date. | MaxDate | DIMENSION | STRING |
|
| PMA Minimum Cached Data Date | Used by Power My Analytics to indicate minimum cached data date. | MinDate | DIMENSION | STRING |
|
| PMA Payment URL | Used by Power My Analytics to provide URL to activate your account, or to see the billing information. | Payment | STRING |
| |
| PMA Subscription ID | Used by Power My Analytics for billing and user-identification with our support staff. | Subscription | STRING |
| |
| PMA Trial Status | Used by Power My Analytics to show trial as Active, Expired or number of days remaining. | Trial | STRING |
| |
| Platform | platform | DIMENSION | STRING |
| |
| Promoted Link Creation Time | promoted_link_creationTime | DIMENSION | STRING |
| |
| Promoted Link Description | promoted_link_description | DIMENSION | STRING |
| |
| Promoted Link ID | promoted_link_id | DIMENSION | STRING |
| |
| Promoted Link Image | promoted_link_cachedImageUrl | DIMENSION | STRING |
| |
| Promoted Link Last Modified | promoted_link_lastModified | DIMENSION | STRING |
| |
| Promoted Link Text | promoted_link_text | DIMENSION | STRING |
| |
| Promoted Link URL | promoted_link_url | DIMENSION | STRING |
| |
| Publisher ID | publisher_id | DIMENSION | STRING |
| |
| Publisher Name | publisher_name | DIMENSION | STRING |
| |
| Publisher URL | publisher_url | DIMENSION | STRING |
| |
| Quarter | The dimension that determines how date-based data in a chart is handled. | quarter | DIMENSION | STRING |
|
| ROAS | The ROAS, determined by Sum Value divided by Spend. | roas | METRIC | NUMBER |
|
| Region Code | region_code | DIMENSION | STRING |
| |
| Region Name | region_name | DIMENSION | STRING |
| |
| Start Date | The budget start date | startDate | DIMENSION | STRING |
|
| Status | status | METRIC | NUMBER |
| |
| Total Average Value | The average amount of money reported for all conversions. | totalAverageValue | METRIC | NUMBER |
|
| Total CPA | The average CPA (Cost Per Acquisition) calculated for all conversions. | totalCpa | METRIC | NUMBER |
|
| Total Conversions | The total number of actions on your website as a result of viewing and clicking on your content. This column shows the sum of all conversion events you've chosen to include | totalConversions | METRIC | NUMBER |
|
| Total Conversions Value - View & Click | The sum of your view-through and click-through conversion values that you've chosen to include | totalSumValue | METRIC | NUMBER |
|
| Total ROAS | The Total ROAS, determined by Total Sum Value divided by Spend. | total_roas | METRIC | NUMBER |
|
| Type | Campaign type differentiates between article and video campaigns | content_type | DIMENSION | STRING |
|
| Updated At | updated_at | DIMENSION | STRING |
| |
| Utm Campaign | utm_campaign | DIMENSION | STRING |
| |
| Utm Content | utm_content | DIMENSION | STRING |
| |
| Utm Medium | utm_medium | DIMENSION | STRING |
| |
| Utm Source | utm_source | DIMENSION | STRING |
| |
| Utm Term | utm_term | DIMENSION | STRING |
| |
| View Average Value | The average amount of money reported for view-through conversions. | viewAverageValue | METRIC | NUMBER |
|
| View Conversion Rate | The average rate of view-through conversions per viewable impression.. | viewConversionRate | METRIC | NUMBER |
|
| Week | The dimension that determines how date-based data in a chart is handled. | week | DIMENSION | STRING |
|
| Year | The dimension that determines how date-based data in a chart is handled. | year | DIMENSION | STRING |
|
| Year Month | The dimension that determines how date-based data in a chart is handled. | month | DIMENSION | STRING |
|
| Year Quarter | The dimension that determines how date-based data in a chart is handled. | year_quarter | DIMENSION | STRING |
|
| Year Week | The dimension that determines how date-based data in a chart is handled. | year_week | DIMENSION | STRING |
|
Preferred by data-driven businesses
BigQuery
FTP Server
Google Sheets
Looker Studio
Microsoft Excel
MySQL
Power My Analytics API
