MULTI_CHANNEL
or AdvertisingChannelSubType UNIVERSAL_APP_CAMPAIGN
.CAMPAIGN_PERFORMANCE_REPORT (Apr 13, 2016-Apr 19, 2016) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Budget period | Custom parameter | Currency | Account | Time zone | Active View avg. CPM | Active View viewable CTR | Active View viewable impressions | Active View measurable impr. / impr. | Active View measurable cost | Active View measurable impr. | Active View viewable impr. / measurable impr. | Network | Network (with search partners) | Advertising Sub Channel | Advertising Channel | All conv. rate | All conv. | All conv. value | Budget | Avg. Cost | Avg. CPC | Avg. CPE | Avg. CPM | Avg. CPV | Avg. position | Bid Strategy ID | Bid Strategy Name | Bid Strategy Type | Conversion optimizer bid type | Budget ID | Campaign ID | Campaign | Campaign state | Click conversion rate | Clicks | Content Lost IS (budget) | Content Impr. share | Content Lost IS (rank) | Conv. rate | Conversions | Total conv. value | Converted clicks | Cost | Cost / conv. | Cost / converted click | CTR | Client name | Day | End date | Engagement rate | Engagements | Enhanced CPC enabled | Enhanced CPV enabled | Customer ID | Gmail forwards | Gmail saves | Gmail clicks to website | Impressions | Interaction Rate | Interactions | Invalid click rate | Invalid clicks | Budget explicitly shared | Label IDs | Labels | Month | Month of Year | Phone impressions | Phone calls | PTR | Company name | Quarter | Relative CTR | Search Lost IS (budget) | Search Exact match IS | Search Impr. share | Search Lost IS (rank) | Campaign serving status | Start date | Tracking template | Value / all conv. | Value / conv. | Value / converted click | Video played to 100% | Video played to 25% | Video played to 50% | Video played to 75% | View rate | Views | View-through conv. | Week | Year | |
Total | -- | -- | -- | -- | 0 | 0.00% | 0 | 0.00% | 0 | 0 | 0.00% | -- | -- | -- | -- | 0.00% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -- | -- | -- | -- | -- | -- | -- | -- | -- | 0.00% | 0 | -- | -- | -- | 0.00% | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% | -- | -- | -- | 0.00% | 0 | -- | -- | -- | 0 | 0 | 0 | 0 | 0.00% | 0 | 0.00% | 0 | -- | -- | -- | -- | -- | 0 | 0 | 0.00% | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 | -- | -- |
SELECT Date, CampaignId, CampaignName, Cost, Impressions, Clicks, Device, ClickType , AdNetworkType1
FROM CAMPAIGN_PERFORMANCE_REPORT WHERE AdvertisingChannelSubType='UNIVERSAL_APP_CAMPAIGN' AND Impressions>0 DURING LAST 7 DAYS
SELECT Date,CampaignId,CampaignName,Cost,Impressions,Clicks,Device,ClickType,AdNetworkType1,Criteria,Id,CriteriaType,AdGroupId FROM CRITERIA_PERFORMANCE_REPORT DURING 20160811,20160811
SELECT Date,CampaignId,CampaignName,Cost,Impressions,Clicks,Device,AdNetworkType1,Criteria,Id,CriteriaType,AdGroupId FROM CRITERIA_PERFORMANCE_REPORT DURING 20160811,20160811