Elton Data Documentation

website·Indexed 32 days ago

https://docs.eltondata.com/docs/

Documentation for Elton, a data integration platform featuring connectors for data sources such as TikTok Shop, TikTok Ads, Amazon Seller, Amazon Ads, Shopee, Haravan, Pancake POS, and Lark Suite. The platform provides tools for data transformation, destination management (including Google BigQuery), and data integrity checks.

Tokens
34.5K
Snippets
45
Records
240
Agent score
55%

What's inside Elton

  1. Overview of the Elton data movement platform

    Elton is a modern data movement platform designed to help organizations centralize their data by automating the most time-consuming parts of the ELT (Extract, Load, Transform) process. It is built to enable users to retrieve necessary data without requiring deep technical skills or direct intervention from technical teams.
  2. Overview of Elton Alerting

    The Alerting feature in Elton is designed to help businesses identify anomalies in their data. It allows users to set specific thresholds for business metrics (e.g., daily revenue) and receive automated notifications when data falls outside of expected ranges, enabling timely analysis and response.
  3. Overview of the Data Bình Dân project

    Data Bình Dân is a non-profit project created by the Elton team to democratize data knowledge for Vietnamese people. It aims to help users confidently access, interpret, and apply data in both daily decision-making and professional environments. The project is structured into four levels of learning, catering to everyone from absolute beginners to experienced professionals seeking to enhance their analytical skills.
  4. Overview of the Elton Data Platform

    Elton is a platform designed to help users collect and systematize data from various business channels and sources. Its primary goal is to centralize fragmented data, allowing users to manage and utilize their information more effectively and efficiently.
  5. Migrate deprecated post impression and video view metrics to Media Views

    Due to changes in Meta's data provision, several legacy post impression and video view metrics are being deprecated and replaced by the 'Media Views' concept. Developers and analysts should update their reporting queries to use the new columns. Note that some specific reach metrics (Fan, Viral, and Non-viral) are no longer provided by Meta and have no replacement.
    Old Data Column (Deprecated)New Replacement ColumnNote
    post_impressions_uniquepost_total_media_view_uniqueUnique reach per post
    post_impressions_paid_uniquepost_media_viewReplaced by categorized Media View
    post_impressions_organic_uniquepost_media_viewReplaced by categorized Media View
    post_video_complete_views_30s_uniquepost_total_media_view_uniqueVideo viewers merged into Media Views
    post_video_views_uniquepost_total_media_view_uniqueVideo viewers merged into Media Views
    post_video_complete_views_30s_autoplayedpost_total_media_view_uniqueVideo viewers merged into Media Views
    post_video_complete_views_30s_clicked_to_playpost_total_media_view_uniqueVideo viewers merged into Media Views
    post_video_complete_views_30s_organicpost_media_viewVideo views (Organic category)
    post_video_complete_views_30s_paidpost_media_viewVideo views (Paid category)
    post_video_views_paid_uniquepost_media_viewVideo views (Paid category)
    post_impressions_fan_uniqueNoneMeta stopped providing Fan Reach
    post_impressions_viral_uniqueNoneMeta stopped providing Viral Reach
    post_impressions_nonviral_uniqueNoneMeta stopped providing Non-viral Reach
  6. Connect Elton with Amazon, Sapo, and Shopee

    Elton supports comprehensive connectivity and integration with Amazon, Sapo, and Shopee applications, allowing users to sync and manage data across these platforms.
  7. Use Transformation Templates for data processing

    EltonData has introduced Transformation Templates to accelerate data processing workflows. This feature includes a library of pre-defined templates and automatic synchronization capabilities to streamline how data is handled.
  8. Organize Connections and Transformations using Tags

    EltonData provides a Tags feature that allows users to organize and group Connections and Transformations. This system is designed to improve the speed of searching and managing workflows by categorizing related assets together.
  9. Understand Elton Data MSSQL Schema Architecture

    Elton Data utilizes three specific schemas within the MSSQL database to manage data synchronization and backups:

    • elton_dwh: The primary schema where the final destination data tables are stored. This is the main schema users will interact with.
    • elton_staging: Used for temporary data storage before it is synchronized into the primary tables.
    • elton_backup: Stores backup copies of tables from elton_dwh during reload operations.
  10. Understand Elton Data's data processing and storage model

    When a Customer Database is connected to Elton Data to perform ELT processes, Elton Data acts as a processor of Personal Information. Elton Data does not store a copy of the user's data; instead, data is moved directly to the user's own data warehouses. To maintain security and minimize exposure, users are encouraged to provide a read-only connection that grants access only to the minimum amount of data required for the ELT process.