{"id":3737,"date":"2020-05-27T19:25:30","date_gmt":"2020-05-27T19:25:30","guid":{"rendered":"https:\/\/www.teamgram.com\/tgblog\/?p=3737"},"modified":"2025-04-04T17:54:13","modified_gmt":"2025-04-04T17:54:13","slug":"hesap-tablolarindaki-verileri-teamgram-panolarinda-goruntuleyin","status":"publish","type":"post","link":"https:\\/\\/www.teamgram.com\\/blog\/tr\/hesap-tablolarindaki-verileri-teamgram-panolarinda-goruntuleyin\/","title":{"rendered":"Hesap Tablolar\u0131ndaki Verilerinizi TeamGram’da G\u00f6r\u00fcnt\u00fcleyin"},"content":{"rendered":"\n

TeamGram’\u0131n h\u0131zl\u0131 g\u00f6stergeleri, sat\u0131\u015flar\u0131n durumunu bir bak\u0131\u015fta kavraman\u0131z\u0131 sa\u011flar. Ama sat\u0131\u015f yaparken ekibinizin bundan daha fazlas\u0131na ihtiyac\u0131 olabilir.<\/p>\n\n\n\n

D\u00f6viz kurlar\u0131. Piyasadan ham madde fiyatlar\u0131. Tahmini temin s\u00fcreleri… CRM yaz\u0131l\u0131m\u0131n\u0131z bunlar\u0131 da g\u00f6sterse iyi olmaz m\u0131?<\/p>\n\n\n\n

Hesap Tablolar\u0131nda Veri Aramaya Son<\/h2>\n\n\n\n

Bu \u00f6nemli verilerin \u00e7o\u011funu hesap tablolar\u0131na kaydediyor olmal\u0131s\u0131n\u0131z. Ama bunlar\u0131n i\u00e7inden tek bir say\u0131ya veya bir grafi\u011fe ihtiya\u00e7lar\u0131 var diye b\u00fct\u00fcn tabloyu ekibinizle payla\u015fmaya ne gerek var?<\/p>\n\n\n\n

Art\u0131k TeamGram’da, Excel ve Google E-Tablolar’dan veri alabilen \u00f6zel g\u00f6stergeler olu\u015fturabilirsiniz. Hatta bunlardan grafikler olu\u015fturabilir, periyodik olarak g\u00fcncellenmelerini sa\u011flayabilirsiniz.<\/p>\n\n\n\n

Hem de g\u00fcvenle: G\u00f6stergelerinizi payla\u015fmak i\u00e7in, bunlar\u0131n veri \u00e7ekti\u011fi hesap tablolar\u0131n\u0131 payla\u015fman\u0131z gerekmez. G\u00f6stergelerin hangi kullan\u0131c\u0131lara ve departmanlara g\u00f6sterilece\u011fini de belirleyebilirsiniz.<\/p>\n\n\n\n

\u00d6zel g\u00f6stergelerinizi sat\u0131\u015f s\u00fcreci sayfas\u0131nda veya pano sayfalar\u0131nda g\u00f6r\u00fcnt\u00fcleyebilirsiniz.<\/p>\n\n\n\n

Kullanabilece\u011finiz G\u00f6sterge Tipleri<\/h2>\n\n\n\n

G\u00f6stergeler birka\u00e7 farkl\u0131 tipte sunulmaktad\u0131r. Amac\u0131n\u0131za uygun olan\u0131 se\u00e7ebilirsiniz.<\/p>\n\n\n\n

\u00c7ubuk Grafik:<\/strong> Birka\u00e7 farkl\u0131 de\u011fi\u015fkenin de\u011ferlerini kar\u015f\u0131la\u015ft\u0131rmal\u0131 olarak g\u00f6stermek i\u00e7in bunlar\u0131 kullan\u0131n.
\"\"<\/p>\n\n\n\n

Zaman Serisi \u00c7izgi Grafi\u011fi:<\/strong> Bunlar, say\u0131sal bir de\u011fi\u015fkenin zamanla nas\u0131l de\u011fi\u015fti\u011fini g\u00f6stermek i\u00e7in idealdir.
\"\"<\/p>\n\n\n\n

Tekil De\u011fer: <\/strong>Tek bir say\u0131 veya metin de\u011ferini panoda g\u00f6stermek i\u00e7in bunlar\u0131 kullan\u0131n.
\"\"<\/p>\n\n\n\n

Liste: <\/strong>Bunlar tekil de\u011fer g\u00f6stergeleri gibidir, ama birden fazla de\u011feri tablo halinde g\u00f6sterirler.
\"\"<\/p>\n\n\n\n

Microsoft Excel ve Google E-Tablolar ile Uyumlu<\/h2>\n\n\n\n

TeamGram \u00f6zel g\u00f6stergeleri, Microsoft OneDrive veya Google Drive’da bulunan Excel dosyalar\u0131ndan veri alabilir. E\u011fer veri dosyan\u0131z yerel bir diskte kay\u0131tl\u0131ysa, \u00f6nce bunu OneDrive veya Google Drive ile senkronize edin.<\/p>\n\n\n\n

Google E-tablolar ise zaten bulut tabanl\u0131 oldu\u011fundan, bunlardan veri almak i\u00e7in \u00f6zel bir d\u00fczenleme yapman\u0131z gerekmez. <\/p>\n\n\n\n

Di\u011fer Uygulamalardan \u00d6zel G\u00f6stergelere Veri Alma<\/h2>\n\n\n\n

Bu y\u00f6ntemle, Excel Dosyalar\u0131na veya Google E-Tablolar’a otomatik aktar\u0131m yapabilen i\u015f uygulamalar\u0131n\u0131n verilerini de TeamGram’da g\u00f6r\u00fcnt\u00fcleyebilirsiniz.<\/p>\n\n\n\n

\u0130\u015fte birka\u00e7 \u00f6rnek kullan\u0131m \u015fekli: ERP yaz\u0131l\u0131m\u0131n\u0131z muhtemelen Excel dosyalar\u0131na veri yazabilir. Google E-Tabolar’daki finansal fonksiyonlar, d\u00f6viz kurlar\u0131, hisse senedi ve baz\u0131 emtia fiyatlar\u0131na ula\u015fman\u0131z\u0131 sa\u011flar. Zapier kullanarak, e-posta ile ald\u0131\u011f\u0131n\u0131z mesajlardan bilgi ay\u0131klay\u0131p bir hesap tablosuna otomatik olarak ge\u00e7irebilirsiniz…<\/p>\n\n\n\n

\u00d6zel G\u00f6sterge Olu\u015fturma<\/h2>\n\n\n\n

\u00d6zel g\u00f6stergeleri sadece sistem y\u00f6neticisi yetkisine sahip kullan\u0131c\u0131lar olu\u015fturup payla\u015fabilir. <\/p>\n\n\n\n

\u00d6zel bir g\u00f6sterge olu\u015fturmak i\u00e7in \u00f6nce verinizin Microsoft OneDrive veya Google Drive’da kay\u0131tl\u0131 bir Excel tablosunda veya Google E-Tablolar’da oldu\u011fundan emin olun.<\/p>\n\n\n\n

Microsoft OneDrive veya Google Drive’daki dosyalar\u0131n\u0131za eri\u015febilmesi i\u00e7in TeamGram’a izin vermeniz gerekir. Bunun i\u00e7in Kontrol Paneli > Entegrasyonlar > Kullan\u0131c\u0131 Entegrasyonu > Di\u011fer<\/em> b\u00f6l\u00fcm\u00fcne gidin. Bu i\u015flemi bir defa yapman\u0131z yeterlidir.<\/p>\n\n\n\n

Sonra Kontrol Paneli > \u00d6zel G\u00f6stergeler<\/em> sayfas\u0131na gidin ve g\u00f6stergenizi olu\u015fturun.<\/p>\n\n\n\n

Hen\u00fcz TeamGram kullanm\u0131yor musunuz? Hemen \u00fccretsiz deneme hesab\u0131n\u0131z\u0131 a\u00e7\u0131n<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Sat\u0131\u015f ekibinizin di\u011fer uygulamalardaki verilere kolayca eri\u015fmesini sa\u011flay\u0131n. ERP sisteminizdekiler de dahil.<\/p>\n","protected":false},"author":2,"featured_media":3767,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","inline_featured_image":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"footnotes":""},"categories":[190,180],"tags":[],"class_list":["post-3737","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ipuclari","category-uncategorized-tr"],"jetpack_featured_media_url":"https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif","spectra_custom_meta":{"_alp_processed":["1743789253"],"_thumbnail_id":["3767"],"_edit_last":["2"],"ct_chosen_pro_video_key":[""],"ct_chosen_pro_video_display_key":["post"],"ct_chosen_pro_video_youtube_logo":["0"],"ct_chosen_pro_video_youtube_captions":["0"],"ct_chosen_pro_video_youtube_autoplay":["0"],"ct_chosen_pro_video_youtube_loop":["0"],"ct_chosen_pro_video_youtube_mute":["0"],"ct_chosen_pro_fi_size_key":["default"],"ct_chosen_pro_post_layout_key":["default"],"ct_chosen_last_updated":["default"],"_yoast_wpseo_primary_category":["15"],"_yoast_wpseo_content_score":["30"],"_wp_old_slug":["pull-data-from-spreadsheets-to-display-in-teamgram-dashboards"],"_wp_page_template":["default"],"ekit_post_views_count":["84"],"_wpml_word_count":["626"],"_edit_lock":["1743789254:2"],"_wpml_location_migration_done":["1"],"_wpml_media_has_media":["1"],"_pingme":["1"],"_encloseme":["1"],"_last_translation_edit_mode":["native-editor"],"_g_feedback_shortcode_91d6569bd95dd9c3a6359d3d643eba3548bbc0bf":["\n\t\t\t\t[contact-field label=\"Name\" type=\"name\" required=\"true\" \/]\n\t\t\t\t[contact-field label=\"Email\" type=\"email\" required=\"true\" \/]\n\t\t\t\t[contact-field label=\"Website\" type=\"url\" \/]\n\t\t\t\t[contact-field label=\"Message\" type=\"textarea\" \/]"],"_g_feedback_shortcode_atts_91d6569bd95dd9c3a6359d3d643eba3548bbc0bf":["a:17:{s:2:\"to\";s:21:\"ayurekli@teamgram.com\";s:7:\"subject\";s:78:\"[TeamGram Blog] Hesap Tablolar\u0131ndaki Verilerinizi TeamGram'da G\u00f6r\u00fcnt\u00fcleyin\";s:12:\"show_subject\";s:2:\"no\";s:6:\"widget\";i:0;s:14:\"block_template\";N;s:19:\"block_template_part\";N;s:2:\"id\";i:3737;s:18:\"submit_button_text\";s:6:\"Submit\";s:14:\"customThankyou\";s:0:\"\";s:21:\"customThankyouHeading\";s:26:\"Your message has been sent\";s:21:\"customThankyouMessage\";s:30:\"Thank you for your submission!\";s:22:\"customThankyouRedirect\";s:0:\"\";s:10:\"jetpackCRM\";b:1;s:9:\"className\";N;s:9:\"postToUrl\";N;s:14:\"salesforceData\";N;s:12:\"hiddenFields\";N;}"],"_wpml_media_duplicate":["1"],"_wpml_media_featured":["1"],"_wp_attachment_metadata":[""],"_uag_css_file_name":["uag-css-3737.css"],"_uag_page_assets":["a:9:{s:3:\"css\";s:263:\".uag-blocks-common-selector{z-index:var(--z-index-desktop) !important}@media (max-width: 976px){.uag-blocks-common-selector{z-index:var(--z-index-tablet) !important}}@media (max-width: 767px){.uag-blocks-common-selector{z-index:var(--z-index-mobile) !important}}\n\";s:2:\"js\";s:0:\"\";s:18:\"current_block_list\";a:8:{i:0;s:14:\"core\/paragraph\";i:1;s:12:\"core\/heading\";i:2;s:11:\"core\/search\";i:3;s:10:\"core\/group\";i:4;s:17:\"core\/latest-posts\";i:5;s:20:\"core\/latest-comments\";i:6;s:13:\"core\/archives\";i:7;s:15:\"core\/categories\";}s:8:\"uag_flag\";b:0;s:11:\"uag_version\";s:10:\"1775297511\";s:6:\"gfonts\";a:0:{}s:10:\"gfonts_url\";s:0:\"\";s:12:\"gfonts_files\";a:0:{}s:14:\"uag_faq_layout\";b:0;}"]},"uagb_featured_image_src":{"full":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",800,400,false],"thumbnail":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6-150x150.gif",150,150,true],"medium":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6-300x150.gif",300,150,true],"medium_large":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6-768x384.gif",768,384,true],"large":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",800,400,false],"1536x1536":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",800,400,false],"2048x2048":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",800,400,false],"newspack-article-block-landscape-large":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",800,400,false],"newspack-article-block-portrait-large":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",800,400,false],"newspack-article-block-square-large":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",800,400,false],"newspack-article-block-landscape-medium":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",800,400,false],"newspack-article-block-portrait-medium":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",600,300,false],"newspack-article-block-square-medium":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",800,400,false],"newspack-article-block-landscape-intermediate":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",600,300,false],"newspack-article-block-portrait-intermediate":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",450,225,false],"newspack-article-block-square-intermediate":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",600,300,false],"newspack-article-block-landscape-small":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",400,200,false],"newspack-article-block-portrait-small":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",300,150,false],"newspack-article-block-square-small":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",400,200,false],"newspack-article-block-landscape-tiny":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",200,100,false],"newspack-article-block-portrait-tiny":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",150,75,false],"newspack-article-block-square-tiny":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",200,100,false],"newspack-article-block-uncropped":["https:\\/\\/www.teamgram.com\\/blog\/wp-content\/uploads\/2020\/05\/widgettr6.gif",800,400,false]},"uagb_author_info":{"display_name":"Ahmet Yurekli","author_link":"https:\\/\\/www.teamgram.com\\/blog\/tr\/author\/ayurekli\/"},"uagb_comment_info":0,"uagb_excerpt":"Sat\u0131\u015f ekibinizin di\u011fer uygulamalardaki verilere kolayca eri\u015fmesini sa\u011flay\u0131n. ERP sisteminizdekiler de dahil.","jetpack_shortlink":"https:\/\/wp.me\/pgusnm-Yh","_links":{"self":[{"href":"https:\\/\\/www.teamgram.com\\/blog\/tr\/wp-json\/wp\/v2\/posts\/3737","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\\/\\/www.teamgram.com\\/blog\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\\/\\/www.teamgram.com\\/blog\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\\/\\/www.teamgram.com\\/blog\/tr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\\/\\/www.teamgram.com\\/blog\/tr\/wp-json\/wp\/v2\/comments?post=3737"}],"version-history":[{"count":2,"href":"https:\\/\\/www.teamgram.com\\/blog\/tr\/wp-json\/wp\/v2\/posts\/3737\/revisions"}],"predecessor-version":[{"id":7911,"href":"https:\\/\\/www.teamgram.com\\/blog\/tr\/wp-json\/wp\/v2\/posts\/3737\/revisions\/7911"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\\/\\/www.teamgram.com\\/blog\/tr\/wp-json\/wp\/v2\/media\/3767"}],"wp:attachment":[{"href":"https:\\/\\/www.teamgram.com\\/blog\/tr\/wp-json\/wp\/v2\/media?parent=3737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\\/\\/www.teamgram.com\\/blog\/tr\/wp-json\/wp\/v2\/categories?post=3737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\\/\\/www.teamgram.com\\/blog\/tr\/wp-json\/wp\/v2\/tags?post=3737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}