Google Sheets - gettectonic.com

AI’s Impact on Future Information Ecosystems

AI’s Impact on Future Information Ecosystems The proliferation of generative AI technology has ignited a renewed focus within the media industry on how to strategically adapt to its capabilities. Media professionals are now confronted with crucial questions: What are the most effective ways to leverage this technology for efficiency in news production and to enhance audience experiences? Conversely, what threats do these technological advancements pose? Is legacy media on the brink of yet another wave of disintermediation from its audiences? Additionally, how does the evolution of technology impact journalism ethics? AI’s Impact on Future Information Ecosystems. In response to these challenges, the Open Society Foundations (OSF) launched the AI in Journalism Futures project earlier this year. The first phase of this ambitious initiative involved an open call for participants to develop future-oriented scenarios that explore the potential driving forces and implications of AI within the broader media ecosystem. The project sought to answer questions about what might transpire among various stakeholders in 5, 10, or 15 years. As highlighted by Nick Diakopoulos, scenarios are a valuable method for capturing a diverse range of perspectives on complex issues. While predicting the future is not the goal, understanding a variety of plausible alternatives can significantly inform current strategic thinking. Ultimately, more than 800 individuals from approximately 70 countries contributed short scenarios for analysis. The AI in Journalism Futures project subsequently utilized these scenarios as a foundation for a workshop, which refined the ideas outlined in their report. Diakopoulos emphasizes the importance of examining this broad set of initial scenarios, which OSF graciously provided in anonymized form. This analysis specifically explores (1) the various types of impacts identified within the scenarios, (2) the associated timeframes for these impacts—whether they are short, medium, or long-term, and (3) the global differences in focus across regions, highlighting how different parts of the world emphasized distinct types of impacts. While many additional questions could be explored regarding this data—such as the drivers of impacts, final outcomes, severity, stakeholders involved, or technical capabilities emphasized—this analysis focuses primarily on impacts. Refining the Data The initial pool of 872 scenarios underwent a rigorous process of cleaning, filtering, transformation, and verification before analysis. Firstly, scenarios shorter than 50 words were excluded from consideration, resulting in 852 scenarios for analysis. Additionally, 14 scenarios that were not written in English were translated using Google Sheets. To enable geographic and temporal analysis, the country of origin for each scenario writer was mapped to their respective continents, and the free-text “timeframe” field was converted into numerical representations of years. Next, impacts were extracted from each scenario using an LLM (GPT-4 in this case). The prompts for the LLM were refined through iteration, with a clear definition established for what constitutes an “impact.” Diakopoulos defined an impact as “a significant effect, consequence, or outcome that an action, event, or other factor has in the scenario.” This definition encompasses not only the ultimate state of a scenario but also intermediate outcomes. The LLM was instructed to extract distinct impacts, with each impact represented by a one-sentence description and a short label. For instance, one impact could be described as, “The proliferation of flawed AI systems leads to a compromised information ecosystem, causing a general doubt in the reliability of all information,” labeled as “Compromised Information Ecosystem.” To ensure the accuracy of this extraction process, a random sample of five scenarios was manually reviewed to validate the extracted impacts against the established definition. All extracted impacts passed the checks, leading to confidence in scaling the analysis across the entire dataset. This process resulted in the identification of 3,445 impacts from the 852 scenarios. AI’s Impact on Future Information Ecosystems A typology of impact types was developed based on the 3,445 impact descriptions, utilizing a novel method for qualitative thematic analysis from a Stanford University study. This approach clusters input texts, synthesizes concepts that reflect abstract connections, and produces scoring definitions to assess the relevance of each original text. For example, a concept like “AI Personalization” might be defined by the question, “Does the text discuss how AI personalizes content or enhances user engagement?” Each impact description was then scored against these concepts to tabulate occurrence frequencies. Impacts of AI on Media Ecosystems Through this analytical approach, 19 impact themes emerged, along with their corresponding scoring definitions: Interestingly, many scenarios articulated themes around how AI intersects with fact-checking, trust, misinformation, ethics, labor concerns, and evolving business models. Although some concepts may not be entirely distinct, this categorization offers a meaningful overview of the key ideas represented in the data. Distribution of Impact Themes Comparing these findings with those in the OSF report reveals some discrepancies. For instance, while the report emphasizes personalization and misinformation, these themes were less prevalent in the analyzed scenarios. Moreover, themes such as the rise of AI agents and audience fragmentation were mentioned but did not cluster significantly in the analysis. To capture potentially interesting but less prevalent impacts, the clustering was rerun with a smaller minimum cluster size. This adjustment yielded hundreds more concept themes, revealing insights into longer-tail issues. Positive visions for generative AI included reduced language barriers and increased accessibility for marginalized audiences, while concerns about societal fragmentation and privacy were also raised. Impacts Over Time and Around the World The analysis also explored how the impacts varied based on the timeframe selected by writers and their geographic locations. Using a Chi-Squared test, it was determined that “AI Personalization” trends towards long-term implications, while both “AI Fact-Checking” and “AI and Misinformation” skew toward shorter-term issues. This suggests that scenario writers perceive misinformation impacts as imminent threats, likely reflecting ongoing developments in the media landscape. When examining the distribution of impacts by region, it was found that “AI Fact-Checking” was more frequently noted by writers from Africa and Asia, while “AI and Misinformation” was less prevalent in scenarios from African writers but more so in those from Asian contributors. This indicates a divergence in perspectives on AI’s role in the media ecosystem.

Read More
Converting 15-Character IDs to 18-Character in Salesforce

Converting 15-Character IDs to 18-Character in Salesforce

In Salesforce, every record is assigned a unique Record ID, which is essential for managing data, writing formulas, and referencing records as an admin or developer. There are two types of Record IDs: a 15-character version and an 18-character version, each suited for different scenarios. Converting 15-character IDs to 18-character ones can be time-consuming when done manually, but several tools and methods can simplify the process, allowing for instant conversion with just a click. Understanding Salesforce Record IDs 15-Character Record ID The 15-character Record ID is case-sensitive and typically used in Salesforce’s user interface for tasks like editing records and generating reports. However, its case sensitivity can create issues with systems that do not recognize differences between uppercase and lowercase letters. 18-Character Record ID To mitigate case sensitivity issues, Salesforce offers an 18-character ID, which is used in APIs and tools such as Data Loader. This ID adds three additional characters to the 15-character version and is always returned by these tools during data exports. When to Use Each ID For consistency, the 18-character ID is preferable, especially when working with external systems. It’s best practice to use the 18-character ID in formulas, API calls, or any data comparisons to avoid errors caused by case sensitivity. Converting IDs Using a Formula Field in Salesforce Salesforce recommends creating a formula field with the CASESAFEID(Id) function to convert the 15-character ID to an 18-character ID. Here are some key points to consider: Implementation Steps: Once completed, this formula field will display the 18-character ID on relevant records. APIs and Software DevelopmentIf you need a more scalable or efficient solution, consider using Salesforce APIs or third-party tools for ID conversion. While online tools may suffice for small tasks, they can become unwieldy when handling hundreds or thousands of records in a CSV or Excel file. Streamlining ID Conversion with Xappex Tools Imagine the frustration of manually copying and pasting IDs! That’s where the XL-Connector and G-Connector from Xappex come into play. These tools work directly in Excel or Google Sheets, simplifying the ID conversion process. Instead of juggling multiple tools or navigating complex processes, you can seamlessly convert Salesforce IDs within your spreadsheet, saving significant time and effort. Using XL-Connector for ID Conversion in Excel Using G-Connector (Google Sheets) for ID Conversion G-Connector is Xappex’s integration tool for Google Sheets and Salesforce. If you haven’t installed it yet, do so and log in to your Salesforce org. The sheet will automatically update with the new 18-character IDs and provide links to open the records directly in Salesforce. Conclusion In summary, managing Salesforce Record IDs doesn’t have to be a hassle. While converting 15-character IDs to 18-character IDs is crucial for consistency, doing it manually can be tedious. With XL-Connector and G-Connector, you can streamline ID conversion with just a click in Excel or Google Sheets, making your workflow much more efficient. Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
UncannyAutomator Salesforce Integration

UncannyAutomator Salesforce Integration

Integrating WordPress with Salesforce With the Uncanny Automator Elite Integrations addon, connecting your WordPress site to Salesforce is a breeze. Steps to Connect Uncanny Automator to Your Salesforce Account 1. Install the Elite Integrations Addon First, ensure you have the Elite Integrations addon for Uncanny Automator installed on your WordPress site. 2. Connect Uncanny Automator to Salesforce To establish the connection, follow these steps: You will be prompted to log into Salesforce. After logging in, you will need to allow Uncanny Automator to manage your Salesforce data by clicking Allow. You will then return to the app connection screen on your WordPress site. Using Salesforce Actions in Recipes Once connected to Salesforce, you can use Uncanny Automator to create and update contacts and leads based on user actions on your WordPress site. Here’s how: Final Steps That’s it! Your recipe will now automatically run whenever users complete the selected trigger(s), sending the desired updates directly to your Salesforce account. Installing Uncanny Automator Install the free version The free version of Uncanny Automator is hosted in the WordPress.org repository, so installing it on your WordPress site couldn’t be easier. Sign into your website as an administrator, and in /wp-admin/, navigate to Plugins > Add New. In the search field, enter “Uncanny Automator”. See the image below for more context. In the Search Results, click the Install Now button for Automator. Once it finishes installing, click Activate. That’s it! Uncanny Automator is installed and ready for use. Please note that you must have the free version installed first to use Uncanny Automator Pro. The setup wizard After activation, you will be redirected to the Uncanny Automator dashboard. From here, you can connect an account, watch tutorials or read articles in our Knowledge Base. Connecting a free account is an optional step allows you to try out some of the App non-WordPress Automator integrations (like Slack, Google Sheets and Facebook) but it is not required to use anything else in the free version. Install Uncanny Automator Pro Uncanny Automator Pro is a separate plugin from our free version, and to use Pro features, you must have both Uncanny Automator AND Uncanny Automator Pro installed and active. If you don’t yet have a copy of Automator Pro, you can purchase one from https://automatorplugin.com/pricing/. Once purchased, you can download the latest version of Uncanny Automator Pro inside your account on our website at https://automatorplugin.com/my-account/downloads/. To install the Pro version after downloading the zip file, navigate to Plugins > Add New in /wp-admin/. At the top of the page, click the Upload Plugin button. Click Choose File to select the Pro zip file, the Install Now and Activate the plugin. Once activated, be sure to visit Automator > Settings in /wp-admin/ to enter your license key. This unlocks access to automatic updates and unlimited use of non-WordPress integrations in your recipes. UncannyAutomator special triggers can be found here. Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
SWOT Templates

SWOT Templates

Top SWOT Analysis Templates for Any Business Strategic planning is crucial for businesses aiming to grow. Whether launching a new product, tackling competition, or enhancing existing offerings, a SWOT analysis can help you understand your current position and develop a confident path forward. When engaging in strategic brainstorming, avoid getting bogged down by documentation. Focus on expansive thinking and creative problem-solving instead. To aid in this process, we’ve compiled some of the best SWOT analysis templates available online. These templates handle the layout and design so you can concentrate on deep thinking. Read on to discover the value of SWOT analyses and our top template picks. What is a SWOT Analysis? A SWOT analysis is a framework for evaluating your company’s market position by examining internal and external factors. It helps identify your strengths, weaknesses, opportunities, and threats. The strengths and weaknesses sections focus on internal factors, such as products, value propositions, teams, and resources. Opportunities and threats examine external factors, including customers, competitors, industry trends, and broader market forces. Why Conduct a SWOT Analysis? A SWOT analysis provides a clear visualization of your business’s current standing. By understanding your strengths, areas for improvement, and external influences, you can formulate effective strategies for progress. Periodic SWOT analyses are beneficial for continuous improvement and essential during significant initiatives or changes, such as: SWOT analyses can also be applied to individual team members, useful for performance reviews or team reorganizations. Top SWOT Analysis Templates for Any Business Here are seven excellent SWOT analysis templates suitable for any business: For SWOT analyses that will be part of larger presentations, Canva’s drag-and-drop design tool offers dozens of templates. Customize with your brand colors and insert into your strategy deck or PDF. Miro’s virtual whiteboard template goes beyond traditional SWOT frameworks by adding sections for potential actions. Explore how to leverage strengths and opportunities or mitigate weaknesses using opportunities. Smartsheet provides templates for both Google Docs and Microsoft Word. Whether evaluating a business goal or personal performance, these templates are versatile and easy to use. TemplateLAB offers SWOT analysis templates in multiple formats, including Word Doc, PowerPoint, PDF, and Photoshop. Choose from a range of styles for both internal brainstorming and formal presentations. Airtable combines the structure of Excel with better organization for written content. Its SWOT analysis template is perfect for those who prefer spreadsheet-style work with enhanced labeling and filtering capabilities. SCORE’s simple Word Doc template provides all the necessary elements for a SWOT analysis without any extra distractions. SCORE also offers free resources, including mentorship and educational opportunities. For those looking to incorporate AI, Notion offers a template that leverages ChatGPT. Input your business information, and ChatGPT generates a SWOT analysis, offering insights you might not have considered. Bonus: WordStream Free SWOT Analysis Template For a comprehensive solution, try the WordStream template in Google Sheets. It’s an excellent tool for SWOT analysis brainstorming sessions. Use a SWOT Analysis Template Today for Business Growth Tomorrow When choosing a template, prioritize strategic work over perfect design. Select one and dive into the brainstorming process with your team to gain valuable insights for your business. If you need assistance with your marketing strategy, explore our solutions to maximize strengths and minimize weaknesses for long-term success. Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
Google Analytics 4 UTM Codes

Google Analytics 4 UTM Codes

How to Generate UTM Codes Generating Google Analytics 4 UTM Codes can be done in several ways. A common method is using Google’s Campaign URL Builder, where you enter your original URL and add the desired UTM parameters. Alternatively, tools like Measureschool’s UTM Tool in Google Sheets or other free online tools can also be used to create UTM codes. Viewing UTM Data in Google Analytics 4 In Google Analytics 4 (GA4), UTM data is found in the standard Acquisition reports. Specifically, you can view this data in the Acquisition Overview, User Acquisition: First User Default Channel Grouping, and Traffic Acquisition reports. Additionally, the Explore section in GA4 allows for the creation of custom reports using UTM data. Best Practices for UTM Tagging When using UTM tags, consider the following best practices: Google Analytics 4 UTM Codes allows you to better track your customer journeys and measure ROI on your advertising and search engine optimization efforts. Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more Top Ten Reasons Why Tectonic Loves the Cloud The Cloud is Good for Everyone – Why Tectonic loves the cloud You don’t need to worry about tracking licenses. Read more

Read More
Google Sheets to Synchronize Salesforce Data

Google Sheets to Synchronize Salesforce Data

Synchronize Salesforce Data with Google Sheets: A Step-by-Step Guide This is Google Docs Editors complete explanation of using Google Sheets to Synchronize, add, and delete data to Salesforce. There are also instructions for doing this from an Android or IPhone here. To seamlessly import, edit, and sync Salesforce data with Google Sheets, follow these steps to set up and use the add-on. Step 1: Download the Add-on Step 2: Connect to Salesforce Importing Data Updating and Deleting Data Important: Exercise caution as changes made in Google Sheets can update or delete data in your Salesforce account. Updating Data: Refreshing Data: Deleting Data: Important: Exercise caution as this action will delete records from Salesforce. Visit the Salesforce Help Center to learn how to restore deleted data if needed. By following these steps, you can efficiently manage Salesforce data within Google Sheets, ensuring seamless synchronization and data management capabilities. Here are some tools that can synchronize Salesforce data with Google Sheets: Should you need assistance with any of these Google Sheet Salesforce solutions, contact Tectonic today. Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
Create Approval Process in Salesforce

Create Approval Process in Salesforce

Implementing a Salesforce Approval Process: Options and Considerations to Create Approval Process in Salesforce An approval process is necessary for: This insight explores top options for implementing a Salesforce approval process within your company. Option 1: Manual Email or Slack Notifications The classic approach involves emailing or using Slack to request approvals. It’s straightforward and free, making it accessible for teams handling fewer approval requests. Pros: Cons: Option 2: Google Sheets Integration Another method involves using Google Sheets to manage approvals. Sales reps and managers input deal details for approval and track status in a centralized document. Pros: Cons: The drawback of both methods is their manual nature and limited integration with Salesforce, which can hinder sales workflow efficiency and lead to approval delays. Option 3: Salesforce Approvals Salesforce provides a native approval functionality where users create processes (e.g., discount matrices) requiring multiple stakeholders to approve at designated levels. Pros: Cons: While Salesforce Approvals streamline the process compared to manual methods, they still rely on user actions for notifications and responses, lacking full automation. Choosing the Right Option Evaluate each method’s pros and cons to determine the best fit for your company’s needs. Consider: By establishing a dynamic approval process aligned with your business requirements, you can empower your sales team to focus more on client acquisition and less on administrative tasks. Choose wisely to optimize efficiency and decision-making within your organization. Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
gettectonic.com