Connect Bing Ads to Amazon S3 with Windsor.ai
+
Stream all your marketing data from Bing Ads to Amazon S3
About Bing Ads
Bing Ads (also known as Microsoft ads) is a pay per click advertising platform. It offers advertisers both the Bing and Yahoo! search engines.
About Amazon S3
Amazon S3 or Amazon Simple Store Service is offered by Amazon Web Services (AWS). It used by many web applications globally and provides scalable object storage. Sending you marketing analytics data to S3 allows data and marketing teams to join it together with other data sets already stored in S3.
First step:
You need to select Bing ads as Data Source and grant access to Windsor.ai.
Second step:
Select AMAZON S3 as a data destination.
Third Step:
Add the following information in the relevant fields :
- Amazon S3 Bucket name
- Amazon S3 Access Key
- Amazon S3 Secret Key
- Select the preferred refresh schedule 12H or 24H
- Add a Folder path to upload to, for example, Windsor-ai.(Optional)
- Add Backfill Data period(Optional)
Instruction: The list of selected fields must contain a date field.
You should also read:
Bing Ads metrics and dimensions available for streaming into Amazon S3
| Name | Type | Description |
|---|---|---|
| Account ID | TEXT | The account id |
| Account Name | TEXT | The account name |
| Account Number | TEXT | The Microsoft Advertising assigned number of an account. |
| Account Status | TEXT | The account status |
| Ad group ID | NUMERIC | The ID of the AdGroup. |
| Ad group | TEXT | The name of the AdGroup. |
| Ad Network Conversions | NUMERIC | The ad network reported conversions |
| Ad Network Revenue | NUMERIC | The ad network reported revenue |
| All Conversion Rate | NUMERIC | The conversion rate as a percentage. |
| All Conversions | NUMERIC | The number of conversions. |
| AllCostPerConversion | NUMERIC | The cost per conversion. |
| All Revenue | NUMERIC | The revenue optionally reported by the advertiser as a result of conversions. |
| All Revenue Per Conversion | NUMERIC | The revenue per conversion.The formula for calculating the revenue per conversion is (Revenue / Conversions). |
| AllReturnOnAdSpend | NUMERIC | The return on ad spend (ROAS).The formula for calculating the ROAS is (Revenue / Spend). |
| Average Cpc | NUMERIC | The average cost per click (CPC). The total cost of all clicks on an ad divided by the number of clicks. This is the average amount you're actually charged each time your ad is clicked. |
| Average Cpm | NUMERIC | The total advertising cost divided by the number of impressions (in thousands). |
| Average Position | NUMERIC | The average position of the ad on a webpage. |
| Campaign | TEXT | The campaign Name |
| Campaign ID | TEXT | The campaign ID |
| Clicks | NUMERIC | The number of clicks |
| Conversions | NUMERIC | The number of conversions |
| Date | DATE | The date |
| Device Type | TEXT | Device type |
| The Final URL of the keyword | TEXT | Only the first URL in the list is reported. If the URL contains dynamic text substitution parameters (for example, {param1}), the report will contain the URL before substitution. |
| Final Url Suffix | TEXT | A place in your final URL where you can add parameters that will be attached to the end of your landing page URL. |
| Goal | TEXT | The name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad. |
| Goal Type | TEXT | The type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url. |
| Impression Share Percent | NUMERIC | The estimated percentage of impressions, out of the total available impressions in the market you were targeting. |
| Impressions | NUMERIC | The number of impressions |
| Keyword | TEXT | The keyword. |
| Ad group ID | NUMERIC | The keyword ID. |
| Spend | NUMERIC | The media spend |
| Top Impression Rate Percent | NUMERIC | The percentage of times your ad showed in the mainline, the top placement where ads appear above the search results, out of your total impressions. |
| Total Cost | NUMERIC | The media spend (Duplicate) |
| Revenue | NUMERIC | The amount of revenue |
Windsor.ai: Easily connect Bing Ads to Amazon S3
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.