Learn how Singular pulls advertising cost data from Display & Video 360, how to set it up, and how to view the data in your reports.
Quick Details
Data connector technology | API (v. 2) |
Data breakdown (segmentation) | Country |
Time zone | PST |
Does the partner offer data for today? | Yes |
Is data available on the creative (ad) level? | Yes |
Does Singular pull creative assets (the actual graphics/video)? | No |
Known Limitations and Issues |
The data will appear under the source "Google Marketing Platform (DV360)". If you need it to appear under another name, contact the Singular support team. |
Basic Setup
To set up the Google Display and Video 360 (Bid Manager) data connector:
- In your Singular account, go to Settings > Data Connectors page and click New Data Connector.
- Type in "DV360".
- Click Sign in with Google and authenticate with the relevant Google account.
- Provide your Partner ID. You can find your partner ID in the DV360 dashboard under Partner Settings / Basic Details. (What is a partner ID?)
Note: Do not provide Advertiser IDs under the Partner ID field. If you need to pull data for specific Advertiser IDs, contact support.
For help, see the Data Connectors FAQ.
Getting Floodlight Activities (Conversion Events)
Note: These instructions are for Singular. If you need help with setting up Floodlight activities on Google, see their documentation.
Singular can pull any "floodlight activities" that you need from DV360 and display their stats in your singular reports.
To get floodlight activity data:
- Add a new event (see How do I add conversion events?).
-
In the DV360 dropdown, you will see a list of the floodlight activities available from DV360. You can map each activity into a separate Singular event or combine multiple floodlight activities into a single event.
The next day, when Singular pulls daily data for your account, it will pull these activities' stats as well.
- After Singular has populated the new conversion event(s) with some floodlight activity data, when you run a report in the Reports page, choose the conversion event(s) from the Events dropdown.
Data Mapping
Tip: For more information about any field in Singular reporting, see the Metrics and Dimensions Glossary.
Field Name in Singular Web UI | Field Name in Singular API & Data Destinations (ETL) | Field Name in DV360 |
Dimensions | ||
Account ID | adn_account_id | Advertiser ID |
Account Name | adn_account_name | Advertiser |
Country | country_field | Country |
Network Campaign ID | adn_campaign_id |
Insertion Order ID Note: To map "Campaign ID" instead, contact support. |
Network Campaign Name | adn_campaign_name |
Insertion Order Note: To map "Campaign" instead, contact support. |
Network Sub Campaign ID | adn_sub_campaign_id | Line Item ID |
Network Sub Campaign Name | adn_sub_campaign_name | Line Item |
Original Currency | adn_original_currency | Advertiser Currency |
Platform | platform | Device Type |
Creative ID | creative_id | Creative ID |
Creative Name | creative_name | Creative |
Metrics | ||
Network Clicks | adn_clicks | Clicks |
Network Impressions | adn_impressions | Impressions |
Network Installs | adn_installs | Total Conversions |
Original Cost | adn_original_cost | Total Media Cost (Advertiser Currency) |
Completed Video Views | completed_video_views | Complete Views (Video) |
Video Views | video_views | Starts (Video) |
Video Views 25% | video_views_25pct | First-Quartile Views (Video) |
Video Views 50% | video_views_50pct | Midpoint Views (Video) |
Video Views 75% | video_views_75pct | Third-Quartile Views (Video) |