Overview
The Lyftron Provider for Bing Ads offers the most natural way to access Bing Ads data from Lyftron with ease and also enables to connect with BI, MDM & ML tools, Data warehouses, Databases and other SAAS based applications with zero code and zero infrastructure requirements. The provider wraps the complexity of accessing Bing Ads data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s Bing Ads data provider and automatically build your data migration pipelines in minutes, not months
The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.
Key Features
- Comprehensive Delta load mechanism.
- Real-time access to Bing Ads.
- Comprehensive full support of ANSI Sql to query data with ease.
- Collaborative query processing.
Prerequisites
The user must have credentials for Bing Ads, Lyftron and your destination data warehouse, lake or database to perform the data pipeline operation with Lyftron
Establishing a Connection with Lyftron's Quickstart Steps
Create your Bing Ads connection with Lyftron by following the 5 easy steps show below:
Step1. Add your connection
Click on Connect section on the left panel → Click on Add Connection button
Step2. Select your connector
In the connector selection panel, search and click Bing Ads for your connection
Step3. Enter your connection details
In the Connection String section enter the values of the below parameters. The following connection string is required to establish Bing Ads connection with Lyftron.
InitiateOAuth=GETANDREFRESH;AccountId=[your_acountid];CustomerId=[your_customerId];DeveloperToken=[your_developerToken];Key | Value | Field |
Connection Name | Enter your connection details | Required |
InitiateOAuth | GETANDREFRESH | Required |
AccountId | Your Bing Ads AccountId | Required |
CustomerId | Your Bing Ads CustomerId | Required |
DeveloperToken | Your Bing Ads DeveloperToken | Required |
Logfile** | Use the logfile option to debug your job and provide your connection name to generate the log file. [ConnectionConfigurationPath]\Connection_name_log.tx | Optional |
Verbosity** | Choose verbosity 1-5 based on the severity of debugging | Optional |
** For more information, check the Lyftron logging and debugging section.
If you want more detailed information about how to establish a connection with Lyftron, click on Lyftron Connection Quick Start guide.
Step4. Test your connection
Once you are done entering your connection details, simply click on the Test Connection button to test the connectivity. In case your connection fails, add Logfile and Verbosity parameters and check the Lyftron logging and debugging section, to debug the error.
Step5. Save your connection
Hurray! Now you have successfully connected with the Lyftron Bing Ads connector and can utilize the connector to Extract, Warehouse, Analyze, Visualize and Share your data.
Data Modal
The Lyftron Provider for Bing Ads models entities in the Bing Ads API as database views and stored procedures. These are defined in schema files, which are simple, text-based configuration files.
The following sections provide information on executing SQL to the available API objects. The provider offloads as much of the SELECT statement processing as possible to Bing Ads and then processes the rest of the query in memory; API limitations and requirements are documented in this section.
See SupportEnhancedSQL for more information on how the provider circumvents API limitations with in-memory client-side processing.
Views
The provider Bing Ads objects as Views, including reports.
You can query Reports based on an aggregation and time period. The default time period is this year; to change the time period, see the following Time Filter section.
When retrieving only some report columns, all columns marked as 'Select Requirement' and at least one of the columns marked as 'Metric' should be selected to issue a valid report request. On the other hand, if you're retrieving all columns then the driver will default to including the minimally required columns in the request.
Querying Report Aggregations
By default the report data will be aggregated by the entire specified report time, and the report will not include a time period column. Data, by default, will be retrieved only for the last month. If you want to change this behaviour see the 'Specifying a Time Filter' section below.
Additionally you can aggregate the report data by selecting one of the following aggregation columns:
-
Daily: Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. The report will include a column named Daily that contains the day formatted as yyyy-mm-dd.
SELECT Daily, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]
-
DayOfWeek: Each row of the report identifies the day of the week when the transaction occurred. The report data will be aggregated by each of the seven days in a week. The report will include a column named DayOfWeek, and the possible values are 1 - 7 where 1 represents Sunday and 7 represents Saturday.
If the report time spans multiple weeks, then the performance data across all weeks for a given day of the week will be aggregated in one row. For example if Campaign A has 5 impressions every Monday (day 2) throughout each of the 3 weeks included in the report time range, then the report will include one row with DayOfWeek set to 2 and impressions in that row totaling 15.
SELECT DayOfWeek, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]
- Hourly: Each row of the report identifies the hour when the transaction occurred. The report data will be aggregated by each hour of the day. The report will include a column named Hourly, and the possible values are 0 - 23.
SELECT Hourly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]
-
HourOfDay: Each row of the report identifies the hour of the day when the transaction occurred. The report data will be aggregated by each of the 24 hours across all days. The report will include a column named HourOfDay, and the possible values are 0 - 23.
If the report time spans multiple days, then the performance data across all days for a given hour will be aggregated in one row. For example if Campaign A has 5 impressions during hour 7 on each of the 3 days included in the report time range, then the report will include one row with impressions for HourOfDay totaling 15.
SELECT HourOfDay, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]
- Monthly:
Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named Monthly that contains the first day of the month formatted as yyyy-mm-dd.
SELECT Monthly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]
- Weekly:
Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named Weekly that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
SELECT Weekly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]
- Yearly:
Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Yearly that contains the year formatted as yyyy.
SELECT Yearly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]
Specifying a Time Filter
You can specify a custom date range or specify a predefined date range.
- To search on a predefined date range, set the DatePreset pseudo column in the WHERE clause to one of the following values: Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, or LastYear. The default DatePreset value is "ThisYear".
SELECT Monthly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ] WHERE DatePreset =
'LastYear'
- To specify a custom date range, specify the StartDate and EndDate pseudo columns in the WHERE clause.
SELECT Monthly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ] WHERE StartDate =
'2014-01-01'
AND EndDate =
'2017-09-19'
Name | Type | Description |
AccountPerformanceReport | Views | Use this report to observe long-term account performance and trends. |
Accounts | Views | Query the available Accounts in Bing Ads. |
AdDynamicTextPerformanceReport | Views | Use this report to identify which dynamic text strings are performing well and which strings you should consider changing. |
AdExtensionByAdReport | Views | Use this report to compare how well different versions of your ad extensions are performing with each ad. |
AdExtensionByKeywordReport | Views | Use this report to compare how well different versions of your ad extensions are performing for each keyword. |
AdExtensionDetailReport | Views | Use this report to discover the effectiveness of individual ad extension items, for example, each link of a sitelink extension. |
AdGroupPerformanceReport | Views | Use this report to more broadly compare delivery performance statistics by ad group, campaign, or account attributes rather than at the keyword level. |
AdGroups | Views | Query the available AdGroups in Bing Ads. |
AdPerformanceReport | Views | Use this report to help you determine which ads lead to clicks and conversions, and which are not performing. Having underperforming ads in your account can pull down the quality of your campaigns. |
Ads | Views | Query the available Ads in Bing Ads. |
AgeGenderAudienceReport | Views | Use this report to discover how your campaigns and ad groups are resonating with audiences of diverse age and gender. |
AudiencePerformanceReport | Views | Use this report to compare delivery performance statistics by audience, ad group, campaign, or account attributes. |
Audiences | Views | Query the available Audiences in Bing Ads. |
BidOpportunities | Views | Query the available Bid Opportunities in Bing Ads. |
BudgetOpportunities | Views | Query the available Budget Opportunities in Bing Ads. |
Budgets | Views | Query the available Budgets in Bing Ads. |
BudgetSummaryReport | Views | Use this report to discover how your campaign's budget is performing for the month. For example, the report shows your monthly budget, how much you have spent to date, and whether you are on target to spend your monthly budget. |
CampaignPerformanceReport | Views | Use this report 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. |
Campaigns | Views | Query the available Campaigns in Bing Ads. |
ConversionPerformanceReport | Views | Use this report to understand which campaigns and keywords are leading an audience to complete a purchase or other conversion action. |
DestinationUrlPerformanceReport | Views | Use this report to identify landing pages that met audience expectations and potentially resulted in high click-through or conversion rates. |
DSAAutoTargetPerformanceReport | Views | Use this report to find out which DSA auto targets are performing well and those that are not. |
DSACategoryPerformanceReport | Views | Use this report to find out which DSA categories are performing well and those that are not. |
DSASearchQueryPerformanceReport | Views | Use this report to find out which search terms are in demand for your DSA campaign and the performance of dynamic headlines that are being displayed. |
GeographicPerformanceReport | Views | Use this report to see which locations your traffic is coming from. You can then validate whether your location targeting strategy is successful, and identify opportunities to improve. The report also identifies either the physical location of the search user or the geographical location interest based on the user's search query. |
GoalsAndFunnelsReport | Views | Use this report 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 that 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. |
KeywordDemographics | Views | Query the available Keyword Demographics in Bing Ads. |
KeywordEstimatedBid | Views | Query the available Keyword Estimated Bid in Bing Ads. |
KeywordEstimatedPosition | Views | Query the available EstimatedPosition in Bing Ads. |
KeywordHistoricalSearch | Views | Query the available Keyword Historical Search in Bing Ads. |
KeywordLocations | Views | Query the available Keyword Locations in Bing Ads. |
KeywordPerformance | Views | Query the available Keyword Performance in Bing Ads. |
KeywordPerformanceReport | Views | Use this report to find out which keywords are performing well and those that are not. |
Keywords | Views | Query the available Keywords in Bing Ads. |
NegativeKeywordConflictReport | Views | Use this report to discover which keywords and negative keywords are in conflict, and whether the conflict is at the campaign or ad group level. Use this list to figure out which negative keywords to delete. |
ProductDimensionPerformanceReport | Views | Use this report to find out which product dimensions are performing well and those that are not. |
ProductNegativeKeywordConflictReport | Views | Use this report to discover which keywords and negative keywords are in conflict, and whether the conflict is at the campaign or ad group level. Use this list to figure out which negative keywords to delete. |
ProductPartitionPerformanceReport | Views | You can include details in the report such as impressions, clicks, and spend that you can use to identify whether or not the product partitions are performing well. |
ProductPartitionUnitPerformanceReport | Views | Use this report to find out which product partition units are performing well and those that are not. |
ProductSearchQueryPerformanceReport | Views | Use this report to get insight into what your audience is searching for when your ads are shown as well as ensure that your product titles are relevant to search queries. |
PublisherUsagePerformanceReport | Views | Use this report to see 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. |
SearchCampaignChangeHistoryReport | Views | Use this report to discover when changes to an account were made, as well as which user made the changes. |
SearchQueryPerformanceReport | Views | Use this report to see 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. |
ShareOfVoiceReport | Views | Use this report to view impression share (%) of successful bids for each keyword, and identify opportunities to increase impression share. |
Tags | Views | Query the available Tags in Bing Ads. |
UserLocationPerformanceReport | Views | Use this report to see which locations your traffic is coming from. You can then validate whether your location targeting strategy is successful, and identify opportunities to improve. The report also identifies the physical location of the user and the intended geographical location of the user's search query, for example a user in Seattle searching for services in Portland. |
Advanced Settings
To view a detailed advanced settings options, go to Bing Ads Advanced Settings. Complete list of the parameters you can configure in the connection string can be found by clicking Connection String Parameters.