RTB House Data Connector User Guide
Last updated
Note: RTB House is a global advertising platform that uses deep learning to power retargeting and programmatic display campaigns. With the Power My Analytics RTB House connector, you can connect your RTB House account to your Hub and choose the RTB House advertisers you want to report on. This guide covers what you need before you connect, how to add RTB House as a data source, how to create a Data Studio report, and the tables and fields you can use.
Note: RTB House is a Beta connector. It is available and supported now, and it appears in your Hub's source gallery with a BETA label. While it is in Beta, some fields and behavior may still change as we continue to improve it. We will expand this guide as the connector develops, and your feedback helps shape what comes next.
Prerequisites
Before you begin, make sure you have:
- An active RTB House account with access to the advertisers you want to report on
- API access enabled for your RTB House user. Your RTB House account representative can turn this on for you.
- Two-factor authentication turned off for the RTB House user you connect with. The RTB House API does not support two-factor authentication.
- Your RTB House username and password (the login you use for the RTB House panel). RTB House connects with your login, so there is no API key to copy. Power My Analytics stores your password encrypted.
Adding RTB House as a Data Source
- In your Power My Analytics Hub, select Sources from the menu.
- Click + Add new source and choose RTB House from the gallery.
- Enter your RTB House username and password, and an optional account name to help you identify the account, then click Connect.
RTB House checks your login when you click Connect. Once you're connected, the RTB House advertisers your login can access are available to choose from. Archived advertisers are included and labeled "(archived)", so you can still select a past client.
Creating a Data Studio Report
- In your Hub, go to Reports > Data Studio and click the orange + Create report button.
- In the Templates window, select Single sources, find RTB House, and click Open in Data Studio.
- In Data Studio, click Authorize if you are prompted, then select your Power My Analytics Hub and the RTB House account you connected.
- Click Connect (top right), then click Create report.
Key Reports and Fields
The RTB House connector provides two daily tables, one row per subcampaign per day:
- Performance: Cost, Impressions, Clicks, and conversions and conversion values under four RTB House count conventions (all conversions, attributed post-click, post-view, and all post-click), plus CTR, eCPM, eCPC, CR, eCPA, and ROAS.
- Branding: Cost, Impressions, Clicks, Completed Video Views, VCR, Viewability, plus CTR, eCPM, eCPC, and eCPCV.
For the complete list of available RTB House fields, open the RTB House Schema Explorer in your Hub.
Limitations and Important Considerations
- Backfilling: Power My Analytics backfills up to 730 days of daily history when you first connect.
- Beta connector: While RTB House is in Beta, fields, configuration options, and behavior may change. If a field is renamed or removed, you may need to update the reports that use it.
- Conversion data depends on RTB House: RTB House can hide a count convention, or some metrics, for an advertiser. The matching columns stay empty and your other columns still sync.
- Branding data depends on RTB House: RTB House decides which metrics an advertiser may read. If video and viewability metrics are not enabled for your advertiser, the Branding table has no data. Ask your RTB House account representative to enable them.
- Two-factor authentication: The RTB House user you connect with needs two-factor authentication turned off, because the RTB House API does not support it.
- Password changes: Your RTB House data source connects with your RTB House username and password. If you change that password, or API access is turned off for your RTB House user, reconnect your RTB House data source (see Disconnect and Reconnect a Source from Your Hub).
Unavailable Data
If there is an RTB House field or report you would like to see, please submit a ticket with a description or screenshot of what you need. Requests during Beta help us decide what to add next.
Troubleshooting
If your RTB House data source does not connect or behave the way you expect, start with Basic Troubleshooting. A few RTB House-specific issues are worth checking first:
- "RTB House rejected your login": The username or password is incorrect, or two-factor authentication is turned on for this RTB House user. Check your login, make sure two-factor authentication is off for the user, then connect again.
- An access error asking you to check that API access is enabled: API access is not enabled for your RTB House user. Ask your RTB House account representative to enable API access, then connect again.
- RTB House does not appear in the source gallery: RTB House is available to every Hub. Type "RTB House" in the search box under Sources > + Add new source. If it still does not appear, submit a ticket.
- Your RTB House data source stops working after a password change: Reconnect your RTB House data source with the new password.
Still have questions? Submit a ticket and our support team will be glad to help. Please include the connector name and a short description of what you are seeing; screenshots are always helpful.