Skip to main content

​
Intro

Bing Ads is a service that provides pay-per-click advertising on both the Bing and Yahoo! search engines. Use Domo’s Bing Ads connector to pull Bing Ads data from marketing, sales, operations, and finance for true closed-loop reporting. This service supports a subset of the Bing Ads web application reports. The reports that you can request are grouped into the following categories.
  • Delivery Show the overall effectiveness and cost of ads and keywords for a specified period. You can include details in the reports—such as clicks, conversions, and spending—that you can use to identify the ads and keywords that are performing well and those that you may need to adjust.
  • Budget Shows your monthly budget, how much you have spent to date, and whether you are on target to spend your monthly budget.
  • Targeting Determine whether your ads are reaching their intended audiences.
  • Campaign Analytics Used to measure the effectiveness of the account’s ad campaigns, primarily in terms of return on investment. In addition, you can use the reports to learn which pages on your website are most commonly abandoned by visitors and then use this information to change the design of your website to improve conversions.
To learn more about the Bing Ads API, visit their page (https://msdn.microsoft.com/en-us/library/bing-ads-getting-started.aspx ). The Bing Ads connector is a “Cloud App” connector, meaning it retrieves data stored in the cloud. In the Data Center, you can access the connector page for this and other Cloud App connectors by clicking Cloud App in the toolbar at the top of the window. You connect to your Bing Ads account in the Data Center. This topic discusses the fields and menus that are specific to the Bing Ads connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Connector.

Primary Use Cases

Ad conversion

Primary Metrics

Ad click-thru rates

Primary Company Roles

Web marketing roles

Average Implementation Time

~1 hour

Ease of Use (on a 1-to-10 scale with 1 being easiest)

4

​
Best Practices

Use the backfill to pull in historic data. The first time the report runs, historic data will be retrieved. Subsequent runs will only pull in the date ranges specified.

​
Prerequisites

To connect to your Bing Ads account and create a DataSet, you must have the following:

​
Obtaining your Developer Token

To find your developer token:
  1. Go to https://developers.ads.microsoft.com/Account
  2. Make sure it’s a Super Admin account and that the token is a Universal token, and verify that it’s the same account that is creating the Azure portal app.
clipboard_e16d8414c35f3cdea9ef73fd020d591d2.png

​
Configuring your Azure App to obtain your Secret ID and Value

  1. Login into Azure Portal.
  2. Select Azure Active Directory > App Registrations > New Registration.
New_registration.png
  1. Fill out the registration form as follows:
  • Name: enter a meaningful application name that will be displayed to users of the app, for example, ‘DomoConnector’.
  • Supported account types: Select Accounts in any organizational directory (Any Azure AD directory – Multitenant) and personal Microsoft accounts.
  • Redirect URI: Add and save the following URI: https://oauth.domo.com/api/data/v1/oauth/providers/bingads/exchange. The authentication response is sent to this URI after successfully authenticating the user. Providing the URI at this stage is optional and it can be changed later, but a value is required for most of the authentication scenarios.
  1. Click Register to create the application. An overview of your registered App will appear.
clipboard_e182d798536c1739a92a68e5460154f73.png
  1. The Application ID that appears here is the Client ID you will enter in the Credentials pane in Domo.
clipboard_ed4d398399f9f9430f75bd609d6bdbc83.png
  1. Select Authentication under Manage. Under Implicit Grant, check the box to enable both Access Tokens and ID Tokens. Select Save at the top of the page to save the changes.
clipboard_eaa283cf721974a3f4aba17d1cc195efa.png
  1. Select API Permissions under Manage. You will need the User.Rea d and User.ReadBasic.All permissions.
  2. To add permissions, select Add a Permission. Select Microsoft Graph API, and then Delegated Permissions. Type or Navigate to User.ReadBasic.All, check the box, and click Add Permissions.
clipboard_e647c7731599144cdd8772f2f24584978.png
  1. Select Certificates & Secrets under Manage. Certificates can be used as secrets to prove the application’s identity when requesting a token. Also, can be referred to as public keys.
  2. Select the + New client secret button.
clipboard_ed1a25153bb6f42452f69844e51a34d99.png
  1. Enter a value in Description, select a suitable option for Expires, and click Add.
Add_client_secret.png
Important: Ensure to c opy the client secret Value (not the Secret ID) before leaving the page. It’s not displayed again after you leave this page.
Secret_Value_selection.png
This will be the Client Secret within Domo.
  1. Now, enter the Developer Token, Client ID, and Client Secret in Domo under the Credentials section for the Bing Ads connector, and click Connect. There will be a popup to Log in to Microsoft. Login using your Super Admin account and follow the prompts to complete the connection.

​
Debugging the Azure portal app and BingAds account

While creating your account, if you get an error “There was a problem creating your account. Please try again”, you can check the following configuration to debug your Azure portal app and BingAds account.
  1. In your Azure portal app, check the following:
  • Under Authentication -> Supported account types, select “Accounts in any organizational directory (Any Azure AD directory – Multitenant) and personal Microsoft accounts”
clipboard_ec16519b5018b601429a348c3d1d0b086.png
clipboard_e7d684428067470d26a41cec3dce46759.png
  • Under API permissions, select User.Read and User.ReadBasic.All
clipboard_e5745d4f728b4e7e3f1200218556f2ed1.png
  1. In your Developer Token which you can find at https://developers.ads.microsoft.com/Account, make sure it’s a Super Admin account and that the token is a Universal token, and verify that it’s the same account that is creating the Azure portal app.
  2. You need to create a new client secret in the app that you previously created, copy the Value of that secret, and use that to create the Bing Ads account in Domo. If that doesn’t work, create a new app and use those credentials.

​
Connecting to Your Bing Ads Account

This section enumerates the options in the Credentials and Details panes in the Bing Ads Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Connector.

​
Credentials Pane

Field Description
Developer Token Enter the developer token. To get a developer token, login to Bing Ads as a Super Admin user and click Request Token. For more help, see Bing Ads.
Client ID Go to portal.azure.com > Azure Active directory > App registrations. Find and select the web app. The Application ID from the web app is the client id.
Client Secret Value Go to portal.azure.com > Azure Active directory > App registrations. Find and select the web app. Go to Settings > Keys. Create the client secret.
This pane contains three field where you enter your Bing Ads developer token, Client ID and Client Secret Value. You are then taken to the Microsoft OAuth page where you are required to enter your Microsoft username and password. Once you have entered valid Microsoft credentials, you can use the same account any time you go to create a new Bing Ads DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector/Adapter Accounts.

​
Details Pane

This pane contains a primary Report menu, along with various other menus which may or may not appear depending on the report type you select.

Menu

Description

Report

Select the Bing Ads report you want to run. The following reports are available:

Report Name

Description

Account Performance Report

Shows the long-term account performance and trends.

Ad Dynamic Text Performance Report

Identifies the dynamic text strings that are performing well and which strings you should consider changing.

Ad Extension by Ads Report

Used to compare how well the different versions of your ad extensions are performing with each ad.

Ad Extension by Keyword Report

Used to compare how well the different versions of your ad extensions are performing for each keyword.

Ad Extension Detail Report

Used to discover the effectiveness of individual ad extension items, such as each link of a sitelink extension.

Ad Group Performance Report

Used to compare the delivery performance statistics by ad group, campaign, or account attributes, rather than at the keyword level.

Ad Performance Report

Used to determine which ads lead to clicks and conversions, and which are not performing.

Age Gender Audience Report

Used to discover how your campaigns and ad groups are resonating with audiences of diverse age and gender.

Audience Performance Report

Compares the delivery performance statistics by audience, ad group, campaign, or account attributes.

Budget Summary Report

Used to discover how your budget is performing for the month. The report shows your monthly budget, how much you have spent to date, and whether you are on target to stay within your monthly budget.

Call Detail Report

Used to discover which accounts, campaigns, or ad groups are driving the most completed phone calls.

Campaign Performance Report

Used to view high-level performance statistics and quality attributes for each campaign or account. This is also a quick way to flag any major campaign or account problems.

Conversion Performance Report

Used to discover which campaigns and keywords are leading an audience to complete a purchase or other conversion action.

Destination URL Performance Report

Used to identify landing pages that met audience expectations and potentially resulted in high click-through or conversion rates.

DSA Auto Target Performance Report

This report provides the performance data specifically for Dynamic Search Ads (DSA) auto targets.

DSA Category Performance Report

This report provides insights into how your Dynamic Search Ads (DSA) perform across different product or service categories.

DSA Search Query Performance Report

This report provides valuable insights into the specific search terms that triggered your Dynamic Search Ads (DSA) to appear.

Geographic Performance Report

This report provides insights into how your ads perform across different geographic locations.

Goals and Funnels Report

Used to discover whether your audience completes each step through the land, browse, prospect, and conversion pages of your website. For example, you can use this report to determine the step in which users leave the conversion funnel, so that you can improve or remove that step to increase the chance that the user will continue to the next step.

Hotel Dimension Performance Report

Provides in-depth insights into the performance of your hotel advertising campaigns.

Hotel Group Performance Report

Provides insights into the performance of your hotel advertising campaigns, specifically focusing on the performance of different hotel groups within your campaigns.

Keyword Performance Report

Used to discover which keywords are performing well and which are not.

Negative Keyword Conflict Report

Used to discover which keywords and negative keywords are in conflict, and whether the conflict is at the campaign or ad group level.

Publisher Usage Performance Report

Used to discover if any website URLs aren’t performing well enough for your campaign or ad group target settings. For example, if ad impressions at those URLs yield a low click-through rate, then you might decide to exclude those websites from your campaign.

Search Campaign Change History Report

Used to discover when changes to an account were made, as well as which user made the changes.

Search Query Performance Report

Used to discover what your audience is searching for when your ads are shown. You can use this information to make informed additions, removals, or edits to both your keyword and negative keyword lists.

Share of Voice Report

Used to view impression share (%) of successful bids for each keyword, and identify opportunities to increase impression share.

User Location Performance Report Used to show where your traffic is coming from broken out by the physical location and the location people are searching for.

Aggregate By

Select how data in the report is broken down. For example, Weekly breaks down data by week.

Duration

Select whether you want to pull data for a specific date or a date range.

Report Date

Select whether the report data is for a specific date or for a relative number of days back from today.

Select Specific Date

Select the date for the report.

Days Back

Enter the number of past days that should appear in the report.

Start Date

Specify whether the first date in your date range is a specific or relative date. You select the last date in your range in End Date .

End Date

Specify whether the second date in your date range is a specific or relative date. You select the first date in your range in Start Date .

Select Specific Start Date

Select the first date in your date range.

Select Specific End Date

Select the second date in your date range.

Days Back to Start From

Enter the number of the farthest day back that should be represented in the report. Combine with Days Back to End At to create a range of represented days.

For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At , the report would contain data for 10 days ago up until 5 days ago.

Days Back to End At

Enter the number of the most recent day back that should be represented in the report. Combine with Days Back to Start From to create a range of represented days.

For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At , the report would contain data for 10 days ago up until 5 days ago.

Backfill Enter the number of days before the start date that should be backfilled. This action will be performed only the first time the data source runs. On subsequent runs, the specified Start Date to End Date range is used.

​
Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Connector.

​
Troubleshooting

  • Double-check the API key.
  • Try to access the data directly from the API.

​
FAQ

As often as needed.
You need to provide the Report type, Aggregated by (daily/weekly/hourly etc.) and PastDays value (backfill) while creating a new Bing Ads dataset.
No.
Backfilling is supported in Bing Ads connector for the first attempt only. As you set the backfill value, the Bing Ads connector pulls the data for the mentioned number of days before the start date, along with the data between the specified start and end dates.