Welcome to the seventh tutorial in our series about Google DoubleClick for Publishers. DFP is a service that can seem incredibly complicated to the uninitiated, so our series has aimed to simplify it (while possibly annoying a few Google product managers for pointing out its numerous UX missteps).
In this tutorial, I'll guide you through Google DFP's Query and Reporting options, exploring the differences between queries and reports and the various ways to gather data about the performance of your web advertising.
For consistency, the DFP team has made these look as complicated and confusing as other parts of the DFP interface, but if you study them for a while, queries and reports become fairly simple to use.
If you're new to this series, please review our earlier episodes before continuing: Introduction to Google DFP Small Business, Beginning Ad Integration With Your Website, Placements, and Placing Orders.
I do try to participate in the discussions below. If you have a question or topic suggestion for a future episode, please post a comment below or contact me on Twitter @reifman.
Before I began writing about this topic, I wanted to see how Google describes the differences between queries and reports and immediately was confronted with yet another example of the complexity of the system, its terminology, and its sometimes redundant help system:
Essentially queries and reports are the same thing. However, when you want to run just a quick, one-off ad-hoc report, you can use the Reports menu. When you want to create something that will run repeatedly, it's not a Report that recurs (Dear Google UX team, that would be simpler), it's a query.
Also, the I'M DONE button seems to be both a button and a checkbox. This is odd. If we could get by without ad revenue, I'm sure a lot of us would check and click a button entitled "I'M DONE WITH DFP."
More amusingly, the description above isn't enough. There's actually a "full article about the difference between a query and a report" which takes you to a new page with just a few extra sentences for each (note to Google, JavaScript links are great for expanding small sections of content):
Queries are like templates for reports. When you create a query, you essentially set up the criteria for a report to be run. When you run a query, the output is a report. Queries are recommended when you want to pull the same type of data again in the future, particularly when you select a rolling date range, for example, "Last 7 days".
To easily find the last report you've generated from a specific query, view the queries list page, and you'll see a column for "Most recent report run". Queries can be set up to run automatically on a schedule.
The benefits of queries include:
Reports can be run ad hoc, without being generated from a saved query. If you run reports in this way, it could prove to be more useful when data is needed for one-time use, for example, troubleshooting. When you see the reports list page, the "Query" column displays the query that generated the report. For reports that were run ad hoc, this column shows blank.
Here are Google DFP's Report (and Query) types:
At the top left of the DFP Reports menu, there is a Yield Report. You can generate this with two different approaches:
Here's the Yield Type as one example over just a month:
And, here's an Aggregated Demand Channel report over two years:
The default System Queries are built into DFP and can be very helpful. Unfortunately, the description column is empty and wasted:
You can find the missing description fields for System Queries here.
When you hover over a query, DFP shows you more details about its configurable input options:
Here are a few obviously useful system queries:
Before you create your own query from scratch, I recommend experimenting with running and editing one of these System Queries to your liking. Let's do this first.
On the Queries page, click New Query. You can name the query and begin a broad array of open-ended configuration options for what you want. In this case, I wanted to create a Historical report for two years of my network's performance showing the basics: impressions, CPM, CPC, etc.
The report configuration is very detailed. Here are the report metrics you can choose:
And the final area allows you to set up recurring reports. Click edit beside Generate Report:
And you can choose the frequency of recurrence and select an email address and report file format:
Here's my first view of the report, which I can save or export into various file formats:
If you want to create a report yourself, visit the Reports menu and click New Report. Then you can fully configure new reports with all of DFP's rich set of options:
For this I asked for a historical report over the last week showing lifetime clicks and impressions as well as CTR, CPM and CTC.
DFP allows you to Preview reports, which can be quite useful in seeing how your customization is coming together:
If you visit the Reports menu, you'll see a list of reports and when they were created. Recurring reports will appear here as well.
You can easily share reports with your colleagues by clicking the Share button on individual reports and providing an email address:
People who are not registered in DFP only receive an attachment of the report; they do not have access to the DFP user interface.
Google doesn't allow sorting within its reporting interface, saying, "Generally the idea is that most developers prefer the report in a basic format like CSV so they can import and manipulate it themselves as they wish."
It's pretty easy to export reports when you're creating them to send file exports on a report generation schedule, or to do it one time from the Reports list or Report results:
The file types and destinations for exported reports are as follows:
Here's what my report looked like in Google Drive:
If you've been following along with the series, I hope you're beginning to feel more proficient with the basics of DFP. It's not easy to dive into. Queries and reports are also more complicated than they should be.
Its System Queries make reporting quite simple once you get to used to the user interface. The recurrence, sharing and export are quite powerful as well.
While I've noticed that the folks at Google have tried to improve their help and documentation, they really need to redesign a lot of the system and update their terminology. It's not helpful to have to repeatedly leave a web application and dig through long technical explanations.
As the series evolves, I'd love to hear more of your feedback about DFP topics you'd like me to explore. Please feel free to post your questions and comments below. You can also contact me on Twitter @reifman. To see other tutorials I've written, browse my Envato Tuts+ instructor page.
In the next episode, we'll explore selling directly to advertisers and placing their orders for your ad units and placements within Google DFP.
New Course: Practical React Fundamentals
/20 WordPress Video Plugins and Players to Add Engagement
/Preview Our New Course on Angular Material
/Build Your Own CAPTCHA and Contact Form in PHP
/Object-Oriented PHP With Classes and Objects
/Best Practices for ARIA Implementation
/Accessible Apps: Barriers to Access and Getting Started With Accessibility
Dramatically Speed Up Your React Front-End App Using Lazy Loading
/15 Best Modern JavaScript Admin Templates for React, Angular, and Vue.js
/15 Best Modern JavaScript Admin Templates for React, Angular and Vue.js
/10 Best WordPress Facebook Widgets
13Hands-on With ARIA: Accessibility for eCommerce
/New eBooks Available for Subscribers
/Hands-on With ARIA: Homepage Elements and Standard Navigation
/20 Best WordPress Calendar Plugins and Widgets
/How Secure Are Your JavaScript Open-Source Dependencies?
/New Course: Secure Your WordPress Site With SSL
/Testing Components in React Using Jest: The Basics
/15 Best PHP Event Calendar and Booking Scripts
/Set Up Routing in PHP Applications Using the Symfony Routing Component
1 /How to Build Complex, Large-Scale Vue.js Apps With Vuex
1 /Creating Stylish and Responsive Progress Bars Using ProgressBar.js
/Set Up an OAuth2 Server Using Passport in Laravel
/Getting Started With Redux: Connecting Redux With React
/Getting Started With Redux: Learn by Example
/Introduction to API Calls With React and Axios
/Introduction to Popmotion: Custom Animation Scrubber
/Introduction to Popmotion: Pointers and Physics
/New Course: Connect to a Database With Laravel’s Eloquent ORM
/How to Make a Real-Time Sports Application Using Node.js
/How to Create a Custom Settings Panel in WooCommerce
/How Laravel Broadcasting Works
/Getting Started With Redux: Why Redux?
/Building the DOM faster: speculative parsing, async, defer and preload
1 /20 Useful PHP Scripts Available on CodeCanyon
3 /Single-Page React Applications With the React-Router and React-Transition-Group Modules
/12 Best Contact Form PHP Scripts
1 /Getting Started With the Mojs Animation Library: The ShapeSwirl and Stagger Modules
/Getting Started With the Mojs Animation Library: The Shape Module
Getting Started With the Mojs Animation Library: The HTML Module
/Project Management Considerations for Your WordPress Project
/Introduction to the CSS Grid Layout With Examples
18 Things That Make Jest the Best React Testing Framework
/Creating an Image Editor Using CamanJS: Layers, Blend Modes, and Events
/New Short Course: Code a Front-End App With GraphQL and React
/Creating an Image Editor Using CamanJS: Applying Basic Filters
/Creating an Image Editor Using CamanJS: Creating Custom Filters and Blend Modes
/Modern Web Scraping With BeautifulSoup and Selenium
/Challenge: Create a To-Do List in React
1 /Deploy PHP Web Applications Using Laravel Forge
/Getting Started With the Mojs Animation Library: The Burst Module
/A Gentle Introduction to Higher-Order Components in React: Best Practices
/Challenge: Build a React Component
/Eloquent Mutators and Accessors in Laravel
1 /A Gentle Introduction to Higher-Order Components in React
/Understanding Recursion With JavaScript
/Creating a Blogging App Using Angular & MongoDB: Delete Post
/Creating a Blogging App Using Angular & MongoDB: Edit Post
/Creating a Blogging App Using Angular & MongoDB: Add Post
/Introduction to Mocking in Python
/Creating a Blogging App Using Angular & MongoDB: Show Post
/Creating a Blogging App Using Angular & MongoDB: Home
/Creating Your First Angular App: Implement Routing
/Persisted WordPress Admin Notices: Part 4
/Creating Your First Angular App: Components, Part 2
/Persisted WordPress Admin Notices: Part 3
/Creating Your First Angular App: Components, Part 1
/Persisted WordPress Admin Notices: Part 2
/Creating Your First Angular App: Basics
/Persisted WordPress Admin Notices: Part 1
/Error and Performance Monitoring for Web & Mobile Apps Using Raygun
/Using Luxon for Date and Time in JavaScript
7 /How to Create an Audio Oscillator With the Web Audio API
/How to Cache Using Redis in Django Applications
/20 Essential WordPress Utilities to Manage Your Site
/Beginner’s Guide to Angular 4: HTTP
/Rapid Web Deployment for Laravel With GitHub, Linode, and RunCloud.io
/Beginners Guide to Angular 4: Routing
/Beginner’s Guide to Angular 4: Services
/Beginner’s Guide to Angular 4: Components
/Creating a Drop-Down Menu for Mobile Pages
/Introduction to Forms in Angular 4: Writing Custom Form Validators
/10 Best WordPress Booking & Reservation Plugins
/How to Download Files in Python
/10 Best HTML5 Sliders for Images and Text
/Site Authentication in Node.js: User Signup
/Creating a Task Manager App Using Ionic: Part 2
/Creating a Task Manager App Using Ionic: Part 1
/Introduction to Forms in Angular 4: Template-Driven Forms
/Get Rid of Bugs Quickly Using BugReplay
/Manipulating HTML5 Canvas Using Konva: Part 1, Getting Started
10 Must-See Easy Digital Downloads Extensions for Your WordPress Site
/Understanding ExpressJS Routing
/Inheritance and Extending Objects With JavaScript
/Performant Animations Using KUTE.js: Part 5, Easing Functions and Attributes
/Performant Animations Using KUTE.js: Part 4, Animating Text
/Performant Animations Using KUTE.js: Part 3, Animating SVG
/Performant Animations Using KUTE.js: Part 2, Animating CSS Properties
Performant Animations Using KUTE.js: Part 1, Getting Started
/Single-Page Applications With ngRoute and ngAnimate in AngularJS
/Working With Tables in React, Part Two
/How to Set Up a Scalable, E-Commerce-Ready WordPress Site Using ClusterCS
/Build Web Applications Using Node.js
/New Course on WordPress Conditional Tags
/TypeScript for Beginners, Part 5: Generics
/TypeScript for Beginners, Part 4: Classes
/Building With Vue.js 2 and Firebase
6Best Unique Bootstrap JavaScript Plugins
/Essential JavaScript Libraries and Frameworks You Should Know About
Vue.js Crash Course: Create a Simple Blog Using Vue.js
/Build a React App With a Laravel Back End: Part 2, React
/Build a React App With a Laravel RESTful Back End: Part 1, Laravel 5.5 API
/Bulk Import a CSV File Into MongoDB Using Mongoose With Node.js
/API Authentication With Node.js
/Command Line Basics and Useful Tricks With the Terminal
/Learn Computer Science With JavaScript: Part 3, Loops
/Learn Computer Science With JavaScript: Part 4, Functions
/Learn Computer Science With JavaScript: Part 2, Conditionals
Learn Computer Science With JavaScript: Part 1, The Basics
/Create Interactive Charts Using Plotly.js, Part 5: Pie and Gauge Charts
Create Interactive Charts Using Plotly.js, Part 4: Bubble and Dot Charts
/Create Interactive Charts Using Plotly.js, Part 3: Bar Charts
/Create Interactive Charts Using Plotly.js, Part 2: Line Charts
/Create Interactive Charts Using Plotly.js, Part 1: Getting Started
/Getting Started With End-to-End Testing in Angular Using Protractor
/Testing Components in Angular Using Jasmine: Part 2, Services
/Testing Components in Angular Using Jasmine: Part 1
/Creating a Blogging App Using React, Part 6: Tags
/React Crash Course for Beginners, Part 3
/React Crash Course for Beginners, Part 2
/React Crash Course for Beginners, Part 1
/Set Up a React Environment, Part 4
1 /Set Up a React Environment, Part 3
/Set Up a React Environment, Part 1
/Creating a Blogging App Using React, Part 5: Profile Page
/Pagination in CodeIgniter: The Complete Guide
/JavaScript-Based Animations Using Anime.js, Part 4: Callbacks, Easings, and SVG
/JavaScript-Based Animations Using Anime.js, Part 3: Values, Timeline, and Playback
/JavaScript-Based Animations Using Anime.js, Part 2: Parameters
JavaScript-Based Animations Using Anime.js, Part 1: Targets and Properties
/20 Popular WordPress User Interface Elements
/10 Elegant CSS Pricing Tables for Your Latest Web Project
/Getting Started With the Flux Architecture in React
/Getting Started With Matter.js: The Composites and Composite Modules
/Getting Started With Matter.js: The Engine and World Modules
/Getting Started With Matter.js: Introduction
/10 More Popular HTML5 Projects for You to Use and Study
/Iterating Fast With Django & Heroku
/Creating a Blogging App Using React, Part 4: Update & Delete Posts
/Creating a jQuery Plugin for Long Shadow Design
/How to Register & Use Laravel Service Providers
2 /Unit Testing in React: Shallow vs. Static Testing
/Creating a Blogging App Using React, Part 3: Add & Display Post
/Creating a Blogging App Using React, Part 2: User Sign-Up
20 /Creating a Blogging App Using React, Part 1: User Sign-In
/Creating a Grocery List Manager Using Angular, Part 2: Managing Items
/Using Celery With Django for Background Task Processing
/Dynamic Page Templates in WordPress, Part 3
/Creating a Grocery List Manager Using Angular, Part 1: Add & Display Items
/New Course: How to Hack Your Own App
/What Is a JavaScript Operator?
/Building Your Startup: Approaching Major Feature Enhancements
How to Define State With Angular UI-Router
/Dynamic Page Templates in WordPress, Part 2
/Dynamic Page Templates in WordPress, Part 1
1Building Your Startup: Securing an API
/How to Draw Bar Charts Using JavaScript and HTML5 Canvas
/Programming With Yii2: Building Community With Voting, Comments, and Sharing
/How to Work With Session Data in CodeIgniter
/12 Best Tab & Accordion WordPress Widgets & Plugins
1 /How to Use the jQuery Function to Select Elements
/How to Create Animations in AngularJS With ngAnimate
/AngularJS Form Validation With ngMessages
/15 Best PHP Calendar, Booking & Events Scripts
/Building Your Startup: Using Routes for Schedule With Me
/A Quick Guide to Dependency Management With Bower
/Getting Started With Chart.js: Scales
/New Short Course: React State Management With MobX
/Building Your Startup: Leveraging Bootstrap, Ajax, and jQuery
/How to Create a Laravel Helper
/Getting Started With Chart.js: Pie, Doughnut, and Bubble Charts
Getting Started With Chart.js: Radar and Polar Area Charts
/Getting Started With Chart.js: Line and Bar Charts
/How to Handle Errors & Exceptions in the Yii Framework
/Getting Started With Chart.js: Introduction
3 /Building Your Startup With PHP: Bootstrap Your Home Page
/How to Build a User Tour With Shepherd in JavaScript
/Building With the Twitter API: Analyzing Your Followers
/Programming With Yii2: Building a RESTful API
/New Course: How to Use the Google Maps API
/Uploading With Rails and Carrierwave
/Making a Sliding Side Navigation Menu for Responsive Designs
/Building With the Twitter API: Creating Friends to Follow
/Building Your Startup: Running Multiple Domains
/Using the Requests Module in Python
5 /Acuity Scheduling Developer Platform: OAuth, Webhooks, and Reporting
/Decoding the Proxy Class in OpenCart
/Acuity Scheduling: Embedding and Developer Integration
1 /Custom Controllers in OpenCart 2
/Building Your Startup: Error Logging
/Acuity Scheduling’s Developer-Friendly Scheduling Service
/New Short Course: Essential Gulp Tasks
/Add a Website Calendar Using Jalendar 2
/Using the New York Times API to Scrape Metadata
1Make Creating Websites Fun Again With Hugo
/Using Illuminate Database With Eloquent in Your PHP App Without Laravel
New Coffee Break Course: How to Use the Angular 2 HTTP Service
/Get Started Building Your Blog With Parse.js: Migration to Your Own Parse Server
/Adding Custom Fields to Simple Products With WooCommerce
/Using Namespaces and Autoloading in WordPress Plugins, Part 4
New Code eBooks Available for Subscribers
/Understanding Forms and Events in React
/Integrate External Libraries in OpenCart Using Composer
1 /How to Build an Angular 2 Service
7 /Programming With Yii2: Using the Debugger
/20 Best CSS Animations on CodeCanyon
/Creating a Custom WordPress Messaging System, Part 4
/Building Your First Web Scraper, Part 3
/
Cathleen Wonderful, what a website it is! This…
Sharyn Ѕimply a smiling ѵisitant heгe to…
shelby What's up it's me, I am also visiting…
Lottie I read this paragraph completely…