Yahoo Gemini

Yahoo Gemini ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v3
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Yahoogemini email Yahoogemini password
Replication Type	Full based replication
Replication Key	NA
Suggested Replication Frequency	24 hrs

Tables/APIs supported
advertisers	adgroup
campaign	ad

Integrate Yahoogemini with Daton

1. Signin to Daton

2. Select Yahoogemini from Integrations page

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your email and password associated with yahoo account to authorize Daton to periodically extract data from yahoogemini.

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Yahoogemini Data

advertisers

Purpose: The AdvertiserService provides methods for retrieving advertiser data. An advertiser is an entity that manages campaigns in the Native Ad Platform API. It has settings such as contact information and billing details, and is able to manage campaigns and view reports for those campaigns. The Native ID you use to log in to Ad Manager can be associated with one or more advertisers.

Source API Documentation https://developer.verizonmedia.com/nativeandsearch/guide/advertiser.html

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
type	STRING
webSiteUrl	STRING
advertiserName	STRING
managedBy	STRING
vatId	STRING
currency	STRING
status	STRING
lastUpdatedDate	NUMERIC
bookingCountry	STRING
billingCountry	STRING
language	STRING
timezone	STRING
trackingUrl	STRING
createdDate	NUMERIC
id	NUMERIC

adgroup

Purpose:The AdGroupService provides methods for creating, updating, and retrieving ad groups. An ad group is a collection of ads and targeting objects that is associated with a particular campaign. For a campaign that runs on mobile search, ad groups will also include keywords. Ad groups help you manage different contexts within your campaign, and provide them with their own default bids, flight dates, status and targeting settings.

Source API Documentation https://developer.verizonmedia.com/nativeandsearch/guide/adgroup.html

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
status	STRING
bidset	RECORD
createdDate	NUMERIC
campaignId	NUMERIC
advertiserId	NUMERIC
startDateStr	STRING
biddingStrategy	STRING
productSetId	STRING
endDateStr	STRING
adGroupName	STRING
lastUpdateDate	NUMERIC
dpaAudienceStrategy	STRING
advancedGeoPos	STRING
advancedGeoNeg	STRING
trackingUrl	STRING
id	NUMERIC
ecpaGoal	NUMERIC
customParameters	STRING
editorialStatus	STRING

Campaigns

Purpose:The CampaignService provides methods for creating, updating, deleting and retrieving campaigns. You can also create an app install campaign if your goal is to generate app downloads.

Source API Documentation https://developer.verizonmedia.com/nativeandsearch/guide/adgroup.html

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
status	STRING
createdDate	NUMERIC
advertiserId	NUMERIC
conversionRuleIds	STRING
budgetType	STRING
budget	NUMERIC
biddingStrategy	STRING
language	STRING
lastUpdateDate	NUMERIC
objective	STRING
campaignName	STRING
advancedGeoPos	STRING
advancedGeoNeg	STRING
effectiveStatus	STRING
conversionRuleConfig	RECORD
isPartnerNetwork	STRING
subChannelModifier	STRING
trackingUrl	STRING
id	NUMERIC
customParameters	STRING
subChannel	STRING
editorialStatus	STRING
channel	STRING
isDeepLink	STRING

ads

Purpose:The AdService provides methods for adding, updating, and retrieving ads. An ad is an assembly of creatives and other ad details, like title, description, landing page URL, display URL, and more.

Source API Documentation https://developer.verizonmedia.com/nativeandsearch/guide/adgroup.html

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
description	STRING
id	NUMERIC
status	STRING
lastUpdateDate	NUMERIC
sponsoredby	STRING
campaignId	NUMERIC
adGroupId	NUMERIC
optimizeAssets	STRING
advertiserId	NUMERIC
imageUrlHQ	STRING
title	STRING
imageUrl	STRING
displayUrlPath1	STRING
displayUrlPath2	STRING
contentUrl	STRING
title2	STRING
mobileFinalUrl	STRING
finalUrl	STRING
createdDate	NUMERIC
trackingUrl	STRING
landingUrl	STRING
assets	STRING
flashSaleConfig	STRING
isAdTemplate	STRING
displayUrl	STRING
callToActionText	STRING
dpaDomain	STRING
customParameters	STRING
editorialStatus	STRING
impressionTrackingUrls	RECORD
mailAssetUrl	STRING
imageUrlThumbnail	STRING
rejectionReasons	STRING
adName	STRING