+
Stream all your data from Yahoo Japan to Snowflake
About Yahoo Japan
About SnowFlake
Connect Yahoo Japan to Snowflake
It is very simple to connect Yahoo Japan to Snowflake, it can be done in a fast and easy manner with Windsor.ai.
First Step
Follow the Tutorial Below:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
- Get the username
- Get the password
- Get the account
- Get the warehouse
- Get the database
- Get the schema
- Get the table name
Second step
1.You need to select Yahoo Japan as a Data Source and Grant Access to Windsor.ai.
2. In Select Destination select Snowflake as destination
3.Enter all the credentials required and click Save
4. Your data will now be streamed from Yahoo Japan to Snowflake. In case there is an error you will be notified.
Yahoo Japan metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| Absolute Top Impression Percentage (Search Ads) | NUMERIC | Search absolute top impression rate. Available in Search Ads account only. |
| Account Id (Search + Display Ads) | TEXT | Account ID. Available in Search Ads and Display Ads account. |
| Account Name (Search + Display Ads) | TEXT | Account Name. Available in Search Ads and Display Ads account. |
| Ad Distribution Settings (Search Ads) | TEXT | Distribution Settings. Available in Search Ads account only. |
| Ad Editorial Status (Search Ads) | TEXT | Editorial Status. Available in Search Ads account only. |
| Ad Id (Search + Display Ads) | TEXT | Ad ID. Available in Search Ads and Display Ads account. |
| Ad Keyword Id (Search Ads) | TEXT | Keyword ID. Available in Search Ads account only. |
| Ad Label (Display Ads) | TEXT | Ad label. Available in Display Ads account only. |
| Ad Label Id (Display Ads) | TEXT | Ad label ID. Available in Display Ads account only. |
| Ad Label Ids Json (Display Ads) | TEXT | Ad label IDs (JSON). Available in Display Ads account only. |
| Ad Labels (Display Ads) | TEXT | Ad labels. Available in Display Ads account only. |
| Ad Labels Json (Display Ads) | TEXT | Ad labels (JSON). Available in Display Ads account only. |
| Ad Layout (Display Ads) | TEXT | Layout. Available in Display Ads account only. |
| Ad Name (Search + Display Ads) | TEXT | Ad Name. Available in Search Ads and Display Ads account. |
| Ad Title (Display Ads) | TEXT | Title. Available in Display Ads account only. |
| Ad Tracking Id (Search Ads) | TEXT | Ad tracking ID. Available in Search Ads account only. |
| Ad Type (Search + Display Ads) | TEXT | Ad Type. Available in Search Ads and Display Ads account. |
| Ad Type Prev (Display Ads) | TEXT | Ad type (prev). Available in Display Ads account only. |
| Ad User Status (Display Ads) | TEXT | Ad delivery settings. Available in Display Ads account only. |
| Adgroup Bid (Search Ads) | TEXT | Ad group bid. Available in Search Ads account only. |
| Adgroup Distribution Settings (Search Ads) | TEXT | Distribution Settings. Available in Search Ads account only. |
| Adgroup Id (Search + Display Ads) | TEXT | Ad group ID. Available in Search Ads and Display Ads account. |
| Adgroup Label (Display Ads) | TEXT | Ad group label. Available in Display Ads account only. |
| Adgroup Label Id (Display Ads) | TEXT | Ad group label ID. Available in Display Ads account only. |
| Adgroup Label Ids Json (Display Ads) | TEXT | Ad group label IDs (JSON). Available in Display Ads account only. |
| Adgroup Labels (Display Ads) | TEXT | Ad group labels. Available in Display Ads account only. |
| Adgroup Labels Json (Display Ads) | TEXT | Ad group labels (JSON). Available in Display Ads account only. |
| Adgroup Name (Search + Display Ads) | TEXT | Ad group name. Available in Search Ads and Display Ads account. |
| Adgroup Tracking Id (Search Ads) | TEXT | Ad group tracking ID. Available in Search Ads account only. |
| Adgroup User Status (Display Ads) | TEXT | Ad group delivery settings. Available in Display Ads account only. |
| Age (Display Ads) | TEXT | Age. Available in Display Ads account only. |
| All Conv (Search + Display Ads) | NUMERIC | Conversions (all). Available in Search Ads and Display Ads account. |
| All Conv Rate (Search + Display Ads) | NUMERIC | Conv. rate (all). Available in Search Ads and Display Ads account. |
| All Conv Value (Search + Display Ads) | NUMERIC | Conv. value (all). Available in Search Ads and Display Ads account. |
| All Conv Value Per Cost (Search + Display Ads) | NUMERIC | Conv. value (all)/cost. Available in Search Ads and Display Ads account. |
| App Id (Display Ads) | TEXT | App ID/Package name. Available in Display Ads account only. |
| App Name (Display Ads) | TEXT | App Name. Available in Display Ads account only. |
| App Os (Display Ads) | TEXT | App OS. Available in Display Ads account only. |
| Appli (Display Ads) | TEXT | Web/App. Available in Display Ads account only. |
| Asset Callout (Search Ads) | TEXT | Callout text. Available in Search Ads account only. |
| Asset Description1 (Search Ads) | TEXT | Asset (description1). Available in Search Ads account only. |
| Asset Description2 (Search Ads) | TEXT | Asset (description2). Available in Search Ads account only. |
| Asset Description3 (Search Ads) | TEXT | Asset (description3). Available in Search Ads account only. |
| Asset Description4 (Search Ads) | TEXT | Asset (description4). Available in Search Ads account only. |
| Asset End Date (Search Ads) | DATE | End Date. Available in Search Ads account only. |
| Asset Entity Type (Search Ads) | TEXT | Ad display option type. Available in Search Ads account only. |
| Asset Id (Search Ads) | TEXT | Ad display option ID. Available in Search Ads account only. |
| Asset Phone Number (Search Ads) | TEXT | Phone Number. Available in Search Ads account only. |
| Asset Start Date (Search Ads) | DATE | Start Date. Available in Search Ads account only. |
| Asset Text (Search Ads) | TEXT | Asset. Available in Search Ads account only. |
| Asset Title1 (Search Ads) | TEXT | Asset (title1). Available in Search Ads account only. |
| Asset Title10 (Search Ads) | TEXT | Asset (title10). Available in Search Ads account only. |
| Asset Title11 (Search Ads) | TEXT | Asset (title11). Available in Search Ads account only. |
| Asset Title12 (Search Ads) | TEXT | Asset (title12). Available in Search Ads account only. |
| Asset Title13 (Search Ads) | TEXT | Asset (title13). Available in Search Ads account only. |
| Asset Title14 (Search Ads) | TEXT | Asset (title14). Available in Search Ads account only. |
| Asset Title15 (Search Ads) | TEXT | Asset (title15). Available in Search Ads account only. |
| Asset Title2 (Search Ads) | TEXT | Asset (title2). Available in Search Ads account only. |
| Asset Title3 (Search Ads) | TEXT | Asset (title3). Available in Search Ads account only. |
| Asset Title4 (Search Ads) | TEXT | Asset (title4). Available in Search Ads account only. |
| Asset Title5 (Search Ads) | TEXT | Asset (title5). Available in Search Ads account only. |
| Asset Title6 (Search Ads) | TEXT | Asset (title6). Available in Search Ads account only. |
| Asset Title7 (Search Ads) | TEXT | Asset (title7). Available in Search Ads account only. |
| Asset Title8 (Search Ads) | TEXT | Asset (title8). Available in Search Ads account only. |
| Asset Title9 (Search Ads) | TEXT | Asset (title9). Available in Search Ads account only. |
| Asset Tracking Id (Search Ads) | TEXT | Ad Display Option Tracking ID. Available in Search Ads account only. |
| Asset Type (Search Ads) | TEXT | Asset type. Available in Search Ads account only. |
| Attribute Values (Search Ads) | TEXT | Ad Display Option Detail. Available in Search Ads account only. |
| Attribute Values Json (Search Ads) | TEXT | Ad Display Option Detail (JSON). Available in Search Ads account only. |
| Audience Category (Display Ads) | TEXT | Audience category. Available in Display Ads account only. |
| Audience Category Type (Display Ads) | TEXT | Audience category type. Available in Display Ads account only. |
| Audience List Id (Display Ads) | TEXT | Audience list ID. Available in Display Ads account only. |
| Audience List Name (Display Ads) | TEXT | Audience list name. Available in Display Ads account only. |
| Audience List Type (Display Ads) | TEXT | Audience list type. Available in Display Ads account only. |
| Avg Cpc (Search + Display Ads) | NUMERIC | Avg. CPC. Available in Search Ads and Display Ads account. |
| Avg Cpm (Display Ads) | NUMERIC | Avg. CPM. Available in Display Ads account only. |
| Avg Cpv (Display Ads) | NUMERIC | Avg. CPV. Available in Display Ads account only. |
| Avg Deliver Rank (Display Ads) | NUMERIC | Avg. position. Available in Display Ads account only. |
| Avg Duration Video Viewed (Display Ads) | NUMERIC | Avg. duration of video viewed. Available in Display Ads account only. |
| Avg Frequency (Display Ads) | NUMERIC | Average frequency. Available in Display Ads account only. |
| Avg Percent Video Viewed (Display Ads) | NUMERIC | Avg. video view rate. Available in Display Ads account only. |
| Avg Vcpm (Display Ads) | NUMERIC | Avg. vCPM. Available in Display Ads account only. |
| Bid (Search Ads) | TEXT | Bid (JPY). Available in Search Ads account only. |
| Bid Automation (Search Ads) | TEXT | Bidding Adjustment Method (Target position in search results). Available in Search Ads account only. |
| Bid Modifier Attachment Level (Search Ads) | TEXT | Level. Available in Search Ads account only. |
| Bid Multiplier (Search Ads) | TEXT | Bid Adjustment. Available in Search Ads account only. |
| Bid Multiplier Of Target Page Location (Search Ads) | TEXT | Bidding Adjustment (Target position in search results). Available in Search Ads account only. |
| Bid Strategy Id (Search Ads) | TEXT | Portfolio bidding ID. Available in Search Ads account only. |
| Bid Strategy Name (Search Ads) | TEXT | Portfolio bidding name. Available in Search Ads account only. |
| Bid Strategy Type (Search Ads) | TEXT | Bid strategy. Available in Search Ads account only. |
| Budget Lost Impression Share (Search Ads) | NUMERIC | Lost impression share (budget). Available in Search Ads account only. |
| Callout (Search Ads) | TEXT | Callout text. Available in Search Ads account only. |
| Campaign Name (Search + Display Ads) (Duplicate of campaign_name) | TEXT | Campaign name. Available in Search Ads and Display Ads account. |
| Campaign Buying Type (Display Ads) | TEXT | Campaign buying type. Available in Display Ads account only. |
| Campaign Count (Search Ads) | NUMERIC | Campaigns. Available in Search Ads account only. |
| Campaign Distribution Settings (Search Ads) | TEXT | Distribution Settings. Available in Search Ads account only. |
| Campaign Distribution Status (Search Ads) | TEXT | Distribution Status. Available in Search Ads account only. |
| Campaign End Date (Search Ads) | DATE | End Date. Available in Search Ads account only. |
| Campaign Goals (Display Ads) | TEXT | Campaign goals. Available in Display Ads account only. |
| Campaign Id (Search + Display Ads) | TEXT | CampaignID. Available in Search Ads and Display Ads account. |
| Campaign Label (Display Ads) | TEXT | Campaign label. Available in Display Ads account only. |
| Campaign Label Id (Display Ads) | TEXT | Campaign label ID. Available in Display Ads account only. |
| Campaign Label Ids Json (Display Ads) | TEXT | Campaign label IDs (JSON). Available in Display Ads account only. |
| Campaign Labels (Display Ads) | TEXT | Campaign labels. Available in Display Ads account only. |
| Campaign Labels Json (Display Ads) | TEXT | Campaign labels (JSON). Available in Display Ads account only. |
| Campaign Lifetime Budget (Display Ads) | NUMERIC | Lifetime budget. Available in Display Ads account only. |
| Campaign Name (Search + Display Ads) | TEXT | Campaign name. Available in Search Ads and Display Ads account. |
| Campaign Start Date (Search Ads) | DATE | Start Date. Available in Search Ads account only. |
| Campaign Tracking Id (Search Ads) | TEXT | Campaign tracking ID. Available in Search Ads account only. |
| Campaign Type (Search + Display Ads) | TEXT | Campaign type. Available in Search Ads and Display Ads account. |
| Campaign User Status (Display Ads) | TEXT | Campaign delivery settings. Available in Display Ads account only. |
| Carrier (Display Ads) | TEXT | Carrier. Available in Display Ads account only. |
| City (Search Ads) | CITY | City. Available in Search Ads account only. |
| City Id (Display Ads) | TEXT | City ID. Available in Display Ads account only. |
| City Name (Display Ads) | CITY | City. Available in Display Ads account only. |
| Click (Display Ads) | NUMERIC | Clicks. Available in Display Ads account only. |
| Click And Video Conversions For Conversion Path (Display Ads) | NUMERIC | Conversions. Available in Display Ads account only. |
| Click Conversions For Conversion Path (Display Ads) | NUMERIC | Conversions (via click). Available in Display Ads account only. |
| Click Rate (Search + Display Ads) | PERCENT | CTR. Available in Search Ads and Display Ads account. |
| Click Type (Search Ads) | TEXT | ClickType. Available in Search Ads account only. |
| Clicks (Search Ads) | NUMERIC | Clicks. Available in Search Ads account only. |
| Content Keyword (Display Ads) | TEXT | Content keyword. Available in Display Ads account only. |
| Content Keyword Id (Display Ads) | TEXT | Content keyword ID. Available in Display Ads account only. |
| Content Keyword List Id (Display Ads) | TEXT | Content keyword list ID. Available in Display Ads account only. |
| Content Keyword List Name (Display Ads) | TEXT | Content keyword list name. Available in Display Ads account only. |
| Conv Rate (Search + Display Ads) | NUMERIC | Conv. rate. Available in Search Ads and Display Ads account. |
| Conv Value (Search + Display Ads) | NUMERIC | Conv. value. Available in Search Ads and Display Ads account. |
| Conv Value For Conversion Path (Display Ads) | NUMERIC | Conv. value (incl. view-through). Available in Display Ads account only. |
| Conv Value Per Cost (Search + Display Ads) | NUMERIC | Conv. value/cost. Available in Search Ads and Display Ads account. |
| Conv Value Via Ad Click (Display Ads) | NUMERIC | Conv. value (via click). Available in Display Ads account only. |
| Conv Value Via Ad Click Per Cost (Display Ads) | NUMERIC | Conv. value (via click)/cost. Available in Display Ads account only. |
| Conv Value Via View Through (Display Ads) | NUMERIC | View-through conversions. Available in Display Ads account only. |
| Conversion Category (Display Ads) | TEXT | Objective of Conversion Tracking. Available in Display Ads account only. |
| Conversion Group Id (Display Ads) | TEXT | Conversion group ID. Available in Display Ads account only. |
| Conversion Group Name (Display Ads) | TEXT | Conversion group name. Available in Display Ads account only. |
| Conversion Id (Display Ads) | TEXT | Conversion ID. Available in Display Ads account only. |
| Conversion Name (Search + Display Ads) | TEXT | Conversion name. Available in Search Ads and Display Ads account. |
| Conversion Rate Via Ad Click (Display Ads) | NUMERIC | Conv. rate (via click). Available in Display Ads account only. |
| Conversions (Search + Display Ads) | NUMERIC | Conversions. Available in Search Ads and Display Ads account. |
| Conversions For Conversion Path (Display Ads) | NUMERIC | Conversions (incl. view-through). Available in Display Ads account only. |
| Conversions Via Ad Click (Display Ads) | NUMERIC | Conversions (via click). Available in Display Ads account only. |
| Cost (Search + Display Ads) | NUMERIC | Cost. Available in Search Ads and Display Ads account. |
| Cost Per All Conv (Search + Display Ads) | NUMERIC | Cost/conv. (all). Available in Search Ads and Display Ads account. |
| Cost Per Conv (Search + Display Ads) | NUMERIC | Cost/conv.. Available in Search Ads and Display Ads account. |
| Cost Per Conv Via Ad Click (Display Ads) | NUMERIC | Cost/conv. (via click). Available in Display Ads account only. |
| Country Territory (Search Ads) | COUNTRY | Country. Available in Search Ads account only. |
| Creative Quality Score (Search Ads) | TEXT | Ad relevance. Available in Search Ads account only. |
| Criterion Id (Search Ads) | NUMERIC | Target page ID. Available in Search Ads account only. |
| Criterion Tracking Id (Search Ads) | TEXT | Target page tracking ID. Available in Search Ads account only. |
| Cross Device Conversions (Search + Display Ads) | NUMERIC | Cross-device conv.. Available in Search Ads and Display Ads account. |
| Custom Parameters (Search Ads) | TEXT | Custom parameter. Available in Search Ads account only. |
| Custom Url (Search Ads) | TEXT | Custom URL. Available in Search Ads account only. |
| Daily Spending Limit (Search Ads) | TEXT | Daily Spending Limit. Available in Search Ads account only. |
| Date | DATE | The Date |
| Day (Search + Display Ads) | TEXT | Day. Available in Search Ads and Display Ads account. |
| Day Of Week (Search Ads) | TEXT | Day of the week. Available in Search Ads account only. |
| Deliver (Display Ads) | TEXT | Ad Distribution. Available in Display Ads account only. |
| Deliver Url (Display Ads) | TEXT | Ad Delivery URL. Available in Display Ads account only. |
| Description1 (Search + Display Ads) | TEXT | Description 1. Available in Search Ads and Display Ads account. |
| Description2 (Search + Display Ads) | TEXT | Description 2. Available in Search Ads and Display Ads account. |
| Destination Url (Search Ads) | TEXT | Destination URL. Available in Search Ads account only. |
| Destination Url Campaign Banner (Display Ads) | TEXT | Destination URL (campaign banner). Available in Display Ads account only. |
| Device (Search + Display Ads) | TEXT | Device. Available in Search Ads and Display Ads account. |
| Device Preference (Search Ads) | TEXT | Focus Device. Available in Search Ads account only. |
| Device Type (Search Ads) | TEXT | Device. Available in Search Ads account only. |
| Directory1 (Search Ads) | TEXT | Directory1. Available in Search Ads account only. |
| Directory2 (Search Ads) | TEXT | Directory2. Available in Search Ads account only. |
| Display Url (Search + Display Ads) | TEXT | Display URL. Available in Search Ads and Display Ads account. |
| Editorial Status (Search Ads) | TEXT | Editorial Status. Available in Search Ads account only. |
| End Date (Display Ads) | DATE | End date. Available in Display Ads account only. |
| Enhanced Cpc Enabled (Search Ads) | TEXT | Enhanced CPC. Available in Search Ads account only. |
| Exact Match Impression Share (Search Ads) | NUMERIC | Exact match impression share. Available in Search Ads account only. |
| Expanded Landing Page Url (Search Ads) | TEXT | Expanded Landing Page URL. Available in Search Ads account only. |
| Feed Id (Search Ads) | TEXT | Feed ID. Available in Search Ads account only. |
| Feed Item Attributes (Search Ads) | TEXT | Data Assignment List. Available in Search Ads account only. |
| Feed Item End Date (Search Ads) | DATE | End Date. Available in Search Ads account only. |
| Feed Item Id (Search Ads) | TEXT | Ad display option ID. Available in Search Ads account only. |
| Feed Item Start Date (Search Ads) | DATE | Start Date. Available in Search Ads account only. |
| Feed Item Tracking Id (Search Ads) | TEXT | Ad Display Option Tracking ID. Available in Search Ads account only. |
| Final Url (Search + Display Ads) | TEXT | Final URL. Available in Search Ads and Display Ads account. |
| Final Url Smartphone (Search Ads) | TEXT | Smartphone final URL. Available in Search Ads account only. |
| First Page Bid Estimate (Search Ads) | TEXT | First page bid estimate. Available in Search Ads account only. |
| Gender (Display Ads) | TEXT | Gender. Available in Display Ads account only. |
| Generated Title (Search Ads) | TEXT | Title auto created. Available in Search Ads account only. |
| Historical Creative Quality Score (Search Ads) | TEXT | Ad relevance (hist.). Available in Search Ads account only. |
| Historical Landing Page Quality Score (Search Ads) | TEXT | Landing page experience (hist.). Available in Search Ads account only. |
| Historical Quality Score (Search Ads) | NUMERIC | Quality index (hist.). Available in Search Ads account only. |
| Historical Search Predicted Ctr (Search Ads) | TEXT | Expected CTR (hist.). Available in Search Ads account only. |
| Hour (Display Ads) | TEXT | Hourly. Available in Display Ads account only. |
| Hour Of Day (Search Ads) | NUMERIC | Hour of day. Available in Search Ads account only. |
| Image Option (Display Ads) | TEXT | Dynamic Image Extensions. Available in Display Ads account only. |
| Impression Share (Search + Display Ads) | NUMERIC | Impression share. Available in Search Ads and Display Ads account. |
| Impression Share Budget Loss (Display Ads) | NUMERIC | Lost impression share (budget). Available in Display Ads account only. |
| Impression Share Rank Loss (Display Ads) | NUMERIC | Lost impression share (rank). Available in Display Ads account only. |
| Measured Imps (Display Ads) (Duplicate of measured_imps) | NUMERIC | Measured impressions. Available in Display Ads account only. |
| Imps (Search + Display Ads) | NUMERIC | Impressions. Available in Search Ads and Display Ads account. |
| Interaction At Touchpoint 1 (Display Ads) | TEXT | Interaction At Touchpoint1. Available in Display Ads account only. |
| Interaction At Touchpoint 10 (Display Ads) | TEXT | Interaction At Touchpoint10. Available in Display Ads account only. |
| Interaction At Touchpoint 11 (Display Ads) | TEXT | Interaction At Touchpoint11. Available in Display Ads account only. |
| Interaction At Touchpoint 12 (Display Ads) | TEXT | Interaction At Touchpoint12. Available in Display Ads account only. |
| Interaction At Touchpoint 13 (Display Ads) | TEXT | Interaction At Touchpoint13. Available in Display Ads account only. |
| Interaction At Touchpoint 14 (Display Ads) | TEXT | Interaction At Touchpoint14. Available in Display Ads account only. |
| Interaction At Touchpoint 15 (Display Ads) | TEXT | Interaction At Touchpoint15. Available in Display Ads account only. |
| Interaction At Touchpoint 16 (Display Ads) | TEXT | Interaction At Touchpoint16. Available in Display Ads account only. |
| Interaction At Touchpoint 17 (Display Ads) | TEXT | Interaction At Touchpoint17. Available in Display Ads account only. |
| Interaction At Touchpoint 18 (Display Ads) | TEXT | Interaction At Touchpoint18. Available in Display Ads account only. |
| Interaction At Touchpoint 19 (Display Ads) | TEXT | Interaction At Touchpoint19. Available in Display Ads account only. |
| Interaction At Touchpoint 2 (Display Ads) | TEXT | Interaction At Touchpoint2. Available in Display Ads account only. |
| Interaction At Touchpoint 20 (Display Ads) | TEXT | Interaction At Touchpoint20. Available in Display Ads account only. |
| Interaction At Touchpoint 3 (Display Ads) | TEXT | Interaction At Touchpoint3. Available in Display Ads account only. |
| Interaction At Touchpoint 4 (Display Ads) | TEXT | Interaction At Touchpoint4. Available in Display Ads account only. |
| Interaction At Touchpoint 5 (Display Ads) | TEXT | Interaction At Touchpoint5. Available in Display Ads account only. |
| Interaction At Touchpoint 6 (Display Ads) | TEXT | Interaction At Touchpoint6. Available in Display Ads account only. |
| Interaction At Touchpoint 7 (Display Ads) | TEXT | Interaction At Touchpoint7. Available in Display Ads account only. |
| Interaction At Touchpoint 8 (Display Ads) | TEXT | Interaction At Touchpoint8. Available in Display Ads account only. |
| Interaction At Touchpoint 9 (Display Ads) | TEXT | Interaction At Touchpoint9. Available in Display Ads account only. |
| Invalid Click Rate (Search Ads) | PERCENT | Invalid Click Rate. Available in Search Ads account only. |
| Invalid Clicks (Search Ads) | NUMERIC | Invalid clicks. Available in Search Ads account only. |
| Is Self Action (Search Ads) | TEXT | Is Self Action. Available in Search Ads account only. |
| Keyword (Search Ads) | TEXT | Keyword. Available in Search Ads account only. |
| Keyword Distribution Settings (Search Ads) | TEXT | Distribution Settings. Available in Search Ads account only. |
| Keyword Editorial Status (Search Ads) | TEXT | Editorial Status. Available in Search Ads account only. |
| Keyword Id (Search Ads) | NUMERIC | Keyword ID. Available in Search Ads account only. |
| Keyword Match Type (Search Ads) | TEXT | Match Type. Available in Search Ads account only. |
| Keyword Targeting Match Type (Search Ads) | TEXT | Target Keyword Match Type. Available in Search Ads account only. |
| Keyword Targeting Text (Search Ads) | TEXT | Target Keyword. Available in Search Ads account only. |
| Keyword Tracking Id (Search Ads) | TEXT | Keyword tracking ID. Available in Search Ads account only. |
| Labels (Search Ads) | TEXT | Label. Available in Search Ads account only. |
| Labels Json (Search Ads) | TEXT | Labels(JSON). Available in Search Ads account only. |
| Landing Page Url (Search Ads) | TEXT | Landing Page URL. Available in Search Ads account only. |
| Limited Budgets (Search Ads) | TEXT | Limit by Campaign Budget (Target position in search results). Available in Search Ads account only. |
| Location Type (Search Ads) | TEXT | Location Type. Available in Search Ads account only. |
| Low Quality Keywords (Search Ads) | TEXT | Low Quality Keyword (Target position in search results). Available in Search Ads account only. |
| Lower Bid Limit Of Target Cpa (Search Ads) | TEXT | Lower Bid Limit (Target CPA). Available in Search Ads account only. |
| Lower Bid Limit Of Target Roas (Search Ads) | TEXT | Lower Bid Limit (Target ROAS). Available in Search Ads account only. |
| Main Media Format (Display Ads) | TEXT | Main media format. Available in Display Ads account only. |
| Material Viewable Click Rate (Display Ads) | NUMERIC | Viewable CTR per panel. Available in Display Ads account only. |
| Material Viewable Imps (Display Ads) | NUMERIC | Viewable impressions per panel. Available in Display Ads account only. |
| Measured Impression Avg Frequency (Display Ads) | NUMERIC | Average frequency (measured impression). Available in Display Ads account only. |
| Measured Impression Reaches (Display Ads) | NUMERIC | Reaches (measured impression). Available in Display Ads account only. |
| Measured Imps (Display Ads) | NUMERIC | Measured impressions. Available in Display Ads account only. |
| Measured Imps Rate (Display Ads) | NUMERIC | Measured impression rate. Available in Display Ads account only. |
| Media Ad Format (Display Ads) | TEXT | Pixel Size. Available in Display Ads account only. |
| Media File Name (Display Ads) | TEXT | File Name. Available in Display Ads account only. |
| Media Id (Display Ads) | TEXT | Media ID. Available in Display Ads account only. |
| Media Name (Display Ads) | TEXT | Media Name. Available in Display Ads account only. |
| Metro Area (Search Ads) | TEXT | Metro Area. Available in Search Ads account only. |
| Month (Search + Display Ads) | TEXT | Month. Available in Search Ads and Display Ads account. |
| Month Of Year (Search Ads) | TEXT | Month of Year. Available in Search Ads account only. |
| Most Specific Location (Search Ads) | TEXT | Location. Available in Search Ads account only. |
| Negative Keyword (Search Ads) | TEXT | Negative Keywords. Available in Search Ads account only. |
| Network (Search Ads) | TEXT | Show ads on. Available in Search Ads account only. |
| Object Of Conversion Tracking (Search Ads) | TEXT | Conversion Tracking Purpose. Available in Search Ads account only. |
| Os (Display Ads) | TEXT | OS. Available in Display Ads account only. |
| Package Name (Display Ads) | TEXT | Package name. Available in Display Ads account only. |
| Paid Video View Rate (Display Ads) | NUMERIC | Paid video view rate (CPV). Available in Display Ads account only. |
| Paid Video Views (Display Ads) | NUMERIC | Paid video views (CPV). Available in Display Ads account only. |
| Performance (Search Ads) | TEXT | Performance rating. Available in Search Ads account only. |
| Phone Number (Search Ads) | TEXT | Phone Number. Available in Search Ads account only. |
| Pinned Field (Search Ads) | TEXT | Position pinning. Available in Search Ads account only. |
| Placeholder Type (Search Ads) | TEXT | Ad display option type. Available in Search Ads account only. |
| Placement List Id (Display Ads) | TEXT | Placement list ID. Available in Display Ads account only. |
| Placement List Name (Display Ads) | TEXT | Placement list name. Available in Display Ads account only. |
| Post Click Quality Score (Search Ads) | TEXT | Landing page experience. Available in Search Ads account only. |
| Pref Id (Display Ads) | TEXT | Prefecture ID. Available in Display Ads account only. |
| Pref Name (Display Ads) | TEXT | Prefectures. Available in Display Ads account only. |
| Prefecture (Search Ads) | TEXT | Prefecture. Available in Search Ads account only. |
| Quality Index (Search Ads) | TEXT | Quality index. Available in Search Ads account only. |
| Quality Lost Impression Share (Search Ads) | NUMERIC | Lost impression share (rank). Available in Search Ads account only. |
| Quarter (Search Ads) | TEXT | Quarter. Available in Search Ads account only. |
| Query Targeting Status (Search Ads) | TEXT | Keyword / Negative Keyword. Available in Search Ads account only. |
| Quick Link Text (Search Ads) | TEXT | QuickLink text. Available in Search Ads account only. |
| Quick Link Url (Search Ads) | TEXT | QuickLink URL. Available in Search Ads account only. |
| Radius Distance (Display Ads) | TEXT | Distance from target location. Available in Display Ads account only. |
| Radius Target (Display Ads) | TEXT | Target radius. Available in Display Ads account only. |
| Reaches (Display Ads) | NUMERIC | Reaches. Available in Display Ads account only. |
| Responsive Ads Type (Display Ads) | TEXT | Responsive ads type. Available in Display Ads account only. |
| Search Absolute Top Impression Share (Search Ads) | NUMERIC | Search absolute top impression share. Available in Search Ads account only. |
| Search Budget Lost Absolute Top Impression Share (Search Ads) | NUMERIC | Search absolute top impression share (budget). Available in Search Ads account only. |
| Search Budget Lost Top Impression Share (Search Ads) | NUMERIC | Search top impression share (budget). Available in Search Ads account only. |
| Search Keyword List Id (Display Ads) | TEXT | Search keyword list ID. Available in Display Ads account only. |
| Search Keyword List Name (Display Ads) | TEXT | Search keyword list name. Available in Display Ads account only. |
| Search Predicted Ctr (Search Ads) | TEXT | Expected CTR. Available in Search Ads account only. |
| Search Query (Search Ads) | TEXT | Search Query. Available in Search Ads account only. |
| Search Query Match Type (Search Ads) | TEXT | SearchQueryMatch Type. Available in Search Ads account only. |
| Search Rank Lost Absolute Top Impression Share (Search Ads) | NUMERIC | Search absolute top lost impression share (rank). Available in Search Ads account only. |
| Search Rank Lost Top Impression Share (Search Ads) | NUMERIC | Search top lost impression share (rank). Available in Search Ads account only. |
| Search Top Impression Share (Search Ads) | NUMERIC | Search top impression share. Available in Search Ads account only. |
| Searchkeyword (Display Ads) | TEXT | Search Keyword. Available in Display Ads account only. |
| Searchkeyword Id (Display Ads) | TEXT | Search Keyword ID. Available in Display Ads account only. |
| Site Category (Display Ads) | TEXT | Site Category. Available in Display Ads account only. |
| Sitelink Asset Line1 (Search Ads) | TEXT | QuickLink Description 1. Available in Search Ads account only. |
| Sitelink Asset Line2 (Search Ads) | TEXT | QuickLink Description 2. Available in Search Ads account only. |
| Sitelink Feed Item Line1 (Search Ads) | TEXT | QuickLink Description 1. Available in Search Ads account only. |
| Sitelink Feed Item Line2 (Search Ads) | TEXT | QuickLink Description 2. Available in Search Ads account only. |
| Sitelink Text (Search Ads) | TEXT | QuickLink text. Available in Search Ads account only. |
| Special Product Type (Display Ads) | TEXT | Campaign delivery type. Available in Display Ads account only. |
| Start Date (Display Ads) | DATE | Start date. Available in Display Ads account only. |
| Structured Snippet Asset Header (Search Ads) | TEXT | Category. Available in Search Ads account only. |
| Structured Snippet Asset Values (Search Ads) | TEXT | Text. Available in Search Ads account only. |
| System Serving Status (Search Ads) | TEXT | Keyword status. Available in Search Ads account only. |
| Target Cpa (Search Ads) | NUMERIC | Target CPA. Available in Search Ads account only. |
| Target List Id (Search Ads) | TEXT | Target List ID. Available in Search Ads account only. |
| Target List Name (Search Ads) | TEXT | Target List Name. Available in Search Ads account only. |
| Target List Status (Search Ads) | TEXT | Reach Status. Available in Search Ads account only. |
| Target List Tracking Id (Search Ads) | TEXT | Target List Tracking ID. Available in Search Ads account only. |
| Target Location Id (Search Ads) | TEXT | Target Location ID. Available in Search Ads account only. |
| Target Location Name (Search Ads) | TEXT | Target Location. Available in Search Ads account only. |
| Target Location Restriction (Search Ads) | TEXT | Target Location Restriction. Available in Search Ads account only. |
| Target Roas (Search Ads) | NUMERIC | Target ROAS. Available in Search Ads account only. |
| Target Schedule (Search Ads) | TEXT | Day of week/hours. Available in Search Ads account only. |
| Target Schedule Id (Search Ads) | TEXT | Target Schedule ID. Available in Search Ads account only. |
| Target Search Page Location (Search Ads) | TEXT | Ad Position (Target position in search results). Available in Search Ads account only. |
| Targeting Adgroup Id (Search Ads) | TEXT | Target Ad Group ID. Available in Search Ads account only. |
| Targeting Campaign Id (Search Ads) | TEXT | Target Campaign ID. Available in Search Ads account only. |
| Title1 (Search Ads) | TEXT | Title1. Available in Search Ads account only. |
| Title2 (Search Ads) | TEXT | Title2. Available in Search Ads account only. |
| Title3 (Search Ads) | TEXT | Title3. Available in Search Ads account only. |
| Top Impression Percentage (Search Ads) | NUMERIC | Search top impression rate. Available in Search Ads account only. |
| Top Of Page Bid Estimate (Search Ads) | TEXT | Top of page bid estimate. Available in Search Ads account only. |
| Cost (Search + Display Ads) (Duplicate of cost) | NUMERIC | Cost. Available in Search Ads and Display Ads account. |
| Touchpoint 1 (Display Ads) | TEXT | Campaign for touchpoint 1. Available in Display Ads account only. |
| Touchpoint 10 (Display Ads) | TEXT | Campaign for touchpoint 10. Available in Display Ads account only. |
| Touchpoint 10 Account (Display Ads) | TEXT | Account for touchpoint 10. Available in Display Ads account only. |
| Touchpoint 10 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 10. Available in Display Ads account only. |
| Touchpoint 10 Interactions (Display Ads) | TEXT | Touchpoint 10 Interactions. Available in Display Ads account only. |
| Touchpoint 11 (Display Ads) | TEXT | Campaign for touchpoint 11. Available in Display Ads account only. |
| Touchpoint 11 Account (Display Ads) | TEXT | Account for touchpoint 11. Available in Display Ads account only. |
| Touchpoint 11 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 11. Available in Display Ads account only. |
| Touchpoint 11 Interactions (Display Ads) | TEXT | Touchpoint 11 Interactions. Available in Display Ads account only. |
| Touchpoint 12 (Display Ads) | TEXT | Campaign for touchpoint 12. Available in Display Ads account only. |
| Touchpoint 12 Account (Display Ads) | TEXT | Account for touchpoint 12. Available in Display Ads account only. |
| Touchpoint 12 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 12. Available in Display Ads account only. |
| Touchpoint 12 Interactions (Display Ads) | TEXT | Touchpoint 12 Interactions. Available in Display Ads account only. |
| Touchpoint 13 (Display Ads) | TEXT | Campaign for touchpoint 13. Available in Display Ads account only. |
| Touchpoint 13 Account (Display Ads) | TEXT | Account for touchpoint 13. Available in Display Ads account only. |
| Touchpoint 13 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 13. Available in Display Ads account only. |
| Touchpoint 13 Interactions (Display Ads) | TEXT | Touchpoint 13 Interactions. Available in Display Ads account only. |
| Touchpoint 14 (Display Ads) | TEXT | Campaign for touchpoint 14. Available in Display Ads account only. |
| Touchpoint 14 Account (Display Ads) | TEXT | Account for touchpoint 14. Available in Display Ads account only. |
| Touchpoint 14 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 14. Available in Display Ads account only. |
| Touchpoint 14 Interactions (Display Ads) | TEXT | Touchpoint 14 Interactions. Available in Display Ads account only. |
| Touchpoint 15 (Display Ads) | TEXT | Campaign for touchpoint 15. Available in Display Ads account only. |
| Touchpoint 15 Account (Display Ads) | TEXT | Account for touchpoint 15. Available in Display Ads account only. |
| Touchpoint 15 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 15. Available in Display Ads account only. |
| Touchpoint 15 Interactions (Display Ads) | TEXT | Touchpoint 15 Interactions. Available in Display Ads account only. |
| Touchpoint 16 (Display Ads) | TEXT | Campaign for touchpoint 16. Available in Display Ads account only. |
| Touchpoint 16 Account (Display Ads) | TEXT | Account for touchpoint 16. Available in Display Ads account only. |
| Touchpoint 16 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 16. Available in Display Ads account only. |
| Touchpoint 16 Interactions (Display Ads) | TEXT | Touchpoint 16 Interactions. Available in Display Ads account only. |
| Touchpoint 17 (Display Ads) | TEXT | Campaign for touchpoint 17. Available in Display Ads account only. |
| Touchpoint 17 Account (Display Ads) | TEXT | Account for touchpoint 17. Available in Display Ads account only. |
| Touchpoint 17 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 17. Available in Display Ads account only. |
| Touchpoint 17 Interactions (Display Ads) | TEXT | Touchpoint 17 Interactions. Available in Display Ads account only. |
| Touchpoint 18 (Display Ads) | TEXT | Campaign for touchpoint 18. Available in Display Ads account only. |
| Touchpoint 18 Account (Display Ads) | TEXT | Account for touchpoint 18. Available in Display Ads account only. |
| Touchpoint 18 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 18. Available in Display Ads account only. |
| Touchpoint 18 Interactions (Display Ads) | TEXT | Touchpoint 18 Interactions. Available in Display Ads account only. |
| Touchpoint 19 (Display Ads) | TEXT | Campaign for touchpoint 19. Available in Display Ads account only. |
| Touchpoint 19 Account (Display Ads) | TEXT | Account for touchpoint 19. Available in Display Ads account only. |
| Touchpoint 19 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 19. Available in Display Ads account only. |
| Touchpoint 19 Interactions (Display Ads) | TEXT | Touchpoint 19 Interactions. Available in Display Ads account only. |
| Touchpoint 1 Account (Display Ads) | TEXT | Account for touchpoint 1. Available in Display Ads account only. |
| Touchpoint 1 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 1. Available in Display Ads account only. |
| Touchpoint 1 Interactions (Display Ads) | TEXT | Touchpoint 1 Interactions. Available in Display Ads account only. |
| Touchpoint 2 (Display Ads) | TEXT | Campaign for touchpoint 2. Available in Display Ads account only. |
| Touchpoint 20 (Display Ads) | TEXT | Campaign for touchpoint 20. Available in Display Ads account only. |
| Touchpoint 20 Account (Display Ads) | TEXT | Account for touchpoint 20. Available in Display Ads account only. |
| Touchpoint 20 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 20. Available in Display Ads account only. |
| Touchpoint 20 Interactions (Display Ads) | TEXT | Touchpoint 20 Interactions. Available in Display Ads account only. |
| Touchpoint 2 Account (Display Ads) | TEXT | Account for touchpoint 2. Available in Display Ads account only. |
| Touchpoint 2 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 2. Available in Display Ads account only. |
| Touchpoint 2 Interactions (Display Ads) | TEXT | Touchpoint 2 Interactions. Available in Display Ads account only. |
| Touchpoint 3 (Display Ads) | TEXT | Campaign for touchpoint 3. Available in Display Ads account only. |
| Touchpoint 3 Account (Display Ads) | TEXT | Account for touchpoint 3. Available in Display Ads account only. |
| Touchpoint 3 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 3. Available in Display Ads account only. |
| Touchpoint 3 Interactions (Display Ads) | TEXT | Touchpoint 3 Interactions. Available in Display Ads account only. |
| Touchpoint 4 (Display Ads) | TEXT | Campaign for touchpoint 4. Available in Display Ads account only. |
| Touchpoint 4 Account (Display Ads) | TEXT | Account for touchpoint 4. Available in Display Ads account only. |
| Touchpoint 4 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 4. Available in Display Ads account only. |
| Touchpoint 4 Interactions (Display Ads) | TEXT | Touchpoint 4 Interactions. Available in Display Ads account only. |
| Touchpoint 5 (Display Ads) | TEXT | Campaign for touchpoint 5. Available in Display Ads account only. |
| Touchpoint 5 Account (Display Ads) | TEXT | Account for touchpoint 5. Available in Display Ads account only. |
| Touchpoint 5 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 5. Available in Display Ads account only. |
| Touchpoint 5 Interactions (Display Ads) | TEXT | Touchpoint 5 Interactions. Available in Display Ads account only. |
| Touchpoint 6 (Display Ads) | TEXT | Campaign for touchpoint 6. Available in Display Ads account only. |
| Touchpoint 6 Account (Display Ads) | TEXT | Account for touchpoint 6. Available in Display Ads account only. |
| Touchpoint 6 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 6. Available in Display Ads account only. |
| Touchpoint 6 Interactions (Display Ads) | TEXT | Touchpoint 6 Interactions. Available in Display Ads account only. |
| Touchpoint 7 (Display Ads) | TEXT | Campaign for touchpoint 7. Available in Display Ads account only. |
| Touchpoint 7 Account (Display Ads) | TEXT | Account for touchpoint 7. Available in Display Ads account only. |
| Touchpoint 7 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 7. Available in Display Ads account only. |
| Touchpoint 7 Interactions (Display Ads) | TEXT | Touchpoint 7 Interactions. Available in Display Ads account only. |
| Touchpoint 8 (Display Ads) | TEXT | Campaign for touchpoint 8. Available in Display Ads account only. |
| Touchpoint 8 Account (Display Ads) | TEXT | Account for touchpoint 8. Available in Display Ads account only. |
| Touchpoint 8 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 8. Available in Display Ads account only. |
| Touchpoint 8 Interactions (Display Ads) | TEXT | Touchpoint 8 Interactions. Available in Display Ads account only. |
| Touchpoint 9 (Display Ads) | TEXT | Campaign for touchpoint 9. Available in Display Ads account only. |
| Touchpoint 9 Account (Display Ads) | TEXT | Account for touchpoint 9. Available in Display Ads account only. |
| Touchpoint 9 Adgroup (Display Ads) | TEXT | AdGroup for touchpoint 9. Available in Display Ads account only. |
| Touchpoint 9 Interactions (Display Ads) | TEXT | Touchpoint 9 Interactions. Available in Display Ads account only. |
| Tracking Url (Search + Display Ads) | TEXT | Tracking URL. Available in Search Ads and Display Ads account. |
| Upper Bid Limit Of Maximize Clicks (Search Ads) | TEXT | Bid Limit (Maximize Clicks). Available in Search Ads account only. |
| Upper Bid Limit Of Target Cpa (Search Ads) | TEXT | Bid Limit (Target CPA). Available in Search Ads account only. |
| Upper Bid Limit Of Target Page Location (Search Ads) | TEXT | Bid Limit (Target position in search results). Available in Search Ads account only. |
| Upper Bid Limit Of Target Roas (Search Ads) | TEXT | Bid Limit (Target ROAS). Available in Search Ads account only. |
| Url (Search Ads) | TEXT | URL. Available in Search Ads account only. |
| Url Id (Display Ads) | TEXT | Destination URL ID. Available in Display Ads account only. |
| Url Name (Display Ads) | TEXT | Destination URL. Available in Display Ads account only. |
| Value Per All Conv (Search + Display Ads) | NUMERIC | Conv. value (all)/conv. (all). Available in Search Ads and Display Ads account. |
| Value Per Conv (Search + Display Ads) | NUMERIC | Conv. value/conv.. Available in Search Ads and Display Ads account. |
| Value Per Conv Via Ad Click (Display Ads) | NUMERIC | Conv. value (via click)/conv. (via click). Available in Display Ads account only. |
| Video View Through Rate (Display Ads) | NUMERIC | Video view through rate. Available in Display Ads account only. |
| Video Views (Display Ads) | NUMERIC | Video views. Available in Display Ads account only. |
| Video Views To 100 (Display Ads) | NUMERIC | 100% video views. Available in Display Ads account only. |
| Video Views To 10 Sec (Display Ads) | NUMERIC | 10 sec video views. Available in Display Ads account only. |
| Video Views To 25 (Display Ads) | NUMERIC | 25% video views. Available in Display Ads account only. |
| Video Views To 3 Sec (Display Ads) | NUMERIC | 3 sec video views. Available in Display Ads account only. |
| Video Views To 50 (Display Ads) | NUMERIC | 50% video views. Available in Display Ads account only. |
| Video Views To 75 (Display Ads) | NUMERIC | 75% video views. Available in Display Ads account only. |
| Video Views To 95 (Display Ads) | NUMERIC | 95% video views. Available in Display Ads account only. |
| View Through Conversions For Conversion Path (Display Ads) | NUMERIC | View-through conversions. Available in Display Ads account only. |
| Viewable Click (Display Ads) | NUMERIC | Viewable clicks. Available in Display Ads account only. |
| Viewable Click Rate (Display Ads) | NUMERIC | Viewable CTR. Available in Display Ads account only. |
| Viewable Impression Avg Frequency (Display Ads) | NUMERIC | Average frequency (viewable impression). Available in Display Ads account only. |
| Viewable Impression Reaches (Display Ads) | NUMERIC | Reaches (viewable impression). Available in Display Ads account only. |
| Viewable Imps (Display Ads) | NUMERIC | Viewable impressions. Available in Display Ads account only. |
| Viewable Imps Rate (Display Ads) | NUMERIC | Viewable impression rate. Available in Display Ads account only. |
| Ward Id (Display Ads) | TEXT | Ward ID. Available in Display Ads account only. |
| Ward Name (Display Ads) | TEXT | Ward. Available in Display Ads account only. |
| Week (Search Ads) | TEXT | Week (Mon-Sun). Available in Search Ads account only. |
| Year (Search Ads) | TEXT | Year. Available in Search Ads account only. |
| Today | DATE | Today's date |
Easily connect Yahoo Japan to Snowflake
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 marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.