We are looking for a Google Measurement protocol expert that has worked with complex offline transactions before.
In this case we are experiencing race conditions with adding offline transactions to cover transactions that hasn't been added automatically.
We have a current script for this but I'm experiencing double transactions on the same ID due to race conditions and the 4 hour limit (i think).
So I'm looking for options to have Google 99% vs the internal database we have. Our goal is to be as close as possible with a -+3% margin.
This is ASAP and you should have done similar things before, don't bother if you havent.
How it should look:
Screenshot from DB:
*Net revenue* = Actual amount: Jan 1 - Jan 22: 166 643 Clicks (same as transactions in Google analytics)
*Guessed Price* = The transaction in Google Analytics is not a REAL transaction per say. It's an estimate and could be a real booking months after the click, so therefor the earning is estimated to.
*Clicks *= Should be equivalent to Google Analytics transactions.
*Click ID* = Each click out from our site has their own unique click_id. Saved both server side in a local db and used as product_sku in google analytics.
Screenshot from GA:
MMP = The SKU item of the offline added product within the transaction.
ProductSKU with number = as you see Unique purchases should never be 2. At least the items should never be able to be double since it's a unique click.
Current fields used for the transaction sent to Measurement Protocol:
sub create_transaction {
my $market_id = shift;
my $click = shift;
my $t = { } ;
$t->{ qt} = $click->value('queue_time');
$t->{ ti} = $click->value('stat_click_id');
$t->{ cu} = $click->value('currency_code');
$t->{ ta} = $click->value('site');
$t->{ tr} = $click->value('guessed_price');
return $t;
}
sub create_item {
my $market_id = shift;
my $click = shift;
my $i = { } ;
$i->{ qt} = $click->value('queue_time');
$i->{ ti} = $click->value('stat_click_id');
$i->{ cu} = $click->value('currency_code');
$i->{ in} = $click->value('click_type');
$i->{ ip} = $click->value('guessed_price');
$i->{ iq} = 1;
$i->{ ic} = 'MMP';
$i->{ iv} = $click->value('section');
return $i;
}
About the recuiterMember since May 20, 2018 Ramaswamysunder
from Teleorman, Romania