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