Recherche avancée

Sur d’autres sites (13256)

• Anomalie #2182 : tables spip_trucs_liens dans les logs

  7 juillet 2016, par Guillaume Fahrner

  Le commit ne supprime qu’une seule ligne de log, il reste toujours ces lignes généré lors de l’accès à une page contenant une boucle recherche ( a chaque recherche) :

  2016-07-07 10:41:36 IP (pid 16419) :Pub : !INFO : trouver_table : table inconnue ’’ ’spip_articles_liens’
  2016-07-07 10:41:36 IP (pid 16419) :Pub:ERREUR : Erreur mysql 1146
  2016-07-07 10:41:36 IP (pid 16419) :Pub:ERREUR : Erreur mysql 1146

  venant pour la première de :

  ecrire/base/trouver_table.php:155 : spip_log("trouver_table : table inconnue ’$serveur’ ’$nom’", _LOG_INFO_IMPORTANTE) ;

  Est ce encore améliorable ?

• 7 Ecommerce Metrics to Track and Improve in 2024

  12 avril 2024, par Erin

  You can invest hours into market research, create the best ads you’ve ever seen and fine-tune your budgets. But the only way to really know if your digital marketing campaigns move the needle is to track ecommerce metrics.

  It’s time to put your hopes and gut feelings aside and focus on the data. Ecommerce metrics are key performance indicators that can tell you a lot about the performance of a single campaign, a traffic source or your entire marketing efforts. 

  That’s why it’s essential to understand what ecommerce metrics are, key metrics to track and how to improve them. 

  Ready to do all of the above ? Then, let’s get started.

  What are ecommerce metrics ? 

  An ecommerce metric is any metric that helps you understand the effectiveness of your digital marketing efforts and the extent to which users are taking a desired action. Most ecommerce metrics focus on conversions, which could be anything from making a purchase to subscribing to your email list.

  You need to track ecommerce metrics to understand how well your marketing efforts are working. They are essential to helping you run a cost-effective marketing campaign that delivers a return on investment. 

  For example, tracking ecommerce metrics will help you identify whether your digital marketing campaigns are generating a return on investment or whether they are actually losing money. They also help you identify your most effective campaigns and traffic sources. 

  Ecommerce metrics also help you spot opportunities for improvement both in terms of your marketing campaigns and your site’s UX. 

  For instance, you can use ecommerce metrics to track the impact on revenue of A/B tests on your marketing campaigns. Or you can use them to understand how users interact with your website and what, if anything, you can do to make it more engaging.

  What’s the difference between conversion rate and conversion value ?

  The difference between a conversion rate and a conversion value is that the former is a percentage while the latter is a monetary value. 

  There can be confusion between the terms conversion rate and conversion value. Since conversions are core metrics in ecommerce, it’s worth taking a minute to clarify. 

  Conversion rates measure the percentage of people who take a desired action on your website compared to the total number of visitors. If you have 100 visitors and one of them converts, then your conversion rate is 1%. 

  Here’s the formula for calculating your conversion rate :

  Conversion Rate (%) = (Number of conversions / Total number of visitors) × 100

  

  Using the example above :

  Conversion Rate = (1 / 100) × 100 = 1%

  Conversion value is a monetary amount you assign to each conversion. In some cases, this is the price of the product a user purchases. In other conversion events, such as signing up for a free trial, you may wish to assign a hypothetical conversion value. 

  To calculate a hypothetical conversion value, let’s consider that you have estimated the average revenue generated from a paying customer is $300. If the conversion rate from free trial to paying customer is 20%, then the hypothetical conversion value for each free trial signup would be $300 multiplied by 20%, which equals $60. This takes into account the number of free trial users who eventually become paying customers.

  So the formula for hypothetical conversion value looks like this :

  

  Hypothetical conversion value = (Average revenue per paying customer) × (Conversion rate)

  Using the values from our example :

  Hypothetical conversion value = $300 × 20% = $60

  The most important ecommerce metrics and how to track them

  There are dozens of ecommerce metrics you could track, but here are seven of the most important. 

  Conversion rate

  Conversion rate is the percentage of visitors who take a desired action. It is arguably one of the most important ecommerce metrics and a great top-level indicator of the success of your marketing efforts. 

  You can measure the conversion rate of anything, including newsletter signups, ebook downloads, and product purchases, using the following formula :

  

  Conversion rate = (Number of people who took action / Total number of visitors) × 100

  You usually won’t have to manually calculate your conversion rate, though. Almost every web analytics or ad platform will track the conversion rate automatically.

  Matomo, for instance, automatically tracks any conversion you set in the Goals report.

  

  As you can see in the screenshot, your site’s conversions are plotted over a period of time and the conversion rate is tracked below the graph. You can change the time period to see how your conversion rate fluctuates.

  If you want to go even further, track your new visitor conversion rate to see how engaging your site is to first-time visitors. 

  Try Matomo for Free

  Get the web insights you need, without compromising data accuracy.

  Start for free

  No credit card required

  Cost per acquisition

  Cost per acquisition (CPA) is the average cost of acquiring a new user. You can calculate your overall CPA or you can break CPA down by email campaign, traffic source, or any other criteria. 

  Calculate CPA by dividing your total marketing cost by the number of new users you acquire.

  

  CPA = Total marketing cost​ / Number of new users acquired 

  So if your Google Ads campaign costs €1,000 and you acquire 100 new users, your CPA is €10 (1000/100=10).

  It’s important to note that CPA is not the same as customer acquisition cost. Customer acquisition cost considers the number of paying customers. CPA looks at the number of users taking a certain action, like subscribing to a newsletter, making a purchase, or signing up for a free trial.

  Cost per acquisition is a direct measure of your marketing efforts’ effectiveness, especially when comparing CPA to average customer spend and return on ad spend. 

  If your CPA is higher than the average customer spend, your marketing campaign is profitable. If not, then you can look at ways to either increase customer spend or decrease your cost per acquisition.

  Customer lifetime value

  Customer lifetime value (CLV) is the average amount of money a customer will spend with your ecommerce brand over their lifetime. 

  Customer value is the total worth of a customer to your brand based on their purchasing behaviour. To calculate it, multiply the average purchase value by the average number of purchases. For instance, if the average purchase value is €50 and customers make 5 purchases on average, the customer value would be €250.

  Use this formula to calculate customer value :

  

  Customer value = Average purchase value × Average number of purchases

  Then you can calculate customer lifetime value using the following formula :

  

  CLV = Customer value × Average customer lifespan

  In another example, let’s say you have a software company and customers pay you €500 per year for an annual subscription. If the average customer lifespan is 5 years, then the Customer Lifetime Value (CLV) would be €2,500.

  Customer lifetime value = €500 × 5 = €2,500

  Knowing how much potential customers are likely to spend helps you set accurate marketing budgets and optimise the price of your products. 

  Return on investment

  Return on investment (ROI) is the amount of revenue your marketing efforts generate compared to total spend. 

  It’s usually calculated as a percentage using the following formula :

  

  ROI = (Revenue / Total spend) × 100

  If you spend €1,000 on a paid ad campaign and your efforts bring in €5,000, then your ROI is 500% (5,000/1,000 × 100).

  With a web analytics tool like Matomo, you can quickly see the revenue generated from each traffic source and you can drill down further to compare different social media channels, search engines, referral websites and campaigns to get more granular view. 

  

  In the example above in Matomo’s Marketing Attribution feature, we can see that social networks are generating the highest amount of revenue in the year. To calculate ROI, we would need to compare the amount of investment to each channel. 

  Let’s say we invested $1,000 per year in search engine optimisation and content marketing, the return on investment (ROI) stands at approximately 2576%, based on a revenue of $26,763.48 per year. 

  Conversely, for organic social media campaigns, where $5,000 was invested and revenue amounted to $71,180.22 per year, the ROI is approximately 1323%. 

  Despite differences in revenue generation, both channels exhibit significant returns on investment, with SEO and content marketing demonstrating a much higher ROI compared to organic social media campaigns. 

  With that in mind, we might want to consider shifting our marketing budget to focus more on search engine optimisation and content marketing as it’s a greater return on investment.

  Try Matomo for Free

  Get the web insights you need, without compromising data accuracy.

  Start for free

  No credit card required

  Return on ad spend

  Return on ad spend (ROAS) is similar to return on investment, but it measures the profitability of a specific ad or campaign.

  Calculate ROAS using the following formula :

  

  ROAS = Revenue / Ad cost 

  A positive ROAS means you are making money. If you generate €3 for every €1 you spend on advertising, for example, there’s no reason to turn off that campaign. If you only make €1 for every €2 you spend, however, then you need to shut down the campaign or optimise it. 

  Bounce rate

  Bounce rate is the percentage of visitors who leave your site without taking another action. Calculate it using the following formula :

  

  Bounce rate = (Number of visitors who bounce / Total number of visitors) × 100

  Some portion of users will always leave your site immediately, but you should aim to make your bounce rate as low as possible. After all, every customer that bounces is a missed opportunity that you may never get again. 

  You can check the bounce rate for each one of your site’s pages using Matomo’s page analytics report. Web analytics tools like Google Analytics can track bounce rates for online stores also. 

  

  Bounce rate is calculated automatically. You can sort the list of pages by bounce rate allowing you to prioritise your optimisation efforts. 

  Don’t stop there, though. Explore bounce rate further by comparing your mobile bounce rate vs. desktop bounce rate by segmenting your traffic. This will highlight whether your mobile site needs improving. 

  Try Matomo for Free

  Get the web insights you need, without compromising data accuracy.

  Start for free

  No credit card required

  Click-through rate

  Your clickthrough rate (CTR) tells you the number of people who click on your ads as a percentage of total impressions. You can calculate it by dividing the number of clicks your ad gets by the total number of times people see it. 

  So the formula looks like this :

  

  CTR (%) = (Number of clicks / Total impressions​) × 100

  If an ad gets 1,000 impressions and 10 people click on it, then the CTR will be 10/1,000 × 100 = 1%

  You don’t usually need to calculate your clickthrough rate manually, however. Most ad platforms like Google Ads will automatically calculate CTR.

  What is considered a good ecommerce sales conversion rate ?

  This question is so broad it’s almost impossible to answer. The thing is, sales conversion rates vary massively depending on the conversion event and the industry. A good conversion rate in one industry might be terrible in another. 

  That being said, research shows that the average website conversion rate across all industries is 2.35%. Of course, some websites convert much better than this. The same study found that the top 25% of websites across all industries have a conversion rate of 5.31% or higher. 

  How can you improve your conversion rate ?

  Ecommerce metrics don’t just let you track your campaign’s ROI, they help you identify ways to improve your campaign. 

  Use these five tips to start improving your marketing campaign’s conversion rates today :

  Run A/B tests

  The most effective way to improve almost all of the ecommerce metrics you track is to test, test, and test again.

  A/B testing or multivariate testing compares two different versions of the same content, such as a landing page or blog post. Seeing which version performs better can help you squeeze as many conversions as possible from your website and ad campaigns. But only if you test as many things as possible. This should include :

  • Ad placement
  • Ad copy
  • CTAs
  • Headlines
  • Straplines
  • Colours
  • Design

  To create and analyse tests and their results effectively, you’ll need either an A/B testing platform or a web analytics solution like Matomo, which offers one out of the box.

  

  Matomo’s A/B Testing feature makes it easy to create and track tests over time, breaking down each test’s variations by the metrics that matter. It automatically calculates statistical significance, too, meaning you can be sure you’re making a change for the better. 

  Try Matomo for Free

  Get the web insights you need, without compromising data accuracy.

• 2023-04-18 18:25:05 INFO discord.player ffmpeg process ##### successfully terminated with return code of 0

  19 avril 2023, par I_am_thing

  I am making a discord music bot with discord.py and ctx, it uses Spotify

  


  I am using FFmpeg for my music feature. This is my !play code

  


  client_id = ''
client_secret = ''
client_credentials_manager = SpotifyClientCredentials(client_id=client_id, client_secret=client_secret)
sp = spotipy.Spotify(client_credentials_manager=client_credentials_manager)

bot.volume = 0.5 # initial volume of the bot (can be changed)

@bot.command()
async def play(ctx, *, track_query):
    # check if the query is a valid Spotify link
    if 'open.spotify.com/track/' in track_query:
        track_id = track_query.split('/')[-1] # extract the track ID from the link
    else:
        # search for tracks with the given name
        track_results = sp.search(q=track_query, type='track', limit=1)
        if len(track_results['tracks']['items']) == 0:
            await ctx.send(f'Sorry, I could not find any track with the name "{track_query}".')
            return
        track_id = track_results['tracks']['items'][0]['id'] # get the track ID for the first search result
    track_info = sp.track(track_id) # get the track information for the given ID
    track_name = track_info['name']
    track_artist = track_info['artists'][0]['name']
    track_duration = time.strftime('%M:%S', time.gmtime(track_info['duration_ms']//1000))
    track_preview_url = track_info['preview_url'] # get the preview URL for the track
    if track_preview_url is None:
        await ctx.send(f'Sorry, the track "{track_name}" by {track_artist} cannot be played.')
        return
    voice_channel = ctx.author.voice.channel
    if voice_channel is None:
        await ctx.send('Please join a voice channel first.')
        return
    voice_client = await voice_channel.connect()
    audio_source = discord.FFmpegPCMAudio(track_preview_url, options="-b:a 128k -bufsize 512k")
    voice_client.play(audio_source, after=lambda e: print('Player error: %s' % e) if e else None)
    voice_client.source = discord.PCMVolumeTransformer(voice_client.source)
    voice_client.source.volume = bot.volume

    # format the embed message
    embed = discord.Embed(title=track_name, description=track_artist, color=0xff8c00)
    embed.add_field(name='Duration', value=track_duration, inline=True)
    embed.set_thumbnail(url=track_info['album']['images'][0]['url'])
    embed.set_footer(text='This music is from https://www.spotify.com/')
    await ctx.send(embed=embed)

    while voice_client.is_playing():
        await asyncio.sleep(1)
    await voice_client.disconnect()


  


  I joined the unofficial ffmpeg discord server no one could find a fix I searched for ages and I couldn't fix it