What is the significance of the 'CPM' column in a broker's Google Sheet?

The 'CPM' column indicates the cost per thousand impressions, helping you assess the cost efficiency of the inventory. However, it does not provide information on the quality of the traffic or the viewability of the ads.

How can I verify the quality of the inventory listed in the Google Sheet?

To verify inventory quality, request additional documentation such as viewability reports, fraud prevention certifications, and third-party audits. This helps ensure the traffic is genuine and meets your campaign goals.

What should I do if the broker's Google Sheet lacks transparency?

If the sheet lacks transparency, ask the broker for more detailed information. Request specifics on viewability, fraud prevention, and ad placement. If the broker is unwilling to provide this information, consider looking for alternative inventory sources.

How can I negotiate better deals with brokers using the Google Sheet?

Use the data in the Google Sheet to identify potential issues or areas for improvement. Discuss your campaign goals and how the inventory can help you achieve them. Be prepared to negotiate CPM rates and request additional services such as viewability reports or fraud prevention measures.

What a broker's Google Sheet actually tells you

A detailed guide to understanding broker Google Sheets in display advertising, covering typical columns, what they reveal about inventory quality, and red flags to watch for.

Short answer: A broker’s Google Sheet provides a snapshot of available inventory, including basic metrics like impressions, CPMs, and audience demographics. However, it may not reveal crucial details about ad placement, viewability, or fraud prevention. Always scrutinize the data for inconsistencies and ask for additional verification.

Key points

Google Sheets from brokers list basic inventory metrics but may omit critical details.
Look for transparency in data, including viewability and fraud prevention measures.
Beware of inconsistencies or unusually low CPMs, which can indicate poor quality inventory.
Request additional documentation or verification to ensure the inventory meets your standards.

Introduction to Broker Google Sheets

A broker’s Google Sheet is often the first point of contact for advertisers looking to purchase display advertising inventory. These sheets typically contain a list of available inventory, along with various metrics and details about each offering. However, understanding what these sheets reveal—and more importantly, what they hide—is crucial for making informed decisions.

Typical Columns in a Broker’s Google Sheet

Common columns in a broker’s Google Sheet include:

Inventory Name/ID: A unique identifier for the inventory.
Impressions: The number of times the ad will be displayed.
CPM (Cost Per Mille): The cost per thousand impressions.
Audience Demographics: Information about the target audience, such as age, gender, and location.
Ad Format: The type of ad (e.g., banner, video, native).

These columns provide a basic overview of the inventory, but they often lack deeper insights into quality and performance.

What These Columns Reveal

The columns in a broker’s Google Sheet give you a glimpse into the potential reach and cost of the inventory. For instance, the ‘Impressions’ column tells you how many times your ad could be displayed, while the ‘CPM’ column indicates the cost efficiency of the inventory. Audience demographics help you understand if the inventory aligns with your target market.

What These Columns Hide

While the basic metrics are useful, they often don’t reveal crucial details such as:

Viewability: The likelihood that your ad will be seen by a user.
Fraud Prevention: Measures to ensure the traffic is genuine and not from bots.
Ad Placement: Where exactly your ad will appear on the page.
Historical Performance: Past data on click-through rates and conversions.

These omissions can make it difficult to assess the true value of the inventory.

Red Flags to Watch For

When reviewing a broker’s Google Sheet, be on the lookout for the following red flags:

Inconsistencies in Data: Discrepancies between metrics can indicate poor data quality.
Unusually Low CPMs: If the cost seems too good to be true, it might be due to low-quality traffic.
Lack of Transparency: Absence of information on viewability or fraud prevention is a concern.
Generic Audience Demographics: Vague descriptions of the target audience can be a sign of poor targeting.

These issues can significantly impact the effectiveness of your ad campaign.

The Importance of Verification

To ensure the inventory meets your standards, consider requesting additional verification. This could include third-party audits, viewability reports, or fraud prevention certifications. Verification helps you confirm that the inventory is legitimate and aligns with your campaign goals.

Negotiating with Brokers

When negotiating with brokers, use the information from the Google Sheet as a starting point. Ask for clarification on any unclear metrics and request more detailed data if necessary. Be prepared to discuss your campaign goals and how the inventory can help you achieve them.

Conclusion

A broker’s Google Sheet is a valuable tool for evaluating display advertising inventory, but it should not be the only factor in your decision-making process. By understanding what the sheet reveals and what it hides, you can make more informed choices and negotiate better deals.

This article is general information for advertisers, not advice. Prices vary — check the benchmark for your vertical and format, and evaluate any placement against the framework.