[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/Fundadores-Siguetuliga.webp” alt=”Untitled Group event” title_text=”Fundadores Siguetuliga” _builder_version=”4.18.1″ _module_preset=”default” width=”100%” max_width=”600px” max_height=”360px” border_radii=”on|12px|12px|12px|12px” box_shadow_style=”preset1″ box_shadow_horizontal=”6px” box_shadow_vertical=”0px” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]Using Sheetgo, Siguetuliga now saves around 144 hours every year with a custom solution that creates an accurate marketing report every week using data from several sources linked via connections. As a result, the team have 1.5 days extra per month to focus on the most crucial aspects of the business: data analysis.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Dealing with outdated data from multiple sources<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- \n
Manually inputting data from several sources<\/span><\/p>\n<\/li>\n
- <\/span>\n
Over half a day per week spent on extraction process<\/span><\/p>\n<\/li>\n
- <\/span>No time left to spend on data analysis and results<\/span><\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]Siguetuliga has developed its programming with database MySQL, Google Workspace and Google Analytics to manage the data for all aspects of the company. Siguetuliga relied on a script to collect the data and then would manually copy and paste this data into a spreadsheet. What’s more, they’d manually copy and past data directly from Google Analytics. This had become an extremely time consuming process, taking over half a day to extract the data. Not only did this reduce the time they had to actually analyze the data properly, but by the time the data had been collected, it wasn’t as accurate as they needed.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cWe were spending almost 2 days every month extracting data. It was taking away from our analysis, which is one of the most important aspects of our business.”
\n<\/span><\/p>\nDiego Fern\u00e1ndez | CEO, Siguetuliga
\n<\/em>[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]Siguetuliga reached out to Sheetgo to create a custom solution that would automate the extraction of data from Google Analytics and add it to Google Sheets. What’s more, they needed a reliable system that would be able to match data to customers, so they could send each customer the correct sports insights, i.e., game results, upcoming matches, league tables, etc.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\nEffortless data collection using Sheetgo<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- \n
Merge to consolidate 27 spreadsheets into single report<\/span><\/p>\n<\/li>\n
- <\/span>\n
Automate data collection process on weekly basis<\/span><\/p>\n<\/li>\n
- <\/span>\n
Visual Marketing KPI report with key metrics<\/span><\/p>\n<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]Using Sheetgo, Siguetuliga is able to connect their Google Analytics directly to Google Sheets to automate data extraction. Then, using the Merge feature, these spreadsheets are combined to create a single report. This custom solution also incorporates the database they had originally developed: MySQL. This database is exported as CSV and transferred to a KPI Google Sheets where customer data is collected. This is connected to the report spreadsheet where Analytics data is matched with customer data to create personalized sports updates.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cUsing Sheetgo resulted in more time for decision making, and created more room for thinking of strategic ways of analyzing\u201d
\n<\/span><\/p>\nDiego Fern\u00e1ndez | CEO, Siguetuliga
\n<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]Siguetuliga has finally created the infrastructure they needed where time-consuming tasks have been automated to leave more quality time for data analysis and sending accurate reports to customers. At the same time, they receive the latest performance insights, including key metrics like total visits and conversion. Simply by replacing manual input on various databases and creating a custom automation schedule, the team now have access to accurate data which they can consolidate and share in a matter of minutes.[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\nSaving 1.5 days a month to focus on data analysis<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- \n
144 hours saved every year<\/span><\/p>\n<\/li>\n
- <\/span>\n
100% up-to-date KPI insights\u00a0<\/span><\/p>\n<\/li>\n
- \n
Consolidate data for deeper analysis<\/span>
<\/span><\/p>\n<\/li>\n<\/ul>\n[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]Thanks to Sheetgo, Siguetuliga\u2019s workload has reduce hugely, saving them around 8 hours of work per month. Now the team have the time to dedicate to top-quality analysis of data to help make their customer experience better. What’s more, they have a fully customized solution that builds on top of their existing tools to create a centralized system.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cSheetgo saves me 12 hours a month of work, it allows me to focus on data analysis and not on the collection\u201d
\n<\/span><\/p>\nDiego Fern\u00e1ndez | CEO, Siguetuliga
\n<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]Siguetuliga can now rely on one same infrastructure to input, manage, and especially analyze data. Since Sheetgo integrates with all Google Workspace products, they don’t need to learn to use new tools and can maintain their productivity levels. As growth is assured for Siguetuliga and this system is scalable, this Sheetgo solution will grow alongside them to guarantee further efficiency and productivity.[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/08\/siguetuliga-logo.svg” alt=”Untitled Group logo” title_text=”siguetuliga-logo” align=”center” _builder_version=”4.18.1″ _module_preset=”default” width=”200px” max_width=”200px” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]Siguetuliga is a social sports platform in Spain with over 2 million users. It\u2019s a well-known online meeting point for sports fans where they can find regional sports events. Siguetuliga uses MySQL, Google G Suite, Google Analytics, and Sheetgo to run the company.
\n<\/span>[\/et_pb_text][et_pb_icon font_icon=”||fa||900″ icon_width=”16px” align=”left” _builder_version=”4.16″ _module_preset=”default” custom_margin=”|20px|10px||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” width=”85%” custom_margin=”||10px||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]Spain<\/span>[\/et_pb_text][et_pb_icon font_icon=”||fa||900″ icon_width=”16px” align=”left” _builder_version=”4.16″ _module_preset=”default” custom_margin=”|20px|||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” width=”85%” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]https:\/\/www.siguetuliga.com\/<\/span><\/a>[\/et_pb_text][et_pb_divider _builder_version=”4.16″ _module_preset=”default” custom_margin=”||20px||false|false” global_colors_info=”{}”][\/et_pb_divider][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]Industry<\/strong>
\nTechnology<\/span>[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]Features used<\/strong><\/span><\/p>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-google-sheets.svg\")
Google Sheets<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/07\/scalable-sheets-google-drive.svg\")
Google Drive<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/01\/g-suite.webp\")
Google Suite<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/01\/g-analytics.webp\")
Google Analytics<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/05\/icon-connection.svg\")
Connect<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-merge.svg\")
Merge<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/automatic-updates.png)
Automatic updates<\/div>\n[\/et_pb_text][\/et_pb_column][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Siguetuliga: Custom KPI reporting system for a Spanish social sports platformSheetgo is the no-code spreadsheet automation platform that turns the data your team already keeps in Sheets, Excel, and CSVs into pipelines, dashboards, and AI-ready datasets.Using Sheetgo, Siguetuliga now saves around 144 hours every year with a custom solution that creates an accurate marketing report […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":6600,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"difl_page_category":[],"class_list":["post-6718","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/6718","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=6718"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/6718\/revisions"}],"predecessor-version":[{"id":260742,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/6718\/revisions\/260742"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/6600"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=6718"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/difl_page_category?post=6718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- <\/span>\n
- <\/span>\n
- <\/span>\n